Sales Analysis With Microsoft Power BI
This report is a summary of the sales data analysis I performed with Microsoft Power BI with focus on identified business problems and insights gotten from the data.
The dataset used in this analysis was downloaded from Enterprise DNA when I took their ultimate beginner’s guide to DAX (highly recommended). The dataset was pre-cleaned so did not perform much data cleaning. I did the basic checking of the columns and its data type to ensure they are correct and checked for null values as well. I then proceeded to view the data model and inspected the automatic relationships created by Power BI and I was okay with it.
I then created a date table using CALENDERAUTO() (DAX formular). This creates a date column from the start date in the dataset to the end date in the dataset. I then created Year, Month, Quarter, Month number columns accordingly using DAX and ensured I sorted the “month column” using “month number”. Then I marked it as my preferred date table. Went back to data model and linked it up with the fact table. At this point, I was ready for visualization.
For this analysis, the following questions were asked:
- Who are the top 5 customers?
- What are the top 5 products ?
- What are the top 5 counties?
- What is the trend in cumulative sales compared to previous year?
- What kind of relationship exist between total cost and total sales?
- What is the trend of total sales compared to sales last year?
- What is the trend of total profits compared to total profits last year?
To answer these business questions,I created some measures using DAX to aid my analysis and also included some card visuals for a general overview of the sales, profits, transactions and customers. The dashboard was further made interractive by adding year and quarter slicers for further insights. The full dashboard is shown below.
The following insights were deduced from the static dashboard shown above:
- The top five customers are Martin Berry, William Andrews, Craig Wright, Wayne Johnson and Christopher Write.
- The best selling products are product 63, 28, 47, 59 and 29
- The top counties by sales are Broward, Suffork, New Haven, Middlesex, and Fairfield
- There is a steady increase in cumulative sales as against the previous year
- There is a positive linear relationship between total costs and total sales. That is, an increase in total cost leads to an increase in total sales.
- The six months sales data available so far for current year shows that they are above average whereas for previous year, the monthly sales were below average except in September.
- The monthly profits made so far for the current year were all above average except for April whereas for last year, the profits were below average except in July, September and December.
The current year data stopped at June so it was not enough to make full comparison with previous year.
Let’s connect on LinkedIn.