EY Global Delivery Services ( EY GDS) Power BI Developer Interview Questions and Answers

SUMX calculates the total of an expression evaluated for each row in a table, while SUM calculates the total of a column.

• SUMX is an iterator function in DAX that allows you to iterate over a table and perform calculations on each row.

• SUMX is commonly used to calculate a total based on a formula or expression applied to each row.

• SUM, on the other hand, simply calculates the total of a column without any iteration over r...read more

Direct query mode connects to data source in real-time, while import mode loads data into Power BI for faster analysis.

• Direct query mode connects to data source in real-time, providing up-to-date data

• Import mode loads data into Power BI for faster analysis, but may not always reflect real-time changes

• Direct query mode is suitable for large datasets that require real-time updates

• Import mode is suitable for smaller datas

PowerBI is a data visualization tool that helps users analyze and visualize data to make informed business decisions.

• PowerBI helps in creating interactive reports and dashboards

• It allows users to connect to various data sources like Excel, SQL databases, and cloud services

• Users can create custom visualizations and share insights with others

• PowerBI can be used for data exploration, data modeling, and data storytelling

End users can access the report through Power BI Service, Power BI Mobile App, or embedded in other applications.

• End users can access the report through Power BI Service by logging in with their credentials

• End users can also access the report through Power BI Mobile App on their smartphones or tablets

• Reports can be embedded in other applications using Power BI Embedded feature

Calculated columns are columns created in Power BI by using DAX formulas, while measures are calculations based on the data model.

• Calculated columns are static and stored in the data model, while measures are dynamic and calculated on the fly.

• Calculated columns are used for adding new data to a table, while measures are used for aggregating data or performing calculations.

• Examples of calculated columns include adding a...read more

Numerical range parameter is a parameter that defines a range of numerical values for a specific variable or function.

• It is used to specify a range of numerical values that a parameter can take.

• It helps in filtering data based on a specific numerical range.

• For example, a numerical range parameter can be used to filter sales data for products with prices between $50 and $100.

A field parameter is a variable that is used to pass values to a function or method.

• Field parameters are used to customize the behavior of functions or methods.

• They can be used to filter, sort, or group data in Power BI reports.

• Examples include filtering data based on a specific date range or sorting data by revenue.

I have 5 years of experience as a Power BI Developer.

• Developed interactive dashboards and reports using Power BI

• Created data models and performed data analysis

• Worked with various data sources such as SQL Server, Excel, and SharePoint

• Implemented data transformations and data cleansing

• Collaborated with business stakeholders to gather requirements and provide insights

• Optimized performance and improved data visualization

• Tr...read more

I have recently worked as a Power BI Developer, creating interactive dashboards and reports.

• Developed interactive dashboards and reports using Power BI

• Gathered requirements from stakeholders and translated them into data visualizations

• Created data models and implemented data transformations

• Collaborated with cross-functional teams to ensure data accuracy and consistency

• Provided training and support to end-users for effe

The current company is XYZ Corporation.

• The current company is XYZ Corporation.

• XYZ Corporation is a multinational technology company.

• XYZ Corporation specializes in software development and data analytics.

• XYZ Corporation has a strong presence in the Power BI industry.

I work remotely from my home office.

• I work from a dedicated home office space.

• I have all the necessary equipment and tools to work remotely.

• I communicate with my team and clients through online collaboration tools.

• I am available for meetings and discussions via video conferencing.

• I maintain a productive work environment at home.