Fabric & Power Bi Flashcards
What is Microsoft Fabric?
Microsoft’s all-in-one AI-powered analytics solution.
What is the purpose of a workspace in Microsoft Fabric?
A workspace in Microsoft Fabric is a collaborative space where colleagues can group and manage collections of items
What is the importance of the ‘One Lake’ feature in Microsoft Fabric?
The ‘One Lake’ feature in Microsoft Fabric enables efficient data access, collaboration, and creation within all Microsoft platforms.
What does Power BI do?
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
What is a Power BI Dashboard
A Power BI dashboard displays multiple key metrics from given data on a single interactive page for easy analysis.
What are the steps to create a dashboard in Power BI?
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’.
Is it possible to filter or slice data directly on a Power BI dashboard?
No, you cannot directly filter or slice data on a dashboard.
What is a Power BI report?
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.
Where should you filter or slice data in Power BI?
You can filter your data on reports, which can then be pinned as visuals to dashboards.
What is the difference between a dashboard and a report in Power BI?
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.
What is a data pipeline in Power BI?
It is a structured process to facilitate the flow of data from different sources and make sure it is ready for analysis and reporting.
What are the steps to create this pipeline?
1) Data extraction
2) Data transformation
3) Data loading
Why is setting up Office 365 Outlook activity important?
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.
What is a semantic model?
A semantic model defines the meaning of data in context, enabling easier analysis.
What are DAX expressions in Power BI for your semantic model?
DAX expressions in Power BI are formulas used to calculate and analyze data, enabling advanced data manipulation and analysis within models.
What is the ‘Auto Create Report’ feature in Power BI?
This feature helps generate quick reports to explore your data or as a starting point to build your own custom report.
What should you do before autogenerating the report?
Make sure to navigate to the dataset of interest in your workspace view, and then click on the “Auto-Create Report” feature.
How can you customize and access an auto-created report?
You can access full customization by switching to edit mode, which provides access to the data pane and a complete visual authoring experience.
What are the main methods to begin report creation in Power BI via Microsoft Fabric?
The two primary ways to start building a report in Power BI are either pasting / manually entering data or picking a published dataset.
What are the steps to import external data into Power BI?
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.
What is an important step to take after importing your data in Power BI?
Verify that the data types in the set are correct and change the ones that are not.
How can you change the data type?
This can be done by clicking on the data type icon next to each column header and selecting the appropriate data type.
What could be wrong when you are not able to edit and work with your data?
You did not click on the “Edit” feature!!
What are Paginated Reports and what’s their main advantage?
The ability to print or export to PDF every row in a table ensures no data is missed during printing or sharing.
What is the main tool for authoring Paginated Reports for the Power BI service?
The main tool for authoring paginated reports is the Power BI Report Builder.
What is a sensitivity label in Power BI?
Sensitivity labels classify and protect data based on its sensitivity, ensuring proper access and compliance across Microsoft services.
What is the difference between a data source and a data set?
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.
What is an embedded data source in a Paginated report?
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.
What is a Scorecard in Power BI?
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.
What are some additional useful features available in scorecards?
The ability to add multiple metrics and set up hierarchies.
Filters to view metrics by their status (e.g., ‘completed’, ‘behind’).