Registration Open
Registration Open
01 September | 12:00
-
Reset your password
We'll email you instructions on how to reset your password
Build an E-commerce Power BI Dashboard
Sep 01 - Sep 29, 2026 | EDT
Build a Power BI report that reveals what drives ecommerce profitability. Analyze contribution margins, returns, promotions, customer cohorts, fulfillment performance, and stock availability to help marketing and operations teams make smarter decisions.
Timeline
Workshop | How to Build an E-commerce Profitability Dashboard in Power BI
Workshop | How to Build an E-commerce Profitability Dashboard in Power BI
10 September | 07:00
-
Entry Submission Deadline
Entry Submission Deadline
24 September | 21:00
01 September - 24 September
Webinar | Top 5 E-commerce Profitability Power BI Dashboards
Webinar | Top 5 E-commerce Profitability Power BI Dashboards
29 September | 07:00
01 September - 24 September
Submitted Reports
About Challenge
How to Participate
The Brief
Judging Criteria
Timeline
Dataset
Past challenges
Winner of the challenge
All Submissions
About 4U Reports Challenge
Improve your Power BI data visualization skills and demonstrate strong professional credibility by building 4U Reports.
In this challenge, you’ll be provided with a business case dataset to analyze and visualize in Power BI. Each month, a new dataset is released, allowing you to build high-demand Power BI reports and dashboards for your portfolio, gain recognition within a community of 20k+ BI professionals, and win amazing prizes from ZoomCharts.
🏆
1st place $300Amazon gift card
🥈
2nd place $200Amazon gift card
🥉
3rd place $100Amazon gift card
Benefits of participation:
- Workshops & 1:1 Mentoring: Learn directly from experienced Power BI professionals through a live workshop on report-building best practices, join 1:1 mentoring sessions to review your report, and receive tailored advice.
- Get Personal Feedback: Every participant receives detailed, personalized feedback on their report—a valuable opportunity to improve based on expert recommendations.
- Free Power BI Accounts for Using Power BI Desktop: If you don’t have a Microsoft work or school account, you can acquire your own ZoomCharts account for building your challenge report without restrictions.
- Free ZoomCharts Visuals License: All participants get a ZoomCharts Developer License worth hundreds of dollars, providing full access to the Drill Down PRO visuals library.
- Free Report Downloads: Each challenge participant with a validated report will receive 5 free downloads from the Power BI Report Gallery.
Prize Pool:
🏆 The best 3 overall reports will receive a $300 / $200 / $100 Amazon gift card.
⭐ Being selected for the Top 5 will grant you 10 additional free downloads from the Power BI Report Gallery.
📜 The creators of the Top 5 reports, honorable mentions, and most-liked reports will receive official certificates from ZoomCharts.
Winners Announcement
On August 27, the Top 5 reports and prize winners will be announced during the live webinar.
Webinar recordings
How to participate in the challenge
Follow these steps to register, build your Power BI report, submit your entry, and compete for prizes.
1
Register for the Challenge
- Register using the form above.
- Download the challenge dataset using the "Get the Dataset" button.
- Activate your free ZoomCharts Drill Down Visuals Developer License for Power BI. If you have your own Microsoft account, select "See My License" and follow the setup video or step-by-step instructions.
- If you don’t have a work or school Microsoft account, select "See My Account" to activate a free Microsoft account provided by ZoomCharts exclusively for challenge participants.
2
Build Your Report in Power BI
- Add ZoomCharts visuals from the Power BI visuals library or Microsoft Marketplace.
- Add your ZoomCharts license to Power BI Desktop.
- Build your Power BI report using the challenge dataset.
- Your report must include at least two (2) ZoomCharts Drill Down Visuals on at least 1 report page.
3
Improve Your Report and Learn
- Join the challenge workshop to learn how to use ZoomCharts visuals and the dataset.
- If you need help, book a free consultation with the ZoomCharts team.
- Browse the Template Gallery for inspiration and ideas.
4
Submit Your Challenge Entry
Upload your report in .pbix format using the submission form on this page.
If your report does not meet the challenge requirements:
You will receive an email explaining what needs to be fixed. You can update your report and submit it again.
Validation timeline:
- Your report will be reviewed within 1-2 business days.
- Once validated, you will receive a Publish to Web link you can share publicly or add to your portfolio.
- You will also receive personalized feedback from the evaluation team within 1-2 business days.
- Use this feedback to improve your report and resubmit before the deadline.
Note: You can resubmit your entry as many times as needed before the final deadline.
5
Finalize Your Participation to Compete for Prizes
- Share a LinkedIn post showing your finished report as an image, screenshot, or video.
- Tag @ZoomCharts and use the hashtags #4UReport and #builtwithzoomcharts.
- Follow ZoomCharts on LinkedIn.
6
Attend the Live Closing Webinar
The ZoomCharts team reviews and analyzes the Top 5 Mini Challenge entries during the live webinar. You will learn best practices, improvement tips, and see how others solved the challenge. Winners will be announced during the live webinar and afterward on the ZoomCharts LinkedIn page.
Report Requirements
Tool
Power BI
Recommended length
Up to 3 pages
Including drill-through pages
Canvas size
16:9 or 1920 × 1080
Power BI E-commerce Profitability Analytics Challenge
Build an interactive Power BI e-commerce profitability dashboard that helps business leaders understand sales performance, contribution margin, customer behavior, returns, inventory availability, and the operational costs behind each result.
Challenge Brief
In this ZoomCharts Power BI Challenge, participants will work with a European e-commerce dataset containing more than 9,000 order-line records from 2024 to 2025. The data connects transactions with products, customers, geographic markets, promotions, sales channels, fulfillment providers, return reasons, and customer lifecycle stages.
The dataset follows the complete path from gross sales to contribution margin. It includes discounts, refunds, shipping revenue, product costs, outbound and return shipping costs, fulfillment costs, payment fees, allocated marketing costs, return processing costs, lost sales value, and return losses.
The goal is to design a clear, decision-ready Power BI report that explains not only what the business sold, but what remained profitable. Your dashboard should help stakeholders identify profitable growth opportunities, understand margin pressure, evaluate promotions and channels, and discover where returns, delivery performance, or stock availability are reducing business value.
Ideas to Visualize in the Dashboard
Sales and profitability
How are gross sales, net sales, contribution revenue, and contribution margin changing over time?
Products and categories
Which departments, categories, subcategories, products, brands, and price tiers generate the strongest revenue and margin?
Returns and financial impact
Which products, customer groups, and return reasons drive refunds, reverse-logistics costs, processing costs, and return losses?
Promotions and discounts
Which campaigns and discount levels support profitable growth, and where do promotions increase sales while weakening contribution margin?
Customers and cohorts
How do customer segments, loyalty tiers, acquisition channels, age groups, cohorts, and lifecycle stages differ in sales and profitability?
Sales channels and markets
How do the website, mobile app, marketplace, and social commerce channels perform across European countries, regions, and cities?
Fulfillment and delivery
How do fulfillment models, centers, carriers, and service levels compare by cost, delivery speed, and on-time performance?
Inventory and lost sales
Where are low stock, partial availability, and backorders causing cancelled orders, unfulfilled demand, and lost sales value?
Design Focus
Combine e-commerce data storytelling with intuitive Power BI report design. Use ZoomCharts Drill Down Visuals to help users explore performance over time, compare products, customers, channels, promotions, and markets, and move smoothly from executive KPIs to detailed insights about contribution margin, returns, fulfillment, and inventory availability.
Judging Criteria
Each submission is evaluated based on four main criteria: Inspiring, Intuitive, Interactive, and Insightful. These dimensions ensure that the solution is visually compelling, easy to understand, engaging to use, and capable of delivering valuable insights.
Inspiring
Max 15 ptsHow visually clear, modern, and purposeful the report looks.
- Visually Appealing Design: Is the design harmonious, with a modern color palette, consistent formatting, and a clear presentation of information?
- Clear and Focused Visualizations: Are only the necessary visualizations used, avoiding clutter and keeping focus on key insights?
- Readability: Are color contrasts appropriate and text elements easy to read across different devices and screen sizes?
Intuitive
Max 15 ptsHow clear and easy it is to understand the report at a glance.
- Logical Navigation: Is the report organized with intuitive navigation paths, reset options, and a structure that allows users to explore at their own pace?
- Storytelling through Data: Does the report present data in a logical and compelling narrative that supports decision-making?
- Streamlined Information: Is the report focused on key data without overwhelming the user with unnecessary details?
- Tooltips and Labeling: Are tooltips, titles, and legends clear, helpful, and supportive of understanding without cluttering the design?
Interactive
Max 15 ptsHow engaging and seamless the report exploration and interaction with data feels.
- Dynamic User Controls: Are slicers and interactive elements designed so users can easily adjust and explore different data views?
- Cross-Chart Integration: Are charts connected in a way that filtering and interactions feel smooth and unified across the report?
- Drill-Down Functionality: Can users intuitively dive deeper into data layers to explore additional details and insights?
- Guided Learning Aids: Are there helpful tutorials, hints, or onboarding elements that support users in understanding and navigating the report?
Insightful
Max 15 ptsHow accurate, complete, and meaningful the data is in driving decisions.
- Depth of Analysis: Does the analysis provide meaningful insights and fully address the problem using effective methods?
- Data Accuracy: Is the data consistent across visuals, and are calculations and aggregations applied correctly?
- Performance Optimization: Is the report optimized for fast loading and smooth performance, even with larger datasets?
- Data Cleanliness: Is the data well-prepared, free from redundancies or gaps, and structured to support reliable analysis?
Timeline
Workshop | How to Build an E-commerce Profitability Dashboard in Power BI
Workshop | How to Build an E-commerce Profitability Dashboard in Power BI
10 September | 07:00
-
Entry Submission Deadline
Entry Submission Deadline
24 September | 21:00
01 September - 24 September
Webinar | Top 5 E-commerce Profitability Power BI Dashboards
Webinar | Top 5 E-commerce Profitability Power BI Dashboards
29 September | 07:00
01 September - 24 September