Business Analyst Courses is an industry-designed course to learn the core competencies of Business Analysts like Requirement Planning, Project Management, Business Analyst Tools and Techniques, Business Process modeling and more through hands-on real-time projects and case studies. Our team of certified experts has designed our Business Analyst Course Content and syllabus based on current requirements from the industry. This enables them to be Industry-Ready Professionals capable of handling the majority of the real-world scenarios. In this course, you'll delve into the role and responsibilities of the business analyst (BA) - the communication link between all business areas and a critical player in project success. Learn techniques for ensuring project success every step of the way-from identifying and analyzing potential projects to making sure that the final project product meets the requirements you identified. Through hands-on exercises, you'll learn to define the scope of work and master requirements-gathering techniques that will work for a variety of projects and audiences. You'll consider the unique needs of customers, stakeholders, and the IT department as you work toward building, documenting, communicating, and managing requirements.

Course Objectives:

• Define the role of a business analyst and explain the importance of their contribution to the business environment.
• Develop the skills necessary for effective stakeholder engagement, including planning, communication, and collaboration techniques.
• Master the processes of elicitation, requirement lifecycle management, and strategy analysis to ensure accurate requirement gathering and prioritization.
• Learn to evaluate and validate solutions, ensuring alignment with business needs and stakeholder requirements.
• Acquire the ability to assess risks and define change strategies to facilitate smooth transitions and successful project outcomes.
• Gain proficiency in a wide array of business analysis techniques and tools to support decision-making and problem-solving.
• Enhance analytical thinking, problem-solving, communication, and interaction skills vital for a business analyst's success.
• Explore different perspectives such as Agile, Business Intelligence, and Business Process Management, and understand their impact on business analysis practices.

Learning Path:

1. Excel: Basics to Advanced
2. MySQL
3. Tableau
4. Power BI
5. Business Statistics
6. Fundamentals of R
7. Fundamentals of Python
8. Agile
9. UML 2.0
10. ChatGPT

Course content

Excel

Introduction

• MS office Versions(similarities and differences)
• Interface(latest available version)
• Row and Columns
• Keyboard shortcuts for easy navigation
• Data Entry(Fill series)
• Find and Select
• Clear Options
• Ctrl+Enter
• Formatting options (Font, Alignment, Clipboard (copy, paste special))

Referencing, Named ranges, Uses, Arithmetic Functions

• Mathematical calculations with Cell referencing(Absolute, Relative, Mixed)
• Functions with Name Range
• Arithmetic functions(SUM,SUMIF,SUMIFS,COUNT,COUNTA,COUNTIFS,AVERAGE,AVERAGEIFS,MAX,MAXIFS,MIN,MINIFS)

Logical functions

• Logical functions: IF, AND, OR, NESTED IFS, NOT, IF ERROR
• Usage of Mathematical and Logical functions nested together

Referring data from different tables: Various types of Lookup, Nested IF

• LOOKUP
• VLOOKUP
• NESTED VLOOKUP
• HLOOKUP
• INDEX
• INDEX WITH MATCH FUNCTION
• INDIRECT
• OFFSET

Advanced functions

• Combination of Arithmetic
• Logical
• Lookup functions
• Data Validation(with Dependent drop down)

Date and Text Functions

• Date Functions: DATE, DAY, MONTH, YEAR, YEARFRAC, DATEDIFF, EOMONTH
• Text Functions: TEXT, UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, FIND, MID, TTC, Flash Fill

Data Handling: Data cleaning, Data type identification, Remove Duplicates, Formatting and Filtering

• Number Formatting(with shortcuts)
• CTRL+T(Converting into an Excel Table)
• Formatting Table
• Remove Duplicate
• SORT
• Advanced Sort
• FILTER
• Advanced Filter

Data Visualization: Conditional Formatting, Charts

• Conditional formatting(icon sets/Highlighted colour sets/Data bars/custom formatting)
• Charts: Bar, Column, Lines, Scatter, Combo, Gantt, Waterfall, pie

Data Summarization: Pivot Report and Charts

