ad

Tableau Desktop Advanced Course

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