OVERVIEW
This course provides a comprehensive introduction to data analysis and visualization using Tableau, one of the leading business intelligence tools. Participants will learn how to connect to various data sources, clean and prepare data, and create interactive dashboards that uncover insights. The course covers essential Tableau features, including charts, graphs, calculated fields, filters, and parameters, enabling learners to make data-driven decisions. By the end of the course, students will be able to transform raw data into meaningful visual stories, enhance reporting efficiency, and communicate insights effectively.
Benefits of Data Analysis Using Tableau Training Course in Vellore
Helps visualize complex data using interactive charts and dashboards for clear understanding.
Provides real-time insights, enabling faster and smarter business decisions.
Features an easy drag-and-drop interface suitable for both technical and non-technical users.
Connects effortlessly to multiple data sources such as Excel, SQL, and cloud platforms.
Makes it simple to identify patterns, trends, and key performance indicators.
Data Analysis Using Tableau Course Syllabus
Data Analytics Fundamentals
- Introduction of Data Analytics
- What is Data Analytics?
- Why is Data Analytics Important?
- Where is Data Analytics used
- Popular Tools for Data Analytics - Tableau, Power BI and Other data analytics tools
INTRODUCTION TO Tableau
- Understanding the concepts of Data Warehouse DWH
- Necessity and purpose for building DWH
- Understanding various tools required to build DWH
- Understanding Business Intelligence and BI Tools
- Understanding Data Visualization
- Advantages of Data Visualization
- Demand for Data Visualization for various business requirements
- Introduction to Data Visualization Tools
- Advantages of using Tableau
- Tableau as a Desktop Application
- Installing and setting up Tableau
Getting Started with Tableau
- Understanding the Tableau Suit
- Understanding the Tableau Architecture
- Understanding the Tableau Repository
- Exploring Data Sources
- connecting to Data Sources
- Exploring the Tableau Workspace
- Understanding Dimensions and Measures
- Working with Data Type
- Understanding the Default Properties
- Understanding Shelves and Mark Cards
- Understanding Show Me!
- Creating Basic Views
- Saving and Sharing
Tableau Basics
- Data Terminology
- Navigation
- Start Page
- Design Flow
- File System
- Data Types
- Highlight Tables
- Changing Data types
- Date functions
- Show Me
Basic Visualizations
- Create Visualization
- Change the order in visualization
- Change the summary
- Sorting by field in Visualization
- Box Plot
- Line graph
- Dual Lines Chart
- Bar Chart
- Heat Map
- Histogram
- Scatter plot
- Pie chart
- Bubble Chart
Advanced Visualizations
- Side-by-Side Bars
- Stacked Bars
- Lollipop Chart
- Cumulative Histogram
- Crosstab
- Total in a crosstab by column
- Bullet Graph
- Basic MapArea Chart
- Basic Map
- Geographical plot
- Circle views
- Dual Combination Chart
- Treemap
- Funnel Chart
- Traditional Funnel Chart
- Waterfall Chart
- Gantt Chart
Tableau Calculations
- Operators
- IF Function
- Aggregate Functions
- Create Calculated Field
- Logical Functions
- Case Function
- Highlight Tables
- Quick Table Calculation
- LOD Calculation
Sorting and Filtering and Grouping
- Filtering in Visualization
- Quick Filter
- Context Filter
- Conditional Filter
- Slicing Filter
- Types of filters in Tableau and their Order of Operations
- Grouping in Visualization
- Hierarchy
- Set
- Combined Set
- Parameters
- Bins
- Manual Sorting of Visualization
- Sorting by Data Source order in Visualization
- Sorting by field in Visualization
Working with Dashboards
- Create a Dashboard
- Text Object on Dashboard
- Image Object on Dashboard
- Objects on Dashboard
- Filters in Dashboard
- Device Preview
- Format Dashboard Layout
Advanced Tableau Features
- Forecast
- Reference line
- Reference Band
- Reference Distribution Band
- Trend Lines
- Building up a storyline
- Word Cloud
- Advanced Tableau Skills
Data Modeling
- Relationships vs Joins vs Blending (newer Tableau versions emphasize relationships)
Tableau Prep / Data Preparation
- Tableau Prep Builder: flows, cleaning, pivoting, joins
SQL
- SQL Introduction
- SQL Database
- SQL Table
- SQL Constraints
- SQL Data Types
- SQL Operators
- SQL Wildcard Characters
- SQL Joins
- SQL Aggregate Function
- SQL Views
- SQL Dates
- String Functions in SQL Server
- SQL Server Date Functions
- SQL query
Advanced Excel
- Working with Advanced Formulas
- Working with Lists
- Working with Illustrations
- Data Visualization – Advanced
- Advanced Formatting in Excel
- Working with Pivot Tables
- Introduction to Power Query