Welcome to the FP20 Analytics September 2024 Challenge!

Webinars

Learn more about ZoomCharts visuals & gain a knowledge advantage in the contest by joining the upcoming webinars! You'll also get the chance to your ask questions and get expert answers in the Q&A section.

Upcoming webinars

Track E-Commerce Growth Metrics with Power BI

17th September, 2024

11:00 AM - EDT

Online Workshop on E-Commerce KPI Analysis for the FP20 Analytics & ZoomCharts Challenge 19

Learn more

Expert Feedback on Top 5 E-Commerce KPI Reports

3rd October, 2024

11:00 AM - EDT

Best FP20 Analytics ZoomCharts Challenge 19 submissions + the winner announcement

Learn more

How to participate? 

1. Register for the challenge: 

• Download the Challenge dataset either on this Challenge page or from FP20 Analytics website. 
• Register for the FP20 Analytics ZoomCharts Challenge. 
• Activate your free Drill Down Visuals Developer License for Power BI. Read license setup instructions.
• Read the challenge brief (see "The Brief" section) for additional info about the dataset and to see what questions your report should answer.  

2. Build your report in Power BI: 

• Set up an account in Power BI using the assigned license details (if you have participated in ZoomCharts Challenges in the past, you can use the same account you set up before).
• Use the account to access the full library of custom ZoomCharts Drill Down visuals. 
• Use the dataset to build a Power BI report including at least 2 ZoomCharts Drill Down Visuals in one report page. 
• The number of pages in the report is limited to 3 pages, including drill-through pages. 

3. Improve your report and learn new skills: 

• To learn more about applying ZoomCharts visuals in your reports, participate in the challenge workshop. 
• If you have any questions or need advice, you can book a free individual consultation. 
• Check out the submissions from past challenges for inspiration. 

4. Submit your challenge entry: 

• Submit your report in .pbix format for validation. 
• If your submission doesn’t match the challenge criteria, you will be notified by email indicating the reason. Don't worry if this happens! You can fix the issue and resubmit your report. 
• Together with validation confirmation, you will receive a publish to web link that you can use to add the report to your portfolio or publicly share online. 
• All validated entries will receive personalized feedback from the evaluation team. You can use this feedback to revise your report and resubmit it before the deadline. Feel free to resubmit your entry as many times as necessary before the deadline. 

5. Finalize your participation to compete for the ZoomCharts grand prize: 

• (Optional) Upload your publish to web link on NovyPro.  If you opt to post your report on NovyPro, for instructions on how to do this, refer to the video link provided. NovyPro: https://www.novypro.com/  
  Instruction Video: https://www.youtube.com/watch?v=jkcAYgFGWUY
• Post the final version of your submission in PDF format on your LinkedIn profile. 
• Use the caption "I am participating in FP20 Analytics Challenge 19”. 
• Include a summary of your report's key insights and add the ZoomCharts publish to web link or NovyPro link. 
• Use the hashtags #FP20Analytics, #FP20EcommerceAnalysis, #builtwithzoomcharts, tag @Federico Pastor and @Zoomcharts. 
• Additionally, post your report in the FP20 Analytics LinkedIn Community group. 
• Follow ZoomCharts on LinkedIn 

6. Attend challenge closing webinar to hear the results: 

• The submissions are evaluated by ZoomCharts team (see "Judging criteria" for more info). The submissions of Top 5 ZoomCharts Mini Challenge finalists are analyzed live during the challenge closing webinar to share the best practices and learning opportunities with the community. 
• The author of the best report is awarded with a $300 Amazon gift card.

About the dataset

You are tasked with creating a comprehensive Power BI report using an order dataset from a global skincare and beauty e-store.

Your report should analyze sales volumes and profitability across various product groups and markets, focusing on key performance indicators (KPIs) critical to the e-store's success. Specifically, the e-store aims to achieve an average annual profit margin of 15% across all product groups, 20% annual overall sales growth with a higher target of 30% for the corporate segment, and at least $400K in annual sales for each market.

The final report should not only visualize these KPIs but also provide actionable insights that can drive strategic decision-making for the e-store's future growth.

What should your report include?

Create a report that allows end users to easily find answers to the following questions:

1. What were the most profitable segments from 2020 to 2023?
2. Can we have a map visual to interact with locations to see the profit distribution?
3. What were the most profitable markets since 2020?
4. What were the best selling products since 2020?
5. Following above, can we also view the best selling categories and subcategories?
6. In each market, can we view the sales trend of each product/category/subcategory from 2020 to 2023?
7. In each market, can we view the profits trend of each product/category/subcategory from 2020 to 2023?
8. Did we have a good discount strategy last a few years?
9. Can we list top 10 customers who spent most from each country every year?
10. Which countries contributed most profits to each category?

Technical requirements

• Build your report using only Power BI 
• The number of pages in the report is limited to 3 pages, including drill-through pages
• Canvas size is 16:9 (Default Power BI size) or Full HD size = w:1920 - h:1080 
• The report should contain at least 2 ZoomCharts Drill Down visuals within a single page. See a practical guide for using Drill Down visuals here

Judging criteria

Business users use reports to make data-driven decisions. That’s why reports are called 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. We will evaluate:

1. How easy is it to understand the data? (max 10 points)
   • Is too much text used for explanation?
   • Are the indicative colors in charts instinctually understandable?
   • Does it tell a story?
2. How easy-to-use is the report? (max 14 points)
   • Cross-chart filtering implementation across the report. Can other visuals provide relevant data as the user explores the report?
   • Response time
   • Drill Down: multi-layer data exploration. Can the user drill down and gain additional insights within the report?
   • 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?
3. How good is the report design and is it suitable for its purpose? (max 10 points)
   • Visual design: is the overall look consistent, no empty spaces, no overcrowding?
   • Interface design: are there unnecessary visualisations/buttons/complexity in use?
   • UX design: is the produced report usable?
   • Report design: is the main challenge answered?
   • Technical: are all the fonts used the same, are the sizes readable?

You are encouraged to use various techniques at your disposal, such as tooltips, drill-throughs, drill-downs, cross-chart filtering and page navigation features, to enhance your analysis.

Dataset

My license

1:1 mentoring sessions

You can book a personal session with Senior Product Expert at ZoomCharts, Aivis Pavlovs, to gain practical knowledge about Drill Down Visuals and how they can be used to enhance data storytelling in a report.