Filter interviews by
I applied via campus placement at Netaji Subhas Institute of Technology (NSIT) and was interviewed before Oct 2023. There were 3 interview rounds.
Objective test for 45-50 mins
Resume grill, guesstimates and a small case study
Case study and guesstimate. A higher level case study.
Top trending discussions
I was interviewed in Jan 2025.
Basic aptitude test with around 20-25 questions
A video assignment on a given topic
I applied via Approached by Company and was interviewed in Jun 2024. There was 1 interview round.
Power Pivot is a data analysis tool in Excel that allows users to create powerful data models, perform calculations, and generate insights.
Power Pivot is an Excel add-in used for data analysis and modeling.
It allows users to import and manipulate large datasets from different sources.
Users can create relationships between tables, perform calculations, and create advanced data visualizations.
Power Pivot is commonly used...
Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources.
Power Query is used to import, transform, and combine data from different sources for analysis.
It helps in cleaning and shaping data before loading it into Excel or Power BI.
Power Query can be used to automate data preparation tasks, saving time and effort.
It allows users to easil...
Power Pivot is used for data modeling and analysis, while Power Query is used for data transformation and cleaning.
Power Pivot is used for creating relationships between tables and performing calculations.
Power Query is used for importing, transforming, and cleaning data from various sources.
Power Pivot is more focused on data analysis and modeling, while Power Query is more focused on data preparation.
Both Power Pivot...
To retrieve data over 3 months in a dynamic dashboard, use a date range filter and ensure the data source is updated regularly.
Create a date range filter in the dashboard to select a time period of over 3 months
Ensure the data source is updated regularly to include the required data
Use SQL queries or data extraction tools to pull the necessary data for the dashboard
Consider automating the data retrieval process to ensu
A Dicreat Chart is a type of chart that displays data points in a discrete manner, typically using bars or columns.
Dicreat Charts are used to represent categorical data, where each category is represented by a separate bar or column.
They are commonly used in market research, survey data analysis, and comparison of different categories.
Examples of Dicreat Charts include bar charts, column charts, and stacked bar charts.
SQL join is used to combine rows from two or more 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 the matched rows from the left table...
Stored procedures are precompiled SQL queries stored in a database for reuse.
Stored procedures are precompiled SQL queries stored in a database for reuse
They can improve performance by reducing network traffic and increasing security
Stored procedures can be used to encapsulate business logic and complex queries
Examples include procedures for updating customer information or calculating sales totals
CTE stands for Common Table Expressions. It is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
CTEs are defined using the WITH keyword in SQL.
They help improve readability and maintainability of complex queries.
CTEs can be recursive, allowing for hierarchical data querying.
Examples: Recursive CTEs for querying organizational hierarchies, CTEs for data transformation be
Matrix in PowerBi is a visual representation of data in rows and columns, allowing for easy comparison and analysis.
Matrix displays data in a grid format with rows and columns
It allows for easy comparison of data across different categories
Users can drill down into the data to see more detailed information
Matrix can be used to create interactive reports and dashboards
Lambda function is an anonymous function in Python that can have any number of arguments, but can only have one expression.
Used for creating small, throwaway functions without a name
Commonly used with functions like map(), filter(), and reduce()
Can be used to define functions inline without the need to formally define a function using def keyword
To manipulate datasets in Python, steps include loading data, cleaning data, transforming data, and analyzing data using libraries like Pandas.
Load the dataset using Pandas library
Clean the data by handling missing values, removing duplicates, and correcting data types
Transform the data by applying functions, merging datasets, and creating new columns
Analyze the data by performing statistical analysis, visualizations,
DAX data types are used in Power BI and Excel to define the type of data stored in a column or measure.
DAX data types include Integer, Decimal Number, String, Boolean, Date, Time, DateTime, and Currency.
Data types are important for calculations and formatting in DAX formulas.
For example, using the correct data type for a column can ensure accurate calculations and visualizations.
Inner join returns only the matching rows between two tables, while left join returns all rows from the left table and the matching rows from the right table.
Inner join only includes rows that have matching values in both tables
Left join includes all rows from the left table, even if there are no matching rows in the right table
Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Example...
Developed a predictive analytics model to forecast customer churn rate in a telecom company.
Utilized machine learning algorithms to analyze customer data
Identified key factors contributing to customer churn
Built a predictive model to forecast future churn rate
Collaborated with cross-functional teams to implement strategies to reduce churn
I applied via Walk-in and was interviewed in Nov 2024. There was 1 interview round.
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI is a data visualization tool used to create interactive reports and dashboards.
It allows users to connect to various data sources, clean and transform data, and create visually appealing reports.
Users can share and collaborate on reports with others, and access them on multiple dev...
Enumeration is the process of listing items in a specific order or sequence.
Enumeration is commonly used in programming to iterate through a list of items.
It helps in organizing and categorizing data for analysis.
Examples include counting the number of occurrences of specific values in a dataset.
First round will be aptitude test
I have a strong analytical background, excellent problem-solving skills, and a proven track record of delivering actionable insights.
I have a degree in data analytics and relevant work experience
I am proficient in statistical analysis and data visualization tools such as Python, R, and Tableau
I have successfully completed projects where I identified trends and patterns in data to drive business decisions
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Use conditional formatting to highlight odd cells in Excel
Select the range of cells you want to highlight
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose 'New Rule' and select 'Use a formula to determine which cells to format'
Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)
Choose the formatting style you want for the odd cells
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Types of 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 the matched rows from the left table
FU...
Use window function to calculate running sum of salary in SQL
Use window function like SUM() with OVER() clause
Partition the data by employee ID if needed
Order the data by date or any other relevant column
I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.
I applied via Walk-in and was interviewed in Aug 2024. There were 2 interview rounds.
SQL Joins are used to combine rows from two or more 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 the matched rows from the left tab...
Use DAX to create data modeling on inactive relationship in Power BI.
Use USERELATIONSHIP function to create an inactive relationship between two tables.
Specify the relationship between the tables and the columns to be used in the relationship.
Use CALCULATE function along with USERELATIONSHIP to perform calculations using the inactive relationship.
Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all
based on 1 interview
Interview experience
Associate
93
salaries
| ₹14 L/yr - ₹21 L/yr |
Analyst
55
salaries
| ₹8 L/yr - ₹14 L/yr |
Senior Associate
43
salaries
| ₹15 L/yr - ₹22 L/yr |
Project Lead
42
salaries
| ₹18 L/yr - ₹33 L/yr |
Manager
13
salaries
| ₹30 L/yr - ₹50.1 L/yr |
McKinsey & Company
BCG
Deloitte
Accenture