i
New Era Technology
Filter interviews by
DAX functions should be used appropriately and efficiently to achieve desired results.
Understand the purpose and syntax of each DAX function
Use the appropriate function for the specific calculation or analysis
Avoid using too many nested functions as it can impact performance
Test and validate the results of DAX functions before using them in production
Document the DAX functions used in the Power BI report for future ref
One sample sales report and use of dax functions
Top trending discussions
I applied via Campus Placement and was interviewed before Feb 2021. There were 4 interview rounds.
Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.
Power BI is a Microsoft product used for data analysis and visualization.
It allows users to connect to various data sources and create interactive reports and dashboards.
Power BI provides a wide range of visualizations, such as charts, maps, and tables, to represent data.
Users can create custom calculat...
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 Company Website and was interviewed before Jan 2022. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.
Power BI provides various types of security to protect data and control access.
Row-level security allows restricting data access based on user roles or filters.
Data encryption ensures that data is securely stored and transmitted.
Azure Active Directory integration enables centralized user authentication and access control.
Power BI service provides access and sharing controls to manage permissions.
Data loss prevention po...
Gauge charts are used to visually represent a single value within a given range.
Gauge charts are commonly used in business dashboards to display key performance indicators (KPIs).
They provide a quick and intuitive way to assess the current status or progress towards a goal.
Gauge charts can be used to show metrics such as sales targets, customer satisfaction scores, or production efficiency.
They are effective in highlig...
Gateway is a tool that allows Power BI to connect to on-premises data sources. Dataflow is a self-service data preparation tool in Power BI.
Gateway enables Power BI to securely access on-premises data sources.
Dataflow allows users to extract, transform, and load data from various sources into Power BI.
Gateway and Dataflow work together to enable data refresh and data preparation in Power BI.
Gateway can be used to conne...
I applied via Job Portal and was interviewed in Apr 2023. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
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 a data transformation tool in Power BI used to import, transform, and clean data before loading it into the data model.
It allows users to connect to various data sources such as Excel, databases, web services, and more.
Users can perform data cleansing, transformatio...
summarize is used to aggregate data at a specified level, while summarizetable is used to aggregate data across multiple tables.
summarize is used with a single table, while summarizetable can be used with multiple tables
summarize can only be used with columns from the specified table, while summarizetable can be used with columns from multiple tables
summarize can be used to create new columns, while summarizetable is u
I applied via Walk-in and was interviewed before Nov 2023. There were 2 interview rounds.
Easy round. Mainly speed is required.
3 leetcode easy to medium to be solved in one hour
based on 2 reviews
Rating in categories
IT Analyst
119
salaries
| ₹0 L/yr - ₹0 L/yr |
Network Engineer
90
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior IT Analyst
34
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
31
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
24
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech