Google Data Analytics Certificate Project
Summary
A structured analytics and visualisation project undertaken as part of the Google Data Analytics Professional Certificate. The programme focuses on practical data analysis workflows including SQL querying, Python-based analysis, dashboard development in Tableau, and communicating findings through stakeholder-focused reporting.
The Challenge
The objective is to analyse a real-world business dataset, extract meaningful trends, and translate raw data into actionable insights through both visual dashboarding and concise written recommendations. The broader goal is to refresh and formalise modern analytics tooling knowledge while strengthening practical SQL, Python, and business intelligence workflows.
Product Rationale
Technical Skills Refresh
Used the programme to reinforce core analytical tooling including SQL and Python while revisiting structured data manipulation, querying, and transformation techniques in a modern analytics workflow.
Dashboard Development
Expanded business intelligence capability by learning Tableau and applying dashboard design principles to present findings in a clear, stakeholder-friendly visual format.
Insight Communication
Focused not only on analysis itself, but on translating technical findings into concise written recommendations and commercially relevant business insights.
Tech Stack
Key Decisions
Practical Tool Exposure: Selected the course primarily as a structured refresher in analytics tooling rather than introductory learning, helping formalise prior experience while filling gaps in Tableau exposure.
Portfolio-Focused Output: The final capstone deliverable was chosen for inclusion due to its tangible outputs, including a completed dashboard and written case study that demonstrate end-to-end analysis capability.
Project Notes
No two projects solve the same problem, so each case study emphasises different aspects of delivery depending on what was most relevant to the challenge. Supporting visuals and implementation details are included here to provide additional context behind the final outcome.
Visuals
