BI Courses

Microstrategy BIQLICK VIEWTABLEAUIBM COGNOSMicrosoft SQL Server
  • Course Objectives:

    • Understand the activities of a business analyst including roles that contribute to quality requirements.
    • Learn how to recognize different requirement levels and types (business, user, functional, and nonfunctional).
    • Learn how to identify and involve the right people.
    • Be able to support a role-based requirements review

    CLICK HERE TO VIEW INSTRUCTOR LED – BUSINESS ANALYIS LIVE DEMO

    Duration: 15 Hrs

    Attendance Limit: 15 students

    Course Fee:
    Please call 1-888-424-8432 to discuss your specific training needs or email: training@aleph-technolgies.com for more information.

    Materials Provided: Student Manual. Exercise Workbook.

    Intended Audiences: Business Analysts, System Analysts, Project Managers, Subject-Matter-Experts, Designers, Developers and other individuals who are looking to understand basics on requirements process or want to be a Business Analyst.

  • Course Outline

    1. Overview

    • BA Responsibilities
    • Communications
    • Information distribution
    • Communications styles
    • Documentation strategy

    2. Introduction to Business Analysis

    • Business Composition and Architecture
    • Roles and Responsibilities of a Business Analysis
    • Need for a Business Analyst
    • Project Team
    • Importance of a Business Analyst in the Project Team

    3. Business Analysis Techniques

    • PESTLE – Political, Economic, Sociological, Technological, Legal, Environmental
    • MOST – Mission, Objectives, Strategies, Tactics
    • SWOT – Strengths, Weaknesses, Opportunities, Threats
    • CATWOE – Customers, Actors, Transformation Process, World View, Owner, Environmental Constraints

    3.1 Defining a Requirements Workgroup

    • Why are introductions important?
    • Meeting characteristics.
    • Workgroup characteristics.
    • What is facilitation?
    • The role of Facilitator.

    3.2 Preparing for the Workgroup

    • How do I plan the activities for the workgroup?
    • Workgroup purpose statement.
    • Using a standard agenda.
    • What visual aids should I use?

    3.3 Managing Problem People

    • How do I handle “people problems”?
    • Keeping the session on track.
    • Stopping side conversations.
    • Staying on time.
    • Never-ending discussion.
    • Conflict: personal attacks.
    • Conflict: group attacks.

    4. System Development Life Cycle (SDLC)

    • Understanding Concept of Business Modeling
    • Requirement Gathering
    • Analysis
    • Implementation
    • Testing
    • Deployment

    5. Fundamentals of testing

    • Testing strategy
    • Ensure project quality and quality of the product
    • Test scripts

    6.Templates

    • Software/Product Requirements Outline
    • Test Plan Template

    7. Practical Application Sessions

    • Determine your own Communication Style
    • Interview a project sponsor
    • Gather requirements while developing a Work Breakdown Structure
    • Design and facilitate a Requirements-Gathering session
    • Develop a high-level Requirements Document
    • Create a Project Test Plan

    8. Software Testing

    • Introduction to QA Methodology
    • Role of BA in Testing
    • Creating Test Plans
    • Creating Test Cases
    • Different Testing Methods
    • Functional and Regression testing
    • White Box and Black Box Testing
    • Positive and Negative Testing
    • GUI and Unit Testing
    • User Acceptance Testing

    9. Business Analysis Governance

    • International Institute of Business Analysis (IIBA)®
    • Business Analysis Body of Knowledge (BABOK)®
    • Certified Business Analysis Professional (CBAP)®

    10. Resume Preparation

    • Resume Review
    • Resume Preparation Tips
    • Sample Resume

    11. Interview Preparation

    • Mock Interviews
    • Interview Preparation Tips
    • Sample Interview Questions
  • Certified Business Analysis Professional (CBAP®)

    The Certified Business Analysis Professional (CBAP) is a professional designation awarded by the International Institute of Business Analysis (IIBA) to candidates who have significant professional experience and have demonstrated sufficient breadth and depth of knowledge by sitting and passing a four hour exam based on the Business Analysis Body of Knowledge (BABOK).

    The Certified Business Analysis ProfessionalTM(CBAP®) designation is a professional certification for individuals with extensive business analysis experience. With at least 7500 hours of hands-on BA experience, CBAP®recipients are the elite, senior members of the BA community.

    IT Professional with has benefits of earning the CBAP® certification if you have an advanced level of knowledge and experience and are working in any of the following roles:

    • Business analysis
    • Systems analysis
    • Requirements analysis or management
    • Process improvement
  • Course Objectives

    • Understand the activities of a business analyst including roles that contribute to quality requirements.
    • Learn how to recognize different requirement levels and types (business, user, functional, and nonfunctional).
    • Learn how to identify and involve the right people.
    • Be able to support a role-based requirements review

    Duration: 15 Hrs

    Attendance Limit: 15 students

    Course Fee:
    Please call 1-888-424-8432 to discuss your specific training needs or email: training@aleph-technolgies.com for more information.

    Materials Provided: Student Manual. Exercise Workbook.

    Intended Audiences: Business Analysts, System Analysts, Project Managers, Subject-Matter-Experts, Designers, Developers and other individuals who are looking to understand basics on requirements process or want to be a Business Analyst.

  •  

    Course Outline

    1. Requirements Gathering

    • Levels of requirements on a project
    • Identifying needs vs. wants
    • Techniques for gathering requirements
    • Interviewing (BA Core Skillset)
    • Prototyping
    • Use Cases
    • Collaborative Workshops
    • Work Breakdown Structure
    • Business Process Analysis
    • Use Cases
    • Ranking requirements

    2. Understanding and Capturing business needs

    • Setting up priorities
    • Feasibility studies
    • Project scope
    • Risk assessment
    • Evaluating and selecting an initiative
    • Setting up future vision

    3. Software Engineering Methods

    • Waterfall Method
    • Rational Unified Process (RUP)
    • RAD Methodology
    • AGILE Methodology
    • Prototype Model
    • Comparison between Waterfall & RUP
    • Artifacts delivered in each phase of RUP

    4. Requirement Analysis Process

    • Creating Requirement gathering strategy
    • Planning
    • Requirements Activities
    • Requirement Gathering Techniques
    • Different Types of Requirements
    • Creating Business Requirement Document
    • Creating Software Requirement Specifications
    • Requirements Risk Management
    • Manage Requirements Change

    5. Modeling

    • Business Process Analysis
    • Business Process Improvements (BPI)
    • Business Process Reengineering (BPR)
    • Data Modeling
    • Fundamentals
    • Entity Relationship Diagrams.

    6. Practical Application Sessions

    • Determine your own Communication Style
    • Interview a project sponsor
    • Gather requirements while developing a Work Breakdown Structure
    • Design and facilitate a Requirements-Gathering session
    • Develop a high-level Requirements Document
    • Create a Project Test Plan

    7. Requirements Elicitation

    • Identify stakeholders (Stakeholder Profile technique).
    • Identify sources of requirements (User Profile technique).
    • Elicit the requirements.

    8. Requirements Analysis

    • Identify assumptions.
    • Identify conflicts and dependencies.
    • Identify constraints and risks.
    • Requirements prioritization.
    • Trade-off analysis (priorities, effort, risk, schedule).

    9. Requirements Representation

    • Textual versus graphical representation techniques.
    • Overcoming challenges to writing requirements.
    • Requirements writing guidelines.

    10. Requirements Validation

    • Reviewing requirements for quality characteristics.
    • Eliminating ambiguities.
    • Tracing requirements.
    • Conducting the requirements review—Ink-Free Sign-Off™.

    11. Requirements Change Management

    • Establish a requirements baseline.
    • Following a formal change management process.
    • Change management roles.

    12. Business Level

    • Process Map (also called Swim-Lane or Workflow Diagram, Cross-Functional Map)
    • Event Table (also called Event-Response Table, Event List)
    • Relationship Map (also called Business Interaction Model, Organizational Context Diagram)
    • Context Diagram (also called Scope Diagram)

    13. User Level

    • User Table (also called Actor Table, User Role Model)
    • Use Case Diagram
    • Use Case Map (also called Use Case Flow Diagram, Use Case Navigation Diagram)
    • Scenario Analysis (also called Use Case Scenarios, Business Scenarios)
    • Data Model (also called Entity Relationship Diagram)

    14. System Level

    • Decision Table (also called Decision Tree or Diagram, Logic Table)
    • Prototype (also called Mock-up)
    • State-Transition Diagram (also called State Machine, State Diagram)

    15. Fundamentals of testing

    • Testing strategy
    • Ensure project quality and quality of the product
    • Test scripts

    16. Templates

    • Software/Product Requirements Outline
    • Test Plan Template

    17. Software Testing

    • Introduction to QA Methodology
    • Role of BA in Testing
    • Creating Test Plans
    • Creating Test Cases
    • Different Testing Methods
    • Functional and Regression testing
    • White Box and Black Box Testing
    • Positive and Negative Testing
    • GUI and Unit Testing
    • User Acceptance Testing

    18.Business Analysis Governance

    • International Institute of Business Analysis (IIBA)®
    • Business Analysis Body of Knowledge (BABOK)®
    • Certified Business Analysis Professional (CBAP)®

    19. Resume Preparation

    • Resume Review
    • Resume Preparation Tips
    • Sample Resumes

    20. Interview Preparation:

    • Mock Interviews
    • Interview Preparation Tips
    • Sample Interview Questions
  • Certified Business Analysis Professional (CBAP®)

    The Certified Business Analysis Professional (CBAP) is a professional designation awarded by the International Institute of Business Analysis (IIBA) to candidates who have significant professional experience and have demonstrated sufficient breadth and depth of knowledge by sitting and passing a four hour exam based on the Business Analysis Body of Knowledge (BABOK).

    The Certified Business Analysis ProfessionalTM(CBAP®) designation is a professional certification for individuals with extensive business analysis experience. With at least 7500 hours of hands-on BA experience, CBAP®recipients are the elite, senior members of the BA community.

    IT Professional with has benefits of earning the CBAP® certification if you have an advanced level of knowledge and experience and are working in any of the following roles:

    • Business analysis
    • Systems analysis
    • Requirements analysis or management
    • Process improvement
  • Course Objectives

    • Understand the activities of a business analyst including roles that contribute to quality requirements.
    • Learn how to create UML, Use Cases, Modelling Data and recognize different requirement levels and types (business, user, functional, and nonfunctional).

    Duration: 15 Hrs

    Attendance Limit: 15 students

    Course Fee:
    Please call 1-888-424-8432 to discuss your specific training needs or email: training@aleph-technolgies.com for more information.

    Materials Provided: Student Manual. Exercise Workbook.

    Intended Audiences: Business Analysts I, Business Analyst II, Business Analyst III, Designers, Developers and other individuals who are looking to understand the Process flows in requirements process.

  • Course Outline

    1.UML Methodology

    • Use Case Diagrams
    • Activity Diagrams
    • Sequence Diagrams
    • State Chart Diagrams

    2. Use Cases

    • Understanding Use Cases
    • Use Case Relationships
    • Use Case Brainstorming
    • Creating Use cases from Requirements
    • Creating Use Case Narratives
    • Change Management & Version Control Concept

    3. Business Requirement Gathering Tools

    • Rational Requisite Pro
    • Enterprise Architect
    • MS Visio

    4. Business Analysis & Modeling Tools

    • Enterprise Architect
    • MS Visio
    • Rational Rose

    5. Business Process Improvement

    • Selection of process teams and leader
    • Process analysis training
    • Process analysis interview
    • Process documentation
    • Review cycle
    • Problem analysis

    6. Modeling Data and Processes

    • Data models
    • Conceptual, logical and physical schemes
    • Data modeling process
    • Modeling methodologies
    • Entity relationship diagrams
    • Generic data modeling
    • Semantic data modeling

    7. Introduction to Use Case Modeling

    • Use Cases within the Requirements Management Process.
    • What is Use Case Modeling
    • 3-Step Use Case Approach.
    • Benefits of Use Cases.
    • When are Use Cases effective?

    8. Use Case Diagram

    • What is an Actor?
    • What are Primary and Supporting Actors?
    • Describing the Actors.
    • Pitfalls for Naming Actors.
    • What are the Goals of each Actor?
    • Naming the Use Case.
    • Using Descriptive Action Verbs.
    • Pitfalls when naming Use Cases.
    • What is Unified Modeling Language (UML)?
    • Use Case Diagramming Symbols.
    • Pitfalls for Diagramming.

    9. Outline the Use Case Specification

    • Eight Industry Use Case Formats.
    • A Use Case Template.
    • Writing a Use Case Brief Description.
    • Use Case Flow of Events.
    • A Scenario is a Use Case Instance.
    • Writing the Main Flow.
    • What are Alternate Flows?
    • Schematic of Alternate Flows.
    • Identifying Alternate Flows.
    • What are Exception Flows?
    • Schematic of Exception Flows.
    • Identifying Exception Flows.
    • “Size” Guidelines for a Use Case.
    • Pitfalls for Outlining Use Cases.

    10. Detail the Use Case Specification

    • Avoiding Design Language.
    • Writing the Alternate Flows.
    • Pitfalls for Detailing the Use Case.
    • Writing the Exception Flows.
    • What are Pre-conditions?
    • What are Post-conditions?
    • Completing the Representation Package.

    11. Introduction to Requirements Management

    • What are the costs of poor quality requirements?
    • What are requirement types?
    • What is a quality requirements management process?
    • The 5-Stage Requirements Management Process.
    • What are the roles and activities in the Requirements Management Process?Introduction to Requirements Management

    12. Software Testing

    • Introduction to QA Methodology
    • Role of BA in Testing
    • Creating Test Plans
    • Creating Test Cases
    • Different Testing Methods
    • Functional and Regression testing
    • White Box and Black Box Testing
    • Positive and Negative Testing
    • GUI and Unit Testing
    • User Acceptance Testing

    13. Business Analysis Governance

    • International Institute of Business Analysis (IIBA)®
    • Business Analysis Body of Knowledge (BABOK)®
    • Certified Business Analysis Professional (CBAP)®

    14. Resume Preparation

    • Resume Review
    • Resume Preparation Tips
    • Sample Resumes

    15. Interview Preparation

    • Mock Interviews
    • Interview Preparation Tips
    • Sample Interview Questions
  • Certified Business Analysis Professional (CBAP®)

    The Certified Business Analysis Professional (CBAP) is a professional designation awarded by the International Institute of Business Analysis (IIBA) to candidates who have significant professional experience and have demonstrated sufficient breadth and depth of knowledge by sitting and passing a four hour exam based on the Business Analysis Body of Knowledge (BABOK).

    The Certified Business Analysis ProfessionalTM(CBAP®) designation is a professional certification for individuals with extensive business analysis experience. With at least 7500 hours of hands-on BA experience, CBAP®recipients are the elite, senior members of the BA community.

    IT Professional with has benefits of earning the CBAP® certification if you have an advanced level of knowledge and experience and are working in any of the following roles:

    • Business analysis
    • Systems analysis
    • Requirements analysis or management
    • Process improvement
  • Course Objectives

    • Understand the activities of a business analyst in Healthcare Domain
    • Deep dive understanding of Healthcare Domain from Claim submission to Claim Payment.

    CLICK HERE TO VIEW INSTRUCTOR LED – HEALTH CARE DOMAIN LIVE DEMO

    Duration: 15 Hrs

    Attendance Limit: 15 students

    Course Fee:
    Please call 1-888-424-8432 to discuss your specific training needs or email: training@aleph-technolgies.com for more information.

    Materials Provided: Student Manual. Exercise Workbook.

    Intended Audiences: Business Analysts I, Business Analyst II, Business Analyst III, Designers, Developers and other individuals who are looking to gain knowledge in Healthcare Domain.

  • Course Outline

    1. Health Insurance – Overview

    • What is Health Insurance
    • Components of Health Insurance
    • Types of Health Insurance Coverages
    • Types of Health Insurance (HMO, PPO, POS)
    • Provider vs. Payer, and NPI

    2. Claims Process

    • Claims Process Flow
    • Claims Submission
    • Claims Adjudication Processing
    • Encounters Submission
    • Compliance Check

    3. EDI Transactions-I

    • 837 EDI Claims; 835 Remittance
    • Edits and Validations
    • Reports and Acknowledgements

    4. EDI Transactions-II

    • Other EDI 5010 Transactions
    • ICD-10 Impacts
    • ICD-10 Implementation Roadmap
    • DRG, CPT, HCPCS
    • TR3 Documentation, Companion Guide

    5. Facets – Overview

    • Facets Functional Modules
    • Data Model
    • Pricing Workflow
    • DRG Processing
    • HIPAA Compliance

    6. Health Information Exchange

    • Affordable Care Act / Govt Reforms
    • Electronic Medical Records
    • Healthcare Exchange
    • Review Templates/Sample Artifacts
  • Paul is the co-founder and Senior Trainer for Aleph Technologies and he has extensive healthcare payer, provider domain experience working for wide variety of companies such as Health Insurance Companies, Hospitals and State Health and Human Service Divisions.

    Paul designs and reviews all the healthcare course materials developed for Aleph Technologies to provide detailed in-depth course delivery experience for professionals who are looking to be the experts in Healthcare Domain.

    Domain Expertise Include: FACETS Configuration, QNXT Configurations, EDI Subject Matter Expert

    Cindi is a Senior Trainer(Guest) for Aleph Technologies and she has 15 years of experience in healthcare payer, provider and Healthcare Implementations consulting experience working for wide variety of companies such as Health Insurance Companies, Hospitals and major blue chip consulting firms.

    Domain Expertise Include: Healthcare Implementation Projects and Consulting, FACETS Configuration, QNXT Configurations, EDI Subject Matter Expert and Health Insurance Payer Business SME

    Sajida is a Senior Trainer(Guest) for Aleph Technologies and she has 17 years of experience in healthcare payer, provider and Healthcare Implementations consulting experience working for wide variety of companies such as Health Insurance Companies, Hospitals and major blue chip consulting firms.

    Domain Expertise Include: Leading Healthcare Business Analysis, FACETS Configuration, QNXT Configurations, EDI Subject Matter Expert and Health Insurance Payer Business SME

  • Microsoft SQL Server
    Course Objective: This SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server. Gives idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.

    Duration: 26 Hrs
    Attendance Limit: 15 students
    Course Fee:
    Please call 1-888-424-8432 to discuss your specific training needs or email: training@aleph-technolgies.com for more information.
    Materials Provided: Student Manual. Exercise Workbook.
    Intended Audience: Must have some basic programming concepts and analytical thinking.

  • Course Outline:

    • SQL Server Training Course Objective
    • Learn Database models
    • Overview of SQL Server Management Studio and Transact-SQL language
    • Master writing simple and complex queries that retrieve data from the database
    • Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
    • Insert, update, and delete data
    • Retrieve data from tables
    • Joins
    • Sub-queries
    • Working with Data Types
    • Procedure and Functions
    • Understand the different Views
    • Working with Triggers
    • Design a database
    • Maintain databases, tables, and sequences with SQL statements
    • Create and manage views
    • Ensure the integrity of multiple, related database updates by using transactions
    • Retrieve data using cursors
    • Manage binary data using BLOBs
    • Introduction To SQL Server
    • Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
    • Connecting To Server
    • Server Type
    • Server Name
    • Authentication Modes
    • Sql Server Authentication Mode
    • Windows Authentication Mode
    • Login and Password
    • Sql Server Management Studio and Tools In Management Studio
    • Object Explorer
    • Object Explorer Details
    • Query Editor
    • TSQL (Transact Structured Query Language)
    • Introduction To TSQL
    • History and Features of TSQL
    • Types Of TSQL Commands
    • Data Definition Language (DDL)
    • Data Manipulation Language (DML)
    • Data Query Language (DQL)
    • Data Control Language (DCL)
    • Transaction Control Language (TCL)
    • Database
    • Creating Database
    • Altering Database
    • Deleting Database
    • Constrains
    • Procedural Integrity Constraints
    • Declarative Integrity Constraints
    • Not Null, Unique, Default and Check constraints
    • Primary Key and Referential Integrity or foreign key constraints
    • Data Types In TSQL
    • Table
    • Creating Table
    • Altering Table
    • Deleting Table
    • Data Manipulation Language
    • Insert
    • Identity
    • Creating A Table From Another Table
    • Inserting Rows From One Table To Another
    • Update
    • Computed Columns
    • Delete
    • Truncate
    • Differences Between Delete and Truncate
    • Data Query Language (DQL)
    • Select
    • SQL Server Management Studio SQL Reporting Services SQL Server Integrated Services
    • SQL Server Installation Introduction to Reporting ETL Introduction
    • Introduction to SQL Server features
    • Introduction to Tables Grouping and Drill down Data Profiling
    • Introduction to Select Statement Matrix Reports Auditing and Error Handling
    • How to Group different tables Parameters Package Design Consideration
    • Working with Constraints How to create Sub Reports How to Deploy a Package
    • How to Sort Data How to create Drill through Reports
    • How to use System Functions Configuring Report Manager
    • Variables
    • What is UDF
    • Temp Table, CTE
    • Joins
    • Stored procedures
    • Triggers and Views
    • Introduction to different Graphs and Charts Variables and Expressions
    • SQL Server Management Studio
    • SQL Server Installation Introduction to Reporting ETL Introduction
    • Introduction to SQL Server features
    • Introduction to Tables Grouping and Drill down Data Profiling
    • Introduction to Select Statement Matrix Reports Auditing and Error Handling
    • How to Group different tables Parameters Package Design Consideration
    • Working with Constraints How to create Sub Reports How to Deploy a Package
    • How to Sort Data How to create Drill through Reports
    • How to use System Functions Configuring Report Manager
    • Variables
    • What is UDF
    • Temp Table, CTE
    • Joins
    • Stored procedures
    • Triggers and Views
    • SQL Reporting Services
    • Introduction to different Graphs and Charts Variables and Expressions
    • Grouping and Drill down
    • Matrix Reports
    • Parameters
    • How to create Sub Reports
    • How to create Drill through Reports
    • Configuring Report Manager
    • SQL Server Integrated Services
    • ETL Introduction
    • Variables and Expressions
    • Data Profiling
    • Auditing and Error Handling
    • Package Design Consideration
    • How to Deploy a Package