• Pivot Reports: Insert, Interface, Cross table Reports: Filter, Pivot Charts,
• Slicers: Add, Connect to multiple reports and charts
• Calculated field, Calculated item

Data Summarization: Dashboard Creation, Tips and Tricks

• Dashboard: Types, Getting reports and charts together, Use of Slicers.
• Design and placement: Formatting of Tables, Charts, Sheets, Proper use of Colours and Shapes

Connecting to Data: Power Query, Pivot, Power Pivot within Excel

• Power Query: Interface, Tabs
• Connecting to data from other excel files, text files, other sources
• Data Cleaning
• Transforming
• Loading Data into Excel Query

Connecting to Data: Power Query, Pivot, Power Pivot within Excel

• Using Loaded queries
• Merge and Append
• Insert Power Pivot
• Similarities and Differences in Pivot and Power Pivot reporting
• Getting data from databases, workbooks, webpages

VBA and Macros

• View Tab
• Add Developer Tab
• Record Macro: Name, Storage
• Record Macro to Format table(Absolute Ref)
• Format table of any size(Relative ref)
• Play macro by button
• shape
• as command(in new tab)
• Editing Macros
• VBA: Introduction to the basics of working with VBA for Excel: Subs, Ranges, Sheets
• Comparing values and conditions
• if statements and select cases
• Repeat processes with For loops and Do While or Do Until Loops
• Communicate with the end-user with message boxes and take user input with input boxes, User Form

MySQL

Introduction to MySQL

• Introduction to Databases
• Introduction to RDBMS
• Explain RDBMS through normalization
• Different types of RDBMS
• Software Installation(MySQL Workbench)

SQL Commands and Data Types

• Types of SQL Commands (DDL,DML,DQL,DCL,TCL) and their applications
• Data Types in SQL (Numeric, Char, Datetime)

DQL & Operators

• SELECT
• LIMIT
• DISTINCT
• WHERE AND
• OR
• IN
• NOT IN
• BETWEEN
• EXIST
• ISNULL
• IS NOT NULL
• Wild Cards
• ORDER BY

Case When Then and Handling NULL Values

• Usage of Case When then to solve logical problems and handling NULL Values (IFNULL, COALESCE)

Group Operations & Aggregate Functions

• Group By
• Having Clause
• COUNT
• SUM
• AVG
• MIN
• MAX
• COUNT String Functions
• Date & Time Function

Constraints

• NOT NULL
• UNIQUE
• CHECK
• DEFAULT
• Primary key
• Foreign Key (Both at column level and table level)

Joins

• Inner
• Left
• Right
• Cross
• Self Joins
• Full outer join

DDL

• Create
• Drop
• Alter
• Rename
• Truncate
• Modify
• Comment

DML & TCL Commands

• DML
• Insert
• Update & Delete
• TCL
• Commit
• Rollback
• Save point
• Data Partitioning

Indexes and Views

• Indexes (Different Type of Indexes)
• Views in SQL

Stored Procedures

• Procedure with IN Parameter
• Procedure with OUT parameter
• Procedure with INOUT parameter

Function, Constructs

• User Define Function
• Window Functions
• Rank
• Dense Rank
• Lead
• Lag
• Row_number

Union, Intersect, Sub-query

• Union, Union all
• Intersect
• Sub Queries, Multiple Query

Exception Handling

• Handling Exceptions in a query
• CONTINUE Handler
• EXIT handler

Triggers

• Triggers – Before | After DML Statement

Tableau

Introduction to Tableau

• What is Tableau ?
• What is Data Visualization ?
• Tableau Products
• Tableau Desktop Variations
• Tableau File Extensions
• Data Types, Dimensions, Measures, Aggregation concept
• Tableau Desktop Installation
• Data Source Overview
• Live Vs Extract

Basic Charts & Formatting

• Overview of worksheet sections
• Shelves
• Bar Chart, Stacked Bar Chart
• Discrete & Continuous Line Charts
• Symbol Map & Filled Map
• Text Table, Highlight Table
• Formatting: Remove grid lines, hiding the axes, conversion of numbers to thousands, millions, Shading, Row divider, Column divider
• Marks Card

