📊 Excel Beginner Roadmap 🚀

📂 Start Here
∟📂 What is Microsoft Excel & Why Use It?
∟📂 Understanding Excel Interface (Rows, Columns, Cells, Ribbon)

📂 Excel Basics
∟📂 Entering & Formatting Data
∟📂 Basic Formulas (SUM, AVERAGE, COUNT)
∟📂 Cell References (Relative, Absolute, Mixed)

📂 Important Functions
∟📂 Logical Functions (IF, AND, OR)
∟📂 Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
∟📂 Text Functions (LEFT, RIGHT, MID, LEN, CONCAT)

📂 Data Handling
∟📂 Sorting & Filtering Data
∟📂 Remove Duplicates
∟📂 Data Validation

📂 Data Analysis Tools
∟📂 Conditional Formatting
∟📂 Pivot Tables
∟📂 Pivot Charts

📂 Charts & Visualization
∟📂 Column, Line, Pie Charts
∟📂 Creating Dashboards in Excel
∟📂 Formatting Charts for Insights

📂 Advanced Excel
∟📂 INDEX & MATCH
∟📂 Nested IF Statements
∟📂 Introduction to Macros

📂 Excel for Data Analysis
∟📂 Cleaning Data
∟📂 Using Excel Tables
∟📂 Basic Data Analysis Techniques

📂 Practice Projects
∟📌 Sales Data Dashboard
∟📌 Employee Attendance Tracker
∟📌 Personal Budget Tracker

📂 ✅ Move to Next Level
∟📂 Power Query Basics
∟📂 Power Pivot & Data Model
∟📂 Automating Tasks with VBA

React "❤️" for more! 📊🚀

Data Analyst INTERVIEW QUESTIONS AND ANSWERS
👇👇

1.Can you name the wildcards in Excel?

Ans: There are 3 wildcards in Excel that can ve used in formulas.

Asterisk (*) – 0 or more characters. For example, Ex* could mean Excel, Extra, Expertise, etc.

Question mark (?) – Represents any 1 character. For example, R?ain may mean Rain or Ruin.

Tilde (~) – Used to identify a wildcard character (~, *, ?). For example, If you need to find the exact phrase India* in a list. If you use India* as the search string, you may get any word with India at the beginning followed by different characters (such as Indian, Indiana). If you have to look for India” exclusively, use ~.

Hence, the search string will be india~*. ~ is used to ensure that the spreadsheet reads the following character as is, and not as a wildcard.


2.What is cascading filter in tableau?

Ans: Cascading filters can also be understood as giving preference to a particular filter and then applying other filters on previously filtered data source. Right-click on the filter you want to use as a main filter and make sure it is set as all values in dashboard then select the subsequent filter and select only relevant values to cascade the filters. This will improve the performance of the dashboard as you have decreased the time wasted in running all the filters over complete data source.


3.What is the difference between .twb and .twbx extension?

Ans:
A .twb file contains information on all the sheets, dashboards and stories, but it won’t contain any information regarding data source. Whereas .twbx file contains all the sheets, dashboards, stories and also compressed data sources. For saving a .twbx extract needs to be performed on the data source. If we forward .twb file to someone else than they will be able to see the worksheets and dashboards but won’t be able to look into the dataset.


4.What are the various Power BI versions?

Power BI Premium capacity-based license, for example, allows users with a free license to act on content in workspaces with Premium capacity. A user with a free license can only use the Power BI service to connect to data and produce reports and dashboards in My Workspace outside of Premium capacity. They are unable to exchange material or publish it in other workspaces. To process material, a Power BI license with a free or Pro per-user license only uses a shared and restricted capacity. Users with a Power BI Pro license can only work with other Power BI Pro users if the material is stored in that shared capacity. They may consume user-generated information, post material to app workspaces, share dashboards, and subscribe to dashboards and reports. Pro users can share material with users who don’t have a Power BI Pro subscription while workspaces are at Premium capacity.

ENJOY LEARNING 👍👍

Quick Excel Cheatsheet! 📊

Basic Formulas
1. Add: =A1+B1
2. Subtract: =A1-B1
3. Multiply: =A1*B1
4. Divide: =A1/B1
5. Average: =AVERAGE(A1:A10)
6. Sum: =SUM(A1:A10)

