Skip to main content

Case Study: Competitor Sales Analysis in Power BI

This Power BI case study follows a real-world business use case where you will apply the concepts of ETL and visualization.

Start Course for Free
3 Hours4 Videos21 Exercises1750 XP

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies


Course Description

This Power BI case study follows a real-world business use case where you will apply the concepts of ETL and visualization. Through Power BI and Power Query Editor, you will work on the development of a complete Power BI report starting from the data integration from multiple sources, data transformation, modeling, and then visualization. You will carry out a sales and market share analysis, focusing not only on the company's performance internally, reflecting on how well the products sell, but also externally analyzing how well they are doing against competing manufacturers. Thus, business users can make informed decisions and actions on their data. By the end of this case study, you’ll have a stronger understanding of competitor sales analysis and have more confidence in using Power BI on your own datasets.
  1. 1

    Preparing your Data and Model

    Free

    In the first chapter, you will start by exploring and integrating the dataset into Power BI and understand the challenges faced with the uncleaned data. Then, using Power Query Editor operations, you will clean and mash up the data so you can use it for reporting.

    Play Chapter Now
    Competitor Sales Analysis in Power BI
    50 xp
    Data transformation best practices
    50 xp
    Data integration
    100 xp
    Data transformation operations
    100 xp
    Append queries
    100 xp
    Data model performance optimization
    100 xp
    Setting up relationships
    100 xp
  2. 2

    Discovering Sales Trends

    In this chapter, after loading the cleaned data in Power BI, you will continue building a common data model, analyze the manufacturer's product growth, and compare your manufacturer against the competitors across multiple geographies.

    Play Chapter Now
  3. 3

    Creating a Data-Driven Story

    In this last chapter, you will make your Power BI report more dynamic and interactive using images and adding navigations. You will also use advanced features and visuals to present the data in the form of a story which end users can use to make informed decisions.

    Play Chapter Now

Datasets

Exercises and Datasets

Collaborators

maartenvdbroeck
Maarten Van den Broeck
carlrosseel-73112126-9ed2-4866-942a-96fbf265b088
Carl Rosseel
jessahmet-d9c6d363-de9d-4cf2-998f-d86306ff5807
Jess Ahmet
Deepesh Vashistha Headshot

Deepesh Vashistha

Deepesh is a Microsoft Certified Data Architect proficient in Power BI, MS-BI stack, and Azure technologies. Over the years, he has worked on many BI and data warehousing projects and is passionate about providing training to companies and working professionals. Outside of his work, he likes to go for bike rides and enjoys PC gaming.
See More

What do other learners have to say?

Join over 10 million learners and start Case Study: Competitor Sales Analysis in Power BI today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.