Business Analysis

Business systems analysts review computers and computer programs used by a company and advise business stakeholders on ways to make …


    Who is a Business Systems Analyst?

    Business systems analysts review computers and computer programs used by a company and advise business stakeholders on ways to make processes more efficient and employees more productive. Typically employed by medium and large corporations, they require a certain level of business acumen coupled with technical knowledge.

    Business Analysis 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.

    Course Reviews


    4 ratings
    • 1 stars0
    • 2 stars0
    • 3 stars0
    • 4 stars0
    • 5 stars0

    No Reviews found for this course.

    • 90 Days

    Instructor Details

    More Courses by Jide Ojediran

    Advanced Course Search Widget

    Popular Courses

    Recent Posts

    © Copyright 2017 Ntelegence Training LLC.