Power BI Training 2017-09-19T23:13:17+00:00

POWER BI TRAINING

Is your organisation deploying or already using Microsoft Power BI?
Do need help with the transition from complex reporting in Excel, to using Power BI for simply yet compelling interactive storytelling?
Do your analysts have the skills needed to produce the BI reports your company needs?

WE OFFER A VARIETY OF POWER BI TRAINING OPTIONS TO SUIT SPECIFIC LEARNING GOALS AND PREFERENCES

Our hands-on on-site training courses will help you master the Power BI skills your organisations needs. Drawing on their years of experience in the design and development of robust BI Solutions, our Power BI trainers and consultants will help you achieve your BI learning goals. Learn Tips & Tricks of the trade to build onto a best practice foundation.

WHY CHOOSE DATA BEAR FOR POWER BI TRAINING? 

We’re a Power BI centric company, and a Microsoft Power BI Partner, with a vertical focus on empowering organisations with Power BI solutions that produce results. Having helped numerous organisations overcome the obstacles to enhanced data efficiency and empowering them with the skills to adopt a ‘data culture’, the Data Bear team has many years of ‘real life’ experience in the ‘BI – trenches’.

We don’t just show you what all the various buttons and knobs do. You can learn that from the Power BI documentation. Drawing on a wealth of experience, based on developing and deploying numerous best practice BI solutions globally, we teach you how to build a robust Power BI solution from the ground up, ensuring that, going forward, your team has the best practice foundation to continue the process of getting the right data into the right hands.

The Data Bear team is dedicated to helping business become more profitable through the provision of timely and accurate insights. Providing solutions that save time, increase profits and reduce stress our driving force.


Johann is brilliant. The Data Bear solutions are just fantastic. The quantifiable improvement to any business using their Power BI Dashboards are worth 100 times more than the investment. Great stuff.
Purple Thread Marketing
Purple Thread Marketing
23:14 23 Mar 17
We have been working with Johann and Dmitri for almost a year now. From concept to design and implementation, they have been nothing but professional and timely. They leveraged Azure and Power BI to sort and report our point of sales data. We have no reservation when it comes to recommending Data Bear and look forward to our continued partnership.
James Mack
James Mack
22:48 18 May 17
The DataBear team has been great to work with! They take the time to understand the problem and then put together a real-time solution. It's also great when they responds so quickly! We will continue to work with them!
Laura Sailor
Laura Sailor
01:13 05 Apr 17
Fantastic experience. Very customer oriented - in helping us think through our needs, suggesting solutions and then delivering on a great solution. Great guys to work with!
Guru Sankar
Guru Sankar
07:11 08 Apr 17
Extremely professional and easy to work with. Highly knowledgeable on all aspects of Microsoft Power BI issues and solutions. Would strongly recommend.
Ellen Howard
Ellen Howard
22:27 04 Apr 17

Power BI Training London: 

Build an End-to-End Solution in Power BI

In this popular 2 day workshop, our Power BI Training course follows a hands-on end to end process of importing ‘dirty’ data into Power BI Desktop and transforming it into a stunning interactive dashboard shared in the cloud. All exercises, have a relevant context, covering ‘real-life’ scenarios that require building advanced KPIs to answers specific business questions. Learn the Power BI tricks of the trade from a team who has many complex Power BI solutions under their belts.

Here is an example of the Power BI solution you will learn how to build from scratch during this 2-day Power BI Training course:

Example Power BI Solution

Power BI Training Course Outline

Day 1

Overview of Power BI

  • The value offering
  • Pricing
  • Positioning

Power BI Cloud Service (the wow features)

  • Overview of the Cloud Service
  • Importing a Report into the Cloud Service
  • Building a Dashboard
  • Dashboard Flow and Navigation
  • Power BI for Mobile
  • Q&A (Natural Language Queries)
  • Quick Insights
  • Content Packs
  • Demo Samples
  • Publish to web (embedded)
  • Export to PowerPoint

_

Power BI Desktop

  • Overview of Power BI Desktop
  • Similarities to Excel Power Pivot
  • Similarities to Excel Power Query

Importing and Transforming Data

  • Importing Data from various sources
  • Direct Query
  • Query Editor Overview
  • Query Building Best Practice
  • Applied Steps
  • Fail Safes
  • Data Transformations
    – Cleaning data (covers many different methods)
    – Merging datasets
    – Unpivoting Data
  • Combining Files from a folder
  • Dynamic Fiscal Calendar Table
    – Creating Parameters

Day 2

Data Modelling

  • Creating Relationships
  • Default Summarization
  • Sort by
  • Parameter Tables
  • Data Types & Formatting

