Special Offer and Next Steps - Codanics

Course Content

Introduction (Day-1)

0/1

What will you learn and Registration Process

How to enroll in this course?

0/1

Enrolment Process

Important Information (only for enrolled students)

0/1

Important Announcements for Enrolled Students

Zoom Meeting – 1

0/4

Where can you get everything about this course?

Microsoft Excel and Installation (Course Plan)

Data is Everywhere

Complete Course Plan

Special Offer

0/1

Special Offer and Next Steps

Data is Everywhere

0/1

Data is Everywhere and Data Analyst Demand is Increasing

Data Analyst Jobs and Profiles

0/3

Data Analyst Job Roles and Profile

Important Skills, tools and Qualifications to be a Data Analyst

Data Analysts Roles in Railways

Scales/Levels of Measurements

0/2

Nominal vs. Ordinal Scales (Categorical Data)

Interval vs. Ratio Scales (Numerical Data)

Data Collection

0/2

Data Collection Methods

Data Collection Measurement Errors

Data Types

0/1

Primary Data vs. Secondary Data

How to ask Questions in this course?

0/1

Discord Server for this course

Data Types in Detail

0/9

Primary vs. Secondary Data

Qualitative vs. Quantitative Data | Discreet and Continuous Numeric Data

Categorical Data | Nominal and Ordinal Data Types

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

MS Excel (Part-1)

0/3

Introduction and Basics of MS Excel

Task and Assignment

How to submit the task and Assignment

MS Excel (Part-2)

0/15

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)

0/68

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

Calculation with Dates

Compare data in Excel

Change date format in excel

Calculate time difference in excel

DAX in MS Excel

Checkbox in MS Excel

Insert Excel in PPT

Insert image in excel

Insert PPT/PDF in excel

Convert PDF to Excel

Insert tickmarks in MS Excel

Insert watermark in excel

Set cell size in excel

Create barcodes in excel

Excel flash Fill

Add hyperlink in excel

Round off formula in excel

Calculate standard deviation in excel

Sort by date in excel

Sort data set in Excel

Slicers and Filters in Excel

Add filters in Excel

Goal Seek in Excel

Add drop down list in Excel

Data Validation in Excel

Lock (Protect) cells in MS Excel

Excel print page setup

Conditional Formatting in Excel

Remove duplicates in excel

Calculate percentage in excel

Autofill in Excel

Highlight duplicates in excel

Charts In excel

Progress tracker in Excel

Gantt Chart in Excel

Mail Merge in Excel

vLookup Function (A complete Basic Guide)

Vstack Function In Excel

Indirect Function in Excel

Web query in Excel

User form in Excel

Recover unsaved files in excel

Project planning and Gantt chart in Excel

MIS (Management Information System) Reports in Excel

Time series analysis (Complete Basic Guide)

Dashboard in Excel (Part-1)

Power Query in Excel

Dashboard in Excel (Part-2)

Shortcut Keys in MS Excel

Logical Test in MS Excel

IF Function in MS Excel

NESTED IF Function in MS Excel

NOT Function & IF ERROR Function in MS Excel

AND Function in MS Excel

Auditing Tools in MS Excel

Maths & Trigonometric Functions in MS Excel

What we have learned so far?

0/1

Master MS Excel

Advance Excel Tips

0/2

Questions and Answers about lectures

Advances tips in MS Excel about functions and formula

Excel Tips for Formula Sheet

0/2

MS Excel Tips in Formula Basics to Intermediate

MS Excel Tips Joining Text and Numbers

Lecture Day 21 07 2024

0/3

Mastering Excel’s Data Analysis ToolPak: Essential Skills for Data Analysts

Question Answer Session 21 07 2024

Statistics for Data Analysis (Part-1)

0/13

Introduction to Statistics

But what is statistics?

Content of the course

Why Statistics is Important for Data Scientists/Analysts?

Scales/Levels of Measurement in statistics

Qualitative vs. quantitative Data

Discrete vs. Continuous vs. Binary Data types

Time Series Data

Categorical vs. Ordinal Categorical Data

Multivariate Data

Structured vs. Unstructured Data

Boolean Data type or Binary Data

Statistics for Data Analysis (Part-2)

0/9

Operationalization and proxy measurements

Surrogate Endpoints in statistics

True and Error Score

Types of Errors in Data Collection

Type-I and Type-II errors

Reliability and validity

Measurement and Data Bias

How to remove bias?

Statistics for Data Analysis (Part-3)

