Data Analytics & Business Intelligence
Beginner to Intermediate • Estimated: 8 weeks (6-8 hrs/week)
Curriculum Overview
Master the core stack of modern business analysts: SQL queries, Excel dashboards, Tableau/PowerBI visual storytelling, and Python data analysis.
Core Competencies Built:
Who This Is For:
Career changers, marketing analysts, finance professionals, and data enthusiasts.
Prerequisites:
Comfortable with basic spreadsheet calculations (SUM, AVERAGE, VLOOKUP).
Week-by-Week Learning Roadmap
Spreadsheet Modeling & Business Math
Formulas, pivot tables, scenario analysis, and KPI definition.
Relational Databases & SQL
SELECT queries, JOINs, aggregations, window functions, and subqueries.
Exploratory Data Analysis with Python
Pandas dataframes, data cleaning, and statistical summaries.
Visual Dashboards & Capstone Portfolio
Interactive dashboard creation, executive presentation, and portfolio building.
Recommended Courses for This Path
Google Data Analytics Professional Certificate
Coursera / Google Career Certificates • Beginner
Gain in-demand data analytics skills and hands-on experience with spreadsheets, SQL, Tableau, and R programming directly from Google experts.