Filters

• What are Filters ?
• Types of Filters
• Extract, Data Source, Context, Dimension, Measure, Quick Filters
• Order of operation of filters
• Cascading
• Apply to Worksheets

Calculations

• Need for calculations
• Types: Basic, LOD’s, Table
• Examples of Basic Calculations: Aggregate functions, Logical functions, String functions, Tableau calculation functions, numerical functions, Date functions
• LOD’s: Examples
• Table Calculations: Examples

Data Combining Techniques

• What is Data Combining Techniques ?
• Types
• Joins, Relationships, Blending & Union

Custom Charts

• Dual Axis
• Combined Axis
• Donut Chart
• Lollipop Chart
• KPI Cards (Simple)
• KPI Cards (With Shape)

Groups, Bins, Hierarchies, Sets, Parameters

• What are Groups ? Purpose
• What are Bins ? Purpose
• What are Hierarchies ? Purpose
• What are Sets ? Purpose
• What are Parameters ? Purpose and examples

Analytics & Dashboard

• Reference Lines
• Trend Line
• Overview of Dashboard: Tiled Vs Floating
• All Objects overview, Layout overview
• Dashboard creation with formatting

Dashboard Actions & Tableau Public

• Actions: Filter, Highlight, URL, Sheet, Parameter, Set
• How to save the workbook to Tableau Public website ?

Power BI

Power BI Introduction and Installation

• Understanding Power BI Background
• Installation of Power BI and check list for perfect installation
• Formatting and Setting prerequisites
• Understanding the difference between Power BI desktop & Power Query

The Power BI user interface, including types of data sources and visualizations

• Getting familiar with the interface BI Query & Desktop
• Understanding type of Visualisation
• Loading data from multiple sources
• Data type and the type of default chart on drag drop.
• Geo location Map integration

Sample dashboard with Animation Visual

• Financial sample data in Power BI
• Preparing sample dashboard as get started
• Map visual Types and usages in different variation
• Understanding scatter Plot chart with Play axis and the parameters

Power BI artificial intelligence Visual

• Understanding the use of AI in power BI
• AI analysis in Power BI using chart
• Q&A chat bot and the use in real life
• Hirarchy tree

Power BI Visualization

• Understanding Column Chart
• Understanding Line Chart
• Implementation of Conditional formatting
• Implementation of Formatting techniques

Power Query Editor

• Loading data from folder
• Understanding Power Query in detail
• Promote header, Split to limiter, Add columns, append, merge queries etc

Modelling with Power BI

• Loading multiple data from different format
• Understanding modelling (How to create relationship)
• Connection type, Data cardinality, Filter direction
• Making dashboard using new loaded data

Power Query Editor Filter Data

• Power Query Custom Column & Conditional Column
• Manage Parameter
• Introduction to Filter and types of filter
• Trend analysis, Future forecast

Customize the data in Power BI

• Understanding Tool tip with information
• Use and understanding of Drill Down
• Visual interaction and customisation of visual interaction
• Drill through function and usage
• Button triggers
• Bookmark and different use and implementation
• Navigation buttons

Dax Expressions

• Introduction to DAX
• Table Dax, Calculated column, DAX measure and difference
• Ex: Calendar, Calendar auto, Summarize, Group by etc
• Calculated Column
• Related, Lookup value, switch, Dated if, Rankx, Date functions
• Dax Measure and Quick Measure
• Remove filters, Keep filters, All, All selected, Time Intelligence Functions, Rolling average, YoY, Running total

Custom Visual

• Custom visual and understanding the use of custom
• Loading custom visual, Pinning visual
• Loading to template for future use
• Publishing Power BI

Power BI Service

• Introduction to app.powerbi.com
• Schedule refresh
• Data flow and use power bi from online
• Download data as live in power point and more

Business Statistics

Descriptive Statistics

• Data Types, Measure Of central tendency, Measures of Dispersion
• Graphical Techniques, Skewness & Kurtosis, Box Plot

Probability and Normal Distribution

• Random Variable, Probability, Probility Distribution, Normal Distribution, SND, Expected Value

