Tableau Functions, Calculations, Filters, Unions & Joins

WHO’S THIS FOR?

This course is designed specifically for intermediates but freshers are also welcome who want to understand Tableau Functions, Calculations, Filters, Unions &  Joins.

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.

Section 1:Starter

Lecture 1:Downlaod

(Preview enabled)

Lecture 2:Install

Lecture 3:Visualize Data in workspace

Section 2:Joins Intro

Lecture 4:Join Intro

Section 3:Joins & Unions

Lecture 5:Data Source Files & Join Intro

(Preview enabled)

Lecture 6:Inner Join

Lecture 7:Left Join

Lecture 8:Right Join

Lecture 9:Full Join

Lecture 10:Inner Join in Tableau

Lecture 11:Left Join in Tableau

Lecture 12:Right Join In Tableau

Lecture 13:Full Join In Tableau

Lecture 14:Union

Lecture 15:Union In Tableau

Section 4:Function

Lecture 16:Function Intro

Lecture 17:SUM()

Lecture 18:MIN() & MAX()

Lecture 19:AVERAGE()

Lecture 20:FLOOR()

Lecture 21:CEILING()

Lecture 22:COUNT()

Lecture 23:UPPER()

Lecture 24:LOWER()

Lecture 25:RIGHT() & Left ()

Section 5:Functions & Calculations

Lecture 26:Function

Lecture 27:RANK()

Lecture 28:Rank Dense ()

Lecture 29:Quick Table Calculations

Lecture 30:Running Total

Lecture 31:Difference

Lecture 32:Percent Difference

Lecture 33:Percent of Total

Lecture 34:Rank Part2

Lecture 35:Moving Average Part 1.1

Lecture 36:Moving Average Part 1.2

Lecture 37:Moving Average Part 1.3_

Lecture 38:Date Functions ()

Lecture 39:Now() Today()

Lecture 40:DateName and DatePart ()

Lecture 41:Date Diff ()

Lecture 42:Dateadd ()

Lecture 43:Datetrunc()

Lecture 44:MakeDate()

Lecture 45:COUNT() vs CountD()

(Preview enabled)

Lecture 46:Mid()

Lecture 47:Len()

Lecture 48:Find ()

Lecture 49:Mid() part 2

Lecture 50:Trim()

Lecture 51:Replace()

(Preview enabled)

Lecture 52:Rank_unique Part1

Lecture 53:Rank_unique Part2

Lecture 54:Rank_unique Part3

Section 6:Function & Calculations Part 2

Lecture 55:round zero or round function

Lecture 56:round 1 2 3 4

Lecture 57:absolute()

Lecture 58:Concatenate()

Lecture 59:Replace()

Lecture 60:Table Across

Lecture 61:Table Down

Lecture 62:Table Across Then Down

Section 7:LOD Level of Details

Lecture 63:1

Lecture 64:2

Lecture 65:3

Lecture 66:4

Lecture 67:5_

Lecture 68:6

Lecture 69:7

Lecture 70:8

Lecture 71:9

Section 8:IF & Case Functions

Lecture 72:IF ()

Lecture 73:IF () in Tableau

(Preview enabled)

Lecture 74:IF () OR

Lecture 75:IF () OR in Tableau

Lecture 76:IF () AND

Lecture 77:Nested IF ()

Lecture 78:Case ()

Lecture 79:Null() using if

Lecture 80:Null() using if including OR AND

Lecture 81:AND OR Part1

Lecture 82:AND OR Part2

Lecture 83:Viz 1

Lecture 84:Viz 2

Section 9:Filtrers

Lecture 85:Filters

Lecture 86:Type of Filters

Lecture 87:Data Source Filters

Lecture 88:Quick Filters

Lecture 89:Dimension and Dependent Filters

Lecture 90:Meausure Filters

Lecture 91:Context Filters Part1

Lecture 92:Context Filters Part2

Lecture 93:Context Filter Proper Details Part3

Lecture 94:Date Filter

Lecture 95:Table Across

Lecture 96:Table Down

Lecture 97:Table Across Then Down

Lecture 98:Final

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 1 votes
• 3 stars: 1 votes
• 4 stars: 0 votes
• 5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!