CÔNG TY TNHH TRAINOCATE VIỆT NAM
ATC-TABLEAU - Tableau

ATC-TABLEAU - Tableau

Overview

Duration: 5.0 days

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.

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

Trainocate Certificate of Attendance

Lịch khai giảng

Form đăng ký

Bằng cách nhấn nút "ĐĂNG KÝ", tôi hoàn toàn đồng ý với Chính sách bảo mật

Các khóa đào tạo Advanced Technology Courses khác

ATC-DSM - Professional Specialist Diploma in Search Marketing

The Professional Specialist Diploma in Search Marketing is an in-depth 30-hour course created and validated by the Digital Marketing Institute (DMI). In 2017, DMI was named by ValueColleges.com as among the top 30 best value digital marketing certification programs, the only non-traditional university in the list. The Professional Specialist Diploma in Search Marketing empowers and imparts you with the necessary skills to create, manage and implement advanced search marketing strategies using AdWords, PPC marketing, display marketing & remarketing techniques. The Diploma will provide you with the know-how to increase visibility of your brand and convert traffic from within search engines that is crucial to nearly every business operating today. This course is a 4 -day classroom training and at the end of the classroom training, a 3 hours certification exam may be taken. Becoming a Certified Search Marketing Professional will provide and equip you with the elements of search campaign planning, creation and measurement, along with an accredited certification to validate your new expertise. The Professional Specialist Diploma in Search Marketing Certificate is awarded to candidates passing the examination. The Professional Specialist Diploma in Search Marketing Certificate has been credit rated by Scottish Qualification Authority (SQA) at Level 8 on the Scottish Credit and Qualifications Framework (SCQF). SCQF level 8 corresponds to level 5 on the European Qualifications Framework (EQF).
4.0 ngày

Đăng ký tư vấn
cùng đội ngũ chuyên gia Trainocate!!

Bản quyền thuộc về Trainocate Việt Nam

back to top
icon đăng ký