Business Analyst Course in Dallas

30% Salary Hike & Internal Role Transition

I was able to successfully make an internal transition from a Business Analyst to a Senior Analyst. The training has helped me effectively execute the projects in my organization. I am glad to have chosen Intellipaat.

Business Analyst

Senior Analyst

Mandip Dobariya

Sr. Full Stack Engineer | Gujrat

20% Salary Hike

The best result of the program was when I got promoted to a Lead role with a salary hike. Intellipaat’s training has helped me gain skills to handle projects single-handedly.

Full Stack Engineer

Sr. Full Stack Engineer

Er. Sushil Kuvind

Software Engineer | MP

100% Salary Hike

Intellipaat training helped me make a career switch from a Developer to a Software Engineer with a 100% hike even during the pandemic. The best part was the job assistance and mentoring sessions.

Developer

Software Engineer

Rishabh Johri

Senior Project Manager | Delhi

Promotion with 40% Salary Hike

Post enrolling in the course, I gained skills that have made me more confident to face the interviews and I was promoted to Sr. Project Manager. Intellipaat is the best place to get conceptual knowledge.

Project Manager

Senior Project Manager

Somika Simlote

Senior Software Engineering Lead | India

Career Transition Handbook

Got New Job

After having lost my job due to COVID, I was again able to land a better job after enrolling in this program. I was able to shift to Azure even after 13 years in the IT industry only due to the efforts of team Intellipaat.

Technology Project Lead

Senior Software Engineering Lead

Kalyani Umare

ETL Developer | Maharashtra

Consultant to Developer

Thanks to Intellipaat I was able to make a transition from Consultant to ETL Developer. The rich content has helped me get this role. I am extremely satisfied with my career today.

Consultant

ETL Developer

Mitali Dhar

Project Lead | Pune

Sr. Engg to Project Lead

With this training, I was able to shift from a Senior Software Engineer to a Project Lead at LTI. I would highly recommend this training to anyone willing to get into the field of project management.

Senior Software Engineer

Project Lead

Sawal Jain

Associate Consultant | Pune

Developer to Consultant

Post this training, I was able to make a career transition from being a Developer to an Associate Consultant at Capgemini. Intellipaat provides industry-aligned knowledge which has helped me in my current role.

Software Developer

Associate Consultant

Akhil Desai

SCM Procurement Functional Excellence | USA

Fresher to Consultant

This training helped me transform into an SCM professional from a Project Trainee. The expert instructors impart a deep understanding of the important concepts and techniques in the domain.

Project Trainee

SCM Procurement Functional Excellence

Poojitha Pastham

Sr. Software Engineer | Hyderabad

Non-Tech to Tech

Even after being from a non-tech field, I attained the necessary skills to become a Senior Software Engineer through this program. The major concepts were taught with ease and in lucid language, along with real-life projects.

Assistant Manager

Sr. Software Engineer

55% Average Salary Hike

$1,30,000 Highest Salary

12000+ Career Transitions

300+ Hiring Partners

Business Analyst Course Curriculum

Live Course Self Paced

Module 1 – Preparatory Sessions – Data Transformation using Ms. Excel

MS-Excel –

1.1 Excel Fundamentals

Reading the Data, Referencing in formulas , Name Range, Logical Functions, Conditional Formatting, Advanced Validation, Dynamic Tables in Excel, Sorting and Filtering
Working with Charts in Excel, Pivot Table, Dashboards, Data And File Security
VBA Macros, Ranges and Worksheet in VBA
IF conditions, loops, Debugging, etc.

1.2 Excel For Data Analytics

Handling Text Data, Splitting, combining, data imputation on text data, Working with Dates in Excel, Data Conversion, Handling Missing Values, Data Cleaning, Working with Tables in Excel, etc.

1.3 Data Visualization with Excel

Charts, Pie charts, Scatter and bubble charts
Bar charts, Column charts, Line charts, Maps
Multiples: A set of charts with the same axes, Matrices, Cards, Tiles

Module 2 - SQL for Business Analytics

2.1 SQL Basics –

Fundamentals of Structured Query Language
SQL Tables, Joins, Variables

2.2 Advanced SQL –

SQL Functions, Subqueries, Rules, Views
Nested Queries, string functions, pattern matching
Mathematical functions, Date-time functions, etc.

2.3 Deep Dive into User Defined Functions

Types of UDFs, Inline table value, multi-statement table.
Stored procedures, rank function, SQL ROLLUP, etc.

2.4 SQL Optimization and Performance

