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 and time-series decomposition for trend identification.
Python Pandas Matplotlib RFM 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.

Key Techniques: Designed and optimized data models to enable accurate profit margin calculations and implemented drill-through reporting for detailed category-level insights.
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 Data Modelling Excel

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.
Data Cleaning Data Exploration Excel PowerBI Desktop PowerBI Service Data Modelling DAX

Energy Consumer Survey Analytics

Served as client-facing data consultant, translating complex survey data into clear insights and dashboards to support stakeholder advocacy and decision-making.

Problem Solved: Raw survey data from thousands of respondents needed visual insights for policy decisions.
Client Engagement Conflict Managment Business Requirements Power BI Excel Power Query Machine Learning RapidMiner

Accounts Payable Automation

Worked with developers to implement an automated accounts payable system. Ensured finance operations remained accurate and efficient throughout the project.

Problem Solved:

Maintained smooth financial workflows, managed stakeholder collaboration, and supported operational continuity during system changes.

Business Process Modelling Accounts Payable Management Supplier Relationship Management SharePoint Power Automate Contingency Planning for Digital Transition