Report Building

  • Requirements Analysis templates
  • Formulate Questions the Reports Should Answer
  • Report Layout Guide lines
  • Build a Time Intelligence Report
  • Calculated Measures & Calculated Columns
  • Commonly Used DAX functions
    – SUM, SUMX, AVERAGE, MIN, MAX, DIVIDE
    – COUNT, COUTA, COUNTROWS, COUNTBLANK
    – CALCULATE, FILTER, ALL, ALLEXCEPT
    – HASONEVALUE, DISTINCT
    – EOMONTH, MONTH, YEAR, NOW(), LASTDATE
    – SWITCH, TRUE, VALUES,
    – ISERROR, ISBLANK, BLANK()
    – AND, IF, OR, ABS, RAND, RANDBETWEEN
    – RELATED, USERRELATIONSHIP
    – Time Intelligence (MTD, QTD, YTD, Prior Year)
    – % Variances
  • Optimizing Measure for Self-Service BI
  • Using Quick Measures
  • Base Measures & Metrics
  • Build a Monthly Trend Report
  • Dynamic Headings & Dates
  • Types of Slicers
  • KPI cards
  • The Field, Format, Analytics Pane
  • Tabular Reporting with a Matrix

 

Report Functionality     

  • Drill-Downs
  • Drill-Through
  • Slice by Measure
  • Slice by Relative Dates
  • Setting Interactivity
  • Focus Mode – See Details
  • Forecasting
  • What-if Analysis
  • Exporting Data from Power BI Desktop
  • Integrating R
  • Scatter charts
  • Ribbon Charts

Optimizing the Design

  • Sorting Visuals
  • Chart Types
  • Tool Tips
  • Conditional Formatting
  • Page Size
  • Logo & Icons
  • Shapes and Borders
  • Native & Custom Visuals
  • Max, Average or Min lines
  • Formatting Tips & Tricks
  • Creating Reusable Project Template Files
  • DAX formatter
  • Dax Studio

Governance & Distribution

  • Row Level Security – Creating and Testing Roles
  • Publish to the cloud Service
  • Security – Add Users to Defined Roles
  • Sharing Dashboards & Reports
  • Creating Organisational Content Packs
  • Usage metrics for dashboards and reports

Outside of London? This Power BI Training course is also available throughout the UK on request.

_


Power BI Dashboards shown on many screens

BI Training UK:

Dashboard in a Day (DIAD)

Be wowed by Power BI. Without the need of any prior data analysis or reporting building training, this introductory course explores the art of the possible with Power BI. If you’re new to Power BI and require an overview of the basics through guided hands-on learning, and a solid foundation on report building best practices, then this 1 day BI training course is for you.

Power BI – The wow features

  • Overview of the Cloud Service
  • Importing a Report into the Cloud Service
  • Building a Dashboard
  • Dashboard Flow and Navigation
  • Power BI for Mobile
  • Q&A (Natural Language Queries)
  • Quick Insights
  • Sharing Dashboards
  • Organisational Content Packs
  • Content Packs
  • Demo Samples
  • Publish to web (embedded)
  • Export to PowerPoint
  • Overview of Power BI Desktop
  • Data modelling and Report Building Best Practices

Outside the UK? This Power BI Training course is also available throughout the US and South Africa on request.

_


Example of Data Bear Power BI solutions on mobile devices

Power BI Training:

BYO DATA

This Power BI Training course has received the most positive feedback. Why? – Because using your own data to learn how to build insightful reports not only adds value to your organisation, the training has a relevant context that is familiar to your everyday experience. In this Hands-On One Day Training session, we follow the same end-to-end training agenda outlined in our 2 day session detailed above. The difference being, we use your own data to build reports that add value to your organisational goals.

Note: This training requires an on-site scoping session beforehand. Not only do we to understanding you your data, we also need to understanding the type of reports you would like to produce from your data.

Based on the outcomes of the scoping day, we will tailor specific custom learning content and the training will focus on the skills needed to transform your data into a compelling data story that answers specific business questions.

Please refer to the our 2 day BI training agenda above for specific details on the content covered.

Outside of London? This training course is also available throughout the UK, US and South Africa on request.

_


Image for BYO data training

Remote and on-site Training:
Supercharge Your Analyst

Do you data analysts have the required skills to build robust automated business intelligence solutions? This popular deep dive Power BI Training course focuses on empowering your company’s analysts with the modern analytics skills required to develop and maintain the various BI solutions your companies needs. Using an agile approach, we meet your analysts where they at and work alongside them on mastering the various scenarios towards compelling data storytelling. This training course rapidly increases the Cycle Time to Information (CTI) and the Cycle Time to Action (CTA).  These metrics are useful to track the efficiency of a Business Analytics infrastructure and the elimination of manual processes to increase productivity.

During the training course, based on your Business Intelligence needs, your analyst will develop a robust BI solution that will serve as part of the shift towards building a data culture within your organisation. Our Power BI experienced Power BI Consulting team will work closely alongside you analysts ensuring that best practices are learnt and understood.

Outside of London? This Power BI Training course is also available throughout the UK, the US and South Africa on request.

_


Onsite Training London:
2 Days Hands-On Training Workshop

BOOK A MEETING WITH US TODAY

Discuss your specific training needs, and let’s help you empower your business

Your Name (required)

Your Email (required)

Company Name (required)

Country (required)

Telephone Number (required)

Subject

Your Message (required)

Please leave this field empty.