Record grouping, searching, sorting, etc.
Clustered indexes, common table expressions.

Hands-on exercise:

Writing comparison data between past year to present year with respect to top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future(using complex subqueries, functions, pattern matching concepts).

Tools covered

Module 3 - Mastering MS Excel for Business Analysis

3.1 Introduction to MS Excel & Data Extraction
3.2 Referencing in formulas
3.3 Name range
3.4 Logical functions
3.5 Conditional formatting
3.6 Advanced-level validation
3.7 Important formulas in Excel
3.8 Dynamic table
3.9 Data sorting, filtering
3.10 Chart creation techniques
3.11 Pivot tables in Excel
3.12 Data and file security
3.13 VBA Macros
3.14 Best practices of dashboards visualization
3.15 Creating dashboards
3.16 Creation of interactive components

Tools covered

Module 4 - Certified Business Analysis Professional (CBAP®)

4.1 Introduction to Business Analysis

Business Analysis overview
Who is a Business Analyst?
Introduction to governance body (IIBA)
Business Analysis body of knowledge
Knowledge areas of BABOK
SDLC & requirement analysis

4.2 Business Analysis Concepts and Knowledge Areas

Business Analysis core concepts and knowledge areas
Planning and monitoring
Business Analysis approach and governance
Business Analysis information management
Elicitation and collaboration

4.3 Requirement Lifecycle Management and Strategy Analysis

Trace, maintain, & prioritize requirements
Assess requirement changes and approval
Analyze current state
Define future state
Assess risks
Define change strategy

4.4 Requirement Analysis, Design Definition, Model Requirements, and Solution Evaluation

Specify model requirements
Verify and validate requirements
Define requirement architecture and design options
Measure and analyze solution performance
Assess solution and enterprise limitations
Recommend actions to increase solution values
Data model, UI model, user stories

4.5 Agile Business Perspectives and Creating UML

Introduction to business Agile perspective
Business Intelligence perspective
Information Technology perspective
Business architecture perspective
Business Process Management perspective

4.6 Understand BA Role on the Agile Team

Write effective user stories and acceptance criteria
Develop backlogs into great products
BA role in new age Business Analysis

4.7 Underlying Competencies of a Business Analyst & Microsoft Visio

Business Analyst underlying competencies
BA Skills
Soft skills, leadership and personal development
UML diagrams using Microsoft Visio
Types of flowcharts, cross-functional flowcharts

Tools covered

Module 5 - Data Visualization with Power BI

5.1 Introduction to Power BI
5.2 Data Extraction
5.3 Data Transformation – Shaping & Combining Data
5.4 Data Modelling & DAX
5.5 Data Visualization with analytics
5.6 Power BI Service (Cloud), Q&A, and Data Insights
5.7 Power BI Settings, Administration & Direct Connectivity
5.8 Embedded Power BI with API & Power BI
5.9 Power BI Advance & Power BI Premium

Tools covered

Module 6 - IIBA Certification in Business Data Analytics (CBDA)

6.1 Data Science and Analytics Fundamentals

Introduction to data science and analytics
Use cases in data science and analytics
Data science life cycle
Data Analytics: Types
AI and Machine Learning: Overview

6.2 CBDA: Introduction

CBDA: Overview
What is Business Data Analytics?
Eligibility criteria
Six Business Data Analytics domains

6.3 Business Analysis and Data Analytics

Business analysis in data analytics projects
Comparison between business analysis and data analytics

6.4 Business Data Analytics Domains: Introduction

Domain 1: Identifying the Research Questions

Defining business problems or opportunities
Identifying and understanding stakeholders
Current state assessment
Defining the future state
Formulation of research questions
Planning the Business Data Analytics approach

Selection of techniques for the identification of research questions

Domain 2: Source Data

Data collection planning
Determination of datasets
Data collection
Data validation

Domain 3: Data Analysis

Developing a Data Analysis plan
Data preparation
Data exploration
Performing data analysis
Assessment of the analytics and system approach

Domain 4: Interpreting and Reporting Results

Validating the understanding of stakeholders
Planning for stakeholder communication
Determining the communication requirements of the stakeholders
Deriving insights from data
Documentation and communication of findings from the completed analysis
Selection of techniques for interpreting and reporting results

Domain 5: Using Results to Influence Business Decision-making

Action recommendation
Implementation plan development
Change management
Guiding the organizational-level strategy for Business Data Analytics
Organizational strategy
Talent strategy
Data strategy

6.5 Techniques