Inferential Statistics

• 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 and Insights

• Data Cleaning(Invalid cells, Blanks, Outliers, Null values)
• Imputation Techniques(Mean and Median)
• Scatter Diagram
• Correlation Analysis

Certified Business Analysis Professional (CBAP)

Introduction to Business Analysis 

• Business Analysis overview
• Who is a Business Analyst?
• Introduction to governance body (IIBA)
• Business analysis body of knowledge
• Knowledge areas of BABOK
• SDLC & requirement analysis

Business Analysis Concepts and Knowledge Areas                    

• Business Analysis core concepts and knowledge areas
• Planning and monitoring
• Business Analysis Approach and Governance
• Business Analysis Information Management
• Elicitation and collaboration

Requirement Lifecycle Management and Strategy Analysis 

• Trace, maintain, & prioritize requirements
• Assess requirement changes and approval
• Analyze current state
• Define future state
• Assess risks
• Define change strategy

Requirement Analysis, Design Definition, Model Requirements, and Solution Evaluation 

• Specify model requirements
• Verify and validate requirements
• Define requirement architecture and design options
• Measure and analyze solution performance
• Assess solution and enterprise limitations
• Recommend actions to increase solution values
• Data model, UI model, user stories

Agile Business Perspectives and Creating UML 

• Introduction to business Agile perspective
• Business Intelligence perspective
• Information Technology perspective
• Business architecture perspective
• Business Process Management Perspective

Understand BA Role on the Agile Team

• Write effective user stories and acceptance criteria
• Develop backlogs into great products
• BA role in new age Business Analysis

Underlying Competencies of a Business Analyst & Microsoft Visio 

• Business Analyst underlying competencies
• BA Skills
• Soft skills, leadership, and personal development
• UML diagrams using Microsoft Visio
• Types of flowcharts, cross-functional flowcharts

IIBA Certification in Business Data Analytics (CBDA)

Data Science and Analytics Fundamentals

• Introduction to data science and Analytics
• Use cases in data science and analytics
• Data science life cycle
• Data analytics: Types
• AI and Machine Learning: Overview

CBDA: Introduction

• CBDA: Overview
• What is Business Data Analytics?
• Eligibility criteria
• Six Business Data Analytics domains

Business Analysis and Data Analytics

• Business analysis in data analytics projects
• Comparison between business analysis and data analytics

Business Data Analytics Domains: Introduction

Identifying the Research Questions

• Defining business problems or opportunities
• Identifying and understanding stakeholders
• Current state assessment
• Defining the future state
• Formulation of research questions
• Planning the Business Data Analytics approach
• Selection of techniques for the identification of research questions

Source Data

• Data collection planning
• Determination of datasets
• Data collection
• Data validation

Data Analysis

• Developing a Data Analysis Plan
• Data preparation
• Data exploration
• Performing data analysis
• Assessment of the analytics and system approach

Interpreting and Reporting Results

• Validating the understanding of stakeholders
• Planning for stakeholder communication
• Determining the communication requirements of the stakeholders
• Deriving Insights from Data
• Documentation and communication of findings from the completed analysis
• Selection of techniques for interpreting and reporting results

Using Results to Influence Business Decision-making

• Action recommendation
• Implementation plan development
• Change management
• Guiding the organizational-level strategy for Business Data Analytics
• Organizational strategy
• Talent strategy
• Data strategy

Techniques

• Business simulation
• Business visualization
• Concept modeling
• Data dictionary, flow diagrams, mapping, and storytelling
• Decision modeling and analysis
• Descriptive and inferential statistics
• Extract, Transform, and Load (ETL)
• Exploratory data analysis
• Hypothesis formulation and testing
• Interface analysis
• Optimization
• Problem shaping and reframing
• Stakeholder list, map, and personas
• Survey and questionnaire
• Technical visualizations
• The big idea
• Three-minute story

Fundamentals Of R

Introduction to R, Installation of R studio, Data Types in R

• Data types (Numeric, Char, Logical, Complex, Vector, List, Matrix, Factor, Array, Data frame) Relational operators, Logical operators

