

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 the FP20 Analytics Sales, Profitability & Discount Effectiveness Challenge, where analytics meets retail strategy, promotional planning, and commercial decision-making. You’ll explore three holiday seasons across eight European cities, covering Black Friday, Cyber Monday, Christmas, New Year, and non-campaign trading.
In this challenge, you’ll step into the role of a Retail Data Analyst, Commercial Performance Manager, or Pricing and Promotions Analyst, tasked with answering a question every retailer faces: Which promotions delivered sales volume and healthy margins, and where did the extra volume come with thinner margins?
Your analysis should follow the money from gross sales through to contribution profit. Show how discounts, refunds, product costs, fulfilment, payment fees, return handling, and campaign spend shape the final result. The strongest submissions will explain why a campaign, product, or city can rank highly for sales and fall down the rankings once those costs are taken into account.
Compare performance across discount bands, product categories, customer segments, cities, and online and in-store channels. Look at how the same campaign performed from one season to the next, and use daily figures when comparing events of different lengths. Where deeper discounts coincide with higher sales volumes, examine whether those sales also came with healthy contribution margins and manageable return rates.
Your final recommendations should help decision-makers choose which campaigns to prioritise, which discount bands to revisit, and which product and market combinations to test next season. Ground each recommendation in observed performance and explain what a future test would need to establish about the effect of the discount.
This challenge is an opportunity to show how Power BI can turn transaction-level data into an interactive report that helps a retail team decide where to spend its next promotional euro.
1. How did net sales, contribution profit, and contribution margin change across the 2023/24, 2024/25, and 2025/26 holiday seasons?
2. Which product categories and subcategories generated the most net sales, and how did their rankings change when measured by contribution profit?
3.Which products generated high net sales but delivered low or negative contribution margins?
4. How did net units sold, net sales, and contribution margin vary across discount bands, including sales with no discount?
5. Within each product category, which discount bands recorded the highest contribution profit per net unit sold, and how much sales volume did they represent?
6. Which campaigns delivered the highest contribution profit per day after allocated campaign spending, and how did they compare with non-campaign trading in the same holiday season?
7. How did each recurring campaign type—Black Friday, Cyber Monday, Christmas, and New Year—perform across the three holiday seasons in terms of net sales, weighted discount rate, and contribution margin?
8. Which cities had the highest net sales, and which had the highest contribution margin? Where did the rankings differ most?
9. How did online and in-store sales compare on contribution profit per order, and how much did fulfilment costs and payment fees account for in each channel?
10. Which customer segments received the highest weighted discounts, and how did their contribution margins compare within the same product category?
11. Which products and sales channels had the highest unit return rates, and where did refunds and return-handling costs have the greatest impact on profitability?
12. Which categories recovered the smallest share of the original cost of returned units, and how did that affect their net cost of goods sold?
13. How did discounts, refunds, net cost of goods sold, fulfilment, payment fees, return handling, and campaign spend reconcile gross sales to contribution profit? Which deductions accounted for the largest share of gross sales?
14. Within each sales channel, how did average order value and contribution profit per order differ between weekdays and weekends during the same holiday season?
15. Based on the observed results, which campaign, product, and discount-band combinations would you prioritise, adjust, or test next season, and what evidence supports each recommendation
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 43” and screenshots from your report.
3. Include a summary of your report's key insights.
4. Use the hashtags #FP20Analytics, #FP20Profitability and Discount Effectiveness, #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.