🎓 OFFICIAL CERTIFICATION ⏱️ 3 Month • 30 Masterclasses

📊 Data Analytics & Business Intelligence

Instructed by Sarah Jenkins

★ 4.8 (2.5k Reviews)

About this course

Transform raw numbers into actionable business insights. Master Advanced Excel functions, data cleaning, interactive charts, KPI metrics, and Power BI dashboard creation.

Course Curriculum & Modules

10 Modules • 30 Video Lessons + 10 Reading Guides

FULL ACCESS

Understanding Data Lifecycle & Analytical Types (Descriptive, Diagnostic, Predictive, Prescriptive)

Video Lesson • 03:04

Play

Advanced Excel Formulas: XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS & Dynamic Arrays

Video Lesson • 03:04

Play

Data Cleaning, Text Functions, Deduplication & Error Handling in Excel

Video Lesson • 03:04

Play

Executive Reading Guide & Summary: Data Analytics Fundamentals & Excel Wrangling

Reading Study Article • 10–12 Min Read

Open

Module 1 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

Start Test

Mastering Pivot Tables, Grouping, Calculated Fields & Slicers

Video Lesson • 03:04

🔒 Unlock

Power Query ETL: Unpivoting Columns, Merging Datasets & Data Transformation

Video Lesson • 03:04

🔒 Unlock

Building Interactive Excel KPI Dashboards & Executive Reports

Video Lesson • 03:04

🔒 Unlock

Executive Reading Guide & Summary: Pivot Tables & Power Query ETL

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 2 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

Relational Database Concepts, SQL Syntax & SELECT Statements

Video Lesson • 03:04

🔒 Unlock

Filtering & Sorting Data: WHERE, GROUP BY, HAVING, ORDER BY & Aggregations

Video Lesson • 03:04

🔒 Unlock

Multi-Table Joins (INNER, LEFT, RIGHT, FULL) & Subqueries

Video Lesson • 03:04

🔒 Unlock

Executive Reading Guide & Summary: SQL Fundamentals & Data Extraction

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 3 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

Window Functions: ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LEAD() & LAG()

Video Lesson • 03:04

🔒 Unlock

Common Table Expressions (CTEs), Temp Tables & Complex Joins

Video Lesson • 03:04

🔒 Unlock

Database Indexing, Query Optimization & Data Integrity

Video Lesson • 03:04

🔒 Unlock

Executive Reading Guide & Summary: Advanced SQL & Window Functions

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 4 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

Choosing the Right Chart: Bar, Line, Scatter, Treemap, Waterfall & Funnel

Video Lesson • 03:04

🔒 Unlock

Gestalt Principles, Color Theory & Executive Visual Hierarchy

Video Lesson • 03:04

🔒 Unlock

Data Storytelling: Structuring Executive Insights & Presentation Decks

Video Lesson • 03:04

🔒 Unlock

Executive Reading Guide & Summary: Data Visualization & Storytelling

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 5 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

Connecting Data Sources, Power Query Transformations in Power BI

Video Lesson • 03:04

🔒 Unlock

Data Modeling: Fact Tables, Dimension Tables & Star Schema Design

Video Lesson • 03:04

🔒 Unlock

Managing Relationships, Active vs. Inactive Relationships & Cardinality

Video Lesson • 03:04

🔒 Unlock

Executive Reading Guide & Summary: Power BI Data Modeling & Star Schema

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 6 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

DAX Fundamentals: Calculated Columns vs. Measures & Evaluation Context

Video Lesson • 03:04

🔒 Unlock

Time Intelligence Functions: YTD, QTD, MTD, SAMEPERIODLASTYEAR & Date Tables

Video Lesson • 03:04

🔒 Unlock

Advanced DAX: CALCULATE(), ALL(), ALLEXCEPT(), FILTER() & Userelationship()

Video Lesson • 03:04

🔒 Unlock

Executive Reading Guide & Summary: DAX & Advanced Calculations

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 7 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

Designing Interactive Visualizations, Tooltips, Drillthrough & Bookmarks

Video Lesson • 03:04

🔒 Unlock

Publishing Reports to Power BI Service, Workspaces & Scheduled Refresh

Video Lesson • 03:04

🔒 Unlock

Row-Level Security (RLS), Sharing Dashboards & Mobile Optimization

Video Lesson • 03:04

🔒 Unlock

Executive Reading Guide & Summary: Power BI Dashboards & Security

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 8 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

Descriptive Statistics: Mean, Median, Mode, Variance, Standard Deviation & Percentiles

Video Lesson • 03:04

🔒 Unlock

Correlation, Regression Analysis & Trend Line Forecasting

Video Lesson • 03:04

🔒 Unlock

Hypothesis Testing: P-Values, T-Tests, Chi-Square & A/B Testing Analytics

Knowledge Check • Quiz

🔒 Unlock

Executive Reading Guide & Summary: Statistical Analysis & Business Metrics

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 9 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

Defining Corporate KPIs, Metric Trees & Balanced Scorecards

Video Lesson • 03:04

🔒 Unlock

Building a Modern Data Stack (Snowflake, BigQuery, dbt, Tableau/Power BI)

Video Lesson • 03:04

🔒 Unlock

Analytics Leadership, Data Governance & Driving a Data-Driven Culture

Video Lesson • 03:04

🔒 Unlock

Executive Reading Guide & Summary: BI Strategy & Analytics Leadership

Reading Study Article • 10–12 Min Read

🔒 Unlock

Module 10 Evaluation Quiz (20 MCQs)

Knowledge Check • 20 MCQs • 15 min

🔒 Unlock

Course Certification

Professional Credential

Earn a verified professional certificate upon successful completion of all lessons and assessments (≥ 75% score). Share your verified credential on LinkedIn and resume.

Limited Offer First Session is FREE