Comprehensive Power BI

This course combines Power BI Introduction, Intermediate and Advanced. Introduction: Day one is meant to serve as a primer for a student who is new to Power BI, and what it can do. It will include a basic tour of the Power BI desktop to how to build report/dashboard elements. If you are relatively familiar with these topics, please refer to the intermediate course. Students will learn how to navigate the Power BI desktop. You will interact with existing reports to demonstrate the capabilities of Power BI. You will see how slicers, drill down, drill through, buttons, bookmarks, and more interactions can provide dynamic and interactive reports and dashboards. You will also learn about workspaces and their contents and how to share reports with your peers. After the tutorial of the desktop, and how to interact with existing reports, you will start a basic lesson on how to build dashboard elements. This will include how to create text cards (a visual that displays a numeric calculation, be it a sum or average, or standard deviation) and display that numeric value with basic details on a dashboard. We will also look at basic graphics such as a simple chart, and how to apply slicers, filters, and drill-through capabilities (which take you to the details of what that chart was based on). Intermediate: In day 2 of this course, you will start with a review of basic visualizations, slicers, filters and drillthrough. You will learn how to build tables, matrixes, a card, and multi-row cards. You will learn about formatting labels, creating pie charts, donut charts, gauges and treemaps. Filtering these visualizations will also be covered. We will cover text boxes, images and shapes to make your report more customized. We will also cover the formatting of a report page, such as tooltips, Q&A (which is amazing!), page sizing, backgrounds, alignment, borders, lock aspect, tooltips, and visual headers. Advanced: In day 3 of this course, we will look at chart formatting (x axis and Y axis), styles, formatting, sentiment colors, column and row headers, subtotals, grand totals, and conditional formatting. We will also look at controls for data bars and analytic lines. You’ll also learn how to have slicers synchronize across a report, how to create custom tooltips, custom maps, and more!