SQL & Power BI Data Analyst Portfolio Project (No Experience Needed!)
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/dataAnalystCe...
PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAn...
Data Scientist Certification Program: https://datacamp.pxf.io/DataScientist...
SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert
TOP DATA ANALYST COURSES
Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWi...
Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPo...
Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateData...
Project Files: https://drive.google.com/drive/folder...
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