Logical Functions
1. IF: =IF(A1>10, "Yes", "No")
2. AND: =AND(A1>5, B1<10)
3. OR: =OR(A1=1, B1=2)
4. EXACT (case-sensitive match): =EXACT(A1, B1)

Lookup Functions
1. VLOOKUP: =VLOOKUP(A1, Table, 2, FALSE)
2. HLOOKUP: =HLOOKUP(A1, Table, 2, FALSE)
3. XLOOKUP: =XLOOKUP(A1, Range1, Range2)

Counting Data Types
1. Count numbers: =COUNT(A1:A10)
2. Count non-empty: =COUNTA(A1:A10)
3. Count blanks: =COUNTBLANK(A1:A10)
4. Is number: =ISNUMBER(A1)
5. Is text: =ISTEXT(A1)

React ❤️ for more

✅ If you're serious about learning Data Analytics — follow this roadmap 📊🧠

1. Learn Excel basics – formulas, pivot tables, charts
2. Master SQL – SELECT, JOIN, GROUP BY, CTEs, window functions
3. Get good at Python – especially Pandas, NumPy, Matplotlib, Seaborn
4. Understand statistics – mean, median, standard deviation, correlation, hypothesis testing
5. Clean and wrangle data – handle missing values, outliers, normalization, encoding
6. Practice Exploratory Data Analysis (EDA) – univariate, bivariate analysis
7. Work on real datasets – sales, customer, finance, healthcare, etc.
8. Use Power BI or Tableau – create dashboards and data stories
9. Learn business metrics KPIs – retention rate, CLV, ROI, conversion rate
10. Build mini-projects – sales dashboard, HR analytics, customer segmentation
11. Understand A/B Testing – setup, analysis, significance
12. Practice SQL + Python combo – extract, clean, visualize, analyze
13. Learn about data pipelines – basic ETL concepts, Airflow, dbt
14. Use version control – Git GitHub for all projects
15. Document your analysis – use Jupyter or Notion to explain insights
16. Practice storytelling with data – explain “so what?” clearly
17. Know how to answer business questions using data
18. Explore cloud tools (optional) – BigQuery, AWS S3, Redshift
19. Solve case studies – product analysis, churn, marketing impact
20. Apply for internships/freelance – gain experience + build resume
21. Post your projects on GitHub or portfolio site
22. Prepare for interviews – SQL, Python, scenario-based questions
23. Keep learning – YouTube, courses, Kaggle, LinkedIn Learning

💡 Tip: Focus on building 3–5 strong projects and learn to explain them in interviews.

💬 Tap ❤️ for more!

Data Analyst Interview Questions

1. What do Tableau's sets and groups mean?

Data is grouped using sets and groups according to predefined criteria. The primary distinction between the two is that although a set can have only two options—either in or out—a group can divide the dataset into several groups. A user should decide which group or sets to apply based on the conditions.

2.What in Excel is a macro?

An Excel macro is an algorithm or a group of steps that helps automate an operation by capturing and replaying the steps needed to finish it. Once the steps have been saved, you may construct a Macro that the user can alter and replay as often as they like.

Macro is excellent for routine work because it also gets rid of mistakes. Consider the scenario when an account manager needs to share reports about staff members who owe the company money. If so, it can be automated by utilising a macro and making small adjustments each month as necessary.


3.Gantt chart in Tableau

A Tableau Gantt chart illustrates the duration of events as well as the progression of value across the period. Along with the time axis, it has bars. The Gantt chart is primarily used as a project management tool, with each bar representing a project job.

4.In Microsoft Excel, how do you create a drop-down list?

Start by selecting the Data tab from the ribbon.
Select Data Validation from the Data Tools group.
Go to Settings > Allow > List next.
Choose the source you want to offer in the form of a list array.

How to Crack a Data Analyst Job Faster

1️⃣ Fix Your Resume
- One page, clean layout, show impact (not tools)
- Example: Improved sales reporting accuracy by 18% using SQL & Power BI
- Add links: GitHub, Portfolio, LinkedIn

2️⃣ Prepare Smart for Interviews
- SQL: joins, window functions, CTEs (daily practice)
- Excel: case questions (pivots, formulas)
- Power BI/Tableau: explain one dashboard end-to-end
- Python: pandas (groupby, merge, missing values)

