Data Analyst Interview Resources

🚀 Excel Interview Questions with Answers — Part 1 1. What is Microsoft Excel and what is it mainly used for? Microsoft Excel is a spreadsheet application used to store, organize, analyze, and visualize data. It is part of Microsoft 365. Main Uses of Excel: - Data entry and management - Calculations using formulas and functions - Data analysis and reporting - Creating charts and dashboards - Budgeting and financial analysis - Automation using macros and VBA 📌 Example: A data analyst may use Excel to analyze sales data and create monthly KPI dashboards. 2. What is the difference between a workbook and a worksheet? Workbook | Worksheet A workbook is the entire Excel file | A worksheet is a single sheet/tab inside the workbook It can contain multiple worksheets | It contains rows and columns of data Saved as .xlsx, .xls, etc. | Appears as tabs at the bottom 📌 Example: Sales_Report.xlsx = Workbook January Sales = Worksheet inside the workbook 3. What is a cell, row, and column? Cell: Intersection of a row and column Example: B5 Row: Horizontal arrangement of data Rows are numbered: 1, 2, 3... Column: Vertical arrangement of data Columns are labeled: A, B, C... 📌 Example: If “Sales” is written in cell C2, then: - C = Column - 2 = Row - C2 = Cell 4. How do you rename, insert, or delete a worksheet? Rename a Worksheet: - Double-click the sheet tab OR - Right-click → Rename Insert a Worksheet: - Click the + icon beside sheet tabs OR - Press Shift + F11 Delete a Worksheet: - Right-click sheet tab → Delete ⚠️ Important: Deleting a worksheet permanently removes its data unless recovered immediately. 5. How do you select a range, entire row, or entire column? Select a Range: Click and drag across cells Example: A1:D10 Select Entire Row: - Click the row number OR - Shortcut: Shift + Space Select Entire Column: - Click the column letter OR - Shortcut: Ctrl + Space 📌 Useful for formatting, filtering, or applying formulas quickly. 6. How do you copy, paste, and cut data? Action | Shortcut Copy | Ctrl + C Paste | Ctrl + V Cut | Ctrl + X Paste Special: Used when you want to paste: - Values only - Formulas only - Formatting only Shortcut: Ctrl + Alt + V 📌 Example: Copy formulas without changing formatting using “Paste Special → Formulas”. 7. How do you use Zoom, Freeze Panes, and Split Window? Zoom: Used to increase or decrease worksheet view size. - Bottom-right zoom slider OR - View → Zoom Freeze Panes: Keeps headers visible while scrolling. Path: View → Freeze Panes Common options: - Freeze Top Row - Freeze First Column 📌 Example: Freeze headers in large sales reports. Split Window: Splits worksheet into multiple scrollable sections. Path: View → Split Useful when comparing distant parts of the same sheet. 8. How do you hide/unhide rows and columns? Hide: - Select row/column - Right-click → Hide Unhide: - Select surrounding rows/columns - Right-click → Unhide 📌 Example: Hide helper columns containing intermediate calculations. 9. How do you insert/delete rows and columns without breaking formulas? Best Practice: Use Excel insert/delete options instead of manual copy-paste. Insert: Right-click row/column → Insert Delete: Right-click row/column → Delete Why? Excel automatically adjusts formulas and references. 📌 Example: If formula is: =SUM(A1:A5) After inserting a new row inside the range, Excel updates automatically: =SUM(A1:A6) ⚠️ Avoid deleting cells individually unless necessary because it may shift references incorrectly. 10. How do you save, open, and share an Excel file (including via OneDrive / Microsoft SharePoint)? Save a File: - Ctrl + S - File → Save As Open a File: - File → Open OR - Double-click the Excel file Share via OneDrive:  1. Save file to OneDrive  2. Click Share  3. Generate link or invite users  Share via Microsoft SharePoint:  - Upload workbook to SharePoint  - Collaborate with multiple users in real time  Double Tap ❤️ For Part-2

