Microsoft Power BI

Duration: 
2 days
Codes: 
BI

Overview

Verhoef's Microsoft Power BI training course shows attendees how to use the latest collection of on-premise and online tools to enable them to find, clean, model, and visualize data, share discoveries, and collaborate in intuitive new ways.

Power BI is the latest set of Microsoft BI tools for data mash up, data modelling, and data visualisation. The results can be deployed on-premise or in the cloud and can be visualised in browsers, on tablets, and on mobile phones.

This course will take you through the product, demonstrating functionality, with plenty of hands on so that you can learn to use this powerful tool to help you transform your rows of data into a compelling interactive visual story.

Audience

Business Analysts, Financial Analysts, Data Scientists and Staff who need to use Power BI for producing reports from Excel, SQL Server and other databases.

Prerequisites

There are no prerequisites for this course.

Course Outline

  • Power BI Service
  • Self-service BI
  • Organisational BI
  • Portal
  • Content Items
  • Datasets
  • Connecting to Data
  • Visualizing Data
  • Reports
  • Reading View
  • Editing View
  • Visualisations and Custom Visualisations
  • Dashboards
  • Power BI Mobile
  • Native Applications (iOS/Android/Windows)
  • Viewing Content
  • Sharing & Collaboration
  • Configuring Alerts
  • Power BI Desktop
  • Data Models
  • Schemas
  • Relationships
  • Connectivity
  • Design Environment
  • Navigation
  • Importing Data
  • Transforming Data
  • Queries & the Query Editor
  • Data Previews
  • Shaping & Cleansing Data
  • Basic Transformations
  • Loading Transformed Data
  • Combining Datasets
  • Functions
  • Date Tables
  • Refining the Model
  • Tables & Columns
  • Data View
  • Exploring Data
  • Managing Schema & Data Changes
  • Connections & Tables
  • Data Refresh
  • Relating Tables
  • Rules & Limitations
  • Auto-Detecting
  • Relationship View
  • Calculations
  • Data Analysis Expressions
  • Calculated Columns
  • Measures
  • DAX Syntax
  • DAX Functions
  • Advanced Relationships

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Somerset Bath2 795 £795 2020-01-21
Somerset Bath2 795 £795 2020-04-06