3️⃣ Master Business Thinking
- Ask why the data exists
- Translate numbers into decisions
- Example: High month-2 churn → poor onboarding

4️⃣ Build a Strong Portfolio
- 3 solid projects > 10 weak ones
- Projects:
- Customer churn analysis
- Sales performance dashboard
- Marketing funnel analysis

5️⃣ Apply With Strategy
- Apply to 5-10 roles daily
- Customize resume keywords
- Reach out to hiring managers (referrals = 3x interviews)

6️⃣ Track Progress
- Maintain interview log
- Fix gaps weekly

🎯 Skills get you shortlisted. Thinking gets you hired.

Data Analyst Interview Preparation Roadmap ✅

Technical skills to revise

- SQL
Write queries from scratch.
Practice joins, group by, subqueries.
Handle duplicates and NULLs.
Window functions basics.

- Excel
Pivot tables without help.
XLOOKUP and IF confidently.
Data cleaning steps.

- Power BI or Tableau
Explain data model.
Write basic DAX.
Explain one dashboard end to end.

- Statistics
Mean vs median.
Standard deviation meaning.
Correlation vs causation.

- Python. If required
Pandas basics.
Groupby and filtering.

Interview question types

- SQL questions
Top N per group.
Running totals.
Duplicate records.
Date based queries.

- Business case questions
Why did sales drop.
Which metric matters most and why.

- Dashboard questions
Explain one KPI.
How users will use this report.

- Project questions
Data source.
Cleaning logic.
Key insight.
Business action.

Resume preparation
- Must have Tools section.
- One strong project.
- Metrics driven points.
Example: Improved reporting time by 30 percent using Power BI.

Mock interviews
- Practice explaining out loud.
- Time your answers.
- Use real datasets.

Daily prep plan
1 SQL problem.
1 dashboard review.
10 interview questions.

- Common mistakes
Memorizing queries.
No project explanation.
Weak business reasoning.

- Final task
- Prepare one project story.
- Prepare one SQL solution on paper.
- Prepare one business metric explanation.

Double Tap ♥️ For More

register now 🔥

Junior-level Data Analyst interview questions:

Introduction and Background

1. Can you tell me about your background and how you became interested in data analysis?
2. What do you know about our company/organization?
3. Why do you want to work as a data analyst?

Data Analysis and Interpretation

1. What is your experience with data analysis tools like Excel, SQL, or Tableau?
2. How would you approach analyzing a large dataset to identify trends and patterns?
3. Can you explain the concept of correlation versus causation?
4. How do you handle missing or incomplete data?
5. Can you walk me through a time when you had to interpret complex data results?

Technical Skills

1. Write a SQL query to extract data from a database.
2. How do you create a pivot table in Excel?
3. Can you explain the difference between a histogram and a box plot?
4. How do you perform data visualization using Tableau or Power BI?
5. Can you write a simple Python or R script to manipulate data?

Statistics and Math

1. What is the difference between mean, median, and mode?
2. Can you explain the concept of standard deviation and variance?
3. How do you calculate probability and confidence intervals?
4. Can you describe a time when you applied statistical concepts to a real-world problem?
5. How do you approach hypothesis testing?

Communication and Storytelling

1. Can you explain a complex data concept to a non-technical person?
2. How do you present data insights to stakeholders?
3. Can you walk me through a time when you had to communicate data results to a team?
4. How do you create effective data visualizations?
5. Can you tell a story using data?

Case Studies and Scenarios

1. You are given a dataset with customer purchase history. How would you analyze it to identify trends?
2. A company wants to increase sales. How would you use data to inform marketing strategies?
3. You notice a discrepancy in sales data. How would you investigate and resolve the issue?
4. Can you describe a time when you had to work with a stakeholder to understand their data needs?
5. How would you prioritize data projects with limited resources?

Behavioral Questions

1. Can you describe a time when you overcame a difficult data analysis challenge?
2. How do you handle tight deadlines and multiple projects?
3. Can you tell me about a project you worked on and your role in it?
4. How do you stay up-to-date with new data tools and technologies?
5. Can you describe a time when you received feedback on your data analysis work?

Final Questions

