1. Power BI Part A

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.