Tableau Desktop Qualified Associate

Tableau is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data into the very easily understandable format. Data analysis is very fast with Tableau and the visualizations created are in the form of dashboards and worksheets.
Over the last 2 years a number of our clients have stressed upon the importance of know a Data Visualisation Tool like Tableau. Real Time Visualisation techniques have enabled better and quicker decision making across the globe. In our case we chose Tableau. If you look carefully the Tableau Program we provide enables and equips you to sit for 3 International Certifications.

1)Desktop Specialist 2) Desktop Qualified Associate
The Syllabus and content of our Tableau I module effectively covers what is required for the above 2 certifications.
3) Desktop Certified Professional
The Syllabus and content of our Tableau II module effectively covers what is required for the above.

Main Features

  • Download, install and run the full version of Tableau Public.
  • Be able to create analyses, such as line charts, stacked bar charts, or geographic analyses using maps.
  • Format and customize your graphs and charts to make it look appealing.
  • In depth understanding of more advanced features, such as Calculated Fields, Parameters and Hierarchies.
  • Get acquainted with worksheet interface.
  • Learn how to join datasets and perform analysis and construct charts on the joint data set.
  • Learn how to apply filters and use them dynamically.
  • Learn importing Excel, SPSS, Txt, CSV & SAS Files.
  • Perform all tips and tricks to make your visualization elegant and interpretable.

Introduction to Tableau

1
Introduction to Excel
2
Conditional Formatting
3
General formatting Options
4
Tableau screens
5
Dimensions
6
Measures
7
Marks
8
Filter Tab
9
Columns, rows
10
Data tab, analytics tab
11
Views in Tableau, creating a simple view (box plot)

Importing Data and Publishing Data

1
Data source Page
2
Connecting to an excel file
3
Connecting to a statistical file
4
Extract vs Live data
5
Saving Data
6
Publishing to server

Formatting

1
Colour, Size, Label, Tooltip
2
Changing the size of the label
3
Applying labels at start point and endpoints
4
Giving different labels to different sections of the view
5
Formatting the different labels with different colors
6
Formatting different axis with different scales

Annotation-Point Area

1
Putting the annotation over a specified period of time
2
Highlighting the point section of a particular point based on a value
3
Applying a border over the annotation area
4
Formatting Axis through View, Worksheets
5
Formatting the different axis with different labels
6
Formatting through filters
7
Formatting range in Y Axis
8
Creating own axis scale
9
Map formatting options

Tooltips

1
Applying tooltips to a view
2
Giving a border to the tooltip in the view
3
Adding variables to tooltip

Alias in tableau

1
Creating alias in tableau
2
Applying the alias to the view

Hierarchy in tableau

1
Need for hierarchy in tableau
2
Types of hierarchy in tableau
3
Creating a simple hierarchy with two variables
4
Multi-level hierarchy with multiple related variables
5
Concept of drill down hierarchy
6
Drilling down hierarchy with the user defined hierarchy
7
Date hierarchies

Sorting Data

1
Quick sort
2
Sorting from pill
3
Sorting across panes
4
Clearing sort
5
Pill types and sorting options
6
Sorting a variable from the view
7
Sorting a view based on a numeric variable not in view

Grouping in Tableau

1
Need for grouping
2
Grouping from header
3
Grouping from data pane
4
Using grouped field
5
Grouping marks-visual grouping
6
Using Calculations to Create Groups
7
Concept of parameters in grouping
8
Parameterized calculated Groups
9
Concept of bins
10
Creating and using bins
11
Grouping through creating and using Bins

Calculations in Tableau

1
Types of Calculation functions
2
Table calculation
3
Quick table calculation
4
In shelf calculation
5
Calculation syntax
6
Using and LOD Expression
7
LOD Expression syntax
8
Fixed and Include, Exclude
9
Nested LOD Expressions
10
Calculation using categorical and numerical variables
11
Calculating across variables in view
12
Calculating using top down approach
13
Calculating across panes
14
Manual table Calculations
15
Manual table calculations- user creating formulas
16
Compute using specific dimensions or variables
17
Aggregate Calculation-AGG calculation
18
Aggregated versus record level calculations
19
Attribute calculation-ATTR calculation
20
Calculation using date variables- Date Calculation
21
Calculation using numeric variables
22
Logical calculation using conditions-if, else if ,then
23
Performance Indicator with parameter
24
Logical Conditional Filter
25
String calculation
26
Type Calculation-converting across data types
27
Operators-types of operators
28
Uses of operators
29
Functions in tableau
30
Comparing Values using functions

Parameters

1
Why is there a need to use parameters
2
How to use Parameters
3
Coding parameters
4
Parameter with Filter
5
Parameter with sets
6
Parameter with Calculated Field
7
Parameters with Reference lines
8
Parameter Types

Filtering Data

1
What is filtering, how filtering gives a concise view
2
Different Ways to filter views
3
Filtering from the Pill
4
Filtering Dimensions
5
Filtering Measures or Continuous Dimensions
6
Filtering Continuous Date
7
Interactive Filtering-filtering from view
8
Layout Mode for Interactive Filters
9
Hierarchical or cascading Interactive Filters
10
Filtering through variables not in view
11
Filtering through wildcard characters or pattern matching
12
Aggregate filtering
13
Record level filtering
14
Context Filter
15
Performance and Filter queries

Creating Sets

1
Why are sets needed
2
Creating sets from variables
3
Creating sets from parameters
4
Creating sets from calculated fields
5
Creating sets from combining sets
6
Editing sets
7
In/Out versus members
8
Sets and Filters
9
Sets in Hierarchies and calculations

Joining data

1
Joining across multiple data sources
2
Data blending concept
3
Applying data blending
4
Left Join
5
Right Join
6
Inner Joins
7
Union
8
Outer Joins
9
Blend Relationship
10
Swapping primary and secondary data sources
11
Data Blending and calculation
12
Working with null values
13
Asterisks when blending
Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Enrolled: 34 students
Duration: 40 hours
Lectures: 137
Video: 9 hours
Level: Intermediate

Archive

Working hours

Monday 9:30 am - 7.00 pm
Tuesday 9:30 am - 7.00 pm
Wednesday 9:30 am - 7.00 pm
Thursday Closed
Friday 9:30 am - 7.00 pm
Saturday 9:30 am - 7.00 pm
Sunday 9:30 am - 7.00 pm
WhatsApp chat