AEGIS BUSINESS BI Developer Interview Questions, Process, and Tips

Power BI offers different license types for users.

• Power BI Free

• Power BI Pro

• Power BI Premium

• Power BI Embedded

Filters in Power BI allow users to narrow down data based on specific criteria.

• Filters can be applied to visuals, pages, or the entire report.

• There are different types of filters such as visual-level, page-level, and report-level filters.

• Filters can be based on single or multiple values, ranges, or advanced conditions.

• Examples of filters include filtering data by date, category, or region.

• Filters can be applied manuall

Perspectives in analysis cubes are different views of the data that allow users to analyze data from different angles.

• Perspectives provide different combinations of dimensions and measures for analysis.

• They allow users to focus on specific aspects of the data.

• Perspectives can be used to create customized reports and dashboards.

• They help in simplifying complex data models by presenting a subset of data.

• For example, a sa...read more

Self joins are used to join a table to itself. Types include inner, outer, and self-join.

• Self joins are used when a table needs to be joined with itself.

• Inner self join returns only the matching rows between the two instances of the table.

• Outer self join returns all rows from both instances of the table, with null values where there is no match.

• Self join can be used to find hierarchical relationships within a table.

• Exa...read more