Decision making statements, Loops, Functions

• If, If else, For loop, While loop, Repeat, Functions

Built in Functions in R, Joins, dplyr and ggplot2

• Merging data frames, Analyzing Iris Dataset using apply functions, dplyr package (Filter, Sel, Arrange) Data visualization using ggplot2, Scatterplot, Histogram, Boxplot

Fundamentals Of Python

Anaconda Installation, Introduction to python, Data types, Operators

• Variables, data types ( integer, Boolean, Float, List, tuple, string), Operators in python

Data types Contd, Slicing the data, Inbuilt functions in python

• Dictionaries, Sequence methods, Concatenate, Repetition, len, min, max functions, Index position, Addition and deletion of elements, Reverse, Sorting

Sets, Set Theory, Regular Expressions, Decision making statements

• Sets, re module (find all, search, split, match) if, elif Getting input from user, Identity Operators

Loops, Functions, Lambda functions, Modules

• For, While loops, Functions, Lambda functions, Math module, Calendar module, Date & time module

Pandas, NumPy, Matplotlib, Seaborn

• Data frame creation using different methods, Using Pandas analysis on Universities, Salary data sets, Visualization using Matplotlib and Seaborn, NumPy introduction

Agile

Introduction to Agile

• Project Definition
• Difference Between Traditional & Agile Project Mgmt.
• Agile Manifesto and Principles
• Agile Methodology
• Agile Principles
• Agile Frameworks and Terminology

Agile Methodologies

• Scrum
• XP

Agile Analysis and Design

• Product Roadmap
• Product Backlog
• Story Maps
• Agile Modeling
• Wireframes
• Charting
• Personas

Planning and Monitoring

• Iteration and Release Planning
• Progressive Elaboration
• Time Boxing
• Cumulative Flow Diagram
• Kanban Boards
• WIP Limits
• Burn Charts
• Retrospectives
• Innovation Games

Agile Metrics and Estimations

• Relative Sizing
• Story Points
• Wideband Delphi Technique
• Planning Poker
• Affinity Diagram
• Ideal time
• Velocity
• Cycle Time
• EVM
• Escaped Defects

Quality

• Frequent Verification and Validation
• Test Driven Development
• Definition of Done
• Continues Integration
• Feedback Techniques
• Incremental Delivery
• Continuous Improvement

Value Based Prioritization

• Customer Valued Prioritization
• Compliance
• Relative Prioritization
• Value Stream Mapping
• Minimum Marketable Feature

Risk Management

• Risk Adjusted backlog
• Risk Burn down charts
• Risk based spike

Agile Communications

• Team Space
• Information Radiator
• Agile Tooling
• Daily Stand-ups
• Osmotic Communication

UML 2.0

• Class diagram
• Component diagram
• Composite structure diagram
• Deployment diagram
• Object diagram
• Package diagram
• Profile diagram
• Activity diagram
• State machine diagram
• Use case diagram
• Communication diagram
• Interaction overview diagram
• Sequence diagram
• Timing diagram

ChatGPT (Optional)

Introduction to ChatGPT and AI

• What is ChatGPT?
• The history of ChatGPT
• Applications of ChatGPT
• ChatGPT vs other chatbot platforms
• Industries using ChatGPT
• The benefits and limitations of ChatGPT
• Future developments in ChatGPT technology
• Ethical considerations related to ChatGPT and AI

Types of AI and ChatGPT architecture

• What is AI?
• Types of AI
• What is Machine Learning?
• Neural Networks
• Deep Learning
• Natural Language Processing (NLP)
• Computer Vision
• Robotics and AI

ChatGPT Functionalities and Applications

• How does ChatGPT work?
• ChatGPT Functionalities
• Drafting emails and professional communication
• Automating content creation
• Resume and Cover letter creation
• Research and information gathering
• Brainstorming ideas and creative problem solving
• Best Practices for Using ChatGPT

ChatGPT Prompt Engineering

• What is Prompt Engineering?
• Types of Prompts
• Crafting Effective Prompts
• Using ChatGPT to generate prompt

To see the full course content Download now