Data Analysis Using Tableau

Data Analysis

  • Last updated 04/2023
  • Certified Course
Security

Data Analysis

About The Course

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.

Data Analysis Training Program @ Learnage Academy

Data Analysis Using Tableau is a practical course that teaches how to turn raw data into meaningful insights using Tableau. Participants learn to connect to various data sources, clean and prepare data, and create interactive visualizations like charts, maps, and dashboards. The course also covers advanced analysis such as trends, forecasting, and clustering, enabling data-driven decision-making. By the end, learners can build compelling dashboards, interpret data effectively, and communicate insights for business impact.

Show More

Certificate

  • Duration: 50 Hours
  • Number of Question: 80-100
  • Format: Multiple choices

Prerequisites

  • Anyone having interest in Web Designing.
  • Knowledge of using computer.
  • Basic internet skills.

Training - Deliverables

  • Training
  • Books
  • CD's
  • Participation Certificate
  • Regular Track: 04 Months (120 Days)
  • Exam Duration: 3 Hours

Topics Covered

  • 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

  • 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

  • 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

  • Data Terminology
  • Navigation
  • Start Page
  • Design Flow
  • File System
  • Data Types
  • Highlight Tables
  • Changing Data types
  • Date functions
  • Show Me

  • 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

  • Side-by-Side Bars
  • Stacked Bars
  • Lollipop Chart
  • Cumulative Histogram
  • Crosstab
  • Total in a crosstab by column
  • Bullet Graph
  • Area Chart
  • Basic Map
  • Geographical plot
  • Circle views
  • Dual Combination Chart
  • Treemap
  • Funnel Chart
  • Traditional Funnel Chart
  • Waterfall Chart
  • Gantt Chart

  • Operators
  • IF Function
  • Aggregate Functions
  • Create Calculated Field
  • Logical Functions
  • Case Function
  • Highlight Tables
  • Quick Table Calculation
  • LOD Calculation

  • Filtering in Visualization
  • Quick Filter
  • Context Filt
  • 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

  • Create a Dashboard
  • Text Object on Dashboard
  • Image Object on Dashboard
  • Objects on Dashboard
  • Filters in Dashboard
  • Device Preview
  • Format Dashboard Layout

  • Forecast
  • Reference line
  • Reference Band
  • Reference Distribution Band
  • Trend Lines
  • Building up a storyline
  • Word Cloud
  • Advanced Tableau Skills

  • Relationships vs Joins vs Blending (newer Tableau versions emphasize relationships)

  • Tableau Prep Builder: flows, cleaning, pivoting, joins.

  • SQL Basic Overview
  • Query Language
  • SQL Server
  • MySQL
  • Oracle Database

  • Create Database
  • Delete or Drop Database
  • Use Database
  • Create Database in SQL Server
  • Rename Database

  • Create table
  • Create Table in SQL Server
  • Delete or Drop table
  • Insert Data into table
  • Select Distinct
  • Select Top
  • Where Clause
  • Aliases
  • Update Table
  • AND, OR, NOT
  • IN
  • Between
  • Order By
  • Group By
  • Rank
  • Having
  • Exists
  • ANY and ALL
  • CASE Statement
  • Select Into
  • Alter Table
  • Order of execution of a Query

  • Constraints Introduction
  • Not Null
  • Unique
  • Primary Key
  • Foreign Key
  • Check
  • Default
  • Index
  • Auto Increment Field
  • Cascading referential integrity constraint
  • Identity Column in SQL Server

  • Data Types Introduction

  • Operators Introduction

  • Wildcard Introduction
  • Like

  • Joins Introduction
  • Inner Join
  • Left Join
  • Right Join
  • Full Join
  • Self Join
  • Union
  • Cross Join
  • Advanced Join

  • Introduction
  • Min
  • Max
  • Count
  • Avg
  • Sum

  • Views Introduction
  • Advantages of View
  • Updateable ViewsDrop Views
  • Drop Views

  • Dates Introduction

  • Ascii ()
  • Char ()
  • L trim ()
  • R trim ()
  • Lower ()
  • Upper ()
  • Reverse ()
  • Len ()
  • Left ()
  • Right ()
  • Char Index ()
  • Replace ()
  • Stuff ()

  • ISDATE ()
  • DAY ()
  • MONTH ()
  • YEAR ()
  • DATENAME ()
  • DATEPART ()
  • DATEADD ()
  • DATEDIFF ()

  • Simple Query
  • Advance level Query

  • Using Named Ranges in Formulas
  • Naming a Single Cell and Range of Cells
  • Naming Multiple Single Cells Quickly
  • Using Formulas Spanning Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Working with the LOOKUP, VLOOKUP and HLOOKUP Functions
  • Understand various Financial Functions

  • Converting a List to Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List

  • Advantages of using Illustrations
  • Working with Clip Art
  • Using Shapes
  • Working with SmartArt

  • Overview of Data Visualization
  • Advantages of Data Visualization
  • Understanding and working with Charts
  • Creating a Custom Chart Template
  • Inserting Charts
  • Adding and Formatting Objects
  • Inserting Text in Charts
  • Working with Advanced Features
  • New Chart Formats -Tree maps, Sunburst, Histogram, Waterfall, Box and Whisker, Pareto

  • Understanding and Applying Conditional Formatting
  • Using and Working with Styles

  • Understanding Pivot Tables
  • Creating Pivot Table
  • Working with Column and Row Labels
  • Formatting a Pivot Table
  • Inserting Slicers
  • Working with Pivot Tables
  • Inserting Pivot Charts

  • What is Power Query
  • Enabling Power Query Add-on
  • Working with Power Query to Import
  • Data from various sources
  • Managing Data using Power Query
Quick Enquiry

Accelerate Your Career Development and Upskill Yourself