WHO'S THIS FOR?
This course is designed specifically for freshers and also for those who want to switch career from Excel to Tableau .
Tableau is a leading data visualization tool used for data analysis and business intelligence. Gartner's Magic Quadrant classified Tableau as a leader for analytics and business intelligence.
Advantages of Tableau
Data visualization.
Quickly Create Interactive visualizations.
Ease of Implementation.
Tableau can handle large amounts of data.
Use of other scripting languages in Tableau.
Mobile Support and Responsive Dashboard.
Tableau Company Strategy.
Scheduling or notification of reports.
PROBLEMS YOU'VE EXPERIENCED WITH EXCEL IN THE PAST
Excel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.
Mistakenly working on the wrong file you saved.
It’s so annoying to email multiple Excel files to the same people everyday.
It takes hours to create a dashboard with multiple charts and formula functions.
Some time Excel files are used to store the large amount data which is a very wrong decision because to update the data everyday on that file is a headache because it takes so much time to get open and then to get save.
Note : Excel is also an Excellent Application. Yes Excel has some draw backs but it doesn't means its useless. Excel is also the Excellent tool to visualize and analyze the data.
Learn how to use a TABLEAU Desktop (Data Visualization) most demanded tool in the industry today. Give your career a boost. With our online sessions, you will be amazed what you can achieved.
Section 1 : Booster
1 Introduction
2 Download
3 Install
4 Tableau Extension
5 Connect with Database
6 Tableau Live & Extract
7 View Tables
8 Data Types
9 Tableau Work Sheet Interface
10 Data Types Symbol
11 Adding new Sheet
12 Product Category & Sales
13 Dimensions & Measures
14 Visualize data in workspace
15 Make Hierarchy
16 Grouping
17 Auto Generated Fields 5
18 Auto Generated Fields in Tableau
19 Records Per Dimension data or Item
20 Granularity
21 Granularity and Drill Down
22 Table into chart form
23 Color label
24 Color label for two different dimension
25 Map
26 Normal
27 Dynamic Filter
28 Date Filter 1
29 Date Filter 2 (Part1)
30 Date Filter 2 (Part2)
31 Date Filter 2 (Part 3)
32 Date Filter 3
33 Relevant Filter Explained
34 Relevant Filter in Tableau
35 Set
36 Discrete vs Continuous
37 Filtering
38 Keep only and Exclude
Section 2 : Filters
1 Filters
2 Type of Filters
3 Data Source Filters
4 Quick Filters
5 Dimension and Dependent Filters
6 Measure Filters
7 Context Filters Part1
8 Context Filters Part2
9 Context Filter Proper Details Part3
10 Date Filter
Session 3 : Charts
1 Introduction to charts
2 Create a Chart
3 Swap the Dimension & Measures
4 Bubble Chart
5 Pie Chart
6 Tree Map
7 Stacked Tree Map
8 Word Map Chart
8 Word Map Chart
9 Geographical Map
10 Geographical Bubble Map Measure
11 Geographical Bubble Map with size and color Measure
12 Geographical Bubble Map (Unknown error)
13 Geographical Map with color Dimension
14 Geographical Map with Date as Year Filter
15 Month Year Filter
16 Month Year Filter Apply
17 Bar chart
18 Bar chart color Measure
19 Bar chart size Measure
20 Bar chart size and color Measure
21 Bar chart with dual axis
22 Bar Stacked chart part 1
23 Bar Stacked chart part 2
24 Reference line scope Entire table
25 Reference line scope per cell
26 Reference line scope per pan
27 Tree Map Stacked in Bar Chart
28 Bar Chart with Date as Month Year Filter.
29 Bubble Chart color label
30 Bubble Chart color label as second dimension
31 Bubble Chart with motion
32 Line Chart
33 Line chart dual axis
34 Line Chart size Measure
35 Line chart dual Measure Date as Month Year Filter
36 Funnel Chart 1
37 Funnel Chart 2 Intro
38 Funnel Chart 2 Created
39 Scattered chart
40 Water Fall Chart
41 Parameter part 1
42 Parameter part 2
43 Parameter with Dynamic Reference line
44 Scatter plot and Many more Part1
45 Scatter plot and Many more Part2
46 Scatter plot and Many more Part3
Section 4: Union & Joins
1 Intro Joins
2 Inner Join
3 Left Join
4 Right Join
5 Full Join
6 Inner Join In Tableau
7 Left Join in Tableau
8 Right Join In Tableau
9 Full Join In Tableau
10 Union
11 Union in Tableau
12 Relation Like Vlookup
Section 5 : Function Base
1 Function Intro
2 Sum ()
3 Min () & Max ()
4 Average ()
5 Floor ()
6 Ceiling ()
7 Count ()
8 Upper ()
9 Lower ()
10 Right () & Left ()
Section 6 : Functions & Calculations Part1
1 Function Intro
2 RANK()
3 RANK_DENSE()
4 Rank Part 2
5 Rank_unique Part1
6 Rank_unique Part2
7 Rank_unique Part3
8 COUNT() vs CountD()
9 Mid()
10 Len()
11 Find ()
12 Mid() part 2
13 Trim()
14 Replace()
15 Quick Table Calculations
16 Running Total
17 Difference
18 Percent Difference
19 Percent of Total
20 Moving Average Part 1
21 Moving Average Part 1 continuous
22 Date Functions ()
24 Now() Today()
25 DateName and DatePart ()
26 Date Diff ()
27 Dateadd ()
28 Datetrunc()
29 MakeDate()
Section 7 : Functions & Calculations Part 2
1 round zero or round function
2 round 1 2 3 4
3 absolute()
4 Concatenate()
5 Replace()
6 Table Across
7 Table Down
8 Table Across Then Down
Section 8 : Functions & Calculations Part 2
1 IF ()
2 IF () in Tableau
3 IF () OR
4 IF () OR in Tableau
5 IF () AND
6 Nested IF ()
7 Case ()
8 Null() using if
9 Null() using if including OR AND
10 AND OR Part1
11 AND OR Part2