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 in 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 Content

Live Course Self Paced

Module 1 - Certified Business Analysis Professional (CBAP®)

1.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

1.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

1.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

1.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

1.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

1.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

1.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

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

2.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

2.2 CBDA: Introduction

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

2.3 Business Analysis and Data Analytics

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

2.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

2.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 3 - Agile Methodologies for Project Management

3.1 Introduction to Agile Scrum

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

3.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

3.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

Module 4 - UML 2.0

4.1 Class diagram
4.2 Component diagram
4.3 Composite structure diagram
4.4 Deployment diagram
4.5 Object diagram
4.6 Package diagram
4.7 Profile diagram
4.8 Activity diagram
4.9 State machine diagram
4.10 Use case diagram
4.11 Communication diagram
4.12 Interaction overview diagram
4.13 Sequence diagram
4.14 Timing diagram

Module 5 - Career Essentials

5.1 Communication skills
5.2 Leadership skills
5.3 Problem-solving skills
5.4 Business knowledge
5.5 IT knowledge

Module 6 - Data Visualization using Tableau

6.1 Introduction to Data Visualization and Power of Tableau

What is data visualization?
Comparison and benefits against reading raw numbers
Real use cases from various business domains
Examples using Tableau
Installing Tableau, Tableau interface, connecting to DataSource, Tableau data types
Data preparation

6.2 Architecture of Tableau

Installation of Tableau Desktop
Architecture of Tableau
Tableau interface
How to start with Tableau
The ways to share and export the work done in Tableau

Hands-on Exercise:

Play with Tableau desktop, learn about the interface, share and export existing works

6.3 Working with Metadata and Data Blending

Connection to Excel
Cubes and PDFs
Management of metadata and extracts
Data preparation
Joins and Union

Hands-on Exercise:

Connect to Excel sheet to import data, use metadata and extracts, manage NULL values, clean up data before using, perform the join techniques, execute data blending from multiple sources

6.4 Creation of Sets

Mark, highlight, sort, group, and use sets
Constant sets
Computed sets, bins, etc.

Hands-on Exercise:

Use marks to create and edit sets, highlight the desired items, make groups, apply to sort on results, make hierarchies among the created sets

6.5 Working with Filters

Filters
Filtering continuous dates, dimensions, and measures
Interactive filters, marks card, and hierarchies
How to create folders in Tableau
Sorting in Tableau, types of sorting, filtering in Tableau, Types of filters
Filtering the order of operations

Hands-on Exercise:

Use the data set by date/dimensions/measures to add a filter, Use an interactive filter to view the data, Customize/remove filters to view the result

6.6 Organizing Data and Visual Analytics

Using formatting pane
Formatting data using labels and tooltips
Edit axes and annotations
K-means cluster analysis
Trend and reference lines
Visual analytics in Tableau

Hands-on Exercise:

Apply labels and tooltips to graphs, annotations, edit axes’ attributes, set the reference line, perform k-means cluster analysis on the given dataset

6.7 Working with Mapping

Working on coordinate points
Plotting longitude and latitude
Editing unrecognized locations
Customizing geocoding, polygon maps, WMS: web mapping services
Working on the background image, including add image
Plotting points on images and generating coordinates from them
Map visualization, custom territories, map box, WMS map
Create map projects in Tableau
Creating dual axes maps, and editing locations

Hands-on Exercise:

Plot longitude and latitude on a geo map, edit locations on the geo map, custom geocoding, use images of the map and plot points, find coordinates, create a polygon map, use WMS

6.8 Working with Calculations and Expressions

Calculation syntax and functions in Tableau
Various types of calculations
LOD expressions, including concept and syntax
Aggregation and replication with LOD expressions
Nested LOD expressions
Levels of details
Quick table calculations
The creation of calculated fields
Predefined calculations
How to validate

6.9 Working with Parameters

Creating parameters
Parameters in calculations
Using parameters with filters
Column selection parameters
Chart selection parameters
Parameters in the filter session
Parameters in calculated fields
Parameters in the reference line

Hands-on Exercise:

Creating new parameters to apply on a filter, passing parameters to filters to select columns, passing parameters to filters to select charts

6.10 Charts and Graphs

Dual axes graph
Histograms, single and dual axes, box plot
Charts
Maps
Market basket analysis (MBA)
Using show me, text table, and highlighted table

Hands-on Exercise:

Plot a histogram, tree map, heat map, funnel chart, and more using the given dataset, perform market basket analysis (MBA) on the same dataset

6.11 Dashboards and Stories

What is a dashboard?
Building and formatting a dashboard
Best practices for making dashboards
Creating stories
Adding annotations
Tableau joins, Types of joins, Tableau field types
Saving as well as a publishing data source

Hands-on Exercise:

Create a Tableau dashboard view, include legends, objects, and filters, make the dashboard interactive, use visual effects, annotations, and descriptions to create and edit a story

6.12 Tableau Prep

Introduction to Tableau Prep
Getting deeper insights into the data with visualizations
Making data preparation simpler and accessible
Integrating Tableau Prep with Tableau analytical workflow
Data preparation to analysis with Tableau Prep

Module 7 - Mastering MS Excel for Business Analysis

7.1 Introduction to MS Excel & Data Extraction
7.2 Referencing in formulas
7.3 Name range
7.4 Logical functions
7.5 Conditional formatting
7.6 Advanced-level validation
7.7 Important formulas in Excel
7.8 Dynamic table
7.9 Data sorting, filtering
7.10 Chart creation techniques
7.11 Pivot tables in Excel
7.12 Data and file security
7.13 VBA Macros
7.14 Best practices of dashboards visualization
7.15 Creating dashboards
7.16 Creation of interactive components

Module 8 - SQL for Business Analytics

8.1 Introduction to SQL

Various types of databases
Structured Query Language
Distinction between client-server and file server databases
Understanding SQL Server Management Studio
SQL Table basics
Data types and functions
Transaction-SQL
Authentication for Windows
Data control language
Identification of keywords in T-SQL

8.2 Database Normalization and Entity Relationship Model

Data anomalies
What is normalization?
Types of normalization forms
Entity-relationship model

8.3 SQL Operators

Introduction to relational databases
Fundamental concepts of relational rows, tables, and columns
Several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys
Understanding group functions, the unique key

8.4 Working with SQL: Join, Tables, and Variables

Advanced concepts of SQL tables
SQL functions
Operators & queries
Table creation
Data retrieval from tables
Combining rows from tables
Deploying operators
Temporary table creation
Set operator rules
Table variables

8.5 Deep Dive into SQL Functions

SQL functions
Scalar and aggregate functions
Inline SQL functions
General and duplicate functions

8.6 Working with Subqueries

SQL subqueries and rules
Statements and operators with which subqueries can be used
Modify subqueries
Types of subqueries
Methods to create and view subqueries

8.7 SQL Views, Functions, and Stored Procedures

Learning SQL views
Methods of working with views
Stored procedures and their key benefits

Module 9 - 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 10 - Data Analysis with Python

10.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

10.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

10.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.

10.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.

10.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.

10.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

10.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

10.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

Module 11 - 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.