Use the filters below to find out what’s coming up near you
Click into each event to view additional dates
Duration: 4 Days
Microsoft Course: 55215
This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites, whether you’re using SharePoint Online through Office 365, or SharePoint 2019 on-premises. Your goal is to learn how to make SharePoint relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class you will also learn best practices and ‘what not to do’ as you watch live, interactive demonstrations and put theory into practice with hands on exercises.
* Module 1: Introduction to SharePoint
* Module 2: Finding Content
* Module 3: Working with Lists
* Module 4: Working with Libraries
* Module 5: Working with Publishing Features
* Module 6: Leveraging Social Content in the Business
* Module 7: Site Owner Responsibilities
* Module 8: Creating and Managing Sites
* Module 9: Permissions and Security
* Module 10: Adding and Configuring Apps (Pt. 1)
* Module 10: Adding & Configuring Apps (Pt. 2)
* Module 11: Adding & Managing Workflows
* Module 12: Creating & Managing Content Types
* Module 13: Document Lifecycle Management
* Module 14: Site Customisation
Duration: 2 Days
Audience: End Users, Business Analysts, Administrators, IT Pros
Please note, this course will be delivered remotely by a live instructor. Our online courses aim to mimic the in-person training experience, delivered directly to your home or office.
‘Getting Started with Power BI’ is a 2-day training course designed for students who are just getting started with Power BI and who need to get up to speed on building and deploying custom solutions using the Power BI Service and Power BI Desktop. Students will work through hands-on lab exercises to gain and reinforce skills for using a project-based approach for building custom BI solutions using Power BI Desktop.
Students will learn what can be accomplished with the Power BI service using just a browser as well as which types of project work must be completed using Power BI Desktop. Students will learn how to use the query features in Power BI Desktop to import and transform data as it loads into a project’s data model. The course also teaches students how to use the data modelling features of Power BI Desktop and to become proficient writing DAX expression to create calculated columns and measures. Students will learn how to design interactive reports as well as how to publish reports to the Power BI service and to SharePoint Online.
Along the way, students will learn how to import data from a variety of sources including Azure SQL databases, One Drive for Business, SharePoint Online and Dynamics 365. The course also teaches students the various techniques that can be used to integrate Excel workbooks into the Power BI environment.
Anyone attending this course require no previous knowledge of Power BI, however an intermediate knowledge of Excel and experience in working with databases and other data sources would be advantageous.
Module 1: Introducing the Power BI Platform
Module 2: Getting Started with Power BI Desktop
Module 3: Mastering the Query Features of Power BI Desktop
Module 4: Designing a Data Model with Power BI Desktop
Module 5: Designing Interactive Reports in Power BI Desktop
Module 6: Designing and Deploying Dashboards
Module 7: Integrating Excel Workbooks into Power BI
Module 8: Publishing Content using Apps and App Workspaces
This module introduces the fundamental concepts and terms associated with the Power BI platform. Students will learn how to create a trial tenant in Office 365 to serve as a multiuser development environment for designing and testing custom Power BI solutions. Students will learn to navigate around in the Power BI service using a browser and to create a simple solution which includes a dataset, a report and a dashboard. The module teaches students about Power BI licensing and the differences between standard Power BI subscriptions and a Power BI Pro subscriptions. The module concludes by discussing how to keep current with the Power BI cloud cadence and the monthly updates that Microsoft consistently applies to the Power BI platform.
This module introduces students to Power BI Desktop and provides a high-level overview of managing the lifecycle of a Power BI Desktop project. Students will learn how the contents of a Power BI Desktop project are saved and published using the PBIX project file format. The module demonstrates how to import data from an external source into a Power BI Desktop project to create a dataset. Students will also learn how to get started with data modelling by creating simple calculated columns and measures. Students will also get hands-on experience using the report designer in Power BI Desktop and publishing a PBIX project file to the Power BI service to make a Power BI Desktop report accessible through the browser.
This module provides an in-depth examination of designing and running queries in a Power BI Desktop project. Students will learn to import data from a variety of external data sources including text files, Excel workbooks, web pages, Azure SQL databases, SharePoint Online and Dynamics 365. The module demonstrates how to design queries to clean up and transform data during the import process and students will learn the why and the how of designing queries in a Power BI Desktop project to generate a star schema. Along the way, students will learn advanced query design techniques to merge columns from multiple data sources and to append rows from multiple sources tables into a single output table.
This module examines the data modelling features in Power BI Desktop project and teaches students how to extend a data model with table relationships, calculated columns, measures and dimensional hierarchies. The module discusses working with the DAX expression language and reviews guidelines for writing maintainable DAX expressions. Students will learn how to import a lookup table from a secondary data source and how to integrate the lookup table into a data model to assist with data categorization. The module also demonstrates how to configure the metadata for geolocation fields within a data model so they can be used to visually map aggregated data values to geographical locations such as countries, states, cities and post codes.
This module demonstrates how to use the report design features of Power BI Desktop to create reports using the standard set of Power BI visuals. Students will learn to design reports with effective interactive behaviour by adding slicers, visual highlighting and drill actions. The module introduces students to the Power BI Custom Visuals Gallery and explains how to import custom visuals into a Power BI Desktop project. The module teaches students how to use Phone Layout view to create mobile reports as well as how to publish Power BI reports to the Power BI service. Students will learn how to use the Publish to SharePoint feature and the Publish to Web feature in Power BI to deploy reports to SharePoint Online sites and to public websites on the Internet with anonymous access.
The module examines the role that dashboards play in Power BI and teaches students about the strengths and weakness of dashboards in comparison to Power BI reports. Students will learn about best practices in dashboard design and how to create an effective drilldown scheme from a dashboard into its underlying reports. Students will also learn about Natural Language Q&A and how to pin Q&A query results to create a dashboard tile. The module teaches students how to use Phone Layout view customize the mobile layout of a dashboard and examines using dashboard sharing as a simple mechanism to make dashboards and reports accessible to other users. The module concludes by examining how to configure a dashboard with data alerts to send notifications when a measure behind a dashboard tile reaches a predefined threshold.
This module discusses the three primary techniques that can be used to integrate Excel workbooks into the Power BI environment. points that exist between the Excel Desktop application, Excel Online and the Power BI platform. First, students will learn how to connect to Excel workbooks from a Power BI workspace. Next, students will learn how to import an Excel workbook into Power BI to create a new Power BI dataset from the data inside the workbook. Finally, the module teaches students how to migrate a data model from inside an Excel workbook into a new Power BI Desktop project. Along the way, students will learn about several other features to assist with Excel to Power BI integration such as the Power BI Publisher Add-in for Excel and the Analyse in Excel feature.
The module examines the best practice of building a custom solution in an app workspace and then using the app model to distribute the custom solution on a wide-scale basis. This module walks through the steps of publishing an app workspace and making it accessible to other users as an installable app. Students will learn the various ways one can install a Power BI app. The module demonstrates how to upgrade reports and dashboards after an app has been installed using staged updates. The module explains the essential concepts involved with Power BI Premium and dedicated capacities and demonstrates how to configure an app workspace to run within a dedicated capacity. Along the way, this module will provide students with the decoder ring necessary to understand the capacity-based licensing model and strategies for distributing content to users with the Power BI free license.
Course Code: MSPOWAP
Duration: 2 Days
Audience: End-users & Developers
This course delivers an instructor-led breakdown of Microsoft PowerApps. Students will be taught how to design, test and publish new applications that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.
This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their applications.
Delegates should have prior experience of using Office 365, including working with Excel data sources and formulas, OneDrive, and SharePoint lists to a reasonably advanced level. We recommend taking a look at the following courses:
Course Code: MSFLOW
Duration: 1 Day
Audience: End-users & Developers
This course delivers an instructor-led product showcase for Microsoft Flow from start to finish in an engaging and practical way. Flow is a diverse product, turning business processes into automated, consistent and visual workflows. Flow is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workflow logic for your business workflows.
The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimising their existing business processes and designing new ones.
Delegates should have prior experience of using Office 365, including working with OneDrive, SharePoint lists & libraries, and content approval processes to a reasonably advanced level. We recommend taking a look at the following courses: