Masters in Business Analytics / Analyst

IT Industry Fundamentals for Business Analysts

Business Analysis Essentials

Business Process Analysis

Requirements Process - The Core of Business Analysis Activity

Stakeholder Analysis and Management

UML- Unified Modelling Language for the Business Analyst

Microsoft Visio for the Business Analyst

Business Process Model and Notation

Bizagi Business Process Modeler

Business Analysis Techniques

Requirements Elicitation, Collaboration, and Techniques

Requirements Analysis, Wireframes and Prototypes

Requirements Documentation - BRD, FRD, SRS Preparation

Agile Business Analysis

SQL and Database Concepts for the IT Business Analyst

Software Test Management & User Acceptance Testing for the IT Business Analyst

Understanding Concepts of Excel

MS Excel Advance concepts

Advance Data Sorting

Restoring data to the original format

Advance Functions, filters in Excel

Lookup Functions

Pivot table

MIS Reporting & Dashboard

Introduction to Power BI

Power BI Desktop and Data Transformation

Data Analysis Expressions (DAX)

Data Visualization

Power BI Service

Connectivity Modes

Power BI Report Server

R & Python in Power BI

Advanced Analytics in Power BI

Module 1: Data Preparation using Tableau Prep.

Module 2: Data Connection with Tableau Desktop.

Module 3: Basic Visual Analytics.

Module 4: Calculations in Tableau.

Module 5: Advanced Visual Analytics.

Module 6: Level of Detail (LOD) Expressions in Tableau.

Module 7: Geographic Visualizations in Tableau.

Module 8: Advanced charts in Tableau.

Module 9: Dashboards and Stories.

Module 10: Get Industry Ready.

Module 11: Exploring Tableau Online.

Introduction To Python

Python Keyword and Identifiers

Introduction To Variables

Python Data Type

Control Structure & Flow

Python Functions, Modules, and Packages

Python Date Time and Calendar

List, Tuple, Dictionary

Sets, Strings

Python Exception Handling

Python File Handling

Python Database Interaction

Contacting users Through Emails Using Python

Reading an excel

Complete Understanding of OS Module of Python

Connectivity Modes

Power BI Report Server

R & Python in Power BI

Advanced Analytics in Power BI

Data Analysis and Visualization using Pandas.

Data Analysis and Visualization using NumPy and MatPlotLib

Introduction to Data Visualization with Seaborn

Know about Seaborn

Visualizing Two Quantitative Variables

Visualizing a Categorical and a Quantitative Variable

Customizing Seaborn Plots

SQL Server Fundamentals

SQL Server 2019 Database Design

SQL Tables in MS SQL Server

Data Validation and Constraints

Views and Row Data Security

Indexes and Query tuning

Stored Procedures and Benefits

System functions and Usage

Triggers, cursors, memory limitations

Cursors and Memory Limitations

Transactions Management

Introduction to Data Analytics

Accessing/Importing and Exporting Data

Data Manipulation Cleansing - Munging Using Python Modules

Feature Engineering in Data Science

Data Analysis Visualization Using Python

Introduction to Statistics

Introduction to Predictive Modelling

EDA (Exploratory Data Analysis)

Data Pre-Processing & Data Mining

Work on a final project to apply your learning to real-world problems, with guidance from the instructor.