Power Bi And Tableau For Data Visualization [2-In-1 Bundle]

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

What you'll 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

Requirements

A PC with internet connection. Installation instructions for the tools used are covered in the course.

Description

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.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!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Course resources

Lecture 3 This is a milestone

Section 2: Installation and Setting up Power BI Desktop

Lecture 4 Installation and Setting up Power BI Desktop

Lecture 5 About the data and the way forward

Section 3: Connecting Power BI to different Data Sources

Lecture 6 Connecting to a CSV file

Lecture 7 Connecting to an SQL database

Lecture 8 Getting data from all files in a folder

Lecture 9 Getting data from an XML file

Section 4: Preparing and Manipulating data using Power Query

Lecture 10 Introduction to Power Query Editor

Lecture 11 Important checks before we transform data

Lecture 12 Merging and Appending Queries - Theory

Lecture 13 Appending queries in Power Query

Lecture 14 Merging queries in Power Query

Lecture 15 Manage table rows and columns

Lecture 16 Split Column tool

Lecture 17 Replace Values tool

Lecture 18 Group By tool

Lecture 19 Pivoting and unpivoting - Theory

Lecture 20 Pivoting and unpivoting in Power Query

Lecture 21 Extract tool

Lecture 22 Format Text options

Lecture 23 Number transformations

Lecture 24 Date and Time transformations

Section 5: Adding new columns using Power Query

Lecture 25 Add column from examples

Lecture 26 Add a custom column

Lecture 27 Add conditional and Index column

Section 6: Creating a data model using relationships

Lecture 28 Introduction to Model View

Lecture 29 Creating and modifying relationships

Lecture 30 Cardinality and cross filter direction

Lecture 31 Fact and Dimension tables

Lecture 32 Star and Snowflake schemas

Lecture 33 Data Pane and the Properties Pane

Section 7: Creating Charts and Visuals in Power BI

Lecture 34 Bar chart and Column chart

Lecture 35 Clustered Bar chart and Stacked Bar chart

Lecture 36 Chart formatting options

Lecture 37 Small multiples, Tooltips and Drill Through

Lecture 38 Line chart and Area chart

Lecture 39 Combination chart or a combo chart

Lecture 40 Pie chart and Donut chart

Lecture 41 Scatter chart and Bubble chart

Lecture 42 Applying filters

Lecture 43 'Add Further Analysis' tab

Lecture 44 Table and Matrix Visuals

Lecture 45 Card and Multi-row cards

Lecture 46 Hierarchies in Power BI

Lecture 47 Tree map

Lecture 48 Map charts for showing geographical data

Lecture 49 Conditional formatting of charts

Section 8: Advanced Charts

Lecture 50 Gauge Chart

Lecture 51 KPI Chart

Lecture 52 Funnel Chart

Lecture 53 Ribbon Chart

Section 9: Data analysis using DAX

Lecture 54 Introduction to DAX

Lecture 55 DAX syntax and Row context vs Filter context

Lecture 56 Types of operators and functions

Lecture 57 Demonstration of new columns and new measures

Lecture 58 Using explicit measures to create new measures

Lecture 59 IF function with Logical operators

Lecture 60 COUNT and DISTINCTCOUNT functions

Lecture 61 RELATED function

Lecture 62 CALCULATE function

Lecture 63 All Function

Lecture 64 Filter function

Lecture 65 SUMX Iterator function

Lecture 66 DATESYTD and DATEADD- Time intelligence function

Section 10: Creating Beautiful and Interactive Reports in Power BI

Lecture 67 Introduction to reports

Lecture 68 Formatting report page and creating a template

Lecture 69 Slicers on report page

Lecture 70 Drill-through for report pages

Lecture 71 Adding a page navigator

Lecture 72 Adding Bookmarks to the report

Section 11: TABLEAU STARTS HERE!

Lecture 73 Comparision between Power BI vs Tableau

Section 12: Installation and getting started With Tableau

Lecture 74 Tableau Products

Lecture 75 Installing Tableau desktop and Public

Lecture 76 About the data

Lecture 77 Connecting to data

Lecture 78 Live vs Extract

Section 13: Combining data to create Data model

Lecture 79 Relationships in Tableau

Lecture 80 Combining data from multiple tables

Lecture 81 Joins in Tableau

Lecture 82 Types of Joins in Tableau

Lecture 83 Union in Tableau

Lecture 84 Physical Logical layer and Data models

Lecture 85 The visualization screen - Sheet

Section 14: Data categorization in Tableau

Lecture 86 Types of Data - Dimensions and Measures

Lecture 87 Types of Data - Discreet and Continuous

Lecture 88 Changing Data type in Tableau

Section 15: Most used charts

Lecture 89 Bar charts

Lecture 90 Line charts

Lecture 91 Scatterplots

Section 16: Customizing charts using Marks shelf

Lecture 92 Marks cards

Lecture 93 Dropping Dimensions and Measures on marks card

Lecture 94 Dropping Dimensions on Line chart

Lecture 95 Adding marks in scatterplot

Section 17: Other important charts

Lecture 96 Text tables, heat map and highlight tables

Lecture 97 Pie charts

Lecture 98 Area charts

Lecture 99 Creating custom hierarchy

Lecture 100 Tree map

Lecture 101 Dual combination charts

Lecture 102 Creating Bins

Lecture 103 Histogram

Section 18: Grouping and Filtering data

Lecture 104 Grouping Data

Lecture 105 Filtering data

Lecture 106 Dimension filters

Lecture 107 Measure filters

Lecture 108 Date-Time filters

Lecture 109 Filter options

Lecture 110 Types of filters and order of operation

Lecture 111 Customizing visual filters

Lecture 112 Sorting options

Section 19: Map chart in Tableau

Lecture 113 How to make a map chart

Lecture 114 Considerations before making a Map chart

Lecture 115 Marks card for customizing maps

Lecture 116 Customizing maps using map menu

Lecture 117 Layers in a Map

Lecture 118 Visual toolbar on a map

Lecture 119 Custom background images

Lecture 120 Territories in maps

Lecture 121 Data blending for missing geocoding

Section 20: Calculations and Analytics

Lecture 122 Calculated fields in Tableau

Lecture 123 Functions in Tableau

Lecture 124 Table calculations theory

Lecture 125 Table calculations in Tableau

Lecture 126 Understanding LOD expressions

Lecture 127 LOD expressions examples

Lecture 128 Analytics pane

Section 21: Sets and Parameters

Lecture 129 Understanding sets in Tableau

Lecture 130 Creating Sets in Tableau

Lecture 131 Parameters

Section 22: Dashboard and Story

Lecture 132 Dashboard part -1

Lecture 133 Dashboard part - 2

Lecture 134 Story

Section 23: Saving and Sharing your work

Lecture 135 Saving and sharing tableau workbook

Lecture 136 Saving and sharing data

Lecture 137 Saving and sharing views and dashboards

Section 24: Appendix

Lecture 138 Connecting to SQL data source

Lecture 139 Connecting to cloud storage services

Lecture 140 The final milestone!

Section 25: Congratulations and about your certificate

Lecture 141 Bonus lecture

Students or beginners who are new to the field of data visualization and want to learn about the top tools in the market.,Business professionals who want to gain advanced skills in data visualization using the 2 most popular tools.,Analysts or managers who work with large sets of data and need to present them in an easy-to-understand manner to others.,Data enthusiasts who want to broaden their knowledge in data visualization and learn about the latest features in these tools.,Career Changers Targeting Data Visualization Roles