𝗪𝗮𝗹𝗺𝗮𝗿𝘁 𝗙𝗥𝗘𝗘 𝗜𝗻𝘁𝗲𝗿𝗻𝘀𝗵𝗶𝗽 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺 | 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄!🚀 Offering a FREE Advanced Software Engineering Job Simulation where you can work on practical tasks, enhance your coding skills, and earn a certificate to strengthen your resume. 🎯 Benefits: ✅ Free Certificate ✅ Real-World Software Engineering Tasks ✅ Self-Paced Learning Don't miss this opportunity to boost your profile and get job-ready for top tech companies! 🔥 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlink.in/4vDJN5W 📢 Share with your friends and classmates.

𝗙𝗥𝗘𝗘 𝗔𝗜 & 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 | 𝟰 𝗕𝗲𝘀𝘁 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 𝗖𝗵𝗮𝗻𝗻𝗲𝗹𝘀 🚀 Learn Artificial Intelligence and Machine Learning for FREE from world-class creators ✔️ 100% Free Learning ✔️ Beginner to Advanced Content ✔️ Real-World Coding Projects ✔️ Learn from AI Experts ✔️ Build a Strong Portfolio ✔️ Stay Updated with the Latest AI Trends 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlinks.in/aiml 🚀Start Learning Today. Build AI Skills. Get Career Ready!

✅ Power BI Project Ideas for Data Analysts 📊💡 Real-world projects help you stand out in job applications and interviews. 1️⃣ Sales Dashboard • Track revenue, profit, and sales by region/product • Add slicers for year, month, category • Source: Sample Superstore dataset 2️⃣ HR Analytics Dashboard • Analyze employee attrition, performance, and satisfaction • KPIs: attrition rate, avg tenure, engagement score • Use Excel or mock HR dataset 3️⃣ E-commerce Analysis • Show total orders, AOV (average order value), top-selling items • Use date filters, category breakdowns • Optional: add customer segmentation 4️⃣ Financial Report • Monthly expenses vs income • Budget variance tracking • Charts for category-wise breakdown 5️⃣ Healthcare Analytics • Hospital admissions, treatment outcomes, patient demographics • Drill-through: see patient-level detail by department • Public health datasets available online 6️⃣ Marketing Campaign Tracker • Click-through rates, conversion rates, campaign ROI • Compare across channels (email, social, paid ads) 🧠 Bonus Tips: • Use DAX to create measures • Add tooltips and slicers • Make the design clean and professional 📌 Practice Task: Choose one topic → Get a dataset → Build a dashboard → Upload screenshots to GitHub Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c 💬 Tap ❤️ for more!

💻 𝗠𝗮𝘀𝘁𝗲𝗿 𝗦𝗤𝗟 𝗙𝗢𝗥 𝗙𝗥𝗘𝗘 | 𝟱 𝗔𝗺𝗮𝘇𝗶𝗻𝗴 𝗪𝗲𝗯𝘀𝗶𝘁𝗲𝘀 𝗧𝗼 𝗟𝗲𝗮𝗿𝗻 𝗦𝗤𝗟 🚀 Want to become a Data Analyst, Data Scientist, or Software Engineer? Start by mastering SQL—one of the most in-demand skills in the tech industry! These 5 FREE websites will help you learn SQL from scratch through interactive lessons, quizzes, and hands-on practice. 𝐋𝐢𝐧𝐤👇:- https://pdlinks.in/qje 🚀 Start Learning SQL Today and Build a Strong Foundation for Your Tech Career!

🚀 𝗡𝗩𝗜𝗗𝗜𝗔 𝗙𝗥𝗘𝗘 𝗔𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 | 𝗟𝗲𝗮𝗿𝗻 𝗙𝗿𝗼𝗺 𝗔𝗜 𝗜𝗻𝗱𝘂𝘀𝘁𝗿𝘆 𝗟𝗲𝗮𝗱𝗲𝗿𝘀 Want to build cutting-edge *AI skills* from one of the world's leading AI and GPU companies? *NVIDIA* offers *FREE AI Certification Courses* to help students, freshers, developers, and professionals 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlinks.in/nvdia 🚀 Start Learning Today. Earn Your Certificate. Build Your Future in AI!

