Registration Open
Registration Open
05 January | 03:00
-
Reset your password
We'll email you instructions on how to reset your password
Pharmacy Sales & Profitability Data Challenge
Jan 05 - Feb 27, 2026 | EST
Analyze European pharmacy chain data, build stunning Power BI reports, and compete for a $300 prize.
Timeline
Workshop | Building Insightful Pharmacy Sales & Profitability Dashboards in Power BI
Workshop | Building Insightful Pharmacy Sales & Profitability Dashboards in Power BI
15 January | 08:00
-
Webinar | Top 5 Pharmacy Sales & Profitability Reports: Power BI Best Practices Review
Webinar | Top 5 Pharmacy Sales & Profitability Reports: Power BI Best Practices Review
27 February | 07:00
05 January - 20 February
Submitted Reports
About challenge
How to participate
The Brief
Judging criteria
Timeline
Dataset
Past challenges
Winner of the challenge
All Submissions
About ZoomCharts Mini Challenge
🏆 Main Prize: $300 Amazon Gift Card
Read about all prizes of Onyx Data #DataDNA challenge here.
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.
Benefits of Joining DataDNA ZoomCharts Mini Challenge:
- 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.
- Get Personal Feedback: Every participant receives detailed, personalized feedback on their report - a great opportunity to improve based on real input from seasoned analysts.
- 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.
- Free Report Downloads: Each challenge participant with a validated report will receive 5 free downloads from the Power BI Report Gallery.
Special Prizes for ZoomCharts Mini Challenge Finalists 🏆
- 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.
Join LIVE Winner Announcement event on February 27 during a special live webinar session, where experts will review the Top 5 entries from the challenge.
Webinar recordings
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.
- 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
- 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?
- 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
Workshop | Building Insightful Pharmacy Sales & Profitability Dashboards in Power BI
Workshop | Building Insightful Pharmacy Sales & Profitability Dashboards in Power BI
15 January | 08:00
-
Webinar | Top 5 Pharmacy Sales & Profitability Reports: Power BI Best Practices Review
Webinar | Top 5 Pharmacy Sales & Profitability Reports: Power BI Best Practices Review
27 February | 07:00
05 January - 20 February