*NEW* Microsoft Power BI Introduction for Office 365

Request info

Microsoft Power BI Office 365 Training

Training Aims:

Training in this course covers the essential skills in Power BI, Extracting, Transforming and Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts and Dashboards.  These can then be shared with colleagues or others with the Power BI service, and in many other ways.

Course Requirements:-

Attendees should previously have knowledge of Excel with some familiarity with Excel Pivot Tables and Excel Functions like SUMIFS and VLOOKUP.  People with Database, Programming, or other BI experience will be qualified for the course even if they don’t have direct Excel experience.

Course Contents

What is Microsoft Power BI

Understanding the Power BI environment

Installing Power BI Desktop


Understanding Data Sources in Power BI Desktop

Importing a variety of data sources into Power BI Desktop

Connecting to Excel Workbooks, Access Databases, CSV Files and other data locations.


Exploring Power BI Desktop

Working with the Fields and Visualisation Panes

Using Report View to create visualisations

Using Data View to sort and Format data


Creating a Data Model in Power BI desktop

Understanding the Data Model

Using Relationship View

Creating Many-to-One relationships

Refreshing Data


Visualisations Workshop using Power BI Desktop

Adding visualisation to the Report Canvas

Understanding and controlling interactions between Visualisations

Using Drill Down and Drill Through on visualisations

Creating and using Hierarchies


Introduction to DAX in Power BI Desktop

Exploring the importance of custom calculation within the Data Model

Creating Calculated Columns & Measures

Understanding Evaluation Context

Using CountRows and DistinctCount Functions


Using Queries in Power BI Desktop

Understanding the role of Queries in data import

Understanding Extract, Transform & Load (ETL)

Data transformations

Applied Steps

Creating and using Query Parameters

Publishing to Power BI Service

Publish your Report to PowerBI.com

Creating Dashboards


Using Power Pivot Data Model in Power BI Service

Creating visualisations in Power BI Service using Power Pivot data


Sharing your Dashboards & Content Packs

How to share your interactive Power BI Dashboards with people both inside and outside your organisation

Sharing using Power BI, Web, PowerPoint and others


Duration: 1 Day

Cost: £235 + VAT


Office 365 Training,Inverness, Aberdeen, Glasgow, Edinburgh, Scotland and onsite UK Training available.

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2021-01-16' ) ) AND wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (11302) AND wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC

Scheduled Courses:

    DateCourse NameLocationPrice (Excluding VAT)Book
    22 MarMicrosoft Power BI Introduction for Office 365Online - Remote£235Enquire Now
    24 JunMicrosoft Power BI Introduction for Office 365Online - Remote£235Enquire Now
    20 SepMicrosoft Power BI Introduction for Office 365Online - Remote£235Enquire Now
    14 DecMicrosoft Power BI Introduction for Office 365Online - Remote£235Enquire Now