Business Analytics Certification

Power BI Introduction

Power BI Components

Getting Data using Power BI

Power BI Transformations

Creating Data Models

Power BI Charts

Power BI Filters

Power BI Visualizations

Exploring Data in Power BI

Power BI and Excel

Power BI Publishing and sharing

Data Analysis Expressions (DAX)

Report & Dasboards

Artificial Intelligence Visuals – Key Influencers

Real Time Project on Data Visualization

SQL Programming

Entity Relationship Diagram (ERD)

CREATE DATABASE

CREATE TABLE

INSERT INTO TABLE

SELECT QUERY

UPDATE TABLE

DELETE DATA FROM TABLE

DROP TABLE

LIMIT

ORDER BY

WHERE CLAUSE

ARITHMETIC OPERATORS – MULTIPLE, ADDITION, SUBTRACTION, DIVISION

PRIMARY & FOREIGN KEYS

JOINS

AGGREGATIONS

DATA CLEANING

ROW NUMBER & RANK

UNION, INTERSECTION

Advanced Excel

Statistics and Regression