Emergency Operations & Patient Flow Analytics

Guest Judge

Kathrin Borchert

YODABI
Managing Partner

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.

How to Participate in the FP20 Analytics & ZoomCharts Challenge

1. Register for the Challenge

• Register using the form above on this page.

• Download the dataset using the "Get the Dataset" button on this page.

• Read the challenge brief in the "The Brief" section to understand the data and requirements.

• Activate your free Drill Down Visuals Developer License for Power BI. (watch the setup video or follow the step-by-step instructions).

2. Build Your Report in Power BI

• Add your ZoomCharts Developers license to Power BI Desktop.

• Add ZoomCharts visuals from the Power BI visuals library or Microsoft Marketplace.

• Build your report using the challenge dataset.

• Recommended report format:

  • Up to 3 pages (including any drill-through pages)

  • Canvas size: 16:9 (default) or 1920 × 1080 (Full HD)

  • Your report must include at least two ZoomCharts Drill Down Visuals on the same page.

3. Improve Your Report and Learn New Skills

• Join the challenge workshop to learn how to use the dataset

• If you need help, book a free 1-on-1 consultation with the ZoomCharts team to discuss your report

• Look at previous challenge submissions for ideas and inspiration in the report gallery.

4. Submit Your Challenge Entry

• Log in to your account on this page and upload your report in .pbix format for validation.

• If your report does not meet all 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 that you can use in your portfolio or share online.

• You will also receive personalized feedback within 1–2 business days to help you improve your report.

Note:
You may resubmit your entry as many times as needed before the challenge deadline.

5. Finalize Your Participation to Compete for the ZoomCharts Grand Prize

To be eligible for all prizes, complete these steps:

1. Post the final version of your report (PDF) on your LinkedIn profile.

2. Use this caption:
   "I am participating in FP20 Analytics ZoomCharts Challenge 38"

3. Include a short summary of your report and the Publish to Web link (if you have one).

4. Use the hashtags #FP20Analytics and #builtwithzoomcharts and tag @Federico Pastor and @ZoomCharts.

5. Obligatory! Share your report also in the FP20 Analytics LinkedIn Community group.

6. Follow ZoomCharts on LinkedIn.

7. Rate ZoomCharts visuals at Microsoft Marketplace.

6. Attend the Live Closing Webinar

• The ZoomCharts team reviews and analyzes the Top 5 challenge submissions during the live webinar.

• You will learn best practices, visualization tips, and new Power BI skills.

• The winner of the best report receives a $300 Amazon gift card from ZoomCharts.

Technical requirements

• Build your report using Power BI
• The recommended number of pages in the report is up to 3 pages, including drill-through 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 at least one page. See a practical guide for using Drill Down PRO visuals.

Emergency Operations & Patient Flow Analytics

In this data analytics challenge, you will be using the healthcare dataset from the “Code Blue” Emergency Operations & Patient Flow dataset to help hospitals understand operational performance, identify pressure points, and support better decision-making.

Key Questions to Explore

• How does Beds change by Full_Date, and what trend patterns should leaders pay attention to?
• Which Hospital_ID and Hospital_Name account for the highest activity, pressure, or performance variation?
• Which measures show the strongest improvement or decline?
• Where are the biggest gaps, risks, or inefficiencies in the process?
• Which groups or dimensions explain the biggest differences in performance?
• How do key metrics compare across important business segments?
• Are there outliers or unusual patterns that need further investigation?
• Which factors appear most connected to better or worse outcomes?
• Where are the strongest opportunities for operational improvement?
• What practical recommendations should leaders prioritise based on 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. 

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 licenses

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.