About Tableau Big Data:
Data Visualization is one of the key aspects of the data analysis. It is very important to present the data in an understandable and visually appealing format. Data visualization is an important skill that Data Scientists have to excel in to communicate effectively with their clients.
Data visualization helps the data scientists to communicate effectively with their end users. The outcome of the data analysis cannot be comprehended easily to those who do not deal with data directly. Data visualization bridges that gap and makes people appreciate the possibility of the data analysis.
Tableau is one of the leading business intelligence tools to accelerate your business and make it easy-to-comprehend by clients and consumers. This BI data visualization tool is highly scalable, easily deployable and highly efficient in presenting the data in a visually appealing format to the end users. Tableau is the leader in this year’s Gartner Magic Quadrant for the third consecutive year. This visualization software received appreciation from large enterprises and business audiences across the globe.
Course Overview:
Our training course teaches you to apply design principles, color theory, and effective storytelling with data. If you aspire to be a business analyst or data scientist, or if you’d like to become more effective with visualization tools, then you can sharpen your skills with this course. Our training course helps you to learn the key concepts of Data Visualization and how data can be transformed by cleaning, splitting, pivoting, and merging using Tableau 10.
In this training, we discuss the architecture of Tableau, the connections established with data sets, perform Joins on the datasets and explore the new cross join that is now possible with data integration.
We will teach you to discover new ways to analyze your data such as, quick highlighting, reference lines, and use the new Clustering feature. You will learn to create personalized, dynamic visualizations by using Parameters to take user input and drive the visualization. We will also discuss good design practices for dashboards and how to make them fully interactive using Actions. We will give you extensive hands-on activities using Tableau 10 thereby emphasizing the concepts which will help to implement in the real-time world.
This training will help you clear the Tableau Associate Certificate Level Exam. This training course is useful for:
- Professionals working with large volume of data
- Tableau professionals who want to understand R Connectivity with Tableau
- Data scientists and BI Analysts
- Big data professionals aspiring to learn new and innovative techniques of presenting the data for clients.
Prerequisites:
Any individual who wants to learn Tableau training should have a basic knowledge of Computer Programming terminologies and Data analysis. A basic knowledge of the creation of graphs and charts is desired. Familiarity with SQL will be an added advantage.
Tableau Course Content:
Introduction to Data Visualization and Power of Tableau:
- What is Data Visualization
- Comparison and benefits against reading raw numbers
- Real usage examples from various business domains, some quick powerful examples using Tableau without going into the technical details of Tableau
Architecture of Tableau:
- Installation of Tableau Desktop
- Architecture of Tableau
- Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane etc)
- How to start with Tableau
- Ways to share and exporting the work done in Tableau
Hands-on Exercise – Play with the tableau desktop, interface to learn its user interface, Share an existing work, and Export an existing work
Tableau Data Sources:
- Tableau Data sources
- Custom Data View
- Extracting Data
- Field Operations
- Editing Meta Data
- Data Joining
- Data Blending
Working with Metadata & Data Blending:
- Connection to Excels
- PDFs and Cubes
- Managing Metadata and Extracts
- Data Preparation and dealing with NULL values, Data Joins (Inner, Left, Right, Outer) and Union
- Cross Database joining, Data Blending
Hands-on Exercise – Connect to an excel sheet and import data, Use metadata and extracts, Handle NULL values, Clean up the data before the actual use, Perform various join techniques, Perform data blending from more than one sources
Creation of sets:
- Marks, Highlighting, Sort and Group
- Working with Sets (Creation of sets, Editing sets, IN/OUT, Sets in Hierarchies)
Hands-on Exercise – Create and edit sets using Marks, Highlight desired items, Make groups, Applying sorting on result, Make hierarchies in the created set
Working with Sort & Filters:
- Basic Sorting
- Filters (Addition and Removal)
- Basic Filters
- Quick Filters
- Context Filters
- Condition Filters
- Filtering continuous dates
- Dimensions, measures, Interactive Filters
Hands-on Exercise – Add Filter on data set by date/dimensions/measures, Use interactive filter to views, Remove some filters to see the result
Organizing Data and Visual Analytics:
- Formatting Data (Labels, Annotations, Tooltips, Edit axes)
- Formatting Pane (Menu, Settings, Font, Alignment, Copy-Paste)
- Trend and Reference Lines, Forecasting
- k-means Cluster Analysis in Tableau
Hands-on Exercise – Apply labels, annotations, tooltips to graphs, Edit the attributes of axes, Set a reference line, and Do k-means cluster analysis on a dataset
Working with Mapping:
- Coordinate points
- Plotting Longitude and Latitude
- Editing Unrecognized Locations
- Custom Geocoding
- Polygon Maps, WMS: Web Mapping Services, Background Image (Add Image, Plot Points on Image, and Generate coordinates from Image)
Hands-on Exercise – Plot latitude and longitude on geo map, Edit locations on the map, Create custom geocoding, Use images of a map and plot points on it, find coordinates in the image, Create a polygon map, Use WMS
Working with Calculations & Expressions:
- Calculation Syntax and Functions in Tableau
- Types of Calculations (Table, String, Logic, Date, Number, Aggregate)
- LOD Expressions (concept and syntax)
- Aggregation and Replication with LOD Expressions
- Nested LOD Expressions
Working with Parameters:
- Create Parameters
- Parameters in Calculations
- Using Parameters with Filters
- Column Selection Parameters
- Chart Selection Parameters
Hands-on Exercise – Create new parameters to apply on a filter, Pass parameters to filters to select columns, Pass parameters to filters to select charts
Charts and Graphs:
- Dual Axes Graphs,
- Bullet Graphs
- Histogram (Single and Dual Axes),
- Box Plot
- Scatter Plot
- Pareto Chart
- Bump Chart
- Gantt Chart
- Motion Chart
- Funnel Chart
- Waterfall Chart
- Tree Map
- Heat Map
- Market Basket analysis
Hands-on Exercise – Plot a histogram, heat map, tree map, funnel chart and others using the same data set, Do market basket analysis on a given dataset
Dashboards and Stories:
- Build and Format a Dashboard (Size, Views, Objects, Legends and Filters),
- Best Practices for Creative and Interactive Dashboards using Actions,
- Create Stories (Intro of Story Points, Creating and Updating Story Points, Adding Visuals in Stories, Annotations with Description)
Hands-on Exercise – Create a dashboard view, Include objects, legends and filters, Make the dashboard interactive, Create and edit a story with visual effects, annotation, and description.
Tableau Advanced course:
- Tableau Dashboard
- Tableau Formatting
- Tableau Forecasting
- Tableau Trend lines.
Integration of Tableau with R and Hadoop:
- Introduction to R Language
- Applications and Use Cases of R
- Deploying R on Tableau Platform
- Learning R functions in Tableau
- Integration with Hadoop
Hands-on Exercise – Deploy R on tableau, Create a line graph using R interface, Connect tableau with Hadoop and extract data
Certification:
On successful completion of our training course, and through with our project, you will be awarded Tableau Desktop Qualified Associate certificate. Our certification has industry recognition and we are the preferred training partner for many top companies like Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Ford, Mindtree, BNYMellon etc.
Job and Placement:
A certified Tableau developer is highly accepted in most of the top MNCs, as every company which is implementing Big Data needs data visualization.
Organizations are turning towards Big Data technologies such as Hadoop, Spark and SQL databases to meet their fast evolving data needs. Tableau Developers work closely with the Big Data leaders. Tableau Developers at various designations help to find that value in your company’s data interpret in a meaningful way so that your company gets the most out of its data. From manufacturing to marketing, finance to aviation- Tableau Developers helps businesses see and understand your data. The average Tableau Developer salary in U.S.A is $114,000.