Master BI Program with Tableau
PRICE: 30,000
Sessions :       Hours:
Inclusive all of taxes

Upcoming Batches

05/10/19

SAT - SUN (21 DAYS)

Timings - 01:30 PM to 04:30 PM (IST)

09/11/19

SAT - SUN (21 DAYS)

Timings - 09:00 AM to 12:00 PM (IST)

Can’t find a batch you were looking for?

Master BI Program with Tableau Curriculum

  •  Excel Tables
  •  Sparklines
  •  Conditional Formatting
  •  Excel Data Tables
  •  Slicers
  •  Introduction
  •  Slicers to filter your table data
  •  Pivot Tables
  •  Creating Pivot Tables
  •  Use multiple ways to filter data in Pivot Tables
  •  Slicers in Pivot Tables
  •  Power Pivot
  •  Introduction to Power Pivot and it’s uses
  •  Pivot Tables v/s Power Pivot Tables
  •  Creating Power Pivot Tables
  •  Tables & Charts Combination
  •  Power Pivot Hierarchies
  •  Power Pivot using Slicers

  • Flexible data aggregation using pivot tables and pivot charts to create Dashboards
  • Introduction to Dashboards
  • Types of Dashboards
  • Analytical Dashboards
  • Dynamic Dashboards with Live Data
  • Excel Charts for Dashboards 
  • Pie Chart
  • Stacked Bar Chart 
  • Scatter Chart
  • Bubble Chart
  • Stock Chart
  • Radar Chart
  • Data Filter in Pivot to get Subsets of data & Advance Charts 
  • Dashboard Data & Formats
  • Waterfall Chart 
  • Band Chart 
  • Gantt chart 
  • Thermometer Chart
  •  Histogram
  •  Pareto Chart
  •  Funnel Chart
  •  Box and Whisker Chart
  •  Waffle Chart
  •  Reporting Layouts using formulas to aggregate the data as an alternative to Pivot Tables.
  •  Power view visualisation
  •  Combination of power view visualisation
  •  Interactive Nature of Charts in Power View Visualizations
  •  Slicers & Tiles in Power View 

  • Data Gathering & Transformation from multiple sources
  • Combining Multiple worksheet
  • Get and Transform data
  • Concatenate Formatting
  • Discover and combine data in mashups
  • Append Data  Merging Data
  • Data Blending
  • Data model creation
  • Data Exploration, Analysis and Visualisation 

  • Descriptive Stats and Basic Probability
  • Exploring Data in Excel
  • Exploring Data in Pivot Table
  • One way ANOVA using Excel
  • Random Variables
  • Sampling and Confidence Intervals
  • Hypothesis Testing

  • What is SQL
  • SQL Process
  • SQL Architecture
  • SQL Syntax
  • SQL Types
  • Operators 

  • Creating Database
  • Creating Tables
  • Insertion of row
  • Deletion of rows
  • Null Values
  • Clauses
  • Removing Duplicate data
  • Sorting data 
  • Alteration of Data 
  • Plots

  • Relationships in SQL
  • Understanding Joins
  • Types of Joins
  • Concept of Keys

  •  Brief about Functions
  • Aggregation Function
  • Practice & Doubt Session on SQL

  • What is Business Intelligence?
  • Data Visualization & Reporting
  • Introduction
  • Tools Available
  • Features of Tableau Server & Tableau Reader
  • Where does Tableau fit in?
  • Tableau Features 
  • Interactive graphs in Tableau 
  • Types of files in Tableau 
  • Approach to be followed while creating a dashboard 
  • Data types in Tableau while creating a dashboard 
  • Tableau terminology
  • Tableau Environment setup

  • Gatting starting with Tableau
  • Navigation in Tableau
  • Tableau ‘Show me’
  • Tableau ‘Data sources’
  • Tableau ‘Custom data view’
  • Tableau ‘Extrating Data’
  • Tableau ‘Operations Applied on data Fields’

  • Tableau ‘Editing Metadata
  • Data joins in Tableau 
  • Data Blending in Tableau 
  • Union in data In Tableau
  • Worksheets in Tableau

  • Operators in Tableau
  • String Calculations 
  • Numeric Calculations 
  • Functions in Tableau
  • Table calculation in tableau 

  • Basic shorting in Tableau
  • Basic filters in Tableau
  • Quick filters in Tableau
  • Context filters in tablue 

  • ADVANCE CHARTS IN TABLEAU
  • ACTIONS IN TABLEAU
  • PARAMETERS IN TABLEAU

Level of Detail 

Level of Detail (LOD) Calculations : Include 

Level of Detail (LOD) calculations : exclude

Level of Detail (LOD) calculations: Fixed

Level of detail (LOD) calculations : Used case 

Dates in tableau 

  • Dashboard design
  • Dashboard Design – Plan
  • Dashboard design – Layout 
  • Dashboard Design -- Interactivity

  • A list of Orders returned by the Customers (in terms of refund).
  • Top 10 Countries mapped on the World Map that had most of the refunds.
  • Predict the refund for next 1 year category-wise.
  • Actions to be Performed to Create the Dashboard 
  • Create hierarchies and folders in the dataset provided.
  • Generate a list of order returned from customers and compare it to the original sales, sort the visualization in ascending. 
  • Order in terms of returned order, for top 10 countries in terms of refunds.
  • Map top 10 countries, with most of the refunds on the world map. 
  • Predict the returned sale with lowest and actual forecast of the data
  • Add a URL action to represent details of the countries 
  • Finally publish your work to Tableau Server/ Online 

Basic Analytics 

  • Statistics Basics Introduction to Data Analytics andStatistical Techniques 
  • Types of Variables, measures of central tendency and dispersion 
  • Variable Distributions and ProbabilityDistributions 
  • Normal Distribution andProperties 
  • Central Limit Theorem andApplication 
  • Hypothesis Testing Null/Alternative Hypothesisformulation 
  • One Sample, two sample (Paired and Independent) T/ZTest 
  • P Value Interpretation 
  • Analysis of Variance(ANOVA) 
  • Chi Square Test 
  • Non Parametric Tests (Kruskal-Wallis, Mann-Whitney,KS) 
  • Correlation

Customer Segmentation 

  • Basic Clustering
  • Deciles analysis 
  • Cluster analysis (K-means andHierarchical) 
  • Cluster evaluation andprofiling
  • Interpretation of results

Master BI Program with Tableau Reviews

Master BI Program with Tableau Project

Features

EXPERIENCED TRAINER

Min 8+ years of industry Experience.For end to end implementation in analytics life cycle

HIGHEST PLACEMENT RATE

Training as per industry requirement with mock interviews training

ENDORSED CURRICULUM

Designed by professionals according to industry requirement

FLEXIBLE SCHEDULE

Choose the timimg as per your convenience

REAL TIME CASE STUDIES

For end to end implementation in analytics life cycle

CLASS RECORDINGS

Life time access for recorded sessions

Students Questions and answers

Related Courses

Students who interested this course also interested for these

0 Student reviews
5 star
80%
4 star
65%
3 star
50%
2 star
10%
1 star
8%
Student Images

Post Comments.

M8, Lower ground Floor, Sector 14 OLD DLF ,Gurugram (HR) - 122001
Enroll Now For Data Science Using Python