1. Do you have any questions about the company or role?
2. What do you think sets you apart from other candidates?
3. Can you summarize your experience and qualifications?
4. What are your long-term career goals?

Hope this helps you 😊

Keyboard Shortcut Keys

Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl W - Close
Ctrl+X - Cut
Ctrl+Y - Repeat
Ctrl+Z - Undo
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat last action
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F10 - Activate Menu bar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional functions in Excel’s menu
Shift+F1 - What’s This?
Shift+F2 - Edit cell comment
Shift+F3 - Paste function into formula
Shift+F4 - Find Next
Shift+F5 - Find
Shift+F6 - Previous Pane
Shift+F8 - Add to selection
Shift+F9 - Calculate active worksheet
Shift+F10 - Display shortcut menu
Shift+F11 - New worksheet
Ctrl+F3 - Define name
Ctrl+F4 - Close
Ctrl+F5 - XL, Restore window size
Ctrl+F6 - Next workbook window
Shift+Ctrl+F6 - Previous workbook window
Ctrl+F7 - Move window
Ctrl+F8 - Resize window
Ctrl+F9 - Minimize workbook
Ctrl+F10 - Maximize or restore window
Ctrl+F11 - Inset 4.0 Macro sheet
Ctrl+F1 - File Open
Alt+F1 - Insert Chart
Alt+F2 - Save As
Alt+F4 - Exit
Alt+Down arrow - Display AutoComplete list
Alt+’ - Format Style dialog box
Ctrl+Shift+~ - General format
Ctrl+Shift+! - Comma format
Ctrl+Shift+@ - Time format
Ctrl+Shift+# - Date format
Ctrl+Shift+$ - Currency format
Ctrl+Shift+% - Percent format
Ctrl+Shift+^ - Exponential format
Ctrl+Shift+& - Place outline border around selected cells
Ctrl+Shift+_ - Remove outline border
Ctrl+Shift+* - Select current region
Ctrl++ - Insert
Ctrl+- - Delete
Ctrl+1 - Format cells dialog box
Ctrl+2 - Bold
Ctrl+3 - Italic
Ctrl+4 - Underline
Ctrl+5 - Strikethrough
Ctrl+6 - Show/Hide objects
Ctrl+7 - Show/Hide Standard toolbar
Ctrl+8 - Toggle Outline symbols
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl+Shift+( - Unhide rows
Ctrl+Shift+) - Unhide columns
Alt or F10 - Activate the menu
Ctrl+Tab - In toolbar: next toolbar
Shift+Ctrl+Tab - In toolbar: previous toolbar
Ctrl+Tab - In a workbook: activate next workbook
Shift+Ctrl+Tab - In a workbook: activate previous workbook
Tab - Next tool
Shift+Tab - Previous tool
Enter - Do the command
Shift+Ctrl+F - Font Drop down List
Shift+Ctrl+F+F - Font tab of Format Cell Dialog box
Shift+Ctrl+P - Point size Drop down List
Ctrl + E - Align center
Ctrl + J - justify
Ctrl + L - align 
Ctrl + R - align right
Alt + Tab - switch applications
Windows + P - Project screen
Windows + E - open file explorer
Windows + D - go to desktop
Windows + M - minimize all windows
Windows + S - search

𝚃𝚘𝚙 𝙴𝚡𝚌𝚎𝚕 𝙵𝚘𝚛𝚖𝚞𝚕𝚊𝚜 𝙴𝚟𝚎𝚛𝚢 𝙳𝚊𝚝𝚊 𝙰𝚗𝚊𝚕𝚢𝚜𝚝 𝚂𝚑𝚘𝚞𝚕𝚍 𝙺𝚗𝚘𝚠

𝚂𝚄𝙼():

𝙿𝚞𝚛𝚙𝚘𝚜𝚎: 𝙰𝚍𝚍𝚜 𝚞𝚙 𝚊 𝚛𝚊𝚗𝚐𝚎 𝚘𝚏 𝚗𝚞𝚖𝚋𝚎𝚛𝚜.

𝙴𝚡𝚊𝚖𝚙𝚕𝚎: =𝚂𝚄𝙼(𝐴1:𝐴10)


𝙰𝚅𝙴𝚁𝙰𝙶𝙴():

