Useful Link

Telegram Link- https://t.me/+XTjv6r80eDc5ZWU1

Practice Workbook - 100 Days Challenge https://docs.google.com/spreadsheets/d/1eP8evU2JIsawAVJ7GH_NNd_2xNLOT7abpJTs5O9iUQI/edit#gid=775777503

Roadmap to Become a Data Analyst https://topmate.io/mazher_khan/907723

Follow on Linkedin https://www.linkedin.com/in/mazher-khan/

Follow on Instagram https://www.instagram.com/khan.the.analyst

Book 1:1 Mentorship Plan - 1,3, 6 Months https://www.preplaced.in/profile/mazher-khan

Book for Career Guidance, CV review & interview tip https://topmate.io/mazher_khan

Follow on Youtube https://youtube.com/@imzhr.?si=KdMGmWt-vTy12hxV

About Me:

I am Mazher Khan. I am an IIT graduate & have 6 years of experience in Data Science & Analytics.
I have an end-to-end understanding of this field. What you should prepare for, how you should prepare, etc., to become an Analyst.
I have appeared in 90+ job interviews, landed 25+ job offers from companies like Amazon, Zomato, Paytm, Target, OLX, etc.
I have experience of 2+ years in mentorship and taking interviews. I have been Top-rated in the Data Category by "Top Mate" and rated 5/5.
I give 1:1 mentorships session on Preplaced. Rated 5/5.

To aspiring Data Analysts, Business Analysts, and Product Analysts - whether you're a fresher or a seasoned professional:

Thank you for your trust and support. This IG account serves the following purposes:

1 Helping you become skilled Data Analysts. I've curated a 100-day learning challenge to provide daily content and resources guiding you through the journey.
Invest your time in completing these learning challenges to gain valuable skills. I've started with Excel, then onto SQL, LeetCode SQL questions, PYTHON, Tableau/Power BI, Product Analytics, Behavior, How to apply, where to apply, etc. - so it's a complete 100-day journey.
2 Sharing resources about job preparation, interviews, any recent hirings, etc. Since one can't access the direct resources, follow me on Telegram where I will be sharing the resources.
3 Sharing Job & internship Opportunities time to time
4 Sharing my personal experiences or tips with you, which are critical and you may not know related to your job search, interview experience, and CV and Linkedin Optimization etc
5 Drop your CV to mazherkhan1803@gmail.com. I will rate your CV out of 10 and highlight the issues. However, be informed that this will be added to your IG stories so that others could take note of it. (Your personal info will be hidden)
6 Addressing your queries. As job seekers, you likely have numerous questions. I'm here to patiently answer them one by one, ensuring you have the guidance you need to succeed.
Keep reaching out on IG, and I'll continue to provide assistance. I have responded to most of the people and will be to the remaining ones.

Expectations from You:

1 Engage with Content and Use it. By engage, I mean, save it for later and share your questions with respective reels to me. Practice daily and make notes out of it.
2 If you are looking for 1:1 Direct Mentorship, then you can enroll in a 1, 3, 6 months program. DM me to know how you can book or refer to the Preplaced link in BIO.
3 If you are looking for a quick session, about your CV review, mock interview, tips and tricks, or 1:1 session about how to make a career in Data Analytics etc. DM me to know how or refer to the TopMate Link in BIO.
4 Ask the right questions. Think logically and critically.
5 Follow me on Telegram for resources and detailed discussions. (Link in Description)
6 Follow me on LinkedIn for more tips. (Link in Description)
7 Subscribe to the Youtube Channel (Link in Description). Currently, the channel has vlogs but going forward will be sharing Data Science & Analytics related videos covering different topics.
8 Share your feedback with me. If I am missing any topics that you want me to cover.
Dy

Day 1 of Learning Data Analytics SQL Leetcode Questions for Data/Business Analys

1. What Is Data Analytics? - An Introduction (Full Guide) https://topmate.io/mazher_khan/910822

https://www.youtube.com/watch?v=yZvFH7B6gKI

2. Data Analyst Roles and Responsibilities

https://www.youtube.com/watch?v=Bfqu75obvyg

3. Difference between Data Analyst, Data Scientist & Business Analyst

https://www.boardinfinity.com/blog/difference-between-data-analyst-data-scientist-business-analyst/

4. A Day in the Life of a Data Analyst

https://www.youtube.com/watch?v=uSTtLpstV-o

5. Data Analytics vs Data Science

https://www.youtube.com/watch?v=dcXqhMqhZUo

6. Data Analyst vs Data Scientist | Responsibilities, Salaries, Skills, Education

https://www.youtube.com/watch?v=bxIF9X9k2IE

Day 2 of Learning Data Analytics

1. Microsoft Excel Tutorial for Beginners - Full Course

https://www.youtube.com/watch?v=Vl0H-qTclOg&t=3s

2. The Beginner's Guide to Excel - Excel Basics Tutorial

