We17 Interview Questions and Answers

There are three types of filters in Power BI: visual, page, and report level filters.

• Visual filters apply to a single visual or chart.

• Page filters apply to all visuals on a single page.

• Report level filters apply to all visuals and pages in the report.

• Filters can be applied to columns, measures, or hierarchies.

• Examples of filters include date range filters, slicers, and dropdown filters.

Reports are detailed and provide specific information, while dashboards are high-level and provide an overview.

• Reports are typically longer and more detailed than dashboards

• Reports are often used to provide specific information to a targeted audience

• Dashboards are high-level and provide an overview of key metrics

• Dashboards are often used to monitor performance and identify trends

• Reports are usually static, while dashbo...read more

Tableau and Power BI are both data visualization tools, but Power BI is more user-friendly and affordable while Tableau is more powerful and flexible.

• Power BI is easier to use and has a lower learning curve

• Tableau has more advanced features and customization options

• Power BI is more affordable for small to medium-sized businesses

• Tableau is better for large enterprises with complex data needs

• Power BI integrates well with...read more

Calculate column is a static column while measure is a dynamic calculation.

• Calculate column is computed during data load and cannot be changed afterwards.

• Measure is computed on the fly based on user interaction with the report.

• Calculate column is used for static calculations like concatenation or simple arithmetic.

• Measure is used for dynamic calculations like aggregation or percentage.

• Calculate column can consume more ...read more