Course curriculum

    1. Introduction to Course

    2. Outline

    3. Intro to Data Analysis

    4. A Use Case of Data Analysis

    1. Introduction and Installation

    2. Anatomy of a Spreadsheet and UI Tour

    3. Math Functions (Numeric)

    4. Math Functions (Basic)

    5. Math Functions (Aggregate)

    6. Math Functions (Rounding)

    7. Text Functions

    8. Information Functions

    9. Date and Time Functions

    10. Logical Functions

    11. Lookup Functions

    12. Formatting

    13. Pivot Table

    14. Print Formatting

    15. Project Part 1

    16. Project Part 2

    1. Intro to Power BI

    2. Installation

    3. UI Tour

    4. Importing Data

    5. Intro to Data Visualization

    6. Visualizations - Clustured Chart

    7. Visualizations - Formatting Charts

    8. Visualizations - Pie Chart and Donut Chart

    9. Visualizations - Funnel Chart

    10. Visualizations - Ribbon Chart and Card

    11. Visualizations - Include Exclude

    12. Visualizations - Themes

    13. Intro to Map Based Visualizations

    14. Map Based Visualizations - Map

    15. Map Based Visualizations - Filled Map

    16. Map Based Visualizations - Formatting Maps

    17. Intro to Data Modeling

    18. Creating Relationships

    19. What is DAX?

    20. DAX - Hands on

    21. DAX - Complex Functions

    22. DAX - Quick Measure

    23. DAX - New Column

    24. DAX - IF Function

    25. Intro to ETL Pipeline

    26. Extract Data from Multiple Files

    27. Extract Data from Multiple Sources

    28. Extract Data from Multiple Sources with Different Columns

    29. Transform Data

    30. Home Tabs for Transformation

    31. Project Part 1

    32. Project Part 2

    1. Introduction to Instructor and Tableau

    2. Importance of Tableau

    3. What is tableau

    4. UseCase

    1. Installation and Setup

    2. UI Tour

    3. Import Data from Various Data Sources (Excel, CSV, etc.)

    4. Explore Data Pane and Data Source Pane

    1. Functions (Presentation Canva)

    2. Basic Functions (ABS, Ceiling, Floor, Max, Min, Div, ZN)

    3. String Functions (Contains, endswith, find, findnth, len, lower, upper, split, trim)

    4. Date Functions (Dateadd, DateDiff, Datename, Day, Month, Year, isdate, Makedate, Maketime, Makedatetime, Now)

    5. Aggregate Functions (avg, max, median, min, sum)

    6. Logical Functions (if, and, else, or)

About this course

  • $199.99
  • 87 lessons
  • 9.5 hours of video content