Fabric & Power Bi

Question 1

What is Microsoft Fabric?

Answer 1

Microsoft’s all-in-one AI-powered analytics solution.

Question 2

What is the purpose of a workspace in Microsoft Fabric?

Answer 2

A workspace in Microsoft Fabric is a collaborative space where colleagues can group and manage collections of items

Question 3

What is the importance of the ‘One Lake’ feature in Microsoft Fabric?

Answer 3

The ‘One Lake’ feature in Microsoft Fabric enables efficient data access, collaboration, and creation within all Microsoft platforms.

Question 4

What does Power BI do?

Answer 4

1) Integrates data from different sources

2) Helps users create and share reports and dashboards

3) Offers a variety of dynamic visualization and filtering tools

Question 5

What is a Power BI Dashboard

Answer 5

A Power BI dashboard displays multiple key metrics from given data on a single interactive page for easy analysis.

Question 6

What are the steps to create a dashboard in Power BI?

Answer 6

To create a dashboard, you go to your workspace in Power BI, click on ‘New’, and select ‘Dashboard’. Give it a name and click ‘Save’.

Question 7

Is it possible to filter or slice data directly on a Power BI dashboard?

Answer 7

No, you cannot directly filter or slice data on a dashboard.

Question 8

What is a Power BI report?

Answer 8

A Power BI report is a multi-page document containing data visualizations that provide insights from datasets, with interactive filters and drill-down capabilities for detailed analysis.

Question 9

Where should you filter or slice data in Power BI?

Answer 9

You can filter your data on reports, which can then be pinned as visuals to dashboards.

Question 10

What is the difference between a dashboard and a report in Power BI?

Answer 10

Dashboards are single pages that provide a summarized view, pulling data from multiple reports.

Reports are more detailed, can have multiple pages, and are used for in-depth data analysis.

Question 11

What is a data pipeline in Power BI?

Answer 11

It is a structured process to facilitate the flow of data from different sources and make sure it is ready for analysis and reporting.

Question 12

What are the steps to create this pipeline?

Answer 12

1) Data extraction

2) Data transformation

3) Data loading

Question 13

Why is setting up Office 365 Outlook activity important?

Answer 13

It ensures that if an error occurs during the data flow, a customized email notification is sent out, allowing for prompt identification and resolution of issues.

Question 14

What is a semantic model?

Answer 14

A semantic model defines the meaning of data in context, enabling easier analysis.

Question 15

What are DAX expressions in Power BI for your semantic model?

Answer 15

DAX expressions in Power BI are formulas used to calculate and analyze data, enabling advanced data manipulation and analysis within models.

Question 16

What is the ‘Auto Create Report’ feature in Power BI?

Answer 16

This feature helps generate quick reports to explore your data or as a starting point to build your own custom report.

Question 17

What should you do before autogenerating the report?

Answer 17

Make sure to navigate to the dataset of interest in your workspace view, and then click on the “Auto-Create Report” feature.

Question 18

How can you customize and access an auto-created report?

Answer 18

You can access full customization by switching to edit mode, which provides access to the data pane and a complete visual authoring experience.

Question 19

What are the main methods to begin report creation in Power BI via Microsoft Fabric?

Answer 19

The two primary ways to start building a report in Power BI are either pasting / manually entering data or picking a published dataset.

Question 20

What are the steps to import external data into Power BI?

Answer 20

Copy the data from the source and paste it into the Power BI interface, where it provides an option to paste or manually enter data.

Question 21

What is an important step to take after importing your data in Power BI?

Answer 21

Verify that the data types in the set are correct and change the ones that are not.

Question 22

How can you change the data type?

Answer 22

This can be done by clicking on the data type icon next to each column header and selecting the appropriate data type.

Question 23

What could be wrong when you are not able to edit and work with your data?

Answer 23

You did not click on the “Edit” feature!!

Question 24

What are Paginated Reports and what’s their main advantage?

Answer 24

The ability to print or export to PDF every row in a table ensures no data is missed during printing or sharing.

Question 25

What is the main tool for authoring Paginated Reports for the Power BI service?

Answer 25

The main tool for authoring paginated reports is the Power BI Report Builder.

Question 26

What is a sensitivity label in Power BI?

Answer 26

Sensitivity labels classify and protect data based on its sensitivity, ensuring proper access and compliance across Microsoft services.

Question 27

What is the difference between a data source and a data set?

Answer 27

A data source is the origin of the data (like a database or a file), while a dataset is a structured collection of data pulled from one or more data sources.

Question 28

What is an embedded data source in a Paginated report?

Answer 28

An embedded data source in a Paginated report stores the connection details directly within the report itself, enhancing portability. However, this approach requires individual updates to each report if the connection details change.

Question 29

What is a Scorecard in Power BI?

Answer 29

A scorecard is a visual representation of KPIs with associated metrics and target values to help assess the data and numbers obtained in the reports.

Question 30

What are some additional useful features available in scorecards?

Answer 30

The ability to add multiple metrics and set up hierarchies.

Filters to view metrics by their status (e.g., ‘completed’, ‘behind’).