SQL Data Cleaning Portfolio Project: Data Engineering, Analytics & Data Science with Business Rules, KPIs for dashboards
Sub Category
- Other IT & Software
{inAds}
Objectives
- Build a complete portfolio project you can publish: an end-to-end SQL data cleaning + KPI pipeline
- Turn a messy e-commerce table into a trusted clean_table that’s safe for reporting and dashboards
- Profile data like a professional: row counts, null/completeness checks, category profiling, and “how bad is it?” diagnostics
- Build a typed silver layer in SQL: safe casting, mixed-format date parsing, and text normalisation (without silently corrupting results)
- Enforce a real business contract: filter invalid orders (amounts, costs, flags, hour ranges) and quantify exactly what each rule removes
- Detect and remove duplicates using a business key, and understand the real-world risk of defining that key incorrectly
- Implement 10 dashboard-ready KPIs in SQL using CTEs, aggregates, and window functions where needed
- Standardise outputs into a single kpi_results table with one consistent schema a dashboard (or platform) can read
- Debug KPI mismatches properly: trace issues back to the right layer (source → silver → clean → KPI) instead of guessing
- Package the project professionally: clean SQL files, a strong README, evidence screenshots, and a LinkedIn-ready project summary
Pre Requisites
- Basic SQL knowledge (you should be comfortable with SELECT, WHERE, GROUP BY, and basic joins)
- A laptop/PC and a modern web browser
- You can use any SQL tool you already have
- In the videos, I use Verulam Blue Mint (a free to use browser-based SQL workbench) to keep everything in one notebook workflow and support KPI checking/feedback — but the SQL approach is transferable
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)