Prerequisite: Must have Data Analysis with Python – Basic Level knowledge
Overview:
Advanced is the direct next step after Basics built to stretch students further without tipping into heavy theory. It focuses on the skills analysts use most: cleaner SQL, better visuals, practical statistics, spotting trends, and automating repeat work each taught at a pace that builds steadily on basics rather than jumping too far ahead. The course closes with a full capstone students’ scope, build, and present a real analysis project from raw data to a workplace-ready recommendation.
Course outline
1. Data Aggregation & Summarization
2. Data Visualization & Dashboards
3. Advanced SQL Techniques
4. Window Functions & Database Design
5. Descriptive Statistics & Correlation Analysis
6. Comparative Analysis & Forecasting
7. Automation & External Data Sources
8. Capstone Project

