9 Power BI Projects To Develop Your Skills

Power BI Case Studies for Intermediate Learners

In this section, we’ve included various case studies to start you on your journey of managing an end-to-end dashboard development and analysis process. These intermediate projects will further push the realms of detailed industry knowledge and Power BI skills.

Inventory Analysis

In this Inventory Analysis in Power BI case study, you’ll put your skills to the test with a real-world challenge based on a fictional retailer WarmeHands Inc. The primary goal of this case study is to identify potential improvements in inventory management and purchasing strategies. You’ll investigate inventory turnover and ABC analysis, then identify which products should be prioritized.

In this project, you will:

• Prepare your data ready for analysis using Power Query
• Write intermediate DAX functions for data manipulation

Here is an example of a page you might create whilst taking this case study.

Supply Chain Analytics

In this Supply Chain Analytics in Power BI case study, you’ll be acting as a Supply Chain Analyst for a fictitious company called Tenate Industries that focuses on replacement parts for industrial pizza ovens. The primary goal of this case study is to develop a make versus buy analysis tool in Power BI. You’ll develop a quote analysis tool and cost scenario analysis based on production volumes and integrate cost data for a more detailed analysis.

In this project, you will:

• Write intermediate DAX functions for data analysis
• Create dynamic scenario analysis using slicers
• Apply row-level security
• Build a Make vs Buy report page

Above is an example of a page you might create on this Power BI project.

Analyzing Healthcare Data

In this Analyzing Healthcare Data in Power BI case study, you’ll be acting as a consultant for a fictional consulting company called HealthStat but exploring a real-world dataset. The primary goal of this case study is to uncover hospital efficiency insights and make recommendations for change. You’ll conduct an initial exploratory analysis before diving deeper into hospital performance outliers and understanding the factors most influence length of stay and cost per patient discharge.

In this project, you will:

• Load data and create a data model
• Write DAX functions for data analysis
• Utilize advanced visualizations such as Key Influencers
• Develop a 3-page branded report to share with stakeholders

On this Power BI project, you might create a final deliverable like the one shown above.

Competitor Sales Analysis

In this Competitor Sales Analysis in Power BI case study, you’ll work on real-world business use cases for a fictional manufacturing company called Sintec. The primary goal of this case study is to help Sintic assess company product performance compared to competitors. You’ll focus on sales and market share analysis for internal performance, focusing on product revenue.

In this case study, you will:

• Utilize PowerQuery to clean and transform the data
• Write DAX functions to compare performance
• Utilize AI visualizations
• Develop a branded report to share with stakeholders

Here is an example of a page you might create whilst taking this case study.

Mortgage Trading Analysis

In this Mortgage Trading Analysis in Power BI case study, you’ll be acting as a newly hired junior trader on a trading desk at a Mortgage Originator. This fast-paced and challenging case study will enable you to learn the ins and outs of the financial system. The primary goal of this case study will be to identify a population of mortgages to trade and evaluate each mortgage and bid received from prospective buyers before finally deciding to execute a trade.

In this case study, you will:

• Write advanced DAX calculations to analyze mortgage data
• Utilize advanced visualizations such as Key Influencers
• Carry out detailed analysis with multiple visualizations

Here is an example of a page you might create whilst taking this intermediate Power BI project.

E-commerce Analysis

In the e-commerce analysis case study, you’ll explore a real-world e-commerce business dataset to uncover insights for an online pet supply company called Whiskique. Specifically, in this case study, you will:

• Use Power Query to investigate and clean the data to determine how the company’s sales are performing and where their customers are.
• Use DAX to build insightful visualizations of your findings.
• Bring it all together using everything Power BI offers to create dashboard-style pages so you can answer questions for the Whiskique executive team.

Comparison Table: Power BI Projects

Conclusion

After learning the essentials, these case studies give you the foundation to build a strong portfolio to help showcase your skills.

In this post, we have learned about beginner and intermediate projects covering data modeling, data transformation to visualization, and storytelling.

So, what’s next? Now that you’ve followed a guided approach to projects - try experimenting with more complex datasets and see what insights you can derive! If you’d like to test your Power BI skills further, keep an eye out for Power BI-related competitions. To gain some inspiration, you can also check out our article, Top 9 Power BI Dashboard Examples.