Highlights
- Gain an insight into the more advanced functionality of Tableau
- Extract further business intelligence insights adding value to your data
- Integrate and blend cross-database data and blend data sources
- Subset, Field, Table and LOD (Level of Detail) calculations
- Use parameters to make dynamic outputs.
- Maps and Images customisation
- Trends, data distribution and forecasting
- Advanced dashboards and data storytelling
Course Details
What Should I already Know?
Foreword
Query Sequence
Dashboard Revision
Measure Values and Measure Names Dates
What Ways Can I Connect To My Data?
Using Data Sources and Connections
Comparing Data Connection Options
Joins
Joining Tables
Cross Database Joins
How Data Blending Works
Using Data Blending
Exploring Effect of Primary Data Source Selection
Unions
How Do I Create Calculated Subsets of Data?
Using Sets
Showing the Biggest and the Smallest
Nested Top N with Context
Nested Top N with Rank
How Do Calculations Work And What Is LOD?
Understanding Where Calculations Occur
Creating and Editing Calculated Fields
Join Calculations
Calculations and Aggregations
Calculations Performed on the Database
Calculation and Aggregation in Overall Profitability
Aggregating Dimensions in Calculations
Level of Detail (LOD) Expressions
How Can I Define Table Calculations?
Table Calculation Overview
Table Calculation Scope and Direction
Other Scope and Direction Options
Null Values in Table Calculations
Profitability as a Percent of Total
Table Calculations for Statistical Analysis
Moving Average
How Can I make Things Dynamic?
Using Parameters
Parameters and Filters
Dynamic Measure Selection and Reference Line
How Do I Create Data Extracts?
Using Data Extracts
How Do I Compare Progress?
Comparing Two Measures (Bar in Bar Graph)
Bar in Bar Chart
Comparing Progress Toward a Goal (Bullet Graph)
How Do I Customise Maps and Use Images?
Navigation and Selection in Maps
Background Maps and Layers
Modifying Geocode Locations within Tableau
Using Background Images for Spatial Analysis
Background Images
Using Spatial Files for Mapping
How Is My Data Distributed?
Bins and Histograms
Box and Whisker Plots
How Can I See and Use Trends In My Data?
Trend Lines
Using the Analytics Pane
Trend Lines with Small Multiples
Forecasting
Forecast Field Results
Forecast Options
Improving Dashboards and Telling Data Stories
Planning Your Dashboard
Building Your Dashboard: Advanced Techniques
Adding Interactivity to Your Dashboard
Applying Visual Best Practices
Creating a Dashboard
Navigating Between Dashboards
Device Specific Dashboards
Telling Stories with Data
Who should attend
Business Analysts, Financial Analysts, Data Scientists and Staff who need to use Tableau for producing reports from Excel, SQL Server and other databases.
Learn to build Dashboards like this - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...
Feedback
4.8 out of 5 average
"The beyond the basics course supplied a fantastic step up from my existing Tableau knowledge, so I am now able to use data stories, maps, images and other visual methods for data analysis."
ML, Data Analyst, Tableau - Beyond the Basics, March 2021
“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”
Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022
