Vouched

Command Palette

Search for a command to run...

Datacamp

Datacamp

DataCamp Courses & Certificates

25% off

Datacamp

DataCamp Courses & Certificates

25% off
MShared byMo Chen
From video: SQL & Power BI Data Analyst Portfolio Project (No Experience Needed!)
Published: March 16, 2026

Video Description

Portfolio, Projects, Resume, Courses & Certifications, Newsletter https://mochen.info Sponsorships: https://mo-chen.notion.site/partnerships Hi, I'm Mo! I'm a Data & Analytics Manager. I'm all about turning complex, big data into insights and actions. I am not interested in building yet another dashboard that nobody looks at - I'm interested in solving the most challenging business problems using data. ========================================================= 25% DISCOUNT ON COURSES & CERTIFICATES Get 25% OFF DataCamp's Courses & Certificates: https://datacamp.pxf.io/DataCampMoChen INDUSTRY RECOGNIZED CERTIFICATIONS Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCertDataCamp PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAnalyst Data Scientist Certification Program: https://datacamp.pxf.io/DataScientistCert SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert TOP DATA ANALYST COURSES Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWithPython Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPowerBIMoChen Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateDataAnalystSQL Project Files: https://drive.google.com/drive/folders/10CPTijqoGzODuAuT8-SnQ67XkAbbQqIt?usp=sharing TIMESTAMPS 00:00 Project Summary 01:18 Non-Technical Project Overview 09:01 Technical Overview 13:27 Getting started with BigQuery (Creating Project and Dataset) 16:04 Creating a table 17:27 Table Preview 18:32 Portfolio and Resume templates, Projects, Free Newsletter 19:07 Append all monthly sales tables together 23:08 Creating the RFM Metrics View 34:44 Creating the RFM Scores View 38:47 Creating the RFM Total Scores View 42:44 Creating the final RFM Segments Table 47:48 Quick recap of SQL queries 50:03 Power BI Report 59:00 Project Recap, Closing Thoughts