Welcome to the Onyx Data November 2025 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 PRO License: All participants get a ZoomCharts Developer License (worth hundreds of dollars) that gives full access to the Drill Down PRO visuals library.

🏆 Prize: 

The creator of the best report submitted to the Mini Challenge will receive a $300 Amazon gift card. The ZoomCharts winner will be announced in a special live webinar session on November 27th, 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

E-Commerce Sales Power BI Report Creation Workshop

7th November, 2025

07:00 AM - EST

Learn to analyze e-commerce sales, loyalty, and promotions in Power BI with Aivis Pavlovs from ZoomCharts.

Learn more

Expert Review of the Top 5 Power BI E-Commerce Sales Reports

27th November, 2025

09:00 AM - EST

Explore the top 5 Power BI reports, see different analysis approaches, and discover best practices for clear e-commerce reporting.

Learn more

How to participate in Onyx Data DataDNA & ZoomCharts Mini Challenge?

1. Register for the challenge: 

• Register for DataDNA ZoomCharts Mini Challenge using the form above ⬆️
  
• Activate your free Drill Down Visuals Developer License for Power BI.
• Download Challenge dataset from Onyx Data DataDNA Main Challenge website.

2. Build your report in Power BI: 

• Add ZoomCharts License to your Power BI Desktop. Watch license setup video or read the guide.
• Add ZoomCharts visuals to your Power BI visualization pane from the Power BI visuals library or AppSource.
• Use the dataset to build a Power BI report including at least 2 ZoomCharts Drill Down Visuals in one report page. 

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 here.
• Check out the submissions from past challenges for inspiration. 

4. Submit your challenge entry: 

• Submit your report in .pbix format for validation using the form on this page.

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. 

• Your report will be reviewed within 1–2 business days. Once it’s validated, you’ll receive a Publish to Web link via email. You can use this link to add the report to your portfolio or share it publicly online.
• All validated entries will also receive personalized feedback from the evaluation team via email within 1-2 business days. Use this feedback to revise your report and resubmit it before the deadline.

Note: Feel free to resubmit your entry as many times as necessary before the deadline.

5. Finalize your participation to compete for the prize

• Share a LinkedIn post on your profile with an image, screenshot, or video of your Power BI project showcasing how to interact with the report, including the tags @ZoomCharts and @OnyxData, as well as the hashtags #dataDNA and #builtwithzoomcharts.
• After posting the report on LinkedIn, please submit it to the Onyx Data DataDNA Main Challenge to compete for all prizes.
• Follow ZoomCharts on LinkedIn
• Follow Onyx Data 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 rewarded with 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

E‑commerce Analytics Challenge

You will analyze an e-commerce sales dataset from a global software retailer that sells subscriptions and add-ons across analytics, design, collaboration, and AI. Your objective is to identify loyal customers (repeat buyers) and determine which channels and promotional campaigns drive their repeat purchases.

Build an easy-to-read data visualization report that:

• Tracks sales and loyal-customer volumes over time.
• Highlights revenue drivers and repeat-purchase patterns.
• Shows how discounts and pricing influence sales performance.
• Delivers clear insights that guide business strategy and stakeholder decisions.

Guiding Questions

1. How do total sales change by month?
2. Which channels bring in the most sales?
3. Which channels bring the most repeat (loyal) customers?
4. What percent of monthly sales comes from loyal customers?
5. Which products or plans sell the most?
6. Which products are most popular with loyal customers?
7. How long do customers wait before their second purchase?
8. Which discount codes are used most, and do they increase repeat purchases?
9. What is the average selling price (ASP) by country or currency?
10. Where do refunds happen most (by product or channel)?
11. Do annual plans bring higher revenue per customer than monthly plans?
12. Which add-ons are most often bought with core products (attach rate)?

✨ Note: These questions are just starting points. You’re encouraged to explore the data in your own way and share any unexpected findings that could.

Your insights could help regulators strengthen consumer protection policies, support journalists in highlighting financial fairness issues, and provide consumers with more transparency about financial institutions.

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.