What will you learn and Registration Process

Data Analyst Summer Bootcamp 2024 What will you learn and Registration Process

Data Analyst Summer Bootcamp 2024

0% Completed

Introduction (Day-1)

Video - 4:57 mins

How to enroll in this course?

Enrolment Process

Video - 6:21 mins

Important Information (only for enrolled students)

Important Announcements for Enrolled Students

Video - 00:00 mins

Zoom Meeting – 1

Where can you get everything about this course?

Video - 6:22 mins

Microsoft Excel and Installation (Course Plan)

Special Offer

Special Offer and Next Steps

Video - 5:23 mins

Data is Everywhere

Data is Everywhere and Data Analyst Demand is Increasing

Video - 13:42 mins

Data Analyst Jobs and Profiles

Data Analyst Job Roles and Profile

Video - 18:01 mins

Important Skills, tools and Qualifications to be a Data Analyst

Video - 8:56 mins

Data Analysts Roles in Railways

Video - 2:43 mins

Scales/Levels of Measurements

Nominal vs. Ordinal Scales (Categorical Data)

Video - 10:13 mins

Interval vs. Ratio Scales (Numerical Data)

Video - 9:36 mins

Data Collection

Data Collection Methods

Video - 23:12 mins

Data Collection Measurement Errors

Video - 12:12 mins

Data Types

Primary Data vs. Secondary Data

Video - 12:21 mins

How to ask Questions in this course?

Discord Server for this course

Video - 1:51 mins

Data Types in Detail

Primary vs. Secondary Data

Video - 5:32 mins

Qualitative vs. Quantitative Data | Discreet and Continuous Numeric Data

Video - 10:05 mins

Categorical Data | Nominal and Ordinal Data Types

Video - 5:29 mins

Binary Data

Video - 4:48 mins

Time Series Data for Data Analysts

Video - 4:59 mins

Cross-sectional and Longitudinal Data

Video - 3:45 mins

Spatial data or GIS Data

Video - 6:07 mins

Multidimensional Data and its importance for Data Analysts

Video - 6:11 mins

Structured vs. Un-structured vs. Semi-structured data

Video - 5:54 mins

MS Excel (Part-1)

Introduction and Basics of MS Excel

Video - 42:03 mins

Task and Assignment

Video - 6:43 mins

How to submit the task and Assignment

Video - 1:46 mins

MS Excel (Part-2)

Master Microsoft Excel for Data Analysis in 10 steps

Video - 53:34 mins

Auto Fitting Rows and Columns in Microsoft Excel

Video - 1:02 mins

Pasting and Formatting Dates in Excel

Video - 1:35 mins

Data Tables in Excel

Video - 1:28 mins

Serial Numbers in Excel

Video - 1:42 mins

Add current date and time in Microsoft Excel

Video - 0:57 mins

Hyperlinks in Microsoft Excel

Video - 0:43 mins

Dynamic Interactive chart in Microsoft Excel

Video - 2:39 mins

Mean, standard Deviation and Standard Error Calculation in MS EXCEL

Video - 6:21 mins

Descriptive Statistics in MS Excel |Hindi/Urdu

Video - 4:14 mins

Percent Calculation in MS Excel

Video - 3:44 mins

Correlation and Linear Regression in MS Excel

Video - 12:20 mins

IQR (Interquartile range) in Microsoft Excel

Video - 2:40 mins

CV (Coefficient of Variation) in Microsoft Excel

Video - 4:46 mins

t-test in Microsoft Excel

Video - 9:39 mins

MS Excel (Part-3)

Introduction to MS EXCEL

Video - 8:10 mins

Excel Basics Knowledge

Video - 18:08 mins

Change alphabets in upper & lower case in excel

Video - 3:48 mins

Add rows and columns in excel

Video - 3:47 mins

Select entire row & entire column in excel

Video - 3:27 mins

Group & ungroup data in excel

