Business Analytics Professional Certification

MS Excel Benefits & Various Uses

Understanding of Worksheet, Workbook, Columns, Rows & Cells

Ribbon and Tabs

Bars: Quick access, Formula, Name, Status

Shortcuts & Navigation for Keyboards for large data

Alternative Uses of Mouse

Insert Comment

Converting data into tables: Methods & Advantages

Structured formula

Slicers Uses

Dynamic Range

Absolute Reference

Relative Reference

Mixed Reference

3D Reference

Text to Column

Flash Fill

Auto Fill

Ascending & Descending Order

Sorting with Text, Numbers & Date

Sorting with formatting (Cell, Color, Font Color)

Multiple Order Sorting

Custom Order Sorting

Data Filtering by text, numbers, or dates

Advanced Filter: Creating Filtering Criteria for Data

Advanced Filter: Creating Filtering Criteria for Data

Eliminating the existing criteria

Employ Wildcard characters in Filter Criteria

From Multiple Sheets

From Multiple Files

Mastering Syntax, Intellisense, Suggestion box & optional argument

Fundamental Calculations & BODMAS Rule

Calculate Square, cube & Raise Numbers to Power Course

Simple If

IF Combination: OR, AND & NOT

Nested IF Function

String Functions: LEN, TRIM, LEFT, MID, RIGHT, FIND, SEARCH, CONCATENATE, UPPER, LOWER, PROPER

REPLACE, SUBSTITUTE, SEARCH, FIND

Date & Time Formula

COUNTIFS

SUMIF & SUMIFS

AVERAGEIFS

Lookup Functions - VLOOKUP. HLOOKUP. LOOKUP

Vlookup Limitations

Reference Functions - MATCH INDEX

Simple XLookup

Exact Match

Approx Match

Nested XLookup

Case Sensitive Xlookup

Multiple Answer column Xlookup

Duplicate XLookUp Repeating Value

Definition and Usage

Applying Named Ranges in Functions

Validation by Whole Number, Decimal, Text Length, Time, Date, List, Custom

Input and Error Messages

Dependent Data Validation

Dynamic Dropdown range with Table

Spilled Ranges & use of #SPILL

Sort

Sort by

Unique

Filter

Sequence

IFs

 Applying Conditional Formatting

Multiple Rule Sets Use

Custom Rule Sets Development

Viewing and Managing Rules

Clearing Custom Rules

Developer Tab Displaying

Understanding Macros: Review and Purpose

Macros Saving Location

Recording: Absolute and relative, Charts & Sorting Data

Running macros: Allotting Quick Access Toolbar, shapes

Shortcuts: Pictures and keyboard

Record Code Altering

User-Defined Function (UDF)

Use Pre-built VBA code

Creating Pivot Tables

Reformatting Pivot Table Data

Pivot Table calculations & Modifications

Drill-Down

Pivot Data Filtering

Summarizing Values by Sum/Count/ Average/ Max/ Product

Showing Values -  % of Grand Total, % of Column Total, % of Row Total

Fields Grouping

Making Calculated Column(s) in Pivot

Making Calculated Item(s) in Pivot

Displaying and Hiding the Grand Totals

Pivot table data Refreshing

Data source Scope changing

Slicers: Insertions and Uses

Renaming the Slicer

Slicer Settings Altering

Slicer Formatting

Slicer Clearing

Enable PowerPivot

Understanding Data: Import Data, Transform Data, and Data Model for creating a report

Using Load, Load to & Data Transform

Using Power Query to record file steps from a folder

Adding column, Updating Column with Text, Numbers, & date

Selecting data

Chart Formatting

Types of Charts

Combo Chart

Making Custom chart types

Secondary Axis Uses

Trend Line in Charts Course & Uses

Format Painter

Freeze Pans

Removing Duplicates

Transposing Data

Paste Special

Print Settings

Custom Formatting

Goals of Creating a Dashboard

Creating Pivot Table & Charts

Designing  Dashboard

