by Siddharth Pawar | Released September 2018 | ISBN: 9781789133790

Find new opportunities in your business that you have never seen before by learning advanced data analytics with TableauAbout This VideoGain a practical understanding by working with new Tableau 2018.1 features such as dual axis mapping improvements, improved hierarchy filtering, visualization and tooltip improvements, step and jump lines, SQL Server spatial data, additional clustering functionality, and analytical object guidance.CREATE TABLE IF NOT EXISTSs and charts, annotate and format charts, and map geographic data and dashboards to analyze results.Build visualizations that go beyond the default styles by leveraging advanced features and processing your data.In DetailTableau has brought the world of visual analytics within the reach of many nonplussed by Excel charts and graphs. But after acquiring the basic skills, there is a learning curve that gets in the way of using Tableau to its full potential.This course will give you the tools to use Tableau to its fullest and make optimal business decisions with rich analytics. If you want to be more feature-ready to use Tableau and perform effective data visualizations and analysis, then this course is for you. After taking this course, you will be confident enough to use advanced Tableau features and other tools. You will develop the skills to perform in-depth analyses for effective business decision making. Your skills will no longer be at an intermediate level; you will now be a master of data analysis using Tableau. You will be able to connect to data sources; summarize data; and create, manipulate, and share data visualizations including highlight tables, charts, scatter-plots, histograms, maps, dashboards, and more.By the end of this course, you will be able to build useful, thoughtful, and beautiful visualizations that will help you make databases and spreadsheets understandable to ordinary people.The code bundle for this video course is available at - https://github.com/PacktPublishing/-Mastering-Tableau-2018.1-Second-Edition Show and hide more Publisher Resources Download Example Code

1. Chapter 1 : Getting Started with Tableau 2018.1
   • The Course Overview 00:06:38
   • Exploring Tableau and Data Visualization 00:09:07
   • Understanding Tableau File Types and Workspace 00:13:15
   • Business Case for Visualizations with an Advanced Practical Example 00:04:38
2. Chapter 2 : Connect with Single Data Sources
   • Understanding the Connect Page and Global Superstore Dataset 00:08:19
   • Connecting to the Global Superstore Dataset 00:01:54
   • Saving Data Sources and Workbooks, Live, or Extracts 00:05:04
3. Chapter 3 : Clean and Prepare Your Data
   • Data Preparation and Cleaning Data Sources with Dates and Numbers 00:17:41
   • Data Preparation and Cleaning Data Sources with Text and Geography 00:09:14
   • Using the Data Interpreter 00:04:27
4. Chapter 4 : Combine and Transform Data with Multiple Data Sources
   • Joining Your Data 00:06:51
   • Data Blending with Tableau 00:09:18
   • Combining Your Data with Union 00:05:19
   • Creating Charts from Multiple Data Sources 00:06:38
5. Chapter 5 : Filtering and Sorting with Tableau Data
   • Creating Your First Visual 00:04:01
   • Working with Selection Filters 00:04:01
   • Creating a Wildcard Filter 00:03:26
   • Creating a Condition Filter 00:02:59
   • Creating a Top Filter 00:02:44
   • Working with Colors and Shapes 00:05:52
   • Working with Data Labels and the Tooltip 00:06:08
   • Understanding Aggregations 00:06:15
   • Working with Sorting and Nested Sorting 00:08:56
6. Chapter 6 : Groups, Sets, and Hierarchies
   • Working with Grouping, Drill Down, and Date Hierarchies 00:12:59
   • Working with Sets 00:09:05
   • Using Parameters to Control Visualization Interactivity 00:15:39
7. Chapter 7 : Create Custom Calculations and Fields
   • Working with Table Calculations 00:07:54
   • Quick Table Calculations – Running Total and Difference 00:06:46
   • Quick Table Calculations – Percent Difference and Percent of Total 00:05:21
   • Quick Table Calculations – Rank 00:06:38
   • Understanding Window Table Calculations 00:07:51
   • Nested Table Calculations in Tableau 00:03:49
   • Creating Ad-hoc Calculations 00:03:41
8. Chapter 8 : Reference Lines, Parameters, and Analysis
   • Using Reference Lines 00:05:00
   • Using Parameters to Create and Control Reference Lines 00:03:56
   • Using Step and Jump Lines 00:04:32
   • Clustering Data in Tableau 00:03:11
   • Creating Pareto Charts in Tableau 00:05:14
   • Visualize Benford’s Law 00:10:07
9. Chapter 9 : Run Complex Queries with Level-of-Detail Expressions
   • Exploring Level-of-Detail (LOD) Expressions 00:06:52
   • Going from Regular Expressions to Level-of-Detail Expressions 00:05:44
   • Working with Fixed, Include, Exclude Expressions 00:08:45
   • Using Nested LOD Expressions 00:06:35
   • Using Filters and LODs 00:05:14
10. Chapter 10 : Spatial Analysis, Mapping Geographical Data, and Geocoding
    • Connecting to Existing Spatial Data 00:04:09
    • Develop Geographic Visualizations Using Colors, Shapes, and Filtering 00:03:03
    • Dual Layer Mapping 00:04:15
    • Custom Geocoding 00:07:32
    • Working with Pathway and Territories 00:11:16
11. Chapter 11 : Create Dashboards and Actions
    • Data Visualization Best Practices for Effective Dashboards 00:11:32
    • Formatting Data with Different Formatting Techniques 00:11:12
    • Design Tricks for Great Dashboards 00:07:02
    • Actions and Highlighting on Dashboards 00:08:50
    • Storyboarding 00:06:47
Show and hide more