Microsoft Power BI Full Course

Student Project B - Process Using Relational Database In this Student Project, we will walk through an example that includes three worksheets that need to be related, similar to a relational database. Will go through all steps from the beginning as you Get Data, and to the end of Publishing. We will not repeat the explanation of the concepts from the previous chapter but will add additional notes as necessary.

In this video, we will take students through a step-by-step process to develop a report. This includes using Get Data, Query Editor, Data View, Model View, Report View, Formatting, Filtering, Publishing on the Web, and creating a Dashboard. The Power BI products used in this chapter include: Power BI Desktop - This is a free downloadable application, installed locally on your computer and used to create/develop Visual Reports (charts describing a data source). Power BI Pro Web Service - This will allow you to Publish Visual Reports and organize them into a single Dashboard which is viewable in a Web Browser by anyone who has rights. Tip: If you do not have these products installed on your computer, you can obtain an evaluation copy by going to http://PowerBI.com/pricing.

In this video, we will review design strategies and tools associated with Power BI. The following include the Tools that will enhance the overall process of Power BI: Power BI Desktop - This is used to Filter data from the database, relationships between tables, as well as develop Visual Reports. Power BI Edge Webview2 - Power BI Desktop will work with most supported browsers, but you will see performance improvements by using Microsoft Edge WebView2 Runtime. Power BI Pro Web Service - This will post or publish Visual Reports in order to share them via the Internet. This product will also build a Dashboard from Visual Reports. Power BI for Mobile - This will provide access to Visual Reports and Dashboards on a Smart Device or Tablet. Power BI Publisher For Excel - This is built into Excel and allows you to publish charts, PivotTables, and other objects to Power BI Pro Web Service. Power BI Data Gateway - This will connect Power BI Pro Web Service directly to a data source located on a network (enterprise mode), or to a local data source (personal mode). Power BI Report Builder - This is a Visual Report tool that creates page size layouts (paginated reports) and can contain multiple pages. Power BI Developer Tools - There is a wide range of Developer Tools available for Power BI.