Power BI


Overview

Power BI is a personal Business Intelligence software. It allows you to aggregate data from multiple sources, analyze it, and then create visuals to tell a story. 

The Power BI lifecycle includes:

  1. Data discovery/shaping: Bringing data from other sources into Power BI, and making sure it is correctly formatted
  2. Data modeling: Connecting data from different sources and using DAX functions to create relationships
  3. Data visualization: Creating graphs, charts, maps, etc., for a visual representation of data

Power BI includes a desktop application that must be installed and a web-based application that requires signing in with your KU Online ID and password. Both applications are required for full capabilities. The desktop application is only available on the Windows operating system; if you use a Mac, please contact your Technology Support Center staff for assistance. 

Access Power BI

Power BI includes a desktop application that must be installed and a web-based application that requires signing in with your KU Online ID and password. Both applications are required for full capabilities. The desktop application is only available on the Windows operating system; if you use a Mac, please contact your Technology Support Center staff for assistance. 

Install the Desktop App

(Windows operating system required)

  1. Type software center into your search bar / start menu in the lower left corner of your home screen.
  2. Select the Software Center App to open it.
  3. Select the Microsoft Power BI Desktop app. 
  4. Select Install.

Access the Online Power BI Service

  1. Open your internet browser and navigate to the Microsoft 365 landing page.
  2. Log in with your KU Online ID and password.
  3. Select the waffle in the upper left corner.
    View ScreenshotWaffle icon is the 9 dot icon in the blue bar.
  4. Select the Power BI app.
  5. If this app is not in the list on the left side, choose All apps and enter Power BI in the search bar.
    View ScreenshotAll apps located at the bottom-left of screen

Load Data

Power BI can load data from many sources such as Excel, SharePoint, Access, and SQL. 

  1. Select Get data from the Home ribbon.
    View ScreenshotSelect the Get Data link from the ribbon.
  2. Choose your source from the list and select Connect.
  3. Browse to the location of the data you want to load and select Open.
  4. Once the Navigator opens, select the specific data you want to load and then choose to Load or Transform Data.
    View ScreenshotSelect data source from the left panel.
    1. Choose Load if your data has already been transformed and normalized so that it is ready for analysis.
    2. Choose Transform Data if you need to make modifications so that it can be analyzed. Go to Transform Data below for more information. 

Transform Data

If your dataset needs to be edited before it can be analyzed, choose to Transform Data when you are loading your data. 

Choosing to Transform Data will open the Power Query Editor which allows you to complete many steps that will normalize your data so it is ready for analysis.
View ScreenshotPower Query Editor.

