Live Challenge closes on the 6th of August
Live Challenge closes on the 6th of August
Participate in the ZoomCharts Challenge to showcase skills, gain recognition, network, and boost your professional profile.
The ZoomCharts team provides personalized feedback to EVERY report entry that meets the requirements. This gives all participants the chance to hone their skills and adjust their report before deadline, giving you an extra competitive edge in the challenge.
Upon signing up for the challenge, you will receive a FREE Drill Down Visuals Developers License that lets you access the full Drill Down Visuals PRO library. This license remains active for a year after the last challenge you take part in. Meaning, you can access the latest advanced data visualization tools to enhance your projects for a full year.
Participants receive all the latest information on upcoming workshops and events, demonstrating how our team of proven professionals approaches visualizing the given dataset for the challenge. You also have the chance to book 1:1 calls with a Power BI mentor who will analyse and give specific suggestions to improve your report.
Last but not least, entering the challenge with ZoomCharts puts you in the running for an additional $300 Amazon gift card.
Below is your show time. Read me carefully!
Below is your important reading!
Welcome to FP20 Analytics Challenge 39, where analytics meets legal operations, case management, lawyer performance, client intelligence, and financial oversight across a fictional European law firm.
In this challenge, you will step into the role of a Legal Operations Analyst, Firm Performance Manager, Client Intelligence Consultant, or Executive BI Advisor, tasked with evaluating a dataset that reflects the operational and commercial reality of a multi-office international law firm — LexEuropa Legal Group.
You are not just analysing legal records — you are telling the story of how case performance drives revenue, how lawyer seniority shapes outcomes, how practice area trends reveal market shifts, and how office geography creates competitive advantage. The best submissions will connect case complexity, billing patterns, client satisfaction, risk exposure, and financial performance to real-world decisions: faster case resolution, smarter resource allocation, stronger client retention, and more profitable practice areas.
The objective is clear: transform raw legal data into strategic business intelligence — highlighting where revenue is growing, which offices are outperforming, which lawyers are driving the most value, what drives winning cases, and how client relationships translate into long-term profitability.
This challenge is an opportunity to demonstrate how Power BI can elevate legal operations from reactive reporting into a strategic driver of smarter decisions across the firm.
KEY QUESTIONS TO EXPLORE
1 How does Days Open change by Open Date, and what trend patterns should leaders pay attention to?
2 Which Case ID and Client ID account for the highest activity, pressure, or performance variation?
3 Are there outliers or unusual patterns that need further investigation?
4 How do key metrics compare across important business segments?
5 Which groups or dimensions explain the biggest differences in performance?
6 How do strategic clients compare to non-strategic clients across revenue, satisfaction, case complexity, and outstanding balance — and is the premium justified?
7 Which offices are generating the highest profit margins, and which are carrying disproportionate outstanding balances or risk scores?
8 Which measures show the strongest improvement or decline?
9 Which practice areas have grown or declined in revenue and case volume over the three years, and what does that signal for the firm's strategic focus?
10 Which factors appear most connected to better or worse outcomes?
11 How does lawyer seniority and years of experience relate to case outcomes, client satisfaction scores, and billable hour efficiency?
12 Which combinations of case complexity, practice area, and priority are most likely to result in cases being Won versus Lost or Settled — and what does that mean for case intake decisions?
13 Where are the biggest gaps, risks, or inefficiencies in the process?
14 Where are the strongest opportunities for operational improvement?
15 What practical recommendations should leaders prioritise based on the data?
Know more about the judging criteria and other requirements
1. Is too much text used for explanation?
2. Are the indicative colors in charts understandable?
3. Does it tell a story?
1. Cross-chart filtering implementation.
2. Across the report. Can other visuals provide relevant data as the user explores the rep.
3. Response time.
4. Drill Down: multi-layer data exploration. Can the user drill down and gain additional insights within the report?
5. 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?
1. Visual design: is the overall look consistent, no empty spaces, no overcrowding?
2. Interface design: are there unnecessary visualisations, buttons, complexity in use?
3. UX design: is the produced report usable?
4. Report design: is the main challenge answered?
5. Technical: are all the fonts used the same, are the sizes readable?
All tools are permitted for the challenge.
For the ZoomCharts Challenge, create a Power BI report that includes at least 2 ZoomCharts Drill Down Visuals on one report page.
Reports are restricted to a maximum of three pages, including drill-through pages.
Canvas size is 16:9 (Default Power BI size) or Full HD size = w:1920 - h:1080.
Business users use reports to make data-driven decisions. Reports are 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.
1. Use-Case Gallery: Try live demos and download reports made by the ZoomCharts team
2. Video tutorials: Watch engaging video guides on how to set up and use the visuals
3. Documentation: Technical deep-dive about ZoomCharts visuals
4. ZoomCharts Blog: Useful tips & tricks for data visualization and report creation
5. Visuals Gallery: Explore all the possible customization options for Drill Down Visuals.
1. One Excel workbooks.
2. One Word document containing the Introduction and Brief (English).
To submit your three-page report, please follow these steps, if you want to be considered for the ZoomCharts' prize, otherwise post your entry in the challenges group.
Your report must be verified to ensure it meets all the technical requirements. If the report is validated, you will receive a 'Publish to Web' link. If it does not meet the criteria, you will receive a rejection reason and will have the opportunity to resubmit your report.
1. Upload the report as a PDF document on your LinkedIn feed.
2. Use the caption "I am participating in FP20 Analytics Challenge 39” and screenshots from your report.
3. Include a summary of your report's key insights.
4. Use the hashtags #FP20Analytics, #FP20LexEuropa, #builtwithzoomcharts, tag @Federico Pastor - @Zoomcharts
5. Additionally, post your report in the FP20 Analytics LinkedIn Community Group.
Click on the link below to get your dataset: The files contain all the necessary data and information to create your report.