ONE DAY COURSE OUTLINE
Prerequisites
An intermediate knowledge of Excel including charting and tables. It would also be beneficial to have a basic understanding of Pivot Tables but not essential
Overview
Learn how to create powerful interactive dashboards, custom reports, analyse data and share insights. After the completion of this course you will be able to create rich dashboards available on every device that will allow you to monitor your business and get answers quickly
| Introduction | • The three main tools: Power BI Service, Power BI Desktop and Power Bi Mobile • Content samples |
| Using data from an Excel workbook | • Understand and import data |
| Visualisations | • Create and work with visualisations • Format visualisations |
| Visualisations to Reports | • Adding pages to reports • Re-using visualisations • Using text boxes and shapes • Publish the report to a Power BI Service |
| Visual Interactions | • Turn interaction on or off • Interacting by filtering, highlighting or none |
| Working with Filters | • Slicers, Field filter, Top N filter, page filters, report level filters |
| Q & A and Quick Insights | • Activate Quick Insights • Pin visualisations from Quick Insights to a Dashboard |
| Power BI Desktop | • Use Query Editor to clean up data tables • Format properties of data • Create extra tables of data • Create, manage and delete a relationship |
| Use Custom Visuals | • Import custom visuals |
| Databases and Power Bi | • Import a database and view relationships • Create visualisations from a database • Design business insight visualisations |
| Working with Data | • Create and use calculated columns |
| Working with the Power BI Service | • Uploading versus importing data • Printing and publishing reports • Power BI Publisher for Excel • Sharing Dashboards • Power BI Mobile |
