Data Analytics & Business Intelligence with Power BI, SQL & Python
Executive Dashboards, Advanced SQL Queries, DAX Calculations, ETL Pipelines, and Predictive Insights.
Bestseller
Pro Specialist
4.9
(0 ratings)
0 students
Created by
Dr. Alex Morgan
Last updated Sep 2026
English
Course content
10 sections • 41 lectures • 17.3h total length
Lesson 1.1: Enterprise Data Architectures: OLTP vs. OLAP, Data Warehouses, Lakes & Lakehouses
Preview
25 min
Lesson 1.2: Business Intelligence Strategy, Metric Trees & Stakeholder KPI Frameworks
Preview
25 min
Lesson 1.3: The Analytics Lifecycle: From Raw Ingestion to Executive Action
25 min
Lesson 1.4: Module 1 Graded Assessment (10 MCQs)
20 min
Lesson 2.1: Entity-Relationship Modeling & Schema Normalization (1NF through 3NF/BCNF)
25 min
Lesson 2.2: Declarative SQL Foundations: DDL, DML & Precision Filtering Logic
25 min
Lesson 2.3: Multidimensional Aggregations: GROUP BY, HAVING, ROLLUP & CUBE
25 min
Lesson 2.4: Module 2 Graded Assessment (10 MCQs)
20 min
Lesson 3.1: Deep Relational Joins & Query Execution Engine Mechanics
25 min
Lesson 3.2: Subqueries & Existence Checks: Correlated Subqueries, EXISTS vs IN
25 min
Lesson 3.3: Set Operations & Enterprise Data Reconciliation: UNION, INTERSECT & EXCEPT
25 min
Lesson 3.4: Module 3 Graded Assessment (10 MCQs)
20 min
Lesson 4.1: Window Function Architecture: Partitioning, Ordering & Frame Specifications
25 min
Lesson 4.2: Common Table Expressions (CTEs) & Recursive Hierarchical Queries
25 min
Lesson 4.3: SQL Performance Tuning: Execution Plans, Indexing & SARGability
25 min
Lesson 4.4: Module 4 Graded Assessment (10 MCQs)
20 min
Lesson 5.1: Python Analytics Environment: Virtual Environments, Jupyter & Data Structures
25 min
Lesson 5.2: NumPy Foundations: N-Dimensional Arrays, Data Types & Memory Strides
25 min
Lesson 5.3: NumPy Universal Functions (ufuncs), Broadcasting & Mathematical Operations
25 min
Lesson 5.4: Module 5 Graded Assessment (10 MCQs)
20 min
Lesson 6.1: Pandas Data Structures: Series, DataFrames & Precision Indexing (loc vs iloc)
25 min
Lesson 6.2: Advanced Data Cleansing: Missing Values, Outliers, String & DateTime Handling
25 min
Lesson 6.3: Relational Transformations: Merging, Joining, Pivoting & Reshaping
25 min
Lesson 6.4: Module 6 Graded Assessment (10 MCQs)
20 min
Lesson 7.1: Systematic EDA Framework & Descriptive Summary Statistics
25 min
Lesson 7.2: Hypothesis Testing, A/B Test Evaluation & Confidence Intervals
25 min
Lesson 7.3: Data Visualization with Matplotlib & Seaborn: Visual Grammar & Aesthetic Standards
25 min
Lesson 7.4: Module 7 Graded Assessment (10 MCQs)
20 min
Lesson 8.1: Power Query Engine: ETL Extraction, M Formula Language & Query Folding
25 min
Lesson 8.2: Dimensional Modeling in Power BI: Star Schemas vs Snowflake Schemas
25 min
Lesson 8.3: Enterprise Date Dimension & Bridge Tables for Many-to-Many Relationships
25 min
Lesson 8.4: Module 8 Graded Assessment (10 MCQs)
20 min
Lesson 9.1: DAX Core Philosophy: Calculated Columns vs Measures & Evaluation Contexts
25 min
Lesson 9.2: The Power of CALCULATE(), FILTER(), ALL(), ALLEXCEPT() & VALUES()
25 min
Lesson 9.3: Time Intelligence Mastery: YTD, QTD, MoM Growth & Rolling Averages
25 min
Lesson 9.4: Module 9 Graded Assessment (10 MCQs)
20 min
Lesson 10.1: Executive BI Dashboards: Information Hierarchy, UX & Visual Storytelling
25 min
Lesson 10.2: Enterprise Governance in Power BI Service: Workspaces, Gateways & Row-Level Security (RLS)
25 min
Lesson 10.3: Capstone Integration Project: End-to-End Enterprise Analytics Pipeline (SQL + Python + Power BI)
25 min
Lesson 10.4: Module 10 Graded Assessment (10 MCQs)
20 min
Lesson 10.5: DATA ANALYTICS & BUSINESS INTELLIGENCE FINAL COMPREHENSIVE EXAMINATION
90 min
Description
Turn raw business data into actionable strategic value. Master complex multi-table SQL queries, automated ETL workflows, predictive models in Python, and stunning Power BI dashboards.
Instructor
Dr. Alex Morgan
Industry Expert & Senior Mentor
4.8 Instructor Rating
1,420 Reviews
8,900 Students
12 Courses
Over 15 years of industry experience leading engineering teams and publishing research in AI.
Preview
Data Analytics & Business Intelligence with Power BI, SQL & Python
No preview video currently available for this course.