Introduction

• Self-Service BI

• Tool  architecture and structure

• Development workflow and overall flow

Data Import & Transformation with Power BI Query Editor

• Introduction to Power BI Query Editor

• Extract – importing data from multiple sources

  • Files (Excel, text)

  • SQL databases

  • Folders

• Transform – data transformation and process automation

• Creating a Date Dimension (enabling slicing by day of week, month, quarter, year)

• Developing data transformation automation

  • Joining tables

  • Creating calculated columns

  • Filtering data

  • Splitting and merging columns

  • Data cleansing

• Introduction to the M language

Data Modelling

• Data modelling rules and best practices

• Data modelling methodologies

• Introduction to Star Schema and Snowflake Schema

• Defining relationships between tables

Measures

• Overview and definition of measures and KPIs

• Introduction to DAX and the impact of the data model on measure design

• Developing measures using DAX

• Time intelligence measures for period-over-period comparison and cumulative      calculations

Reports

• Report,design and development

• Best practices and tips for report design

• Using filters and different visualizations

• Adding visuals and colour palettes from the Microsoft marketplace

• Using bookmarks, tooltips, and drillthrough

• Using buttons

• Mobile-optimized report design

Power BI Service (Cloud Environment)

• Introduction to the Power BI cloud service

• Publishing the model from Power BI Desktop to the cloud service

• Installing and configuring the Gateway

• Creating dashboards

• Sharing reports and dashboards

• Managing permissions and workspaces

• Configuring scheduled refresh and data source settings via the Gateway