Business Analyst Certification Course Training in Bangalore

250

Business Analyst Certification Course Training in Bangalore

5

5/5

Best

Seller

3225

Rating (5 star)

3 Months

Duration

1.30hr

PER DAY

Business Analyst Course training in Bangalore

Business Analyst Course in Bangalore at Cambridge Infotech teaches you the essential abilities of business analysts such as requirement planning, project management, business analyst tools and techniques, business process modeling, and more. Our Business Analyst certification Course Content and Syllabus have been developed by a team of professional specialists based on current industry requirements. This qualifies them as Industry-Ready Professionals capable of dealing with the vast majority of real-world events.

Why Business Analyst Course With Cambridge Infotech?

It is critical to understand that business analysts are the backbone of most firms and are needed in every industry. For those with the necessary skills, business analysis as a whole is a tremendously stimulating and fulfilling vocation. They contribute to the growth and success of businesses.

You can easily pursue a business analyst certification in Bangalore, which will provide you with extensive business analysis knowledge. With this Business Analyst course in Bangalore, you may learn numerous concepts and abilities that are required to make active business decisions. Excel, Tableau, agile, CCBA, and many more topics will be second nature to you. This Business Analyst training in Bangalore will assist you in becoming a better Business Analyst. You will gain knowledge about business analysis planning, monitoring, and the roles and responsibilities of a business analyst by learning the necessary skills through the Business Analyst course in Bangalore

Companies all over the world are analyzing massive amounts of data generated as part of their daily operations. The study aids these businesses in gaining vital insights that boost profits to new heights.

business analyst course training in bangalore
business analyst course training in Bangalore | business analyst certification   

Business Analyst Course is an industry-designed course that teaches business analysts the basic competencies of requirement planning, project management, business analyst tools and techniques, business process modeling, and more through hands-on real-world projects and case studies. Our Business Analyst Course Content and Syllabus have been developed by a team of professional specialists based on current industry requirements. This qualifies them as Industry-Ready Professionals capable of dealing with the vast majority of real-world events.

Business Analyst course training in bangalore

Business Analyst course in Bangalore that includes placement assistance. Our Business Analyst Trainers are highly qualified and experienced working professionals with a minimum of 5-7 years of experience in the Business Analyst domain, assisting us in providing high-quality Business Analyst training to our students.

Syllabus of Business Analyst course

  • Business Statistics
  • Excel: Basics to Advanced
  • SQL
  • Tableau
  • Power BI
  • SAS
  • R Basics
  • Python Basics
  •  
  • Data Types, Measure Of central tendency, Measures of Dispersion
  • Graphical Techniques, Skewness & Kurtosis, Box Plot
  • Descriptive Stats
  • Random Variable, Probability, Probability Distribution, Normal Distribution, SND, Expected Value
  • Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
  • Introduction to Hypothesis Testing
  • Hypothesis Testing (2 proportion test, 2 t sample t-test)
  • ANOVA and Chisquare
  • Data Cleaning
  • Imputation Techniques
  • Scatter Diagram
  • Correlation Analysis

Advanced Excel –Basic

An overview of the screen, navigation, and basic spreadsheet concepts

  • Customizing the Ribbon
  • Worksheets
  • Format Cells
  • Various selection techniques
  • Shortcuts Keys
  • Protecting and un-protecting worksheets

Advanced Excel -Sorting and Filtering Data

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options

Advanced Excel -Data Validations

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell

Advanced Excel -Text Function

  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len, Exact
  • Concatenate

Advanced Excel -Function & Formula

  • Basic Function –Sum, Average, Max, Min, Count, Count A
  • Conditional Formatting
  • Logical functions (AND, OR, NOT)
  • Lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • V-lookup with Exact Match, Approximate Match
  • Nested V-lookup with Exact Match
  • V-lookup with Tables, Dynamic Ranges
  • Nested V-V-lookup with Exact Match
  • Using V-lookup to consolidate Data from Multiple Sheets
  • Mathematical Functions
  • SumIf, CountIf, AverageIf etc
  • Date & Time Function

