Home

All courses

Data Visualization in Tableau & Power BI (2 Courses in 1)

Business Analytics & Intelligence

Data Analysis

Business

Data Visualization in Tableau & Power BI (2 Courses in 1)

Learn Data Visualization with Tableau & Power BI from the basic to advanced level using Real-Life Projects

4.6

(613)

1904 enrolled on this course

Last updated 11/2021

Data Science Guide

₹ 2999.0

₹ 4499.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

Tableau
You will find in this course all what you need to learn about creating powerful diagrams and practicing data analytics. You will learn how to create many insightful charts from varied datasets that cover several business problems. First, you will learn about data visualization, installing Tableau and use main menus and functions. You will learn, also, how to connect to different data sources and formats and make the necessary data preparation to create interactive diagrams and charts. After that, you will learn more advanced features, such as: data joins and blending, calculated fields, dual axis, table calculation and more. You will learn how to use the advanced analytical functions in Tableau in your charts and diagrams.
Power BI
Converting raw data to insightful diagrams and charts to make informative decisions is a crucial analytical skill in data science. You will learn in this course how to create insightful and powerful charts and perform data analysis. First, you will understand data visualization, and why data visualization. After that you will understand Power BI services and the use of each of them. After you became familiar with these services you will learn how to install and navigate in Power BI Desktop. After that, you will learn how to use the advanced functions in Power BI Editor in data preparation and cleaning. You will learn appending and merging datasets to create one dataset. After that you will learn how to turn your datasets into insightful charts using many powerful functions. You will learn how to filter your data according to your business requirements. You will learn how to create measures and calculated columns for your own data analysis. You will have an introduction to DAX language where you can learn how to create new tables and columns according to your needs. After that you will learn how to take your projects in the Cloud where you can work with other users. You will learn how use Power BI Pro interface to create, edit and share reports with others.
Who this course is for:
All those that need to learn Data Visualization for data analysis and business analysis

What you'll learn

Install and use Tableau and Power BI

Understand Data Visualization

Create different types of diagrams and charts, such as Maps, Bar-charts and more

Learn all types of data joins and how to use them in your diagrams

Create calculated columns in Tableau and Power BI Desktop

Create dual Axis charts in Tableau

Create and use Table Calculation in Tableau

Learn Data Preparation, such as: converting data types, split columns, converting measures to dimensions and more

Work with time series data and understand granularity

Connect to varied formats of data sources like XLS, CSV, JSON and more

Deal with Geographical data and fix any issues with them

Learn to use analytical tools in Tableau and Power BI Desktop

Learn to use Data Blending in diagrams

Create filters to focus on specific parts of data in charts and diagrams

Create interactive dashboards and stories

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction to Data Visualization and Tableau

1.1-Introduction to the Course

1.2-Control the Pace of a Lesson

1.3-Introduction to Data Visualization

1.4-Installing Tableau Public

1.5-Overview on Tableau Work Environment

1.6-Connecting to Data Sources

1.7-Options of Data Connection in Tableau Professional

2-Learn Tableau Basics

2.1-Create Your First Diagram

2.2-Add Formatting to Diagrams

2.3-Create Treemaps Chart

2.4-Homework 1

2.5-Homework 1 Solution

2.6-Create Calculated Fields

2.7-Add Filters to Diagrams

2.8-Types of Aggregation Measures

2.9-Homework 2

2.10-Homework 2 Solution

2.11-Homework 2 Solution

2.12-Course Rating

3-Managing and Preparing Data in Tableau

3.1-Use Data Interpreter for data cleaning

3.2-Data Preparation in Excel and Flat files (part 2)

3.3-Data Preparation in Excel and Flat files (part 3)

3.4-Managing Metadata (Renaming and Hiding Data Fields)

3.5-Managing Metadata (Grouping Fields in Folders and Hierarchies)

4-Introduction to Data Granularity

4.1-Introduction to Granularity

4.2-Time Series Data Analysis

4.3-Introduction to Data Bins

4.4-Create Bins in Tableau

4.5-Homework 3

4.6-Homework 3 Solution

4.7-Course Rating

5-Creating a Dashboard and Story

5.1-What is a Dashboard

5.2-Create Dashboard Diagrams Part 1

5.3-Create Dashboard Diagrams Part 2

5.4-Create a Dashboard

5.5-Interpret the KPI's

5.6-A Story Definition

5.7-Create a Story

6-Creating Maps in Tableau

6.1-Introduction to the Business Problem and Data Preparation

