Power BI 1 Week Intensive Training Course for Power Users

£1,695.00£4,975.00

Our Power BI 1 Week Intensive Training Course offers comprehensive coverage of both basic and advanced features of Microsoft Power BI. This course is designed for users who are new to Power BI, but who intend to use the program extensively in their business workflows.

Clear
SKU: PWB-INGT-760 Category:

Description

Looking for a Power BI Intensive Training Course? Our Power BI 1 Week Intensive Training Course offers comprehensive coverage of both basic and advanced features of Microsoft Power BI. This course is designed for users who are new to Power BI, but who intend to use the program extensively in their business workflows. You should consider taking this course when your company has recently adopted, or are about to adopt Power BI; and you will be playing a pivotal role in ensuring that your organization derives the greatest possible benefit from self-service business intelligence.

TIP: You can book this course to get a discounted rate, but stagger the three levels across different dates!

Our Power BI Intensive Training Course for Power Users consists of three courses: Power BI Introduction (2 days), Power BI Intermediate (1 day) and Power BI Advanced (2 days).


Scheduled Instructor-Led Online Courses

We run this scheduled Power BI training course regularly as a public, instructor-led online course. Our online classes are small, with a maximum of eight delegates and each person is given remote access to a computer in our training centre and provided with lots of opportunities to practice all of the techniques being taught.

Scheduled Online Training Courses

Recent Course Feedback

Avantcard Logo

Enjoyed the course. Very well structured and excellent instructor. First online course I have attended and it ran very well and no issues.

Avantcard Data Analyst

Ove Arup and Partners Power BI Training

The course was enjoyable and informative. I have a few takeaways that I am looking forward to implementing.

Ove Arup and Partners Reporting and Business Analytics Functional Analyst Power BI Administration Training - London

Mimecast Logo

A well structured and comprehensive course. My main objectives were to improve my knowledge of DAX and understanding of working with dates and time, which were met fully.

Mimecast Head of Data Science for Threat Intelligence

ABN AMRO Bank Power BI Training

Relaxed pace and touched practical topics which is going to help us a lot on servicing Power BI in a more mature way. Great course, thanks a lot!

ABN AMRO Bank Senior IT Development Engineer Power BI Administration Training - London

Sermo Logo

Very good. The instructor was clear and took time to explain every action in Power BI and why it was being done.

Sermo Senior commercial and Data analyst

Fairtrade Foundation Power BI Training

Great introduction to a very broad range of functionality of Power BI. Good having few students - able to ask as many questions as I liked and have help when I needed.

Fairtrade Senior Impact Data Analyst Power BI Introduction and Intermediate Training - London

WRB Underwriting Logo

The course made me comfortable with the interface on Power BI, and the working examples showed me how it can be used in the working environment to help better present data and make it more dynamic.

W/R/B Underwriting Senior Exposure Management Analyst

Private Individual

The course was really practical and effective! The trainer was very patient to explain how to use the functions and design the table relationships. Also it was customized to student background and needs.

Private Individual Senior Analyst

Cardiff Council

The course was well designed and suited my requirements. There were plentiful exercises that covered key areas of Power BI, plus the tutor was extremely knowledgable and helpful.

Cardiff Council Housing Policy Officer

Course Outline

Power BI Introduction

Getting started

The key components of Power BI; What is Power BI Desktop; The Power BI service; Power BI free vs Power BI Pro; Power BI vs Excel add-ins; Dashboards, reports and datasets

Connecting to software services

Understanding content packs for services; Google Analytics content pack; Salesforce content pack; Microsoft Dynamics CRM content pack

Getting data into Power BI

Connecting to data sources in the Power BI service; Connecting to data sources in Power BI Desktop; Importing excel workbooks; Importing Access databases; Connecting to SQL Server

Cleaning up and transforming data

Using the Query Editor; Creating a query; Understanding query steps; Automatically generated steps; Removing query steps; Modifying query steps; Renaming columns; Reordering and removing columns; Changing data types; The close & apply command

Data modelling

Working in data view; Working in relationship view; Auto-detection of table relationships; Creating table relationships manually; Setting cardinality; Cross filter direction

Using DAX

Creating Calculated columns; Creating measures; Understanding row context; Understanding filter context; The SUMX function; The CALCULATE function; The ALL function; The FILTER function; Using time intelligence functions

Creating reports

Working in report view; Creating tables and key metrics; Working with matrixes; Filtering data with slicers

Creating visualizations

Creating column and bar charts; Creating line and area charts; Creating scatter charts; Treemap visualizations; Using charts as slicers; Using maps with geographical data; Using custom visuals in your reports

Publishing content

Publishing Power BI Desktop reports; Printing and exporting dashboards and reports; Creating Groups in the Power BI service; Creating content Packs; Assigning groups to content packs; Sharing dashboards with your organization; Publishing reports to the web; Embedding a report in a web page

Creating Power BI Mobile Content

Optimising visuals for small viewports; Creating a phone version of a dashboard; Creating phone-optimised reports

Consuming and customizing content

Browsing group content; Using content packs; Creating read-only versions; Using Quick Insights in Power BI; Creating dashboards from your reports; Querying with natural language; Creating custom Q & A suggestions

