Case Study: Ecommerce Analysis in Power BI

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

In this Power BI case study, you’ll explore a real-world ecommerce business dataset to uncover insights for an online pet supply company called Whiskique. Using what you’ve learned from previous courses; you’ll use Power Query to investigate and clean the data to find out how the company’s sales are performing and where their customers are located. You’ll then use DAX to build insightful visualizations of your findings. Finally, you’ll bring it all together using everything Power BI has to offer to create dashboard-style pages so that you can answer questions for the Whiskique executive team.

• 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.
  
• 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.
• 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.