Performing Calculations in Tableau Desktop

Tableau Desktop
  • 10 Videos | 37m 52s
  • Includes Assessment
  • Earns a Badge
Likes 30
Performing calculations is one of the most essential parts of analysis in Tableau. Calculations allow you to manipulate your data in ways that standard tools cannot. In this 10-video course, learners will explore ways to manipulate various data types with a number of different functions and calculations to solve a wide range of problems. Begin by working with the string functions and using the Calculated Field window, and then work with the date functions by using the Calculated Field window. Use quick table calculations to quickly apply common table calculations to visualizations; create simple LOD [level of detail] expressions and use them in visualizations; and observe the use of EXCLUDE and FIXED LOD expressions in calculations. Discover how to perform ad-hoc calculations; configure aggregate and disaggregate options, and perform logical calculations. The course concludes by focusing on the use of arithmetic and aggregate calculations, and using join calculations to work with data where common fields are missing in the two sources.

WHAT YOU WILL LEARN

  • work with the string functions using the Calculated Field window
    work with the date functions using the Calculated Field window
    use quick table calculations to quickly apply common table calculations to visualizations
    create simple LOD expressions and use them in visualizations
    demonstrate the use of EXCLUDE & FIXED LOD expressions in calculations
  • create ad-hoc calculations using existing fields
    demonstrate the approach to setting default aggregation for any measure which is not a calculated field and disaggregate all measures in the view
    create logical calculations to determine if certain conditions are true or false
    use aggregate functions to summarize or change the granularity of data
    demonstrate how to use join calculations to work with data where common fields are missing in the two sources

IN THIS COURSE

  • Playable
    1. 
    Manipulating string calculations
    4m 4s
    UP NEXT
  • Playable
    2. 
    Manipulating date calculations
    3m 1s
  • Locked
    3. 
    Creating quick table calculations
    3m 36s
  • Locked
    4. 
    Using Level of Detail expressions
    5m 7s
  • Locked
    5. 
    Using EXCLUDE & FIXED Level of Detail expressions
    4m 18s
  • Locked
    6. 
    Performing ad-hoc calculations
    3m 10s
  • Locked
    7. 
    Configuring aggregate & disaggregate options
    3m 20s
  • Locked
    8. 
    Performing logical calculations
    3m 6s
  • Locked
    9. 
    Using arithmetic & aggregate calculations
    4m 20s
  • Locked
    10. 
    Creating calculated joins between fields
    3m 50s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE