Overview
This two-day, lab-intensive, hands-on course is targeted towards experienced Tableau users with a background and interest in data analysis. The course explores basic to advanced level concepts of data visualization with Tableau. It also covers the fundamentals of data organization and scripting, visualization, playing with time dimension, incremental loading and blending, as well as integrating Tableau with Hadoop and R.
What You'll Learn
- Understand why data visualization is needed
- Connect to the databases and make basic charts and graphs
- Make advanced charts and graphs
- Learn scripting functionality and organizing data for effective results
- Learn about more advanced visualizations for various analytical requirements
- Create time based calculations
- Use location analytics capabilities to put geographic and other spatial context to analysis
- Blend and arrange data from multiple source systems for effective analysis
- Learn how to integrate Tableau with R and Hadoop, statistical analysis and social media analysis
- Work in real-time environment for Tableau projects (A mini project is provided with business scenarios)
- Understand the requirement and creating various dashboards, story boards, deploying your dashboards for the project
Curriculum
Why Data Visualization is Needed
- Making sense out of Numbers
- Uses of Tableau
- Installation
- Architecture
- Features of Tableau.
Connect to the databases and make basic charts and graphs.
- Exporting Data
- Connecting Sheets
- Loading into Tableau visualization engine.
- Basic visualizations: Text Tables, Bar, Line, Pie charts,
- Basic maps; interpreting the same.
Make Advance Charts and Graphs.
- Highlight Tables
- Heat Maps, Circle Plots, Side by Side Bars, Continues Lines, Scatter Plots, Dual Charts, Area Charts, Tree Maps.
Learn scripting functionality and organizing data for effective results.
- Calculated Metrics
- Sorting, Filtering
- Totals and Sub Totals
- Various Aggregated Measures, Percentages,
- Data Spotlighting, Summary Card.
- Date and time functions, String Functions and logical functions
- Data Items,
- Data behind your views
- Hierarchies, Sets, Groups, Bins.
Learn about more advanced visualizations for various analytical requirements
- Dual Charts, Dual Axis, Combination charts, Gantt Charts for activity tracking,
- Motion Charts, Box and Whisker Plots
- Reference Lines, Reference Bands
- Pareto Analysis
- Water Fall Charts
- Market Basket Analysis
Create Time based calculations.
- Quick Table Calculations, Custom Table Calculations, YTD
- Parallel Period, Moving Averages, Running totals, Window Averages, Trend Lines and Predictive Models.
Location analytics capabilities to put geographic And other spatial context to your analysis.
- Filled Maps, Symbol Maps
- Geo Coding
- Online Maps
- Sorting in Maps
- Background Maps.
Blend and arrange your data from multiple source systems for effective analysis.
- Data Blending from multiple source systems
- Custom SQL Queries
- Creating Incremental Loads
- Creating File Extractions
Integration of Tableau with R and Hadoop, Statistical Analytics, and social media analytics.
- Connect to Hadoop Systems from Tableau
- Integrating Tableau with R
- Connecting to R Server Parameterized R calls
- Mean, Median, Mode, Standard Deviation,
- Forecasting Models
Sharing Insights with Enterprise Dashboards: Work in real time environment for Tableau Projects. one mini project will be provided with business scenarios. Understand the requirement and creating various dashboards, story boards, deploying your dashboards for the project.
Mini end-end project with Business case study. Interactive Dashboards, Action Filters, Story Boards, Best Practices, Cover Pages, Annotations, Tool Tips, keyboard short cuts, Legends, Sharing your work, Deploying to server, Tableau Online, Tableau Reader, and Tableau Public.
Who should attend
The course is highly recommended for –
- Integration analysts
- Data analysts
- Data visualizers
- Financial analysts
- Business analysts
- Programmers
- Business intelligence professionals
Prerequisites
This is an advanced level Tableau course, so participants need to have experience working with Tableau.
