Getting Started with Power BI Desktop

• Power BI Concepts and Overview

• Introduction to Main Features

• Imports

• Visualisations

• Filters and Queries

• Reports

Connecting to Data Sources with Power BI Desktop

• Data Sources Power BI Desktop will connect to

• Data Types and Properties in Power BI Desktop

• Import and Enter Data

• Get Data and Query Editor

• Introducing the Query Editor

• Using the Query Editor to Connect to Data

• Combining Data Sources as a Mash Up

• Working with Relationships in Data

Data Visualisations

• Overview of Data Visualisations

• Tables and Matrix Views

• Applying Conditional Formats

• Charts

• Interactive Data and Date Slicers

• Drill Visualisations to see underlying data

• Create Reusable Field Hierarchies

• Record Grouping and Binning in Visualisations

• Drill Visualisations with using Dates

• Clustering

• Analytics and Forecast Lines in Visualisations

• Creating Role Based Views

• Data Categories, Geo-Data and Maps

Querying and Shaping the Data

• Common Activities using Query Editor

• Filters

• Transforms

• Pivot and Group By

• Creating Custom Calculated Columns

• Adding Conditional Columns

• Introduction to DAX Expressions Histograms

Reports and Output Options

• Report Elements and Options

• Working with Pages

• Adding Graphics

• Visual and Filter Settings

• Export Power BI Data to CSV

• Create a Power BI Template