3. Demonstrate the business value of Power BI Flashcards
Identify and describe uses for visualization controls
Visuals allow you to present data in a compelling and insightful way and help you to highlight the important components. To create a new visualization drag field names from the Fields pane and then drop them on the report canvas, or in the Visualizations pane, select the type of visualization that you want to create.
Describe types of filters
Page filter: Applies to all the visuals on the report page
Visual filter: Applies to a single visual on a report page
Report filter: Applies to all pages in the report
Drillthrough Filter: Applies to a single entity in a report
Describe Tabs
NA
Describe uses for custom visuals
Visualize data your way, with our rich library of fully-customizable, open-source data visualizations. With the custom visuals SDK, you can create stunning visualizations, based on well-known JavaScript libraries such as D3, jQuery, and even R-language scripts.
Describe Dashboards
A Power BI dashboard is a single page, often called a canvas, that uses visualizations to tell a story. Because it is limited to one page, a well-designed dashboard contains only the most-important elements of that story.
Describe Workspaces
Workspaces are places to collaborate with colleagues on specific content. Workspaces are created by Power BI designers to hold collections of dashboards, reports, and apps.
Describe the Power BI Desktop
Power BI Desktop is a free application you install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them into a data model. Most users who work on business intelligence projects use Power BI Desktop to create reports, and then use the Power BI service to share their reports with others.
Describe the Power BI Service
The Microsoft Power BI service (app.powerbi.com), sometimes referred to as Power BI online, is the SaaS (Software as a Service) part of Power BI. See: Comparing Power BI Desktop and the Power BI Service.
Describe how to combine multiple data sources
With Power BI Desktop, you can connect to many different types of data sources, then shape the data to meet your needs, enabling you to create visual reports to share with others. Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
Describe how to clean and transform data
Shaping data means transforming the data: renaming columns or tables, changing text to numbers, removing rows, setting the first row as headers, and so on. Shape data by using Query Editor.
Describe and implement aggregate functions
Sometimes you want to mathematically combine values in your data. The mathematical operation could be sum, average, maximum, count, and so on. When you combine values in your data, it’s called aggregating. The result of that mathematical operation is an aggregate.
Identify available types of data sources
With Power BI Desktop, you can connect to data from many different sources. For a full list of available data sources, see Power BI data sources. You connect to data by using the Home ribbon. To show the Most Common data types menu, select the Get Data button label or the down arrow.
Describe shared datasets in Power BI
As a creator of data models in Power BI Desktop, you’re creating datasets that you can distribute in the Power BI service. Then other report creators can use your datasets as a basis for their own reports.
Describe Power BI Template Apps
As a Power BI partner, you create a set of out-of-the-box content for your customers and publish it yourself. You build template apps that allow your customers to connect and instantiate within their own accounts. As domain experts, they can unlock the data in a way that’s easy for their business users to consume.
Describe the Power BI Layout
Move Tiles: On the dashboard, locate the new tile. Select and hold the tile to drag it to a new location on the dashboard canvas. Resize Tiles: You can make tiles many different sizes – from 1x1 tile units up to 5x5. Select and drag the handle (in the bottom right corner) to resize the tile.
