Sales & Profitability Dashboard 6 New Zealand Transactional Data (Power BI)

End-to-end Power BI analytical project covering data cleansing, modelling, DAX development, visualisation and business recommendation. Developed an interactive Power BI sales and profitability dashboard analysing 499 transactions across New Zealand, providing visibility into revenue, profit, product and regional performance. Transformed and cleansed a 7-field transactional dataset using Power Query, performing data-quality checks, data-type standardisation and preparation for analytical reporting. Designed a structured date-based data model and developed 15+ DAX measures and KPIs covering Total Sales, Total Profit, Profit Margin %, Orders, Average Order Value, Average Profit and growth metrics. Built KPI and trend analysis to monitor sales and profit performance over time, enabling identification of periods of increased or decreased commercial performance. Developed regional and category-level analysis to identify top and underperforming markets, supporting evidence-based recommendations around sales focus and resource allocation. Analysed profit margin by product and category, enabling comparison between high-revenue products and products delivering stronger profitability. Implemented interactive slicers, drill-downs and cross-filtering, allowing users to move from high-level KPIs into region 0 category 0 product-level performance. Created monthly sales and profit growth measures using DAX time-intelligence techniques to support performance comparison and trend monitoring. Produced a management-ready dashboard and translated analytical findings into 5+ data-driven insights and 3 business recommendations, demonstrating the ability to convert raw transactional data into actionable business intelligence.