Microsoft Power BI Questions & Answers

Power Bi does not have any dependencies, it is solely responsible for data visualization and representing it graphically with the help of elements like charts, maps, graphs, etc.

A dashboard is a single page canvas that can show us multiple data sheets over a single page. It clubs the information of multiple pages into a single page, thereby giving us an overview of our data.

Power BI's drill down feature allows for more detailed data analysis by expanding or collapsing data at various levels of granularity.

There are six building blocks of Power Bi, which are as follows:

• Dashboard
• Reports
• Workbooks
• Semantic Models
• Dataflow
• Applications

Power Bi does not support Binary columns or Complex numbers. Although it does support data types like Text, Whole number, Decimal number, Date/Time, and Boolean.

Dashboard building blocks can create visuals from only one sheet. A Power BI dashboard is a one-page report that briefs the user about his data using templates and graphics.

The core data visualization feature of Power BI is called Power View. It is an interactive element that obtains metadata by connecting data sources.

Here's a breakdown of the Power BI architecture with a diagram:

• Data Sources: This layer encompasses various data sources that Power BI can connect to, including databases, cloud storage, and flat files.
• Data Ingestion: The data is extracted, transformed, and loaded (ETL) into the Power BI model in this layer.
• Data Modeling: This layer defines the data structure within Power BI, including tables, relationships, and hierarchies.
• Analysis Services: This layer comprises analytical engines that process data and perform calculations based on user queries and defined measures.
• Visualization Layer: This layer provides a user-friendly interface for creating interactive reports and dashboards using various charts, graphs, and other visual elements.
• Sharing and Collaboration: Power BI enables sharing reports and dashboards with colleagues securely, fostering collaboration and data-driven decision-making.