Business Analysis & Business Intelligence
Duration: 6 weeks
Classes only on Weekends
Duration: 6 weeks
Classes only on Weekends
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
Prerequisite:
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):
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:
Session-5
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