Business Analysis & Business Intelligence

Duration: 6 weeks

Classes only on Weekends

BA:

  • Software Life Cycle Basics: Waterfall and Agile
  • Case Studies SCRUM – Agile Project Management
  • Domain Knowledge – Financial Services, Capital Markets, Technology, Telecom, and Insurance
  • Assignment(s) – Business and IT, BRD case studies

Business Analysis Planning and Monitoring
a. Identification & Profiling of Stakeholders
b. Understanding the Stakeholder Analysis Matrix
c. Determining the Business Analysis Approach: Plan-Driven vs. Change Driven
d. Planning Business Analysis Activities and Communication
e. Understanding the Contents of the Requirements Management Plan
f. Understanding Requirements Attributes
g. Monitoring and Managing Business Analysis Performance

Requirements Management and Communication
a. Managing Solution Scope and Requirements
b. Creating the Requirements Traceability Matrix
c. Preparing Requirements Packages
d. Types of Requirements
i. Business Requirements
ii. Functional Requirements Specifications
Overview the Use Case Methodology
iii. Non-Functional Requirements Specifications
Understanding Different Types of Non-Functional Requirements
iv. Technical & Design Constraints
e. Managing Requirements Communication Activities

Elicitation
a. Preparing for Elicitation
b. Conducting Elicitation
c. Documenting and Conforming Elicitation Results
d. Requirements Elicitation Techniques – JAD, Brainstorming, White Boarding

Jira
Managing issue workflow & Jira Reports

Testing, Validation and Verification

A) What is testing?
B) Why testing?
C) What are different environments and why are they needed?
D) Types of testing – Dev, SIT, UAT, Production
E) Creating a testing strategy
F) Creating a test plan
G) Executing and managing testing cycles
H) Obtaining sign-offs and approvals
I) Deployment/implementation and further

BI

Session-1

  • Introduction to BI
  • Setup
  • SQL – part 1

Session-2

  • SQL – part 2
  • Advanced SQL Analytic queries
  • Data – warehouse concepts

Session-3

  • Overview of Data Science process
  • Data Visualization
  • Tableau – part 1

Session-4

  • Tableau – part 2
  • Overview of ETL tool

Session-5

  • Introduction to Power BI

Pre-requisite for Program: Good communication skills, Microsoft Office

Job roles: Business Analyst, Data Analyst, Business Intelligence Analyst, Product Manager, Project Manager