Google Data Analytics Certificate Study Bundle, SQL, Python, Excel Practice (Digital Download)

Studying for the Google Data Analytics Professional Certificate? This bundle helps you actually understand the material, practise every tool on realistic data, and finish with a portfolio project you can talk about in interviews.

It's built around the programme's current 9-course curriculum — spreadsheets, SQL, Python and Tableau — and it's 100% original. No copied course content, no graded answers: just clear explanations and a LOT of hands-on practice.

★ WHAT'S INCLUDED (260+ pages + files)

▸ ILLUSTRATED STUDY GUIDE (52 pages)
All 9 courses explained in plain English, in course order: diagrams, real business examples, 50+ memory hooks, common mistakes, quick-recall questions and a one-page cheat card for every part.

▸ SQL PRACTICE WORKBOOK (97 pages · 120 exercises)
A realistic 6-table coffee-chain database (27,068 orders). Exercises from your first SELECT to JOINs, CASE, subqueries, CTEs and window functions. Every exercise shows the expected row count; every solution shows the real output and explains why it works. SQLite ↔ BigQuery translation table included. Blank and solution .sql files.

▸ SPREADSHEET & DATA-CLEANING WORKBOOKS (Excel + Google Sheets)
Exercise and solution files: clean 418 messy customer records (TRIM, PROPER, SUBSTITUTE, COUNTIF, VLOOKUP mapping), build calculated columns and INDEX/MATCH lookups, answer business questions with SUMIFS/COUNTIFS/AVERAGEIFS — with instant ✓ Correct / ✗ Not yet checks — plus 5 pivot-table tasks and data-validation practice.

▸ PYTHON PRACTICE PACK (46 exercises)
Exercise + solution notebooks (Jupyter or Google Colab — nothing to install) and a 29-page guide: Python basics, NumPy, pandas, data cleaning, groupby & merge, matplotlib charts.

▸ VISUALISATION & STORYTELLING KIT (16 pages + editable slides)
Chart chooser, chart gallery built from real data, before/after makeovers, accessibility checklist, dashboard-planning and storyboard worksheets, a step-by-step Tableau Public build, and an editable 10-slide data-story presentation template (.pptx).

▸ PORTFOLIO PROJECT: "PULSEFIT — WHY ARE MEMBERS LEAVING?"
An original business case with 3,200 members, 26,000 activity rows and realistic data problems. Project brief, starter notebook, Spreadsheet/SQL/Python tracks, full solution guide, SQL solutions, an example executive report, a Word report template and a 2-minute interview pitch.

▸ 180 KNOWLEDGE-CHECK QUESTIONS
160 questions across all 9 parts + a 20-question final mock — every answer explained.

▸ STUDY PLANNER & CAREER TOOLKIT
30/60/90-day plans, a digital progress tracker (.xlsx), 100-term glossary, résumé guide with 40 action verbs and career-changer examples, portfolio checklist, 30 interview questions with model answers, and a responsible-AI prompt library.

▸ DATASETS
Bean & Bloom Coffee Co. (SQLite database + CSVs), messy raw files for cleaning practice, and the PulseFit project data.

★ WHY THIS BUNDLE?
✔ One realistic company across every tool — the numbers match in SQL, Sheets, Python and Tableau
✔ Practice-first: 120 SQL + 46 Python exercises + 180 questions
✔ Self-checking: expected outputs and ✓ checks so you know you're right
✔ Memorable: memory hooks, cheat cards, diagrams
✔ Job-ready: a portfolio project, report template, slides and interview prep

★ WHO IT'S FOR
• Learners taking (or about to take) the Google Data Analytics Certificate on Coursera
• Career changers who want more hands-on practice than videos alone
• Anyone preparing for junior data analyst, reporting or business analyst interviews
No experience needed — exercises are labelled Starter, Core and Stretch.

★ FILE FORMATS
PDF (US Letter, prints fine on A4) · XLSX (Excel, Google Sheets, LibreOffice) · IPYNB (Jupyter, Google Colab) · SQLite + CSV · PPTX (PowerPoint, Google Slides, Keynote) · DOCX (Word, Google Docs)
Works on Windows, Mac and Chromebook. All software used has a free option.

★ HOW TO GET IT
After purchase, download the ZIP from your Etsy Purchases page, unzip it on a computer, and open 00_START_HERE.pdf.