Data Analyst Interview Resources

𝟳 𝗠𝘂𝘀𝘁-𝗞𝗻𝗼𝘄 𝗦𝗤𝗟 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀 𝗘𝘃𝗲𝗿𝘆 𝗔𝘀𝗽𝗶𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗦𝗵𝗼𝘂𝗹𝗱 𝗠𝗮𝘀𝘁𝗲𝗿😍 If you’re serious about becoming a data analyst, there’s no skipping SQL. It’s not just another technical skill — it’s the core language for data analytics.📊 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/44S3Xi5 This guide covers 7 key SQL concepts that every beginner must learn✅️

Q1: How do you ensure data consistency and integrity in a data warehousing environment? Ans: I implement data validation checks, use constraints like primary and foreign keys, and ensure that ETL processes have error-handling mechanisms. Regular audits and data reconciliation processes are also set up to ensure data accuracy and consistency. Q2: Describe a situation where you had to design a star schema for a data warehousing project. Ans: For a retail sales data warehousing project, I designed a star schema with a central fact table containing sales transactions. Surrounding this were dimension tables like Products, Stores, Time, and Customers. This structure allowed for efficient querying and reporting of sales metrics across various dimensions. Q3: How would you use data analytics to assess credit risk for loan applicants? Ans: I'd analyze the applicant's financial history, including credit score, income, employment stability, and existing debts. Using predictive modeling, I'd assess the probability of default based on historical data of similar applicants. This would help in making informed lending decisions. Q4: Describe a situation where you had to ensure data security for sensitive financial data. Ans: While working on a project involving customer transaction data, I ensured that all data was encrypted both at rest and in transit. I also implemented role-based access controls, ensuring that only authorized personnel could access specific data sets. Regular audits and penetration tests were conducted to identify and rectify potential vulnerabilities.

🎓 𝐀𝐜𝐜𝐞𝐧𝐭𝐮𝐫𝐞 𝐅𝐑𝐄𝐄 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 | 𝗘𝗻𝗿𝗼𝗹𝗹 𝗡𝗼𝘄 😍 Boost your skills with 100% FREE certification courses from Accenture! 📚 FREE Courses Offered: 1️⃣ Data Processing and Visualization 2️⃣ Exploratory Data Analysis 3️⃣ SQL Fundamentals 4️⃣ Python Basics 5️⃣ Acquiring Data 𝐋𝐢𝐧𝐤 👇:-  https://pdlink.in/45WnGy1 ✅ Learn Online | 📜 Get Certified

Hey guys, Today, I curated a list of essential Power BI interview questions that every aspiring data analyst should be prepared to answer 👇👇 1. What is Power BI? Power BI is a business analytics service developed by Microsoft. It provides tools for aggregating, analyzing, visualizing, and sharing data. With Power BI, users can create dynamic dashboards and interactive reports from multiple data sources. Key Features: - Data transformation using Power Query - Powerful visualizations and reporting tools - DAX (Data Analysis Expressions) for complex calculations 2. What are the building blocks of Power BI? The main building blocks of Power BI include: - Visualizations: Graphical representations of data (charts, graphs, etc.). - Datasets: A collection of data used to create visualizations. - Reports: A collection of visualizations on one or more pages. - Dashboards: A single page that combines multiple visualizations from reports. - Tiles: Single visualization found on a report or dashboard. 3. What is DAX, and why is it important in Power BI? DAX (Data Analysis Expressions) is a formula language used in Power BI for creating custom calculations and aggregations. DAX is similar to Excel formulas but offers much more powerful data manipulation capabilities. Tip: Be ready to explain not just the syntax, but scenarios where DAX is essential, such as calculating year-over-year growth or creating dynamic measures. 4. How does Power BI differ from Excel in data visualization? While Excel is great for individual analysis and data manipulation, Power BI excels in handling large datasets, creating interactive dashboards, and sharing insights across the organization. Power BI also integrates better and allows for real-time data streaming. 5. What are the types of filters in Power BI, and how are they used? Power BI offers several types of filters to refine data and display only what’s relevant: - Visual-level filters: Apply filters to individual visuals. - Page-level filters: Apply filters to all the visuals on a report page. - Report-level filters: Apply filters to all pages in the report. Filters help to create more customized and targeted reports by narrowing down the data view based on specific conditions. 6. What are Power BI Desktop, Power BI Service, and Power BI Mobile? How do they interact? - Power BI Desktop: A desktop-based application used for data modeling, creating reports, and building dashboards. - Power BI Service: A cloud-based platform that allows users to publish and share reports created in Power BI Desktop. - Power BI Mobile: Allows users to view reports and dashboards on mobile devices for on-the-go access. These components work together in a typical workflow: 1. Build reports and dashboards in Power BI Desktop. 2. Publish them to the Power BI Service for sharing and collaboration. 3. View and interact with reports on Power BI Mobile for easy access anywhere. 7. Explain the difference between calculated columns and measures. - Calculated columns are added to a table using DAX and are calculated row by row. - Measures are calculations used in aggregations, such as sums, averages, and ratios. Unlike calculated columns, measures are dynamic and evaluated based on the filter context of a report. 8. How would you perform data cleaning and transformation in Power BI? Data cleaning and transformation in Power BI are mainly done using Power Query Editor. Here, you can: - Remove duplicates or empty rows - Split columns (e.g., text into multiple parts) - Change data types (e.g., text to numbers) - Merge and append queries from different data sources Power BI isn’t just about visuals; it’s about turning raw data into actionable insights. So, keep honing your skills, try building dashboards, and soon enough, you’ll be impressing your interviewers too! I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://t.me/DataSimplifier Share with credits: https://t.me/sqlspecialist Hope it helps :)

