Want to build professional Power BI reports and grow your portfolio?

Prizes 🏆

• The best report using ZoomCharts visuals will receive a $300 Amazon Gift Card.
• Being selected in the Top 5 grants you +10 free downloads from the Power BI Report Gallery.
• All FP20 Analytics challenge participants also compete for prizes from Skillwave, The Data Vis Force, and Enterprise DNA.

Live Winner Announcement

Winners will be announced during a special live webinar. Join the winner announcement and top submissions review to see standout reports, learn from the best entries, and celebrate the challenge results.

Report Requirements

• To participate in this challenge, create a Power BI report that includes at least two ZoomCharts Drill Down Visuals on one report page.
• Reports are limited to a maximum of two pages.
• Use a 16:9 Power BI canvas or a Full HD canvas at 1920 x 1080 pixels.

For details on how entries will be evaluated, please refer to the Judging Criteria section above.

Challenge Brief

A travel company is preparing its Summer 2026 holiday portfolio. Its commercial, product, marketing, and customer advisory teams need a clear way to compare destinations, understand package cost drivers, and match different traveller segments with suitable holiday options.

In the FP20 Analytics ZoomCharts Challenge 40, participants are tasked with using a detailed summer holiday dataset to build an interactive Power BI travel analytics dashboard that supports confident, data-driven decisions.

The goal is to create a decision-ready report that helps business users evaluate holiday packages, identify attractive destination and customer-segment combinations, and balance affordability, travel convenience, weather, visitor pressure, and traveller preferences.

The Summer 2026 Holiday Dataset contains 13 sheets and approximately 12,029 data rows. It covers 21 destinations across Spain, Portugal, France, and Italy, with travel originating from London, Manchester, Dublin, Berlin, and Amsterdam.

The available analysis areas include:

• Estimated total and per-person holiday costs, including flights, baggage, accommodation, food, local transport, attractions, and tourist taxes
• Six traveller profiles, six accommodation types, and three-, five-, and seven-night trips
• Departure dates, flight duration, direct-flight availability, and number of stops
• Temperature, rainfall, sunshine, humidity, UV index, beach weather, weather comfort, and extreme heat risk
• Visitor volumes, overnight stays, occupancy, accommodation capacity, and tourism pressure
• Destination suitability scores covering beaches, culture, food, nightlife, shopping, family activities, romance, outdoor activities, accessibility, public transport, safety, and value for money

Recommended Focus

• Build a clear narrative from portfolio-level performance to individual destination and package recommendations.
• Use interactive filtering and drill-down to compare origins, destinations, dates, traveller types, accommodation, and trip durations.
• Explain the trade-offs behind each recommendation instead of relying on a single overall ranking.
• Use ZoomCharts Drill Down Visuals to make multi-level exploration fast, intuitive, and useful for business users.
• Finish with practical recommendations for product planning, customer targeting, destination promotion, or package positioning.

Read "How to Participate" Section above

FP20 Analytics Challenge 40 is delivered in collaboration with ZoomCharts, giving participants an opportunity to practise building interactive Power BI reports that help business users explore data quickly and intuitively.

Each report is evaluated based on three main criteria: Intuitiveness, Interactivity, and Insightfulness. These factors ensure that the report is accurate, functional, user-friendly, and ready to be presented to end users.

Total possible score: 45 points. A strong submission should be easy to understand, smooth to explore, and rich enough to support meaningful decisions.