𝙿𝚞𝚛𝚙𝚘𝚜𝚎: 𝙲𝚊𝚕𝚌𝚞𝚕𝚊𝚝𝚎𝚜 𝚝𝚑𝚎 𝚊𝚌𝐯𝐞𝐫𝐢𝐧𝐠 𝗼𝗳 𝗮 𝗿𝗮𝗻𝗴𝗲 𝗼𝗳 𝗻𝗨𝗺𝗯𝗲𝗿𝗦.

💡 Example: =𝐴𝐵𝐸𝐑𝐴𝐺𝐸(𝐵1:𝐵10)


𝙲𝙾𝙐𝙽𝚃():

💡 Purpose: Counts the number of cells containing numbers.

💡 Example: =𝐶𝐷𝐵(𝐶1:𝐶10)


𝐼𝐹():

💡 Purpose: Returns one value if a condition is true, and another if false.

💡 Example: =𝐼𝐹(𝐴1 > 10, "Yes", "No")


𝐕𝐋𝐎𝐎𝐊𝐔𝐏():

💡 Purpose: Searches for a value in the first column and returns a value in the same row from another column.

💡 Example: =𝐕𝐋𝐎𝐎𝐊𝐔𝐏(𝐷1, 𝐴1:𝐵10, 2, FALSE)


𝐇𝐋𝐎𝐎𝐊𝐔𝐏():

💡 Purpose: Searches for a value in the first row and returns a value in the same column from another row.

💡 Example: =𝐇𝐋𝐎𝐎𝐊𝐔𝐏("Sales", A1:F5, 3, FALSE)


𝐼𝐍𝐃𝐄𝐗():

💡 Purpose: Returns the value of a cell based on row and column numbers.

💡 Example: =𝐼𝐍𝐃𝐄𝐗(𝐴1:𝐶10, 2, 3)


𝐌𝐀𝐓𝐂𝐇():

💡 Purpose: Searches for a value and returns its position in a range.

💡 Example: =𝐌𝐀𝐓𝐂𝐇("Product B", A1:A10, 0)


𝐂𝐎𝐍𝐂𝐀𝐓𝐄𝐍𝐀𝐓𝐄() or 𝐂𝐎𝐍𝐂𝐀𝐓():

💡 Purpose: Joins multiple text strings into one.

💡 Example: =𝐂𝐎𝐍𝐂𝐀𝐓𝐄𝐍𝐀𝐓𝐄(𝐴1, " ", 𝐵1)


𝗧𝗘𝗫𝗧():

💡 Purpose: Formats numbers or dates as text.

💡 Example: =𝗧𝗘𝗫𝗧(𝗔1, "dd/mm/yyyy")

React ❤️ for more

✅ 8-Week Beginner Roadmap to Master Excel 📊

🗓️ Week 1: Excel Basics
Goal: Get comfortable with the interface and basic operations
Topics: Workbook, worksheets, cells, data entry, basic formulas
Mini Project: Create a personal budget sheet

🗓️ Week 2: Formulas & Functions
Goal: Learn essential calculations
Topics: SUM, AVERAGE, COUNT, MIN, MAX
Mini Project: Calculate expenses and incomes with formulas

🗓️ Week 3: Data Formatting & Cleaning
Goal: Make data readable and clean
Topics: Cell formatting, conditional formatting, removing duplicates, data validation
Mini Project: Format and clean a messy dataset

🗓️ Week 4: Logical Functions & Text Functions
Goal: Use logic and manipulate text
Topics: IF, AND, OR, CONCATENATE, LEFT, RIGHT, LEN
Mini Project: Categorize data and extract information from text

🗓️ Week 5: Data Analysis with PivotTables
Goal: Summarize and analyze data quickly
Topics: Creating PivotTables, slicers, filters
Mini Project: Analyze sales data with PivotTables

🗓️ Week 6: Charts & Visualization
Goal: Create impactful visuals
Topics: Bar, line, pie charts, sparklines
Mini Project: Visualize sales or survey data

🗓️ Week 7: Advanced Functions & Lookup
Goal: Work with complex data retrieval
Topics: VLOOKUP, HLOOKUP, INDEX & MATCH
Mini Project: Combine data from multiple tables

