Microsoft Partner

power bi courses london


Excel Power Bi Desktop Training Excel Training Company


Learn how to Create stunning reports and visualizations with Power BI Desktop Training

Power BI Desktop puts visual analytics at your fingertips with intuitive report authoring. Drag-and-drop to place content exactly where you want it on the flexible and fluid canvas. Quickly discover patterns as you explore a single unified view of linked, interactive visualizations


Audience: Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analyzed and published from a variety of sources. With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published. This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.

Please Note: This course does not cover Microsoft’s Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.


• Please note that this course is not suitable for new Excel or database users

• An understanding of basic data concepts

• Ability to create, format chart outputs • Be able to create formulas using standard aggregate functions

Public Courses for PowerBi £240.00/Day +Vat

Course Duration: 2 day

Course Types: Group bookings, public courses , 1-2-1 sessions, bespoke tailored courses.

Course Location: This Microsoft Excel 2016 PowerBI training course is delivered at our training centre in London situated close to Liverpool street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

reaining course


After completing this course, students will be able to:
    • Delegates will learn
    • • Power BI Desktop Concepts and Main Features
    • • Data Sources compatible with Power BI Desktop
    • • Connecting to Data with Power BI Desktop
    • • Explore Data Visualizations
    • • Apply Common Query Tasks to Shape Data in Power BI Desktop
    • • Create and publish Reports

  • Course Outline
    print this page
    Module 1: Getting Started with Power BI Desktop

    Power BI Concepts and Overview

    Introduction to Main Features



    Filters and Queries


    Module 2: Connecting to Data Sources with Power BI Desktop

    Data Sources Power BI Desktop will connect to

    Data Types and Properties in Power BI Desktop

    Import and Enter Data

    Get Data and Query Editor

    Introducing the Query Editor

    Using the Query Editor to Connect to Data

    Combining Data Sources as a Mash Up

    Working with Relationships in Data

    Module 3: Data Visualizations

    Overview of Data Visualizations

    Tables and Matrix Views

    Applying Conditional Formats


    Interactive Data and Date Slicers

    Drill Visualizations to see underlying data

    Create Reusable Field Hierarchies

    Record Grouping and Binning in Visualizations

    Drill Visualizations with using Dates


    Analytics and Forecast Lines in Visualizations

    Creating Role Based Views

    Data Categories, Geo-Data and Maps

    Module 4: Querying and Shaping the Data

    Common Activities using Query Editor



    Pivot and Group By

    Creating Custom Calculated Columns

    Adding Conditional Columns

    Introduction to DAX Expressions


    Module 5: Reports and Dashboards

    Reports and Output Options microsoft power bi training london

    Report Elements and Options

    Working with Pages

    Adding Graphics

    Visual and Filter Settings

    Export Power BI Data to CSV

    Create a Power BI Template

    power bi courses london and UK


    microsoft power bi training london


    Excel Training London
    Excel PowerBI London
    Excel Training courses
    Excel data visulization Training courses
    Excel Power Bi Desktop Training Excel Training Company



    excel training london

we can deliver power bi desktop training for microsoft at our training offices or at your site.

Excel data visulization Training courses

Excel Power Bi Desktop Training Excel Training Company

Call us now for further information Tel:08001601666