Data Analyst Interview Resources

Important Excel, Tableau, Statistics, SQL related Questions with answers 1. What are the common problems that data analysts encounter during analysis? The common problems steps involved in any analytics project are: Handling duplicate data Collecting the meaningful right data at the right time Handling data purging and storage problems Making data secure and dealing with compliance issues 2. Explain the Type I and Type II errors in Statistics? In Hypothesis testing, a Type I error occurs when the null hypothesis is rejected even if it is true. It is also known as a false positive. A Type II error occurs when the null hypothesis is not rejected, even if it is false. It is also known as a false negative. 3. How do you make a dropdown list in MS Excel? First, click on the Data tab that is present in the ribbon. Under the Data Tools group, select Data Validation. Then navigate to Settings > Allow > List. Select the source you want to provide as a list array. 4. How do you subset or filter data in SQL? To subset or filter data in SQL, we use WHERE and HAVING clauses which give us an option of including only the data matching certain conditions. 5. What is a Gantt Chart in Tableau? A Gantt chart in Tableau depicts the progress of value over the period, i.e., it shows the duration of events. It consists of bars along with the time axis. The Gantt chart is mostly used as a project management tool where each bar is a measure of a task in the project

𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 & 𝗙𝘂𝗹𝗹 𝗦𝘁𝗮𝗰𝗸 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗔𝗿𝗲 𝗠𝗼𝘀𝘁 𝗗𝗲𝗺𝗮𝗻𝗱𝗶𝗻𝗴 𝗖𝗮𝗿𝗲𝗲𝗿𝘀 𝗜𝗻 𝟮𝟬𝟮𝟱 😍 Learn Full Stack Development | Data Analytics & Data Science  Curriculum designed and taught by Alumni from IITs & Leading Tech Companies. 60+ Hiring Drives Every Month 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬:-  🌟 500+ Hiring Partners 🤝Trusted by 7500+ Students  💼 Avg. Rs. 7.2 LPA 🚀 41 LPA Highest Package 𝗙𝘂𝗹𝗹 𝗦𝘁𝗮𝗰𝗸  :- https://pdlink.in/4hO7rWY 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 :- https://bit.ly/4g3kyT6 Hurry, limited seats available!🏃‍♀️

Data Analyst Interview Questions 👇 1.How to create filters in Power BI? Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways. Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries. Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters) 2.How to sort data in Power BI? Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available. 3.How to convert pdf to excel? Open the PDF document you want to convert in XLSX format in Acrobat DC. Go to the right pane and click on the “Export PDF” option. Choose spreadsheet as the Export format. Select “Microsoft Excel Workbook.” Now click “Export.” Download the converted file or share it. 4. How to enable macros in excel? Click the file tab and then click “Options.” A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.” Go to the “Macro Settings” and select “enable all macros.” Click OK to apply the macro settings.

𝗟𝗲𝗮𝗿𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗳𝗼𝗿 𝗙𝗿𝗲𝗲 𝗼𝗻 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 – 𝗖𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁 𝗚𝘂𝗶𝗱𝗲😍 🎥 YouTube is the ultimate free classroom—and this is your Data Analytics syllabus in one post!👨‍💻 From Python and SQL to Power BI, Machine Learning, and Data Science, these carefully curated playlists will take you from complete beginner to job-ready✨️📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4jzVggc Enjoy Learning ✅️

𝐒𝐐𝐋 𝐂𝐚𝐬𝐞 𝐒𝐭𝐮𝐝𝐢𝐞𝐬 𝐟𝐨𝐫 𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰: Join for more: https://t.me/sqlanalyst 1. Danny’s Diner: Restaurant analytics to understand the customer orders pattern. Link: https://8weeksqlchallenge.com/case-study-1/ 2. Pizza Runner Pizza shop analytics to optimize the efficiency of the operation Link: https://8weeksqlchallenge.com/case-study-2/ 3. Foodie Fie Subscription-based food content platform Link: https://lnkd.in/gzB39qAT 4. Data Bank: That’s money Analytics based on customer activities with the digital bank Link: https://lnkd.in/gH8pKPyv 5. Data Mart: Fresh is Best Analytics on Online supermarket Link: https://lnkd.in/gC5bkcDf 6. Clique Bait: Attention capturing Analytics on the seafood industry Link: https://lnkd.in/ggP4JiYG 7. Balanced Tree: Clothing Company Analytics on the sales performance of clothing store Link: https://8weeksqlchallenge.com/case-study-7 8. Fresh segments: Extract maximum value Analytics on online advertising Link: https://8weeksqlchallenge.com/case-study-8

