1.
Functions
·
Number Functions
o ABS
o DIV
o EXP
o POWER
o ROUND
o SIGN
o SQRT
o SQUARE
·
String Functions
o ASCII
o CHAR
o CONTAINS
o ENDSWITH
o FIND
o LEFT
o LEN
o LOWER
o LTRIM
o MID
o REPLACE
o RIGHT
o RTRIM
o SPACE
o STARTWITH
o TRIM
o UPPER
·
Date
o DATEADD
o DATEDIFF
o DATENAME
o DATEPARSE
o DATEPART
o DATETRUNC
o DAY
o MONTH
o NOW
o TODAY
o YEAR
·
Type Conversion
o DATE
o DATETIME
o FLOAT
o INT
o MAKEDATETIME
o STR
·
Logical
o CASE
o IF
o IFNULL
o IIF
o ISDATE
o ISNULL
o ZN
·
Aggregate
o ATTR
o AVG
o COUNT
o COUNTD
o MAX
o MEDIAN
o MIN
o SUM
·
User
o FULLNAME
o ISFULLNAME
o ISMEMBEROF
o ISUSERNAME
o ISDOMAIN
o USERDOMAIN
o USERNAME
·
Table Calculation
o FIRST
o INDEX
o LAST
o LOOKUP
o PREVIOUS_VALUE
o RANK
o RANK_DENSE
o RANK_MODIFIED
o RANK_UNIQUE
o RUNNING_AVG
o RUNNING_COUNT
o RUNNING_MAX
o RUNNING_MIN
o RUNNING_SUM
o SIZE
o TOTAL
o WINDOW_AVG
o WINDOW_COUNT
o WINDOW_MAX
o WINDOW_MIN
o WINDOW_SUM
2.
Table Calculations
3.
Adding Reference Line Advanced
4.
Real Time Scenarios
·
Mapping
5 parameters to top 5 Quarters
·
Showing
latest 4 months or quarters dynamically
·
Gap
Analysis using floating bar chart
·
Weekly
sales by year. showing Week dates exactly on axis
·
Region
sales line graph, showing different shapes for connecting points
·
Dynamic
sorting for sales by month-year
·
Sorting
month-year sales based on current month
·
Showing
inventory for selected day if not selected then show last day inventory by
month wise
·
Actual
vs Plan sales graph with variance KPI
·
Showing
First day of year or month sales dynamically
·
sales
vs profit ratio at row level and grand total level
·
Upper/right
triangle matrix, Lower/left triangle matrix, Correlation Matrix table
·
Some
times you wont find synchronize axis option. why ? how to solve this?
·
Bar
Charts in Tool tip
·
Swapping
different measures using parameters
·
Conditional
labeling
·
Quarter
over quarter when quarters looking like 15Q1, 15Q2...
·
Year
over year when quarters are like this 15Q1, 15Q2...
·
Showing
last 4 quarters + current quarter when we have previous and future quarters.
·
YTD
and MTD calculations
·
Showing
Sum(sales) for pane with out repeating same value.
·
Dynamic
sets in tableau
·
How
to Make KPI donut Charts
·
Manually
Choosing the number of bins
·
Creating
Sheet selector
·
Dynamic
Annotations
·
Creating
empty extract
·
How
to create Calendar Heat Maps in Tableau
·
How
to Label the Top of Stacked Bars
5.
Advanced Dashboard Techniques
·
Advanced
formatting techniques
·
Vertical
vs Horizontal containers
·
Best
practices
·
Advanced
Dashboard Actions
6.
Tips and Tricks
7.
Miscellaneous Topics
·
How
to do performance recording
·
Adding
New Color Palette
·
Adding
New Shape Palette
8.
Tableau Desktop 9 New Features
9.
Tableau Desktop 9 LOD Calculations
10.
Certification Guidance And Sample Questions Discussion
suresh.n2008@gmail.com
suresh.n2008@gmail.com