Data Analyst Interview Resources

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 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. 4. 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. 5. State some ways to improve the performance of Tableau? Use an Extract to make workbooks run faster. Reduce the scope of data to decrease the volume of data. Reduce the number of marks on the view to avoid information overload. Hide unused fields. Use Context filters. Use indexing in tables and use the same fields for filtering. Remove unnecessary calculations and sheets.

Data Analyst Remote Job will be posted in this channel today 👇👇 https://t.me/jobs_SQL

Free Resources for Numpy and Pandas: Codebasics Numpy playlist:  https://www.youtube.com/playlist?list=PLeo1K3hjS3uset9zIVzJWqplaWBiacTEU Codebasics pandas playlist (first 9):  https://www.youtube.com/playlist?list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy Freecodecamp matplotlib playlist:  https://youtu.be/3Xc3CA655Y4 Seaborn tutorials:  https://youtu.be/GcXcSZ0gQps Pandas for beginners https://t.me/datasciencefun/660 Numpy for beginners https://t.me/datasciencefree/156

Amazon Data Analyst Interview Questions for 1-3 years of experience role :- A. SQL: 1. You have two tables: Employee and Department. - Employee Table Columns: Employee_id, Employee_Name, Department_id, Salary - Department Table Columns: Department_id, Department_Name, Location Write an SQL query to find the name of the employee with the highest salary in each location. 2. You have two tables: Orders and Customers. - Orders Table Columns: Order_id, Customer_id, Order_Date, Amount - Customers Table Columns: Customer_id, Customer_Name, Join_Date Write an SQL query to calculate the total order amount for each customer who joined in the current year. The output should contain Customer_Name and the total amount. B. Python: 1. Basic oral questions on NumPy (e.g., array creation, slicing, broadcasting) and Matplotlib (e.g., plot types, customization). 2. Basic oral questions on pandas (like: groupby, loc/iloc, merge & join, etc.) 2. Write the code in NumPy and Pandas to replicate the functionality of your answer to the second SQL question. C. Leadership or Situational Questions: (Based on the leadership principle of Bias for Action) - Describe a situation where you had to make a quick decision with limited information. How did you proceed, and what was the outcome? (Based on the leadership principle of Dive Deep) - Can you share an example of a project where you had to delve deeply into the data to uncover insights or solve a problem? What steps did you take, and what were the results? (Based on the leadership principle of Customer Obsession) - Tell us about a time when you went above and beyond to meet a customer's needs or expectations. How did you identify their requirements, and what actions did you take to deliver exceptional service? D. Excel: Questions on advanced functions like VLOOKUP, XLookup, SUMPRODUCT, INDIRECT, TEXT functions, SUMIFS, COUNTIFS, LOOKUPS, INDEX & MATCH, AVERAGEIFS. Plus, some basic questions on pivot tables, conditional formatting, data validation, and charts. I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://topmate.io/analyst/861634 Like if it helps :)

