You are an independent contractor, so you do not have an organizational email address. Can you still sign up for a Power BI trial subscription?
Yes, you
... [Show More] can get a trial subscription to Office 365, and then use that account to sign up for a Power BI trial.
You are trying to sign up for the free 60-day trial of Power BI Pro with your personal email, [email protected]. Why won't you be able to sign up for the free trial?
Your email address has to be a business email, not a Hotmail personal email address.
Which choice best describes how Power BI is used at a basic level?
to create models from which you will utilize other Power BI features
Renata is a business analyst who spends significant time modeling and transforming data. Which Power BI tool, a free download software, will Renata most often be using?
Power BI Desktop
What will you find in Favorites & Frequents on your Power BI service home page?
items you have set as favorites, or have used often by count
You have some Excel data stored in OneDrive for Business you want to analyze in Power BI. Which step must you do first?
Make sure the data is formatted as a table.
You would like to analyze data contained in an on-premises Access database. How will you do this with Power BI service?
Create a data model with Power BI Desktop, then connect the data model to the Power BI service.
You selected the Retail Analysis Sample from the available samples. What will be the result?
A dashboard, reports with visualizations, and a dataset of real data that has been anonymized will be added to your workspace.
You are uploading an Excel workbook. How do Excel workbooks differ from CSV files that you might upload?
The Excel data sources you upload will be formatted as tables.
Why would you store Excel files in OneDrive for Business for use with Power BI?
Excel files will be refreshable using OneDrive for Business.
When you are creating reports using Power BI to share data with other users, what are you ultimately doing?
You are creating a dashboard for users to access the information in the visuals you place in the report.
You would like a hierarchical visualization that shows total sales in Canada, then sales by province. Which visualization will provide this?
a treemap
You want a visualization that shows the contribution of each of your 12 sales regions to total sales for the quarter. Why is a tree map a better choice than a pie chart?
The contribution of each segment is easier to see and understand.
Your visualization is a table. How can you add alt text?
by selecting it from the Formatting options in the Visualizations pane.
The visualization you are creating has four tiles. How can you rearrange them so a particular tile is at the upper left?
Drag and drop the visualization to the desired location.
You are creating a new report and your first step is to select the Districts checkbox in the Fields pane. What will happen?
Power BI will immediately generate a visualization.
Your report has four visualizations, including a filled map and a column chart for your four sales regions. How can you quickly filter the report to display data only from the Northwest Region?
Select the Northwest Region of the column chart.
You are creating a visualization. The first item you selected from the Fields list has a calculator icon next to it. The next item selected does not have an icon next to it. In which type of visualization will the second item appear?
as a chart
You would like a visualization that shows how much of your third quarter sales goal has been reached. Which visualization will you choose?
a gauge
None of the visualizations you have will be useful to illustrate your data, so you go to Power BI Visuals. What will you find there?
third-party visuals, some of which are free, as well as visuals your organization has already selected
When you have multiple columns in a list, what effect does this have on sorting your data?
You can select which column you want to sort by.
How can you create multiselect slicers to display data for the Territories of Ohio, Michigan, and Indiana?
Select each of them from the Territory List while holding down the Ctrl key.
The visualization you want is based on your sales by state. When you select State in the Values option to create a list of states, what will happen?
A map will be created.
What must you consider when creating a report you know users will print out?
Keep visualizations that should be printed together on the same page.
Why should a report owner be cautious about changing the default behaviors for a report?
It can be confusing for a user to drill into a report and not have it behave as they expect it to.
You are the creator and owner of a report involving purchases by customers in your various sales regions. Why would you add filters to visuals?
to make working with the filtered data easier for users when they might not know all the details about the regions and customers
After creating reports for each of your regional sales managers from national sales data, you find that for the Midwest Region only data for Indiana is showing. What did you likely do?
When you created the report, you selected Indiana under Report level filters.
You decide the dashboard you created is not in the order you would like them to appear in the final report. How can you rearrange the pages?
Use the drag-and-drop feature to arrange the pages in the order you would like them to appear.
One reason to create reports is to share them with other users in print fashion, such as a PDF or PowerPoint. However, what often happens when you want to export a report to one of these file types?
Most of the custom Power BI visuals that you use in reports do not survive the exporting process.
in Power BI, what is the principal printing unit for a report?
a page
You have created a new dashboard with tiles from other dashboards. Your sales manager asks you to pin an element from Excel to the dashboard. When would you do this?
You would do this to pin a PivotTable to your dashboard.
How does a dashboard differ from a report?
You can use a natural language query with a dashboard.
How can you create a mobile view when you add a new tile to a dashboard?
Choose More (...) > Mobile View, then size all the tiles so they are most helpful for mobile users to see.
How does Quick Insights provide you with additional and valuable information?
Power BI churns through your data and tells you what it learned about your data.
What is the primary reason to use the Add a comment feature with tiles?
to start a conversation among your colleagues about the tile
You would like to provide some instructions to users of your dashboard. Where should you go in Add Tile to do this?
text box [Show Less]