𝗧𝗵𝗲 𝗕𝗲𝘀𝘁 𝗙𝗿𝗲𝗲 𝟯𝟬-𝗗𝗮𝘆 𝗥𝗼𝗮𝗱𝗺𝗮𝗽 𝘁𝗼 𝗦𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗝𝗼𝘂𝗿𝗻𝗲𝘆😍 📊 If I had to restart my Data Science journey in 2025, this is where I’d begin✨️ Meet 30 Days of Data Science — a free and beginner-friendly GitHub repository that guides you through the core fundamentals of data science in just one month🧑‍🎓📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4mfNdXR Simply bookmark the page, pick Day 1, and begin your journey✅️

Essential Skills Excel for Data Analysts 🚀 1️⃣ Data Cleaning & Transformation Remove Duplicates – Ensure unique records. Find & Replace – Quick data modifications. Text Functions – TRIM, LEN, LEFT, RIGHT, MID, PROPER. Data Validation – Restrict input values. 2️⃣ Data Analysis & Manipulation Sorting & Filtering – Organize and extract key insights. Conditional Formatting – Highlight trends, outliers. Pivot Tables – Summarize large datasets efficiently. Power Query – Automate data transformation. 3️⃣ Essential Formulas & Functions Lookup Functions – VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH. Logical Functions – IF, AND, OR, IFERROR, IFS. Aggregation Functions – SUM, AVERAGE, MIN, MAX, COUNT, COUNTA. Text Functions – CONCATENATE, TEXTJOIN, SUBSTITUTE. 4️⃣ Data Visualization Charts & Graphs – Bar, Line, Pie, Scatter, Histogram. Sparklines – Miniature charts inside cells. Conditional Formatting – Color scales, data bars. Dashboard Creation – Interactive and dynamic reports. 5️⃣ Advanced Excel Techniques Array Formulas – Dynamic calculations with multiple values. Power Pivot & DAX – Advanced data modeling. What-If Analysis – Goal Seek, Scenario Manager. Macros & VBA – Automate repetitive tasks. 6️⃣ Data Import & Export CSV & TXT Files – Import and clean raw data. Power Query – Connect to databases, web sources. Exporting Reports – PDF, CSV, Excel formats. Here you can find some free Excel books & useful resources: https://t.me/excel_data Hope it helps :) #dataanalyst

𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗜𝗻 𝗧𝗼𝗽 𝗠𝗡𝗖𝘀😍 Learn Data Analytics, Data Science & AI From Top Data Experts  Modes :- Online & Offline (Hyderabad/Pune) 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝗲𝘀:-  - 12.65 Lakhs Highest Salary - 500+ Partner Companies - 100% Job Assistance - 5.7 LPA Average Salary 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼👇:- 𝗢𝗻𝗹𝗶𝗻𝗲 :- https://pdlink.in/4fdWxJB 𝗛𝘆𝗱𝗲𝗿𝗮𝗯𝗮𝗱 :- https://pdlink.in/4kFhjn3 𝗣𝘂𝗻𝗲 :- https://pdlink.in/45p4GrC ( Hurry Up 🏃‍♂️Limited Slots )

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 😊

