Welcome to the FP20 Analytics November 2024 Challenge!

Nov 12 - Dec 11, 2024 | EST

Join Challenge 21 and create a Power BI report to explore the dynamics of Candy Market Share

Submission deadline

00

DAYS

00

HOURS

00

MINUTES

00

SECONDS

Create a ZoomCharts account to receive a Drill Down Visuals Developer License and participate in the competition! Sign in or sign up to continue

Make sure you provide an email address that you check regularly.



Already have an account? Sign in!

Register to the FP20 Analytics ZoomCharts Challenge!



Activate your Drill Down visuals Developer License!

You can use these credential to access ZoomCharts visuals and create your report for this ZoomCharts Mini Challenge, or for your personal training purposes.


Ready to submit your report for review?

Thank you! Your report has been submitted!

Submitted:

Your report will undergo validation. Once the validation of your report is complete, we will send you a Power BI Publish to Web link that you can share publicly.

Confirmed your submission fits the criteria:

Reviewed:

Rejection reason:

Sorry, we are no longer accepting entries for this competition. Stay tuned for future events!

Something went wrong, please contact support!

Timeline

Registration Open

Registration Open

12 November | 19:00

-

Submissions Open

Submissions Open

12 November | 19:00

-

Workshop | How to Analyze Candy market Share in Power BI 🟣 LIVE

Workshop | How to Analyze Candy market Share in Power BI 🟣 LIVE

26 November | 09:00

-

1:1 Mentoring Sessions

1:1 Mentoring Sessions

26 November | 09:00

12 November - 08 December

Entry Submission Deadline

Entry Submission Deadline

08 December | 19:00

12 November - 08 December

Webinar | TOP 5 Power BI Reports of Candy Market Share 🟣 LIVE

Webinar | TOP 5 Power BI Reports of Candy Market Share 🟣 LIVE

12 December | 11:00

12 November - 08 December

Winner Announced

Winner Announced

12 December | 11:00

12 November - 08 December

Dataset

Get the dataset
About challenge
How to participate
The Brief
Judging criteria (Updated!)
Timeline
Dataset
My license
Mentoring

About FP20 Analytics ZoomCharts Challenge

Want to learn to build PRO reports? With personalized feedback and informative workshops, this is your opportunity to take your report-building skills to the next level, build your professional portfolio, and network with like-minded people.

The ZoomCharts challenge is hosted in partnership with FP20 Analytics – a group that unites passionate and inspiring data enthusiasts, and helps new data analysts improve their skills and build a competitive portfolio. Join in and sharpen your skills together with this open and friendly data community. Read more about the challenges on the FP20 Analytics website. Join the community on LinkedIn.

Participate in FP20 Analytics ZoomCharts Challenge to enrich your skill in creating PRO reports that help business users explore data quickly and intuitively. 

  1. Free License: All participants receive a free ZoomCharts Developer License that gives access to the full Drill Down PRO visuals library. License will remain active for 1 year after the challenge.
  2. Learn from Experienced Professionals: As part of the challenge, we host live workshops on report building and visualizing the challenge’s dataset in Power BI. Challenge participants can also book an individual consultation with an experienced Power BI mentor to ask questions and get personalized tips.
  3. Tailored Feedback: Every challenge submission will receive personalized feedback, giving participants the chance to hone their skills and improve their reports.

Prizes

The best report’s creator will receive a $300 Amazon gift card from ZoomCharts. The ZoomCharts winner will be announced in a special live webinar session on December 12th, where we will review the Top 5 entries from the 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

Past Webinar recordings

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 recommended number of pages in the report is up 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 21”. 
  • Include a summary of your report's key insights and add the ZoomCharts publish to web link or NovyPro link. 
  • Use the hashtags #FP20Analytics, #FP20MarketShareAnalysis, #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 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

This Power BI report competition centers on analyzing data from a leading European market research company specializing in the confectionery industry. The dataset includes detailed information on major manufacturers, their brands, packaging, and sales volumes in a specific regional market. Contestants are tasked with visualizing market share dynamics among key players, conducting category-level analysis, and exploring consumption volumes over time.

The report should visualize this information and provide actionable insights to support strategic decision-making for the Company Researchers.

What should your report include?

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

1. What are the top 10 candy items by sales volume in terms of weight in 2022 and 2023?

2. What are the top 10 candy items by sales volume regarding money value in 2022 and 2023?

3. What is the candies’ sales volume in terms of weight trend by month from 2022 to 2023?

4. What manufacturer had the most sales volume in the euro dollar in 2022?

5. What manufacturer had the fewest sales volume in weight in 2023?

6. Which package type of candy is the most popular to sell by weight?

7. Which candy category is the most popular to sell by revenue?

8. Which candy brand sold the most chips in 2022?

9. Which candy brand sold the most chocolate-related candies in 2023?

10. What is the most profitable distribution channel to sell candies?

Technical requirements

  • Build your report using only Power BI 
  • The recommended number of pages in the report is up 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.

Each report is evaluated based on three main criteria: intuitiveness, insightfulness, and interactivity. These factors ensure that the reports are not only accurate and functional, but also meet the target audience's needs and are ready to be presented to the end-users. 

  1. Intuitive: How clear and easy it is to understand the report at a glance? (max 15 points)
    • Is the report visually appealing?
    • Choice of charts and visual elements
    • Does the report tell a story?
    • Is it not overwhelming to the user?
    • Choice of tooltips, titles, and legends

  2. Interactive: How engaging and seamless is the report exploration and interaction with data? (max 15 points)
    • Clear navigation that allows user to explore the report
    • Use of slicers and other interactive elements
    • Smooth cross-chart integration
    • Is report optimized for touch devices?
    • Are tutorials and guiding elements helpful to the user?

  3. Insightful: How accurate, complete, and meaningful is the data in driving decisions? (max 15 points)
    • Depth of analysis
    • Data cleaning and preparation
    • Does data show up accurately in the report?
    • Is report optimized for quicker loading time?
    • Does the report provide deeper exploration of data (drill-down)?

 

Timeline

Registration Open

Registration Open

12 November | 19:00

-

Submissions Open

Submissions Open

12 November | 19:00

-

Workshop | How to Analyze Candy market Share in Power BI 🟣 LIVE

Workshop | How to Analyze Candy market Share in Power BI 🟣 LIVE

26 November | 09:00

-

1:1 Mentoring Sessions

1:1 Mentoring Sessions

26 November | 09:00

12 November - 08 December

Entry Submission Deadline

Entry Submission Deadline

08 December | 19:00

12 November - 08 December

Webinar | TOP 5 Power BI Reports of Candy Market Share 🟣 LIVE

Webinar | TOP 5 Power BI Reports of Candy Market Share 🟣 LIVE

12 December | 11:00

12 November - 08 December

Winner Announced

Winner Announced

12 December | 11:00

12 November - 08 December

Dataset

Get the 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.

Book a meeting