Business Analysis & Business Intelligence

Duration: 6 weeks

Classes only on Weekends


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

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




  1. Database Installation (Postgres)
  2. ETL Software installation (Pentaho)
  3. BI Tool installation (Tableau / Pentaho)


Background ETL

-> What is it ?

-> Source Types

-> Destination Types

-> Transformation

-> Data quality

-> Data lineage

-> Metadata information

-> Introduction to Datastage ()

-> Introduction to Pentaho


-> Database Overview

-> SQL (DDL / DML)

-> Postgres SQL


Database (SQL Continued):

  • SQL Advanced concepts
  • Sample projects

ETL In-depth dive:

-> Data Extractions Sources



-> Target stages

– Files

– Datasets

– DB


ETL In – depth:


– Lookups (Normal / Sparse)

– Joins

– filters

– pivot functionality

– aggregation

IBM Datastage Overview


IBM datastage continued:

Mini project

Reporting Tools

-Connect to your data.

-Edit and save a data source.

-Understand Tableau terminology.

-Use the Tableau interface / paradigm to effectively create powerful visualizations.

-Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations.

-Represent your data using the following visualization types:

  • Pie Charts and Bar Charts
  • Dual Axis and Combo Charts with different mark type

Java developer