🚀𝗧𝗼𝗽 𝟯 𝗙𝗿𝗲𝗲 𝗚𝗼𝗼𝗴𝗹𝗲-𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗣𝘆𝘁𝗵𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟱😍 Want to boost your tech career? Learn Python for FREE with Google-certified courses! Perfect for beginners—no expensive bootcamps needed. 🔥 Learn Python for AI, Data, Automation & More! 📍𝗦𝘁𝗮𝗿𝘁 𝗡𝗼𝘄👇 https://pdlink.in/42okGqG ✅ Future You Will Thank You!

Dreaming of a perfect day as a data analyst? Here is the reality check: • You arrive at the office, grab a coffee, and dive deep into solving complex problems. 𝗕𝘂𝘁, you spend the first hour trying to figure out why one of your dashboards shows outdated data. • You present impactful insights to a room full of executives, who trust your recommendations and are eager to execute your ideas. 𝗕𝘂𝘁, you will explain for the 10th time why Excel isn’t the best tool for running the complex analysis they are requesting. • You use the latest machine learning models to accurately predict future trends. 𝗕𝘂𝘁, you will spend whole days wrangling messy, incomplete datasets. • You collaborate with a team of data scientists to create innovative solutions. 𝗕𝘂𝘁, you will have to send a dozen Slack messages to IT just to get access to the data you need. • You spend the afternoon writing elegant, and efficient Python code. 𝗕𝘂𝘁, you will google basic pandas function more times than you’d like to admit. Manage your expectations and find humor in your daily work. It’s all part of the journey to those moments where you will drive real business impact as a data analyst!

📊𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 - 𝟭𝟬𝟬% 𝗙𝗥𝗘𝗘 😍 Start learning industry-relevant data skills today at zero cost! ✅ 100% FREE Certification ✅ Learn Data Analysis, Excel, SQL, Power BI & more ✅ Boost your resume with job-ready skills 🚀 Perfect for Students, Freshers & Career Switchers 𝐋𝐢𝐧𝐤 👇:-    https://pdlink.in/4lp7hXQ   🎓 Enroll Now & Get Certified

1. Define the term 'Data Wrangling. Data Wrangling is the process wherein raw data is cleaned, structured, and enriched into a desired usable format for better decision making. It involves discovering, structuring, cleaning, enriching, validating, and analyzing data. This process can turn and map out large amounts of data extracted from various sources into a more useful format. 2. What are the best methods for data cleaning? Create a data cleaning plan by understanding where the common errors take place and keep all the communications open. Before working with the data, identify and remove the duplicates. This will lead to an easy and effective data analysis process.Focus on the accuracy of the data. Set cross-field validation, maintain the value types of data, and provide mandatory constraints.Normalize the data at the entry point so that it is less chaotic. You will be able to ensure that all information is standardized, leading to fewer errors on entry. 3. Explain 4 steps to use CTE in sql. All CTE starts with "with" clause. After with you need to define CTE name and the field names. For instance in the below code snippet I have 3 fields Count,Column and Id. The name of CTE is "MyTemp". Once you have defined CTE we need to specify the SQL which will give the result for the CTE. Finally you can use the CTE in your SQL query.

𝟲 𝗙𝗿𝗲𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗟𝗲𝗮𝗿𝗻 𝘁𝗵𝗲 𝗠𝗼𝘀𝘁 𝗜𝗻-𝗗𝗲𝗺𝗮𝗻𝗱 𝗧𝗲𝗰𝗵 𝗦𝗸𝗶𝗹𝗹𝘀😍 🚀 Want to future-proof your career without spending a single rupee?💵 These 6 free online courses from top institutions like Google, Harvard, IBM, Stanford, and Cisco will help you master high-demand tech skills in 2025 — from Data Analytics to Machine Learning📊🧑‍💻 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4fbDejW Each course is beginner-friendly, comes with certification, and helps you build your resume or switch careers✅️

