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:57
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:13
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
05:00
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:04
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:33
Auto Fitting Rows and Columns in Microsoft Excel
01:03
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:58
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:20
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:41
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:49
Add rows and columns in excel
03:47
Select entire row & entire column in excel
03:28
Group & ungroup data in excel
02:56
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:27
Insert tickmarks in MS Excel
05:51
Insert watermark in excel
03:06
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:56
Lock (Protect) cells in MS Excel
04:31
Excel print page setup
09:42
Conditional Formatting in Excel
04:43
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:26
Vstack Function In Excel
01:56
Indirect Function in Excel
04:58
Web query in Excel
04:38
User form in Excel
11:16
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:53
Power Query in Excel
17:16
Dashboard in Excel (Part-2)
23: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
Assignment before next session
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:43
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:38
Variance of the data (Ignore Python Code)
12:41
Standard Deviation and Standard Error in statistics (ignore python code)
24:03
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:06
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:45
Update Power BI features and Updates
04:25
Learning Resources for Power BI
03:52
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:54
Pie Chart in power BI
04:30
Donut Chart in Power BI
03:52
TreeMap in Power BI
03:24
Line Charts in Power BI
06:24
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:37
Slicer and Filter
03:27
Add Tables in Dash Board as Visuals
04:30
Matrix in Power BI Desktop
02:45
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:41
Complete Project | Professional Dashboard for Sales Analysis in Power BI Desktop
23:15
Tableau Complete Course
0/1
Tableau for Beginners | Complete Course
01:52:00
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:38
Next Plan for the Data Analyst Bootcamp
01:31
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:22
DISTINCT function in mySQL
05:39
Constraints in mySQL
51:51
Auto increment in mySQL
05:56
mySQL workbench first look and interface
20:28
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
Data Analyst Summer Bootcamp 2024
About Lesson

All MS Excel Lectures have been uplaoded on the course LMS page, please have a look and finish the lectures by Next Sunday, aj hamari zoom meeting nahi ho ge, next zoom meeting sunday ko ho ge which will be almost 2-3 hours long workshop. Stay tuned. and please keep an eye on the course page:
https://codanics.com/courses/data-analyst-summer-bootcamp/

 

Join the conversation
Umar Mehmood 2 months ago
Sir Aj zoom meeting he
Reply
Previous
Next
0% Complete