Refreshing content

Setting up a personal gateway; Customizing dataset refresh settings; Scheduling a refresh frequency; Setting up enterprise gateways; Managing enterprise gateways; Adding and removing data sources, Creating live connections to data


Power BI Intermediate

Parameters and Templates

Benefits of parameters and templates; Creating parameters; Parameter value types; Parameterizing data sources; parameterizing filters; Creating a template; Using a template

Power Query Functions

Converting a query to a function; Understanding function syntax; Invoking a function

DAX Time Intelligence

Calendar tables; Power BI Auto Date/Time feature; The TOTALYTD function; Specifying end of fiscal year;
Calculating running totals; the SAMEPERIODLASTYEAR function; the PARALLELPERIOD function; Using the DATEADD function for maximum flexibility

What If Parameters

Creating a what-if parameter; Specifying limits; Referencing the parameter measure; Incorporating parameter values in your model

Excel Integration

Analyze in Excel; Installing Power BI Publisher for Excel; Creating pivot table reports from Power BI data sources; The importance of data types; Error – The field that you are moving cannot be placed in that PivotTable area; Pinning Excel content to a Power BI dashboard

Custom visuals

Overview of custom visuals; Chiclet Slicer; Timeline; Advanced Time Slicer; Hierarchy Slicer; Synoptic Panel; Waffle Chart; Percentile Chart; Box and Whisker; Histogram; Bullet Chart; KPI Indicator; GlobeMap; Table Heatmap; WordCloud

Business narration

Planning narratives; Self-running narratives; Interactive narratives; Using the Pulse chart visual; Using the Scroller visual; Using Narratives for Power BI; Using video clips in your visuals

PowerPoint integration

Constructing a narrative in PowerPoint, Using export to PowerPoint, Embedding live reports into a PowerPoint presentation


Power BI Advanced

The Power Query Formula Language

Using The Formula Bar; Using The Advanced Editor; Overview Of The M Language; Exploring M using #shared

Understanding Automatically Generated Code

Excel.Workbook; File.Contents; Table.TransformColumns; Table.TransformColumnTypes; Table.UnpivotColumns; Table.UnpivotOtherColumns

Creating custom functions in M

Defining a function; Defining input parameters; The goes-to operator; Defining the function body; Using optional parameters; Calling functions

Iteration Techniques

Benefit of generating lists; Generating lists of numbers; Generating lists of dates; Generating alphanumeric lists; Using the each function; Applying a function to a list of files

Advanced DAX

Using DAX Studio, Writing complex formulas, Using variables, Calculating moving averages, Calculating running totals, Percentile calculations, Creating advanced time intelligence formulas, Using multiple date tables, Working with non-standard calendars

Working with calculated tables

Creating calculated tables, DAX functions that return tables, The CALCULATETABLE function, The ADDCOLUMNS function, The SUMMARIZE function, SUMMARIZE with ROLLUP, VALUES and DISTINCT functions, The CROSSJOIN function, The TOPN function, The ROW function, Using calculated tables within the data model

Using parameter tables

What is a parameter table, When to use parameter tables, Using the HASONEVALUE function, Using the VALUES function, Creating custom slicers, Creating multiple parameter table solutions

Using ArcGIS Maps for Power BI

Overview of ArgGIS maps integration, Selecting a base map, Creating heat maps, Adding demographic layers, Searching for layers on ArgGIS online

Using R Visualizations and Datasets

Overview of R integration, Configuring R Script Options, Using the R Script editor, Creating correlation plots, Creating predictive plots, Interacting with Power BI visuals

Advanced dashboard tiles

Adding custom links to a dashboard, Using th web content widget, Using the video widget, Real-time streaming dashboard tiles

Contact Us

    Subject (required)

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Please Describe your Requirement

    Upload Example Document(s) (Zip multiple files)

    Private Instructor-Led Online Training

    If you have several staff members that need to complete this training, we can arrange a private instructor-led online training course tailored to the requirements of your organisation. Each person is given remote access to a computer in our training centre and provided with lots of opportunities to practice all of the techniques being taught remotely. This means that your staff can attend a course either in the office or from home.

    Private Online Training Courses

    Training Location for Scheduled Courses

    All of our scheduled public courses are now run online. When we resume the running of our in-person scheduled training courses, they will take place at the following address:
    Tower Bridge Business Centre
    46-48 East Smithfield
    London E1W 1AW
    Tel: 0800 998 9248

    Additional information

    Date

    7-11 Dec 2020 (Tutor-Led Online), 11-15 Jan 2021(Tutor-led, Online), 8-12 Feb 2021(Tutor-led, Online), 15-19 Mar 2021(Tutor-led, Online), 26-30 Apr 2021(Tutor-led, Online), 10-14 May 2021(Tutor-led, Online), 21-25 Jun 2021(Tutor-led, Online), 26-30 Jul 2021(Tutor-led, Online), 23-27 Aug 2021(Tutor-led, Online), 13-17 Sep 2021(Tutor-led, Online), 11-15 Oct 2021(Tutor-led, Online), 8-12 Nov 2021(Tutor-led, Online), 6-10 Dec 2021(Tutor-led, Online), Private Tutor-Led Online Training