Registration Open
Registration Open
16 January | 19:00
-
Welcome to the FP20 Analytics January 2024 Challenge!
Jan 16 - Feb 20, 2024 | EST
Try your hand at strategic planning in education with a real-life data use case.
Timeline
Workshop | FP20 Analytics Challenge 13: Education Management with ZoomCharts
Workshop | FP20 Analytics Challenge 13: Education Management with ZoomCharts
06 February | 09:00
-
Webinar | FP20 Analytics Challenge 13: ZoomCharts Award Winner
Webinar | FP20 Analytics Challenge 13: ZoomCharts Award Winner
21 February | 11:00
16 January - 14 February
Submitted Reports
About challenge
How to participate
The Brief
Judging criteria
Timeline
Dataset
Past challenges
Winner of the challenge
All Submissions
About FP20 Analytics ZoomCharts Challenge
The ZoomCharts challenge is hosted in partnership with FP20 Analytics – a group that unites passionate and inspiring data enthusiasts, and helps new data analysts improve their skills and build a competitive portfolio. Join in and sharpen your skills together with this open and friendly data community. Read more about the challenges on the FP20 Analytics website. Join the community on LinkedIn.
Participate in FP20 Analytics ZoomCharts Challenge to enrich your skill in creating excellent Power BI reports that help business users explore data quickly and intuitively.
- 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 best report’s creator will receive a $300 Amazon gift card from ZoomCharts. The winner will be announced in a special live webinar session on February 21, where we will review the top entries from the challenge.
Webinar recordings
How to participate?
- Register and receive a Drill Down Visuals Developer License for Power BI.
- Download the challenge dataset.
- Use the dataset to build a Power BI report with ZoomCharts Drill Down Visuals.
- 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) - 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 - 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 13”, 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, #FP20AnalyticsEducationAnalysis, #builtwithzoomcharts, tag @Federico Pastor and @Zoomcharts.
- Additionally, post your report in the FP20 Analytics LinkedIn Community Group.
- Follow ZoomCharts on LinkedIn
About the dataset
The Fort Vermilion School Division (FVSD) is a governmental organization responsible for overseeing schools in the northwestern corner of Alberta, Canada. FVSD is renowned for their commitment to data-driven planning and decision-making to empower every student with equal opportunities and care in education. For this challenge, FVSD have contributed their data so you can practice your skills with a real-world use case.
Background information to help you understand the data
The school year is split into 3 semesters (Fall, Winter, and Spring). Each student is assessed each semester using three test (assessment) types — TOSREC, TOWRE and TOSWRF — using a standard score system. For each test, there is a known associated cost per student.
Based on the received score, students are split into groups indicating their performance level. Two types of grouping are used: 1) assessment level (very poor, at risk, good etc.), and 2) assessment level grouping (below average or average and above). Students with poor test results are required to take additional classes (Intervention groups), where each group contains 5 or 10 students depending on the test score, and require additional teacher resources.
What should your report include?
Create a report that allows end users to easily find answers to the following questions:
1. Total number of students per each assessment level broken down by:
- Semester (Fall, Winter, & Spring)
- School Year
- School
2. Total number of students per each assessment type broken down by
- Semester (Fall, Winter, & Spring)
- School Year
- School
3. % of students (calculated from the total number of students) per each assessment level broken down by:
- Semester (Fall, Winter, & Spring)
- School Year
- School
4. % of students (calculated from the total number of students) per each assessment level group broken down by
- Semester (Fall, Winter, & Spring)
- School Year
- School
5. Students Assessments between 80 and 90 Standard Score in each period go into an Intervention Group (Tier 2). This Group contains 10 Students that requires one Teacher. How Many teachers will we require for these Intervention Groups in Winter of 2023 / 2024 based on 2023 / 2024 Fall Results.
6. Students Assessments below 80 Standard Score in each period go into an Intervention Group (Tier 3). This Group contains 5 Students that requires one Teacher. How Many teachers will we require for these Intervention Groups in Winter of 2023 / 2024 based on 2023 / 2024 Fall Results.
7. What are projected testing costs for Winter of 2023 / 2024 based on 2023 / 2024 Fall results?
Optional: (Division of school years and semesters doesn't follow the traditional logic of Calendar year, and Same Period Last year calculations, and can be very complex to solve. Therefore, for these exercises, we have prepared a date calendar in the model that takes into account the semesters and the yearly split of school years. So please pay attention to the values that are provided)
- Change in the total number of students per each assessment level when compared to previous semester (fall, winter, or spring)
- Change in the total number of students per each assessment level when compared to the same semester in the previous school year (e.g., fall 2023 and fall 2022)
- % change in number of students per each assessment level when compared to previous semester (fall, winter, or spring)
- % change in number of students per each assessment level when compared to the same semester in the previous school year (e.g., fall 2023 and fall 2022)
- Showcase the average score trend throughout the years / semesters
Tip: This information can be displayed in separate charts or in drill down levels.
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:
- 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?
- 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?
- 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.
Timeline
Workshop | FP20 Analytics Challenge 13: Education Management with ZoomCharts
Workshop | FP20 Analytics Challenge 13: Education Management with ZoomCharts
06 February | 09:00
-
Webinar | FP20 Analytics Challenge 13: ZoomCharts Award Winner
Webinar | FP20 Analytics Challenge 13: ZoomCharts Award Winner
21 February | 11:00
16 January - 14 February