Introduction to Microsoft Power BI

Introduction to Microsoft Power BI

It all starts with the dataset, which simply means the data you have connected to. These datasets are then added to reports as visualizations, which present that data in a graphical way. 

The Power BI web and mobile apps go a step further with dashboards, which allow you to collect visualizations from different reports into a single location. 

Each dashboard is made up of tiles, which are simply visualizations linked back to the original report. These dashboards can be collected into workspaces.

For example, sales by region might be presented as a map, with a bubble representing each amount:

The Query Editor Interface

On the left (1), you will see a list of queries, with the data displayed in the center pane. Its settings can then be modified using the commands on the ribbon (2). These settings are listed in the Query Settings pane (3), which we will take a closer look at in a moment. Once you have finished making your changes, click Home→ Close & Apply (4).

Managing Report Pages

Showing and Hiding Pages

To temporarily hide a page, right-click its tab and click Hide Page:

The page tab will then be grayed out. You can show it again by right-clicking the page tab again and de-selecting Hide Page.

You can use this same right-click menu to duplicate the current page, rename the page, or delete it

Changing Page Order

To change the order of pages, simply click and drag the tab:

Release your cursor when you have reached the desired location.

Navigating Through Pages

To view a different report page, simply click its tab at the bottom of Report view:

The Web App Interface

1. App Launcher

2. Breadcrumb Trail

3. Office 365 Commands 

4. Search field

5. Navigation pane 

6. Canvas 

7. Get Data

Microsoft Windows Reference Guide Part A

The Snap Feature

To snap any open app to either the left or right side of your screen, drag the title bar to either left or right edge of the screen until you see a ripple effect expand to outline half of the screen. To snap an app to a corner, click and drag the title bar of the app in question to the appropriate corner of the screen. Release your mouse button and the selected app will expand to fill in that half of the screen: 

Keyboard Shortcuts 

Cortana Voice Commands

As you speak a voice command, its interpretation of what you are saying will be printed in the search box. After a brief moment, a response will be presented both visually inside the Cortana menu and audibly: 

Elements of the Microsoft Edge Window

Using Cascade, Stack, and Side By Side Functions

Windows 10 also includes several options that will automatically arrange all open windows. To access these options, open the windows that you would like to arrange and right-click on a blank area of the taskbar. In the middle of the context menu that appears, you will see three window management options: “Cascade windows,” “Show windows stacked,” and “Show windows side by side.”

Password Sign In

In addition to traditional alphanumeric passwords, Windows 10 supports PIN and picture passwords. PIN passwords are simple numeric passwords that can be used in place of a regular password. With picture passwords,  you recreate mouse gestures on a picture that you previously set up.

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London