Microsoft Power BI Fundamentals Course

Duration: 2 days

 

What this course will do for you:

Power BI is a cloud-based business analytics service that gives you a complete view of your most critical business data. You can generate powerful insights into your data by creating rich interactive reports with Power BI Desktop and then publish your reports to the cloud using PowerBI.com. In PowerBI.com you can design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI Mobile apps.

By attending our 2-day Microsoft Power BI Fundamentals course, you’ll get a comprehensive overview of all the features and functions of Power BI that allow you to stay up to date with the information that matters to you.

Public Courses

  • 27th Jan 2020 - 2 Days - At CitizenM, Lavington Street, London - £ 895.00 (Excl VAT) Per Person

    Book Now
  • 17th Mar 2020 - 2 Days - At CitizenM, Lavington Street, London - £ 895.00 (Excl VAT) Per Person

    Book Now

On-Site Courses

Outline of our Microsoft Power BI Fundamentals Course - DURATION: 2 - DAYS

What is Microsoft Power BI?

  • Understanding the components of Power BI: - Power Query, Data Modelling, Visualisations and Service.

Visualisations using Power BI Desktop

  • Exploring Power BI Desktop.
  • Connecting to a certified Dataset.
  • Creating a variety of visualisations.
  • Using the Formatting and Analytics options.
  • Looking at the Slicer visual to filter data.
  • Controlling interactions between visualisations.
  • Creating and using Hierarchies and Drilldown.
  • Using the Filters Pane.
  • Understanding Implicit Measures.
  • Controlling summarisation.
  • Use “ask a question” to generate visualisations.
  • Mapping geographic data.
  • Working with Custom visuals.

Publishing to Power BI Service

  • Publishing your Reports to PowerBI.com.
  • Creating and Customising Dashboards.
  • Sharing Reports and Dashboards with others.
  • Using Q & A for interactive data searching.

Connecting Services to Power BI

  • Connecting to a variety of cloud-based data sources including OneDrive, Google Analytics, Salesforce etc.

Creating a Data Model in Power BI

  • Importing a variety of data sources into Power BI.
  • Using Model View.
  • Creating and managing relationships.
  • Understanding the Star Schema.

Creating Measures using DAX

  • Understanding what Measures are.
  • Introduction to Filter Context.
  • Working with a variety of simple DAX functions: - SUM, AVERAGE and COUNTROWS

Using Power Query in Power BI Desktop

  • Understanding the role of Power Query in data import.
  • Cleaning and filtering data.
  • Exploring a variety of data transformations.

Power BI Licencing

  • Understanding the different Power BI licences.
  • Differences between Pro and Premium licences.

App Workspaces

  • Using Workspaces.
  • Using organisation Apps.
  • When to use Workspaces and Apps.

Data Refresh

  • Types of data refresh.
  • Manually refreshing data.
  • Requirement for a Gateway.
  • Scheduling automated refresh.

Using Power BI on Mobile Devices

  • Using Power BI on Smartphones and Tablets.
  • Features and functions of the mobile client.

Speak to a trainer now

0800 0199 746 for any questions about the courses we offer