Highlight #1

Describe a key feature that sets you apart, solves a problem, or adds value to your users.

Highlight #2

Describe a key feature that sets you apart, solves a problem, or adds value to your users.

Highlight #3

Describe a key feature that sets you apart, solves a problem, or adds value to your users.

About the course

Use this to describe your product. Speak directly to your audience, address their challenges, and show them how your product provides a solution to their problems. Consider what might be holding your target audience back, and tackle those potential concerns upfront. Make sure you clearly state the practical benefits your audience will gain from your product. Share a glimpse of your expertise or the special approach that sets your product apart from the rest. Don’t forget to add a clear and simple call-to-action so that your audience knows exactly how and where to sign up!

Your Name

Introduce yourself to your audience. How did you become an expert in your field? What challenges did you face on your way to success? How did you overcome them? Why are you excited to share your knowledge? What is your biggest goal with regards to teaching?

Curriculum

38 Chapters · 174 Lessons

  1. 1

    Excel Fundamentals + Essential Formulas

    1. (Included in full purchase)

      Excel interface, ribbon, worksheets

    2. (Included in full purchase)

      Cell referencing: Relative, Absolute, Mixed

    3. (Included in full purchase)

      Basic formatting & shortcuts

    4. (Included in full purchase)

      Essential formulas

  2. 2

    Data Cleaning + Professional Data Handling

    1. (Included in full purchase)

      Remove Duplicates

    2. (Included in full purchase)

      Flash Fill

    3. (Included in full purchase)

      Text to Columns

    4. (Included in full purchase)

      Data Validation

    5. (Included in full purchase)

      Conditional Formatting

    6. (Included in full purchase)

      Find & Replace

    7. (Included in full purchase)

      Excel tables, sorting, filtering

  3. 3

    Lookups, Mapping & Data Relationships

    1. (Included in full purchase)

      VLOOKUP

    2. (Included in full purchase)

      HLOOKUP

    3. (Included in full purchase)

      XLOOKUP

    4. (Included in full purchase)

      INDEX + MATCH

    5. (Included in full purchase)

      MATCH, OFFSET

    6. (Included in full purchase)

      Multi-sheet lookups

    7. (Included in full purchase)

      Mapping datasets

  4. 4

    Pivot Tables + Data Analysis Models

    1. (Included in full purchase)

      Creating Pivot Tables

    2. (Included in full purchase)

      Grouping (dates, categories, numbers)

    3. (Included in full purchase)

      Calculated fields

    4. (Included in full purchase)

      Pivot charts

    5. (Included in full purchase)

      Drill-down analysis

    6. (Included in full purchase)

      Slicers & timelines

    7. (Included in full purchase)

      KPI analysis

  5. 5

    Data Visualization + Excel Dashboards

    1. (Included in full purchase)

      Charts: Bar, Column, Line, Area, Pie, Donut, Histogram

    2. (Included in full purchase)

      KPI Cards

    3. (Included in full purchase)

      Dynamic charts

    4. (Included in full purchase)

      Slicers + interactive elements

    5. (Included in full purchase)

      Dashboard layout design

  6. 6

    Project Work

    1. (Included in full purchase)

      Sales & Revenue Analytics Dashboard

  7. 7

    Introduction to Databases & SQL

    1. (Included in full purchase)

      What is a database?

    2. (Included in full purchase)

      SQL vs MySQL vs others

    3. (Included in full purchase)

      Relational database concepts

    4. (Included in full purchase)

      Tables, rows, columns, keys

  8. 8

    MySQL Installation & Setup

    1. (Included in full purchase)

      Installing MySQL Server

    2. (Included in full purchase)

      Using MySQL Workbench

    3. (Included in full purchase)

      Creating databases and schemas

  9. 9

    Basic SQL Commands

    1. (Included in full purchase)

      SELECT, DISTINCT

    2. (Included in full purchase)

      ORDER BY, LIMIT

    3. (Included in full purchase)

      WHERE filtering

    4. (Included in full purchase)

      Operators: IN, BETWEEN, LIKE

  10. 10

    SQL Joins

    1. (Included in full purchase)

      INNER JOIN

    2. (Included in full purchase)

      LEFT JOIN

    3. (Included in full purchase)

      RIGHT JOIN

    4. (Included in full purchase)

      FULL OUTER JOIN

    5. (Included in full purchase)

      CROSS JOIN

    6. (Included in full purchase)

      Self JOIN

  11. 11

    Advanced Conditions

    1. (Included in full purchase)

      AND, OR, NOT

    2. (Included in full purchase)

      CASE WHEN expressions

  12. 12

    Aggregations

    1. (Included in full purchase)

      COUNT, SUM, AVG, MIN, MAX

    2. (Included in full purchase)

      GROUP BY

    3. (Included in full purchase)

      HAVING

  13. 13

    Subqueries

    1. (Included in full purchase)

      Subqueries in SELECT

    2. (Included in full purchase)

      Subqueries in WHERE

    3. (Included in full purchase)

      Subqueries in FROM

    4. (Included in full purchase)

      Correlated subqueries

  14. 14

    Data Cleaning in SQL

    1. (Included in full purchase)

      TRIM, REPLACE

    2. (Included in full purchase)

      SUBSTRING

    3. (Included in full purchase)

      LOWER, UPPER

    4. (Included in full purchase)

      NULL handling

    5. (Included in full purchase)

      COALESCE

  15. 15

    Window Functions

    1. (Included in full purchase)

      OVER

    2. (Included in full purchase)

      ROW_NUMBER

    3. (Included in full purchase)

      RANK, DENSE_RANK

    4. (Included in full purchase)

      LEAD, LAG

    5. (Included in full purchase)

      Running totals, moving averages

  16. 16

    Table Operations

    1. (Included in full purchase)

      CREATE, INSERT, UPDATE, DELETE

    2. (Included in full purchase)

      ALTER TABLE

    3. (Included in full purchase)

      TRUNCATE

  17. 17

    Data Modeling Concepts

    1. (Included in full purchase)

      ER diagrams

    2. (Included in full purchase)

      1NF, 2NF, 3NF

    3. (Included in full purchase)

      Keys & constraints

  18. 18

    Views & Temporary Tables

    1. (Included in full purchase)

      Creating and using views

    2. (Included in full purchase)

      Temporary tables

    3. (Included in full purchase)

      CTEs (WITH clause)

  19. 19

    MySQL Functions for Analytics

    1. (Included in full purchase)

      Date functions: DATEDIFF, DATE_ADD, YEAR, MONTH

    2. (Included in full purchase)

      Math: ROUND, CEIL, FLOOR

    3. (Included in full purchase)

      String: CONCAT, LPAD, RPAD

  20. 20

    Performance Basics

    1. (Included in full purchase)

      Indexes

    2. (Included in full purchase)

      EXPLAIN query optimization

  21. 21

    Importing & Exporting Data

    1. (Included in full purchase)

      LOAD DATA INFILE

    2. (Included in full purchase)

      Import CSV

    3. (Included in full purchase)

      Export results

    4. (Included in full purchase)

      Connecting MySQL with Excel/Power BI

  22. 22

    Real-World Analytics Scenarios

    1. (Included in full purchase)

      Sales analysis

    2. (Included in full purchase)

      Retention analysis

    3. (Included in full purchase)

      Inventory analysis

    4. (Included in full purchase)

      Marketing analytics

  23. 23

    Introduction to Business Intelligence & Power BI

    1. (Included in full purchase)

      What is BI?

    2. (Included in full purchase)

      Power BI ecosystem

    3. (Included in full purchase)

      Reports vs Dashboards

    4. (Included in full purchase)

      End-to-end BI workflow

  24. 24

    Power BI Desktop Interface

    1. (Included in full purchase)

      Canvas layout

    2. (Included in full purchase)

      Visualization pane

    3. (Included in full purchase)

      Filters pane

    4. (Included in full purchase)

      Themes & formatting

  25. 25

    Getting & Connecting Data

    1. (Included in full purchase)

      Excel, CSV, SQL Server, MySQL

    2. (Included in full purchase)

      Folder import

    3. (Included in full purchase)

      Web data

    4. (Included in full purchase)

      Multi-table connections

  26. 26

    Power Query

    1. (Included in full purchase)

      Remove duplicates

    2. (Included in full purchase)

      Split columns

    3. (Included in full purchase)

      Merge & append queries

    4. (Included in full purchase)

      Unpivot and pivot

    5. (Included in full purchase)

      Replace values

    6. (Included in full purchase)

      Data type corrections

    7. (Included in full purchase)

      Handling nulls

    8. (Included in full purchase)

      Group By

    9. (Included in full purchase)

      Conditional columns

    10. (Included in full purchase)

      Automated refresh

  27. 27

    Data Modeling

    1. (Included in full purchase)

      Star schema vs Snowflake schema

    2. (Included in full purchase)

      Fact & Dimension tables

    3. (Included in full purchase)

      Primary keys

    4. (Included in full purchase)

      Relationship types

    5. (Included in full purchase)

      Cardinality & cross-filter direction

  28. 28

    DAX (Data Analysis Expressions)

    1. (Included in full purchase)

      Calculated Columns vs Measures

    2. (Included in full purchase)

      SUM, AVERAGE, COUNTROWS

    3. (Included in full purchase)

      CALCULATE, FILTER

    4. (Included in full purchase)

      ALL, ALLEXCEPT

    5. (Included in full purchase)

      SUMX, AVERAGEX

    6. (Included in full purchase)

      DIVIDE

    7. (Included in full purchase)

      Time intelligence

  29. 29

    Visualizations

    1. (Included in full purchase)

      Bar, Column, Line, Area

    2. (Included in full purchase)

      Pie/Donut

    3. (Included in full purchase)

      Table/Matrix

    4. (Included in full purchase)

      Cards & KPIs

    5. (Included in full purchase)

      Funnel, Treemap, Waterfall

    6. (Included in full purchase)

      Combo charts

    7. (Included in full purchase)

      Scatter plots

    8. (Included in full purchase)

      Gauge Charts

    9. (Included in full purchase)

      Decomposition Tree & Key Influencer

    10. (Included in full purchase)

      Mapping visuals

  30. 30

    Slicers, Filters & Drill-through

    1. (Included in full purchase)

      Visual, page, report-level filters

    2. (Included in full purchase)

      Slicers & sync slicers

    3. (Included in full purchase)

      Drill-down hierarchies

    4. (Included in full purchase)

      Drill-through pages

    5. (Included in full purchase)

      Bookmarks for storytelling

  31. 31

    Dashboard Design Principles

    1. (Included in full purchase)

      UI/UX rules

    2. (Included in full purchase)

      Color psychology

    3. (Included in full purchase)

      Consistent layout

    4. (Included in full purchase)

      White space usage

    5. (Included in full purchase)

      Navigation buttons

    6. (Included in full purchase)

      Using containers

  32. 32

    Power BI Service

    1. (Included in full purchase)

      Publishing reports

    2. (Included in full purchase)

      Sharing & permissions

    3. (Included in full purchase)

      Workspaces

    4. (Included in full purchase)

      Dashboard creation

    5. (Included in full purchase)

      Scheduled refresh

    6. (Included in full purchase)

      Dataflows

    7. (Included in full purchase)

      Gateway setup

  33. 33

    Performance Optimization

    1. (Included in full purchase)

      Reducing dataset size

    2. (Included in full purchase)

      Optimizing relationships

    3. (Included in full purchase)

      DAX optimization

    4. (Included in full purchase)

      Query folding

    5. (Included in full purchase)

      Incremental refresh

    6. (Included in full purchase)

      Aggregations

  34. 34

    Advanced Analytics Features

    1. (Included in full purchase)

      AI visuals

    2. (Included in full purchase)

      Forecasting

    3. (Included in full purchase)

      Clustering

    4. (Included in full purchase)

      Anomaly detection

    5. (Included in full purchase)

      Smart Narratives

  35. 35

    Exporting & Integration

    1. (Included in full purchase)

      Export to PDF/PPT

    2. (Included in full purchase)

      Embedding reports

    3. (Included in full purchase)

      Power BI + Excel

    4. (Included in full purchase)

      Using Python/R

  36. 36

    Real-World Analytics Dashboards

    1. (Included in full purchase)

      Sales dashboard

    2. (Included in full purchase)

      Marketing performance

    3. (Included in full purchase)

      Supply chain dashboard

  37. 37

    Project Work

    1. (Included in full purchase)

      Supply Chain Analytics Dashboard

  38. 38

    Introduction to Python

    1. (Included in full purchase)

      What is Python & why use it for data analytics

    2. (Included in full purchase)

      Installing Python, Jupyter Notebook, VS Code

    3. (Included in full purchase)

      Variables, data types, input/output

    4. (Included in full purchase)

      Scripts vs notebooks

What people are saying

Testimonials build trust — fast. Edit this section to show how your product is making a difference and help your audience purchase with confidence.

”
Text-only testimonials are quick to scan and can highlight the value of your product at a glance.
Jessica L.

Las Vegas, NV

The combination of text and imagery make the testimonial feel more personal and credible.
Ashley T.

Working mom

”
Finally, a handbook that makes photography feel simple! It covers everything from camera settings to post-processing in a way that actually makes sense.
Anna W.

Amateur photographer

Add a clear and direct call-to-action

Seal the deal with a bit more content that supports the main call to action.

Enroll for free