✅ Useful Resources to Learn Power BI 📊⚡ 1. YouTube Channels • Guy in a Cube – Best for all Power BI topics • Learn with Pavan Lalwani – Step-by-step tutorials • Simplilearn – Beginner-friendly dashboards 2. Free Courses • Microsoft Learn – Official, hands-on Power BI modules • Udemy (Free/Paid) – Search “Power BI for Beginners” • Coursera – Data Visualization with Power BI (audit mode) 3. Key Skills to Learn • Data loading & transformation (Power Query) • Data modeling (relationships, star schema) • DAX formulas (CALCULATE, SUMX, etc.) • Building interactive dashboards • Publishing to Power BI Service 4. Practice Resources • Kaggle – Use datasets for custom dashboards • Microsoft Sample Datasets – Sales, finance, HR • Maven Analytics – Project challenges 5. Tools to Use • Power BI Desktop (Free) – Core tool • Power BI Service – Publish & share dashboards • Excel – For data prep and integration 6. Project Ideas • Sales dashboard • Social media performance tracker • HR analytics report • Financial KPI dashboard 7. Certifications (Optional) • PL-300: Microsoft Power BI Data Analyst 💡 Build 2–3 dashboards, post on LinkedIn, and explain your insights. 💬 Tap ❤️ for more!

𝗧𝗖𝗦 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗢𝗻 𝗗𝗮𝘁𝗮 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 - 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘😍 TCS iON is offering a FREE Master Data Management Course with a Certificate, ✅ 100% FREE Learning ✅ Certificate on Completion ✅ Self-Paced Online Course ✅ Beginner-Friendly Content ✅ Industry-Relevant Skills ✅ Resume & LinkedIn Profile Boost 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlink.in/4jGFBw0 🚀 Start Learning Today. Upskill for Free. Get Career Ready!

𝗧𝗖𝗦 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗢𝗻 𝗗𝗮𝘁𝗮 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 - 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘😍 TCS iON is offering a FREE Master Data Management Course with a Certificate, ✅ 100% FREE Learning ✅ Certificate on Completion ✅ Self-Paced Online Course ✅ Beginner-Friendly Content ✅ Industry-Relevant Skills ✅ Resume & LinkedIn Profile Boost 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlink.in/4jGFBw0 🚀 Start Learning Today. Upskill for Free. Get Career Ready!

✅ SQL Interview Roadmap – Step-by-Step Guide to Crack Any SQL Round 💼📊 Whether you're applying for Data Analyst, BI, or Data Engineer roles — SQL rounds are must-clear. Here's your focused roadmap: 1️⃣ Core SQL Concepts 🔹 Understand RDBMS, tables, keys, schemas 🔹 Data types, NULLs, constraints 🧠 Interview Tip: Be able to explain Primary vs Foreign Key. 2️⃣ Basic Queries 🔹 SELECT, FROM, WHERE, ORDER BY, LIMIT 🧠 Practice: Filter and sort data by multiple columns. 3️⃣ Joins – Very Frequently Asked! 🔹 INNER, LEFT, RIGHT, FULL OUTER JOIN 🧠 Interview Tip: Explain the difference with examples. 🧪 Practice: Write queries using joins across 2–3 tables. 4️⃣ Aggregations & GROUP BY 🔹 COUNT, SUM, AVG, MIN, MAX, HAVING 🧠 Common Question: Total sales per category where total > X. 5️⃣ Window Functions 🔹 ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD() 🧠 Interview Favorite: Top N per group, previous row comparison. 6️⃣ Subqueries & CTEs 🔹 Write queries inside WHERE, FROM, and using WITH 🧠 Use Case: Filtering on aggregated data, simplifying logic. 7️⃣ CASE Statements 🔹 Add logic directly in SELECT 🧠 Example: Categorize users based on spend or activity. 8️⃣ Data Cleaning & Transformation 🔹 Handle NULLs, format dates, string manipulation (TRIM, SUBSTRING) 🧠 Real-world Task: Clean user input data. 9️⃣ Query Optimization Basics 🔹 Understand indexing, query plan, performance tips 🧠 Interview Tip: Difference between WHERE and HAVING. 🔟 Real-World Scenarios 🧠 Must Practice: • Sales funnel • Retention cohort • Churn rate • Revenue by channel • Daily active users 🧪 Practice Platforms • LeetCode (Easy–Hard SQL) • StrataScratch (Real business cases) • Mode Analytics (SQL + Visualization) • HackerRank SQL (MCQs + Coding) 💼 Final Tip: Explain why your query works, not just what it does. Speak your logic clearly. 💬 Tap ❤️ for more!

