Ernst & Young Senior Data Analyst Interview Questions, Process, and Tips

There are four types of connections available in Power BI.

• Power BI Desktop Connection

• Power BI Service Connection

• Power BI Mobile Connection

• Power BI Gateway Connection

Incremental refresh is a feature in Power BI that allows you to refresh only a portion of your data instead of the entire dataset.

• Incremental refresh is useful for large datasets that take a long time to refresh.

• It allows you to refresh only the new or updated data since the last refresh.

• You can set up incremental refresh by defining a range of values for a column that represents the refresh window.

• For example, you can...read more

Direct connection is a static connection to a data source, while live connection is a dynamic connection that updates in real-time.

• Direct connection requires data to be imported into the analysis tool, while live connection accesses data directly from the source.

• Live connection allows for real-time updates and analysis, while direct connection requires manual refreshing.

• Direct connection is useful for small datasets or...read more

Power Pivot is available in Power BI Desktop and Power BI Service.

• Power Pivot is a data modeling tool in Excel that allows you to create relationships between tables and perform complex calculations.

• In Power BI Desktop, you can access Power Pivot by going to the 'Data' tab and selecting 'Manage Relationships'.

• In Power BI Service, you can access Power Pivot by going to the 'Settings' menu and selecting 'Data Sources'.

• Po...read more

SELECTEDVALUE() is a DAX function used to return the value of a column if it has only one distinct value.

• Used in Power BI to retrieve the value of a column if it has only one distinct value

• Returns an error if the column has more than one distinct value

• Can be used in combination with IF statement to handle errors

• Example: SELECTEDVALUE('Table'[Column], 'No value found')

• Example: IF(ISBLANK(SELECTEDVALUE('Table'[Column])),...read more

Dependent slicer in Power BI allows filtering of data based on selection in another slicer.

• Create two slicers, one for the main category and another for the sub-category.

• Add the main category slicer to the report page and select the sub-category slicer.

• Go to the Format pane and select the 'Edit interactions' option.

• Choose the 'Filter' option for the sub-category slicer.

• Now, when a main category is selected, the sub-cat...read more

There are three types of filters available in Power BI.

• Visual level filters

• Page level filters

• Report level filters

To share a Power BI report with an external user, we can use the Publish to Web feature or share it via email.

• Use the Publish to Web feature to generate an embed code that can be shared with external users

• Ensure that the report contains only non-sensitive data before using the Publish to Web feature

• Alternatively, share the report via email by granting access to the external user's email address

• The external user must ha