Working with Excel

Working with Excel Day2

DataDec24

Excel : Working with Formula & Function

Excel-Formula-Function-assignment

Excel : Data cleaning & Wrangling

Excel :Data Cleaning and Data Quality

Excel : Data Cleaning and Wrangling (Day2)

Excel-Cleaning Data-Assignment2

Excel : Data wrangling and cleaning (day3)

Excel-Filtering-Sorting-Vlookup-HLookUp-Assognment3

Excel : Filtering and Sorting (day2)

Excel: Working on conditional functions

Excel :Working on Vlookup and HLookUp

Excel: working on Pivot

Excel-Pivot Assigment-4

Excel : Introduction

Excel: Working on charts

Excel :Working on charts (day2)

Excel-Creating Basic Charts-Assignment5

Excel : working on adv graphs

Excel : Graphs on Pivot

Excel : Working on DashBoard

excel : working on dashboard day2

Chart-Dashboard-Final_assignment

Excel ;Assignment discussion

Python :Installtion

How to Install Python

Python : First Program

PY0101EN-1-1-Write_your_first_python_code

Python : Expression

Python : String

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

Python: Tuple

PY0101EN-2-1-Tuples

Python ; List

PY0101EN-2-2-Lists

List assignment and Set

PY0101EN-2-3-Sets

Python: Dictonary

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

Assignment discussion

Python : Operator

Python : Operator assignment

PY0101EN-3-1-Conditions

Python : Working on Loops

Python : Loops assignment

PY0101EN-3-2-Loops

Python : working on Functions

Python : Working on Function Day2

Recording - Python : Function Assignment Day2 28:00

Recording - Python : Function Assignment Day1 49:00

PY0101EN-3-3-Functions

Python ; Function assignment checking

Python Classes and Object (day2)

PY0101EN-3-4-Classes

Assignment checking + Exception Handling (day1)

Exception Handling assignment

3-1.2ExcecptionHandling (1)

Python : Working on file (read)

PY0101EN-4-1-ReadFile

Python : writing to file

PY0101EN-4-2-WriteFile

Python : writing into file (day2)

Python : Working on Numpy (one dimension)

PY0101EN-5-1-Numpy1D1

Numpy One dim assignment

Python: Numpy Assignment -2

PY0101EN-5-2-Numpy2D

Python : working with pandas

PY0101EN-4-3-LoadData

Python : Pandas assignment

PY0101EN-5.4_WorkingWithDifferentFileTypes

Python : working with different files

sample4

test

tetsj

Python : working on API (day1)

Python : API assignment

PY0101EN-5.1_Intro_API

PY0101EN-5.2_API_2.v2

Python : API Assignment (Day2)

Python ; HTTP Rest API (assignment)

PY0101EN-5.3_Requests_HTTP

Python : discussion on assignment

Introduction to Data Analysis

Data Analy : Data Import

Lab 1Importing Datasets

Data Analy: Data Cleaning

Data Wrangling

Data Analy: Data Wrangling

Car-Sale-Demo

Data Analy : Exploratory Data

Data Analy : Exploratory Data Assignment

DA0101EN-3-Review-Exploratory-Data-Analysis

Data Anly : Group By

Data Analy : Statistical correlation

Data Visu : Introduction

Data Visu ; Matplotlib Int

Data Vis: Plotting through Pandas

Data Vis : data preprocessing for charts

Lab Exploring and Pre-processing a Dataset using Pandas

Data Vis : Working on plots Line chart

Lab Introduction to Matplotlib and Line Plots-Copy1

Data Vis: Working on plots Pie chart

Data Vis: Box Chart, scatter chart

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

Data Vis: Scatter bubble plot

Data Vis : working on different charts

Data Vis : working on different chart (Day3)

Lab Area Plots, Histograms, and Bar Charts

Data Vis : Histogram ,bar charts

Data Vis : Bar charts

Data Vis : Direct Potting wit MatPlotLib

Data Vis : Direct Plotting with MatplotLib (day2)

Lab Plotting Directly with Matplotlib-Assignment

Working with plotly

4.3_Plotly_Basics

Plotly Assignment

Assignment discussion

Data vis: working on dashboard

Data Vis : Plotly Dash (day2)

Dash assignment

dash_interactive-Partial

Dash assignment discussion + Webscrapping

labs_module 1_Web Scraping_Web-Scraping-Review-Lab

python: webscrapping assignment

working on database

mysql-8.1.0-winx64

SQL : Database setup

mysql-workbench-community-8.0.34-winx64-client

HR_Database_Create_Tables_Script

Employee2

Department

Jobs

JobsHistory

Location

Data base setup

SQL : Insert ,update query

SQL : create, alter tables

CREATE, ALTER, TRUNCATE, DROP into Tables

SQL : Build in Functions

SQL Cheat Sheet

SQL : Working on predefined functions

SQL : String Pattern Range

Hands-on Lab-String Patterns, Sorting and Grouping

SQL : working on subquery

Hands-on Lab -Sub-queries and Nested SELECTS

SQL : joining Tables

SQL: Joining Table Day2

Hands-on Lab-Working with Multiple Tables

Join-Flow

SQL : Views

view-assignment

Recording - SQL : Build in Function in SQL 45:00

SQL: Stored Procedure

Stored-Procedure

SQL: Transaction

BankAccounts-CREATE

ShoeShop-CREATE

Transaction-assignment

SQL: assignment discussion

MYSQL Lab Connecting to a database instance-Part1

final-assignment

chicago_crime

chicago_public_schools

chicago_socioeconomic_data

SQL Connecting to database (Day2)

MYSQl-Full-assignment-with-Plot

SQl : Database connectivity Day3

SQL; working with SQLMagic

MYSQL Lab Analyzing a real World Data Set- Through SQLMagic

MYSQL Analyzing System SQl Command Through SQLMagic-Chicago-Public-school-assignment

Pizza-Sales-analysis-using-SQL-main

SQL : working with SQLite

SQLITE Creating tables, inserting and querying Data-

SQLiite: working with SQlMagic

SQLite Working on Real Database With SQLMagic -School Data

SQL-Solved-Queries

SQl-Query-Part2

PowerBi Introduction

PBIDesktopSetup

Power Bi : Data Loading and Cleaning

PowerBi:creating graphs

gap-minder

PowerBi: Plotting in graphs(day2)

PowerBi: working on Dashboard

PowerBI: working on DAX functions

Power Bi : Working on Dax (day3)

Date-Dax-Function

DAX-Functions

Covid-19 Vaccination Dashboard

Indigo Fare Sales

Git Working

Working with Jira

Tableau Introduction + Setup

GitProject

GitHub-Create-Personal-AccessToken

Enhancing Salesforce Code Collaboration- Authenticate Git with Personal Access Token (PAT) and Push Code via Command Line

Tableau Discussion

You may also be interested in

Data Science & Analytics Dec24 8 am