Course curriculum

  • 1

    Excel and Power BI: From Fundamental Principles to Brilliant

    • 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
  • 4

    Tableau Essentials: From Foundations to Visualization Master

    • Introduction to Instructor and Tableau
    • Importance of Tableau
    • What is tableau
    • UseCase
  • 5

    Tableau Fundamentals

    • Installation and Setup
    • UI Tour
    • Import Data from Various Data Sources (Excel, CSV, etc.)
    • Explore Data Pane and Data Source Pane
  • 6

    Tableau Functions

    • Functions (Presentation Canva)
    • Basic Functions (ABS, Ceiling, Floor, Max, Min, Div, ZN)
    • String Functions (Contains, endswith, find, findnth, len, lower, upper, split, trim)
    • Date Functions (Dateadd, DateDiff, Datename, Day, Month, Year, isdate, Makedate, Maketime, Makedatetime, Now)
    • Aggregate Functions (avg, max, median, min, sum)
    • Logical Functions (if, and, else, or)
  • 7

    Mastering Visualizations

    • Visualizations – Bar Chart
    • Visualizations – Line Chart
    • Visualizations – Bullet Chart
    • Visualizations – Text Table
    • Visualizations – Gantt Chart
    • Visualizations – Pie Chart
    • Visualizations – Scatter Plot
    • Visualizations – Area Chart
    • Visualizations – Dual Axis Chart
    • Visualizations – Bubble Chart
  • 8

    Exploring Geographic Mapping

    • Introduction to Geo Data Visualization
    • Geographic Mapping
    • Customizing Map Layers and Styles
    • Creating a Dashboard
  • 9

    End-to-End Project Implementation

    • Starting the Projects
    • PROJECT Part 1
    • PROJECT Part 2
    • PROJECT Part 3
    • PROJECT Part 4
    • PROJECT Part 5
  • 10

    Mastering Data Publication and Collaboration with Tableau Cloud

    • Publishing to Tableau Cloud