2.Power BI part 2 Flashcards
How can Power BI users collaborate on content?
Using shared workspaces.
What does the “Transform Data” button in Power BI Desktop do?
Opens Power Query Editor.
What are the benefits of using a semantic model in Power BI?
Ensures consistency.
How does Power BI integrate with Excel?
Imports data and uses Power Query.
What is the purpose of Power BI Template Apps?
Provide prebuilt apps for quick deployment.
What are the two viewing modes for reports in Power BI?
Reading and Editing views.
How do notifications work in Power BI Insights?
Alert users to trends, anomalies, or KPI updates.
What is the role of tiles on a Power BI dashboard?
Display individual visualizations.
What does pinning a report visual to a dashboard achieve?
Adds visual to a dashboard.
How can Power BI help with resource allocation in a business?
Analyzes trends and makes predictions.
What is the Power BI Report Server?
On-premises solution for sharing and managing Power BI reports.
What are Power BI Workspaces used for?
Collaborating on reports and dashboards.
What is the Power BI Service interface?
Web-based interface for creating, sharing, and managing reports.
What is DAX in Power BI?
A formula language used for calculations.
How does Power BI help in decision making?
Provides insights through data analysis.
What is Power BI’s Query Editor used for?
Modifying and shaping data.
What are Power BI visuals?
Graphical representations of data.
Can Power BI integrate with other Microsoft tools?
Yes, it integrates with tools like Excel and SharePoint.
What is Power BI Premium?
A paid version with more features and better performance.
What is a dataflow in Power BI?
A collection of data transformation steps.
What is Power BI’s DirectQuery mode?
Real-time querying without importing data.
What is the difference between Power BI Desktop and Power BI Service?
Desktop is for creating reports, Service is for sharing and collaborating.
What does “Pin to Dashboard” mean in Power BI?
Adds a visual to a dashboard.
What are the advantages of using Power BI?
Interactive reports, easy data integration, cloud-based sharing.
What is a Power BI Embedded solution?
Embedding Power BI reports in apps.
What is Power BI Q&A?
Natural language query tool for reports.
What is the purpose of the Power BI Mobile app?
Access reports and dashboards on the go.
What is Power BI’s Visualizations pane?
A pane where you choose the type of visual for your data.
How does Power BI connect to databases?
Using connectors and queries.
What is a Power BI workspace used for?
Organizing and sharing content within a team.
What is a dataset in Power BI?
A collection of data used to create reports and dashboards.
How do you refresh data in Power BI?
Through scheduled or manual data refresh options.
What is a live connection in Power BI?
Real-time data access without importing data.
What is the “Publish” button in Power BI Desktop?
It uploads reports to Power BI Service.
What is a KPI visualization in Power BI?
A visual that tracks key performance indicators.
What is the role of the Power BI administrator?
Manages users, permissions, and workspace settings.
What are Power BI slicers?
Filters for report visuals.
How can Power BI handle large datasets?
By optimizing performance and using aggregation.
What type of chart is best used to show the relationship of parts to a whole?
Pie chart
In Power BI, what aggregation should be used for text fields when creating visuals?
Count
Where can you create a relationship between two tables in Power BI Desktop?
Modeling view
Where should you collaborate with others to build visualizations in Power BI?
Workspace
What is the correct way to add a calculated column in a Power BI report?
use Power BI Desktop, Data tab, choose New column
Which feature can only be created in Power BI Service?
Dashboards
What type of calculation is a ‘Measure’ in Power BI?
An equation created on the dataset
When creating a Power BI report which visualization should you use to present last year’s revenue?
Bar Chart or Line chart
Which tool should you use to add a calculated column in a Power BI report?
New column option in Power BI Desktop
What should you recommend to allow users to reuse the same dataset to build their own reports and dashboards?
Share the dataset
To which field well should you add the row count measure in order to show the count of rows in the table as columns of a clustered column chart?
Y-axis
Which chart type should you use to display month-by-month revenue comparisons for the current and previous years?
Bar