🗓️ Week 8: Automation & Reporting
Goal: Automate tasks and prepare reports
Topics: Macros basics, creating dashboards, printing setups
Mini Project: Build an interactive dashboard reporting key metrics

💡 Tips:
- Practice regularly with real datasets
- Explore Excel templates and online tutorials
- Join Excel forums and challenges

💬 Double Tap ♥️ For More

✅ Most Asked Excel Interview Questions for Data Analysts 📊🔥

🔍 Q1. What is the difference between VLOOKUP and XLOOKUP?
Answer: VLOOKUP → works only left to right, needs column index
XLOOKUP → works in any direction, more flexible, handles errors better

🔍 Q2. Write a formula to find a value using INDEX and MATCH.
Answer: =INDEX(B2:B10, MATCH(E1, A2:A10, 0))
Returns value from column B where A matches E1

🔍 Q3. What is a Pivot Table and when do you use it?
Answer: Used to summarize large datasets (sum, count, average) and analyze patterns quickly without formulas.

🔍 Q4. How do you handle duplicates in Excel?
Answer: Data → Remove Duplicates, Conditional Formatting → Highlight duplicates, or use formula: =COUNTIF(A:A, A2) > 1

🔍 Q5. What is the difference between COUNT, COUNTA, and COUNTIFS?
Answer: COUNT → counts numeric values, COUNTA → counts non-empty cells, COUNTIFS → counts based on multiple conditions

🔍 Q6. How do you create a dynamic dashboard in Excel?
Answer: Use Pivot Tables + Pivot Charts, add slicers for filters, use named ranges or tables, keep layout clean and interactive

🔍 Q7. What is conditional formatting? Give a use case.
Answer: Used to highlight data based on conditions
Example: Highlight sales > target in green

🔍 Q8. How do you handle missing values in Excel?
Answer: Filter blanks, replace using mean/median, use IF or IFERROR, remove rows if needed

🔍 Q9. What is the difference between absolute and relative cell references?
Answer: Relative → changes when dragged (A1), Absolute → fixed ($A$1)

🔍 Q10. How do you find top 5 sales values?
Answer: =LARGE(A2:A100, 1) Change 1 → 5 for top 5, or use Pivot Table + Top N filter

🔍 Q11. What is IFERROR and why is it used?
Answer: Handles errors in formulas, Example: =IFERROR(A1/B1, "Error")

🔍 Q12. What is data validation?
Answer: Restricts user input (dropdowns, limits) to maintain data quality

Double Tap ❤️ For More

📊 Learn Microsoft Excel in 14 Days:

🟢 Day 1 – Excel Interface & Basics
Understand Excel layout, ribbons, cells, rows, columns, and basic navigation.

📝 Day 2 – Data Entry & Formatting
Learn to enter/edit data, use formatting tools (bold, color, borders, alignment).

➕ Day 3 – Basic Formulas
Use SUM(), AVERAGE(), MIN(), MAX(), and simple arithmetic formulas.

🔍 Day 4 – Cell Referencing
Understand relative, absolute, and mixed references using $.

📋 Day 5 – Sorting & Filtering
Sort data (A-Z, Z-A) and apply filters to analyze specific data quickly.

📐 Day 6 – Conditional Formatting
Highlight data using rules (greater than, color scales, data bars).

📊 Day 7 – Charts & Graphs
Create and customize pie, bar, line charts for data visualization.

🔁 Day 8 – Logical Functions
Learn IF(), AND(), OR(), IFERROR() for decision-making in formulas.

📈 Day 9 – Lookup Functions
Use VLOOKUP(), HLOOKUP(), and XLOOKUP() to fetch data from tables.

🧩 Day 10 – Text Functions
Learn CONCAT(), TEXT(), LEFT(), RIGHT(), LEN(), TRIM().

📆 Day 11 – Date & Time Functions
Work with TODAY(), NOW(), DATEDIF(), TEXT() for date/time formatting.

🔐 Day 12 – Data Validation
Restrict data input using drop-downs, number/text rules, and error messages.

📎 Day 13 – Pivot Tables
Summarize large datasets using Pivot Tables for quick insights.

🚀 Day 14 – Final Dashboard Project
Build a simple Excel dashboard using charts, pivot tables & conditional formatting.

❤️ React for more!

✅ 🔤 A–Z of SQL Commands 🗄️💻⚡

