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
About Lesson

#codanics #dataanalytics #dataanalytics #datanalystjobs #msexceltraining #powerbi #tableau #python #markdown #sql ————————————————————————————————————————————— Register guidelines: After clicking the link add course to the cart and check out then follow the procedure and pay the fee, send and email to the given address you will receive an email from our side then.

 

✅✅Link to register:✅✅

Join the conversation
Previous
Next
0% Complete