𝗧𝗼𝗽 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀 𝗛𝗶𝗿𝗶𝗻𝗴  𝟮𝘆𝗿+ 𝗘𝘅𝗽 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹𝘀 😍 Siemens :- https://pdlink.in/4kPP6tx JP Morgan :- https://pdlink.in/3Frgm2C Orange :- https://pdlink.in/43yatKg PhonePe :- https://pdlink.in/4kOTfOj Oracle :- https://pdlink.in/4kQLFCU Walmart :- https://pdlink.in/4kreO7J Amazon :- https://pdlink.in/4jzo88g Apply before the link expires💫

SQL Basics for Data Analysts SQL (Structured Query Language) is used to retrieve, manipulate, and analyze data stored in databases. 1️⃣ Understanding Databases & Tables Databases store structured data in tables. Tables contain rows (records) and columns (fields). Each column has a specific data type (INTEGER, VARCHAR, DATE, etc.). 2️⃣ Basic SQL Commands Let's start with some fundamental queries: 🔹 SELECT – Retrieve Data

SELECT * FROM employees; -- Fetch all columns from 'employees' table SELECT name, salary FROM employees; -- Fetch specific columns 

🔹 WHERE – Filter Data

SELECT * FROM employees WHERE department = 'Sales'; -- Filter by department SELECT * FROM employees WHERE salary > 50000; -- Filter by salary 

🔹 ORDER BY – Sort Data

SELECT * FROM employees ORDER BY salary DESC; -- Sort by salary (highest first) SELECT name, hire_date FROM employees ORDER BY hire_date ASC; -- Sort by hire date (oldest first) 

🔹 LIMIT – Restrict Number of Results

SELECT * FROM employees LIMIT 5; -- Fetch only 5 rows SELECT * FROM employees WHERE department = 'HR' LIMIT 10; -- Fetch first 10 HR employees 

🔹 DISTINCT – Remove Duplicates

SELECT DISTINCT department FROM employees; -- Show unique departments 

Mini Task for You: Try to write an SQL query to fetch the top 3 highest-paid employees from an "employees" table. You can find free SQL Resources here 👇👇 https://t.me/mysqldata Like this post if you want me to continue covering all the topics! 👍❤️ Share with credits: https://t.me/sqlspecialist Hope it helps :) #sql

𝗣𝗿𝗲𝗽𝗮𝗿𝗶𝗻𝗴 𝗳𝗼𝗿 𝗮𝗻 𝗔𝗺𝗮𝘇𝗼𝗻 𝗗𝗮𝘁𝗮 𝗥𝗼𝗹𝗲? 𝗦𝘁𝗮𝗿𝘁 𝘄𝗶𝘁𝗵 𝗧𝗵𝗲𝘀𝗲 𝗧𝗼𝗽 𝗦𝗤𝗟 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀😍 💼 Why SQL Is Crucial for Amazon Interviews🗣 If you’re applying for a data analyst, data engineer, or business analyst role at Amazon, expect SQL to be a major part of the interview process👨‍💻📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4jrLrRy Practicing real Amazon SQL interview questions is the key to success✅️

1. What are the ways to detect outliers? Outliers are detected using two methods: Box Plot Method: According to this method, the value is considered an outlier if it exceeds or falls below 1.5*IQR (interquartile range), that is, if it lies above the top quartile (Q3) or below the bottom quartile (Q1). Standard Deviation Method: According to this method, an outlier is defined as a value that is greater or lower than the mean ± (3*standard deviation). 2. What is a Recursive Stored Procedure? A stored procedure that calls itself until a boundary condition is reached, is called a recursive stored procedure. This recursive function helps the programmers to deploy the same set of code several times as and when required. 3. What is the shortcut to add a filter to a table in EXCEL? The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L. 4. What is DAX in Power BI? DAX stands for Data Analysis Expressions. It's a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from data you already have.

🎓 𝗟𝗲𝗮𝗿𝗻 𝗖𝗼𝗺𝗽𝘂𝘁𝗲𝗿 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗳𝗼𝗿 𝗙𝗿𝗲𝗲 𝗳𝗿𝗼𝗺 𝗛𝗮𝗿𝘃𝗮𝗿𝗱, 𝗦𝘁𝗮𝗻𝗳𝗼𝗿𝗱, 𝗠𝗜𝗧 & 𝗚𝗼𝗼𝗴𝗹𝗲😍 Why pay thousands when you can access world-class Computer Science courses for free? 🌐 Top institutions like Harvard, Stanford, MIT, and Google offer high-quality learning resources to help you master in-demand tech skills👨‍🎓📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3ZyQpFd Perfect for students, self-learners, and career switchers✅️

