• Post category:StudyBullet-16
  • Reading time:15 mins read

Learn the top 2 data visualization tools – Power BI and Tableau in 1 course | Beginner friendly | Basic to Advance Level

What you will learn

Connect and Integrate various data sources into Power BI and Tableau, including CSV files, SQL databases, and cloud storage services

Manipulate and Transform Data using Power Query in Power BI, mastering skills such as merging, appending, and pivoting data for optimal analysis

Create Advanced Data Models in Power BI, understanding relationships, cardinality, and different schema types like Star and Snowflake

Design Comprehensive Dashboards using both Power BI and Tableau, learning to effectively communicate data insights through visual storytelling

Develop Complex Charts and Graphs, including bar, line, and scatter plots in Power BI and Tableau, enhancing the ability to illustrate data trends and patterns

Perform In-depth Data Analysis using DAX functions in Power BI and calculated fields in Tableau, enabling sophisticated data manipulation and insight generation

Utilize Advanced Visualization Techniques in Tableau, such as creating custom hierarchies, dual combination charts, and Geo charts etc.

Implement Effective Data Filtering and Sorting Techniques in both Power BI and Tableau, allowing for focused and precise data exploration

Publish and Share Interactive Reports and Dashboards, gaining skills in saving, sharing, and presenting data visualizations in professional formats


Are you an aspiring data professional, business analyst, or someone looking to master the art of data visualization? Have you been searching for a comprehensive course that will take you from a novice to an expert in the world’s leading data visualization tools? If your goal is to make impactful, data-driven decisions, then this course is tailor-made for you.

This unique 2-in-1 bundle course offers a high-level overview of both Power BI and Tableau, the leading tools in data visualization. The course is designed to provide you with the skills to create compelling, insightful visualizations, and dashboards that make data come alive.

In this course, you will:

  • Develop proficiency in using Power BI and Tableau, starting from the basics and progressing to advanced techniques.
  • Master the art of connecting to various data sources, data preparation, and transformation using Power Query in Power BI.
  • Create sophisticated data models and understand relationships, cardinality, and schema types.
  • Design and customize interactive charts, graphs, and reports that tell compelling data stories.
  • Explore the powerful DAX functions in Power BI and calculated fields in Tableau for in-depth data analysis.
  • Harness the full potential of Tableau by learning data categorization, creating custom hierarchies, and mastering different types of visualizations.

Why is Data Visualization Crucial? In today’s data-driven world, the ability to visualize and communicate data effectively is essential. It’s not just about presenting data; it’s about unlocking the story that the data holds. This course will equip you with the necessary skills to transform raw data into visually appealing and understandable formats that drive strategic decision-making.

Get Instant Notification of New Courses on our Telegram channel.

Course Activities and Highlights:

  • Hands-on projects including building dashboards, creating custom charts, and performing complex data analysis.
  • Real-world case studies to apply your learning in practical scenarios.
  • Quizzes and exercises for self-assessment and deeper understanding.

Why Choose This Course? This course stands out because of its comprehensive coverage of both Power BI and Tableau, detailed practical examples, and a step-by-step approach that ensures all students, regardless of their starting skill level, can gain mastery.

Ready to Embark on Your Data Visualization Journey? Enroll now and take the first step towards mastering Power BI and Tableau, and elevating your data visualization skills. Transform your career and become an in-demand data visualization expert today!




Course resources
This is a milestone

Installation and Setting up Power BI Desktop

Installation and Setting up Power BI Desktop
About the data and the way forward

Connecting Power BI to different Data Sources

Connecting to a CSV file
Connecting to an SQL database
Getting data from all files in a folder
Getting data from an XML file

Preparing and Manipulating data using Power Query

Introduction to Power Query Editor
Important checks before we transform data
Merging and Appending Queries – Theory
Appending queries in Power Query
Merging queries in Power Query
Manage table rows and columns
Split Column tool
Replace Values tool
Group By tool
Pivoting and unpivoting – Theory
Pivoting and unpivoting in Power Query
Extract tool
Format Text options
Number transformations
Date and Time transformations

Adding new columns using Power Query

Add column from examples
Add a custom column
Add conditional and Index column

Creating a data model using relationships

Introduction to Model View
Creating and modifying relationships
Cardinality and cross filter direction
Fact and Dimension tables
Star and Snowflake schemas
Data Pane and the Properties Pane

Creating Charts and Visuals in Power BI

Bar chart and Column chart
Clustered Bar chart and Stacked Bar chart
Chart formatting options
Small multiples, Tooltips and Drill Through
Line chart and Area chart
Combination chart or a combo chart
Pie chart and Donut chart
Scatter chart and Bubble chart
Applying filters
‘Add Further Analysis’ tab
Table and Matrix Visuals
Card and Multi-row cards
Hierarchies in Power BI
Tree map
Map charts for showing geographical data
Conditional formatting of charts

Advanced Charts

Gauge Chart
KPI Chart
Funnel Chart
Ribbon Chart

Data analysis using DAX

Introduction to DAX
DAX syntax and Row context vs Filter context
Types of operators and functions
Demonstration of new columns and new measures
Using explicit measures to create new measures
IF function with Logical operators
RELATED function
CALCULATE function
All Function
Filter function
SUMX Iterator function
DATESYTD and DATEADD- Time intelligence function

Creating Beautiful and Interactive Reports in Power BI

Introduction to reports
Formatting report page and creating a template
Slicers on report page
Drill-through for report pages
Adding a page navigator
Adding Bookmarks to the report


Comparision between Power BI vs Tableau

Installation and getting started With Tableau

Tableau Products
Installing Tableau desktop and Public
About the data
Connecting to data
Live vs Extract

Combining data to create Data model

Relationships in Tableau
Combining data from multiple tables
Joins in Tableau
Types of Joins in Tableau
Union in Tableau
Physical Logical layer and Data models
The visualization screen – Sheet

Data categorization in Tableau

Types of Data – Dimensions and Measures
Types of Data – Discreet and Continuous
Changing Data type in Tableau

Most used charts

Bar charts
Line charts

Customizing charts using Marks shelf

Marks cards
Dropping Dimensions and Measures on marks card
Dropping Dimensions on Line chart
Adding marks in scatterplot

Other important charts

Text tables, heat map and highlight tables
Pie charts
Area charts
Creating custom hierarchy
Tree map
Dual combination charts
Creating Bins

Grouping and Filtering data

Grouping Data
Filtering data
Dimension filters
Measure filters
Date-Time filters
Filter options
Types of filters and order of operation
Customizing visual filters
Sorting options

Map chart in Tableau

How to make a map chart
Considerations before making a Map chart
Marks card for customizing maps
Customizing maps using map menu
Layers in a Map
Visual toolbar on a map
Custom background images
Territories in maps
Data blending for missing geocoding

Calculations and Analytics

Calculated fields in Tableau
Functions in Tableau
Table calculations theory
Table calculations in Tableau
Understanding LOD expressions
LOD expressions examples
Analytics pane

Sets and Parameters

Understanding sets in Tableau
Creating Sets in Tableau

Dashboard and Story

Dashboard part -1
Dashboard part – 2

Saving and Sharing your work

Saving and sharing tableau workbook
Saving and sharing data
Saving and sharing views and dashboards


Connecting to SQL data source
Connecting to cloud storage services
The final milestone!

Congratulations and about your certificate

Bonus lecture