Data Engineer & BI Analyst

Heureka (Science Center) Report
​This project presents a real-world case study analyzing ticket sales for the Finnish Science Center. The report is designed to uncover the underlying factors driving changes in sales volume and revenue, with a particular focus on how different product categories contribute to increases or decreases over time. Leveraging dynamic measures and interactive visualizations, the analysis explores sales trends across multiple dimensions—including weekdays, months, and ticket categories. Users can easily drill through to detailed views, enabling in-depth exploration and actionable insights to support data-driven decision-making.
​
Heureka Case Insights:
In 2024, total sales increased by 20% compared to 2023. Notably, 71% of this growth came from a newly introduced ticket product, which contributed €468.6K in sales. However, pre-sold tickets experienced the largest decline, with an overall drop of about 20%—and a sharp 40% decrease in July. This suggests that the new ticket categories, such as the Service and Museum Card, were successful, but further analysis is needed to understand the significant decline in pre-sold ticket sales.
Overview Page
-
Key metrics at a glance: Instantly track total sales, volume, and year-over-year growth with clear card visuals.
-
Category performance: Compare revenue across different product categories to identify top performers.
-
Detailed breakdown: See which products drive the most value with ranked bar charts.

Seasonal Fluctuations
-
Weekly and monthly sales trends: Instantly compare 2023 and 2024 performance with clear, interactive visuals.
-
Year-over-year analysis: Track sales growth and seasonal patterns at a glance.
-
Actionable insights: Visualize key sales peaks and compare results across time periods for better decision-making.

Detailed Comparison
-
Detailed year-over-year comparison: Drill through to compare selected month in 2024 and corresponding month in 2023 by product in more detailed level, with key KPIs highlighted for quick insights.
-
Top products at a glance: See the top 5 ticket types driving sales, with detailed breakdowns of volume and revenue changes.
-
Actionable trends: Track overall sales growth and identify which products saw the biggest increases or declines.

View the full interactive report in Power BI Service here.