Advanced Excel -Pivot Tables

  • Creating Simple Pivot Tables
  • Basic and Advanced value field setting
  • Grouping Based on number and Dates
  • Calculated field and Calculated items

Advanced Excel –Charts & Slicers

  • Using Charts
  • Formatting Charts
  • Using 3D Graphs
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically

Advanced Excel -Working with Templates

  • Designing the structure of a template
  • Using templates for standardization of worksheets

Advanced Excel -VBA-Macro

  • Introduction to VBA
  • What is VBA?
  • What can you do with VBA?
  • What can you do with VBA?
  • Procedures and Function in VBA

Advanced Excel -Variable in VBA

  • What is Variables?
  • Using Non-declared variables
  • Variable Data Types

Advanced Excel -Message-Box and Input-box functions

  • Customize Message-Box and Input-box
  • Reading cell values into messages
  • Various button groups in VBA

VBA Coding Advanced function

  • If and Select statement
  • Looping in VBA
  • Mail Function –send automated email
  • An automated report will be shown

Introduction to Databases

  • Databases
  • Introduction to DBMS
  • Popular DBMS Software
  • Concepts of RDBMS
    • Tables
    • Tuples
    • Attributes
  • Normalization
    • First Normal Form
    • Second Normal Form
    • Third Normal Form
  • NoSQL Databases
    • Types of NOSQL
  • Comparision

SQL Commands

  • Types of SQL Commands
  • Data Definition Language
    • Create, Drop, Truncate, Alter and Rename Objects
  • Data Query Language
    • Select Statements
  • Data Manipulation Language
  • DCL and TCL
    • Grant, Revoke and transaction statements
  • SQL Data Types
    • Numeric, Date and TIme, LOB Types
  • DML Commands
    • Insert, Update and Delete Statements
  • DDL Commands
    • Create and Drop Databases

Database Constraints

  • Types of Constraints
    • Relational Integrity Constraints
    • Key Constraints
    • Domain Constraints
    • Referential Integrity
  • Types Of Constraints
    • Primary and Foreign Keys
    • Application of Indexes
    • Checking Constraints
  • Alter Tables

SQL Transactions

  • SQL Transactions
    • Examples
  • ACID Properties
  • TCL Statements
    • Start, Commit and Rollback Statements
  • Auto Commit
  • SavePoints
    • Identifier
    • Rollback and Release

Database Objects

  • Tables
    • Creating, Altering and dropping tables
  • Sequences
    • Auto Increments
    • Re-Sequencing
  • Views
    • Advantages
    • Creating and Dropping Views
  • Indexes
    • Types of Indexes
    • B-Tree and Hash Indexes
    • Creating and dropping Indexes

Stored Procedures and Functions

  • Stored Objects
    • Types of Stored Objects
  • Stored Procedures
    • Create, call and drop stored procedures
    • Using Variables
    • Handling Exceptions
    • Named Errors and Resignals
  • Programming
    • If-then-Else and Case Statements
    • Loops
    • Repeat and Leave Statements
    • Cursors
  • Operators and Functions
  • Joining Tables
    • Inner Join, Left Join, Right join
  • Advantages of Procedures

Database Triggers Accessing Database From R and Python

  • Triggers
    • Database Triggers
    • Data Definition Language (DDL) Triggers
    • Data Manipulation Language (DML) Triggers
    • CLR Triggers
    • Logon Triggers
    • Triggers v/s Stored Procedures
  • Accessing Database from R
    • Install R Packages
    • Configuration Information
  • Python Database Access
    • Databases Supported
    • Libraries
    • Read Operations
    • Insert, Update and Delete
    • Performing Transactions
    • Handling Errors

What is Data Visualization

  • Advantages & Disadvantages of visualizations

Age of Big data

  • Why Data visualization Important
  • Understanding data
  • Examples of Data visualizations in Action
  • Different data visualizations

Principles of Visualizations

  • Design Principles
  • Best Practices
  • Data Viz Inspiration

