Free Practice Projects
Real-world data analytics projects, free to practice
Scenario-based projects with downloadable datasets across Business Analytics, Excel, SQL, Tableau, and Power BI. Each is written like a real client brief with verifiable outputs. The Advanced ones add a graded skills check that saves to your dashboard, so you can prove the judgment the work really demands.
Download the dataset
Real CSVs from genuinely messy exports. Create a free account once and every dataset unlocks.
Work the brief
Follow the tasks like a real client engagement.
Check your numbers
Each project has verifiable expected outputs.
Beginner3 projects
Start here if this is your first analytics project.
Clean and analyze a sari-sari store's messy sales export
A real cleanup job: duplicates, inconsistent names, and blank cells stand between you and the store owner's first sales report.
Start this projectRescue a candle shop's merged multi-platform orders file
Three platform exports pasted into one spreadsheet: duplicates, stray headers, three date formats, peso signs stored as text, and payment labels typed six ways. Untangle it all.
Start this projectAnswer a coffee-gear seller's business questions in SQL
JOINs, GROUP BY, and date functions on a Shopee-style store's real questions: repeat buyers, top provinces, and best months.
Start this projectIntermediate4 projects
Multi-step briefs with real business questions.
Compute lates, overtime hours, and OT pay from a biometric log
Turn a raw time-in/time-out export into the monthly attendance summary HR actually asks for.
Start this projectFind SLA breaches in a telco support queue
Datetime math, CASE logic, and NULL handling on the queue data every BPO ops manager lives in.
Start this projectBuild an executive sales dashboard for a retail chain
One page, four regions, twelve months: the interactive dashboard a VP actually reads.
Start this projectDiagnose employee attrition with DAX measures
Power Query, DAX, and drill-downs on the question every People team asks: who is leaving, from where, and why?
Start this projectAdvanced6 projects
Portfolio-grade work, each with a graded skills check.
Scope and prepare a subscription churn analysis
Before a single chart, do the hard part: turn a vague 'why are we losing subscribers' into a precise question, then join and prepare two messy exports into an analysis-ready table.
Graded skills check, saves to your dashboardStart this projectScope and prepare a promo effectiveness study
The founder wants to double promo spend. Your job is to frame the question correctly first: attributed vs incremental revenue, ROAS traps, and the selection bias hiding in who uses codes.
Graded skills check, saves to your dashboardStart this projectBuild a cohort retention dashboard in Tableau
Order-level data in, a signup-cohort retention triangle out. This is the LOD-and-table-calc project that separates a chart-maker from an analyst.
Graded skills check, saves to your dashboardStart this projectRep quota and YoY analysis with Tableau LOD
Attainment as a ratio of sums, year-over-year as a table calc, share of total as a FIXED LOD: the three calculations executives ask for and analysts most often get subtly wrong.
Graded skills check, saves to your dashboardStart this projectTime intelligence measures in Power BI
A proper date table, then YoY, YTD, margin, and a moving average in DAX. The measures every analyst is expected to write, and the filter-context reasoning behind them.
Graded skills check, saves to your dashboardStart this projectCustomer cohort and retention DAX in Power BI
New vs returning, repeat rate, AOV, and share of segment, built with SUMX, DISTINCTCOUNT, and CALCULATE with ALL. The measures that separate row context from filter context.
Graded skills check, saves to your dashboardStart this projectWant to build these skills with a mentor?
The bootcamp walks you through projects like these live, with feedback, replays, and a portfolio at the end.