Video - 2:55 mins

Delete blank rows in excel

Video - 6:24 mins

Convert numbers into words using excel

Video - 4:50 mins

Combine Data in one column using excel

Video - 2:37 mins

Add date in excel

Video - 00:00:00 mins

Calculate age in excel

Video - 15:38 mins

Calculation with Dates

Video - 2:44 mins

Compare data in Excel

Video - 7:12 mins

Change date format in excel

Video - 15:58 mins

Calculate time difference in excel

Insert image in excel

Video - 3:09 mins

Insert PPT/PDF in excel

Video - 2:57 mins

Convert PDF to Excel

Video - 3:26 mins

Insert tickmarks in MS Excel

Video - 5:51 mins

Insert watermark in excel

Video - 3:05 mins

Set cell size in excel

Video - 4:12 mins

Create barcodes in excel

Video - 3:22 mins

Excel flash Fill

Video - 2:36 mins

Add hyperlink in excel

Video - 4:14 mins

Round off formula in excel

Video - 1:44 mins

Calculate standard deviation in excel

Video - 6:21 mins

Sort by date in excel

Video - 2:57 mins

Sort data set in Excel

Video - 3:47 mins

Slicers and Filters in Excel

Add drop down list in Excel

Video - 7:18 mins

Data Validation in Excel

Video - 18:55 mins

Lock (Protect) cells in MS Excel

Video - 4:30 mins

Excel print page setup

Video - 9:42 mins

Conditional Formatting in Excel

Video - 4:42 mins

Remove duplicates in excel

Video - 2:50 mins

SUMIFS Formula

Video - 8:22 mins

Calculate percentage in excel

Video - 1:50 mins

Autofill in Excel

Video - 4:56 mins

Highlight duplicates in excel

Video - 3:47 mins

Charts In excel

Video - 10:11 mins

Progress tracker in Excel

vLookup Function (A complete Basic Guide)

Video - 38:27 mins

Vstack Function In Excel

Video - 1:55 mins

Indirect Function in Excel

Recover unsaved files in excel

Video - 5:12 mins

Project planning and Gantt chart in Excel

Video - 9:11 mins

MIS (Management Information System) Reports in Excel

Video - 00:10:29 mins

Time series analysis (Complete Basic Guide)

Video - 34:18 mins

Dashboard in Excel (Part-1)

Video - 23:52 mins

Power Query in Excel

Video - 17:16 mins

Dashboard in Excel (Part-2)

Video - 33:05 mins

Shortcut Keys in MS Excel

Video - 00:22:52 mins

Logical Test in MS Excel

Video - 00:03:41 mins

IF Function in MS Excel

Video - 00:08:44 mins

NESTED IF Function in MS Excel

Video - 00:04:06 mins

NOT Function & IF ERROR Function in MS Excel

Video - 00:03:39 mins

AND Function in MS Excel

Video - 00:07:47 mins

Auditing Tools in MS Excel

Video - 00:06:20 mins

Maths & Trigonometric Functions in MS Excel

Video - 00:09:47 mins

What we have learned so far?

Master MS Excel

Video - 9:56 mins

Advance Excel Tips

Questions and Answers about lectures

Video - 22:24 mins

Advances tips in MS Excel about functions and formula

Video - 00:33:07 mins

Excel Tips for Formula Sheet

MS Excel Tips in Formula Basics to Intermediate

Video - 00:16:19 mins

MS Excel Tips Joining Text and Numbers

Video - 00:05:42 mins

Lecture Day 21 07 2024 (Refined)

Mastering Excel's Data Analysis ToolPak: Essential Skills for Data Analysts

Video - 00:58:04 mins

Question Answer Session 21 07 2024

Video - 00:09:50 mins

Statistics for Data Analysis (Part-1)

Introduction to Statistics

Video - 8:03 mins

But what is statistics?

Video - 00:06:05 mins

Content of the course