Tableau –Data Visualization Tool

Introduction to Tableau

  • What is Tableau
  • Overview Of Tableau Tool(Servers , data , visualizations)
  • Tableau Architecture
  • Advantages & Disadvantages

Different Products of Tableau

  • Tableau Desktop
  • Tableau Public
  • Tableau Prep
  • Tableau Online
  • Tableau Server
  • Tableau Analytics

Extensions in Tableau

  • Tableau Workbook
  • Tableau Data Source
  • Tableau Data Extract
  • Tableau Packaged Workbook (TWBX)
  • Tableau Packaged Data Source (TDSX)
  • Tableau Book Mark
  • Tableau Map Source
  • Tableau Preferences

Features of Tableau Desktop

  • Connecting to Data from servers
  • Connecting Data from ODBC
  • Connecting data from local repositories

Tableau-Joins and Data Pane

  • What are Joins in Tableau
  • Types Of Joins in Tableau
    • Inner Join
    • Left Join
    • Right Join
    • Full Outer Join
    • Union
  • Creating Joins Using Data

Tableau Data Pane

  • Dimensions
  • Measures
  • Parameters
  • Sets

Pivot Table and Split Tables in Tableau

In built Charts in Tableau

  • Basic Charts
  • Text Tables
  • Highlight Tables
  • Bar charts
  • Stacked Bar
  • Line Graphs
  • Dual axis
  • Pie chart etc.

Maps in Tableau

  • Symbol Maps
  • Filled maps
  • Combined maps
  • Map layers
  • WMS
  • Polygon Maps
  • Custom coding etc.

How to Interpret Bullet Graphs

  • Actual Profit vs Budget Profit Analysis
  • Market wide Analysis etc

How to Interpret Scatter Plot

  • Correlation Analysis
  • Direction of Relationship
  • Strength of Relationship etc.

How to Interpret Histogram

  • Distributive Analysis, Bin Sizes, Custom bin sizing etc.

How to Interpret Box Plot chart

  • Distributive Analysis, Quartile Analysis, 5 Point Chart Analysis

Data Interpretation

  • Understanding of data types, discussing about dimensions and measures etc.

Creating Calculated Fields

  • Attribute functions
  • Quick table calculations
  • Creation of calculated fields
  • Aggregate and disaggregate functions etc.

Logical Functions

  • Understanding If-else statements, applications of if-else statements (eg: high profit , low profit etc.)

Case-If Function

  • Understanding Case Statements with examples
  • Applications of case statements

ZN Function

  • Creation of ZN functions
  • Application of ZN functions
  • Dealing with calculated fields etc.

Ad-Hoc Calculations

  • Calculations using parameters
  • Sets
  • Filters etcand applications

Manipulating Text-Left & Right Functions

  • Understanding different string functions etc.

Pre-Defined Analytics

  • Forecasting ,LOD Expressions , Functions, Groups, Filters, etc

Dashboards Hands-On in Tableau

  • Understanding concept of Dashboards
  • Building Interactive dashboards
  • Dashboard actions, etc.

Story Hands-On in Tableau

  • Relevance of stories in Dashboards, Working with examples on stories etc.

Animated Visualization Hands-On

  • Animation charts, play controls, page shelf, applications of animation charts

Tools for Sharing Information

  • Understanding Tableau Reader, Tableau online etc.

Publishing our Workbooks in Tableau Server

  • Exploring publishing options using Tableau , Discussing sharing of workbooks, etc.

Connecting Tableau with Tableau Server

  • Overview of how to connect Tableau with Tableau server.

What is R?

  • R software, installation , R studio , Understanding basic interface of R .

Connecting Tableau with R

  • Rservepackage, using functions such as SCRIPT_REAL etc, Understanding with examples.

How to integrate Tableau with R?

  • Rservepackage, external connections, ports, Understanding with examples.
  • Introduction of R
  • Data Types
  • Data Structures
  • Decision Making Statements
  • Conditional Loops
  • Flow Control Statements
  • If Statements
  • For loops
  • While Loops
  • Built Functions in R : Base, datasets, dplyrand ggplot

