DataCareerHubLearn · Practice · Progress
Explore learning
DataCareerHub
Explore learning
Learning/Projects and Career Preparation
Module 02 · Free practice

Data Analyst Portfolio Project

Extend existing analysis work into a decision brief, tested report and explanation.

3 published lessons2h 55m suggestedintroductoryFiles + exercises + worked solutions
Start the first lesson →Download the practice pack ↓
Turn knowledge into practice

A method you can explain.

Work through the reasoning, attempt the task and compare the separate solution. Keep your source copy unchanged and save your own evidence locally.

Before you start: Complete the earlier modules in this track; review the linked Foundations material where you need a refresher.

The suggested study time includes exercises. Use a spreadsheet or text editor for introductory tasks; code lessons use a local Python environment with the supplied setup guide. This website does not run arbitrary Python or upload your files.

Build on what you already know.

Related learning and recommended prerequisites. These links do not grant access or reset progress.

The complete module

Three lessons. One connected workflow.

Learn + practise + review
01

Convert a stakeholder question into scope

Detailed explanation, practical exercise and worked solution.

55 min02

Integrate SQL/Python analysis with reporting

Detailed explanation, practical exercise and worked solution.

55 min03

Write a decision note and defend the limits

Detailed explanation, practical exercise and worked solution.

65 min
Your local practice desk

Real tasks.
Inspectable evidence.

Download the complete pack or choose individual files. Start with the dictionary and worksheet. Templates are deliberately unfinished; the separate worked reference contains explanations and solutions.

All data are fictional. Downloadable code uses local files and fresh output paths. Read the setup guide before running it. The offline HTML reference is static and does not execute Python or save progress.

Open the worked reference ↗
Complete offline practice pack18 files with source, code, worksheets, templates and worked evidence.
Download ↓
OrdersFictional source fixture; keep an unchanged copy and read the dictionary.
Download ↓
Order linesFictional source fixture; keep an unchanged copy and read the dictionary.
Download ↓
ProductsFictional source fixture; keep an unchanged copy and read the dictionary.
Download ↓
ProductsFictional source fixture; keep an unchanged copy and read the dictionary.
Download ↓
SetupFictional source fixture; keep an unchanged copy and read the dictionary.
Download ↓
Source dictionary & timingGrain, key types, units, population, partitions and limitations.
Download ↓
Complete worked local Python referenceRename this copy to worked_lab.py; uses only this module’s helpers and no website credentials.
Download ↓
Pinned reference requirementsPython 3.12.14; install only into your own local environment.
Download ↓
Executed reference resultsObserved on the unchanged fictional fixture; changed inputs require a new result.
Download ↓
Learner implementation scaffoldIntentional TODOs; not a complete executable solution.
Download ↓
Three practical assignmentsAttempt first; save your own evidence locally.
Download ↓
Explained worked solutionsCase-specific reasoning, units and limitations for each exercise.
Download ↓
Evidence and handover templateEditable prompts; no fabricated completion or instructor feedback.
Download ↓
Assignment criteria and self-reviewUse actual artifacts; opening a lesson does not establish mastery.
Download ↓
Local setup and exact commandWorking-copy, environment, rerun and verification instructions.
Download ↓
Complete offline lesson referenceExplanations, local code, tasks and expandable solutions; no automatic execution.
Download ↓
Start here and file guideFile purposes, local workflow and explicit access/verification limits.
Download ↓
File provenanceHashes for the supplied fixture and references before ZIP packaging.
Download ↓
Before moving on

Can someone reproduce your work?

Use the evidence-based self-review to check your method, validation and explanation. Keep unresolved questions visible. This is guided practice, not certification or production approval.

Begin Module 02 →

Return to the complete course ↗

Next module: Data Scientist Portfolio Project →

Open-book module review ↗ · Project Lab ↗

Saved reviews require an active existing learner account; lesson checks remain unsaved practice.

Explore practical lessons, worked examples and projects. Follow a published path, practise the method and build work you can explain.