Case Study: Ecommerce Analysis in Power BI

中级技能水平

更新时间 2024年6月

In ecommerce, increasing sales and reducing costs are key. Analyze data from an online pet supply company using Power BI.

课程描述

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.

先决条件

DAX Functions in Power BI Data Visualization in Power BI

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.

课程描述

Use Your Power BI Skills to Solve Real-World Problems

Analyze The Data and Visualize Your Findings

获得成就证明

加入超过.css-nklxlk{color:var(--wf-brand--main, #03EF62);}19百万学习者，今天就开始Case Study: Ecommerce Analysis in Power BI！

创建您的免费帐户

通过 DataCamp for Mobile 提升您的数据技能

加入超过19百万学习者，今天就开始Case Study: Ecommerce Analysis in Power BI！