• SDLC, Waterfall Model, Agile Methodology,
• Scrum, Different Meetings in Agile
– Roles in A gile, User Stories, Acceptance Criteria
• What is Business Analysis?
• Value of Business Analysis
• Business Analysis vs Business Analytics

• Requirements & needs high level idea
• Stakeholder’s
– Internal Stake holder
– External Stake holder
– List of stakeholders
• Typical W ork of BA & day to day work
• Who al will be stakeholders and details about
every stakeholder.
– Project Manager, Product Owner, Sponsor’s
– Staff, Users, BA’s, Developers, Testers
– Devops Engineers
• Different types of Stakeholder Conflicts and how
to resolve it.

• Flow Chart
• Different UML Diagrams –
– Entity Relationship
– Use case, class, Object, Activity, Sequence
•Wireframesh• Stakeholder Need Analysis

• Product Life Cycle
• Requirement Life cycle/phases

• Characteristics of good Requirements
• Different types of requirements
• What are Business Requirements and how to
prepare Business Requirement Document (BRD)
• What are User Requirements and how to prepare
User Requirement Document (URD)
• What are Functional Requirements and how to
prepare Functional Requirement Document (FRD)
• What are Non-Functional Requirements and how
to prepare Non-Functional Requirement
Document (NFRD)
• Different techniques of requirement gathering.
– One to One interview & Group discussions
– Surveys

• Decomposition Analysis,Additive/Subtractive Analysis
• GAP Analysis, Decision Analysis, Root Cause Analysis
• Stakeholder Need Analysis, Modelling of requirements
• What is UML?

• Flow Chart
• Different UML Diagrams –
– Entity Relationship
– Use case, class, Object, Activity, Sequence
•Wireframesh• Stakeholder Need Analysis

• Product Life Cycle
• Requirement Life cycle/phases

• Finalizing requirements
– Socialization, Presentation, Change Control

• Need of Database
• DBMS Models
• Normalization
• SQL Constraints
• SQL Commands(DML,DDL,DQL,TCL,DCL)
• Clauses
• Exercises

Excel
• Master Data Cleaning Techniques
• Visualize Data with Excel Charts
• Efficient Sub-totaling and Analysis
Advanced Excel
• Pivot Tables for Data Summarization:
Understand how to summarize data
efficiently.
• Data Analysis and Visualization: Deepen
your data analysis and visualization skills.
• Functions

TABLEAU and Power BI
• Introduction to Tableau
• Data Connectors, Data Model
• Basic Visualizations, Filters, Groups, Set
• Types of Calculations (Basic, Table, LOD)
• Date Functions, Table Calculations, Data Blending
• Advance Visualizations
(Gant Chart,Histogram,Donut Chart,Lollipop Chart)
• Dashboards, Projects
Difference between PowerBI and Tableau
• DataSources, Key Terms, Installation, Filters
• DAX Function, Visualization, Projects