Data Analysis Challenge: Optimizing Inventory Management
Published Jan 24 2023 12:00 AM 11.3K Views

DA Scenario 3.png


Quick Question

How Good are you with answering business questions using Microsoft Power BI? You don't have to rate yourself on any scale, I have a challenge for you.


Consider the use case described below and the accompanying data, carry out a detailed analysis using Microsoft Power BI. This is the only way to convince me how good you are at answering business questions.



Use Case Description


use case description.png


The goal of this project is to optimize inventory management for the FitCapacity company by analyzing sales and inventory data. Using the business database, you are to analyze sales data to identify which products have the highest turnover rate and which have the lowest turnover rate. You should also use descriptive statistics to identify the average time a product is out of stock and the frequency of stockouts.


For example, you are to use predictive modeling to forecast the demand for major products and predict when stockouts are likely to occur. Utilize machine learning models, classify products into high-selling, low-selling and average-selling. This will aid in making decisions of which products to remain in the inventory. Once the analysis is complete, use the insights gained to make recommendations for how to optimize inventory levels and minimize stockouts. This may include adjustments to reorder points, ordering certain products, or discontinuing products that are not selling well.


You are required to work with this data and provide solutions to the business problem.



Challenge Dataset


Tech Blog Ads (3).png


You are to use the Adventureworks Dataset 2019 OLTP version for this challenge. More details about adventureworks database can be found in the attached file to this blog post (see at the end of the blog).


To learn how to setup adventureworks database on your PC, watch this video





Project Documentation





Intro to GitHub

Watch this Intro session to get familiarized with GitHub for beginners




Document Your Project

Watch this video to guide you  step-by-step on documenting your project





Let's Spotlight Your Project


Cloud Skill Challenge (1).png


Kindly submit the link to your project repository by clicking here or click on the image above.



We have an upcoming series to help you get the best from this effort. We will show you how you can properly document and showcase your project using GitHub. Kindly find the sessions details below:


Session Image Topic RSVP
theoyinbooke_0-1675207794694.jpeg GitHub for Data Analysts and Power Platform Developers Intro 
theoyinbooke_1-1675207795244.jpeg Documenting Data Analysis Projects on GitHub 
theoyinbooke_2-1675207794697.jpeg Documenting Power Platform Projects on GitHub 


More Challenge

You can complete our dedicated Cloud Skills Challenge



Connect with Others


Connect with others.png


You are not alone working on this project. use the hashtag #GitHub4Me while sharing on twitter and LinkedIn for your content to become more discoverable. Use it while posting your questions, use it while answering other people's questions.



Earn Badges and Trophies


Cloud Skill Challenge.png


Earn Badges and trophies from Microsoft when you complete a module and learning path respectively. This is another way to show a recruiter, your potential employer, or your current employer of your commitment to continuous learning.


Click here to participate in the cloud skill challenge. You can as well click on the image above



Amazing FREE Offer for Student: GitHub Student Pack


Cloud Skill Challenge.png


The GitHub Student Pack is FREE for verifiable STUDENTS and help you learn using real-world development tools. You get to use GitHub Pro while you are a student, enjoy amazing valuable offers from GitHub Partners, etc...

Click here or on the image above to claim this offer.



Project Submission

You will be wondering how you get to submit your project. For now, you should share your work by taking screenshot and using the hashtag #GitHub4Me while posting on Twitter and LinkedIn. We have an upcoming Live session to guide you on how to properly showcase and document your work on GitHub.


Details of the session below


Session Image Topic RSVP
theoyinbooke_3-1675207837714.jpeg GitHub for Data Analysts and Power Platform Developers Intro 
theoyinbooke_4-1675207837725.jpeg Documenting Data Analysis Projects on GitHub 
theoyinbooke_5-1675207837726.jpeg Documenting Power Platform Projects on GitHub 


Once we are done with the sessions, you will be able to go through the process and make your project portfolio worthy by documenting it on GitHub.


We will also provide the Link for you to submit your documented project. Since we want you to get the best from this effort, the most missing part is how you communicate your final work through documentation, this is where you will shine brighter this time. 


We are excited for you already and can't wait to see what you get to do at the end. Kindly check back this blog for details about the forthcoming Live sessions.




Additional Resources

Microsoft Student Hub -   

FREE Advance Certifications for Nigerians -

FREE Learning Resources to Help You Kickstart Your Tech Journey - Begin Now!

FREE Certification for Students Around the Globe - Learn More

FREE Certification for Students in the UK - Learn More Here

Setup M365 Developer Account - 





1 Comment
Version history
Last update:
‎Mar 15 2023 09:48 AM
Updated by: