Course curriculum

  • 1

    Introduction

    • Introduction to Course
    • Outline
    • Intro to Data Analysis
    • A Use Case of Data Analysis
  • 2

    Excel

    • Introduction and Installation
    • Anatomy of a Spreadsheet and UI Tour
    • Math Functions (Numeric)
    • Math Functions (Basic)
    • Math Functions (Aggregate)
    • Math Functions (Rounding)
    • Text Functions
    • Information Functions
    • Date and Time Functions
    • Logical Functions
    • Lookup Functions
    • Formatting
    • Pivot Table
    • Print Formatting
    • Project Part 1
    • Project Part 2
  • 3

    Power BI

    • Intro to Power BI
    • Installation
    • UI Tour
    • Importing Data
    • Intro to Data Visualization
    • Visualizations - Clustured Chart
    • Visualizations - Formatting Charts
    • Visualizations - Pie Chart and Donut Chart
    • Visualizations - Funnel Chart
    • Visualizations - Ribbon Chart and Card
    • Visualizations - Include Exclude
    • Visualizations - Themes
    • Intro to Map Based Visualizations
    • Map Based Visualizations - Map
    • Map Based Visualizations - Filled Map
    • Map Based Visualizations - Formatting Maps
    • Intro to Data Modeling
    • Creating Relationships
    • What is DAX?
    • DAX - Hands on
    • DAX - Complex Functions
    • DAX - Quick Measure
    • DAX - New Column
    • DAX - IF Function
    • Intro to ETL Pipeline
    • Extract Data from Multiple Files
    • Extract Data from Multiple Sources
    • Extract Data from Multiple Sources with Different Columns
    • Transform Data
    • Home Tabs for Transformation
    • Project Part 1
    • Project Part 2