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