Welcome to the FP20 Analytics April 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

Learn from the Best HR Reports: ZoomCharts TOP Picks

13th May, 2024

11:00 AM - EDT

Best FP20 Analytics ZoomCharts Challenge 15 submissions + announcing the winner

Learn more

Past Webinar recordings

How to Leverage ZoomCharts for Data-Driven HR Decisions

ZoomCharts online workshop for FP20 Analytics Challenge 15 participants

Watch the recording

How to participate?

1. Register and receive a Drill Down Visuals Developer License for Power BI.
2. Download the challenge dataset.
3. Use the dataset to build a Power BI report with ZoomCharts Drill Down Visuals.
4. Submit your entry to be verified.
   
   (If your submission doesn’t match the challenge criteria, you will be notified by email, so make sure you will have time for revision and resubmission if needed. Feel free to resubmit the entry as many times as necessary before the deadline)
5. Upload your publish to web link on NovyPro. 

   Note: If you opt to post your report on NovyPro, for instructions on how to do this, refer to the provided video link. 

   NovyPro: https://www.novypro.com/
   Instruction Video: https://www.youtube.com/watch?v=jkcAYgFGWUY 
6. Post your submission on LinkedIn:
   • Upload the report as a PDF document on your LinkedIn feed.
   • Use the caption, “I am participating in FP20 Analytics Challenge 15”, along with screenshots from your report.
   • Include a brief summary about your report's key insights and publish to web or NovyPro link.
   • Use the hashtags #FP20Analytics, #FP20AnalyticsHRAnalysis, #builtwithzoomcharts, tag @Federico Pastor and @Zoomcharts.
   • Additionally, post your report in the FP20 Analytics LinkedIn Community Group.
7. Follow ZoomCharts on LinkedIn

What should your report include?

In Challenge 15 we will be identifying trends within a Human Resource dataset.
Create a report that allows end users to easily find answers to the following questions: 

1. How diverse is the workforce in terms of gender, ethnicity, and age?
2. Is there a correlation between pay levels, departments, and job titles?
3. How about the geographic distribution of the workforce?
4. What is the employee retention rate trend yearly?
5. What is the employee retention rate in terms of gender, ethnicity, and age?
6. Which business unit had the highest and lowest employee retention rate?
7. Which business unit and department paid the most and least bonuses annually?
8. What is the annual historical bonus trend? Can we show new hires some statistics?
9. How about the pay equity based on gender, ethnicity, and age?
10. What is the employee turnover rate (e.g., monthly, quarterly, annually) since 2017?

Tips for working with the dataset

Use the formula: Apply the following formula to calculate the turnover rate:

Employee Turnover Rate — (Number of Separations / Average Number of Employees​) ×100.

For example, if a company had 50 employees at the start of the year, 55 at the end, and 5 separations occurred during the year, using the formula:

Turnover Rate= (5/52.5)×100≈9.52%

Technical requirements

• Build your report using only Power BI 
• Reports are restricted to a maximum of 2 pages 
• Canvas size is 16:9 (Default Power BI size) or Full HD size = w:1920 - h:1080 
• The report should contain at least 2 ZoomCharts Drill Down visuals within a single page. See a practical guide for using Drill Down visuals here

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. We will evaluate:

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 visualisations/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.

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.