📊 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 | 𝗡𝗼 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 𝗡𝗲𝗲𝗱𝗲𝗱! 🚀 Want to start a career in Data Analytics but don't know where to begin? These 5 FREE beginner-friendly courses will help you learn the most in-demand data skills and build a strong foundation. 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlink.in/3SOk64h 🚀 Start Learning Today. Build Your Portfolio. Land Your Dream Data Job!

Practice Tasks: ✅ Automated sales report ✅ CSV cleaning workflow ✅ Refreshable dashboard ✅ Week 8: Real Projects + Interview Preparation Build These Projects: 📊 Project 1: Sales Dashboard Include: • KPIs • PivotTables • Charts • Slicers 💰 Project 2: Expense Tracker Include: • Budget vs Actual • Monthly Trends • Conditional Formatting 👨‍💼 Project 3: HR Analytics Dashboard Include: • Attendance • Employee Performance • Attrition Analysis Interview Preparation: ✔ Practice Excel interview questions ✔ Learn keyboard shortcuts ✔ Solve business problems ✔ Explain dashboards confidently 🚀 Best Excel Features Every Analyst Should Master Skill : Importance PivotTables : ⭐⭐⭐⭐⭐ Lookup Functions : ⭐⭐⭐⭐⭐ Data Cleaning : ⭐⭐⭐⭐⭐ Dashboards : ⭐⭐⭐⭐⭐ Power Query : ⭐⭐⭐⭐⭐ Conditional Formatting : ⭐⭐⭐⭐ VBA Basics : ⭐⭐⭐ 📚 Best Resources to Learn Excel Official Website Microsoft Excel Practice Platforms • Excel Practice Online • W3Schools Excel Tutorial • ExcelJet YouTube Channels • Leila Gharani • Kevin Stratvert • MyOnlineTrainingHub 📌 Consistency matters more than speed. Practice daily for 1 to 2 hours and build projects alongside learning. Double Tap ❤️ For Detailed Explanation