Video - 00:08:10 mins

Why Statistics is Important for Data Scientists/Analysts?

Video - 00:07:15 mins

Scales/Levels of Measurement in statistics

Video - 17:26 mins

Qualitative vs. quantitative Data

Video - 00:09:38 mins

Discrete vs. Continuous vs. Binary Data types

Video - 00:06:56 mins

Categorical vs. Ordinal Categorical Data

Video - 4:43 mins

Multivariate Data

Video - 3:02 mins

Structured vs. Unstructured Data

Video - 9:34 mins

Boolean Data type or Binary Data

Video - 1:18 mins

Statistics for Data Analysis (Part-2)

Operationalization and proxy measurements

Video - 8:25 mins

Surrogate Endpoints in statistics

Video - 9:27 mins

True and Error Score

Video - 10:30 mins

Types of Errors in Data Collection

Video - 00:11:21 mins

Type-I and Type-II errors

Video - 00:11:59 mins

Reliability and validity

Video - 00:15:39 mins

Triangulation

Video - 15:31 mins

Measurement and Data Bias

Video - 00:27:59 mins

How to remove bias?

Video - 00:08:39 mins

Statistics for Data Analysis (Part-3)

Types of Statistics or Statistical Analysis

Video - 18:19 mins

Why is statistics important to learn?

Video - 00:10:38 mins

Data Analysis and Types of Data Analysis

Video - 15:42 mins

Central Tendency: Mean, Median, and Mode

Video - 6:20 mins

Zoom Meeting about Discord server and recordings

Zoom Meeting Recoding 28 July 2024

Video - 19:14 mins

Discord Server Community Link for Codanics Community

Video - 00:01:01 mins

Statistics for Data Analysis (Part-4)

Central Tendency of the Data Complete Guide

Video - 10:33 mins

Mean in statistics (ignore Python Part)

Video - 00:24:42 mins

Hormonic Mean understanding of the formula

Video - 00:01:19 mins

Limitations of using mean in statistics

Video - 00:04:15 mins

Median in statistics (Ignore Python part in the lecture)

Video - 00:12:54 mins

Mode in Statistics (Ignore Python Part in the lecture)

Video - 00:15:17 mins

Population vs. sample and their means

Video - 00:06:42 mins

Variability | Dispersion | Spread of the Data

Video - 21:02 mins

Range of the Data

Video - 9:28 mins

Interquartile range (IQR) of the data (ignore Python code)

Video - 17:39 mins

Variance of the data (Ignore Python Code)

Video - 12:41 mins

Standard Deviation and Standard Error in statistics (ignore python code)

Video - 24:02 mins

Normal distribution and Standard Deviation

Video - 7:43 mins

Data Distributions and types of data distributions (Ignore python code)

Video - 00:22:30 mins

Skewness and Kurtosis (ignore Python Code)

Video - 00:26:01 mins

Statistics for Data Analysis (Part-5)

Primary vs. Secondary | Data

Video - 13:43 mins

Data Collection in the age of big data

Video - 00:16:24 mins

Best Practices for Data Collection

Video - 00:10:00 mins

Representative and Non-representative sample types

Video - 00:11:59 mins

Details of each Sampling Techniques for Data Collection

Video - 00:10:27 mins

Hybrid sampling methods

Video - 0:33 mins

Descriptive Statistics for Data Analysts

Video - 16:00 mins

Exploratory Data Analysis (EDA) and Statistics

Video - 00:18:53 mins

How to choose the right statistical method?

Video - 00:23:59 mins

Exploratory Data Analysis (EDA) and the Four Pillars of statistics

Video - 00:05:04 mins

Dependent vs. independent variables

Video - 00:09:59 mins

Statistics for Data Analysis (Part-6)

Inferential Statistics

Video - 7:17 mins

Hypothesis Testing

Video - 21:03 mins

Confidence Interval in statistics

Video - 10:05 mins