SQL From Basic to Advanced level Basic SQL is ONLY 7 commands: - SELECT - FROM - WHERE (also use SQL comparison operators such as =, <=, >=, <> etc.) - ORDER BY - Aggregate functions such as SUM, AVERAGE, COUNT etc. - GROUP BY - CREATE, INSERT, DELETE, etc. You can do all this in just one morning. Once you know these, take the next step and learn commands like: - LEFT JOIN - INNER JOIN - LIKE - IN - CASE WHEN - HAVING (undertstand how it's different from GROUP BY) - UNION ALL This should take another day. Once both basic and intermediate are done, start learning more advanced SQL concepts such as: - Subqueries (when to use subqueries vs CTE?) - CTEs (WITH AS) - Stored Procedures - Triggers - Window functions (LEAD, LAG, PARTITION BY, RANK, DENSE RANK) These can be done in a couple of days. Learning these concepts is NOT hard at all - what takes time is practice and knowing what command to use when. How do you master that? - First, create a basic SQL project - Then, work on an intermediate SQL project (search online) - Lastly, create something advanced on SQL with many CTEs, subqueries, stored procedures and triggers etc. This is ALL you need to become a badass in SQL, and trust me when I say this, it is not rocket science. It's just logic. Remember that practice is the key here. It will be more clear and perfect with the continous practice Best telegram channel to learn SQL: https://t.me/sqlanalyst Data Analyst Jobs👇 https://t.me/jobs_SQL Join @free4unow_backup for more free resources. Like this post if it helps 😄❤️ ENJOY LEARNING 👍👍

𝗧𝗼𝗽 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀 𝗛𝗶𝗿𝗶𝗻𝗴 𝗔𝗰𝗿𝗼𝘀𝘀 𝗜𝗻𝗱𝗶𝗮 😍 Multiple top MNCs are hiring for various roles across domains! 🔹 Roles: Tech & Non-Tech 🔹 Location: PAN India 🔹 Qualification: Graduate / Post Graduate 🔹 Salary: Competitive Packages 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇:- https://bit.ly/4f5VAmj Select your experience & Complete The Registration Process  Select the company name & apply for the role that matches you

Complete Roadmap to learn Excel in 2025 👇👇 1. Basic Excel Skills:    - Familiarize yourself with Excel's interface and navigation.    - Learn basic formulas (SUM, AVERAGE, COUNT, etc.).    - Understand cell referencing (absolute vs. relative). 2. Data Entry and Formatting:    - Practice entering and formatting data efficiently.    - Explore cell formatting options for a clean and organized dataset. 3. Advanced Formulas:    - Master more advanced formulas like VLOOKUP, HLOOKUP, INDEX-MATCH.    - Learn logical functions (IF, AND, OR).    - Understand array formulas for complex calculations. 4. Pivot Tables:    - Gain proficiency in creating Pivot Tables for data summarization.    - Learn to customize and format Pivot Tables effectively. 5. Data Cleaning:    - Acquire skills in cleaning and transforming data.    - Explore text-to-columns, remove duplicates, and data validation. 6. Charts and Graphs:    - Learn to create various charts (bar, line, pie) for data visualization.    - Understand chart formatting and customization. 7. Dashboard Creation:    - Combine charts and tables to build basic dashboards.    - Explore dynamic dashboards using Excel features. 8. Macros and VBA:    - Dive into basic automation using Excel macros.    - Learn Visual Basic for Applications (VBA) for more advanced automation. 9. Power Query:    - Introduce yourself to Power Query for enhanced data manipulation.    - Learn to import, transform, and load data efficiently. 10. Advanced Excel Techniques:    - Explore advanced features like Goal Seek, Solver, and Scenario Manager.    - Master the use of data tables for sensitivity analysis. 11. Real-world Projects:    - Apply your skills to real-world projects or datasets.    - Practice solving analytical problems using Excel. Remember to practice consistently, as hands-on experience is crucial for mastering Excel. This roadmap will provide a solid foundation for your journey into data analysis using Excel. 5️⃣ Free resources to practice Excel https://www.w3schools.com/EXCEL/index.php https://bit.ly/3PSorPT http://learn.microsoft.com/en-gb/training/paths/modern-analytics/ https://t.me/excel_analyst/52 https://excel-practice-online.com/ Join for more: https://t.me/free4unow_backup ENJOY LEARNING 👍👍

🎓𝟱 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗧𝗲𝗰𝗵 𝗖𝗮𝗿𝗲𝗲𝗿! 🚀 Upgrade your skills and earn industry-recognized certificates — 100% FREE! ✅ Big Data Analytics – https://pdlink.in/4nzRoza ✅ AI & ML – https://pdlink.in/401SWry ✅ Cloud Computing – https://pdlink.in/3U2sMkR ✅ Cyber Security – https://pdlink.in/4nzQaDQ ✅ Other Tech Courses – https://pdlink.in/4lIN673 🎯 Enroll Now & Get Certified for FREE

Machine Learning – Essential Concepts 🚀 1️⃣ Types of Machine Learning Supervised Learning – Uses labeled data to train models. Examples: Linear Regression, Decision Trees, Random Forest, SVM Unsupervised Learning – Identifies patterns in unlabeled data. Examples: Clustering (K-Means, DBSCAN), PCA Reinforcement Learning – Models learn through rewards and penalties. Examples: Q-Learning, Deep Q Networks 2️⃣ Key Algorithms Regression – Predicts continuous values (Linear Regression, Ridge, Lasso). Classification – Categorizes data into classes (Logistic Regression, Decision Tree, SVM, Naïve Bayes). Clustering – Groups similar data points (K-Means, Hierarchical Clustering, DBSCAN). Dimensionality Reduction – Reduces the number of features (PCA, t-SNE, LDA). 3️⃣ Model Training & Evaluation Train-Test Split – Dividing data into training and testing sets. Cross-Validation – Splitting data multiple times for better accuracy. Metrics – Evaluating models with RMSE, Accuracy, Precision, Recall, F1-Score, ROC-AUC. 4️⃣ Feature Engineering Handling missing data (mean imputation, dropna()). Encoding categorical variables (One-Hot Encoding, Label Encoding). Feature Scaling (Normalization, Standardization). 5️⃣ Overfitting & Underfitting Overfitting – Model learns noise, performs well on training but poorly on test data. Underfitting – Model is too simple and fails to capture patterns. Solution: Regularization (L1, L2), Hyperparameter Tuning. 6️⃣ Ensemble Learning Combining multiple models to improve performance. Bagging (Random Forest) Boosting (XGBoost, Gradient Boosting, AdaBoost) 7️⃣ Deep Learning Basics Neural Networks (ANN, CNN, RNN). Activation Functions (ReLU, Sigmoid, Tanh). Backpropagation & Gradient Descent. 8️⃣ Model Deployment Deploy models using Flask, FastAPI, or Streamlit. Model versioning with MLflow. Cloud deployment (AWS SageMaker, Google Vertex AI). Join our WhatsApp channel: https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D

𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗘𝗻𝗿𝗼𝗹𝗹 𝗜𝗻 𝟮𝟬𝟮𝟱 😍 Learn Fundamental Skills with Free Online Courses & Earn Certificates - AI - GenAI - Data Science, - BigData  - Python - Cloud Computing - Machine Learning - Cyber Security  𝐋𝐢𝐧𝐤 👇:-  https://pdlink.in/4dJ27Ta Enroll for FREE & Get Certified 🎓

Excel Cheat Sheet 📔 This Excel cheatsheet is designed to be your quick reference guide for using Microsoft Excel efficiently. 1. Basic Functions    - SUM: =SUM(range)    - AVERAGE: =AVERAGE(range)    - COUNT: =COUNT(range)    - MAX: =MAX(range)    - MIN: =MIN(range) 2. Text Functions    - CONCATENATE: =CONCATENATE(text1, text2, ...) or =TEXTJOIN(delimiter, ignore_empty, text1, text2, ...)    - LEFT: =LEFT(text, num_chars)    - RIGHT: =RIGHT(text, num_chars)    - MID: =MID(text, start_num, num_chars)    - TRIM: =TRIM(text) 3. Logical Functions    - IF: =IF(condition, true_value, false_value)    - AND: =AND(condition1, condition2, ...)    - OR: =OR(condition1, condition2, ...)    - NOT: =NOT(condition) 4. Lookup Functions    - VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])    - HLOOKUP: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])    - INDEX: =INDEX(array, row_num, [column_num])    - MATCH: =MATCH(lookup_value, lookup_array, [match_type]) 5. Data Sorting & Filtering    - Sort: *Data > Sort*    - Filter: *Data > Filter*    - Advanced Filter: *Data > Advanced* 6. Conditional Formatting    - Apply Formatting: *Home > Conditional Formatting > New Rule*    - Highlight Cells: *Home > Conditional Formatting > Highlight Cells Rules* 7. Charts and Graphs    - Insert Chart: *Insert > Select Chart Type*    - Customize Chart: *Chart Tools > Design/Format* 8. PivotTables    - Create PivotTable: *Insert > PivotTable*    - Refresh PivotTable: *Right-click on PivotTable > Refresh* 9. Data Validation    - Set Validation: *Data > Data Validation*    - List: *Allow: List > Source: range or items* 10. Protecting Data     - Protect Sheet: *Review > Protect Sheet*     - Protect Workbook: *Review > Protect Workbook* 11. Shortcuts     - Copy: Ctrl + C     - Paste: Ctrl + V     - Undo: Ctrl + Z     - Redo: Ctrl + Y     - Save: Ctrl + S 12. Printing Options     - Print Area: *Page Layout > Print Area > Set Print Area*     - Page Setup: *Page Layout > Page Setup* Checklist for Data Analyst: https://dataanalytics.beehiiv.com/p/data I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://t.me/DataSimplifier Like for more Interview Resources ♥️ Share with credits: https://t.me/sqlspecialist Hope it helps :)