🚀 Complete 2-Month Excel Roadmap 📊🔥 If you want to become strong in Microsoft Excel for: • Data Analytics • Business Analysis • Finance • Reporting • Office Work • Dashboards • Automation then this 8-week roadmap is enough to build solid Excel skills step-by-step. 💯 🗓️ Month 1 — Build Strong Excel Foundations ✅ Week 1: Excel Basics & Interface Topics to Learn: ✔ Workbook vs Worksheet ✔ Rows, Columns, Cells ✔ Ribbon & Tabs ✔ Entering Data ✔ Copy, Paste, Cut ✔ Undo/Redo ✔ Save/Open Files ✔ Zoom & Freeze Panes ✔ Hide/Unhide Rows & Columns ✔ Keyboard Shortcuts Practice Tasks: ✅ Create a student marksheet ✅ Create an employee database ✅ Use formatting and borders ✅ Freeze headers while scrolling Important Shortcuts: Shortcut : Use Ctrl + C : Copy Ctrl + V : Paste Ctrl + Z : Undo Ctrl + S : Save Ctrl + Arrow Keys : Fast navigation ✅ Week 2: Formatting + Basic Formulas Topics to Learn: ✔ Cell Formatting ✔ Conditional Formatting ✔ Format as Table ✔ Wrap Text & Merge Cells ✔ Number Formats ✔ Basic Arithmetic Formulas ✔ Relative & Absolute References Functions to Master: =SUM() =AVERAGE() =MIN() =MAX() =COUNT() =COUNTA() Practice Tasks: ✅ Sales summary sheet ✅ Expense tracker ✅ Student report card ✅ Week 3: Logical + Text + Date Functions Topics to Learn: ✔ IF Statements ✔ Nested IF ✔ AND / OR ✔ Error Handling Important Functions: =IF() =IFERROR() =TRIM() =LEFT() =RIGHT() =MID() =TODAY() =DATEDIF() Practice Tasks: ✅ Attendance tracker ✅ Invoice generator ✅ Clean messy customer names ✅ Week 4: Lookup Functions + Data Cleaning Lookup Functions: ✔ VLOOKUP ✔ HLOOKUP ✔ INDEX + MATCH ✔ XLOOKUP Data Cleaning Topics: ✔ Remove Duplicates ✔ Text-to-Columns ✔ Flash Fill ✔ Sorting & Filtering ✔ Data Validation Dropdowns Practice Tasks: ✅ Employee lookup system ✅ Product inventory sheet ✅ Customer database cleaning 🗓️ Month 2 — Advanced Excel + Dashboard Skills ✅ Week 5: PivotTables + Charts Topics to Learn: ✔ PivotTables ✔ Grouping Data ✔ PivotCharts ✔ Slicers & Timelines ✔ Dashboard Basics Practice Tasks: ✅ Sales dashboard ✅ HR dashboard ✅ Monthly performance report Charts to Learn: Chart : Use Bar Chart : Comparison Line Chart : Trends Pie Chart : Distribution Combo Chart : Mixed analysis ✅ Week 6: Advanced Excel Functions Important Functions: =SUMIFS() =COUNTIFS() =AVERAGEIFS() =SUMPRODUCT() =FILTER() =SORT() =UNIQUE() Learn: ✔ Dynamic Arrays ✔ Named Ranges ✔ Structured References ✔ Advanced Conditional Formatting Practice Tasks: ✅ Dynamic KPI dashboard ✅ Multi-condition reporting ✅ Automated summary tables ✅ Week 7: Power Query + Automation Learn Microsoft Power Query: ✔ Import CSV Files ✔ Clean Data ✔ Merge Queries ✔ Pivot/Unpivot ✔ Refresh Data Automation Topics: ✔ Macro Recording ✔ Basic VBA Concepts ✔ Report Automation

📊 𝗙𝗥𝗘𝗘 𝗧𝗮𝘁𝗮 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗩𝗶𝗿𝘁𝘂𝗮𝗹 𝗜𝗻𝘁𝗲𝗿𝗻𝘀𝗵𝗶𝗽 | 𝗪𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲 🚀 Here's an amazing opportunity to complete the FREE Tata Data Analytics Virtual Internship and earn a certificate that you can showcase on your Resume and LinkedIn. ✅ 100% FREE ✅ Self-Paced & Online ✅ Beginner-Friendly ✅ Certificate on Completion ✅ Real Business Case Studies ✅ Resume & LinkedIn Boost 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlink.in/4eybW8J 🚀 Upskill Today. Build Your Portfolio. Get Career Ready!

