Course Content
Introduction (Day-1)
0/1
What will you learn and Registration Process
04:57
How to enroll in this course?
0/1
Enrolment Process
06:21
Important Information (only for enrolled students)
0/1
Important Announcements for Enrolled Students
00:00
Zoom Meeting – 1
0/4
Where can you get everything about this course?
06:22
Microsoft Excel and Installation (Course Plan)
07:54
Data is Everywhere
13:05
Complete Course Plan
08:14
Special Offer
0/1
Special Offer and Next Steps
05:23
Data is Everywhere
0/1
Data is Everywhere and Data Analyst Demand is Increasing
13:42
Data Analyst Jobs and Profiles
0/3
Data Analyst Job Roles and Profile
18:01
Important Skills, tools and Qualifications to be a Data Analyst
08:56
Data Analysts Roles in Railways
02:43
Zoom Meeting – 2
0/1
Zoom Meeting Link and Time
00:00
Scales/Levels of Measurements
0/2
Nominal vs. Ordinal Scales (Categorical Data)
10:13
Interval vs. Ratio Scales (Numerical Data)
09:36
Data Collection
0/2
Data Collection Methods
23:12
Data Collection Measurement Errors
12:12
Data Types
0/1
Primary Data vs. Secondary Data
12:21
How to ask Questions in this course?
0/1
Discord Server for this course
01:51
Data Types in Detail
0/9
Primary vs. Secondary Data
05:32
Qualitative vs. Quantitative Data | Discreet and Continuous Numeric Data
10:05
Categorical Data | Nominal and Ordinal Data Types
05:29
Binary Data
04:48
Time Series Data for Data Analysts
04:59
Cross-sectional and Longitudinal Data
03:45
Spatial data or GIS Data
06:07
Multidimensional Data and its importance for Data Analysts
06:11
Structured vs. Un-structured vs. Semi-structured data
05:54
Next ZooM Meeting Details and Time
0/1
Zoom Meeting of enrolled students 30.06.2024
00:00
MS Excel (Part-1)
0/3
Introduction and Basics of MS Excel
42:03
Task and Assignment
06:43
How to submit the task and Assignment
01:46
MS Excel (Part-2)
0/15
Master Microsoft Excel for Data Analysis in 10 steps
53:34
Auto Fitting Rows and Columns in Microsoft Excel
01:02
Pasting and Formatting Dates in Excel
01:35
Data Tables in Excel
01:28
Serial Numbers in Excel
01:42
Add current date and time in Microsoft Excel
00:57
Hyperlinks in Microsoft Excel
00:43
Dynamic Interactive chart in Microsoft Excel
02:39
Mean, standard Deviation and Standard Error Calculation in MS EXCEL
06:21
Descriptive Statistics in MS Excel |Hindi/Urdu
04:14
Percent Calculation in MS Excel
03:44
Correlation and Linear Regression in MS Excel
12:20
IQR (Interquartile range) in Microsoft Excel
02:40
CV (Coefficient of Variation) in Microsoft Excel
04:46
t-test in Microsoft Excel
09:39
MS Excel (Part-3)
0/68
Introduction to MS EXCEL
08:10
Excel Basics Knowledge
18:08
Change alphabets in upper & lower case in excel
03:48
Add rows and columns in excel
03:47
Select entire row & entire column in excel
03:27
Group & ungroup data in excel
02:55
Delete blank rows in excel
06:24
Convert numbers into words using excel
04:50
Combine Data in one column using excel
02:37
Add date in excel
00:00
Calculate age in excel
15:38
Calculation with Dates
02:44
Compare data in Excel
07:12
Change date format in excel
15:58
Calculate time difference in excel
02:43
DAX in MS Excel
05:41
Checkbox in MS Excel
03:25
Insert Excel in PPT
02:14
Insert image in excel
03:09
Insert PPT/PDF in excel
02:57
Convert PDF to Excel
03:26
Insert tickmarks in MS Excel
05:51
Insert watermark in excel
03:05
Set cell size in excel
04:12
Create barcodes in excel
03:22
Excel flash Fill
02:36
Add hyperlink in excel
04:14
Round off formula in excel
01:44
Calculate standard deviation in excel
06:21
Sort by date in excel
02:57
Sort data set in Excel
03:47
Slicers and Filters in Excel
02:52
Add filters in Excel
01:58
Goal Seek in Excel
04:24
Add drop down list in Excel
07:18
Data Validation in Excel
18:55
Lock (Protect) cells in MS Excel
04:30
Excel print page setup
09:42
Conditional Formatting in Excel
04:42
Remove duplicates in excel
02:50
SUMIFS Formula
08:22
Calculate percentage in excel
01:50
Autofill in Excel
04:56
Highlight duplicates in excel
03:47
Charts In excel
10:11
Progress tracker in Excel
02:38
Gantt Chart in Excel
03:16
Mail Merge in Excel
05:31
vLookup Function (A complete Basic Guide)
38:27
Vstack Function In Excel
01:55
Indirect Function in Excel
04:57
Web query in Excel
04:37
User form in Excel
11:15
Recover unsaved files in excel
05:12
Project planning and Gantt chart in Excel
09:11
MIS (Management Information System) Reports in Excel
10:29
Time series analysis (Complete Basic Guide)
34:18
Dashboard in Excel (Part-1)
23:52
Power Query in Excel
17:16
Dashboard in Excel (Part-2)
33:05
Shortcut Keys in MS Excel
22:52
Logical Test in MS Excel
03:41
IF Function in MS Excel
08:44
NESTED IF Function in MS Excel
04:06
NOT Function & IF ERROR Function in MS Excel
03:39
AND Function in MS Excel
07:47
Auditing Tools in MS Excel
06:20
Maths & Trigonometric Functions in MS Excel
09:47
Announcement about Zoom meeting 07.07.2024
0/1
No Zoom meeting on 07.07.2024
00:00
What we have learned so far?
0/1
Master MS Excel
09:56
Zoom Meeting-3
0/1
Next Zoom Meeting
00:00
Advance Excel Tips
0/2
Questions and Answers about lectures
22:24
Advances tips in MS Excel about functions and formula
33:07
Excel Tips for Formula Sheet
0/2
MS Excel Tips in Formula Basics to Intermediate
16:19
MS Excel Tips Joining Text and Numbers
05:42
Zoom Meeting-4 (21 July 2024)
0/1
Zoom Meeting will be at 17:00 on 21.07.2024
00:00
Lecture Day 21 07 2024
0/3
Mastering Excel’s Data Analysis ToolPak: Essential Skills for Data Analysts
58:04
Question Answer Session 21 07 2024
09:50
Statistics for Data Analysis (Part-1)
0/13
Introduction to Statistics
08:03
But what is statistics?
06:05
Content of the course
08:10
Why Statistics is Important for Data Scientists/Analysts?
07:15
Scales/Levels of Measurement in statistics
17:26
Qualitative vs. quantitative Data
09:38
Discrete vs. Continuous vs. Binary Data types
06:56
Time Series Data
03:03
Spatial Data
02:25
Categorical vs. Ordinal Categorical Data
04:43
Multivariate Data
03:02
Structured vs. Unstructured Data
09:34
Boolean Data type or Binary Data
01:18
Statistics for Data Analysis (Part-2)
0/9
Operationalization and proxy measurements
08:25
Surrogate Endpoints in statistics
09:27
True and Error Score
10:30
Types of Errors in Data Collection
11:21
Type-I and Type-II errors
11:59
Reliability and validity
15:39
Triangulation
15:31
Measurement and Data Bias
27:59
How to remove bias?
08:39
Statistics for Data Analysis (Part-3)
0/4
Types of Statistics or Statistical Analysis
18:19
Why is statistics important to learn?
10:38
Data Analysis and Types of Data Analysis
15:42
Central Tendency: Mean, Median, and Mode
06:20
Zoom Meeting-5 (28.07.2024)
0/3
Zoom Meeting to Discuss Statistics (28.07.2024)
00:00
Zoom Meeting Recoding 28 July 2024
19:14
Discord Server Community Link for Codanics Community
01:01
Statistics for Data Analysis (Part-4)
0/15
Central Tendency of the Data Complete Guide
10:33
Mean in statistics (ignore Python Part)
24:42
Hormonic Mean understanding of the formula
01:19
Limitations of using mean in statistics
04:15
Median in statistics (Ignore Python part in the lecture)
12:54
Mode in Statistics (Ignore Python Part in the lecture)
15:17
Population vs. sample and their means
06:42
Variability | Dispersion | Spread of the Data
21:02
Range of the Data
09:28
Interquartile range (IQR) of the data (ignore Python code)
17:39
Variance of the data (Ignore Python Code)
12:41
Standard Deviation and Standard Error in statistics (ignore python code)
24:02
Normal distribution and Standard Deviation
07:43
Data Distributions and types of data distributions (Ignore python code)
22:30
Skewness and Kurtosis (ignore Python Code)
26:01
Statistics for Data Analysis (Part-5)
0/11
Primary vs. Secondary | Data
13:43
Data Collection in the age of big data
16:24
Best Practices for Data Collection
10:00
Representative and Non-representative sample types
11:59
Details of each Sampling Techniques for Data Collection
10:27
Hybrid sampling methods
00:33
Descriptive Statistics for Data Analysts
16:00
Exploratory Data Analysis (EDA) and Statistics
18:53
How to choose the right statistical method?
23:59
Exploratory Data Analysis (EDA) and the Four Pillars of statistics
05:04
Dependent vs. independent variables
09:59
Statistics for Data Analysis (Part-6)
0/4
Inferential Statistics
07:17
Hypothesis Testing
21:03
Confidence Interval in statistics
10:05
More tests coming soon….
00:00
Zoom Meeting-6 (04.08.2024)
0/3
Zoom Meeting details (04.08.2024)
00:00
Recording of Zoom Meeting
01:02:00
Assignment and Questions 04 08 2024
05:00
Excel Add-ins
0/2
MS Excel Import Add-ins for Data Analysts
37:00
Assignment for Students (09.08.2024)
01:34
MS Excel Advance Tips
0/4
MS Excel Night to Practice MS Excel (Univariate, Bivariate and Multivariate Analysis)
02:53:24
Data Scrapping | Paris Summer Olympics 2024 Medal Data Scrapping using MS Excel
07:06
Power Query in MS Excel in 30 Minutes
34:32
Dependent Dropdown Lists in Excel (Using INDEX, MATCH, OFFSET, CHOOSE & INDIRECT Functions)
14:21
Important Announcement | Power BI Lectures
0/1
Power BI Lecture will follow | Announcement for Data Analyst Summer Bootcamp
01:24
Power BI (Part-1)
0/10
Introduction to Data Visualization
07:54
Power BI vs. Tableau vs. Python?
08:55
Top 11 benefits of using Power BI
11:05
Install Power BI Desktop
06:44
Update Power BI features and Updates
04:25
Learning Resources for Power BI
03:51
Business Intelligence with Power BI
11:08
Seven Steps Workflow to use Power BI
04:40
Power BI interface and Features
12:20
Connect Data in Power BI
14:13
Power BI (Part-2)
0/13
Data used in Power BI
00:00
Data Visualization and Plotting in Power BI
03:33
Column/Bar charts in Power BI
07:57
Create a bar plot like a professional
16:37
Pro tips to make a stunning plot in Power BI
14:53
Pie Chart in power BI
04:30
Donut Chart in Power BI
03:51
TreeMap in Power BI
03:23
Line Charts in Power BI
06:23
Save Power BI plots as report PDF
03:47
Funnel Chart in Power BI
04:45
Change colors of a Funnel chart in power BI
01:37
Include Exclude Options in Power BI
05:33
Zoom Meeting-7 (18.08.2024)
0/2
Zoom Meeting link and time information
00:00
Data Wrangling using MS Excel for Titanic Dataset
58:03
Power BI (Part-3)
0/13
View data and export as CSV file
04:36
Slicer and Filter
03:27
Add Tables in Dash Board as Visuals
04:29
Matrix in Power BI Desktop
02:44
Key Performance Indicators KPI
06:21
Row Cards
07:45
Waterfall chart
03:22
AI in Power BI Desktop for Data Interpretation
05:18
Geo Maps in Power BI Desktop
09:54
Filled GEO Maps in Power BI Desktop
04:34
Pie Charts in GEO Maps and Maps formatting
06:53
How to create Map of Pakistan in Power BI?
18:40
Complete Project | Professional Dashboard for Sales Analysis in Power BI Desktop
23:15
Tableau Complete Course
0/1
Tableau for Beginners | Complete Course
01:53:29
Power BI (Part-4)- DAX (Data Analysis Expression)
0/5
DAX (Data Analysis Expression) in Power BI and MS Excel
09:29
Pre-requisites to Learn DAX in Power BI
09:13
DAX (Data Analysis Expression) syntax and expression writing
14:03
Basic use of DAX Expressions in Power BI
26:48
Power BI DAX project A-Z on titanic Dataset
01:04:39
Zoom Meeting 25 08 2024
0/4
Zoom Meeting Link
00:00
Questions by Students in Zoom Meeting
03:02
Assignment Important before next session
01:37
Next Plan for the Data Analyst Bootcamp
01:30
SQL Complete Course
0/17
What is SQL?
08:17
Introduction to SQL
20:16
Install MySQL on Windows 10
14:12
Create a MySQL Database for Beginners
02:29
create/modify tables in mySQL
19:21
DISTINCT function in mySQL
05:39
Constraints in mySQL
51:51
Auto increment in mySQL
05:56
mySQL workbench first look and interface
20:08
Import mySQL database in mySQL workbench
12:15
Pandas processing on mySQL database
05:09
SELECT clause in mySQL
12:25
Data Manipulation in mySQL
14:06
WHERE clause and comparison operators
10:48
AND OR NOT and IN | my SQL
12:30
BETWEEN clause in mySQL
04:14
mySQL in vscode and work with github co-pilot
08:24
Python for Data Analytics
0/94
Installation of Python + VsCode + miniconda + Git
12:44
VScode and Miniconda use for Python for Data Analysts
43:11
GitBash and miniconda | Integration | Solutions
07:34
Python is popular for a reason
14:22
Important Logins and websites
13:09
GitHub student or teacher developer pack
00:55
Rules for Naming files and folders in Python
16:20
.ipynb vs. .py files
13:27
What are python Notebooks? .ipynb | jupyter Notebooks
08:05
Learn MarkDown in 72 minutes
01:11:24
Variable in Python
19:37
Types of Variables in Python
23:47
Type casting in Python (1/2)
23:42
Type Casting in Python (2/2)
09:03
Commenting in Python is important
04:58
git bash in vscode and conda in gitbash
03:44
screencasting mode in VScode to show Keyboard
02:29
Debugging is an art you need to learn
06:45
Google have all solutions
09:59
Blackbox and codeium |Alternatives to GitHub copilots for VScode
03:04
Windows screenshots and Screen Recording tool free
03:49
Use of Variables in Python
10:49
Data Structures in Python | Complete Guide
35:50
Nobel prize in AI and Machine Learning
13:08
Sequences in Python programming
21:57
Indexing in python programming
25:10
Slicing in Python programming
06:02
Mutable elements in Python
06:04
Range Function in Python
02:26
Control Flow Statements in Python
20:06
If else and elif control flow statements in python
17:34
operators | Conditional and relational | nested if statements
21:56
for and while loops in python with examples and code
15:15
break, continue and pass statements
08:45
Infinite loop in python | Beware of infinite loops
10:00
Try, Except and finally statements in python
05:16
Convert notebook to pdf | step by step guide with error handling (uncut version)
23:29
Functions in Python
26:22
Lambda function
22:32
user input in python
24:31
gitbash and conda in vscode
01:43
9 Methods to use print function in Python
41:55
Generators in Python
13:34
Introduction to Libraries in Python
22:11
PyPI , pip and famous libraries in python
04:25
Step-by-Step Installation of libraries in conda environments
16:33
Top five libraries of Python for Data Analysts
08:18
Seventeen important python libraries, I bet you did not know before
11:11
Newsletters to access latest AI News
05:26
Using python libraries as professionals
16:34
Importing and Saving Data in python
19:54
Nine-step guide for Data Analysts and Data Scientists
20:17
Four dimensions of Data Handling and EDA for Data Scientists and Analysts
15:43
pandas profiling or y-data profiling for automatic EDA in python
20:50
python library for automatic exploratory data analysis for any data
14:03
Make stunning plots for EDA like tableau for free in python
11:29
Sweetviz library for EDA | complete debugging uncut
36:01
Skimpy library, dealing with errors and installations
22:43
Skimpy error resolved
04:29
lida for automatic EDA using LLM
09:54
Low code EDA library for python | dataprep | A-Z master guide
09:42
Lida python library for Automatic EDA using LLMs
20:23
Free AI Models available for LLM tasks, we will see in future
04:27
Account to make which are important for all
01:23
Pandas Dataframes vs. datasets
14:16
Reading Data for python using pandas library from clipboard
06:24
Reading data from Excel using pandas library in python
06:42
Reading csv and tsv files in python using pandas library
12:08
Making dummy datasets in python using pandas library from dictionary
03:44
Writing data into files using pandas library in python
05:16
Data Import in Pandas using Excel workbook with specific paths
06:24
.xlsx vs. csv files
04:59
Using absolute paths in windows for data import in pandas or python
03:19
Do not use spaces in reading files in pandas but what if?
02:06
Web scrapping using pandas library in python for table import
06:39
Read online .csv files using pandas python library
05:38
Read tabular data in pandas
03:41
Read data from json file in pandas python
01:17
Elements of Pandas data frames in python | series | df
04:19
Subset or filter the data based on rows or columns
15:38
Important methods for selecting subset of the dataframes in pandas python
03:29
Selecting known data or unknown data from dataframes in pandas python
02:24
Absolute vs. relative paths
05:30
loc and iloc functions for data selection in pandas python library
15:48
EDA in pandas python library | A complete case study (Project A-Z)
01:07:31
Financial Data Handling with thousand separators in Pandas
06:35
Statistics for Data Science Complete Crash course for beginners
14:15:35
Mathematics for Data Science and Machine Learning
15:15:51
Numpy for Data Science
34:59
50 plus commands for NumPy for Data Science and Machine Learning
57:35
Quiz-Python for Data Science
00:00
Quiz-Mathematics for Data Science
00:00
Data Visualization introduction
10:41
Data Visualization in python | Important Terminologies
01:04:40
Data Analyst Summer Bootcamp 2024
    Join the conversation
    Syeda Naheed Abbas 5 months ago
    Thanks Sir. Railways are a good example to relate to our previous lectures, showing that data is everywhere and covers all aspects of our lives.
    Reply
    Abdullah Abrar 5 months ago
    It's a nice opportunity for students. Sir, I have some questions can you please assist?
    Reply
    Previous
    Next
    0% Complete