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)

Course Duration

This course will be a three months course 01.06.2024-31.08.2024

Course plan and Details

We will have 3-5 recorded lectures every week
1 live session via zoom will be conducted every weekend where you can ask questions Most probably on Sunday at 17:00 Pakistan Time.
Each lecture’s duration will be 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

Course Content

Introduction (Day-1)

What will you learn and Registration Process
04:57

How to enroll in this course?

Important Information (only for enrolled students)

Zoom Meeting – 1

Special Offer

Data is Everywhere

Data Analyst Jobs and Profiles

Zoom Meeting – 2

Scales/Levels of Measurements

Data Collection

Data Types

How to ask Questions in this course?

Data Types in Detail

Next ZooM Meeting Details and Time

MS Excel (Part-1)

MS Excel (Part-2)

MS Excel (Part-3)

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

What we have learned so far?

Zoom Meeting-3

Advance Excel Tips

Excel Tips for Formula Sheet

Zoom Meeting-4 (21 July 2024)

Lecture Day 21 07 2024

Statistics for Data Analysis (Part-1)

Statistics for Data Analysis (Part-2)

Statistics for Data Analysis (Part-3)

Zoom Meeting-5 (28.07.2024)

Statistics for Data Analysis (Part-4)

Statistics for Data Analysis (Part-5)

Statistics for Data Analysis (Part-6)

Zoom Meeting-6 (04.08.2024)

Excel Add-ins

MS Excel Advance Tips

Important Announcement | Power BI Lectures

Power BI (Part-1)

Power BI (Part-2)

Zoom Meeting-7 (18.08.2024)

Power BI (Part-3)

Tableau Complete Course

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

Zoom Meeting 25 08 2024

SQL Complete Course

Student Ratings & Reviews

4.6

Total 5 Ratings

5 Ratings

3 Ratings

0 Rating

Syeda Naheed Abbas

3 months ago

This is a good course for beginners, and Sir Aammar's teaching style is awesome.

Tassawar Hussain

3 months ago

I'm serving as a GIS Analyst, and want to grow my self in data analysis.

Ali Akbar

3 months ago

Excellent

MUHAMMAD ALI KHAN

3 months ago

yeah

rehmatgul1355

3 months ago

Excellent

About Course

Course Duration

Course plan and Details

What Will You Learn?

Course Content

Introduction (Day-1)

What will you learn and Registration Process

How to enroll in this course?

Enrolment Process

Important Information (only for enrolled students)

Important Announcements for Enrolled Students

Zoom Meeting – 1

Where can you get everything about this course?

Microsoft Excel and Installation (Course Plan)

Data is Everywhere

Complete Course Plan

Special Offer

Special Offer and Next Steps

Data is Everywhere

Data is Everywhere and Data Analyst Demand is Increasing

Data Analyst Jobs and Profiles

Data Analyst Job Roles and Profile

Important Skills, tools and Qualifications to be a Data Analyst

Data Analysts Roles in Railways

Zoom Meeting – 2

Zoom Meeting Link and Time

Scales/Levels of Measurements

Nominal vs. Ordinal Scales (Categorical Data)

Interval vs. Ratio Scales (Numerical Data)

Data Collection

Data Collection Methods

Data Collection Measurement Errors

Data Types

Primary Data vs. Secondary Data

How to ask Questions in this course?

Discord Server for this course

Data Types in Detail

Primary vs. Secondary Data

Qualitative vs. Quantitative Data | Discreet and Continuous Numeric Data

Categorical Data | Nominal and Ordinal Data Types

Binary Data

Time Series Data for Data Analysts

Cross-sectional and Longitudinal Data

Spatial data or GIS Data

Multidimensional Data and its importance for Data Analysts

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

Next ZooM Meeting Details and Time

Zoom Meeting of enrolled students 30.06.2024

MS Excel (Part-1)

Introduction and Basics of MS Excel

Task and Assignment

How to submit the task and Assignment

MS Excel (Part-2)

Master Microsoft Excel for Data Analysis in 10 steps

Auto Fitting Rows and Columns in Microsoft Excel

Pasting and Formatting Dates in Excel

Data Tables in Excel

Serial Numbers in Excel

Add current date and time in Microsoft Excel

Hyperlinks in Microsoft Excel

Dynamic Interactive chart in Microsoft Excel

Mean, standard Deviation and Standard Error Calculation in MS EXCEL

Descriptive Statistics in MS Excel |Hindi/Urdu

Percent Calculation in MS Excel

Correlation and Linear Regression in MS Excel

IQR (Interquartile range) in Microsoft Excel

CV (Coefficient of Variation) in Microsoft Excel

t-test in Microsoft Excel

MS Excel (Part-3)

Introduction to MS EXCEL

Excel Basics Knowledge

Change alphabets in upper & lower case in excel

Add rows and columns in excel

Select entire row & entire column in excel

Group & ungroup data in excel

Delete blank rows in excel

Convert numbers into words using excel

Combine Data in one column using excel

Add date in excel

Calculate age in excel