Some Imp Scenario Q & A for product based Company : You are a data analyst at a logistics company. The company wants to analyze delivery performance and customer satisfaction. Your tasks are: 1. Identify late deliveries and their impact on customer satisfaction. 2. Calculate the average delivery time for each region. 3. Create a Power BI report to visualize delivery performance and identify areas for improvement Answer: SQL Queries to Retrieve Data 1. Identify Late Deliveries and Their Impact on Customer Satisfaction: SELECT d.DeliveryID, d.CustomerID, d.DeliveryDate, d.ExpectedDeliveryDate, d.DeliveryTime, c.SatisfactionScore FROM Deliveries d JOIN Customers c ON d.CustomerID = c.CustomerID WHERE d.DeliveryDate > d.ExpectedDeliveryDate; 2. Calculate the Average Delivery Time for Each Region: SELECT Region, AVG(DATEDIFF(day, OrderDate, DeliveryDate)) AS AvgDeliveryTime FROM Deliveries GROUP BY Region; 3. Customer Satisfaction by Delivery Performance: SELECT DeliveryPerformance, AVG(SatisfactionScore) AS AvgSatisfactionScore FROM ( SELECT d.CustomerID, c.SatisfactionScore, CASE WHEN d.DeliveryDate <= d.ExpectedDeliveryDate THEN 'On Time' ELSE 'Late' END AS DeliveryPerformance FROM Deliveries d JOIN Customers c ON d.CustomerID = c.CustomerID ) AS DeliveryData GROUP BY DeliveryPerformance; Import Data into Power BI 1. Load Data: Open Power BI Desktop. Use the "Get Data" feature to connect to your SQL database. Import the result sets from the SQL queries into Power BI. 2. Create Relationships (if necessary): Ensure that the data tables are properly related, such as linking the Deliveries table to the Customers table. Create Visualizations 1. Late Deliveries and Their Impact on Customer Satisfaction: Create a table visual. Drag DeliveryID, CustomerID, DeliveryDate, ExpectedDeliveryDate, DeliveryTime, and SatisfactionScore to the Values. 2. Average Delivery Time for Each Region: Create a bar chart. Drag Region to the Axis. Drag AvgDeliveryTime to the Values. 3. Customer Satisfaction by Delivery Performance: Create a bar chart. Drag DeliveryPerformance to the Axis. Drag AvgSatisfactionScore to the Values. 4. Overall Delivery Analysis: Create a pie chart. Drag Region to the Legend. Drag AvgDeliveryTime to the Values. Optimize Performance 1. Data Model Optimization: Filter data to include only necessary columns and rows. Use summarized tables to pre-aggregate data. 2. DAX Optimization: Create measures for dynamic calculations. Simplify DAX formulas to improve performance. 3. Visualization Optimization: Limit the number of visuals per page. Avoid excessive use of slicers or custom visuals that can impact performance. I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://topmate.io/analyst/861634 Like if it helps :)

TOP CONCEPTS FOR INTERVIEW PREPARATION!! 🚀TOP 10 SQL Concepts for Job Interview 1. Aggregate Functions (SUM/AVG) 2. Group By and Order By 3. JOINs (Inner/Left/Right) 4. Union and Union All 5. Date and Time processing 6. String processing 7. Window Functions (Partition by) 8. Subquery 9. View and Index 10. Common Table Expression (CTE) 🚀TOP 10 Statistics Concepts for Job Interview 1. Sampling 2. Experiments (A/B tests) 3. Descriptive Statistics 4. p-value 5. Probability Distributions 6. t-test 7. ANOVA 8. Correlation 9. Linear Regression 10. Logistics Regression 🚀TOP 10 Python Concepts for Job Interview 1. Reading data from file/table 2. Writing data to file/table 3. Data Types 4. Function 5. Data Preprocessing (numpy/pandas) 6. Data Visualisation (Matplotlib/seaborn/bokeh) 7. Machine Learning (sklearn) 8. Deep Learning (Tensorflow/Keras/PyTorch) 9. Distributed Processing (PySpark) 10. Functional and Object Oriented Programming Like ❤️ the post if it was helpful to you!!!

1. What are the various types of refresh options provided in Power BI? Package refresh - This synchronizes your Power BI Desktop or Excel file between the Power BI service and OneDrive, or SharePoint Online. Model or data refresh - This refreshes the dataset within the Power BI service with data from the original data source. Tile refresh - This updates the cache for tile visuals every 15 minutes on the dashboard once data changes. Visual container refresh - This refreshes the visible container and updates the cached report visuals within a report once the data changes. 2. Explain some date manipulation functions in SQL. Getdate: As its name suggests, the getdate function gives us today’s date. Dateadd: The dateadd function is used for adding a time or date interval to a date.Datediff: The datediff function is used for calculating the difference between two dates based on a given interval. Datename: The datename function can be used for extracting the parts of a date. Year, month, day: The year, month, and day functions allow for decomposing a date. 3. What is CTE in SQL? A CTE (Common Table Expression) is a one-time result set that only exists for the duration of the query. It allows us to refer to data within a single SELECT, INSERT, UPDATE, DELETE, CREATE VIEW, or MERGE statement's execution scope. It is temporary because its result cannot be stored anywhere and will be lost as soon as a query's execution is completed.

I'm sure you had an idea, but something got in the way and you didn't develop it. The channel "Usual thing" is about this, the author tries to implement different business ideas, but every day he encounters problems and discusses them with you. https://t.me/usual_thing

Statistical interview questions for entry-level data analyst roles in an MNC. 1. Explain the difference between mean, median, and mode. When would you use each? 2. How do you calculate the variance and standard deviation of a dataset? 3. What is skewness and kurtosis? How do they help in understanding data distribution? 4. What is the central limit theorem, and why is it important in statistics? 5. Describe different types of probability distributions (e.g., normal, binomial, Poisson). 6. Explain the difference between a population and a sample. Why is sampling important? 7. What are null and alternative hypotheses? How do you formulate them? 8. Describe the steps in conducting a hypothesis test. 9. What is a p-value? How do you interpret it in the context of a hypothesis test? 10. When would you use a t-test versus a z-test? 11. Explain how you would conduct an independent two-sample t-test. What assumptions must be met? 12. Describe a scenario where you would use a paired sample t-test. 13. What is ANOVA, and how does it differ from a t-test? 14. Explain how you would interpret the results of a one-way ANOVA. 15. Describe a situation where you might use a two-way ANOVA. 16. What is a chi-square test for independence? When would you use it? 17. How do you interpret the results of a chi-square goodness-of-fit test? 18. Explain the assumptions and limitations of chi-square tests. 19. What is the difference between simple linear regression and multiple regression? 20. How do you assess the goodness-of-fit of a regression model? 21. Explain multicollinearity and how you would detect and handle it in a regression model. 22. What is the difference between correlation and causation? 23. How do you interpret the Pearson correlation coefficient? 24. When would you use Spearman rank correlation instead of Pearson correlation? 25. What are some common methods for forecasting time series data? 26. Explain the components of a time series (trend, seasonality, residuals). 27. How would you handle missing data in a time series dataset? 28. Describe your approach to exploratory data analysis (EDA). 29. How do you handle outliers in a dataset? 30. Explain the steps you would take to validate the results of your analysis. 31. Give an example of how you have used statistical analysis to solve a real-world problem I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://topmate.io/analyst/861634 Hope this helps you 😊

If you want to earn 6-figures working as a data analyst, learn these 6 important skills: Excel - advanced Excel functions for data manipulation and interpretation. Data Cleaning is about mastering data preprocessing and cleaning techniques. Python/R - data analysis, preparation and manipulation Statistical Analysis - understanding fundamental statistics for data Data Visualization - clear and effective visual representations of data SQL - querying and managing databases efficiently

If you are a data analyst and thinking of getting started with freelancing on upwork then here's something you should know. You should be ready to invest money if you want to get started with freelancing on upwork. So there's something called connects on Upwork. For simplicity you can consider connects as the currency of upwork which one will spend while submitting a proposal for the freelancing tasks listed on the platform. Previously upwork used to give some free connects to every new account but these days they don't. So you have to buy the connects at the rate of 100 connects per $15 + Taxes (without upgrading to upwork plus) which will be 1.3k + taxes in INR. Let's say you submit proposal for those jobs asking for 20 connects, the max you will be able to submit is 5 jobs and you will get the job or not again depend on many factors. You may end up having no jobs even after spending 100 connects and then again you have to repeat the cycle. Everything looks shiny from outside but reality can be different. Every platform requires investment either in the form of time, dedication, money or combination of all.

Best practices for writing SQL queries: Join for more: https://t.me/learndataanalysis 1- Write SQL keywords in capital letters. 2- Use table aliases with columns when you are joining multiple tables. 3- Never use select *, always mention list of columns in select clause. 4- Add useful comments wherever you write complex logic. Avoid too many comments. 5- Use joins instead of subqueries when possible for better performance. 6- Create CTEs instead of multiple sub queries , it will make your query easy to read. 7- Join tables using JOIN keywords instead of writing join condition in where clause for better readability. 8- Never use order by in sub queries , It will unnecessary increase runtime. 9- If you know there are no duplicates in 2 tables, use UNION ALL instead of UNION for better performance. SQL Basics: https://t.me/sqlanalyst/105

WebScraping with Gen AI During this session, we'll explore the following topics: 1️⃣ Basics of Web Scraping: Understand the fundamental concepts and techniques of web scraping and its legal and ethical considerations. 2️⃣ Scraping with Gen AI: Discover how Gen AI revolutionizes the web scraping landscape with real-world examples. 3️⃣ Jina Reader API: Get acquainted with the Jina Reader API, a powerful tool for obtaining LLM-friendly input from URLs or web searches. 4️⃣ ScrapeGraphAI: Dive into ScrapeGraphAI, a groundbreaking Python library that combines LLMs and direct graph logic for creating robust scraping pipelines. Event Details: 🗓 Date: 22 June, Saturday ⏰ Time: 11:00 AM IST 🔗 Register now: https://www.buildfastwithai.com/events/web-scraping-with-gen-ai Connect with Founder from IIT Delhi; https://www.linkedin.com/in/satvik-paramkusham/

Here are some Statistics Interview Questions for Data analyst Interview Que 1. What Is the Difference Between Inferential Statistics and Descriptive Statistics? Ans 1. The difference between inferential statistics and descriptive statistics is that inferential statistics are used to draw conclusions about a population based on the data you’ve collected. In contrast, descriptive statistics are used to summarize your data. Que 2. What Is the Difference Between Quantitative Data and Qualitative Data? Ans 2. Quantitative data is numerical data that can be measured, counted, and expressed as a percentage. Qualitative data is non-numerical information that describes subjective experiences or opinions about an event or topic. Que 3. How Do You Calculate Range and Interquartile Range? Ans 3. Range and interquartile range are two ways to calculate the spread of data. The range is the difference between the highest and lowest value in a set of data. The interquartile range is the difference between the 75th percentile and 25th percentile of a set of data. Que 4. Explain Pareto Principle Ans 4. The Pareto Principle, also known as the 80-20 rule, is a principle that states that 20% of causes are responsible for 80% of effects. Que 5. What Are Left-Skewed Distribution and Right-Skewed Distribution? Ans 5. Left-skewed distributions have a longer tail to the left (lower values), while right-skewed distributions have a longer tail to the right (higher values). Que 6. What Is an Outlier, and How Can You Find One? Ans 6. An outlier is an observation point that is distant from other data points. It’s important to note that the term “outlier” doesn’t refer to the numerical value of a data point but rather the distance between it and all other values. Que 7. What Are Skewness and Kurtosis? Ans 7. Skewness is an excellent way to measure the symmetry of distribution and the likelihood of a given value falling in the tails. With symmetrical distribution, the mean and median coincide. If the data distribution isn’t symmetrical, it’s skewed. There are two types of skewness: Positive is when the right tail is longer. Most values are clustered around the left tail, and the median is smaller than the mean. Negative is when the left tail is longer. Most values are clustered around the right tail, and the median is greater than the mean Kurtosis, on the other hand, reveals how heavy or light-tailed data is compared to the normal distribution. There are three types of kurtoses: Mesokurtic distributions approximate a normal distribution. Leptokurtic distributions have a pointy shape and heavy tails, indicating a high probability of extreme events occurring. Platykurtic distributions have a flat shape and light tails. They reveal a low probability of the occurrence of extreme events.

How to become a "Data Analyst" in 36 weeks? Here's the plan - ☞ Microsoft Excel (First 18 Weeks) (Mon-Fri) ☞ Power BI (Next 18 Weeks) (Mon-Fri) ☞ SQL (All 36 weeks) (Sat & Sun) Important Point :- ➜ Spend 2.5 hour's ( Mon - Fri) ➜ Spend 4 hour's ( Sat & Sun) ➜ Follow the Limited resources to avoid Confusion I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://topmate.io/analyst/861634 Like if it helps :)