Certificate Course on: Business Intelligence Analyst 7000

  • Duration: 60 Hours

  • Per Day: 1-2 Hours
Business Intelligence Analyst

The Training session will be live *Recorded lectures will be available

Business Analytics is a combination of Data Analytics, Business Intelligence and Computer Programming.It is the science of analysing data to find out patterns that will be helpful in developing strategies. Its usage can be found in almost every industry.

Week Duration Topic Contents
Week 1 1-2 Hours Introduction
  • Buzzwords
  • Analysis vs. Analytics
  • Business Analytics, Data Analytics and Data Science
  • Adding BI and ML
  • Info graphic
Week 1 1-2 Hours Statistics
  • Population vs. sample
  • Descriptive Statistics
  • Categorical and Numerical variables
Week 1 1-2 Hours Statistics
  • Histogram
  • Cross Tables
  • Scatter plots
  • Mean, Media and Mode
  • Skewness
  • Variance
Week 1 1-2 Hours Statistics
  • Standard Deviation
  • Covariance
  • Correlation coefficient
  • Practical example on descriptive statistics
Week 1 1-2 Hours Inferential Statistics
  • Distribution
  • Standard Error
  • Estimators and Estimates
  • Practical example on Inferential Statistics
Week 2 1-2 Hours Hypothesis Testing
  • Null vs. Alternate Hypothesis
  • Rejection Region and Significance level
  • Type I and Type II Error
  • P-value
  • Test for mean
Week 2 1-2 Hours RDBMS and SQL
  • Introduction to databases
  • Keys
  • SQL Installation and introduction
Week 2 1-2 Hours SQL
  • CRUD Operations on databases
  • SELECT Queries
  • Clauses in SQL
Week 2 1-2 Hours SQL Joins
  • Inner Join
  • Natural Join
  • Left Join
  • Right Join
  • Outer Join
  • Aggregate functions
Week 2 1-2 Hours SQL Subqueries and Stored Procedures
  • IN
  • Exists
  • Defining stored procedures
  • Altering procedures
  • Examples on executing the procedures
  • CASE Statements
Week 3 1-2 Hours Creating Interactive
  • Visualization with
  • Tableau
  • Tableau public installation and various
  • versions
  • Tableau User Interface
  • Dimensions and Measures
  • Pages, Filters, Marks and Show Me
  • Dataset Connections
  • Creating first visualization with Tableau
  • Public
Week 3 1-2 Hours Creating Interactive
  • Dashboard
  • Various graphs in Tableau
  • Integration of Map and geo-locations
  • Creating Interactive Dashboard
  • Publishing your Dashboard to Tableau
  • Public Site
Week 3 1-2 Hours Creating Interactive
  • Story
  • Scatter Plots
  • Data Highlighter
  • Pages and Cards
Week 3 1-2 Hours Creating Interactive
  • Story
  • Annotations
  • Creating Story and publishing on
  • Tableau Public
Week 3 1-2 Hours COVID-19 Case
  • Study
  • Creating India Statistics for COVID-19
  • Cases
  • Creating World Level Statistics for COVID-19
  • Locating Medical Facilities on Map