A – ALTER
Modify an existing table structure (add/modify/drop columns).

B – BEGIN
Start a transaction block.

C – CREATE
Create database objects like tables, views, indexes.

D – DELETE
Remove records from a table.

E – EXISTS
Check if a subquery returns any rows.

F – FETCH
Retrieve rows from a cursor.

G – GRANT
Give privileges to users.

H – HAVING
Filter aggregated results (used with GROUP BY).

I – INSERT
Add new records into a table.

J – JOIN
Combine rows from two or more tables.

K – KEY (PRIMARY KEY / FOREIGN KEY)
Define constraints for uniqueness and relationships.

L – LIMIT
Restrict number of rows returned (MySQL/PostgreSQL).

M – MERGE
Insert/update data conditionally (mainly in SQL Server/Oracle).

N – NULL
Represents missing or unknown data.

O – ORDER BY
Sort query results.

P – PROCEDURE
Stored program in the database.

Q – QUERY
Request for data (general SQL statement).

R – ROLLBACK
Undo changes in a transaction.

S – SELECT
Retrieve data from tables.

T – TRUNCATE
Remove all records from a table quickly.

U – UPDATE
Modify existing records.

V – VIEW
Virtual table based on a query.

W – WHERE
Filter records based on conditions.

X – XML PATH
Generate XML output (mainly SQL Server).

Y – YEAR()
Extract year from a date.

Z – ZONE (AT TIME ZONE)
Convert datetime to specific time zone.

❤️ Double Tap for More

🔹 DATA ANALYST – INTERVIEW REVISION SHEET

1️⃣ Role Clarity
> “A data analyst collects, cleans, analyzes data, and converts it into insights that help businesses make decisions.”

2️⃣ SQL (Most Important)
Must-know clauses:
• SELECT, WHERE, ORDER BY, LIMIT
• GROUP BY, HAVING
• JOINS (INNER, LEFT)
• Subqueries, CTEs
• Window functions (ROW_NUMBER, RANK)
Golden rules:
• WHERE → before aggregation
• HAVING → after aggregation
• LEFT JOIN → keeps all left table rows
• NULLs break calculations → use COALESCE
Classic questions:
• Top N per group
• Find duplicates
• Running totals

3️⃣ Excel Essentials
Formulas:
• IF, XLOOKUP
• COUNTIFS, SUMIFS
• TRIM, LEFT, RIGHT
Core features:
• Pivot tables
• Conditional formatting
• Data validation (dropdowns)
Avoid:
• Merged cells
• Hard-coded values

4️⃣ Power BI / Tableau
Concepts:
• Data model (star schema)
• Relationships (one-to-many)
• Measures > calculated columns
Must-know DAX:
• Total Sales = SUM(Sales[Amount])
• YTD Sales = TOTALYTD(SUM(Sales[Amount]), Sales[Date])
Design rules:
• KPIs on top
• One story per dashboard
• Minimal visuals

5️⃣ Statistics (Only What Matters)
• Mean vs Median
• Standard deviation
• Correlation ≠ causation
• Outliers distort averages
• Use median for Salaries, House prices

6️⃣ Data Cleaning (Interview Gold)
Steps you should say:
1. Remove duplicates
2. Handle missing values
3. Fix data types
4. Standardize text

7️⃣ Business Metrics
• Revenue
• Growth rate
• Conversion rate
• Churn
• Retention
• Average order value
Always connect metrics to business impact.

8️⃣ Case Question Framework (Very Important)
Always answer like this:
1. What happened
2. Why it happened
3. What should be done
Example:
> “Sales dropped due to lower traffic in one region, so I’d recommend increasing marketing spend there.”

9️⃣ Project Explanation Template
> “The goal was . I used to clean data, to analyze, and to visualize. The key insight was . The business impact was .”
Memorize this.

🔟 HR Power Answers
Why data analyst?
> “I enjoy finding patterns in data and turning them into actionable insights.”
Strength:
“I combine technical skills with business understanding.”
Weakness:
“I used to over-analyze, but now I focus on impact.”

🧠 Last-Day Interview Tips
• Think out loud
• Ask clarifying questions
• Don’t jump to tools immediately
• Focus on impact, not syntax

💬 Tap ❤️ for more!