Live Challenge closes on 29th September 2024 at 23:59 pm UK time
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!
You are tasked with creating a comprehensive Power BI report using an order dataset from a global skincare and beauty e-store. Your report should analyze sales volumes and profitability across various product groups and markets, focusing on key performance indicators (KPIs) critical to the e-store's success. Specifically, the e-store aims to achieve an average annual profit margin of 15% across all product groups, 20% annual overall sales growth with a higher target of 30% for the corporate segment, and at least $400K in annual sales for each market. The final report should not only visualize these KPIs but also provide actionable insights that can drive strategic decision-making for the e-store's future growth.
1. What were the most profitable segments from 2020 to 2023?
2. Can we have a map visual to interact with locations to see the profit distribution?
3. What were the most profitable markets since 2020?
4. What were the best seller products since 2020?
5. Following above, can we also view the best seller categories and subcategories?
6. In each market, can we view the sales trend of each product/category/subcategory from 2020 to 2023?
7. In each market, can we view the profits trend of each product/category/subcategory from 2020 to 2023?
8. Did we have a good discount strategy last a few years?
9. Can we list top 10 customers who spent most from each country every year?
10. Which countries contributed most profits to each category?
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 ZoomCharts Challenge: create a Power BI report including at least 2 ZoomCharts Drill Down Visuals in one report page.
Reports are restricted to a maximum of 3 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. 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.
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. An Excel spreadsheet with 1 tab.
2. PDF with the Intro and Brief in English.
3.PDF with the Intro and Brief in Spanish.
To submit your two-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 will undergo validation 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 requirements, 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 19”, along with screenshots from your report.
3. Include a summary of your report's key insights and publish it to the web or NovyPro link.
4. Use the hashtags #FP20Analytics, #FP20AnalyticsE_Commerce KPIsAnalysis, #builtwithzoomcharts, tag @Federico Pastor and @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.