Registration Open
Registration Open
01 July | 04:00
-
Reset your password
We'll email you instructions on how to reset your password
Welcome to the Onyx Data July 2025 Challenge!
Jul 01 - Jul 29, 2025 | EDT
Join the DataDNA ZoomCharts Mini Challenge! Analyze customer satisfaction trends for a retail company using Power BI. Guide leadership in improving retention, loyalty, and the overall customer experience.
Timeline
Workshop | Power BI Workshop: Building Customer Satisfaction and Loyalty Reports
Workshop | Power BI Workshop: Building Customer Satisfaction and Loyalty Reports
03 July | 08:00
-
Webinar | Top Power BI Reports for Customer Satisfaction Analytics
Webinar | Top Power BI Reports for Customer Satisfaction Analytics
29 July | 08:00
01 July - 24 July
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
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
The ZoomCharts Mini Challenge provides additional benefits and a platform for a growing community to learn how to build PRO reports, helping business users explore data quickly and intuitively, including:
- 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.
- 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.
- Tailored Feedback: Every challenge submission will receive personalized feedback, giving participants the chance to hone their skills and improve their reports.
Prizes
The creator of the best report submitted to the Mini Challenge will receive a $300 Amazon gift card from ZoomCharts.
Webinar recordings
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. Read license setup instructions.
- Download Challenge dataset from Onyx Data DataDNA Main Challenge website.
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.
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 your Power BI project image, 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
- Follow ZoomCharts on LinkedIn
- Follow Onyx Data on LinkedIn
- All participants of ZoomCharts Mini Challenge need to submit reports main Onyx Data DataDNA challenge for a chance to win additional prizes.
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
The Brief:
Customer Satisfaction and Loyalty Analytics Challenge
Step into the role of a data analyst at OmniRetail, a U.S. retail chain selling electronics and smart home products through both online and physical stores. To improve customer satisfaction and retention, the company has collected feedback throughout 2024.
You’ve been provided with a customer satisfaction dataset combining satisfaction scores, purchasing behavior, demographics, support history, and location data.
Your mission is to create an analytical report that identifies the key factors influencing customer satisfaction and loyalty across different regions, customer demographics, and support experiences.
Key questions to guide your analysis:
- What are the main factors contributing to high vs. low satisfaction scores?
- Are certain customer segments (by age, gender, group) more loyal than others?
- Which locations (cities or states) report consistently high or low satisfaction scores?
- Does contacting customer support negatively impact satisfaction?
- How do factors like “Price” or “Product Variety” influence customer loyalty?
- Do repeat purchasers report higher satisfaction compared to one-time buyers?
- Are there regional clusters of highly loyal or dissatisfied customers based on location data?
- What is the relationship between loyalty level and satisfaction score?
- Do specific demographic groups favor certain satisfaction factors (e.g., Packaging vs. Price)?
Use these questions as a springboard - don’t hesitate to explore deeper relationships. Your insights could help reshape the customer experience strategy for the brand.
Dataset Overview:
|
Column Name |
Description |
|
Customer_ID |
Unique customer identifier (for internal use only) |
|
Group |
Customer classification: A, B, or C • Group A: High-frequency shoppers • Group B: Moderate-frequency • Group C: New or low-frequency |
|
Satisfaction_Score |
Customer’s rating of their experience (1 = very poor, 10 = excellent) |
|
Age and Gender |
Demographic attributes |
|
Location |
City and State (e.g., Austin.TX), with Latitude and Longitude for geographic mapping |
|
Purchase_History |
Indicates if the customer has made purchases (Yes/No) |
|
Support_Contacted |
Whether the customer interacted with support |
|
Loyalty_Level |
OmniRetail’s internal rating: Low / Medium / High loyalty |
|
Satisfaction_Factor |
The main reason influencing the satisfaction score (e.g., Price, Product Variety, Packaging) |
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
Judging criteria
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 | Power BI Workshop: Building Customer Satisfaction and Loyalty Reports
Workshop | Power BI Workshop: Building Customer Satisfaction and Loyalty Reports
03 July | 08:00
-
Webinar | Top Power BI Reports for Customer Satisfaction Analytics
Webinar | Top Power BI Reports for Customer Satisfaction Analytics
29 July | 08:00
01 July - 24 July