Upload Button Icon Add office photos

Filter interviews by

Mep Media Junior Data Analyst Interview Questions, Process, and Tips

Updated 4 Jan 2025

Mep Media Junior Data Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - HR 

(11 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a recent graduate with a degree in Data Science and a passion for analyzing and interpreting data to drive business decisions.

    • Recent graduate with a degree in Data Science

    • Passionate about analyzing and interpreting data

    • Strong skills in statistical analysis and data visualization

    • Experience with programming languages such as Python and R

    • Completed internships in data analysis roles

  • Answered by AI
  • Q2. What is power Bi
  • Ans. 

    Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.

    • Developed by Microsoft

    • Allows users to create interactive visualizations and reports

    • Integrates with various data sources such as Excel, SQL databases, and cloud services

    • Enables data exploration and sharing insights with stakeholders

    • Offers features like dashboards, data connections, and data

  • Answered by AI
  • Q3. What is SQL
  • Ans. 

    SQL is a programming language used for managing and manipulating relational databases.

    • SQL stands for Structured Query Language

    • It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables

    • Common SQL commands include SELECT, INSERT, UPDATE, DELETE

    • Example: SELECT * FROM table_name WHERE condition;

  • Answered by AI
  • Q4. Hobbie and skills
  • Q5. What is ETL
  • Ans. 

    ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a data warehouse for analysis.

    • Extract: Data is extracted from multiple sources such as databases, files, APIs, etc.

    • Transform: Data is cleaned, standardized, and transformed into a consistent format suitable for analysis.

    • Load: The transformed data is loaded into a da...

  • Answered by AI
  • Q6. Type of keys
  • Ans. 

    Types of keys in data analysis include primary keys, foreign keys, and composite keys.

    • Primary key uniquely identifies each record in a table (e.g. customer ID)

    • Foreign key links two tables together (e.g. customer ID in orders table)

    • Composite key consists of multiple columns to uniquely identify a record (e.g. combination of customer ID and order ID)

  • Answered by AI
  • Q7. What is join
  • Ans. 

    Join is a SQL operation used to combine rows from two or more tables based on a related column between them.

    • Join is used to retrieve data from multiple tables based on a related column.

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

  • Answered by AI
  • Q8. What is RLS
  • Q9. Cross join vs outer join
  • Ans. 

    Cross join produces Cartesian product of two tables, while outer join combines rows from two tables based on a related column.

    • Cross join returns all possible combinations of rows from two tables.

    • Outer join combines rows from two tables based on a related column, including unmatched rows with NULL values.

    • Example: Cross join - SELECT * FROM table1 CROSS JOIN table2

    • Example: Outer join - SELECT * FROM table1 LEFT JOIN tabl

  • Answered by AI
  • Q10. What is fact & dimensions
  • Ans. 

    Facts are measurable data points, while dimensions provide context to the facts by categorizing and organizing them.

    • Facts are quantitative data that can be measured or counted.

    • Dimensions provide context to the facts by categorizing and organizing them.

    • In a sales database, the fact could be the total revenue generated, while dimensions could include product category, region, and time period.

  • Answered by AI
  • Q11. Explain the difference between `TRUNCATE`, `DELETE`, and `DROP` commands.
  • Ans. 

    TRUNCATE removes all rows from a table, DELETE removes specific rows, and DROP deletes the entire table structure.

    • TRUNCATE is faster than DELETE as it does not log individual row deletions.

    • DELETE is slower than TRUNCATE as it logs each row deletion.

    • DROP removes the entire table structure along with all data.

    • TRUNCATE and DELETE can be rolled back, but DROP cannot be rolled back.

    • Example: TRUNCATE table_name;

    • Example: DELE...

  • Answered by AI
Round 2 - Technical 

(15 Questions)

  • Q1. What is SQL, and why is it important in data analytics
  • Ans. 

    SQL is a programming language used for managing and analyzing data in relational databases.

    • SQL stands for Structured Query Language

    • It is used to retrieve, manipulate, and analyze data stored in relational databases

    • SQL is important in data analytics as it allows analysts to query databases to extract relevant information for analysis

    • It helps in filtering, sorting, and aggregating data to generate insights

    • Examples of SQL...

  • Answered by AI
  • Q2. Explain the difference between 'INNER JOIN', 'LEFT JOIN`, `RIGHT JOIN`, and `FULL OUTER JOIN`.
  • Ans. 

    Different types of SQL joins used to combine rows from two or more tables based on a related column between them.

    • INNER JOIN: Returns rows when there is at least one match in both tables.

    • LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.

    • RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.

    • FULL OUTER JOIN: Returns all rows when there is a match

  • Answered by AI
  • Q3. What is the difference between 'WHERE` and 'HAVING` clauses
  • Ans. 

    WHERE clause is used to filter rows before grouping, while HAVING clause is used to filter groups after grouping.

    • WHERE clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

    • HAVING clause is used with SELECT statement to filter groups based on a condition

    • WHERE clause is applied before the data is grouped, while HAVING clause is applied after the data is grouped

    • Example: SELECT * FROM ta...

  • Answered by AI
  • Q4. Difference between Append and Merged
  • Ans. 

    Append adds rows to a dataset, while Merge combines datasets based on a common key.

    • Append adds rows to the bottom of a dataset, increasing the number of observations.

    • Merge combines datasets based on a common key, such as a unique identifier or variable.

    • Appending is useful for adding new data, while merging is useful for combining related datasets.

    • Example: Appending a new month of sales data to an existing dataset. Merg...

  • Answered by AI
  • Q5. Row-level Security and 4 role in power Bi
  • Ans. 

    Row-level security in Power BI allows restricting access to specific rows of data based on user roles.

    • Row-level security in Power BI is used to control access to data at the row level based on user roles.

    • Roles in Power BI define the level of access users have to data and reports.

    • Examples of roles in Power BI include Admin, Analyst, Viewer, and Contributor.

    • By setting up row-level security, users can only see the data th...

  • Answered by AI
  • Q6. Schedule Refresh & Gateways
  • Q7. What are BookMarks, use of it
  • Ans. 

    Bookmarks are digital markers used to quickly navigate to specific sections or pages within a document or website.

    • Bookmarks allow users to easily access important or frequently visited sections of a document or website.

    • They are commonly used in web browsers to save specific web pages for quick access.

    • Bookmarks can also be used in PDF documents to mark important pages or sections for easy reference.

  • Answered by AI
  • Q8. Difference between Duplicate & Reference
  • Ans. 

    Duplicate refers to an exact copy, while reference is a pointer to the original object.

    • Duplicate is a separate copy of the original data, while reference points to the original data.

    • Changing a duplicate does not affect the original, but changing a reference does.

    • Duplicates consume more memory than references.

    • Example: Duplicate - making a photocopy of a document. Reference - sharing a link to a document.

    • Example: Duplica...

  • Answered by AI
  • Q9. Results of Left Join, Right Join and Cross Join
  • Ans. 

    Left Join includes all records from the left table and matching records from the right table. Right Join includes all records from the right table and matching records from the left table. Cross Join combines all records from both tables.

    • Left Join: Includes all records from the left table and matching records from the right table.

    • Right Join: Includes all records from the right table and matching records from the left t...

  • Answered by AI
  • Q10. What are Indexing, it's types and use of it
  • Ans. 

    Indexing is a technique used to optimize data retrieval in databases by creating indexes on columns.

    • Types of indexing include clustered and non-clustered indexes

    • Clustered indexes physically reorder the data in the table based on the index key

    • Non-clustered indexes create a separate structure to store the index key and a pointer to the actual data

    • Indexes are used to speed up data retrieval operations such as SELECT queri

  • Answered by AI
  • Q11. Difference between Union & Union all
  • Ans. 

    Union combines and removes duplicates, Union all combines without removing duplicates.

    • Union combines result sets and removes duplicates

    • Union all combines result sets without removing duplicates

    • Union is slower than Union all as it involves removing duplicates

    • Union all is faster than Union as it does not remove duplicates

  • Answered by AI
  • Q12. How to find 3rd Highest Salary, Marks
  • Ans. 

    To find the 3rd highest salary or marks, you can use SQL query with ORDER BY and LIMIT.

    • Use SQL query with ORDER BY to sort the salaries or marks in descending order

    • Use LIMIT 2,1 to skip the first two highest salaries or marks and get the third highest

  • Answered by AI
  • Q13. How do you use 'PARTITION BY` and `ORDER BY in window functions
  • Ans. 

    PARTITION BY is used to divide the result set into partitions, while ORDER BY is used to sort the rows within each partition in window functions.

    • PARTITION BY is used to group rows with the same values in specified columns

    • ORDER BY is used to sort the rows within each partition

    • Example: SELECT column1, column2, SUM(column3) OVER (PARTITION BY column1 ORDER BY column2) AS total FROM table_name

  • Answered by AI
  • Q14. Explain window functions like `ROW_NUMBER()`, `RANK()`, and `DENSE_RANK()`.
  • Ans. 

    Window functions like ROW_NUMBER(), RANK(), and DENSE_RANK() assign a unique number to each row based on specified criteria.

    • ROW_NUMBER() assigns a unique sequential integer starting from 1 to each row within a partition

    • RANK() assigns a unique rank to each row within a partition, with no gaps in ranking if there are ties

    • DENSE_RANK() assigns a unique rank to each row within a partition, with possible gaps in ranking if t

  • Answered by AI
  • Q15. Workspace & App
Round 3 - HR 

(4 Questions)

  • Q1. What work did you find most difficult
  • Ans. 

    I found data cleaning and manipulation to be the most difficult part of my work.

    • Understanding and cleaning messy data sets

    • Manipulating data to fit the required format

    • Dealing with missing or inconsistent data

    • Creating new variables or features from existing data

    • Ensuring data quality and accuracy

  • Answered by AI
  • Q2. Why should we hire you
  • Ans. 

    I have a strong analytical background, excellent problem-solving skills, and a passion for data-driven decision making.

    • I have a degree in Statistics and experience with data analysis tools such as Python and SQL.

    • I have successfully completed projects where I analyzed large datasets to provide actionable insights.

    • I am detail-oriented and have a proven track record of delivering accurate and timely results.

  • Answered by AI
  • Q3. Where do you see yourself in 5 years
  • Ans. 

    In five years, I see myself as a Senior Data Analyst leading a team and working on more complex projects.

    • Advancing to a Senior Data Analyst role

    • Leading a team of junior analysts

    • Working on more complex and challenging projects

    • Continuing to learn and grow in the field of data analysis

  • Answered by AI
  • Q4. Salery discussion

Interview Preparation Tips

Topics to prepare for Mep Media Junior Data Analyst interview:
  • Power Bi
  • SQL
Interview preparation tips for other job seekers - Answer with patience and listen to the questions carefully, maintain confidence, be honest and don't get scared

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Sep 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

Entry level aptitude test

Round 3 - One-on-one 

(1 Question)

  • Q1. Introduction and about college project.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a really good experience working in TCS

I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL, Business cases

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with examples for each of the 14 principles

I applied via Walk-in and was interviewed before Sep 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

Reasoning and English

Round 2 - Group Discussion 

Just a minute round about favourite movie

Round 3 - Technical 

(1 Question)

  • Q1. SD , about education questions
Round 4 - HR 

(1 Question)

  • Q1. Regarding shifts, timings and relocation

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best guys. It's very is to crack the interview in TCS

I was interviewed before Jun 2016.

Interview Preparation Tips

Round: Video interview
Experience: Tell about why to join cognizant

Skills: Communication Networks, Communication

I was interviewed in Aug 2017.

Interview Preparation Tips

Round: Group Discussion
Experience: every one put their views
Tips: just tell anything. no one listen
Duration: 5 minutes

Round: Test
Experience: online test
Tips: do those question which can be solved without usingpen paper first
Duration: 5 minutes
Total Questions: 50

Skills: Relieving Pressure

Interview Questionnaire 

3 Questions

  • Q1. What is autocorrelation?
  • Ans. 

    Autocorrelation is the correlation of a signal with a delayed copy of itself.

    • Autocorrelation is used to identify patterns in time series data.

    • It is a measure of how similar a signal is to a delayed version of itself.

    • Autocorrelation can be positive, negative, or zero.

    • It is commonly used in signal processing, finance, and econometrics.

    • Autocorrelation can be visualized using a correlogram.

  • Answered by AI
  • Q2. What is heteroscedasticity?
  • Ans. 

    Heteroscedasticity is a statistical term that refers to the unequal variance of a variable across different levels of another variable.

    • It is a violation of the assumption of homoscedasticity in regression analysis.

    • It can lead to biased and inefficient estimates of regression coefficients.

    • It can be detected through residual plots or statistical tests such as the Breusch-Pagan test.

    • Examples include income and expenditure...

  • Answered by AI
  • Q3. How do they affect your data analysis?
  • Ans. 

    Data analysis is affected by various factors that can influence the accuracy and reliability of the results.

    • Data quality: The accuracy, completeness, and consistency of the data can impact the analysis.

    • Data sources: The reliability and relevance of the data sources used for analysis can affect the outcomes.

    • Data preprocessing: The way data is cleaned, transformed, and prepared for analysis can impact the results.

    • Data in...

  • Answered by AI

Interview Preparation Tips

Round: Technical + HR Interview
Experience: Most of the questions was based on statistical modelling as the position they were hiring for was business analyst which requires statistical modelling and its business applications.
Tips: Always try to apply your statistical knowledge to the businesses around you. How you can improve that or apply it for better usage.

College Name: Institute of Management Technology

I applied via Walk-in and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Where you see yourself after 5 years

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident whatever u say. This one thing is enough to get judge by interviewer

Interview Questionnaire 

2 Questions

  • Q1. Speak 5 minutes on Delhi metro, Women empowerment, Facebook, Social media, Politics, motivation, trending Etc.
  • Q2. Tell me about your previous day that what you have done from morning to evening?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident because if you are not confident in front of the interviewed then you can't reply properly to any question of him, You should have to be confident.

I applied via Approached by Company and was interviewed in Nov 2018. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions were asked on what was written on resume
  • Q2. Questions were also asked on testing
  • Q3. Complete questions from payments flow and swift msg

Interview Preparation Tips

General Tips: Be aware of what you write on your resume and be confident while answering for the questions.
Skills: Communication, Body Language, Analytical Skills
Duration: <1 week

Mep Media Interview FAQs

How many rounds are there in Mep Media Junior Data Analyst interview?
Mep Media interview process usually has 3 rounds. The most common rounds in the Mep Media interview process are HR and Technical.
What are the top questions asked in Mep Media Junior Data Analyst interview?

Some of the top questions asked at the Mep Media Junior Data Analyst interview -

  1. What is SQL, and why is it important in data analyt...read more
  2. How do you use 'PARTITION BY` and `ORDER BY in window functi...read more
  3. What is the difference between 'WHERE` and 'HAVING` clau...read more

Tell us how to improve this page.

Mep Media Junior Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Compare Mep Media with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview