WNS
Daiviksoft Technologies Interview Questions and Answers
Q1. How do u make groups and how bins are different from groups
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
Q2. Why do you prefer power bi over tableau
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
Q3. How do you use Group By in Power Query?
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
Q4. what is SQL server Architecture?
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
Q5. Difference between Sum and Sumx
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)
Q6. Difference between Sum and SUMX in DAX
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
Q7. Guesstimates - Cars in delhi
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.
Q8. Difference between list and tuple
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)
Q9. What are sql joins
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
Interview Process at Daiviksoft Technologies
Top Data Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month