Filter interviews by
I applied via Referral and was interviewed before Mar 2021. There were 2 interview rounds.
I applied via Referral and was interviewed before Mar 2021. There were 2 interview rounds.
Calculate rolling total without resetting at specified interval
Use DAX formula with functions like CALCULATE, FILTER, and EARLIER
Create a measure that calculates the running total based on the current and previous rows
Consider using variables to store intermediate results for efficiency
Use DAX function to shift one cell down in a table
Use the LAG function in DAX to shift values down in a column
Specify the number of rows to shift as a parameter in the LAG function
Example: LAG([Column], 1) will shift values in 'Column' down by one row
Cardinality refers to the uniqueness of values in a column or relationship.
Cardinality is the number of unique values in a column or relationship.
High cardinality means a column has many unique values, while low cardinality means few unique values.
For example, a column like 'Customer ID' may have high cardinality, while 'Gender' may have low cardinality.
SQL query to retrieve data from a table
Use SELECT statement to specify columns to retrieve
Use FROM statement to specify the table to retrieve data from
Use WHERE statement to filter the data based on conditions
I applied via Naukri.com and was interviewed in Jul 2024. There were 4 interview rounds.
Power bi desktop in power bi service
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI allows users to connect to various data sources and create interactive reports and dashboards.
Users can easily share and collaborate on reports with others within the organization.
It offers features like data modeling, data visualization, and data transformation.
Power BI can be use...
A creative dashboard in Power Query involves using unique visuals and interactive elements to present data in an engaging way.
Utilize custom visuals to display data in a visually appealing manner
Incorporate interactive elements such as slicers and filters for user-friendly navigation
Use color coding and formatting to highlight important insights
Include dynamic elements like tooltips and drill-down capabilities
Experimen...
Write a DAX query in data modeling
Use CALCULATE function to apply filters and context to calculations
Use SUMX function to iterate over a table and perform calculations
Use RELATED function to retrieve related values from other tables
Power Pivot is a data modeling tool in Excel that allows users to create relationships, calculations, and measures for analyzing large datasets.
Power Pivot is an add-in for Excel that enables users to create data models and perform advanced data analysis.
It allows users to import and combine data from multiple sources, create relationships between tables, and define calculations and measures.
Users can create complex ca...
Creation in DAX refers to the process of generating new calculated columns or measures in Power BI using Data Analysis Expressions.
Use DAX functions like CALCULATE, SUMX, AVERAGE, etc. to create new columns or measures
Understand the data model and relationships to create accurate calculations
Test the newly created calculations to ensure they are working correctly
I applied via Referral and was interviewed in Sep 2024. There was 1 interview round.
Duplicates are identical copies of data, while references are pointers to the same data in memory.
Duplicates are exact copies of the original data.
References point to the same data in memory.
Duplicates can lead to inconsistencies in data analysis.
References are more memory efficient than duplicates.
Incremental refresh in Power BI allows for loading only new or modified data to improve performance.
Set up incremental refresh policy in Power BI Service
Define a range of values for the refresh policy
Use parameters to filter data based on the refresh policy
Schedule regular refreshes to update the dataset
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
Star schema is a data warehouse schema where a central fact table is connected to multiple dimension tables. Snowflake schema is a normalized form of star schema.
Star schema consists of a central fact table connected to multiple dimension tables
Snowflake schema is a normalized form of star schema where dimension tables are further normalized into sub-dimension tables
Star schema is denormalized for faster query performa...
Performance of reports can be improved by optimizing queries, reducing data volume, using efficient visuals, and caching data.
Optimize queries by removing unnecessary columns and filters
Reduce data volume by aggregating data at the source or using incremental refresh
Use efficient visuals like matrix instead of tables for large datasets
Cache data to reduce query times for frequently accessed data
Data query is the process of retrieving specific data from a database, while data flow is the movement of data from one point to another.
Data query involves writing SQL queries to extract specific data from a database
Data flow refers to the movement of data from source to destination through various transformations
Data query is used to filter and retrieve relevant data, while data flow ensures data is processed and mov...
Power Query is used to import and transform data within Power BI, while Direct Query allows real-time data access from the data source.
Power Query is used to import and transform data within Power BI before loading it into the data model.
Direct Query allows Power BI to query the data source directly in real-time, without importing the data into the data model.
Power Query is suitable for smaller datasets that can be loa...
RANK assigns a unique rank to each row based on a specified column, while DENSE RANK assigns a unique rank to each distinct row.
RANK function is used to assign a unique rank to each row based on a specified column
DENSE RANK function is used to assign a unique rank to each distinct row, skipping ranks if there are ties
RANK and DENSE RANK are commonly used in SQL queries to rank data based on certain criteria
Calculated column is a static column in a table calculated based on a formula, while Measure is a dynamic calculation based on aggregated data.
Calculated column is created in Power BI using DAX formula and stored in the data model.
Measure is a calculation performed on the fly based on the context of the visualization.
Calculated columns are static and can be used for filtering and sorting, while Measures are dynamic and
I have used complex DAX functions like CALCULATE, FILTER, SUMX, etc. to perform advanced calculations in Power BI.
Used CALCULATE function to apply filters and context changes to calculations
Utilized FILTER function to filter data based on specific conditions
Implemented SUMX function to iterate over a table and perform calculations for each row
CALCULATED function is used in Power BI to create custom calculations based on existing data in a report.
CALCULATED function is used to create custom calculations in DAX (Data Analysis Expressions) language.
It allows users to define complex calculations based on existing data in the report.
CALCULATED function can be used with other DAX functions to perform calculations like aggregations, comparisons, and conditional lo...
Query folding in Power BI is a process where Power BI pushes the data transformation steps back to the data source.
Query folding improves performance by reducing the amount of data loaded into Power BI.
It allows Power BI to leverage the capabilities of the data source for data transformation.
Commonly used with relational databases like SQL Server, Oracle, etc.
Example: When filtering data in Power BI, query folding will...
Types of context refer to the different ways in which data can be analyzed and interpreted in Power BI.
Row context: evaluates calculations row by row
Filter context: applies filters to data before calculations
Query context: used in DAX queries to retrieve data
Relationship context: determines how tables are related
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI is a business analytics tool by Microsoft
It allows users to create interactive visualizations and reports
Users can connect to various data sources to import data
Power BI offers a wide range of data visualization options such as charts, graphs, and maps
Users can share and collaborat
INNER JOIN is used to combine rows from two or more tables based on a related column between them.
Use INNER JOIN to retrieve rows from both tables that have matching values in the specified column
Syntax: SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name
Example: SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.Cus
I applied via Approached by Company and was interviewed in Jul 2024. There was 1 interview round.
Power BI components include Power Query, Power Pivot, Power View, Power Map, and Power Q&A.
Power Query: Used for data extraction and transformation.
Power Pivot: Used for data modeling and analysis.
Power View: Used for interactive data visualization.
Power Map: Used for geographical data visualization.
Power Q&A: Allows users to ask questions in natural language and get answers from data.
DAX stands for Data Analysis Expressions and is a formula language used in Power BI for creating custom calculations.
DAX is used to create custom calculations in Power BI, similar to Excel formulas.
It can be used to create calculated columns, measures, and calculated tables.
DAX functions can be used to manipulate data, perform calculations, and create complex expressions.
Examples of DAX functions include SUM, AVERAGE,
M language is a powerful data transformation language used in Power Query in Power BI.
M language is used to transform and clean data in Power BI.
It is a functional language with a wide range of functions and operators.
M language is case-sensitive and uses a step-by-step approach to data transformation.
Examples of M language functions include Table.TransformColumns and List.Transform.
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
It was a real-time scenario that they asked about.
I applied via Naukri.com
Implement security to data using row-level security (RLS)
Use user roles and permissions to restrict access to specific data
Leverage Power BI's built-in security features such as dataset security and data categorization
Implement dynamic security based on user context or attributes
Utilize Power BI's security features like Azure Active Directory integration for authentication and authorization
based on 2 reviews
Rating in categories
Software Engineer
46
salaries
| ₹3.8 L/yr - ₹7.6 L/yr |
Softwaretest Engineer
34
salaries
| ₹3.6 L/yr - ₹6.6 L/yr |
Software Developer
25
salaries
| ₹3.6 L/yr - ₹6.5 L/yr |
Devops Engineer
23
salaries
| ₹4 L/yr - ₹8.7 L/yr |
Test Engineer
23
salaries
| ₹3.8 L/yr - ₹6.5 L/yr |
TCS
Accenture
Wipro
Cognizant