Excel Introduction

Working with Excel

Membership-Data-Demo

Working with Excel Day2

Excel : working with Formula

Excel: working with formulas and functions

Excel-Formula-Function-assignment

Excel : data cleaning & Wrangling

Excel-Cleaning Data-Assignment2

Excel:data cleaning +wrangling with formulas

Excel:Data cleaning and wrangling (day2)

Excel: Filtering and sorting

Excel: Filtering and sorting2

Excel : Vlookup HLookup

Exce: Vlokup and HLookup (Day2)

Excel-Filtering-Sorting-Vlookup-HLookUp-Assognment3

Excel : FashFill & PickList

Excel : Creating Pivot

Excel : Creating Pivot (Day2)

Excel; Pivot assignment and working with charts

Excel: Working with graphs

Test

Excel : working with graphs (Day2)

Excel : Working with Graphs (Day3)

Excel-Pivot Assigment-4

Working on Graphs (day4)

Car-Demo-Data1

Working on Graphs (Day5)

Working n Graphs and DashBOard

Excel-Creating Basic Charts-Assignment5

Excel: working on DashBoard

Excel :DashBoard creation

Car-Data-Demo

Car-Demo-Data1

DashBoard-Filter

Python Installation

Python with anaconda

How to Install Python

get-pip

Python : First Program

PY0101EN-1-1-Write_your_first_python_code

Python: First Program (day2)

Python:Expression Assignment

Python: Assignment checking

Python:String (day2)

PY0101EN-1-2-Strings-20230410-1681084800.jupyterlite

String assignment

Python: List ,Tuples

PY0101EN-2-1-Tuples

Python;Tuple assigment

Python:List

PY0101EN-2-2-Lists

Python :Set

Python :Set assignment +dictonary

PY0101EN-2-3-Sets

Python : Dictionary assignment

PY0101EN-2-4-Dictionaries-20230526-1685059200.jupyterlite

Python: Condition and Branching

Python : Condition and Branching assignment

PY0101EN-3-1-Conditions

Python : Loops

Python; Lops assignment

Python : Functions

PY0101EN-3-2-Loops

Python Function (Day2)

Python : Function Assignment

PY0101EN-3-3-Functions

Python : Function Assignment Day2

Python : Function Assignment Day3

Python: Functions and Classes

Python : Classes

Python : Class assignment

PY0101EN-3-4-Classes

Python: Exception Handling

Python : Exception Handling assignment

3-1.2ExcecptionHandling (1)

Python: reading from files

Python : reading from Files assignment

PY0101EN-4-1-ReadFile

Python : Writing into files assignment

PY0101EN-4-2-WriteFile

Python: Write assignment

Python : Working on Numpy (one dimension)

Numpy One dim assignment

PY0101EN-5-1-Numpy1D1

Numpy Plotting 1 dim

Numphy : 2 Dimension

PY0101EN-5-2-Numpy2D

Python: Working on Pandas

PY0101EN-4-3-LoadData-Using-Pandas

python: working with different files

PY0101EN-5.4_WorkingWithDifferentFileTypes

Python: Working with different files (day2)

Introduction to Data Analytics

Recording Python Working with different files day2 -

Data Analytics : Data Import Assignment

Lab 1Importing Datasets

Data Analytics: Pre Processing Data

Data Analytics : Data cleaning

Data Wrangling

Data Analytics: Data cleaning Wrangling assignment checking

Car-Sale-Demo-New Assignment Sheet to PreProcess

Data Analytics : Data Formating & Normalization

Data Analytics : Binning

Data Analytics: Explanatory Data

Data Analytics: Grouping & Correlation

DA0101EN-3-Review-Exploratory-Data-Analysis

Data Analysis : GroupBy + Correlation (day2)

Data Analysis :Correlation + statistical corr

Working with Data Visualization

Data Visualization -day2

Data Visualization Using MatplotLib

Data Visualization : Matplotlib (day3)

Lab Introduction to Matplotlib and Line Plots-Copy1

Data Visualization matplotLib(day3)

Lab Pie Charts, Box Plots, Scatter Plots, and Bubble Plots

Data Visualization : working on MatplotLib (day3)

Data Vis : Area Plot,Histogram

Lab Area Plots, Histograms, and Bar Charts

Working on Direct Plot with MatplotLib

Data Visualization : Direct Plotting with MatpotLib

Lab Plotting Directly with Matplotlib

Data Visualization : MatplotLib assignment

Data Visualization :Polty working

Data Visualization Ploty

4.3_Plotly_Basics

Working on Ploty Dashboard

dash_interactive-Partial

Working on ploty Dash (day2)

Dash Assignment discussion

4.3_Plotly_Basics-Assignment

SQL : Basic

mysql-8.1.0-winx64-Server

mysql-workbench-community-8.0.34-winx64-client

SQL : Importing Data

HR_Database_Create_Tables_Script

Employee

Department

Jobs

JobsHistory

Location

SQL : Insert Update delete query

SQL : Update ,delete

SQL assignment discussion

SQL: Create Alter Drop

SQL : String Pattern Range

SQL : Grouping and Functons

Hands-on Lab-String Patterns, Sorting and Grouping

SQL : Build in Function

PETRESCUE-CREATE

SQL Cheat Sheet-Functions-Implicit Joins

SQL : working on sub query

SQL : Joining two tables

SQL : working on Joins (Day2)

Join-Flow

Hands-on Lab-String Patterns, Sorting and Grouping

Hands-on Lab -Sub-queries and Nested SELECTS

Hands-on Lab-Working with Multiple Tables

SQL Cheat Sheet-Functions-Implicit Joins

SQL Cheat Sheet-Like-OrderBy-groupBy

SQL assignment checking

Database connection to python

MYSQL Lab Connecting to a database instance-Part1

SQl-Query-Part2

SQL-Solved-Queries

SQ : Python with Mysql (day2)

MYSQl-Full-assignment-with-Plot

SQL : Python with SQLMagic

SQL : Project discussion

MYSQL Lab Analyzing a real World Data Set- Through SQLMagic-Copy1

Mysql : Information about database

MYSQL Analyzing System SQl Command Through SQLMagic-school data

ChicagoPublicSchools

SQLLite Working

SQLITE Creating tables, inserting and querying Data-

SQLite Working on Real Database With SQLMagic -School Data

Recording - SQL : working on Views 35:00

Recording - SQL: Stored Procedure 41:00

view-assignment

Stored-Procedure

SQL : Stored Procedure (day 2)

SQL :Transaction

BankAccounts-CREATE

ShoeShop-CREATE

Transaction-assignment

Power BI Introduction

Power Bi; Data Cleaning

Power Bi : Graphs ploting

Power Bi : Graphs and Report

gap-minder

Books into Movies

Power Bi : working on Dax functions

Food Prep - DAX

Power Bi : Dax Function (Day2)

POWERBI-Git-Project

You may also be interested in

Data Science & Analytics 8 am (New)