Skip to content

Created an interactive Sales Dashboard on AdventureWorks sales data and found some meaningful insights using Microsoft Power BI and Microsoft SQL Server Management Studio.

Notifications You must be signed in to change notification settings

pratyusha-garaye/Sales-Report-Using-Power-BI

Repository files navigation

Sales-Report-Using-Power-BI

  • I have created an interactive Power BI Sales Dashboard on AdventureWorks sales data track KPIs (sales, revenue, profit, returns), compare regional performance, analyze product-level trends, and identify high-value customers.
  • The query editing was done in 'Microsoft SQL Server Management Studio'.
  • In order to build the dashboard, the data was extracted, transformed and loaded as required, with the use of Power query. DAX were used for creating the calculated measures and calculated column.
  • On finishing the calculations, I visualized the data using cards, charts, slicer etc. which helped in easy understanding from the user's end.

Tools and Technology used-

1. Microsoft Power BI

2. MS Excel

Images of dashboard

Screenshot 2024-07-05 at 5 25 40 PM Screenshot 2024-07-05 at 5 25 57 PM Screenshot 2024-07-05 at 5 26 07 PM Screenshot 2024-07-05 at 5 26 16 PM Screenshot 2024-07-05 at 5 26 34 PM Screenshot 2024-07-05 at 5 26 41 PM Screenshot 2024-07-05 at 5 26 51 PM

About

Created an interactive Sales Dashboard on AdventureWorks sales data and found some meaningful insights using Microsoft Power BI and Microsoft SQL Server Management Studio.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published