Hands-on builds

Projects

Projects

About These Projects

The best way to make the modules stick is to build something. These five projects take you from SQL data cleaning through a Power BI dashboard, a portfolio to show your work, and then an Excel and a Tableau dashboard.

Each one is a code-along video, so you can pause, build it yourself and adapt it to your own data. Pick the project that matches the module you've just finished and come back for the rest.

Projects

5 builds
01

Clean & Transform Data with SQL

Write SQL to clean and shape the tables behind a report: rename columns, join fact and dimension tables, filter, sort, and handle missing values with CASE and ISNULL.

02

Build a Power BI Dashboard

Load the cleaned data into Power BI, connect the tables into a data model, create measures, and design an interactive sales and budget dashboard.

03

Assemble Your Portfolio

Put your SQL scripts and dashboard together on a portfolio site, so recruiters can see your work and how you built it.

04

Build an Excel Dashboard on Real Sales Data

Profile a real coffee shop transactions dataset, add calculated columns, explore it with PivotTables, then build PivotCharts and slicers into an interactive dashboard.

05

Build a Tableau Dashboard from Scratch

Take SQL query results into Tableau, build the visualizations, combine them into a dashboard, and publish it on Tableau Public to share on LinkedIn or in your portfolio.