0/4

Types of Statistics or Statistical Analysis

Why is statistics important to learn?

Data Analysis and Types of Data Analysis

Central Tendency: Mean, Median, and Mode

Zoom Meeting about Discord server and recordings

0/2

Zoom Meeting Recoding 28 July 2024

Discord Server Community Link for Codanics Community

Statistics for Data Analysis (Part-4)

0/15

Central Tendency of the Data Complete Guide

Mean in statistics (ignore Python Part)

Hormonic Mean understanding of the formula

Limitations of using mean in statistics

Median in statistics (Ignore Python part in the lecture)

Mode in Statistics (Ignore Python Part in the lecture)

Population vs. sample and their means

Variability | Dispersion | Spread of the Data

Range of the Data

Interquartile range (IQR) of the data (ignore Python code)

Variance of the data (Ignore Python Code)

Standard Deviation and Standard Error in statistics (ignore python code)

Normal distribution and Standard Deviation

Data Distributions and types of data distributions (Ignore python code)

Skewness and Kurtosis (ignore Python Code)

Statistics for Data Analysis (Part-5)

0/11

Primary vs. Secondary | Data

Data Collection in the age of big data

Best Practices for Data Collection

Representative and Non-representative sample types

Details of each Sampling Techniques for Data Collection

Hybrid sampling methods

Descriptive Statistics for Data Analysts

Exploratory Data Analysis (EDA) and Statistics

How to choose the right statistical method?

Exploratory Data Analysis (EDA) and the Four Pillars of statistics

Dependent vs. independent variables

Statistics for Data Analysis (Part-6)

0/4

Inferential Statistics

Hypothesis Testing

Confidence Interval in statistics

More tests coming soon….

Zoom Meeting

0/2

Recording of Zoom Meeting

Assignment and Questions 04 08 2024

Excel Add-ins

0/2

MS Excel Import Add-ins for Data Analysts

Assignment for Students (09.08.2024)

MS Excel Advance Tips

0/4

MS Excel Night to Practice MS Excel (Univariate, Bivariate and Multivariate Analysis)

Data Scrapping | Paris Summer Olympics 2024 Medal Data Scrapping using MS Excel

Power Query in MS Excel in 30 Minutes

Dependent Dropdown Lists in Excel (Using INDEX, MATCH, OFFSET, CHOOSE & INDIRECT Functions)

Important Announcement | Power BI Lectures

0/1

Power BI Lecture will follow | Announcement for Data Analyst Summer Bootcamp

Power BI (Part-1)

0/10

Introduction to Data Visualization

Power BI vs. Tableau vs. Python?

Top 11 benefits of using Power BI

Install Power BI Desktop

Update Power BI features and Updates

Learning Resources for Power BI

Business Intelligence with Power BI

Seven Steps Workflow to use Power BI

Power BI interface and Features

Connect Data in Power BI

Power BI (Part-2)

0/13

Data used in Power BI

Data Visualization and Plotting in Power BI

Column/Bar charts in Power BI

Create a bar plot like a professional

Pro tips to make a stunning plot in Power BI

Pie Chart in power BI

Donut Chart in Power BI

TreeMap in Power BI

Line Charts in Power BI

Save Power BI plots as report PDF

Funnel Chart in Power BI

Change colors of a Funnel chart in power BI

Include Exclude Options in Power BI

Zoom Meeting for data wrangling

0/1

Data Wrangling using MS Excel for Titanic Dataset

Power BI (Part-3)

0/13

View data and export as CSV file

Slicer and Filter

Add Tables in Dash Board as Visuals

Matrix in Power BI Desktop

Key Performance Indicators KPI

Waterfall chart

AI in Power BI Desktop for Data Interpretation

Geo Maps in Power BI Desktop

Filled GEO Maps in Power BI Desktop

Pie Charts in GEO Maps and Maps formatting

How to create Map of Pakistan in Power BI?

Complete Project | Professional Dashboard for Sales Analysis in Power BI Desktop

Tableau Complete Course

0/1

Tableau for Beginners | Complete Course

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

0/5

DAX (Data Analysis Expression) in Power BI and MS Excel

Pre-requisites to Learn DAX in Power BI

DAX (Data Analysis Expression) syntax and expression writing

Basic use of DAX Expressions in Power BI

Power BI DAX project A-Z on titanic Dataset

Zoom Meeting with students for questions

0/3

Questions by Students in Zoom Meeting

Assignment Important before next session

