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

Check out more Power BI courses in UK

Computer Training Wales Logo

Microsoft PowerBI (Business Intelligence) Beginner Course

This course is specifically designed to provide you with a solid foundation in using PowerBI, a powerful business intelligence tool that enables you to transform raw data into meaningful insights and compelling visualisations.

by Computer Training Wales [Claim Listing ]
Media Training Logo

Power Bi Business Analytics

Learn to analyse and publish data from a variety of sources using this powerful software. Create boards, visualisation and dashboards that can then be published.

by Media Training [Claim Listing ]
London IT Training (LIT) Logo

Big Data Hadoop Training

Big Data is a term that means a huge amount of data and Hadoop is an open-source framework from Apache that is used to run applications on the cluster. Without Big Data Hadoop training, you may learn very little about Big Data processing.

by London IT Training (LIT)
Framework Training Logo

Data Visualisation With R Training Course

You’ll learn about basic graph types such as bar charts, scatter and box-whisker plots, as well as more “exploratory” types such as scatter plot matrices and conditioning plots. You will also learn how to alter basic graphical parameters, and thus customise your graphics to best effect

by Framework Training [Claim Listing ]
Mullan I.T. Training Logo

Microsoft Power Bi

This 1 day course covers the essential skills in Power B: Connecting, Extracting & Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts and Dashboards.

by Mullan I.T. Training [Claim Listing ]

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