Master’s in Business Analytics in USA

Module 01 – Introduction to SQL
Module 02 – Database Normalization and Entity Relationship Model
Module 03 – SQL Operators
Module 04 – Working with SQL: Join, Tables, and Variables
Module 05 – Deep Dive into SQL Functions
Module 06 – Working with Subqueries
Module 07 – SQL Views, Functions, and Stored Procedures
Module 08 – Deep Dive into User-defined Functions
Module 09 – SQL Optimization and Performance
Module 10 – Advanced Topics
Module 11 – Managing Database Concurrency
Module 12 – Programming Databases Using Transact-SQL
Module 13 – Microsoft Courses: Study Material

Tools covered

Certified Business Analysis Professional (CBAP®)

32 Hours 12 Module

Module 01 – Introduction to CBAP Certification
Module 02 – Business Analysis Process management
Module 03 – Roles and Responsibilities of Business Analyst
Module 04 – Overview of Governance body(IIBA) and BABOK
Module 05 – Requirement Analysis and Design Definition
Module 06 – Business Analysis Planning and Monitoring
Module 07 – Business Analysis Approach
Module 08 – Business Analysis Governance & Information Management
Module 09 – Business Analysis Performance Improvements
Module 10 – Requirement Lifecycle Management and Strategy Analysis
Module 11 – Requirement Analysis, Design Definition, and Solution Evaluation
Module 12 – Business Analysis Perspectives and Creating UML
Module 13 – Microsoft Courses: Study Material

Tableau Training

30 Hours 13 Module

Module 01 – Introduction to Data Visualization and The Power of Tableau
Module 02 – Architecture of Tableau
Module 03 – Charts and Graphs
Module 04 – Working with Metadata and Data Blending
Module 05 – Advanced Data Manipulations
Module 06 – Working with Filters
Module 07 – Organizing Data and Visual Analytics
Module 08 – Working with Mapping
Module 09 – Working with Calculations and Expressions
Module 10 – Working with Parameters
Module 11 – Dashboards and Stories
Module 12 – Tableau Prep
Module 13 – Integration of Tableau with R

Tools covered

Business Analyst Capstone

4 Hours 1 Module

Module 01 – Business Analyst

Business Analyst with Excel

24 Hours 23 Module

Module 01 – Entering Data
Module 02 – Referencing in Formulas
Module 03 – Name Range
Module 04 – Understanding Logical Functions
Module 05 – Getting started with Conditional Formatting
Module 06 – Advanced-level Validation
Module 07 – Important Formulas in Excel
Module 08 – Working with Dynamic table
Module 09 – Data Sorting
Module 10 – Data Filtering
Module 11 – Chart Creation
Module 12 – Various Techniques of Charting
Module 13 – Pivot Tables in Excel
Module 14 – Ensuring Data and File Security
Module 15 – Getting started with VBA Macros
Module 16 – Ranges and Worksheet in VBA
Module 17 – IF condition
Module 18 – Loops in VBA
Module 19 – Debugging in VBA
Module 20 – Dashboard Visualization
Module 21 – Principles of Charting
Module 22 – Getting started with Pivot Tables
Module 23 – Statistics with Excel

Tools covered

Mathematical Optimization for Business Problems (IBM Portal)

6 Hours 1 Module

Module 01 – Course Introduction

Agile Scrum Training

6 Hours 7 Module

Module 01 – Introducing Agile Principles
Module 02 – Defining the Agile Framework
Module 03 – Agile Ceremonies and Artifacts
Module 04 – Refining the Product Backlog
Module 05 – Estimating and Prioritizing Product Backlog Items
Module 06 – Agile Responsibilities to the Team
Module 07 – Agile Project

Tools covered

Free Career Counselling

We are happy to help you 24/7

Project Work

Projects will be a part of your Business Analyst Master’s program to consolidate your learning. It will ensure that you have real-world experience in Business Analytics.

Practice 100+ Essential Tools

Get Real-world Experience

Write Complex Sub-queries

The project aims at helping you work with SQL subqueries and also use them in numerous situations. The various queries to be used and covered as a part of the project are - IN or NOT IN, EXISTS or NOT EXISTS, and ANY or ALL, etc.

Query a Large Relational Database

This interesting project on relational databases allows the learners practical know-how to work with various data types, table basics, SQL functions, and SQL operators to acquire the customer details through database querying.

Calculation of Employee Bonuses

The comprehensive project lets the learners use the ‘if’ function to calculate the bonuses of all the employees at 10% of their salary. Also, rate the sales employees as per the respective sales figures and rating scale.

Design a Relational Database

As a part of the project, learn to successfully design a relational database and convert relational design, consisting of the details of the various users, user accounts and user roles, etc., in the SQL Server table.

Deal with Financial Data

This project requires learners to analyze global sales and profit by developing an interactive map. It also helps the learners to practically understand how to use map styles and layers for enhanced visualization.

Work with Agricultural Data

As a part of the project, learners will have to display district-wise data to successfully build an interactive treemap with state labels. Also, the districts must be displayed on hovering over the respective states.

Planning Poker

Each estimator gets a deck of cards and each card has a valid estimate written on it. Each estimator selects a card as an estimate and the cards are turned over to discuss the differences and re-estimate until estimates converge.

Identify the Global Mortality Rate Due to COVID-19

The project aims at identifying the mortality rate by COVID-19 at a global level. Analyze and create a dashboard to gain insights into the COVID-19 cases. Use a world map to compare the confirmed cases and death cases worldwide.

Work with the Customer Data of the UK Bank

This real-life based project has been included to let learners analyze and create a dashboard to gain insight from the UK bank’s customer data. Build an asymmetric drop-down consisting of the region and the corresponding user details.

Career Transition

Shubham Shinde

Data Analyst | India

300% Salary Hike

Intellipaat training helped me crack interviews successfully and transition to a Data Analytics role with a 300% hike at Deloitte. The support staff and mentorship from seasoned educators has contributed highly to my career growth. Read More

Business Intelligence Specialist

Data Analyst

Kiran Kulkarni

Sr. Data Analyst | India

Non-Tech to Tech

I started working in the BPO Sector. I wanted to grow in some technical domain and eventually chose Data Analytics. I found the course immensely interesting and the support staff was of great help.

BPO Associate

Sr. Data Analyst

Aditya Ahuja

Data Analyst | India

130% Salary Hike

Successful career transition from a Quality Analyst to a Data Analyst at Accenture. Intellipaat’s training and excellent placement assistance fetched me offers from companies like Mindtree, Cognizant, and Accenture.

Software Test Engineer

Data Analyst

Lucky Bajetha

Data Analyst | India

Non-Tech to Data Analyst

After completion of my B. Tech, I was working in Human Resources. While pursuing Intellipaat’s course, I mentioned it in my resume and that made a great impact. I started getting calls from various MNCs like Infosys, Capgemini, and EY. Read More

Human Resource Executive

Data Analyst

Bibhu Mohanta

Apttus CPQ/Salesforce Consultant | Pune