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

Managing issue workflow & Jira Reports




  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


1. Introduction to Programming (using Python 3.x)
a. Basic Programming, Data Types (including Tuples / Lists / Dictionaries)
b. Boolean Expressions
c. Control Flows and functions

2. Python for Data Analysis
a. Overview of Python Libraries
b. Reading Data, Selecting and filtering the data, data manipulation, sorting, grouping, rearranging
c. Plotting the data

Java developer