Data Analyst Interview Questions [Python, SQL, PowerBI] 1. Is indentation required in python? Ans: Indentation is necessary for Python. It specifies a block of code. All code within loops, classes, functions, etc is specified within an indented block. It is usually done using four space characters. If your code is not indented necessarily, it will not execute accurately and will throw errors as well. 2. What are Entities and Relationships? Ans: Entity: An entity can be a real-world object that can be easily identifiable. For example, in a college database, students, professors, workers, departments, and projects can be referred to as entities. Relationships: Relations or links between entities that have something to do with each other. For example – The employee’s table in a company’s database can be associated with the salary table in the same database. 3. What are Aggregate and Scalar functions? Ans: An aggregate function performs operations on a collection of values to return a single scalar value. Aggregate functions are often used with the GROUP BY and HAVING clauses of the SELECT statement. A scalar function returns a single value based on the input value. 4. What are Custom Visuals in Power BI? Ans: Custom Visuals are like any other visualizations, generated using Power BI. The only difference is that it develops the custom visuals using a custom SDK. The languages like JQuery and JavaScript are used to create custom visuals in Power BI ENJOY LEARNING 👍👍

𝗪𝗼𝗿𝗸 𝗙𝗿𝗼𝗺 𝗛𝗼𝗺𝗲 𝗝𝗼𝗯 𝗢𝗽𝗽𝗼𝗿𝘁𝘂𝗻𝗶𝘁𝘆 𝘄𝗶𝘁𝗵 𝗮𝗻 𝗘-𝗰𝗼𝗺𝗺𝗲𝗿𝗰𝗲 𝗕𝗿𝗮𝗻𝗱!😍  Role: SEPO - Transaction Risk Investigator  Salary: ₹3.2–₹4 LPA Eligibility: All graduates are welcome  Location:- Work From Home 𝗔𝗽𝗽𝗹𝘆 𝗟𝗶𝗻𝗸👇:- https://pdlink.in/4mGpCAn Apply before the link expires💫 ✅ Take a quick online assessment to get started!

📊🚀A beginner's roadmap for learning SQL: 🔹Understand Basics: Learn what SQL is and its purpose in managing relational databases. Understand basic database concepts like tables, rows, columns, and relationships. 🔹Learn SQL Syntax: Familiarize yourself with SQL syntax for common commands like SELECT, INSERT, UPDATE, DELETE. Understand clauses like WHERE, ORDER BY, GROUP BY, and JOIN. 🔹Setup a Database: Install a relational database management system (RDBMS) like MySQL, SQLite, or PostgreSQL. Practice creating databases, tables, and inserting data. 🔹Retrieve Data (SELECT): Learn to retrieve data from a database using SELECT statements. Practice filtering data using WHERE clause and sorting using ORDER BY. 🔹Modify Data (INSERT, UPDATE, DELETE): Understand how to insert new records, update existing ones, and delete data. Be cautious with DELETE to avoid unintentional data loss. 🔹Working with Functions: Explore SQL functions like COUNT, AVG, SUM, MAX, MIN for data analysis. Understand string functions, date functions, and mathematical functions. 🔹Data Filtering and Sorting: Learn advanced filtering techniques using AND, OR, and IN operators. Practice sorting data using multiple columns. 🔹Table Relationships (JOIN): Understand the concept of joining tables to retrieve data from multiple tables. Learn about INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. 🔹Grouping and Aggregation: Explore GROUP BY clause to group data based on specific columns. Understand aggregate functions for summarizing data (SUM, AVG, COUNT). 🔹Subqueries: Learn to use subqueries to perform complex queries. Understand how to use subqueries in SELECT, WHERE, and FROM clauses. 🔹Indexes and Optimization: Gain knowledge about indexes and their role in optimizing queries. Understand how to optimize SQL queries for better performance. 🔹Transactions and ACID Properties: Learn about transactions and the ACID properties (Atomicity, Consistency, Isolation, Durability). Understand how to use transactions to maintain data integrity. 🔹Normalization: Understand the basics of database normalization to design efficient databases. Learn about 1NF, 2NF, 3NF, and BCNF. 🔹Backup and Recovery: Understand the importance of database backups. Learn how to perform backups and recovery operations. 🔹Practice and Projects: Apply your knowledge through hands-on projects. Practice on platforms like LeetCode, HackerRank, or build your own small database-driven projects. 👀👍Remember to practice regularly and build real-world projects to reinforce your learning. Happy coding!

