Skip to main content
HomeBusiness Intelligence

Course

Case Study: Ecommerce Analysis in Power BI

IntermediateSkill Level
4.8+
190 reviews
Updated 06/2024
In ecommerce, increasing sales and reducing costs are key. Analyze data from an online pet supply company using Power BI.
Start Course for Free
Power BIData Visualization4 hr4 videos23 Exercises2,100 XP3,388Statement of Accomplishment

Create Your Free Account

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

Group

Training 2 or more people?

Try DataCamp for Business

Course Description

For ecommerce businesses, increasing sales and reducing expenses are top priorities. In this Power BI case study, you'll investigate a dataset from a fictitious online pet supply company called Whiskique.

Use Your Power BI Skills to Solve Real-World Problems

First, you’ll analyze the sales dataset to inform the company of who their customers are and what purchases they make. You will then use market basket analysis to help identify which products are frequently bought together.

Next, you’ll need to address the fact that shipping costs remain a big expense for online retailers. You’ll work on strategies such as shipping more of the same product to reduce per-unit costs.

Analyze The Data and Visualize Your Findings

As you collate your findings, you’ll create new measures and various visualizations in Power BI, such as combination graphs, treemaps, and maps. Finally, you'll use filters and parameters to make your graphs dynamic and create dashboard-style pages to share your insights.

Prerequisites

DAX Functions in Power BIData Visualization in Power BI
1

Data Exploration

In this first chapter, you’ll build a data model for sales and expense analysis. You’ll combine multiple files, filter out invalid data, and create metrics for customers and orders. You will utilize Power Query to help determine products that are frequently purchased together.
Start Chapter
2

Ecommerce Analytics

Next, you’ll create metrics for the most profitable products and customers. You’ll build a map of sales by state, before exploring the shipping cost metrics. Finally, you’ll build a what-if analysis to display the impact of shipping higher quantities on shipping costs.
Start Chapter
3

Visualize Your Analysis

In the final chapter, you’ll build multiple dashboard-style pages, in order to create a data story for your audience. You’ll display the product and customer KPIs and visuals. To round off, you’ll recommend specific actions to reduce shipping expenses.
Start Chapter
Case Study: Ecommerce Analysis in Power BI
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8
from 190 reviews
87%
12%
0%
0%
1%
  • Kyle
    10 hours ago

  • Napaporn
    2 days ago

  • Anthony
    2 days ago

  • Eli
    5 days ago

  • Lien Phuong
    last week

  • Graham
    last week

    good

Kyle

Napaporn

Anthony

FAQs

What prior Power BI experience do I need before taking this ecommerce case study?

You should have completed courses on DAX functions, data modeling, and data visualization in Power BI. This is an intermediate course that builds on foundational Power BI skills.

What kind of business dataset does this course use?

You work with data from a fictional online pet supply company called Whiskique, analyzing sales performance, customer locations, shipping costs, and product profitability.

Will I build interactive dashboards in this course?

Yes. The final chapter focuses on building dashboard-style report pages that present product and customer KPIs and tell a data story for an executive audience.

Does this course cover both Power Query and DAX?

Yes. You use Power Query to investigate and clean the data in early chapters, then apply DAX to create calculated metrics and insightful visualizations throughout.

How is the what-if analysis used in this course?

You build a what-if analysis to model the impact of shipping higher quantities on shipping costs, helping the Whiskique team explore cost reduction strategies.

    Join over 19 million learners and start Case Study: Ecommerce Analysis in Power BI today!

    Create Your Free Account

    or

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

    Grow your data skills with DataCamp for Mobile

    Make progress on the go with our mobile courses and daily 5-minute coding challenges.