Creating Power BI Reports (Beginner)

GENERAL 

• What is Power BI? 

• Power BI Versions (e.g. desktop, app service, mobile app) 

• Power BI Licensing and Sharing Reports 

DATA & MODEL LAYERS 

• Importing data (connecting to data, extracting and loading the data into the data model). 

• Changing Data Source settings 

• Introduction to Data Modelling 

• Setting Data Types and formatting columns 

• Working with simple relational data in Power BI 

• Performing simple tasks using the Power Query Editor. 

• Building Hierarchies (optional) 

VISUALISATION LAYER 

• Using common Chart types 

  • Line 

  • Column / Bar 

  • Scatter 

  • Ribbon 

  • Discouraging pie chart 

• Conditional Formatting 

  • Non-Chart types 

  • Cards 

  • Tables 

  • Matrix 

• Visualising geographical data with maps (the basic map) 

• Formatting Charts 

• Choosing a Theme  

• Creating a Theme with your company’s colours 

• Using Shapes, Text and Buttons to enhance your reports 

• Drilling down into your data. 

• Filtering and Slicing 

• Good Practice for Designing Reports (with interactivity in mind) 

APP SERVICE 

(The "app service" is Microsoft's name for the web portal https://app.powerbi.com)

• Publishing a Report to the App Service 

• Understanding Workspaces 

• Modifying a Report on the App Service 

• Building a Workspace App 

• Sharing reports 

  • Setting permissions on a Workspace Application is the preferred way to share

ASSIGNMENT

• Presentation of a Power BI dashboard to peers (final session)