Master Data Visualization:Excel, Power BI, Tableau Essential
-
1
-
Introduction to Course
-
Outline
-
Intro to Data Analysis
-
A Use Case of Data Analysis
-
2
-
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
-
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
-
Introduction to Instructor and Tableau
-
Importance of Tableau
-
What is tableau
-
UseCase
-
5
-
Installation and Setup
-
UI Tour
-
Import Data from Various Data Sources (Excel, CSV, etc.)
-
Explore Data Pane and Data Source Pane
-
6
-
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
-
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
-
Introduction to Geo Data Visualization
-
Geographic Mapping
-
Customizing Map Layers and Styles
-
Creating a Dashboard
-
9
-
Starting the Projects
-
PROJECT Part 1
-
PROJECT Part 2
-
PROJECT Part 3
-
PROJECT Part 4
-
PROJECT Part 5
-
10
-
Publishing to Tableau Cloud