Here are some examples of data transforming:

  • Reduce data down to smallest meaningful value (ex: columns with first and last names should be split into separate columns)
  • Remove unnecessary data (ex: columns of information you know you don't need for your analysis)
  • Standardize data (ex: characters like $ or extra spaces will interfere with analysis)
  • Reconcile data types (ex: columns that contain dates should be formatted as a date type)

After finishing the data transformation process, choose Close & Apply in the upper left corner. This will apply your changes to the dataset and close the Power Query Editor.

Create Reports

Create a Visual

  1. Choose Report mode from the left menu.
    View ScreenshotReport mode icon from the left menu.
  2. Your datasets will be listed in the Fields pane on the right side.
    View ScreenshotFields pane on the right side.
  3. From the Visualizations pane, choose the visual you'd like to create; for example, a column chart, pie chart, etc.
    View ScreenshotVisualizations pane.
  4. In the Fields pane, select the box next to the fields you want to include in your visual. 
  5. Repeat this process to create multiple visualizations and build your report. Use the + button at the bottom of the page screen to add pages to your report as needed.

Format the Visual

  1. With the visual selected, choose Format from the Visualizations pane (the paint roller). 
    View ScreenshotChoose the paint roller icon to Format.
  2. Options listed under Format are dependent upon the type of visual you have created, but in general, you can change things like the title of the visual, colors, and data headings. You can also add a border or a shadow outline around your visual.

Publish the Report

After creating your report, you will need to publish it to your online Power BI Service so that it can be shared with others.

  1. Select the Publish button from the home ribbon.
    View ScreenshotPublish icon far-right in ribbon.
  2. Select My workspace as the destination. 
  3. Click the link to open your report in Power BI
  4. Once the report opens in the online Power BI Service, you can choose to share the report and/or build a dashboard. Find more information about sharing reports and building dashboards using the left navigation.

Share Reports

You can share your report with others in several ways. If your intended recipient has a Power BI Pro account (all KU faculty and staff do), you can share your report directly through Power BI. You can also share your findings by exporting to a PDF or PowerPoint, embedding in a website, or adding to a Microsoft Team. 

Share Through Power BI

  1. Select Share from the top menu.
    View ScreenshotShare button in the ribbon.
  2. Select to whom you want to send the link and choose permission settings.
    View ScreenshotDesignate who can open the file.

Export to Another Program

  1. Select Export from the top menu.
  2. Choose to export to PowerPoint, PDF, or Analyze in Excel (which will require installing extra features in Excel).
    View ScreenshotExport option in top menu.

Exporting to PowerPoint creates a connection between PowerPoint and Power BI so that when you use a visual from your report in a PowerPoint presentation, clicking on the visual will take you to the full Power BI report.

Exporting to PDF creates a static document of your visuals. 

Share Through Microsoft Teams

  1. Select Chat in Teams from the top menu.
    View ScreenshotChat in Teams option in top menu.
  2. Choose to Share to a channel or Create an Assignment. 
  3. Search for the appropriate Team/Channel.
  4. Click Share.

Note: Before you can add a report to a Team:

  • The Teams tab must have Power BI enabled.
  • Team members must have permission through Power BI to view the report. (see "Share through Power BI" above)

Dashboards

After publishing your report to the online Power BI Service, you can build a dashboard to share with others. The dashboard is a single page of visualizations that have been carefully curated to present a summary of analysis. You can also share the full report with others from the Power BI Service. Find more information about Sharing reports in the left navigation.

Build a Dashboard

A Power BI dashboard is a single page that uses visualizations to tell a story. Clicking on a visual takes you to the full report that was used to create it; one dashboard can contain visuals from multiple reports and datasets. 

  1. Open your report from your workspace.
  2. Hover on a visual that you want to pin to your dashboard.
  3. Select the pushpin that appears in the icon menu.
    View ScreenshotPin icon.
    If you don't see the pin, you made need to move your visual around.
  4. When the Pin to dashboard window opens, choose to pin your visual to a New dashboard and name your dashboard.
    View ScreenshotSelect button next to New dashboard, then name your Dashboard in field.
  5. Repeat this process until you have built your dashboard.

Share Your Dashboard

  1. Choose Share from the ribbon at the top.
    View ScreenshotShare button in the ribbon.
  2. In the Share dashboard window, enter the email address of the person with whom you'd like to share your dashboard. Include a message, and select permissions, as appropriate.
    View ScreenshotShare dashboard window.

Use Someone Else's Dashboard

Watch Power BI Dashboard (video) for instructions on how to use a dashboard that's been shared with you.

Refresh Reports

Most reports will use data that is periodically updated, which requires that the report be updated as well. You can set your report to refresh, pulling in the new data from your original data sources and updating your reports and dashboards. 

The refresh process is much simpler when your data is saved in the cloud (such as on a SharePoint, Teams, or OneDrive for Business site) than if it is saved on premises (such as in your department's drive on the KU network). When data is saved on premises, Power BI needs a "gateway" to be able to connect to the data. 

Data Refresh in the Cloud

  1. After creating your report, make sure it has been published to the Power BI online service. Navigate to Create Reports in left navigation for more information.
  2. After your original data source has been updated, log in to the online Power BI Service.
  3. Select the workspace where your project is saved.
  4. Hover on the project's Dataset and select the Refresh now icon.
    View ScreenshotWaffle icon is the 9 dot icon in the blue bar.
  5. Under the Refreshed column, a spinning circle will appear to indicate Power BI is processing your request, and the date/time stamp under the Refreshed column will update to the current date/time once the request is finished.
  6. Select your Report.
  7. Select the Refresh icon in the upper right corner of the report. 

Data Refresh On-Prem

  1. After creating your report, make sure it has been published to the Power BI online service. Navigate to Create reports in left navigation for more information. 
  2. Contact your TSC staff member for assistance in installing a gateway on your computer. This gateway will need to be connected to all of your original data sources so that Power BI can access them.
  3. Follow the steps listed above for Data saved in the cloud.

Schedule Automatic Refresh

  1. Find the workspace where your project is saved in the Power BI online service.
  2. Hover on the project's Dataset and select the Schedule refresh icon.
    View ScreenshotSelect the refresh icon to the right of project dataset name.
  3. Expand the item called Scheduled refresh.
  4. Toggle the switch from Off to On.
    View ScreenshotSelect toggle to switch Off to On.
  5. Select your refresh frequency and other details and choose Apply.

Data Modeling

Data modeling in Power BI has 2 components:

  1. Creating relationships between datasets.
    View ScreenshotExample of relational tables.
  2. Writing calculations using the DAX (Data Analysis Expressions) formula.
    View ScreenshotExample of calculations using DAX.

Workshop Recordings

We are currently hiring for the position that will teach the Power BI classes. We plan to offer these courses again once the position has been hired and up-to-date. In the meantime, find recordings of the Power BI workshops here. 

Power BI Essentials I (video)

Power BI Essentials II (video)

Class Materials:

Central Sales Data (xlsx)

Southwest Sales Data (xlsx)

 

Microsoft Updates & Tips

Updates and new features for Microsoft 365 apps, including Teams, can be found in our public team, KU Teams User Group. A channel in this team is dedicated to Microsoft 365 apps. In addition to updates, members are invited to ask questions and share information.

If you need assistance joining the team, reach out to us at training@ku.edu and we will add you to this team.