quiz image

1. Power BI Part A

FastStatistics avatar
FastStatistics
·

Start Quiz

Study Flashcards

10 Questions

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?

Model section

Which type of view in Power BI is specifically rendered on Power BI mobile apps?

Phone 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?

Open the report using Power BI Desktop, select the Data tab, and then 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 for an investor meeting, which visualization should you use to present last year's revenue?

Bar Chart

Which tool should you use to add a calculated column in a Power BI report for a customer acquisition analysis?

New column option in Power BI Desktop

Study Notes

Power BI Visualizations

  • A pie chart is used to show the relationship of parts to a whole.
  • A line chart is used to display a series over time.
  • A map is used to associate quantity information to locations.
  • A KPI is used to show the progress towards a goal.

Aggregating Text Data in Power BI

  • Power BI aggregates text data as distinct categories and counts the occurrences of each category.
  • The "Count" aggregation should be used to aggregate text data.

Creating Relationships in Power BI Desktop

  • Relationships between two tables in Power BI Desktop can be created from the "Data" section using the "Manage relationships" option.
  • Relationships can also be created from the "Model" section using the "Manage relationships" option.

Creating a Power BI Dashboard for Mobile Apps

  • The "Phone view" should be edited to create a Power BI dashboard for mobile apps.

Collaborating with Others in Power BI

  • Workspaces are used to collaborate on building content for Power BI, including datasets, reports, and dashboards.
  • A workspace must be used to collaborate with others.

Displaying Sales Revenue in Power BI

  • A bar chart should be used to display the sales revenue for the top fifteen product categories.

Creating a Dashboard in Power BI

  • A visualization can be pinned to a new or existing dashboard to create a dashboard containing tiles for individual visualizations.
  • The Q&A feature on the dashboard can be used to ask a question about the data and generate visualizations that can be pinned to the dashboard.

Adding a Calculated Column in Power BI

  • To add a calculated column, the report should be opened using Power BI Desktop.
  • The "Data" tab should be selected, and then "New column" should be selected.

Power BI Service vs Power BI Desktop

  • Dashboards and Workspaces can only be created in the Power BI service.
  • Reports can be created in both Power BI Desktop and Power BI service.
  • Measures can only be created in Power BI Desktop.

This quiz tests your knowledge on Power BI.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Get started for free

More Quizzes Like This

Business Intelligence & Power BI
5 questions
Quiz sur Power BI Desktop
5 questions
COPY: 1. Power BI Part A
10 questions
Use Quizgecko on...
Browser
Browser