Course Content
Week 1 — Understand and Plan a New Business Case
Capstone Overview and Expected Outcomes
You don't currently have access to this content
Understand the Stakeholder Request
You don't currently have access to this content
Explore the business context
You don't currently have access to this content
Define five or six analytical questions
You don't currently have access to this content
Identify Required Metrics and KPIs
You don't currently have access to this content
Inspect the Available Data
You don't currently have access to this content
Create an analysis plan
You don't currently have access to this content
Identify possible data-quality risks
You don't currently have access to this content
Define the Project Scope
You don't currently have access to this content
Create a Data Dictionary
You don't currently have access to this content
Explain which tools they will use and why
You don't currently have access to this content
Project Milestone 1 — Business Requirements and Analysis Plan
You don't currently have access to this content
Week 2 — Clean, Combine, Model and Validate
Clean the dataset with Pandas
You don't currently have access to this content
Extract and Analyze Data with SQL
You don't currently have access to this content
Apply joins, grouping and conditional logic
You don't currently have access to this content
Transform the Data with Power Query
You don't currently have access to this content
Merge and Append Required Tables
You don't currently have access to this content
Build the Capstone Star Schema
You don't currently have access to this content
Create and Validate Relationships
You don't currently have access to this content
Create and Mark a Date Table
You don't currently have access to this content
