Ntelligence

Business Analysis

Our mission: Helping people gain the skills they need to improve their lives through IT.

Click here to Register

Business Analysis Course Curriculum 


 Download Course Curriculum

1. Introduction and Fundamentals

  • Business Analyst – Who, What, Why?
  • BA – qualities, skills, roles, responsibilities
  • BA – Fundamentals

2. BA – Knowledge Areas

  • Software Development Life Cycle
  • Methodologies – Waterfall, Agile, Scrum, RUP

3. Requirement Process, Planning & Management

  • What are requirements?
  • Characteristics of Requirements
  • Types of Requirements
  • Functional & Non-Functional Requirements
  • The Requirements Process
  • Planning & Managing Requirements

4. Requirements Elicitation

  • Principles / Constraints / Techniques
  • JAD – Joint Application Development
  • Data Analysis
  • Creating Models, Scenarios
  • Interviewing
  • Brainstorming
  • Reverse Engineering
  • Prototyping

6. Requirements Analysis

  • RTM - Requirements Traceability Matrix
  • Change Management
  • Requirements Risk Management
  • Gap Analysis
  • Impact Analysis

7. Requirements Specifications

  • Writing Functional Specifications Document

8. UML

  • UML 2.0 – working with use case diagrams, activity diagrams, knowledge on class, object, state,
  • Working with UML tools
  • Working with UI tools

 

Data Analyst Course Curriculum

 

1. SQL Foundation

  • Background on SQL
  • Basic SELECT-FROM-WHERE statements
  • SQL clauses, Math Operations and complex conditions in WHERE clause
  • Pattern matching in the WHERE clause
  • NULL values
  • JOIN operations
  • Grouping and aggregations (Having & Order BY clauses
  • Subqueries & MORE

 

2. Data Modeling

  • How data models are used in practice
  • Overview of Entity Relationships(ER) and its significance to data modeling
  • How to create an Entity Relationship Diagram (ERD)
  • Normalization to reduce data redundancy
  • DE normalize to improve performance

 

3. Data Migration

  • Importing and Exporting Data from SQL Server (RDBMS) to Excel, flat files etc.
  • Creating Extraction Transformation Load (ETL) package in SSIS
  • Writing SQL Queries to migrate data from one platform to another
  • Using Migration Assistant Tool to migrate from other RDBMS platforms into SQL Server

 

4. Report / Dashboard development

  • Translation of requirements into SQL driven reports
  • Create Charts and Graphs in Excel using Pivot tables and Power BI
  • Querying data from SQL Server and displaying in Excel
  • Dashboard creation in SharePoint using SQL Server Reporting Services (SSRS), Performance Point and Excel Services.
  • Dashboard design and data visualization using Microsoft Power BI Tool.

Ntelegence

Ntelegence

© Copyright 2017 Ntelegence Training LLC.