Excel data cleaning using power query

Excel data modelling

Excel pivot table chart

Excel sorting, filtering,data validation

Pivot table and chart

Practical exercise on excel sorting,filtering and data validation

Introduction to PowerBI

Introduction to PowerBI Chart 2

Introduction to PowerBI Chart 3

Introduction to PowerBI Chart

Logical Functions

Power Query

Text Function

And Function

Data Cleaning 2

Data Cleaning 3

Data Cleaning 4

Data Cleaning 5

Data Cleaning 6

Data Cleaning

Date Function

Merging Files

OR Function

Using measure

Creation of Database and table

Introduction to SQL

Select Statement and SQL operators

SQL operators 2

SQL textual, date and aggregate functions

The ALTER TABLE statement

Case Expression

Groupby 1

Groupby 2

Groupby 3

SQL Constraint

SQL Joins 2

SQL Joins

V1 (a)

V1 (b)

V2

V3

V4

V5

V6

V7

V8

import excel file contd.

import excel file.

intro to pandas.

method contd.

method in pandas.

reading _ summaring contd.

reading and summaring data.

Data Cleaning 1

Data Cleaning 1 Contd

Data Cleaning 2

Data Cleaning 2 cont-d

Data visualization 1 - matplotlib

Data visualization 2 - matplotlib

fileDMachine LearningData visualization 3

Machine learning introduction.

Build your first Machine learning model..

Changing Scientific notation values.

Linear Regression - Premium prediction.

Finding correlation.

splitting a dataset for ML model.

Evaluating a Regression model and Building a Class