AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Mad Street Den Data Analyst Interview Questions and Answers
Mad Street Den Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via campus placement at Sri Venkateswara College of Engineering, Chennai and was interviewed before Nov 2023. There were 3 interview rounds.
Basic Aptitude (prob, )
(1 Question)
- Q1. Basic sql and exel
(1 Question)
- Q1. Tell me about your self
Top trending discussions
Interview questions from similar companies
They will provide you with dataset and we need to find insights from that
(1 Question)
- 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
Coding test with simple questions, related to the role
Interview Preparation Tips
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
Half hour test,was held in coderank.
Selected
I applied via Job Fair and was interviewed before Apr 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Walk through on the project you had worked on as a data engineer in azure environment.
- Ans.
Developed a data pipeline in Azure for real-time analytics on customer behavior.
Designed and implemented data ingestion process using Azure Data Factory
Utilized Azure Databricks for data transformation and analysis
Implemented Azure SQL Database for storing processed data
Developed Power BI dashboards for visualization of insights
- Q2. Scenario based question on SQL and Azure data factory
(2 Questions)
- Q1. Understanding on different schema like star and snowflake schema, Dimension and fact table.
- Q2. Questions on Advance SQL
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed before Oct 2023. There were 2 interview rounds.
(1 Question)
- Q1. It was basic data analyst non technical quesions
(1 Question)
- Q1. Salary Discussion
Coding test with simple questions, related to the role
Interview Preparation Tips
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
(1 Question)
- Q1. Tjere was a questions on what is data analysis,how we do it,wep scrapper ,data crawling
(1 Question)
- Q1. It was a discussion with CEO of company
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 3 interview rounds.
It was a simple case study with a regression problem
(4 Questions)
- Q1. The interview was focused on basics of data analytics and python.
- 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...
- 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...
- Q4. Advanced excel formulas were asked
Skills evaluated in this interview
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
(1 Question)
- Q1. Tjere was a questions on what is data analysis,how we do it,wep scrapper ,data crawling
(1 Question)
- Q1. It was a discussion with CEO of company
Interview Preparation Tips
Mad Street Den Interview FAQs
Tell us how to improve this page.
Mad Street Den Interviews By Designations
- Mad Street Den Backend Developer Interview Questions
- Mad Street Den Data Analyst Interview Questions
- Mad Street Den Front end Engineer Interview Questions
- Mad Street Den Full Stack Developer Interview Questions
- Mad Street Den Graphic Designer Interview Questions
- Mad Street Den HR Intern Interview Questions
- Mad Street Den Junior Backend Developer Interview Questions
- Mad Street Den Machine Learning Intern Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Mad Street Den Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Mad Street Den Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Graphic Designer
53
salaries
|  ₹2.3 L/yr - ₹4.8 L/yr |
|
Senior Graphic Designer
16
salaries
| ₹3.3 L/yr - ₹7.2 L/yr |
|
Machine Learning Engineer
14
salaries
| ₹8 L/yr - ₹17.5 L/yr |
|
Image Editor
7
salaries
| ₹3 L/yr - ₹3.8 L/yr |
|
Data Analyst
6
salaries
| ₹3 L/yr - ₹10 L/yr |
Myntra
Flipkart
Paytm
Snapdeal
- Home >
- Interviews >
- Mad Street Den Interview Questions >
- Mad Street Den Data Analyst Interview Questions
