What will I learn?

Full Course Details

Learn the key components and techniques involved in producing and sharing a Power BI report. This session is ideal for people with little or now experience of using Power BI.  You’ll also learn about the role of both Power BI Desktop and the Power BI Service.

As most of the work involved in creating reports is done in the Desktop, the main part of the course will focus on Power BI Desktop.

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

The course provides a solid foundation for further learning which can be provided in the form of short Sprint sessions focusing on specific areas introduced on this course.

Book Power BI Training

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

  • One 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
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 Course Content

What is Power BI?

  • Introduction to the concepts of Business Intelligence and reporting
  • Different roles of Power BI Desktop and Power BI Service
  • Introduction to and constraints of licensing – what’s free and what’s not

Introduction to Power BI Desktop

  • Exploring the Power BI Desktop screen and working environment

Key steps: From Getting Data to Creating and Publishing Reports

  • Import Data: Import data from a range of sources. Introduction to the Query Editor to clean and transform imported data. Refresh options.
  • Setting up the data model: What the Data Model is and why it’s so important.
  • Diagram view and setting up table relationships.
  • Calendar tables.

Key steps: From Getting Data to Creating and Publishing Reports Cont.

  • Introduction to DAX: What is DAX and where does it fit in.
  • DAX: Calculated Columns – How to create calculated columns and why you should keep them to a minimum.
  • DAX: Measures – what are DAX measures and what are they used for.
  • Creating Reports: Introducing the Report canvas and pages. Understanding the relationship between reports, the data model and DAX measures.
  • Adding and formatting visualisations.

Publishing to Power BI Service

  • Publishing reports from the Desktop application to the Service for collaboration and distributing reports to users.
Enquire & Book
Excel Training Business benefits

Power BI Training – 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 over a decade ago 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.

Your complete training solution

Excel Training Business benefits

Before Training

Our Skills Assessment will ensure staff attend the correct level of training. Based on results, we will organise the training sessions required, who will take them and the level to best match the skills needed.

Excel Training Business benefits

During Training

We provide first class training with highly experienced trainers. Courses include lots of exercises, practise and interactivity throughout, maximising learning whether delivered online or at your offices.

Excel Training Business benefits

After Training

We will grant you organisation free access to our suite of online Power BI resources. In addition, we provide free post training support to ensure your staff utilise their new skills effectively.

Our Clients

International SOS Pioneer DJ

Enquire & Book Power BI Training

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.