Introduction to Python

  • Introduction to Python & Data Science Python Installation on laptops
  • Python Basics -Variables -Python Build in functions -Modules -Python Libraries installation using PIP
  • Python Basics -Python Operators
  • Python Basics -Flow Control Statements -If Statements -While Loops
  • Python Basics -Data & time modules in python -Interfaces in Python -For Loops

Python modules for Data Analysis

  • Python Basics -Webscrapping-Python custom functions -Lambda Function -Regular Expressions
  • Data science Life cycle -NumpyModule
  • Data science Life cycle -PandsModule
  • Data science Life cycle -MatplolibModule

Introduction

  • Introduction to PowerBIPreview
  • Download the Training Data Files
  • Introduction to Signing Up for Power
  • Signing up for PowerBIPreview
  • Load Data into the Power BI Service Preview
  • Practical Activity

The Power BI Desktop

  • Intro to PowerBIDesktop Section
  • Introduction to the Power BI Desktop Preview

Creating Reports in Power BI Desktop

  • Create Reports in Power BI Desktop Section
  • Creating Tables in Power BI
  • Table Styles and Formatting Preview
  • Matrix Visualization 06:11
  • Tables and Metrics Practical Activity
  • Answers to Tables and Metrics Practical Activity
  • Changing the Method of Aggregation
  • Methods of Aggregation Challenge
  • Methods of Aggregation Challenge Completed
  • Cards and Multi-Row Cards
  • Cards, Matrix and Multi-Row Card Challenge
  • Answers to Cards Challenge
  • Percentage Calculations
  • Filtering Data -Using Slicers
  • Filtering Data -Visual Filters
  • Filtering Data -Page Filters
  • Filtering Data -DrillThrough Filter
  • Practical Activity -Filters
  • Practical Activity Filters Completed

Graphs and Visualizations

  • Introduction to Visualization Section
  • Clustered Column Graphs
  • Stacked and 100% Graphs
  • Column Graph Challenge
  • Column Graph Challenge Completed
  • Graph Options
  • Trend Analysis Graphs
  • Area Graphs
  • Ribbon Graphs
  • Additional Graphs
  • Scatterplots and Bubble

Interactive Dashboards

  • Creating Interactive Dashboards
  • Challenge -Create an Interactive Report
  • Completed Challenge -How to Create an Interactive Report
  • Publishing Reports to the Power BI Service
  • Pinning Visualizations to Dashboards
  • Mobile Reports
  • Q and A
  • App Workspaces
  • Publishing an App
  • Using Themes in Power BI
  • Using Custom Visualizations

DAX Formulas

  • DAX Formulas Section
  • DAX Formulas
  • Date Functions
  • Formatting Dates
  • Date Master Tables

DAX Measures

  • Introduction to Measures Section
  • Introduction to DAX Measures
  • DAX Measures Practical Activity
  • DAX Measures Activity Completed
  • The =Calculate Formula

Relationships

  • Relationships Section
  • Creating and Managing Relationships in Power BI
  • Relationship Calculations

Power BI Query Editor

  • Introduction to Power BI Query Editor
  • Basic Transformations -Part 1
  • Basic Transformations -Part 2
  • Aggregating Data

What people are saying

Are You Ready To Start?

More Courses

You might also be interested in these courses

Course 2

Aws Training In Kalyan Nagar Bangalore

Cambridge InfoTech offers the AWS Training course in Bangalore Kammanahalli. AWS console Certification, Cloud computing

Aws Training in bangalore

BEST SELLER 3225 Ratings (5.0) Stars
View Course

Course 3

Python Training in Kalyan Nagar Bangalore

python is one of the popular programming languages created by Guido Van Rossum Released in 1991 Cambridge InfoTech corporate training offers job oriented

Python Training in Bangalore

BEST SELLER 4256 Ratings (5.0) Stars
View Course