Excel Basics for Data Analytics Excel sits at the start of most analysis work. What you use Excel for • Cleaning raw data • Exploring patterns • Quick summaries for teams Core concepts you must know • Data setup – Freeze header row. View → Freeze Top Row. – Convert range to table. Ctrl + T. – Use proper headers. No merged cells. One value per cell. • Data cleaning – Remove duplicates. Data → Remove Duplicates. – Trim extra spaces. =TRIM(A2) – Convert text to numbers. =VALUE(A2) – Fix date format. Format Cells → Date. – Handle blanks. Filter blanks, fill or delete. – Find and replace. Ctrl + H. • Essential formulas – Math and counts ▪ SUM. =SUM(A2:A100) ▪ AVERAGE. =AVERAGE(A2:A100) ▪ MIN. =MIN(A2:A100) ▪ MAX. =MAX(A2:A100) ▪ COUNT. Counts numbers. ▪ COUNTA. Counts non blanks. ▪ COUNTBLANK. Counts blanks. – Conditional formulas ▪ IF. =IF(A2>5000,"High","Low") ▪ IFS. Multiple conditions. ▪ AND. =AND(A2>5000,B2="West") ▪ OR. =OR(A2>5000,A2<1000) – Lookup formulas ▪ XLOOKUP. =XLOOKUP(A2,Sheet2!A:A,Sheet2!B:B) ▪ VLOOKUP. Old but common. ▪ INDEX + MATCH. Powerful alternative. – Text formulas ▪ LEFT. =LEFT(A2,4) ▪ RIGHT. =RIGHT(A2,2) ▪ MID. =MID(A2,2,3) ▪ LEN. =LEN(A2) ▪ CONCAT or TEXTJOIN. ▪ LOWER, UPPER, PROPER. – Date formulas ▪ TODAY. Current date. ▪ NOW. Date and time. ▪ YEAR, MONTH, DAY. ▪ DATEDIF. Date difference. ▪ EOMONTH. Month end. • Sorting and filtering – Sort by multiple columns. – Filter by value, color, condition. – Top 10 filter for quick insights. • Conditional formatting – Highlight duplicates. – Color scales for trends. – Rules for thresholds. Example. Sales > 10000 in green. • Pivot tables – Insert → PivotTable. – Rows. Category or Product. – Values. Sum, Count, Average. – Filters. Date, Region. – Refresh after data update. • Charts you must know – Column. Comparison. – Bar. Ranking. – Line. Trends over time. – Pie. Share or percentage. – Combo. Actual vs target. • Data validation – Dropdown list. Data → Data Validation → List. – Prevent wrong entries. • Useful shortcuts – Ctrl + Arrow. Jump data. – Ctrl + Shift + Arrow. Select range. – Ctrl + 1. Format cells. – Ctrl + L. Apply filter. – Alt + =. Auto sum. – Ctrl + Z / Y. Undo redo. • Common analyst mistakes to avoid – Merged cells. – Hard coded totals. – Mixed data types in one column. – No backup before cleaning. • Daily practice task – Download any sales CSV. – Clean it. – Build one pivot table. – Create one chart. Excel Resources: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i Data Analytics Roadmap: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02/1354 Double Tap ♥️ For More

📊 𝗣𝘄𝗖 𝗶𝘀 𝗼𝗳𝗳𝗲𝗿𝗶𝗻𝗴 𝗮 𝗙𝗥𝗘𝗘 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺 This helps tolearn data visualization, dashboard creation, KPI analysis, and business intelligence skills that companies actively look for. ✅ Free Certificate ✅ Self-Paced Learning ✅ Hands-On Power BI Projects ✅ Beginner Friendly ✅ Resume & LinkedIn Boost Don't miss this opportunity to add an in-demand skill to your profile and stand out from the crowd! 💼🔥 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlink.in/4g5sKFa Share with yours friends who wants to start a career in Data Analytics

𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝟭𝟬𝟬+ 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗔𝘇𝘂𝗿𝗲, 𝗔𝗜, 𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 & 𝗠𝗼𝗿𝗲 🚀 Learn the most in-demand tech skills from Microsoft completely FREE🌟 Microsoft Learn offers 100+ free courses designed to help students, freshers, and professionals build job-ready skills in today's fastest-growing technology domains. ✅ 100% Free Learning ✅ Beginner to Advanced Levels 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlink.in/4f0GNuH 🚀 Learn. Practice. Upskill. Get Career Ready

