Sales Analysis Report in Power BI

Dashboard

Overview:

• I got the dataset from one of the data challenges hosted on LinkedIn which is regarding "Sales Analytics".
• The dataset includes details about Product-wise analysis, Geographic analysis and Time Wise analysis.

Key questions with respect to the dataset:

Tools Used: MS Excel, Figma, MS Power BI

Steps in the Analysis:

• With respect to the given dataset, I prepared data in MS Excel and added extra columns which are Order Time, City and Sales using "Flash command" and "Sales" which is a multiplication of "Quantity Ordered" and "Price Each".
• After understanding the data, I used 3 KPIs on which I analysed the dataset which were: Product-Wise Analysis, Geographic Analysis and Time-Wise Analysis

Visualization:

• At first, I used Figma to create the layout for report.
• Then, I used Power BI for creating report or dashboard.

Key Insights from the report:

• 2019 is the best year for sales and sales in that year is 34 million.
• San Francisco has the highest number of sales overall among all cities.
• Between 11:00 a.m. and 1 p.m. & between 6 p.m. and 7 p.m. most number of products were ordered.
• MacBook Pro Laptop is sold the most among all products
• December month has the highest amount of sales which is around 11.3% of the total sales.

Conclusion:

Overall, it was a good dataset to analyze and gave a good practice over storytelling and visualization.