English | 6 May 2018 | ASIN: B07CWMF89B | 135 Pages | PDF | 9.58 MB
In this course, we will explain Power BI features that can be used to create a dashboard of different reports describing related tables. We will take the students through a step-by-step process displaying the capabilities including Getting Data, Query Editor, Data View, Relationships, Visual Reports, Formatting, Filtering, Publishing on the Web, and Creating a Dashboard. The final step will post the Dashboard on the internet to be shared with others.
Power BI Process Overview - Here we will describe the Power BI program, how to download it, and how it relates to the online Power BI tools. We will also discuss terminology and the overall process to create a dashboard. You need to install Power BI Desktop in order to attend the class. Go to http://PowerBI.com/pricing to get your free download. Get Data - This will extract the data source from a database such as Excel, Access, etc. Query Editor - This will allow us to review the data extracted and filter or remove specific records prior to saving it to the Power BI file. Data View - This will allow us to review the structure of the data extracted and add additional fields as needed. These new fields can be used for establishing relationships or creating new fields. Relationships - This will allow the different tables to display how data is tied together. Storing all data into a single table isn’t as efficient as storing data in separate tables containing specific information. Visual Report - This will generate different reports describing the data from different tables. These reports will include Charts, Matrix, Tables, Summary Information, Maps, etc. Filter Report - Once you create a report, it can be filtered to display the desired information.
Format Report - Once you create a report, it can be formatted to display the desired layout. Publish Report - Once reports are complete, they can be Published to a web browser version of Power BI and shared with others on the internet. Create A Dashboard - Once reports are Published, they can be organized into a dashboard layout for others to preview. Different Dashboards can be created describing a different set of data in each of the tables.