Microsoft Power BI (Business Intelligence) Workshop

  • Select Location
  • Online Live Classroom
Select a location then date
  • Select Date
Price (ex vat): £799.00

    PrintDURATION: 3 days
    TIME: 09:00 to 16:00 GMT

    Microsoft Power BI Desktop tools are perfect to manage company data. PowerBI is even better than MS Excel for many reasons. If you regularly analyse and report company data you should consider joining this course. The course is aimed at users and PowerBI is a free app to download from the Microsoft site. You really must consider PowerBI as an important tool to manage and report your data.

    About Microsoft Power BI (Business Intelligence) Workshop

    Microsoft Power BI Workshop

    In order to make sense out of the huge amount of data available in your business, which needs more reporting power and analysis than that offered by Microsoft Excel, Power BI is a cutting edge business intelligence tool. In today’s business, data is a lifeline and with the right tools, we’re generating more of it than ever. Power BI will help you manage data from a number of cloud-based & on-premises applications and services. You will manage, correlate, and analyze data from a variety of sources through a user-friendly dashboard.

    Is this course for you?

    You’re using Microsoft Excel to manage your company data and present reports but now find it has limitations. Microsoft Power BI will provide a perfect tool for you to link to company data “where ever that may be”, or link to multiple data sources. You can then create steps to clean, filter, delete, manipulate, append data in order to prepare it for the next step. Formulas can be introduced to support data analysis. Slicers can be used to create an interactive analysis of your visualisations. Dashboard reports displaying a range of performance visualisations can be created and published for general or specific members of your organisation to view. Gone are the days of creating weekly or monthly reports for management.

    Pre-requisites

    You should have a good depth of knowledge of Internet Explorer 10.0 or later and be familiar with general reporting concepts.

    You will need to install Power BI Desktop Application on your computer before the start of the course. https://www.microsoft.com/en-gb/download/details.aspx?id=58494

    You require access to Power BI in the cloud for deployment, preferably with an account and license: https://powerbi.microsoft.com/en-us/

    Live Virtual Classroom schedule

    Session 1: 09:00 to 10:00 [break 10:00 to 10:15]
    Session 2: 10:15 to 11:15 [break 11:15 to 11:30]
    Session 3: 11:30 to 12:30 [lunch 12:30 to 13:30]
    Session 4: 13:30 to 14:30 [break 14:30 to 14:45]
    Session 5: 14:45 to 15:45 [summarise and close 15:45 to 16:00]

    Courses Includes

    Online training
    Post course support

    Connect to Teams for this course

    We use Microsoft Teams for our Live Online Microsoft courses. Find out more.

    Groups Discounts

    Contact us for Live Online group discounts.

    Aim & Objectives

    Course Aims

    • To link, clean, analyse. report and publish company data from a variety of sources

    Course Objectives

    By the end of the course you will be able to:

    • Link key data sources to Power BI
    • Transform datasets
    • Aggregate, Append, Change data and Relationships
    • Add measures to data
    • Add time based data
    • Add charts and custom visuals
    • Use filters and slicers for a custom view
    • Enhance dashboards
    • Publish and Share dashboards

    Course Content

    Microsoft PowerBI 365 App


    • PowerBI Desktop
    • Loading Data
    • Navigator Window
    • Data Preview

    Data Sources

    • Web Pages
    • File based data
    • SQL Databases
    • OLAP Databases
    • Reusing Data Sources
    • Refreshing Data Sources

    Transforming Datasets

    • Working with columns
    • Working with rows
    • Filtering Data
    • Cleansing Data

    Extending Data Sets and Models

    • Aggregating Data
    • Appending Data
    • Changing Data Structure
    • Relationships
    • Column Sorts
    • Currency Formats
    • Concatenating Data
    • Calculated Columns
    • Using Functions

    Adding Measures

    • Basic Aggregation
    • Multiple Measures
    • Filter Measures
    • Calculating Percentages

    Time based Data

    • Simple Date Calculations
    • Time Intelligence
    • Create a Date Table
    • Previous Period
    • Parallel Period

    Text based Visualisations

    • Tables
    • Matrix

    Chart based Visualisations

    • Basic Charts
    • Donut Charts
    • Funnel Charts
    • Waterfall Charts
    • Enhancing Charts
    • Drill Down

    Enhanced Visualizations

    • Maps
    • Tree Maps
    • Gauges
    • Custom Visuals

    Data Filtering

    • Visual Filters
    • Data Type Filters
    • Text Filters

    Slicers

    • Adding Slicers
    • Formatting Slicers
    • Charts as Slicers
    • Charts as Filters

    Enhancing Dashboards

    • Annotating Reports
    • Adding Shapes
    • Organizing Visuals
    • Exporting Data

    Publishing Reports

    • Publishing to PowerBI.com
    • Printing Reports
    • Sharing Dashboards

    Video Testimonials

    Client Testimonials

    • Name: 386 + reviewsCompany: Via Reviews.co.uk

      View all testimonials