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.

Learn how to use a TABLEAU Desktop (Data Visualization) most demanded tool in the industry today. Give your career a boost. With our online tutorials, 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

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