Add office photos
Employer?
Claim Account for FREE

WNS

3.4
based on 12k Reviews
Video summary
Filter interviews by

Daiviksoft Technologies Interview Questions and Answers

Updated 17 Oct 2024
Popular Designations

Q1. How do u make groups and how bins are different from groups

Ans.

Groups are created by categorizing data based on certain criteria, while bins are specific ranges used to group continuous data.

  • Groups are created by categorizing data based on certain criteria, such as age groups or product categories.

  • Bins are specific ranges used to group continuous data, such as age ranges or income brackets.

  • Groups can be created based on qualitative data, while bins are used for quantitative data.

  • Example: Grouping customers based on their purchase history...read more

Add your answer

Q2. Why do you prefer power bi over tableau

Ans.

Power BI is preferred over Tableau for its seamless integration with Microsoft products and user-friendly interface.

  • Seamless integration with Microsoft products like Excel, SharePoint, and Teams

  • User-friendly interface with drag-and-drop functionality for easy data visualization

  • Cost-effective solution for organizations already using Microsoft products

  • Faster data processing and refreshing capabilities compared to Tableau

  • Robust DAX language for creating complex calculations and ...read more

Add your answer

Q3. How do you use Group By in Power Query?

Ans.

Group By in Power Query is used to aggregate data based on a specific column or columns.

  • Select the column(s) you want to group by

  • Go to the 'Transform' tab and click on 'Group By'

  • Choose the aggregation type and column to aggregate on

  • Rename the new column if needed

Add your answer

Q4. what is SQL server Architecture?

Ans.

SQL Server Architecture refers to the structure and components of the SQL Server database management system.

  • SQL Server Architecture consists of three main components: Database Engine, SQL Server Agent, and SQL Server Browser.

  • The Database Engine is responsible for storing, processing, and securing data.

  • SQL Server Agent handles automation tasks, scheduling jobs, and managing alerts.

  • SQL Server Browser helps clients locate and connect to SQL Server instances.

  • SQL Server Architectu...read more

Add your answer
Discover Daiviksoft Technologies interview dos and don'ts from real experiences

Q5. Difference between Sum and Sumx

Ans.

Sum calculates the total of a column, while Sumx calculates the total of an expression evaluated for each row.

  • Sum is used to calculate the total of a column in a table.

  • Sumx is used to calculate the total of an expression evaluated for each row in a table.

  • Sum: SUM('Table'[Column])

  • Sumx: SUMX('Table', 'Table'[Column] * 2)

Add your answer

Q6. Difference between Sum and SUMX in DAX

Ans.

SUM calculates the total of a column, while SUMX calculates the total of an expression evaluated for each row.

  • SUM is used to calculate the total of a column in a table

  • SUMX is used to calculate the total of an expression evaluated for each row in a table

  • SUMX is often used with iterators like FILTER or RELATEDTABLE to perform calculations on a row-by-row basis

Add your answer

Q7. Guesstimates - Cars in delhi

Ans.

There are approximately 10 million cars in Delhi.

  • Delhi has a population of over 18 million people.

  • The number of cars per household in Delhi is increasing.

  • There are over 1,000 new cars registered in Delhi every day.

  • Traffic congestion is a major issue in Delhi due to the high number of cars.

  • The Delhi government has implemented measures to reduce the number of cars on the road, such as the odd-even rule.

Add your answer

Q8. Difference between list and tuple

Ans.

List is mutable, tuple is immutable in Python.

  • List can be modified after creation, tuple cannot

  • List is defined using square brackets [], tuple using parentheses ()

  • Example: list - [1, 2, 3], tuple - (1, 2, 3)

Add your answer

Q9. What are sql joins

Ans.

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

  • SQL joins are used to retrieve data from multiple tables based on a related column between them

  • Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

  • 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 ...read more

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Daiviksoft Technologies

based on 14 interviews
2 Interview rounds
Technical Round
HR Round
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Data Analyst Interview Questions from Similar Companies

3.7
 • 35 Interview Questions
3.8
 • 25 Interview Questions
3.3
 • 18 Interview Questions
3.7
 • 16 Interview Questions
3.5
 • 11 Interview Questions
3.6
 • 11 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter