Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Dilyt Team. If you also belong to the team, you can get access from here

Dilyt Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Dilyt Data Analyst Interview Questions, Process, and Tips

Updated 19 Jul 2024

Dilyt Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 19 Jul 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

(1 Question)

  • Q1. Basic mathematics question, basic English and SQL questions
Round 2 - Technical 

(5 Questions)

  • Q1. Resume based questions
  • Q2. Different types of commands
  • Ans. 

    Different types of commands include data manipulation, data definition, data control, and transaction control commands.

    • Data manipulation commands: SELECT, INSERT, UPDATE, DELETE

    • Data definition commands: CREATE, ALTER, DROP

    • Data control commands: GRANT, REVOKE

    • Transaction control commands: COMMIT, ROLLBACK, SAVEPOINT

  • Answered by AI
  • Q3. Difference between inner join and outer join
  • Ans. 

    Inner join returns only the matching rows between two tables, while outer join returns all rows from both tables.

    • Inner join only includes rows that have matching values in both tables

    • Outer join includes all rows from both tables, filling in missing values with NULL if there is no match

    • Examples: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id; Outer join - SELECT * FROM table1 LEFT OUTER JOI

  • Answered by AI
  • Q4. Write SQL query to get second highest salary
  • Ans. 

    SQL query to retrieve the second highest salary from a table

    • Use the ORDER BY clause to sort salaries in descending order

    • Use the LIMIT clause to retrieve the second row

  • Answered by AI
  • Q5. What's the difference between numpy and pandas
  • Ans. 

    Numpy is a library for numerical operations in Python, while Pandas is used for data manipulation and analysis.

    • Numpy is used for numerical operations like linear algebra, Fourier transform, etc.

    • Pandas is used for data manipulation tasks like data cleaning, merging, reshaping, etc.

    • Numpy works with arrays, while Pandas works with dataframes.

    • Numpy is more efficient for numerical computations, while Pandas is more user-fri...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Dilyt Data Analyst interview:
  • SQL
  • Python

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed before May 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Pivot table in excel
  • Ans. 

    Pivot table is a data summarization tool in Excel.

    • Pivot table allows users to summarize and analyze large datasets.

    • It can be used to group data by categories, calculate totals, and create custom calculations.

    • Users can easily change the layout of the table to view data in different ways.

    • Pivot table is a powerful tool for data analysis and reporting.

    • Example: A sales manager can use pivot table to analyze sales data by re

  • Answered by AI
  • Q2. How to count data in excel
  • Ans. 

    To count data in Excel, use the COUNT function or select the data and look at the status bar.

    • Use the COUNT function to count the number of cells that contain numbers or dates

    • Use the COUNTA function to count the number of cells that are not empty

    • Select the data and look at the status bar to see the count of selected cells

    • Use the COUNTIF function to count cells that meet a specific criteria

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It’s was good

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL Test with 5 questions

Round 2 - Technical 

(2 Questions)

  • Q1. Approach towards solving the SQL Queries from the test
  • Q2. Past Experiences
Round 3 - One-on-one 

(2 Questions)

  • Q1. Resume related Questions
  • Q2. Power BI and SQL related questions. How to approach in a dashboard building process

Interview Questionnaire 

1 Question

  • Q1. Situation based question on experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for what is in CV

I applied via Referral and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Related to work profile
  • Q2. Related to interests

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, go well groomed

Interview Questionnaire 

1 Question

  • Q1. SDLC Model

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice interview
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Who is a BA Role of a BA Scenario based questions Questions in area of interest Questions on project
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions but less time to solve.

Round 2 - Group Discussion 

Basic topics given such as social media and work life balance.

Round 3 - HR 

(2 Questions)

  • Q1. Self introduction
  • Q2. Why did you choose our company?
  • Ans. 

    I chose your company because of its reputation for innovation and commitment to employee development.

    • Impressed by the company's track record of successful projects

    • Positive reviews from current and former employees

    • Opportunities for growth and advancement within the company

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Normal question about past experience
  • Q2. When you can join and all
Round 2 - Assignment 

SQL test on Select query, insert, create

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - HR 

(4 Questions)

  • Q1. About ourselves
  • Q2. Professional experience
  • Q3. Salary expectation
  • Q4. Notice period, if experienced

Dilyt Interview FAQs

How many rounds are there in Dilyt Data Analyst interview?
Dilyt interview process usually has 2 rounds. The most common rounds in the Dilyt interview process are Technical and Aptitude Test.
What are the top questions asked in Dilyt Data Analyst interview?

Some of the top questions asked at the Dilyt Data Analyst interview -

  1. What's the difference between numpy and pan...read more
  2. Difference between inner join and outer j...read more
  3. Write SQL query to get second highest sal...read more

Tell us how to improve this page.

Dilyt Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

HCL Infosystems Interview Questions
3.9
 • 140 Interviews
Pitney Bowes Interview Questions
3.8
 • 21 Interviews
Diverse Lynx Interview Questions
3.8
 • 19 Interviews
DynPro Interview Questions
3.8
 • 18 Interviews
View all
BI Developer
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

ETL Developer
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Intelligence Developer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
5 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Executive
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Dilyt with

HCL Infosystems

3.9
Compare

Accel Frontline

4.0
Compare

Diverse Lynx

3.8
Compare

Pitney Bowes

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