Microsoft Power BI Desktop

by I Train Scotland Claim Listing

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

$350

Contact the Institutes

Fill this form

Advertisement

I Train Scotland Logo

img Duration

1 Day

Course Details

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
  • Edinburgh Branch

    CBC House, 24 Canning Street, Edinburgh

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy