*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) >= '2018-12-11' ) ) 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:

    2019
    DateCourse NameLocationPrice (Excluding VAT)Book
    22 Feb*NEW* Microsoft Power BI Introduction for Office 365Inverness£235Enquire Now
    29 Mar*NEW* Microsoft Power BI Introduction for Office 365Inverness£235Enquire Now
    16 Aug*NEW* Microsoft Power BI Introduction for Office 365Inverness£235Enquire Now
    27 Sep*NEW* Microsoft Power BI Introduction for Office 365Inverness£235Enquire Now
    27 Sep*NEW* Microsoft Power BI Introduction for Office 365Inverness£235Enquire Now
    22 Nov*NEW* Microsoft Power BI Introduction for Office 365Inverness£235Enquire Now
    22 Nov*NEW* Microsoft Power BI Introduction for Office 365Inverness£235Enquire Now
    7
    2018: