Welcome to the Onyx Data December 2024 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

Review of Top 5 Reports from Bank Data Challenge

20th December, 2024

09:00 AM - EST

Best DataDNA ZoomCharts Mini Challenge submissions + the winner announcement

Learn more

Past Webinar recordings

Customer Analysis and Risk Assessment with Power BI

Workshop for the December DataDNA challenge 

Watch the recording

How to participate? 

1. Register for the challenge: 

• Download the DataDNA Challenge dataset either on this Challenge page or from Onyx Data website. 
• Register for DataDNA ZoomCharts Mini Challenge.
• Activate your free Drill Down Visuals Developer License for Power BI. Read license setup instructions.

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. 
• 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 prize: 

• Post the final version of your submission as a single image on your LinkedIn profile, including the tags @ZoomCharts and @OnyxData, as well as the hashtags #dataDNA and #builtwithzoomcharts.
• After posting the report on LinkedIn, please complete this form. 
• Follow ZoomCharts on LinkedIn 
• Follow Onyx Data on LinkedIn 
• All participants of ZoomCharts Mini Challenge who have filled in the form are also valid to compete in the main Onyx Data DataDNA challenge for a chance to win additional prizes. Read more here. 

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. 

Challenge Description:

Welcome to the Aurora Bank Data Challenge! As a data analyst at one of the most dynamic financial institutions, you're tasked with uncovering critical insights from data on customers, transactions, cards, and merchant categories. Aurora Bank is counting on you to solve pressing challenges and deliver actionable insights.

Your Mission:

• Understand Customer Profiles: Explore customer demographics, financial health, and behaviors to unlock new opportunities for engagement.
• Analyze Spending Trends: Uncover patterns and growth opportunities in transaction data.
• Identify Risks: Spot potential red flags in rising debt, transaction errors, and fraudulent activity.
• Create Impactful Dashboards: Use Power BI to present your insights visually, telling Aurora Bank’s data story.

Choose your own analytical approach, or focus on one of the below options:

1. Customer Profiling & Segmentation

Gain a deep understanding of customer demographics, financial health, and behaviors to enable personalized marketing strategies and assess customer risk levels.

Focus Areas:

• Customer Demographics: Analyze the age, gender, and geographical distribution of customers.
• Credit Score Analysis: Explore the distribution of credit scores and the factors influencing them (e.g., income, debt, age).
• Financial Health: Calculate debt-to-income ratios and identify high-risk customers.
• Card Ownership: Assess the number of credit/debit cards per customer and usage trends by demographic.

2. Transaction and Risk Analysis

Understand customer spending behaviors while enhancing fraud detection and ensuring compliance with regulations to minimize risks.

Focus Areas:

• Spending Patterns: Evaluate transaction volumes by merchant categories (MCC) or locations.
• Geographical Trends: Identify high-spending regions or locations prone to failed transactions.
• Error Trends: Monitor transaction errors (e.g., bad PIN entries) to enhance user experience.
• High-Value Transactions: Flag unusually high-value transactions for potential fraud detection.
• Credit Risk: Identify customers at risk of default based on debt-to-income ratios and credit score trends.
• Debt Levels: Analyze the distribution of total debt across customers for portfolio risk management.

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. 

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.