ATC-TABLEAU - Tableau

Tableau Fundamentals & Advance serves the beginner to intermediate Tableau user, targeted towards anyone who works with data – regardless of technical or analytical background. This course helps you implement important concepts, techniques& admin activities in Tableau. Move from simple to complex visualizations and combine them in interactive dashboards.

Code: atc-tableau

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

  • Build advanced chart types and visualizations 
  • Build complex calculations to manipulate your data 
  • Work with statistics and statistical techniques 
  • Work with parameters and input controls 
  • Implement advanced geographic mapping techniques and use custom images to build spatial visualizations of non-geographic data 
  • Implement all options in working with data: Joining multiple tables, data blending, performance considerations and working with the Data Engine, and understand when to implement which connection method. 
  • Build better dashboards using techniques for guided analytics, interactive dashboard design and visual best practices 
  • Implement many efficiency tips and tricks 
  • Understand the basics of Tableau Server and other options for sharing your results

Content

Introduction 

  • What is Visualization?
  • What Is Dashboard?
  • Why Tableau?
  • Comparison of Tableau with other tools
  • Limitations of Tableau
  • New features in 2019

 

Connecting to Data 

  • Connecting to files
  • Connecting to data – Basics
  • Editing Data connections and data sources
  • Editing Metadata and saving data sources
  • Joins in Tableau
  • Data Source level Filters 
  • Connecting to Databases
  • Connecting to Oracle, SQL Server, Google Analytics, Different RDBMS Databases
  • Connecting to Big Databases like HDFS, Hive, Greenplum, Teradata
  • Calling Stored Procedure in Tableau
  • Join Types
  • Custom SQLs 


Creating Basic Visualizations  

  • Getting Started in Tableau Desktop 
  • Elements of Visualization 
  • Understanding of Dimensions & Measures 
  • Basic Graphs 
  • Bar Chart
  1. Stacked Bar Chart 
  2. Line Chart
  3. Area Chart
  4. Pie Chart
  5. Filled Maps
  6. Symbol Maps
  7. Scatter Plots 
  8. Trend Line
  9. Bullet Chart
  10. Part to Whole Chart
  11. Tree Map
  12. Word cloud 
  13. Bubble Chart
  14. Discrete Line Charts
  15. Discrete Area Charts 
  16. Highlight Table
  17. Heat Map
  18. Cross Tabs
  19. Normal Tables
  20. Grand Totals, Sub-totals and Changing Aggregation 
  • Dual Axis Graphs
  1. Dual line chart
  2. Side by side bar chart 
  3. Donut Chart
  4. Map and Pie Chart
  5. Map and Donut Chart
  6. Bar in Bar Chart 
  7. Bar & Circle Chart 
  • Measure Name & Measure Values
  1. Multi-line chart
  2. Combo Charts 
  3. Highlight table with Multiple Measures 

 

Simplifying and Sorting Your Data

  • Data Filtering 
  • Local Filters 
  • Global Filters 
  • Data Source Level Filters 
  • Context Filters 
  • Sorting 
  • Sorting Single Dimension Graphs 
  • Sorting Multi Dimension Graphs 
  • Sorting by Different Measures 

 

Organizing your Data

  • Using Groups 
  • Static Groups vs. Dynamic Groups 
  • Creating and Using Hierarchies 
  • Creating a Combined Field 
  • Using Sets 

 

Slicing your Data by Date 

  • Working with Dates 
  • Using Discrete Date Parts 
  • Creating Date Filters 
  • Defining a Fiscal Year 
  • Creating Custom Dates 

 

Data Blending 

  • What is Data Blending? 
  • Data Blending on Multiple columns 

 

File Types in Tableau 

  • TWB vs TWBX, TDE, TDS vs TDSX, TBM 

 

Connection Types 

  • Live Connection Vs Data Extracts 
  • Creating Extracts 
  • Using and Refreshing Extracts 
  • Incremental Refresh 

Dashboard Creation 

  • Creating Dashboards 
  • Actions in Tableau 
  • Navigation Buttons 
  • Dashboard Formatting 
  • Bringing Images, web pages in Tableau 
  • Usage of Containers 
  • Best Practices in Dashboard Designing 

Calculations and Statistics 

  • Edit in Shelf 
  • Introduction to Calculations
  • Statistical Calculations
  • Calculation Types 
  • Creating Calculated Fields 
  • Using Logic Statements 
  • Type Conversions and Date Calculations 
  • Using Quick Table Calculations 
  • Calculations and Aggregations 
  • Conditional Formatting 

 

Using Parameters for Dynamic Values

  • What if Analysis using parameters 
  • Parameters as Column Selectors 
  • Dynamic Reference lines using Parameters 
  • Dynamic Top N values using Parameters 
  • Graph selector using Parameters 

 

Sharing Your Work 

  • Export to an Image File 
  • Exporting the Data Only 
  • Other Sharing Options 
  • Integrating Dashboard to Other Portals 
  • Publishing Dashboards on Tableau Public

 

Dashboard Best Practices 

  • Sizing 
  • Dashboard Designing 
  • Finalizing KPIs 
  • Dashboard Formatting 
  • Working with Big Data 
  • Working in Shared Environment 
  • Parallel Development & Integration 
  • Data Visualization Best Practices 
  • Making Efficient Dashboard 

 

Story Telling 

  • Why Storytelling? 
  • How to Create Story Board 
  • Q&A & Windup Session

Audience

Designed for professionals in a variety of job roles who are currently using desktop or web-based data-management tools to perform numerical or general data analysis. This includes capturing and reporting on data to peers, executives, and clients. These professionals must also provide data visualizations in reports or explain data analysis through visualizations.

  • Data Scientists, Business Intelligence Professionals, and Testing Professionals 
  • Statisticians, Business Analysts, and Project Managers 
  • Data Visualization Analysts and Functional Experts 
  • Graduates and professionals looking to move into the analytics domain

Prerequisites

  • Experience with business intelligence and data visualization. 
  • Excel knowledge

Certification

product-certification
Trainocate Certificate of Attendance

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Advanced Technology Courses Popular Courses

atc-python-programming

The course is all about to learn the Python programming language. Its emphasis the core libraries and most useful libraries developed by the Python.

atc-aif

The Artificial Intelligence Fundamentals course provides a comprehensive introduction to the basic principles and concepts of artificial intelligence (AI). This

atc-isc

Our Trainer the Trainer course is designed to equip aspiring trainers with the skills and knowledge they need to deliver effective and engaging training session

atc-fht200

This course teaches individuals how to become proficient in the administration and management of the Falcon Platform, a cyber-security platform by CrowdStrike.


Enquire Now
 
 
 
 
K7n0jr
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy