Mad Street Den Data Analyst Interview Questions and Answers

Q1. Window functions
Add your answer
Q2. Joins and aggregate functions
Add your answer
Q3. Abalytical function lag() and lead() question
Add your answer

Q1. Guesstimate and Puzzle
Add your answer

It was a simple case study with a regression problem

Q1. The interview was focused on basics of data analytics and python.
Add your answer
Q2. What is the imp stw in data analytics?
Ans. 
The importance of data analytics lies in its ability to help organizations make informed decisions, identify trends, and improve overall performance.
• Data analytics helps organizations make data-driven decisions

• It allows businesses to identify trends and patterns in data

• Data analytics can improve operational efficiency and performance

• It enables organizations to gain insights and make predictions based on data

• Data analyt...read more
Answered by AI
Add your answer
Q3. What is rank and dense rank
Ans. 
Rank and dense rank are functions used in SQL to assign a rank to each row based on a specified column.
• Rank function assigns a unique rank to each distinct row based on the specified column.

• Dense rank function assigns a unique rank to each distinct row based on the specified column, but does not leave gaps between ranks.

• Example: If we have a table of students with their scores, using rank function will assign ranks lik...read more
Answered by AI
Add your answer
Q4. Advanced excel formulas were asked
Add your answer

They will provide you with dataset and we need to find insights from that

Q1. Why do want to join as a data analyst
Ans. 
I am passionate about uncovering insights from data and using them to drive informed decision-making.
• I have a strong background in statistics and data analysis

• I enjoy working with large datasets and finding patterns within them

• I am excited about the opportunity to make a meaningful impact through data-driven decision-making

• I am proficient in data visualization tools like Tableau and Power BI
Answered by AI
Add your answer

There was a data with some 6000 rows and we have to derive 5 useful insights from it

To know yourself like it was a kind of OPQ

Q1. Tjere was a questions on what is data analysis,how we do it,wep scrapper ,data crawling
Add your answer

Q1. It was a discussion with CEO of company
Add your answer

Q1. It was basic data analyst non technical quesions
Add your answer

Q1. Salary Discussion
Add your answer

Q1. Create the pivot table, sort the data in ascending order
Ans. 
Create a pivot table and sort the data in ascending order.
• To create a pivot table, select the data range and go to the 'Insert' tab in Excel.

• Choose 'PivotTable' and select the location for the pivot table.

• Drag the desired fields to the 'Rows' and 'Values' areas.

• To sort the data in ascending order, click on the drop-down arrow next to the field name in the pivot table and select 'Sort A to Z'.
Answered by AI
View 4 more answers
Q2. Use lookup with the product based given data and find the needed data
Ans. 
Using lookup with product-based data to find the needed data.
• Use a lookup function like VLOOKUP or INDEX/MATCH to search for the needed data

• Identify the key or unique identifier to match the data

• Specify the range or table where the data is located

• Retrieve the desired data based on the lookup value
Answered by AI
View 2 more answers

Q1. Intermediate SQL questions
Add your answer
Q2. Pivot and Vlookup questions
Add your answer

How many cars are sold in your city in a month and questions on the projects I have done in my previous organisation

Q1. Basic SQL and Python
Add your answer

Q1. Behavioral Questions
Add your answer

Q1. Company fit questions
Add your answer