Welcome to the Onyx Data July 2024 Challenge!

Jun 30 - Jul 29, 2024 | EDT

Decode Corporate Conversations with July challenge: Analyze internal email communication dynamics to uncover insights and trends.

Timeline

Registration Open

Registration Open

30 June | 21:00

-

Submissions Open

Submissions Open

30 June | 21:00

-

Workshop | Workshop: Practical Tips for Analyzing Internal Email Communication Data

Workshop | Workshop: Practical Tips for Analyzing Internal Email Communication Data

11 July | 09:00

-

1:1 Mentoring Sessions

1:1 Mentoring Sessions

11 July | 09:00

30 June - 24 July

Entry Submission Deadline

Entry Submission Deadline

24 July | 21:00

30 June - 24 July

Webinar | Reviewing Top 5 Reports: Internal Email Communication Analysis in Power BI

Webinar | Reviewing Top 5 Reports: Internal Email Communication Analysis in Power BI

30 July | 10:00

30 June - 24 July

Winner Announced

Winner Announced

30 July | 10:00

30 June - 24 July

Dataset

Get the dataset

See past Onyx Data challenges

See past challenges
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 11K+ data enthusiasts worldwide, ranging from beginners to seasoned professionals, including Microsoft MVPs. Read more about the DataDNA challenge on the Onyx Data website. Join the community on LinkedIn

The ZoomCharts Mini Challenge provides a platform for a growing community to learn how to build PRO reports, aiding business users to explore data quickly and intuitively.

  1. 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.
  2. 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.
  3. Tailored Feedback: Every challenge submission will receive personalized feedback, giving participants the chance to hone their skills and improve their reports.

Prizes

The best report’s creator will receive a $300 Amazon gift card from ZoomCharts. The Top 5 submissions and the winner will be announced live on July 30th. 

Webinar recordings

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:

Dive into the world of organizational dynamics with this month's Power BI data challenge! Analyze internal email communication to understand who communicates with whom and how frequently, uncovering informal networks and collaboration patterns. Detect topics, sentiments, and identify internal influencers and outsiders to gain a comprehensive understanding of communication flows within the company.

The dataset is perfectly structured for graph visualization, offering a fact table for straightforward analysis and dimension tables for more refined insights and customized graphs. Utilize this opportunity to enhance your analytical skills and drive organizational efficiency by revealing hidden communication dynamics. Explore the power of Drill Down Graph PRO for deeper insights.

Dataset Highlights:

  • From and To Information: Names, seniority levels, and departments.
  • Email Details: Topics, dates, sentiments, and whether the email was opened.
  • Communication Context: Devices used, within work hours, and workdays information

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

We empower participants to build PRO reports in order to create exceptional user experiences. Drill down and filter data with ease, giving your end-users the insights they need, quickly and intuitively.

  1. How easy is it to understand the data? (max 10 points)
    • Is too much text used for explanation?
    • Are the indicative colors in charts instinctually understandable?
    • Does it tell a story?
  2. How easy-to-use is the report? (max 14 points)
    • Cross-chart filtering implementation across the report. Can other visuals provide relevant data as the user explores the report?
    • Response time
    • Drill Down: multi-layer data exploration. Can the user drill down and gain additional insights within the report?
    • Use of tutorial overlays and other elements to assist new users. Can a new user start using this report straight away with just the guidance provided within the report itself?
  3. How good is the report design and is it suitable for its purpose? (max 10 points)
    • Visual design: is the overall look consistent, no empty spaces, no overcrowding?
    • Interface design: are there unnecessary visualizations/buttons/complexity in use?
    • UX design: is the produced report usable?
    • Report design: is the main challenge answered?
    • Technical: are all the fonts used the same, are the sizes readable?

You are encouraged to use various techniques at your disposal, such as tooltips, drill-throughs, drill-downs, cross-chart filtering and page navigation features, to enhance your analysis.

Timeline

Registration Open

Registration Open

30 June | 21:00

-

Submissions Open

Submissions Open

30 June | 21:00

-

Workshop | Workshop: Practical Tips for Analyzing Internal Email Communication Data

Workshop | Workshop: Practical Tips for Analyzing Internal Email Communication Data

11 July | 09:00

-

1:1 Mentoring Sessions

1:1 Mentoring Sessions

11 July | 09:00

30 June - 24 July

Entry Submission Deadline

Entry Submission Deadline

24 July | 21:00

30 June - 24 July

Webinar | Reviewing Top 5 Reports: Internal Email Communication Analysis in Power BI

Webinar | Reviewing Top 5 Reports: Internal Email Communication Analysis in Power BI

30 July | 10:00

30 June - 24 July

Winner Announced

Winner Announced

30 July | 10:00

30 June - 24 July

Dataset

Get the dataset

See past Onyx Data July 2024 challenges

See past challenges