🚨 SQL Fact Most Beginners Learn Too Late! Many aspiring Data Analysts think these two SQL commands do the same thing... but they don't. 👇 📌 UNION ✅ Combines results and removes duplicates. 📌 UNION ALL ✅ Combines results and keeps duplicates. Example: Table A: 101 102 103 Table B: 103 104 105 🔹 UNION → 101, 102, 103, 104, 105 🔹 UNION ALL → 101, 102, 103, 103, 104, 105 💡 This small difference can affect both your query results and performance. In fact, UNION ALL is usually faster because SQL doesn't need to remove duplicates. 🎯 A favorite SQL interview question that catches many beginners off guard! ❤️ Drop a ❤️ if you learned something new today and follow for more SQL, Excel, Power BI & Data Analyst interview tips!

🎓 𝗚𝗼𝗼𝗴𝗹𝗲 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟲 🚀 Learn job-ready skills from Google and boost your resume?🌟 ✔️ Learn from Google Experts ✔️ Industry-Recognized Certificates ✔️ Beginner-Friendly Learning Paths ✔️ Self-Paced Courses ✔️ Enhance Resume & LinkedIn Profile ✔️ Build Job-Ready Skills 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇: https://pdlink.in/4vjLGVq ⏳ Start Learning Today & Upgrade Your Career!

🚀 Data Analyst Interview Questions with Answers — Part 1 🧠 Data Analyst Role & Basics 1. What does a data analyst do in a company? A data analyst collects, cleans, analyzes, and interprets data to help businesses make better decisions. They create reports, dashboards, and insights that improve performance, reduce costs, and identify opportunities. 2. What is the difference between a data analyst, data scientist, and BI analyst? ✅ Data Analyst → Focuses on analyzing historical data, creating reports, dashboards, and business insights. ✅ Data Scientist → Works on advanced analytics, machine learning, predictive modeling, and AI solutions. ✅ BI Analyst → Primarily focuses on business intelligence tools like Power BI/Tableau to build dashboards and monitor KPIs. 3. What is the typical workflow of a data analyst? A common workflow is: 1️⃣ Understand business requirements 2️⃣ Collect data from databases/files/APIs 3️⃣ Clean and preprocess data 4️⃣ Analyze data using SQL/Excel/Python 5️⃣ Create dashboards or visualizations 6️⃣ Present insights to stakeholders 7️⃣ Monitor results and improve analysis 4. What are the main goals of data analysis? 📊 Descriptive Analysis → What happened? 📈 Diagnostic Analysis → Why did it happen? 🔮 Predictive Analysis → What may happen next? 🎯 Prescriptive Analysis → What action should be taken? 5. What is KPI and why is it important? KPI (Key Performance Indicator) is a measurable metric used to track business performance. Examples: ✔️ Revenue Growth ✔️ Customer Retention ✔️ Conversion Rate ✔️ Website Traffic KPIs help companies measure progress toward goals and make data-driven decisions. 6. What is the difference between metrics and KPIs? 📌 Metrics = Any measurable value Example: Number of website visitors 📌 KPIs = Critical metrics tied to business goals Example: Monthly customer conversion rate 👉 All KPIs are metrics, but not all metrics are KPIs. 7. What is a dashboard vs a report? 📊 Dashboard • Interactive • Real-time or frequently updated • High-level overview of KPIs 📄 Report • Detailed and static • Often shared weekly/monthly • Used for deep analysis 8. What is exploratory data analysis (EDA)? EDA is the process of exploring and understanding data before detailed analysis or modeling. It includes: ✔️ Finding missing values ✔️ Detecting outliers ✔️ Understanding distributions ✔️ Identifying trends and patterns Tools commonly used: SQL, Excel, Python, Power BI. 9. What is the difference between raw data and processed data? 📌 Raw Data → Original uncleaned data directly from sources. Example: Duplicate rows, missing values, inconsistent formats. 📌 Processed Data → Cleaned and transformed data ready for analysis. 10. How do you prioritize which analysis to work on first? A data analyst usually prioritizes tasks based on: ✅ Business impact ✅ Urgency ✅ Stakeholder requirements ✅ Revenue/customer impact ✅ Time and resource availability High-impact and time-sensitive analyses are handled first. 🚀 Double Tap ❤️ For More