Here are some examples of data transforming: If your dataset needs to be edited before it can be analyzed, choose to Transform Data when you are loading your data.Ĭhoosing 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. Go to Transform Data below for more information. Choose Transform Data if you need to make modifications so that it can be analyzed.Choose Load if your data has already been transformed and normalized so that it is ready for analysis.View Screenshot Select data source from the left panel. Once the Navigator opens, select the specific data you want to load and then choose to Load or Transform Data.Browse to the location of the data you want to load and select Open.Choose your source from the list and select Connect.View Screenshot Select the Get Data link from the ribbon. Power BI can load data from many sources such as Excel, SharePoint, Access, and SQL. View Screenshot All apps located at the bottom-left of screen If this app is not in the list on the left side, choose All apps and enter Power BI in the search bar.View Screenshot Waffle icon is the 9 dot icon in the blue bar. Select the waffle in the upper left corner.Log in with your KU Online ID and password.Open your internet browser and navigate to the Office 365 landing page.Select the Microsoft Power BI Desktop app.Select the Software Center App to open it.

Type software center into your search bar / start menu in the lower left corner of your home screen.

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. Both applications are required for full capabilities. 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.

Data visualization: Creating graphs, charts, maps, etc., for a visual representation of data.

Data modeling: Connecting data from different sources and using DAX functions to create relationships.

Data discovery/shaping: Bringing data from other sources into Power BI, and making sure it is correctly formatted.

It allows you to aggregate data from multiple sources, analyze it, and then create visuals to tell a story.

Power BI is a personal Business Intelligence software. KU Technology YouTube Instructional Videos >

Power bi in mac