https://www.youtube.com/watch?v=rwbho0CgEAE

Day 3 of Learning Data Analytics

1. Understanding Different Types of Data

https://www.youtube.com/watch?v=Cj-ICe_4Giw

2. Data Validation

https://www.youtube.com/watch?v=nMxl1_NAcxc

https://www.youtube.com/watch?v=SlWIgMFpsPg

3. Converting Data Types:

https://www.youtube.com/watch?v=XFTIPoaofvo

https://www.youtube.com/watch?v=3mkaWR-tH-I

https://www.youtube.com/watch?v=sVrtkxjfDkc

https://www.youtube.com/watch?v=_uM4n6ad3x0

Day 4 of Learning Data Analytics

1. Importing Data from External Sources

https://www.youtube.com/watch?v=yWA6If6CvcM

2. Data Connection between Excel Workbooks

https://www.youtube.com/watch?v=ze7c96Lkrww

3. Excel to Connect to SQL Server Data

https://www.youtube.com/watch?v=UzfYbWZr6ro

4. Practice Hands-on Examples

Day 5 of Learning Data Analytics

1 Excel Formulas and Functions Tutorial

 https://www.youtube.com/watch?v=Jl0Qk63z2ZY

2 MS Excel - Cell Reference

https://www.youtube.com/watch?v=LFIykJmL4M8

4 Using Relative References in Named Ranges

https://www.youtube.com/watch?v=7YMrHw1pa10

4 Excel Sorting and Filtering Data

https://www.youtube.com/watch?v=O28-xL5YGkE

5 Excel Tables Overview

https://www.youtube.com/watch?v=d4yrHvcyesY

6 How to Enter Named Ranges in formulas in Excel

https://www.youtube.com/watch?v=3BXivKqAdkY

7 Excel Charts and Graphs Tutorial

https://www.youtube.com/watch?v=eHtZrIb0oWY

8 Creating and Formatting Charts in MS Excel

https://www.youtube.com/watch?v=qyITMiBrmqA

9 Add and Change Chart Titles in Excel 2010

https://www.youtube.com/watch?v=pfzhDdT0VS0

10 Practice Workbook-Excel Link is Available in BIO or Join Telegram (as mentioned below)

https://docs.google.com/spreadsheets/d/1eP8evU2JIsawAVJ7GH_NNd_2xNLOT7abpJTs5O9iUQI/edit#gid=206239532

Day 6 of Learning Data Analytics

1 Excel Formulas and Functions | Full Course

https://www.youtube.com/watch?v=Y8xhrUa3KH4

2 Top 10 Most Important Excel Formulas - Made Easy!

https://www.youtube.com/watch?v=ShBTJrdioLo

3 How to use Power Pivot in Excel | Full Tutorial

https://www.youtube.com/watch?v=rB_IiYbOo7w

4 Ultimate Excel PivotTables Tutorial: Beginner to Advanced - 3.5 Hours!

https://www.youtube.com/watch?v=02-5BsJxqzU&list=PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

5 Conditional Formatting in Excel | Excel Tutorials for Beginners

https://www.youtube.com/watch?v=_eZRkmRfVTM

6 Cleaning Data in Excel | Excel Tutorials for Beginners

https://www.youtube.com/watch?v=_jmiEGZ6PIY

Day 7 of Learning Data Analytics

1 Advanced Pivot Table Techniques (to achieve more in Excel)

https://www.youtube.com/watch?v=yHzT_BUggQk

2 How to Make Pivot Chart in Excel

https://www.youtube.com/watch?v=0WstANBX-Gk

3 Excel Slicers, EVERYTHING You Need to Know - includes workbook with step by step instructions

https://www.youtube.com/watch?v=2H7aOHKZ6PY&t=235s

4 Data Visualization Techniques in Excel

https://www.youtube.com/watch?v=PTVTw2rZ4EM

5 Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5)

https://www.youtube.com/watch?v=I23Cy8FkMLY

6 Excel - Time Series Forecasting - Part 1 of 3

 https://www.youtube.com/watch?v=gHdYEZA50KE

7 Excel Shortcut Keys | Full Guide

https://www.youtube.com/watch?v=T5vSDAX1HjY

Day 8 of Learning Data Analytics

1 Learn What is Database | Types of Database | DBMS

https://www.youtube.com/watch?v=j09EQ-xlh88

3 Introduction to Relational Databases

https://www.youtube.com/watch?v=WI9dE8-TFAc

3 SQL Explained in 100 Seconds

https://www.youtube.com/watch?v=zsjvFFKOm3c

4 Entities, Rows, and Columns - Databases tutorial

https://www.youtube.com/watch?v=f_F_q20a6Cc

5 What is SQL? Future Career Scope & Resources

https://www.youtube.com/watch?v=UOJZTqA5Loc

6 Introduction to Structured Query Language | All Points regarding its Features and Syllabus

https://www.youtube.com/watch?v=323H_mOOWQ4

