Business Analyst/Business Intelligence

Duration: 6 weeks

Classes only on Weekends

Ø Anyone who wants to shift career/work in the IT sector but has no prior background in IT;
Ø BA’s wanting to upgrade to BI role;
Ø Those who are preparing for industry certification exams of IIBA / ISTB.

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

 

BI

Prerequisite:

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

Session-1

Background ETL

-> What is it ?

-> Source Types

-> Destination Types

-> Transformation

-> Data quality

-> Data lineage

-> Metadata information

-> Introduction to Datastage ()

-> Introduction to Pentaho

Databases:

-> Database Overview

-> SQL (DDL / DML)

-> Postgres SQL

Session-2

Database (SQL Continued):

  • SQL Advanced concepts
  • Sample projects

ETL In-depth dive:

-> Data Extractions Sources

-Files

-Database

-> Target stages

– Files

– Datasets

– DB

Session-3

ETL In – depth:

Transformations

– Lookups (Normal / Sparse)

– Joins

– filters

– pivot functionality

– aggregation

IBM Datastage Overview

Session-4

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