Personal Projects

Independent projects from my GitHub portfolio, built to sharpen my analytical skills.

Advanced Sales & Customer Analytics

End-to-end analysis of the Online Retail II dataset using Python. This project covers data cleaning, exploratory data analysis, RFM (Recency, Frequency, Monetary) customer segmentation, cohort analysis, and time-series sales forecasting to uncover actionable business insights.

Key Techniques: RFM segmentation to classify customers into meaningful groups, cohort analysis to track retention, and time-series decomposition for trend identification.
Python Pandas Matplotlib RFM Analysis Cohort Analysis

Melbourne Retail Sales & Profit Analysis

Interactive Power BI dashboard analysing Melbourne retail data to uncover sales trends, profit margins, and regional performance across product categories and time periods. Built with DAX calculations and data modelling best practices.

Key Techniques: DAX measures for profit margin calculations, drill-through pages for category-level detail, and time intelligence functions for trend analysis.
Power BI DAX Data Modelling Power Query

Health & Lifestyle Data Analysis

Comprehensive Excel analysis exploring correlations between health metrics, lifestyle habits, and wellness outcomes. Uses pivot tables, conditional formatting, and charts to present findings in a clear, visual format.

Key Techniques: Pivot tables for multi-dimensional analysis, data validation and cleaning, and chart-based storytelling for non-technical audiences.
Advanced Excel Pivot Tables Data Cleaning Charts

Professional Work

Projects completed during my professional roles, solving real business challenges with data.

Construction Project Financial Dashboard

Built an interactive Power BI dashboard consolidating financial data across active construction projects, providing real-time visibility into project profitability and costing.

Problem Solved: Senior management needed a unified view of project profitability across multiple active sites.
Power BI DAX Excel SQL Server

Python Sales Data Analysis Pipeline

Developed an automated Python pipeline to clean, analyse, and visualise sales data across multiple business divisions, replacing a manual process.

Problem Solved: Manual data cleaning consumed significant analyst hours and was prone to human error.
Python Pandas Matplotlib Jupyter

Energy Consumer Survey Analytics

Analysed large-scale consumer survey data for Energy Consumers Australia, creating interactive dashboards for non-technical stakeholders.

Problem Solved: Raw survey data from thousands of respondents needed visual insights for policy decisions.
Power BI Excel Power Query

Workforce Capacity Planning Dashboard

Designed weekly forecasting dashboards for workload management across business divisions, improving visibility into upcoming work.

Problem Solved: Division managers lacked visibility into upcoming workloads and quote conversion rates.
Power BI DAX SQL Power Automate