Curriculum

Data Analytics with Tableau

Module 1: Introduction to Business Intelligence

• Business Intelligence

• Data Integration

• Data Processing

• Data Presentation

• ETL Architecture

• Introduction to Data Analytics.

• Types of Data Analytics.

• Descriptive Analytics

• Diagnostic Analytics

• Predictive Analytics

• Prescriptive Analytics

Module 2: Introduction to Tableau

• Introduction to tableau

• Overview & Features

• Connecting Tableau to Data Sources

• Working with Flat files

• Connecting spreadsheets

Module 3: Data Extraction

• Introduction to Database

• Creating Database & Table

• CRUD Operation on database tables

• Basic SQL Operations

• Basic SQL Operations

Module 4: Architecture of Tableau

• Architecture of Tableau

• Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane, etc.)

• Tableau field types

• Saving and publishing a data source

• Live vs extract connection

• Various file types

• Ways to share and export the work done in Tableau

Module 5: Charts

• Histograms

• Box plot

• Motion

• Pie

• Bar

• Line

• Bubble

• Bullet

• Scatter

• Tree

• Heat maps

• Maps

• Text table

• Highlighted table

• Custom Charts

Module 6: Working with Metadata and Data Blending

• Connecting to Data Source

• Tableau data types

•  Connection to Excel

•  Cubes and PDFs

•  Management of metadata and extracts

•  Data preparation

• Joins (Left, Right, Inner, and Outer) and Union

•  Dealing with NULL values, cross-database joining, data extraction, data blending, refresh extraction, incremental extraction, how to build extract, etc.

•  cross-database joining

•  Data blending

Module 7: Advanced Data Manipulations

• Preview

• Mark and highlight

• Groups

• Sets (creating and editing sets, IN/OUT)

• Constant sets

• Computed sets

• Combined sets

• Bins

• Hierarchies

• Sorting and Types

• Using the Formatting pane to work with the menu, fonts, alignments, settings, etc.

• Editing axes and annotations

Module 8: Working with Filters, Organizing Data 

• Filters (addition and removal)

• Working with filters

• Filtering continuous dates, dimensions, and measures

• Filtering in Tableau

• Types of filters

• Filtering the order of operations

Module 9: Calculated Fields, Quick Table Calculations & LOD Expressions

• Calculated Fields in Tableau

• Quick Table Calculations

• LOD Expressions in Tableau

Module 10: Working With Mapping ,Calculations and Expressions

• Working on coordinate points

• Plotting longitude and latitude

• Editing unrecognized locations

• Customizing geocoding, polygon maps, WMS: web mapping services

• Working on the background image, including add image