More tests coming soon....

Video - 00:00 mins

Zoom Meeting

Recording of Zoom Meeting

Video - 01:02:00 mins

Assignment and Questions 04 08 2024

Video - 5:00 mins

Excel Add-ins

MS Excel Import Add-ins for Data Analysts

Video - 00:37:00 mins

Assignment for Students (09.08.2024)

Video - 00:01:34 mins

MS Excel Advance Tips

MS Excel Night to Practice MS Excel (Univariate, Bivariate and Multivariate Analysis)

Video - 02:53:24 mins

Data Scrapping | Paris Summer Olympics 2024 Medal Data Scrapping using MS Excel

Video - 00:07:06 mins

Power Query in MS Excel in 30 Minutes

Video - 00:34:32 mins

Dependent Dropdown Lists in Excel (Using INDEX, MATCH, OFFSET, CHOOSE & INDIRECT Functions)

Video - 00:14:21 mins

Important Announcement | Power BI Lectures

Power BI Lecture will follow | Announcement for Data Analyst Summer Bootcamp

Video - 00:01:24 mins

Power BI (Part-1)

Introduction to Data Visualization

Video - 7:54 mins

Power BI vs. Tableau vs. Python?

Video - 8:55 mins

Top 11 benefits of using Power BI

Video - 11:05 mins

Install Power BI Desktop

Video - 6:44 mins

Update Power BI features and Updates

Video - 4:25 mins

Learning Resources for Power BI

Video - 3:51 mins

Business Intelligence with Power BI

Video - 11:08 mins

Seven Steps Workflow to use Power BI

Video - 4:40 mins

Power BI interface and Features

Video - 12:20 mins

Connect Data in Power BI

Video - 14:13 mins

Power BI (Part-2)

Data used in Power BI

Video - 00:00 mins

Data Visualization and Plotting in Power BI

Video - 3:33 mins

Column/Bar charts in Power BI

Video - 7:57 mins

Create a bar plot like a professional

Video - 16:37 mins

Pro tips to make a stunning plot in Power BI

Video - 14:53 mins

Pie Chart in power BI

Video - 4:30 mins

Donut Chart in Power BI

Video - 3:51 mins

TreeMap in Power BI

Video - 3:23 mins

Line Charts in Power BI

Video - 6:23 mins

Save Power BI plots as report PDF

Video - 3:47 mins

Funnel Chart in Power BI

Video - 4:45 mins

Change colors of a Funnel chart in power BI

Video - 1:37 mins

Include Exclude Options in Power BI

Video - 5:33 mins

Zoom Meeting for data wrangling

Data Wrangling using MS Excel for Titanic Dataset

Video - 58:03 mins

Power BI (Part-3)

View data and export as CSV file

Video - 4:36 mins

Slicer and Filter

Video - 3:27 mins

Add Tables in Dash Board as Visuals

Video - 4:29 mins

Matrix in Power BI Desktop

Video - 2:44 mins

Key Performance Indicators KPI

AI in Power BI Desktop for Data Interpretation

Video - 5:18 mins

Geo Maps in Power BI Desktop

Video - 9:54 mins

Filled GEO Maps in Power BI Desktop

Video - 4:34 mins

Pie Charts in GEO Maps and Maps formatting

Video - 6:53 mins

How to create Map of Pakistan in Power BI?

Video - 18:40 mins

Complete Project | Professional Dashboard for Sales Analysis in Power BI Desktop

Video - 23:15 mins

Tableau Complete Course

Tableau for Beginners | Complete Course

Video - 1:53:29 mins

Power BI (Part-4)- DAX (Data Analysis Expression)

DAX (Data Analysis Expression) in Power BI and MS Excel

Video - 9:29 mins

Pre-requisites to Learn DAX in Power BI

Video - 9:13 mins

DAX (Data Analysis Expression) syntax and expression writing

Video - 14:03 mins