Next Plan for the Data Analyst Bootcamp

SQL Complete Course

0/17

Introduction to SQL

Install MySQL on Windows 10

Create a MySQL Database for Beginners

create/modify tables in mySQL

DISTINCT function in mySQL

Constraints in mySQL

Auto increment in mySQL

mySQL workbench first look and interface

Import mySQL database in mySQL workbench

Pandas processing on mySQL database

SELECT clause in mySQL

Data Manipulation in mySQL

WHERE clause and comparison operators

AND OR NOT and IN | my SQL

BETWEEN clause in mySQL

mySQL in vscode and work with github co-pilot

Python for Data Analytics

0/94

Installation of Python + VsCode + miniconda + Git

VScode and Miniconda use for Python for Data Analysts

GitBash and miniconda | Integration | Solutions

Python is popular for a reason

Important Logins and websites

GitHub student or teacher developer pack

Rules for Naming files and folders in Python

.ipynb vs. .py files

What are python Notebooks? .ipynb | jupyter Notebooks

Learn MarkDown in 72 minutes

Variable in Python

Types of Variables in Python

Type casting in Python (1/2)

Type Casting in Python (2/2)

Commenting in Python is important

git bash in vscode and conda in gitbash

screencasting mode in VScode to show Keyboard

Debugging is an art you need to learn

Google have all solutions

Blackbox and codeium |Alternatives to GitHub copilots for VScode

Windows screenshots and Screen Recording tool free

Use of Variables in Python

Data Structures in Python | Complete Guide

Nobel prize in AI and Machine Learning

Sequences in Python programming

Indexing in python programming

Slicing in Python programming

Mutable elements in Python

Range Function in Python

Control Flow Statements in Python

If else and elif control flow statements in python

operators | Conditional and relational | nested if statements

for and while loops in python with examples and code

break, continue and pass statements

Infinite loop in python | Beware of infinite loops

Try, Except and finally statements in python

Convert notebook to pdf | step by step guide with error handling (uncut version)

Functions in Python

Lambda function

user input in python

gitbash and conda in vscode

9 Methods to use print function in Python

Generators in Python

Introduction to Libraries in Python

PyPI , pip and famous libraries in python

Step-by-Step Installation of libraries in conda environments

Top five libraries of Python for Data Analysts

Seventeen important python libraries, I bet you did not know before

Newsletters to access latest AI News

Using python libraries as professionals

Importing and Saving Data in python

Nine-step guide for Data Analysts and Data Scientists

Four dimensions of Data Handling and EDA for Data Scientists and Analysts

pandas profiling or y-data profiling for automatic EDA in python

python library for automatic exploratory data analysis for any data

Make stunning plots for EDA like tableau for free in python

Sweetviz library for EDA | complete debugging uncut

Skimpy library, dealing with errors and installations

Skimpy error resolved

lida for automatic EDA using LLM

Low code EDA library for python | dataprep | A-Z master guide

Lida python library for Automatic EDA using LLMs

Free AI Models available for LLM tasks, we will see in future

Account to make which are important for all

Pandas Dataframes vs. datasets

Reading Data for python using pandas library from clipboard

Reading data from Excel using pandas library in python

Reading csv and tsv files in python using pandas library

Making dummy datasets in python using pandas library from dictionary

Writing data into files using pandas library in python

Data Import in Pandas using Excel workbook with specific paths

.xlsx vs. csv files

Using absolute paths in windows for data import in pandas or python

Do not use spaces in reading files in pandas but what if?

Web scrapping using pandas library in python for table import

Read online .csv files using pandas python library

Read tabular data in pandas

Read data from json file in pandas python

Elements of Pandas data frames in python | series | df

Subset or filter the data based on rows or columns

Important methods for selecting subset of the dataframes in pandas python

Selecting known data or unknown data from dataframes in pandas python

Absolute vs. relative paths

loc and iloc functions for data selection in pandas python library

EDA in pandas python library | A complete case study (Project A-Z)

Financial Data Handling with thousand separators in Pandas

Statistics for Data Science Complete Crash course for beginners

Mathematics for Data Science and Machine Learning

Numpy for Data Science

50 plus commands for NumPy for Data Science and Machine Learning

Quiz-Python for Data Science

Quiz-Mathematics for Data Science

Data Visualization introduction

Data Visualization in python | Important Terminologies

Data Analyst Summer Bootcamp 2024

Join the conversation

Umar Mehmood 1 year ago

Thank You Sir

Reply

0% Complete