Business simulation
Business visualization
Concept modeling
Data dictionary, flow diagrams, mapping, and storytelling
Decision modeling and analysis
Descriptive and inferential statistics
Extract, Transform, and Load (ETL)
Exploratory data analysis
Hypothesis formulation and testing
Interface analysis
Optimization
Problem shaping and reframing
Stakeholder list, map, and personas
Survey and questionnaire
Technical visualizations
The big idea
3-minute story

Module 7 - Agile Methodologies for Project Management

7.1 Introduction to Agile Scrum

Agile Scrum overview
Agile project principles
Sprint and Increment in Agile Scrum
Scrum theory
Other Agile Frameworks

7.2 Scrum Team and Artifacts and Events

Scrum team and Scrum Master
Scrum roles
Scrum flow
Scrum artifacts: product backlog
Artifacts transparency
Scrum events: sprint planning and retrospective
Agile estimating, planning, monitoring, and control

7.3 Project Management Using Jira

Introduction to Project Management in Jira
Jira issue types
Scrum & Kanban boards
Customizing board settings
Release and backlog management
Jira reports

Tools covered

Module 8 - UML 2.0

8.1 Class diagram
8.2 Component diagram
8.3 Composite structure diagram
8.4 Deployment diagram
8.5 Object diagram
8.6 Package diagram
8.7 Profile diagram
8.8 Activity diagram
8.9 State machine diagram
8.10 Use case diagram
8.11 Communication diagram
8.12 Interaction overview diagram
8.13 Sequence diagram
8.14 Timing diagram

Module 9 - Career Essentials

9.1 Communication skills
9.2 Leadership skills
9.3 Problem-solving skills
9.4 Business knowledge
9.5 IT knowledge

Module 10 - Machine Learning for Business

You will be working on multiple projects on different domains like retail, finance, banking and learn how Machine Learning is used to solve todays world problems.

Module 11 - Data Analysis with Python

11.1 Python Environment Setup and Essentials

Introduction to Python
Features
Python installation – Windows, Mac & Linux distribution for Anaconda Python
Deploying Python IDE
Basic Python commands, data types, variables, keywords, etc.

Hands-on Exercise

Installing Python Anaconda for Windows, Linux, and Mac

11.2 Python language Basic Constructs

Built-in data types in Python
Learn classes, modules, Str(String), Ellipsis Object, Null Object, Ellipsis, Debug
Basic operators, comparison, arithmetic, slicing and slice operator, logical, bitwise
Loop and control statements

Hands-on Exercise

Write your first Python program, Write a Python function (with and without parameters), use Lambda expression, write a class, create a member function and a variable, create an object, write a for loop

11.3 OOP concepts in Python

Write OOP concepts program in Python
Connecting to a database
Classes and objects in Python
OOPs paradigm
Python functions, return types, and parameters
Lambda expressions

Hands-on Exercise

Creating an application that helps to check balance, deposit money and withdraw the money using the concepts of OOPS.

11.4 Database Connection

Database and need of database
Installing MySQL on Windows
Database connection using Python

Hands-on Exercise

Demo on Database Connection using python and pulling the data.

11.5 NumPy for Mathematical Computing

Arrays and matrices
Broadcasting of array math
Indexing of the array
Standard deviation, conditional probability, correlation, and covariance

Hands-on Exercise

How to import the NumPy module, creating an array using an ND-array, calculating standard deviation on an array of numbers, calculating correlation between two variables.

11.6 SciPy for Scientific Computing

Introduction to SciPy
Functions building on top of NumPy, cluster, linalg, signal, optimize, integrate, subpackages,
SciPy with Bayes Theorem

Hands-on Exercise

Importing of SciPy, applying the Bayes theorem on the given dataset

11.7 Matplotlib for Data Visualization

How to plot graph and chart with Python
Various aspects of line, scatter, bar, histogram, 3D, the API of Matplotlib, subplots

Hands-on Exercise

Deploying MatPlotLib for creating Pie, Scatter, Line, Histogram

11.8 Pandas for Data Analysis and Machine Learning

Introduction to Python data frames
Importing data from JSON, CSV, Excel, SQL database, NumPy array to data frame
Various data operations

Hands-on Exercise

Working on importing data from JSON files, selecting record by a group, applying filter on top, viewing records

Tools covered

Module 12 - Capstone Project

Substantiate your learning experience and Business Analysis skills via this practical, industry-based capstone project based on our course and showcase your skills in the field of Product Management and Business Analysis.