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:30 GMT

    Microsoft Power BI Desktop tools are designed to be accessible to business end users, tools that let you create visualisations that can be manipulated, published, and shared with others. Get the best from Power BI and make a positive impact for you, your team, and your business.

    About Microsoft Power BI (Business Intelligence) Workshop

    Microsoft Power BI Workshop

    In order to make sense out of the abundant data available in our 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 modern business, data is a lifeline and with modern tools, we are 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 want create detailed connected visualisations of company data from different sources in order to analyse and report via a dashboard.

    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 create, manage and edit Microsoft Power BI Dashboards

    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