6.2-Universities Data Analysis using Maps

6.3-Students Data Analysis using Maps

6.4-Deal with Unknown Spatial Data

7-Joining and Blending Data in Tableau

7.1-Introduction to Tables Join

7.2-Join Tables in Tableau

7.3-Blending Definition in Tableau

7.4-Blend Data in Tableau Part 1

7.5-Blend Data in Tableau Part 2

7.6-Course Rating

8-Groups, Sets, and Parameters

8.1-Definition of Groups and Sets in Tableau

8.2-Create a Group in Tableau

8.3-Create the Constant Set in Tableau

8.4-Create a Dynamic Set in Tableau

8.5-Combine Sets in Tableau

8.6-Use Quick Table Calculation Feature

8.7-Add a Table Calculation

8.8-Create and Use Parameters in Tableau

9-Learn more Data Analytics in Tableau

9.1-Add a Reference Line in Tableau

9.2-Scatter Plot Analysis in Tableau

9.3-Use Forecast Algorithm in Tableau

9.4-Use Cluster Algorithm in Tableau

10-The Project (Delayed Flights Analyses)

10.1-Overview on the Business Problem Data

10.2-Arrival Flights per Airline

10.3-Percentage of Arrival and Delayed Flights

10.4-Percentage of Delayed Flights in Time Series

10.5-Percentage of Delayed Flights per State (Map Chart)

10.6-The Project Homework

11-Introduction to Power BI

11.1-Introduction to course

11.2-Introduction to Section 1

11.3-What is Power BI

11.4-Install Power BI Desktop

11.5-Change setting in Power BI Desktop

11.6-Start Power BI Desktop

12-Data Preparation and Cleaning

12.1-Overview on the business dataset

12.2-Connect to a data source

12.3-Remove N/A rows and use first row as headers names

12.4-Introduction to Pivot and Unpivot operators

12.5-Unpivoting columns

12.6-Split columns and change data types

12.7-Other ways to split columns

12.8-Introduction to M Language

12.9-Remove empty rows from a dataset

12.10-Identify the granular data level in a dataset

12.11-Remove duplicated rows in a dataset

12.12-Connect to another data source

12.13-Introduction to Append operator

12.14-Append queries in Power BI Query Editor

12.15-Introduction to data types in Power BI

12.16-Set proper data types in a dataset

12.17-Fix a data conversion error

12.18-Introduction to Star Schema Model

12.19-Create a Star Schema Model in Power BI

12.20-Create the Country dimension table

12.21-Create the Product and Segment dimensions tables

12.22-Create the Fact Sales table

12.23-Introduction to the Merge operator

12.24-Merge queries in Power Query Editor

12.25-Organize datasets in groups

12.26-More useful functions in Power Query Editor

12.27-Disable loading unused files into Power BI

12.28-Project 2 file in Power BI

12.29-Course Rating

13-Data Visualization

13.1-Create the first chart

13.2-Filter data in charts

13.3-Use top N feature in filters

13.4-Formatting charts part-1

13.5-Formatting charts part-2

13.6-Add analytical lines to charts

13.7-Fix the merging problems between queries

13.8-Create a TreeMap chart

13.9-Advanced color formatting in charts

13.10-Add Slicer to charts

13.11-Create a Map chart

13.12-Measure vs Calculated column

13.13-Create a measure in Power BI Desktop

13.14-Create a calculated column in Power BI Desktop

13.15-Create a Pie chart

13.16-Prepare a time series dataset

13.17-Create a Line chart

13.18-Drilling in a Hierarchy dimensions

13.19-Change themes of reports

13.20-Introduction to DAX Language

13.21-DAX Language reference website

13.22-Arithmetic functions in DAX

13.23-DAX operators

13.24-Date functions in DAX

13.25-Logical functions in DAX

13.26-Text concatenation functions in DAX

13.27-Course Rating

14-Work on Projects in the Cloud with Power BI Pro

14.1-Introduction to Power BI Pro

14.2-Login to Power BI Pro

14.3-Quick overview on Power BI Pro interface

14.4-Browse and edit projects in Power BI Pro

14.5-Create a Dashboard in Power BI Pro

14.6-Overview on My workspace in Power BI Pro

14.7-Install Gateways

14.8-Overview on Workspaces in Power BI Pro

14.9-Apps in Power BI Pro

Course Categories

Popular Courses

Data Visualization in Tableau & Power BI (2 Courses in 1)

Description

What you'll learn

Requirements

Course Content

You May Like