It enables stakeholders to analyze sales trends, market share, and growth drivers across different regions (EMEA and LAWK), product categories, and different timeframes.

Overall RTD Coffee Performance

Brand Performance Breakdown (Total Value and Volume, % Change, Value and Volume Share, Share Change)

Contribution to Value Growth

Contribution to Share Growth

Product Deep Dive

Momentum analysis (Period vs. Year Ago), among others.

The development of this project encompassed the complete data lifecycle. I utilized Power Query for robust ETL (Extract, Transform, Load) processes to cleanse, structure, and integrate raw sales and market data. A well-designed data model within Power BI ensures efficient and accurate analysis by establishing clear relationships between data entities.

Furthermore, DAX (Data Analysis Expressions) was critical in creating sophisticated calculated measures and columns, enabling the dynamic computation of essential KPIs such as percentage change, market share, and contribution to growth. These DAX calculations drive the insightful visualizations – including bar charts, line charts, and tables – which translate complex data into actionable insights for stakeholders.

This project effectively showcases my end-to-end proficiency in Power BI, from meticulous data preparation and the creation of a sophisticated data model to the application of advanced DAX for impactful analytics and clear data visualization, ultimately providing valuable intelligence to support strategic business decisions.