The objective of this course “Foundations of Power BI – Data to Dashboard” is to make you learn how to produce effective reports in Power BI Desktop and share them on Power BI.com. You get to learn how to use Power BI for loading data, creating reports, sharing the reports, creating dashboards, etc. You will learn how to use Power Query to clean the data before loading and few Power Query techniques.
In this module, you will learn how to create your first Power BI report - <strong>Sales Summary Report </strong>as shown below. You will learn how to define the layout of the Power BI report, add a logo, add the title for the report, add various visuals such as Map, Column Chart, Bar Chart, Line Chart, Slicer, and Card. You will also learn about the default <strong>cross-filtering</strong> and how to set it the way you want. You will understand the difference between Slicer filtering and cross-filtering. You will also learn about having your own <strong>theme</strong> and how to find and set various formatting options. You will learn how to use <strong>Bookmarks</strong> in your report to create various views of the report and view them later like a PowerPoint presentation. <img class="alignnone wp-image-28175 size-full" src="https://exceleratorbi.com.au/wp-content/uploads/2019/01/Sales-Summary-Report.png" alt="Sales Summary Report" width="927" height="541" /> The following are the lessons in this module:
- An Introduction to Building Power BI Reports
- Building Power BI Reports – Map Visual
- Building Power BI Reports – Column Chart Visual
- Building Power BI Reports – Bar Chart Visual
- Building Power BI Reports – Slicer Visual
- Building Power BI Reports – Card Visual
- Building Power BI Reports – Line Chart Visual
- Building Power BI Reports – Bookmarks
In this module, you will learn to create 3 more types of reports in Power BI Desktop. The <strong>Top Customers Report</strong> displays the top customers based on ranking on a specific field.<strong> </strong>You can choose to display the top, say, 20 customers. The <strong>Customer Detail Report</strong> uses the Drillthrough feature of Power BI Desktop. You can drillthrough from Top Customers Report to Customer Detail Report for a specific customer. The <strong>Tooltip Report</strong> uses the Tooltip feature in a report page of Power BI Desktop. You can display a custom Tooltip in any of reports for the specific field for which Tooltip report is created. <p id="bsfEVWk"><img class="alignnone size-full wp-image-28476 " src="https://exceleratorbi.com.au/wp-content/uploads/2019/01/img_5c4911be1f6b0.png" alt="" /></p>
In this module, you will learn about sharing Power BI reports. You will learn how to sign in to Power BI.com, create a workspace, publish reports from Power BI Desktop to Power BI.com, and create dashboards. You will also learn how to create reports in Power BI.com and the various sharing methods available from Power BI.com. You will understand the major features in Power BI.com, including Quick Insights and Analyze in Excel. <img class="alignnone wp-image-28180 size-full" src="https://exceleratorbi.com.au/wp-content/uploads/2019/01/Sharing-Power-BI-Reports.png" alt="" width="1639" height="785" />
In this module, you will learn how to use Power Query to edit the data before loading it to Power BI Desktop. You will understand Power Query features and some of the Power Query techniques.