Using Macro for automatic refreshing & updating changes and additions in data

Password Protect: Sheet, workbook (file) for opening & modifying

Structure for Password Protect workbook (Review => protect Sheet)

Access to Edit Range with password

Understand Mail Merge

Hello World

Variables

Basic Arithmetic & logical operators (int, float)

Data Types - numbers, boolean & strings

Concat, Subset, Position, length, etc.

If-else, loops

Logic Flowcharts (Intuitive understanding of code flow)

Pseudo Code

Basic Programming syntax

List, Tuples, Sets & Dictionaries ​

Default functions

Default methods

Intro​ to Conditional statements (if-else, elif), Nested Conditional in Python ​

Intro​ to Basic For, While Loops, Break in Python​

Convert pseudo codes from Day 1 into programs using Loops and if-else. ​

List Comprehension​

Use cases vs Loops

Write Programs including both loops and If-else

Practice list comprehensions

Lab Exercises

Exploring commonly used built-in functions (min, max, sort, etc.)

Programming user-defined functions

Working with functions with and without arguments

Functions with return items

Understanding lambda functions

Overview of map, reduce, and filter functions

Introduction to R Language

How to install R

Documentation in R

Hello world

Package in R

Data Types in R

Data structures

Conditional statement in R

Loops in R

Subsetting

Reading Data from CSV and Excel files

Creating a vector and vector operations

Initializing data frame

Control structure

Data Visualization in R

Creating a Bar Chart

Creating Histogram and box plot

Plotting with base graphics

Plotting and coloring in R

Machine Learning Algorithms Using R

Introduction to DBMS

An Introduction to Relational Database

Concepts and SQL Accessing

Data Servers: MySQL/RDBMS Concepts

Extraction, Transformation, and Loading (“ETL”) Processes

Retrieve data from Single Tables-(use of SELECT Statement) and the power of WHERE and ORDER BY Clause. Retrieve and transform data from multiple Tables using JOINS and Unions

Introduction to Views, Working with Aggregate functions, grouping and summarizing Records, Writing Sub queries

Sampling

Probability distribution

Normal distribution

Poisson's distribution

Bayes’ theorem

Central limit theorem

Type 1 and Type 2 errors

Hypothesis testing

Types of hypothesis tests

Confidence Intervals

One-Sample T-Test

Anova and Chi-Square

Reading the Data

Cleaning the Data

Data Visualization in Python

Summary statistics (mean, median, mode, variance, standard deviation)

Seaborn

Matplotlib

Population VS sample

Univariate and Multivariate Statistics

Types of variables – Categorical and Continuous

Coefficient of correlations, Skewness, and Kurtosis

Bagging

Boosting

Bagging & Boosting Examples

Introduction to Model Deployment

Introduction to Flask in Python

How to deploy Applications in Flask?

Types of Model deployment

Introduction to Visualization, Rules of Visualization

Data Types, Sources, Connections, Loading, Reshaping

Data Aggregation

Working with Continuous and Discrete Data

Using Filters

Using Calculated Fields and parameters

Creating Tables and Charts

Building Dashboards and Storyboards

Sharing Your Work and Publishing for a wider audience

Introduction to Visualization

Introduction to Google Data Studio

How does Data Studio work?

Data Types, Sources, Connections, Loading, Reshaping

Data Aggregation

Working with Continuous and Discrete Data

Report Edit Mode in Data Studio.

Using Filters in Data Studio

Using Calculated Fields and parameters

Creating Tables and Charts

Building Dashboards and Storyboards

Building Dashboards and Storyboards in Data Studio

The key features of the Power BI workflow

Desktop application

BI service

File data sources

Sourcing data from the web (OData and Azure)

Building a dashboard

Data visualization

Publishing to the cloud

DAX data computation

Row context

Filter context

Analytics pane

Creating columns and measures

Data drill down and drill up

Creating tables

Binned tables

Data modeling and relationships

Power BI components such as Power View, Map, Query, and Pivot