What will I learn?

Full Course Details

The aim of this course is to provide delegates with the ability to create and manage Power BI data sources, reports and dashboards. Delegates will gain an understanding of the components and functionality of Power BI and the role of both Power BI Desktop and the Power BI Service. As most of the work involved in creating reports is carried out in the Desktop, the main part of the course will focus on Power BI Desktop.

On completion of this course delegates will be able to understand the key stages of working with Power BI including Data Sources, Transforming Datasets, Adding Measures, Visualisations, and Publishing Reports.

To attend this beginners session, little or no experience of Power BI is required. However, a general understanding of Business Intelligence reporting, relational databases and Excel, in particular formulas and Pivot Tables, would be helpful.

 

Book Microsoft Power BI Foundation Training

For companies who need to train groups of staff either remotely or in-person.

  • Two day course
  • Up to 10 delegates
  • Flexible in-house training dates
  • Face-to-face training
  • In-house or a venue of choice
  • Virtual training option
Enquire & Book
MEET THE TRAINER

Paul Watson

Paul brings a wealth of understanding and knowledge, specialising in technical training and development in Excel, Power BI and Access.

His knowledge with IT systems has been gained both academically and through more than 20 years practical experience in the industry. His strengths are demonstrated as both an IT trainer and as a developer.

Read More

Full Microsoft Power BI Foundation Training Course Content

DAY 1

Introduction to Power BI

  • Power BI Desktop
  • Power BI Service

Data Sources

  • Connecting to Data Sources
  • Navigator Window

Transforming Data

  • Power Query Editor
  • Clean and Transform Data
  • Loading Data

Data Model

  • Multiple Tables
  • Relationships

Introduction to DAX

  • Calculated Columns
  • Measures
  • Basic Aggregation
  • Filter Measures

Introduction to Visuals

  • Tables
  • Matrix
  • Charts
  • Formatting Visuals
  • Interactive Filtering

Slicers

  • Adding Slicers
  • Formatting Slicers

DAY 2

Data Filtering

  • Visual, Page and All Pages
  • Text, Date and Number Filters

Working with Dates

  • Date Tables
  • Sorting Dates
  • Calendar Functions

Enhanced Visualisations

  • Adding Shapes and Text
  • Maps
  • Tree Maps
  • Custom Visuals
  • Small Multiples
  • Drill Down
  • Conditional Formatting
  • Edit Interactions

Enhancing Reports

  • Drill Through
  • Bookmarks
  • Navigation Bars

Publishing Reports

  • Workspaces
  • Publish to a Workspace
  • Refreshing Data
  • Dashboards
  • Subscriptions and Alerts
  • Creating and Distributing Workspace Apps
  • Create Reports from Published Data Sets
Enquire & Book
Excel Training Business benefits

Power BI For Beginners – Business Benefits

By investing in people, you can give your team all the necessary skills they need to help support your organisation’s goals.

Excel Training Business benefits

Power BI Training - People Development

Completing our Power BI training course will give you additional skills you need to help support your career development.

Excel Training Business benefits

Flexible Power BI Training Courses

  • Online or face-to-face in-house training
  • Individual delegates or group training
  • Flexible dates to fit schedules
BOOK YOUR POWER BI TRAINING

Why choose TrainingU?

Excel Training Business benefits

Passionate

Established in 2008 by a team of knowledgeable training experts, we are passionate about delivering excellent training that makes a real difference.

Excel Training Business benefits

Experienced

All our trainers are qualified and experienced Power BI trainers that will deliver the highest level of training to you and your team.

Excel Training Business benefits

Collaborative

Working together with our clients, understanding their needs and desired learning outcomes, to deliver a personalised learning solution.

Our Clients

International SOS Pioneer DJ

What Our Clients Say...

"We have used TrainingU on a number of occasions for various different types of training both in house and offsite.  All staff who attended have been extremely impressed with both the trainers and content.  Everyone at TrainingU have been very helpful, professional and always willing to assist in any way they can.  The trainers make learning fun and easy from the Intermediate to the Expert. I would have no hesitation in recommending TrainingU to anyone and we will continue to use them for our future training requirements"

Call Systems Technology

"The IT courses run by TrainingU have been extremely well received by all that have attended them. The company has been supportive, flexible and attentive, going the extra mile to ensure that the courses are a success. All trainers and staff have been professional and pleasant, helping the whole process run smoothly. We are very happy with the training we have received and would not hesitate to recommend them to others."

Red Bull Technology

"The training that we book is always excellent, and the feedback forms reflect this every time. Training U is very professional in all aspects of training and so is the administration that goes with each training course.  All the team are very approachable, and they always go out of their way to help you, nothing is too much trouble for them all. I would have no hesitation in recommending Training U."

The Whitbread Academy

Enquire About Our Power BI Training For Beginners

Simply fill out the contact form or call 0333 344 6630 to make an enquiry, book your Power BI training or assess your staff Power BI training levels.