Basic use of DAX Expressions in Power BI

Video - 26:48 mins

Power BI DAX project A-Z on titanic Dataset

Video - 1:04:39 mins

Zoom Meeting with students for questions

Questions by Students in Zoom Meeting

Video - 3:02 mins

Assignment Important before next session

Video - 1:37 mins

Next Plan for the Data Analyst Bootcamp

SQL Complete Course

Install MySQL on Windows 10

Video - 14:12 mins

Create a MySQL Database for Beginners

Video - 2:29 mins

create/modify tables in mySQL

Video - 19:21 mins

DISTINCT function in mySQL

Video - 5:39 mins

Constraints in mySQL

Video - 51:51 mins

Auto increment in mySQL

Video - 5:56 mins

mySQL workbench first look and interface

Video - 20:08 mins

Import mySQL database in mySQL workbench

Video - 12:15 mins

Pandas processing on mySQL database

Video - 5:09 mins

SELECT clause in mySQL

Video - 00:12:25 mins

Data Manipulation in mySQL

Video - 14:06 mins

WHERE clause and comparison operators

Video - 00:10:48 mins

AND OR NOT and IN | my SQL

Video - 12:30 mins

BETWEEN clause in mySQL

Video - 00:04:14 mins

mySQL in vscode and work with github co-pilot

Video - 00:08:24 mins

Python for Data Analytics

Installation of Python + VsCode + miniconda + Git

Video - 12:44 mins

VScode and Miniconda use for Python for Data Analysts

Video - 43:11 mins

GitBash and miniconda | Integration | Solutions

Video - 7:34 mins

Python is popular for a reason

Video - 14:22 mins

Important Logins and websites

Video - 13:09 mins

GitHub student or teacher developer pack

Video - 0:55 mins

Rules for Naming files and folders in Python

Video - 16:20 mins

.ipynb vs. .py files

Video - 13:27 mins

What are python Notebooks? .ipynb | jupyter Notebooks

Video - 8:05 mins

Learn MarkDown in 72 minutes

Video - 1:11:24 mins

Variable in Python

Video - 19:37 mins

Types of Variables in Python

Video - 23:47 mins

Type casting in Python (1/2)

Video - 23:42 mins

Type Casting in Python (2/2)

Video - 9:03 mins

Commenting in Python is important

Video - 4:58 mins

git bash in vscode and conda in gitbash

Video - 3:44 mins

screencasting mode in VScode to show Keyboard

Video - 2:29 mins

Debugging is an art you need to learn

Video - 6:45 mins

Google have all solutions

Video - 9:59 mins

Blackbox and codeium |Alternatives to GitHub copilots for VScode

Video - 3:04 mins

Windows screenshots and Screen Recording tool free

Video - 3:49 mins

Use of Variables in Python

Video - 10:49 mins

Data Structures in Python | Complete Guide

Video - 35:50 mins

Nobel prize in AI and Machine Learning

Video - 13:08 mins

Sequences in Python programming

Video - 21:57 mins

Indexing in python programming

Video - 25:10 mins

Slicing in Python programming

Video - 6:02 mins

Mutable elements in Python

Video - 6:04 mins

Range Function in Python

Video - 2:26 mins

Control Flow Statements in Python

Video - 20:06 mins

If else and elif control flow statements in python

Video - 17:34 mins

operators | Conditional and relational | nested if statements

Video - 21:56 mins

for and while loops in python with examples and code

Video - 15:15 mins

break, continue and pass statements

Video - 8:45 mins

Infinite loop in python | Beware of infinite loops

Video - 10:00 mins

Try, Except and finally statements in python

Video - 5:16 mins

Convert notebook to pdf | step by step guide with error handling (uncut version)

gitbash and conda in vscode

Video - 1:43 mins

9 Methods to use print function in Python

Video - 41:55 mins

Generators in Python

Video - 13:34 mins

Introduction to Libraries in Python