7 Introduction to SQL | DDL, DML, DQL, DCL, TCL Commands in SQL

https://www.youtube.com/watch?v=U2T_LCdO14Y
1. Basic Excel Functions
Final Results 2. MS Excel - Cell Reference
Add 1 2 3
Subtract 4 2 2 In Microsoft Excel, cell reference is a crucial concept that allows users to refer to specific cells or ranges within a worksheet. It's essentially a way of identifying and locating data within a spreadsheet. There are two main types of cell references: relative and
Multiply 6 2 12
Divide 8 2 4 Relative Cell Reference:
Sum 1 8 9 A relative cell reference is the default type of reference in Excel.
Min 8 8 8 When you use a relative reference in a formula, it adjusts automatically when the formula is copied or moved to another cell.
Max 2 4 4 For example, if you have a formula "=A1+B1" in cell C1, when you copy this formula to cell C2, it will automatically adjust to "=A2+B2".
Count 3 7 2
Counta 10 6 2 Absolute Cell Reference:
Average 4 4 4 An absolute cell reference remains constant, regardless of where the formula containing it is copied or moved.
Median 10 8 9 It's denoted by adding a dollar sign ($) before the column letter and row number. For example, $A$1.
Concatenate 7 10 710 Absolute references are useful when you want a formula to always refer to a specific cell, such as a constant or a total.
If 10 9 Greater For example, if you have a formula "=A1*$B$1" in cell C1, when you copy this formula to cell C2, the reference to cell B1 will remain unchanged.
Countif 2 9 1
Vlookup 4 4 2 Mixed Cell Reference:
SumIF 4 3 30 A mixed cell reference contains both relative and absolute components.
You can fix either the row or the column, or both, while leaving the other part relative.
For example, $A1 is an absolute column reference and a relative row reference. A$1 is a relative column reference and an absolute row reference.
Definitions

Add: The addition function in Excel performs the arithmetic operation of adding two or more numbers together. 3. Excel Sorting and Filtering
Subtract: The subtraction function in Excel performs the arithmetic operation of subtracting one number from another.
Multiply: The multiplication function in Excel performs the arithmetic operation of multiplying two or more numbers together.
Divide: The division function in Excel performs the arithmetic operation of dividing one number by another. Name Salary
Sum: The SUM function in Excel adds up all the numbers in a range of cells. A 134
Min: The MIN function in Excel returns the smallest value from a range of cells. B 138
Max: The MAX function in Excel returns the largest value from a range of cells. C 147
Count: The COUNT function in Excel counts the number of cells in a range that contain numbers. D 166
Counta: The COUNTA function in Excel counts the number of non-empty cells in a range. E 173
Average: The AVERAGE function in Excel calculates the arithmetic mean of a range of cells. F 197
Median: The MEDIAN function in Excel returns the median (middle) value from a range of cells.
Concatenate: The CONCATENATE function in Excel combines multiple text strings into one.
If: The IF function in Excel evaluates a condition and returns one value if the condition is true and another value if the condition is false. Select the Table by Ctrl + A or Command +A
Countif: The COUNTIF function in Excel counts the number of cells in a range that meet a specific condition. Right click the selected table and options left in shown should be visible
Vlookup: The VLOOKUP function in Excel searches for a value in the first column of a table and returns a value in the same row from a specified column. Sort the Data
SumIF: The SUMIF function in Excel adds up the values in a range that meet a specific condition. Filter the data

4. Table in Excel 5. Charts

A table is a structured range of data that has been formatted as a table. Column Chart: Represents data using vertical bars, ideal for comparing values across categories.
Bar Chart: Displays data with horizontal bars, suitable for comparing values when labels are long.
Creating a Table: Line Chart: Connects data points with straight lines, useful for showing trends over time.
Pie Chart: Divides a circle into sectors, showing proportions of a whole or percentages.
Select the range of cells containing your data. Area Chart: Fills area below line, suitable for showing magnitude of change over time.
Go to the "Insert" tab on the Excel ribbon. Scatter Plot: Represents individual data points on a two-dimensional plane, helpful for displaying relationships between variables.
Click on the "Table" button. Bubble Chart: Shows data points with varying bubble sizes, ideal for visualizing three variables.
In the "Create Table" dialog box, verify the selected range and check the box if your table has headers. Histogram: Displays data distribution over intervals, useful for analyzing frequency distributions.
Click "OK." Box Plot: Represents data distribution based on quartiles, helpful for identifying outliers.
Combo Chart: Combines two or more chart types in a single chart, allowing for comparison of different data sets.

To Do - Create a Table based on logic shared and data listed below

Date Sales
Name Salary 01/01/2023 935 To Do - Try out different charts to create
A 191 01/02/2023 573 Click on Inset and the Chart
B 200 01/03/2023 460
A 101 01/04/2023 424
B 170 01/05/2023 466
C 140 01/06/2023 945
C 178 01/06/2023 982