Microsoft Power BI Training

Upgrade your Power BI skills with hands-on Microsoft Power BI training.

Official Microsoft Power BI Training

Influential Software provides the full Power BI curriculum, including skills for Power Pivot, Power Query, Power View, DAX, and more. Our Microsoft Power BI training is led by certified experts with years of practical experience. As a leading IT training provider in the UK and Europe, we have a student satisfaction rating of 94% for BI courses.

microsoft-power-bi-training-classroom-lesson

Analysing Data with Power BI Course

Overview

This three-day instructor-led course provides students with the knowledge and skills to analyse data with Power BI.

Audience

  • BI professionals who need to analyse data with Power BI
  • Technically proficient business users

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some exposure to basic programming concepts (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Familiarity with Microsoft Office applications – particularly Excel

Module 1: Introduction to Self-Service BI Solutions

  • Introduction to Business Intelligence
  • Introduction to Data Analysis
  • Introduction to Data Visualisation
  • Overview of Self-Service BI
  • Considerations for Self-Service BI
  • Microsoft Tools for Self-Service BI
  • Lab : Exploring an Enterprise BI Solution
  • Viewing Reports
  • Creating a Power BI Report
  • Creating a Power BI Dashboard

Module 2: Introducing Power BI

  • The Power BI Service Lab : Creating a Power BI Dashboard
  • Connecting to Power BI Data
  • Create a Power BI Dashboard

Module 3: Power BI Data

  • Using Excel as a Data Source for Power BI
  • The Power BI Data Model
  • Using Databases as a Data Source for Power BI
  • The Power BI Service Lab : Importing Data into Power BI
  • Importing Excel files into Power BI
  • Viewing Reports from Excel Files

Module 4: Shaping and Combining Data

  • Power BI Desktop Queries
  • Shaping Data
  • Combining Data Lab : Shaping and Combining Data
  • Shape Power BI Data
  • Combine Power BI Data

Module 5: Modelling Data

  • Relationships
  • DAX Queries
  • Calculations and Measures
  • Lab : Modelling Data
  • Create Relationships
  • Calculations

Module 6: Interactive Data Visualisations

  • Creating Power BI Reports
  • Managing a Power BI Solution
  • Lab : Creating a Power BI Report
  • Connecting to Power BI Data
  • Building Power BI Reports
  • Creating a Power BI Dashboard

Module 7: Direct Connectivity

  • Cloud Data Connecting to Analysis Services
  • Lab : Direct Connectivity
  • Direct Connections to Power BI

Module 8: The Developer API

  • The Developer API
  • Custom Visuals
  • Lab : Using the Developer API
  • Using a Custom Visualisation

Module 9: Power BI Mobile

  • Power BI Mobile Apps
  • Using the Power BI Mobile App
  • Power BI Embedded

Preparing Your Data for Power BI Course

Overview

This two-day course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX and to compare working in SQL Tabular mode to Excel PowerPivot.

Audience

  • Business analysts
  • Business intelligence developers
  • SQL professionals

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • A working knowledge of SQL Server

Module 1: Course Overview

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We’ll Be Discussing

Module 2: What is the Tabular Model?

  • Analysis Services Installation and Architecture: One Product, Two Models
  • Version Changes: SQL Server Analysis Services
  • Important Terms
  • SQL Server Data Tools for Tabular
  • Lab : What is the Tabular Model?
  • SQL Server Data Tools for Tabular

PowerBI-Influential.com

Power BI Official Logo | Microsoft Partner Influential | Power BI licences, consultancy and services

Power BI Consultancy – Let’s Get Started

    Your Name:

    Your Contact Details:

    *Required