Filter interviews by
I applied via LinkedIn and was interviewed in Jan 2023. There were 4 interview rounds.
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
AI Builder is a Power Platform service that allows users to easily add AI capabilities to their applications.
AI Builder provides pre-built models for common AI scenarios such as object detection, text recognition, and prediction.
Users can also train custom models using their own data to meet specific business needs.
AI Builder integrates seamlessly with Power Apps and Power Automate to enable automation and decision-mak
PCF stands for PowerApps Component Framework, AI Builder is a tool in Power Platform for building AI models.
PCF is a framework for building custom controls in PowerApps and Dynamics 365
AI Builder is a tool that allows users to build AI models without needing coding skills
AI Builder can be used for tasks like object detection, form processing, and prediction
Measure is a calculated value based on data in a model, while count is a simple count of records.
Measure is a calculated value based on aggregation functions like sum, average, etc.
Count is a simple count of records in a dataset.
Measures are used in Power BI to perform calculations on data, while count is used to simply count the number of records.
Row level security is a feature in Power BI that restricts data access at the row level based on user roles or criteria.
Allows users to only see data that is relevant to them
Can be implemented using DAX expressions
Helps in maintaining data privacy and security
Useful for organizations with sensitive data
Relationships in Power BI define how different tables are connected to each other.
Relationships define how tables are related to each other based on common fields
They are used to create connections between tables for data analysis
Relationships can be one-to-one, one-to-many, or many-to-many
They are essential for creating accurate and meaningful visualizations in Power BI
We used a variety of data sources including SQL databases, Excel files, and web APIs.
SQL databases
Excel files
Web APIs
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
There are four types of joins in Power Query editor: Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join.
Inner Join combines rows from two tables based on a matching column.
Left Outer Join returns all rows from the left table and the matching rows from the right table.
Right Outer Join returns all rows from the right table and the matching rows from the left table.
Full Outer Join returns all rows from bot
Power Query Editor allows various transformations on data such as filtering, sorting, merging, splitting, and aggregating.
Filtering: Removing rows based on certain criteria.
Sorting: Arranging rows in a specific order.
Merging: Combining multiple tables or queries into one.
Splitting: Dividing a column into multiple columns.
Aggregating: Calculating summary statistics like sum, average, count, etc.
There are multiple types of filters in Power BI including visual, page, report, and drill-through filters.
Visual filters apply to a specific visual or group of visuals.
Page filters apply to all visuals on a specific page.
Report filters apply to all visuals on all pages of a report.
Drill-through filters allow users to navigate to a different report page based on a selected data point.
The three filters can be applied to the data in Power BI to narrow down the results.
Filters can be applied to specific columns or measures in the data
Filters can be used to show only certain values or ranges of values
Filters can be combined to create more complex filtering logic
There are three connectivity modes in Power BI: Import, DirectQuery, and Live Connection.
Import mode: Data is imported into Power BI and stored in a dataset.
DirectQuery mode: Data stays in the data source and queries are sent directly to the source.
Live Connection mode: Power BI connects directly to the data source for real-time data access.
I applied via Naukri.com
ABC Corporation is a multinational technology company specializing in software development and data analytics.
ABC Corporation is known for its expertise in Power BI development.
The company has a global presence with offices in multiple countries.
ABC Corporation offers a wide range of software solutions for various industries.
They have a strong focus on data analytics and provide advanced reporting and visualization too...
The current CTC and expected CTC are personal financial details and should not be disclosed in an interview.
It is not appropriate to discuss personal financial details in an interview.
Salary negotiations should be done after receiving a job offer.
Focus on discussing your skills, experience, and qualifications for the Power BI Developer role.
Row Level Security is a feature in Power BI that allows you to restrict data access at the row level based on user roles and filters.
Row Level Security (RLS) is used to control data access in Power BI based on user roles and filters.
It allows you to define rules that determine which rows of data a user can see.
RLS can be applied to tables or views in the data model.
It is commonly used to restrict access to sensitive or...
SUM calculates the sum of a column or expression, while SUMX calculates the sum of an expression over a table.
SUM is used to calculate the sum of a column or expression in Power BI.
SUMX is used to calculate the sum of an expression over a table in Power BI.
SUM is typically used with a column reference, while SUMX is used with an expression.
SUMX can be used to perform calculations on filtered or modified data.
Example: S...
Calculated columns are computed during data loading, while measures are computed on the fly during data visualization.
Calculated columns are created in the data model and stored in the underlying table.
Measures are created using DAX expressions and are calculated dynamically based on the context of the visualization.
Calculated columns consume memory and can impact performance, while measures are more efficient.
Calculat...
The last working day of the company is the day on which an employee's employment ends.
The last working day is typically determined by the company's policies and the employee's contract.
It may be different for each employee depending on their notice period or reason for leaving.
The last working day is usually communicated to the employee through an official letter or email.
On the last working day, the employee may be re...
based on 8 reviews
Rating in categories
Power BI Developer
5
salaries
| ₹4 L/yr - ₹9 L/yr |
Data Engineer
4
salaries
| ₹5 L/yr - ₹9 L/yr |
Python Developer
3
salaries
| ₹6 L/yr - ₹9 L/yr |
Software Engineer Level 1
3
salaries
| ₹4 L/yr - ₹7 L/yr |
TCS
Infosys
Wipro
HCLTech