catraining

 

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.

Prerequisites

• 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 Deskto

    Power BI Concepts and Overview

    Introduction to Main Features

    Imports

    Visualizations

    Filters and Queries

    Reports

    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

    Charts

    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

    Clustering

    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

    Filters

    Transforms

    Pivot and Group By

    Creating Custom Calculated Columns

    Adding Conditional Columns

    Introduction to DAX Expressions

    Histograms

    Module 5:

    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

    microsoft power bi training london

 


    Excel
    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