Create and use analytics reports with Power BI Microsoft Quiz Answers

Get Create and use analytics reports with Power BI Microsoft Quiz Answers

This learning path introduces you to Power BI, and teaches you to use and build business intelligence reports.

This learning path can help you prepare for the Microsoft Certified: Microsoft Power Platform App Maker Associate certification.

This learning path helps prepare you for Exam PL-400: Microsoft Power Platform Developer, Exam PL-100: Microsoft Power Platform App Maker, Exam PL-200: Microsoft Power Platform Functional Consultant.

Prerequisites:

• Familiarity with Excel
• Access to the Power BI service
• Power BI Desktop

Enroll on Microsoft

Module 2: Get data with Power BI Desktop

How can you find, collect, and clean data from different sources? Power BI is a tool for making sense of your data. You will learn tricks to make data-gathering easier.

Learning objectives:

In this module, you will:

• Explore the data-centric features and tools of Power BI.
• Explore ways to find data.

Prerequisites:

Access to Power BI Desktop

Quiz 1: Check your knowledge

Q1. Which tool would you use to clean your data before building reports?

• Navigator view
• Power Query editor
• New Measure
• New Parameter

Q2. What is one method for creating a visual?

• Drag a field from the Fields list onto the Visualizations pane
• Drag a field from the Fields list onto the Model view canvas
• Drag a field from the Fields list onto the Report view canvas
• Drag a field from the Fields list onto the Data view canvas

Q3. What is the best way to import tabular data from a website into Power BI?

• Download data from the website and then import to Power BI
• Transfer data from the website to OneDrive and then import to Power BI
• Select Get Data and point to the URL
• Use the Query Editor to find and edit the web-based data

Module 3: Model data in Power BI

Connect Power BI to multiple data sources to create reports. Define the relationship between your data sources.

Learning objectives:

In this module, you will:

• Create relationships between your data sources
• Create a new field with calculated columns
• Optimize data by hiding fields and sorting visualization data
• Create a measure to perform calculations on your data
• Use a calculated table to create a relationship between two tables
• Format time-based data so that you can drill down for more details

Prerequisites:

Access to Power BI Desktop

Quiz 1: Check your knowledge

Q1. How do you get Power BI Desktop to find relationships in data after it has been imported?

• Open the Power Query Editor
• Select Manage Relationships and then Autodetect
• Select the New Parameter button to map the relationship
• Use the Performance Manager

Q2. If your months were sorted alphabetically, how could you sort them by month order?

• Click the Edit Queries button
• Add a slicer to your visual
• Change the visualization type
• Apply the MonthNo category sort option

Q3. How do you get Power BI to separate date data into year, quarter, month, and day?

• Open the Query Editor
• Select the New Parameter button
• Select the New Measure button
• You don’t need to do anything, it is automatic.

Q4. How do you create data tables that you want stored as part of the model rather than as part of a query?

• Use a calculated table
• Select the Enter Data button
• Select the New Measure button
• Select the New Parameter button

Q5. Why would a table show the same value, like “Sales”, for every country?

• Because the Revenue data is corrupted
• Because the column is assigned with the wrong data type
• Because there is no relationship between the Sales and Country fields.
• Because the column is sorted incorrectly

Module 4: Use visuals in Power BI

Create and customize visuals to present data in compelling and insightful ways.

Learning objectives:

In this module, you will:

• Explore Power BI visuals
• Create visuals

Prerequisites:

Access to Power BI Desktop

Quiz 1: Check your knowledge

Q1. You want your report readers to be able to view your bar chart visual for any year that they choose. What tool could you use?

• Conditional formatting
• Slicer
• Treemap
• Z-order

Q2. If you were very satisfied with the appearance of a page and wanted the next page to look the same, what would be the best method?

• Export the report to PDF and then import the PDF with a different name
• Right-click the report page tab and select “Duplicate Page”
• Publish the report to a different location
• Use the “New Quick Measure” feature

Q3. Which scenario would be a good case for using bubble maps?

• You want to see months with the highest sales by country.
• You want to see the types of products sold in each country.
• You want to see sales by age group.
• You want to see total revenue by country.

Module 5: Explore data in Power BI

Turn your business intelligence data into data insights by creating and configuring Power BI dashboards.

Learning objectives:

In this module, you will:

• Upload reports
• Create dashboards
• Ask questions of your data

Prerequisites:

Access to Power BI Desktop

Quiz 1: Check your knowledge

Q1. How can you get Power BI to spot outliers and trends in your data?

• Use the Spotlight feature
• Export data to Microsoft Excel
• Use Quick insights
• Use Custom Q&A

Q2. How could you gather, arrange, and share interesting Power BI visuals from several different sources?

• Pin them to a Power BI report
• Pin them to a Power BI dashboard
• Export them to PDF
• Use the Get Data feature

Q3. If you think of some interesting questions to ask in your report, how could you share them to help your Q&A users?

• Use the Spotlight feature
• Include your questions in a text box on the report canvas
• Use the “Featured Q&A questions” feature
• Use the “Edit Queries” feature

Module 6: Publish and share in Power BI

Publish and share your Power BI reports and dashboards to teammates in your organization or to everyone on the web.

Learning objectives:

In this module, you will:

• Publish reports
• Print and export reports
• Build apps
• Integrate with OneDrive
• Publish to the web

Prerequisites:

Access to Power BI Desktop

Quiz 1: Check your knowledge

Q1. In Power BI, what does the “Publish” button do?

• Packaging your report and data on Power BI Desktop and sending them to the Power BI service.
• Packaging your report and data on the Power BI service and sending them to Power BI Desktop.
• Packaging your report and data and share it as an app.
• Packaging your report and data and saving it to PDF.

Q2. What is the purpose of a “workspace” in Power BI?

• To create a custom bundle of dashboards, reports, and data.
• To define the working area of a canvas.
• To designate the relationship between two tables.
• To define a set of colleagues who have access to specific dashboards, reports, and data.

Q3. What happens when you click Update after changing content that’s part of an app you already published?

• Nothing. You have now created a new fork of that content.
• The new content will automatically update anyone who has connected to your app
• Anyone who has connected to your app will receive a message and they can decide whether to accept the changes or keep the older version
• Anyone who has connected to your app will automatically update but they can roll back to the older version whenever they choose

Conclusion:

I hope this Create and use analytics reports with Power BI Microsoft Quiz Answers would be useful for you to learn something new from this problem. If it helped you then don’t forget to bookmark our site for more Coding Solutions.

This Problem is intended for audiences of all experiences who are interested in learning about Data Science in a business context; there are no prerequisites.

Keep Learning!

More Coding Solutions >>

LeetCode Solutions

Hacker Rank Solutions

CodeChef Solutions