Microsoft AdventureWorks Database analysis using MS SQL Server and visualization of this analysis with PowerBi
This repo created to analyze AdventureWorks Database sales and to visualize the analysis.
- Total Sales Amount
- Total Order Quantity
- Average Money Spent on an Order
- Total Sales in the Second Quarter of Each Year
- Sales Performance by Year
- Total Order Amount of Categories by Year
- Total Sales for Each Product Category
- Total Sales Amount of Sub-Categories of Bike Category (Best sales performance in categories)
- Card (KPIs: 1,2,3)
- Clustered Bar Chart (KPI: 4)
- Area Chart (KPI: 5)
- Clustered Column Chart (KPI: 6)
- Table Chart (KPI: 7)
- Donut Chart (KPI: 8)
- Microsoft SQL Server Management Studio (SSMS)
- Microsoft PowerBi
Clone the repo
$ git clone https://github.com/miraytopal/AdventureWorks-DB-SQL-Queries-and-PowerBi
-
Install AdventureWorks database on SQL Server
-
Install SQL queries on SQL Server
-
Run PowerBi file
- DATEPART Function: https://learn.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-ver16
- CONVERT Function: https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16
- Wildcard: https://learn.microsoft.com/en-us/sql/t-sql/language-elements/wildcard-character-s-to-match-transact-sql?view=sql-server-ver16