Competition - Supply Chain Analytics

Supply Chain Analytics in Tableau or Power BI

📖 Background

Test your BI skills on a real-world dataset focusing on supply chain analytics. As the main data analyst for Just In Time, you will help solve key shipment and inventory management challenges, analyze supply chain inefficiencies, and create insightful dashboards to inform business stakeholders about potential problems and propose structural business improvements.

Be creative and make use of your full skillset! Use this Workspace to prepare your data, import the tables into your local Tableau or Power BI instance, and share your insights below.

The end goal will be a (set of) interactive dashboards that demonstrate clear insights for Just In Time.

💪 Challenge

Using either Tableau or Power BI, create an interactive dashboard to summarize your research. Things to consider:

Use this Workspace to prepare your data (optional).
Some ideas to get you started: visualize how shipments are delayed, by country, product, and over time. Analyze products by their supply versus demand ratio. Rank products by over or understock. Don't feel limited by these, you're encouraged to use your skills to consolidate as much information as possible.
Create a screenshot of your (main) Tableau or Power BI dashboard, and paste that into the designated field.
Summarize your findings in an executive summary.

import pandas as pd
data = pd.read_csv("data/orders_and_shipments.csv")
data

✅ Checklist before publishing

If you use Tableau, don't forget to publish your Tableau dashboard, make it available on Tableau Public and share the link.
If you use Power BI, upload your .pbix file to this Workspace through the sidebar on the left (under Files).
Remove redundant text cells like the background, data, challenge, and checklist. You can add cells if necessary.

✍️ Judging criteria

CATEGORY	WEIGHTING	DETAILS
Visualizations	35%	Appropriateness of visualizations used. Clarity of insight from visualizations.
Insights	25%	Clarity of insights - how clear and well presented the insights are. Quality of recommendations - are appropriate analytical techniques used & are the conclusions valid? Number of relevant insights found for the target audience.
Storytelling	25%	How well the data and insights are connected to tell a story. How the narrative and whole report connects together. How balanced the report is: in-depth enough but also concise.
Votes	15%	Up voting - most upvoted entries get the most points.

🧾 Executive summary

In a couple of lines, write your main findings here.

📷 Dashboard screenshot

Paste one screenshot of your Tableau or Power BI dashboard here.

🌐 Upload your dashboard

For Tableau: paste the link to your Tableau Public dashboard here.

For Power BI: upload your .pbix file to Files in the sidebar on the left.