Live Challenge closes on the 23rd of April 2025 at 23:59pm UK time

Inventory Management Analysis

Welcome to the Inventory Management Challenge! Efficient inventory management is crucial for balancing supply and demand while minimizing costs. This challenge explores key aspects such as stock levels, supplier performance, warehouse utilization, and reorder strategies. By analysing this dataset, you will identify trends, optimize restocking, and assess cost efficiency. Your goal is to uncover actionable insights that enhance inventory operations and decision-making. Use statistical techniques, visualization tools and storytelling to support your findings. Can you optimize inventory performance and improve supply chain efficiency? Let’s dive in and explore the data!

About

FP20 Analytics & Zoomcharts

The FP20 Analytics Challenge 25 is brought to you in collaboration with ZoomCharts. Thanks to this partnership, we're integrating ZoomCharts' exceptional Power BI solutions into this competition. You will gain skills to create Pro reports that help business users explore data faster and more intuitively.

Participating with Zoomcharts

To participate in the challenge with ZoomCharts, register here and create a Power BI report including at least 2 ZoomCharts Drill Down Visuals on one report page.

Why participate in the ZoomCharts Challenge?

Participate in the ZoomCharts Challenge to showcase skills, gain recognition, network, and boost your professional profile.

01

Personalized Feedback ️

The ZoomCharts team provides personalized feedback to EVERY report entry that meets the requirements. This gives all participants the chance to hone their skills and adjust their report before deadline, giving you an extra competitive edge in the challenge.

02

Receive a Free License

Upon signing up for the challenge, you will receive a FREE Drill Down Visuals Developers License that lets you access the full Drill Down Visuals PRO library. This license remains active for a year after the last challenge you take part in. Meaning, you can access the latest advanced data visualization tools to enhance your projects for a full year.

03

Learning Resources

Participants receive all the latest information on upcoming workshops and events, demonstrating how our team of proven professionals approaches visualizing the given dataset for the challenge. You also have the chance to book 1:1 calls with a Power BI mentor who will analyse and give specific suggestions to improve your report.

04

The Main Prize

Last but not least, entering the challenge with ZoomCharts puts you in the running for an additional $300 Amazon gift card.

Challenge Introduction

Below is your show time. Read me carefully!

Start Date

Wednesday 26th of March 2025

Start Time

15:00 pm UK time

Submission Deadline

Wednesday 23rd of April 2025

End Time

23:59 pm UK time

Below is your important reading!

Data Analysis Tools

All tools are permitted.

Zoomcharts entries

Create a Power BI report including at least two ZoomCharts Drill Down Visuals in one report page!.

Acces to the LinkedIn group

Join the Group

Your Portfolio with novyPro

Join novyPro

Tab Content

This is a basic text element.

A few questions to help you with your analysis

From an industry-wide perspective, inefficiencies in inventory management contribute to supply chain imbalances, increased carrying costs, and lost sales opportunities. Whether in retail, manufacturing, or distribution, poor inventory visibility and inaccurate demand forecasting can lead to stockouts, overstock situations, and elevated warehousing costs, all of which hinder operational agility and financial performance. The ripple effects are felt across procurement, production planning, and customer fulfillment processes, especially in sectors relying on lean inventory models.

Understanding the key factors contributing to inventory challenges—ranging from data silos, demand variability, and supplier reliability issues to inadequate inventory tracking, storage constraints, and workforce limitations—is critical for implementing effective control mechanisms. By leveraging advanced analytics, inventory optimization algorithms, and real-time monitoring tools, organizations can improve forecast accuracy, reduce excess stock, and ensure product availability. This strategic approach enhances supply chain resilience, improves service levels, and drives cost-efficiency across operations.

A. Stock Analysis & Inventory Levels.

1. Which product category has the highest total stock quantity across all products?

2. How many products currently have stock quantities below their reorder point?

3. What minimum order quantity is required if a company needs to restock all products below the reorder point?

B. Supplier & Restocking Performance.

4. Which supplier has the highest average lead time for restocking?

5. What is the average time since the last restock for products marked as "Out of Stock"?

6. Identify the months when the highest number of products were restocked—are there any seasonal trends?

C. Cost & Pricing Analysis.

7. Identify the top 5 most expensive products (by unit price) and their categories.

8. Which product category has the fastest turnover based on stock quantity and lead time?

D. Warehouse & Geographic Insights.

9. Which warehouse location has the highest number of products stored?

10. Which country has the most stocked items and which top3 counties have the highest stocked quantities by different product categories?

Special requirements and judging criteria for
Zoomcharts participants

Know more about the judging criteria and other requirements

How easy is it to understand the data? (max 10 points)

1. Is too much text used for explanation?
2. Are the indicative colors in charts understandable?
3. Does it tell a story?

How easy-to-use is the report? (max 14 points)

1. Cross-chart filtering implementation

2. across the report. Can other visuals provide relevant data as the user explores the rep

3. Response time

4. Drill Down: multi-layer data exploration. Can the user drill down and gain additional insights within the report?

5. Use of tutorial overlays and other elements to assist new users. Can a new user start using this report straight away with just the guidance provided within the report itself?

How good is the report design and is it suitable for its purpose? (max 10 points)

1. Visual design: is the overall look consistent, no empty spaces, no overcrowding?

2. Interface design: are there unnecessary visualisations, buttons, complexity in use?

3. UX design: is the produced report usable?

4. Report design: is the main challenge answered?

5. Technical: are all the fonts used the same, are the sizes readable?

Technical Requirements

All tools are permitted for the challenge.

For the ZoomCharts Challenge, create a Power BI report that includes at least 2 ZoomCharts Drill Down Visuals on one report page.

Reports are restricted to a maximum of three pages, including drill-through pages.

Canvas size is 16:9 (Default Power BI size) or Full HD size = w:1920 - h:1080.

ZoomCharts participants judging criteria

Business users use reports to make data-driven decisions. Reports are effective if they enable users to drill down and filter data quickly and intuitively to find answers to any question they might have and analyse data in all possible directions and dimensions.

Zoomcharts Resources.

1. Use-Case Gallery: Try live demos and download reports made by the ZoomCharts team

2. Video tutorials: Watch engaging video guides on how to set up and use the visuals

3. Documentation: Technical deep-dive about ZoomCharts visuals

4. ZoomCharts Blog: Useful tips & tricks for data visualization and report creation

5. Visuals Gallery: Explore all the possible customization options for Drill Down Visuals.

The Resources

1. An Excel spreadsheet with two tabs.
2. PDF with the Intro and Brief in English.
3.PDF with the Intro and Brief in Spanish.

Submissions of Entries

To submit your three-page report, please follow these steps, if you want to be considered for the Zoomcharts' prize, otherwise post your entry in the challenges group.

Your report must be verified to ensure it meets all the technical requirements. If the report is validated, you will receive a 'Publish to Web' link. If it does not meet the criteria, you will receive a rejection reason and will have the opportunity to resubmit your report.

Posting your submission on LinkedIn

1. Upload the report as a PDF document on your LinkedIn feed.

2. Use the caption "I am participating in FP20 Analytics Challenge 25” and screenshots from your report.

3. Include a summary of your report's key insights and publish it on the web or via a NovyPro link.

4. Use the hashtags
#FP20Analytics, #FP20InventoryManagementAnalysis, #builtwithzoomcharts,
tag @Federico Pastor and @Zoomcharts.

5. *Additionally, post your report in the FP20 Analytics LinkedIn Community Group.

Resources and the datasets

Click on the link below to get your dataset: The files contain all the necessary data and information to create your report.