4.60
(5 Ratings)
Data Analyst Summer Bootcamp 2024
About Course
You will learn the following in this course:
- What is Data?
- Basic Concepts of Data Analytics
- How to handle Data using Microsoft Excel
- Beginner to Advance guide to use Microsoft Excel
- Power BI for Data Analytics
- Tableau for Data Analytics
- SQL for Data Analytics
- MarkDown
- Python for Data Analytics
- Much more…. (Please watch the intro lecture)
Note: This is a self paced learning course with certificate at the end.
Course Duration
This course was conducted and recorded for a three months course content during the following dates 01.06.2024-31.08.2024
Course plan and Details
- This is a self paced learning course.
- Each lecture’s duration is 30-50 minutes.
- Certificates will be provided to all by the end of this course
Everything will be provided on this course page.
For more details contact us at info@codanics.com
Join our WhatsApp channel for details and updates about recent positions:
https://whatsapp.com/channel/0029Va7nRDq3QxRzGqaQvS3r
Follow me on LinkedIn:
https://www.linkedin.com/in/aammar-tufail/
Tiktok:
https://www.tiktok.com/@draammar
Youtube: www.youtube.com/@codanics
Twitter/X: https://x.com/aammar_tufail
What Will You Learn?
- This course will train you in Data Analytics without coding and with coding including MS Excel, PowerBI, Tableau, SQL and Python.
Course Content
Introduction (Day-1)
How to enroll in this course?
-
06:21
Important Information (only for enrolled students)
-
Important Announcements for Enrolled Students
00:00
Zoom Meeting – 1
-
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
Data is Everywhere
Data Analyst Jobs and Profiles
-
Data Analyst Job Roles and Profile
18:01 -
Important Skills, tools and Qualifications to be a Data Analyst
08:56 -
02:43
Scales/Levels of Measurements
-
Nominal vs. Ordinal Scales (Categorical Data)
10:13 -
Interval vs. Ratio Scales (Numerical Data)
09:36
Data Collection
-
Data Collection Methods
23:12 -
Data Collection Measurement Errors
12:12
Data Types
-
Primary Data vs. Secondary Data
12:21
How to ask Questions in this course?
-
Discord Server for this course
01:51
Data Types in Detail
-
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
MS Excel (Part-1)
-
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)
-
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)
-
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
What we have learned so far?
-
09:56
Advance Excel Tips
-
Questions and Answers about lectures
22:24 -
Advances tips in MS Excel about functions and formula
33:07
Excel Tips for Formula Sheet
-
MS Excel Tips in Formula Basics to Intermediate
16:19 -
MS Excel Tips Joining Text and Numbers
05:42
Lecture Day 21 07 2024 (Refined)
-
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)
-
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)
-
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)
-
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 about Discord server and recordings
-
Zoom Meeting Recoding 28 July 2024
19:14 -
Discord Server Community Link for Codanics Community
01:01
Statistics for Data Analysis (Part-4)
-
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)
-
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)
-
Inferential Statistics
07:17 -
Hypothesis Testing
21:03 -
Confidence Interval in statistics
10:05 -
More tests coming soon….
00:00
Zoom Meeting
-
Recording of Zoom Meeting
01:02:00 -
Assignment and Questions 04 08 2024
05:00
Excel Add-ins
-
MS Excel Import Add-ins for Data Analysts
37:00 -
Assignment for Students (09.08.2024)
01:34
MS Excel Advance Tips
-
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
-
Power BI Lecture will follow | Announcement for Data Analyst Summer Bootcamp
01:24
Power BI (Part-1)
-
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)
-
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 for data wrangling
-
Data Wrangling using MS Excel for Titanic Dataset
58:03
Power BI (Part-3)
-
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
-
Tableau for Beginners | Complete Course
01:53:29
Power BI (Part-4)- DAX (Data Analysis Expression)
-
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 with students for questions
-
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
-
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
-
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
Student Ratings & Reviews
4.6
Total 5 Ratings
5
3 Ratings
4
2 Ratings
3
0 Rating
2
0 Rating
1
0 Rating
This is a good course for beginners, and Sir Aammar's teaching style is awesome.
I'm serving as a GIS Analyst, and want to grow my self in data analysis.
Excellent
yeah
Excellent