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

Mulan Technology 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 Mulan Technology [Claim Listing ]
Enliten IT Logo

Power BI Desktop Course (Introduction)

Our Microsoft Power BI Desktop Introduction course will introduce delegates to Power BI which is a cloud-based business analytics service that allows you to gather, shape, analyse and visually explore data.  

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

Power Bi Dax Training

DAX (Data Analysis Expression) is a customised formula expression language and can be integrated with different BI (Business Intelligence) and Visualization tools. Power BI DAX is one such powerful application tool developed and released by Microsoft. DAX is also familiar as a functional language, ...

by London IT Training (LIT)
Staffordshire University Logo

Data Analytics

Making sense of new data is vital to allow organisations to carry out business, respond to changes, and take advantage of new opportunities. In this module, you will study data quality and learn how to apply data quality measures to real-life data sets.

by Staffordshire University [Claim Listing ]
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 ]

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