Dataset: [Add dataset source — e.g. HRIS export, department, employment type, tenure, exit reason]

Tools & methodology: Power BI for modelling and visuals; DAX measures for attrition rate, headcount trend, and funnel conversion.

Challenges & solutions: Working through data-quality gaps and unclear metric definitions early, then locking a single source of truth before building visuals.

Key insights: [Add 2–3 headline findings — e.g. which department/segment drives attrition]

Recommendations: [Add specific, actionable recommendations tied to the findings above]

Business impact: [Add measurable outcome once available, or mark as pending stakeholder feedback]

Dataset: [Add dataset source — e.g. admissions log, department, length of stay, resource type]

Tools & methodology: SQL for extraction and cleaning; Power BI for the operational dashboard and drill-through views.

Challenges & solutions: Working through data-quality gaps and unclear metric definitions early, then locking a single source of truth before building visuals.

Key insights: [Add 2–3 headline findings about flow or utilisation patterns]

Recommendations: [Add specific, actionable recommendations tied to the findings above]

Business impact: [Add measurable outcome once available]

Dataset: [Add dataset source — e.g. POS transaction export, store, product, date, revenue]

Tools & methodology: SQL for aggregation; Excel for pivot analysis and the final interactive dashboard.

Challenges & solutions: Working through data-quality gaps and unclear metric definitions early, then locking a single source of truth before building visuals.

Key insights: [Add 2–3 headline findings — e.g. top-performing products, peak hours, seasonality]

Recommendations: [Add specific, actionable recommendations tied to the findings above]

Business impact: [Add measurable outcome once available]

Dataset: [Add dataset source — e.g. exported streaming history]

Tools & methodology: Python (Pandas) for cleaning and feature extraction; Power BI for the interactive dashboard.

Challenges & solutions: Working through data-quality gaps and unclear metric definitions early, then locking a single source of truth before building visuals.

Key insights: [Add 2–3 headline findings about listening patterns]

Recommendations: [Add any follow-up analysis worth pursuing]

Business impact: Demonstrates end-to-end analytics on a personal dataset — from raw export to a polished, explorable dashboard.

Dataset: [Add dataset source and governance domain — e.g. policy compliance log, risk register]

Tools & methodology: SQL for data structuring; Power BI for the governance reporting layer.

Challenges & solutions: Working through data-quality gaps and unclear metric definitions early, then locking a single source of truth before building visuals.

Key insights: [Add 2–3 headline findings]

Recommendations: [Add specific, actionable recommendations]

Business impact: [Add measurable outcome once available]

Dataset: [Add dataset/report type this automation supports]

Tools & methodology: Advanced formulas, pivot tables, and (optionally) VBA macros to remove repeated manual steps.

Challenges & solutions: Working through data-quality gaps and unclear metric definitions early, then locking a single source of truth before building visuals.

Key insights: [Add time saved or error reduction once measured]

Recommendations: [Add next automation candidates]

Business impact: Frees up analyst time for interpretation rather than repetitive formatting.

Dataset: [Add dataset/domain — e.g. sales, operations, clinical records]

Tools & methodology: PostgreSQL/SQL Server for schema design; SQL for joins, window functions, and aggregate reporting queries.

Challenges & solutions: Working through data-quality gaps and unclear metric definitions early, then locking a single source of truth before building visuals.

Key insights: [Add 2–3 headline findings the queries surfaced]

Recommendations: [Add schema or query optimisations worth documenting]

Business impact: A durable data foundation that other dashboards and reports can build on.