Competitor Sales Analysis in Power BI

Case Study: Competitor Sales Analysis in Power BI

Deepesh Vashistha

Data Architect at Accenture

What is a case study?

  • Apply Power BI skills
  • Combine previously learned concepts
  • Solve an example real-world problem

Prerequisite courses:

  • DAX functions in Power BI
  • Report Design in Power BI
  • Data Modeling in Power BI

Power BI case study to solve real-world problems

Case Study: Competitor Sales Analysis in Power BI

End user needs

The BI needs of an end user comprising of all the reporting aspects

Case Study: Competitor Sales Analysis in Power BI

End user needs

Data Access

Case Study: Competitor Sales Analysis in Power BI

End user needs

Data cleaning

Case Study: Competitor Sales Analysis in Power BI

End user needs

Combine the data

Case Study: Competitor Sales Analysis in Power BI

End user needs

Data exploration

Case Study: Competitor Sales Analysis in Power BI

End user needs

Data visualization

Case Study: Competitor Sales Analysis in Power BI

Case study scenario

  • Analyze manufacturers' sales internally
  • Comparing sales against other competitors
  • Comparing product performance against other competitors

Competitor Sales Analysis Report screenshot

Case Study: Competitor Sales Analysis in Power BI

The dataset: Fact table

Column name Description
ProductID A unique id to identify product name
Date Sales transaction date
Zip Zip code of the city the transaction happened
Revenue Total revenue generated on a specific transition
Case Study: Competitor Sales Analysis in Power BI

The dataset: Dimension tables

Geography:

  • Comprises of the geography information with city, state, and zip code details

Product

  • Comprises of Products data in a named table.

Manufacturer

  • Comprises of manufacturers' information along with their logo images.

Date

  • Will be created by DAX calculation during the exercise.
Case Study: Competitor Sales Analysis in Power BI

The dataset: Snowflake schema

A snowflake schema based data model with one fact table and multiple dimension tables.

Case Study: Competitor Sales Analysis in Power BI

Let's practice!

Case Study: Competitor Sales Analysis in Power BI

Preparing Video For Download...