Microsoft Power BI Desktop

Power BI Desktop is a business analytics service which delivers powerful insights to enable fast and informed decision making.  Connect to hundreds of data sources with Live connections for automatic data synchronisation. 

Produce beautiful reports, then publish them for your organisation to consume on the web and across mobile devices. Everyone can create personalised dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.

Course Goals:

• Understanding Power BI Desktop features and uses
• How to connect to a variety of data sources
• Manipulate data with Power Query
• Create exciting data visualisations
• Publish to Power BI.com and create shareable dashboards
• Learn shortcuts, tips and expert advice in a hands-on environment

Topics:

Lesson 1: Getting started with Power BI Desktop

• What is Power BI Desktop?
• Overview demonstration of concepts
• Overview of main features:
  • Creating Dashboards
  • Reports
  • Data
  • Modelling data
  • Visualisations
  • Publishing to Power BI.com

Lesson 2: Data Sources

• Connecting to Excel files
• Connecting to SharePoint, OneDrive, Outlook, Office 365 and other cloud services
• Connecting to databases inc. Access and SQL
• Connecting to Google Analytics, Facebook, Salesforce, Adobe, Mailchimp, Stripe, QuickBooks, and more
• Refreshing and synchronising data
• Working with relationships

Lesson 3: Data Visualisations

• Matrix Pivot tables
• Charts
• Interactive Slicers
  • Date timelines
  • Number slicers
• Geographic data and maps
• Drill Visualisations
  • Hierarchy
  • Levels
• Visualisation interactions in reports
• Importing Marketplace custom visualisations
• Q&A

Lesson 4: Transforming and shaping data

• Overview of Power Query Editor
• Transforming data
  • Data type
  • Unpivoting columns
  • Delimiting
  • Combining and merging
• Cleaning and trimming data
• Calculated columns using DAX
• Measures

Lesson 5: Modelling data

• Overview of relationships
  • Primary / foreign keys
  • Cardinality
• Creating, editing, and managing relationships within Power BI Desktop
• Importing existing relationships from relational databases
  • Autodetecting

Lesson 6: Publishing to PowerBI.com

• Linking with Power Bi Desktop files
• Linking / live synchronising with data sources held in the cloud
• Creating Dashboards
• Sharing Dashboards
• My Workspace
• Creating Insight reports