Welcome to the Onyx Data January February 2026 Challenge!

About ZoomCharts Mini Challenge

🏆 Main Prize: $300 Amazon Gift Card

ZoomCharts Mini Challenge is part of the global DataDNA – Dataset Challenge by Onyx Data, which unites 25K+ data enthusiasts worldwide, ranging from beginners to seasoned professionals, including Microsoft MVPs. Read more about the DataDNA challenge on the Onyx Data DataDNA website. Join the community on LinkedIn.

Why join ZoomCharts Mini Challenge?

1. Workshops & 1:1 Mentoring: Learn directly from experienced Power BI professionals through live workshops on report-building best practices, 1:1 mentoring sessions to review your report and get tailored advice.
2. Get Personal Feedback: Every participant receives detailed, personalized feedback on their report - a great opportunity to improve based on real input from seasoned analysts.
3. Free ZoomCharts Visuals License: All participants get a ZoomCharts Developer License (worth hundreds of dollars) that gives full access to the Drill Down PRO visuals library.
4. Free Report Downloads: Each challenge participant with a validated report will receive 5 free downloads from the Power BI Report Gallery.

Prizes 🏆

• The best report using ZoomCharts visuals will receive a $300 Amazon Gift Card.
• Being selected in the Top 5 will grant you +10 free downloads from the Power BI Report Gallery.

The ZoomCharts Mini Challenge winner will be announced on on February 27 during a special live webinar session, where experts 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

Building Insightful Pharmacy Sales & Profitability Dashboards in Power BI

15th January, 2026

08:00 AM - EST

Join this hands-on Power BI workshop to explore pharmacy sales and profitability data and learn how to design interactive, drillable reports with ZoomCharts.

Learn more

Top 5 Pharmacy Sales & Profitability Reports: Power BI Best Practices Review

27th February, 2026

07:00 AM - EST

Join us as we review the top 5 Power BI reports from the Pharmacy Sales & Profitability Analytics challenge and highlight best practices in visualization and storytelling.

Learn more

How to Participate in the Onyx Data DataDNA & ZoomCharts Mini Challenge

1. Register for the Challenge

• Register using the form above.

• Activate your free ZoomCharts Drill Down Visuals Developer License for Power BI.

• Download the challenge dataset from the Onyx Data DataDNA Main Challenge website here.

2. Build Your Report in Power BI

• Add your ZoomCharts license to Power BI Desktop
  (watch the setup video or read the step-by-step guide).

• Add ZoomCharts visuals from the Power BI visuals library or Microsoft Marketplace.

• Use the dataset to build a Power BI report that includes at least two (2) ZoomCharts Drill Down Visuals on one report page.

3. Improve Your Report and Learn New Skills

• Join the challenge workshop to learn how to use ZoomCharts visuals and the dataset.

• If you need help, book a free consultation with the ZoomCharts team.

• Browse past challenge submissions for inspiration and ideas.

4. Submit Your Challenge Entry

• Upload your report in .pbix format using the submission form on this page.

If your report does not meet the challenge requirements:
You will receive an email explaining what needs to be fixed. You can update your report and submit it again.

Validation timeline:

• Your report will be reviewed within 1–2 business days.

• Once validated, you will receive a Publish to Web link you can share publicly or add to your portfolio.

• You will also receive personalized feedback from the evaluation team within 1–2 business days.
  Use this to improve your report and resubmit before the deadline.

Note:
You can resubmit your entry as many times as needed before the final deadline.

5. Finalize Your Participation to Compete for Prizes

• Share a LinkedIn post showing your finished report (image, screenshot, or video).

• Tag @ZoomCharts and @OnyxData, and use the hashtags #dataDNA and #builtwithzoomcharts.

• After posting, submit the LinkedIn post link to the Onyx Data DataDNA Main Challenge to enter the prize competition.

• Follow both ZoomCharts and Onyx Data on LinkedIn.

6. Attend the Live Closing Webinar

• The ZoomCharts team reviews and analyzes the Top 5 Mini Challenge entries during live webinar.

• You will learn best practices, improvement tips, and see how others solved the challenge.

• The winner of the best report receives a $300 Amazon gift card from ZoomCharts.

Technical requirements

• Build your report using only Power BI
• The number of pages in the report is not limited
• At least one report page has to contain a minimum of 2 ZoomCharts Drill Down Visuals. See a practical guide on Drill Down Visuals here

The Brief

Pharmacy Sales & Profitability Analytics Data Challenge

In this challenge, you will analyze a dataset representing a European pharmacy chain distributor operating across multiple European countries. The dataset includes daily sales transactions by pharmacy and product, with supporting dimensions for time, geography and product hierarchy.

Your task is to build a Power BI report that helps stakeholders understand:

• How sales and profitability vary across countries, regions, and individual pharmacies
• How different product categories and brands perform in different locations
• How regional performance contributes to overall business results

Key Questions:

• How do revenue, units sold, and margin change over time, and are there clear seasonal patterns?
• Which countries and regions contribute the most to total revenue and margin?
• How does performance vary when drilling down from country → region → pharmacy?
• Which pharmacies outperform or underperform compared to others in the same region?
• How do Urban, Suburban, and Rural pharmacies differ in sales volume and profitability?
• Which product categories and brands generate the most revenue, and which generate the most margin?
• Are there products with high volume but low margin, or low volume but high margin?
• How do promoted sales compare to non-promoted sales in terms of volume and margin?
• How does regional performance contribute to overall business results?
• Are there visible geographic patterns in sales or profitability when viewed on a map?

Note: These questions are starting points. Participants are encouraged to explore the dataset further and highlight patterns or comparisons that are not immediately obvious, as long as they are supported by the data.

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)?

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.