New Batches

Tableau Certification Training

Deriving Insights from Data is an Art-Excel it
Course Preview

Why Should You Take Tableau?

  • Data is the foundation of Digital age. The ability to analyze data properly, communicate data analysis results, and make an impact with data is a critical skill today.
  • IBM, claims that the annual demand for data Analysts will lead to 700,000 new recruitments by 2020.
  • A data Analysis career choice will fetch you an average salary of 95,000 USD - 110,000 USD.

Course Curriculum

It stretches your mind, think better and create even better.
1

Introduction to Excel:

Customizing tabs, options in excel

Name managers

Data validation: Options in data validation for list, whole numbers, dates

Using name manager for data validation

Sorting:

Custom sorting

Subtotals

Sorting left to right

Advanced sorting with multiple options

Advanced filter options

Sorting and filtering with color options

Pivot tables

Short cuts to create pivot tables

Changing row and column labels

Custom format tables and default tables

Changing number formats

Value field settings and summarizing values by 11 different options

Value field settings and showing values as different options

Grouping of continuous fields

Pivot charts, compared regular charts

Slicers, Slicer settings, advanced slicer

Calculated fields in pivot tables

Vlookup and Hlookup:

Syntax for Vlookup

What-if there are errors

Vlookup with data validation

Approximation for Vlookup

Using column function for dynamic column numbers

Using Choose function to select a table for Vlookup

Using Match function to identify column number

Locking cells for absolute and relative cells

Formulae

Auto sum functions

Logical functions

Text functions

Date and Time functions

Lookup and reference functions

Information functions

Charts:

Column charts

Line charts

Pie charts, Pie in pie and Bar of pie, Donut

Stacker bar and clustered bar charts

Area

Scatter charts

Radar charts

Tree maps

Histogram

Waterfall

Funnel

Combo

Conditional formatting:

Duplicate values

Alternate rows

Multiple criteria

Negative numbers

Gantt charts and Formula

Advanced topics:

What-if analysis

Text to columns

Flash fill

Remove duplicates, Consolidate

Grouping, ungrouping and sub-totals

Freezing and unfreezing panes

2

Understanding the start pane

Connecting to data source

Data sources that can be connected

Various file formats

Bookmarks

Understanding the start pane

Connecting to data source

Data sources that can be connected

Various file formats

Bookmarks

TDS, TDE

Connecting to excel, Joins, Splitting data

Live and extract

Dimensions and measures

Clearing sorts and filters

Views: Standard fit width and height

Drilling down

Expanding the marks in pane

Swapping axis

Renaming sheets

Editing color pane

Adding highlighters

Understanding show me

Sorting and hierarchy

Data pane and analytics pane

Different view options at bottom of sheet

3

Hiding and unhiding fields

Creating folders to move dimensions and measures

Adding default colors and properties

Adding multiple data sources

Extracting workbook

Replacing data sources

Data cleansing

Database joins

Blending

4

Default charts

Highlighter for color and shape

Sorting from axis, color, category, manually and clearing sort

Creating groups from pane, manually, visually, parameters, and bins

Adding filter, show filter, wildcards, Top N parameters

Discrete and continuous dates

Types of filters: Applying to specific sheets, Editing page shelf

Hiding cards

5

Sets

Parameters

Tool tips

Cluster analysis

Formatting

6

Building dashboards

Hiding and unhiding sheets

Interface between sheets, dashboard and storyboard

Elements in dashboard

Formatting

Actions in dashboard

Device designer

Story points

7

Word cloud

Bump charts

Box and whisker

Funnel

Step and Line

Pareto

Waterfall

Donut

Lollipop

Pie

Heat map

Waffle

Show me charts

8

Basic syntax

Regular calc and table calc

Adding totals

Date calc

Logic calc

String calc

Number calc

LODs

9

Mapbox

WMS>Layers

Converting geo to non-geo

Chart default

Options for maps

Unrecognized locations

Groups

10

Intro

Syntax

Select

Distinct

Where

And Or Not

Order By

Insert into

Null values

Update

Delete

Top

Min and Max

Count, Avg, sum

Like

Wildcards

In

Between

Alias

Joins

Inner

Left

Right

Full

Self

Union

Group By

Having

Exists

Create table

Drop table

Alter table

Not null

Unique

Primary key

Default

Views

Operators

send

Download

curriculum

Projects

Learn and absorb new things with creative projects.

Global warming

A deep dive analysis on how the average temperatures have been on a rise during the last century. This is to understand which are those countries who were impacted or contributed to this climate change.

IPL

A thorough analysis of team/player performance across different venues / seasons against different opposition. This is to draw insights and predict the future performance of the player on the probability of his success or failure against a given set of opponent and at a particular venue.

Related Course

Power BI

pdf-download
enroll_here

Data Analysis

pdf-download
enroll_here

Tableau

pdf-download
enroll_here

Life at Digital Lync

The environment at Digital Lync is colorful and creative. It is where ideas are incubated and generated. An apt place to explore yourself.

Inspiring student stories.

Here are stories of real knowledge, real people, and real innovation.

Have a Question?

we help you go farther than you ever dreamed, 24/7.
+608011244239

Malaysia

LIVE CHAT

LIVE CHAT

Locations

Come and chat with us about your goals over a cup of coffee
Gachibowli-Hyderabad

1st Floor, Plot No: 6-11, survey No., 40 Khajaguda, Naga Hills Rd, Madhura Nagar Colony, Gachibowli Hyderabad, Telangana 500008

Phone: +91 8688444666

Kukatpally-Hyderabad

Address: #106 & 107, Manjeera Trinity Corporate. Near Manjeera Mall, Kukatpally, Hyderabad, Telangana 500072

Phone: +91 8688444666

Malaysia

11, Pusat Dagang Seksyen 16 Seksyen 16, 46350 Petaling Jaya Selangor, Malaysia

Phone: +60 80112 44239

USA

#23664, Richland Grove Dr, Ashburn, VA 20148

Phone: +1-262-997-9000

© Copyright Lync Digital School Pvt. Ltd | 2019 | Privacy Policy

×

Hello!

Click one of our representatives below to chat on WhatsApp or send us an email to hello@digital-lync.com

×