𝗦𝗤𝗟 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗙𝗼𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀😍 SQL is the backbone of data analytics. Whether you’re cleaning data, generating reports, or exploring trends—SQL helps you turn raw information into actionable insights. 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/43lI7CO Use ChatGPT like a developer — not just a casual user✅️

1. Explain the concept of transfer learning in the context of deep learning models. How can it be beneficial in practical applications? Ans- Transfer learning involves leveraging pre-trained models on large datasets and adapting them to new, related tasks with smaller datasets. In deep learning, this is achieved by reusing the knowledge gained during the training of one model on a different, but related, task. This is particularly beneficial when the new task has limited labeled data. Practical applications include image recognition, where a model pre-trained on a dataset like ImageNet can be fine-tuned for a specific domain. Transfer learning accelerates model convergence, requires less labeled data, and helps overcome the challenges of training deep neural networks from scratch. 2. Given a large dataset, how would you efficiently sample a representative subset for model training? Discuss the trade-offs involved. Answer- To efficiently sample a representative subset, one can use techniques like random sampling or stratified sampling. For random sampling, simple random sampling or systematic sampling methods can be employed. For stratified sampling, data is divided into strata, and samples are randomly selected from each stratum. Trade-offs involve the choice between biased and unbiased sampling. Random sampling may not capture rare events, while stratified sampling might introduce complexity but ensures representation. The size of the sample is also crucial; a too-small sample may not be representative, while a too-large sample may incur unnecessary computational costs. 3. How would you approach analyzing A/B test results to determine the effectiveness of a new feature on a platform like Google Search? Answer: A/B testing involves comparing the performance of two versions (A and B) to determine the impact of a change. To analyze A/B test results: - Define Metrics: Clearly define key metrics (e.g., click-through rate, user engagement) before the test. - Random Assignment: Ensure random assignment of users to control (A) and experimental (B) groups. - Statistical Significance: Use statistical tests (e.g., t-test) to determine if differences between groups are statistically significant. - Practical Significance: Consider the practical significance of results to assess real-world impact. - Segmentation: Analyze results across different user segments for nuanced insights. 4. You have access to search query logs. How would you identify and address potential biases in the search results? Answer: To identify and address biases in search results: - Analyze Demographics: Examine user demographics to identify biases related to age, gender, or location. - Query Intent: Understand user query intent and ensure diverse queries are well-represented. - Evaluate Results: Assess the diversity of results to avoid favoring specific perspectives. - User Feedback: Gather feedback from users to identify biased or inappropriate results. - Continuous Monitoring: Implement continuous monitoring and iterate on algorithms to minimize biases.

𝟱 𝗥𝗲𝗮𝗹-𝗪𝗼𝗿𝗹𝗱 𝗦𝗤𝗟 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 𝘄𝗶𝘁𝗵 𝗗𝗮𝘁𝗮𝘀𝗲𝘁𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗥𝗲𝘀𝘂𝗺𝗲 𝗶𝗻 𝟮𝟬𝟮𝟱😍 📊 Want to Boost Your Resume and Stand Out in Tech Interviews?🗣 SQL is a must-have skill for anyone entering data analytics, business intelligence, or database development📊 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4juyGFR In this post, we’ve handpicked 5 powerful SQL projects using real datasets from industries like e-commerce, healthcare, and sales📌✅️

80% of people who start learning data analytics never land a job. Not because they lack skill but because they get stuck in "preparation mode." I was almost one of them. I spent months: -Taking courses. -Watching YouTube tutorials. -Practicing SQL and Power BI. But when it came time to publish a project or apply for jobs I hesitated. “I need to learn more first.” “My portfolio isn’t ready.” “Maybe next month.” Sound familiar? You don’t need more knowledge you need more execution. Data analysts who build & share projects are 3X more likely to get hired. The best analysts aren’t the smartest. They’re the ones who take action. -They publish dashboards, even if they aren’t perfect. -They post case studies, even when they feel like imposters. -They apply for jobs before they "feel ready" Stop overthinking. Pick a dataset, build something, and share it today. One messy project is worth more than 100 courses you never use.

𝟰 𝗙𝗿𝗲𝗲 𝗣𝘆𝘁𝗵𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗥𝗲𝘀𝘂𝗺𝗲 𝗶𝗻 𝟮𝟬𝟮𝟱😍 Want to Boost Your Resume with In-Demand Python Skills?👨‍💻 In today’s tech-driven world, Python is one of the most in-demand programming languages across data science, software development, and machine learning📊📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3Hnx3wh Enjoy Learning ✅️

Data Analytics Interview Questions