Video - 22:11 mins

PyPI , pip and famous libraries in python

Video - 4:25 mins

Step-by-Step Installation of libraries in conda environments

Video - 16:33 mins

Top five libraries of Python for Data Analysts

Video - 8:18 mins

Seventeen important python libraries, I bet you did not know before

Video - 11:11 mins

Newsletters to access latest AI News

Video - 5:26 mins

Using python libraries as professionals

Video - 16:34 mins

Importing and Saving Data in python

Video - 19:54 mins

Nine-step guide for Data Analysts and Data Scientists

Video - 20:17 mins

Four dimensions of Data Handling and EDA for Data Scientists and Analysts

Video - 15:43 mins

pandas profiling or y-data profiling for automatic EDA in python

Video - 20:50 mins

python library for automatic exploratory data analysis for any data

Video - 14:03 mins

Make stunning plots for EDA like tableau for free in python

Video - 11:29 mins

Sweetviz library for EDA | complete debugging uncut

Video - 36:01 mins

Skimpy library, dealing with errors and installations

Video - 22:43 mins

Skimpy error resolved

Video - 4:29 mins

lida for automatic EDA using LLM

Video - 9:54 mins

Low code EDA library for python | dataprep | A-Z master guide

Video - 9:42 mins

Lida python library for Automatic EDA using LLMs

Video - 20:23 mins

Free AI Models available for LLM tasks, we will see in future

Video - 4:27 mins

Account to make which are important for all

Video - 1:23 mins

Pandas Dataframes vs. datasets

Video - 14:16 mins

Reading Data for python using pandas library from clipboard

Video - 6:24 mins

Reading data from Excel using pandas library in python

Video - 6:42 mins

Reading csv and tsv files in python using pandas library

Video - 12:08 mins

Making dummy datasets in python using pandas library from dictionary

Video - 3:44 mins

Writing data into files using pandas library in python

Video - 5:16 mins

Data Import in Pandas using Excel workbook with specific paths

Video - 6:24 mins

.xlsx vs. csv files

Video - 4:59 mins

Using absolute paths in windows for data import in pandas or python

Video - 3:19 mins

Do not use spaces in reading files in pandas but what if?

Video - 2:06 mins

Web scrapping using pandas library in python for table import

Video - 6:39 mins

Read online .csv files using pandas python library

Video - 5:38 mins

Read tabular data in pandas

Video - 3:41 mins

Read data from json file in pandas python

Video - 1:17 mins

Elements of Pandas data frames in python | series | df

Video - 4:19 mins

Subset or filter the data based on rows or columns

Video - 15:38 mins

Important methods for selecting subset of the dataframes in pandas python

Video - 3:29 mins

Selecting known data or unknown data from dataframes in pandas python

Video - 2:24 mins

Absolute vs. relative paths

Video - 5:30 mins

loc and iloc functions for data selection in pandas python library

Video - 15:48 mins

EDA in pandas python library | A complete case study (Project A-Z)

Video - 1:07:31 mins

Financial Data Handling with thousand separators in Pandas

Video - 6:35 mins

Statistics for Data Science Complete Crash course for beginners

Video - 14:15:35 mins

Mathematics for Data Science and Machine Learning

Video - 15:15:51 mins

Numpy for Data Science

Video - 34:59 mins

50 plus commands for NumPy for Data Science and Machine Learning

Video - 57:35 mins

Quiz-Python for Data Science

Video - 00:00 mins

Quiz-Mathematics for Data Science

Video - 00:00 mins

Data Visualization introduction

Video - 10:41 mins

Data Visualization in python | Important Terminologies

Video - 1:04:40 mins

Announcements Reviews Live Classes Gradebook Certificate Course Info

Previous Next

Complete the course to unlock the certificate

Data Analyst Summer Bootcamp 2024 What will you learn and Registration Process

Data Analyst Summer Bootcamp 2024