Power BI logo

Introduction to Power BI Desktop

This one-day workshop is an introduction to Power BI Desktop, the Microsoft tool that enables data from various sources to be ‘mashed together’ to create insightful reports.

Learners do not need to have used Power BI before, though you should be comfortable using Excel to an intermediate level.

Available for Private and Tailored group events

This course is run privately for groups or 1-2-1 Coaching sessions

Book a 1-2-1 Session or Group Event

Course Location

Happy HQ, 3rd Floor, 9 Alie Street, London E1 8DE

Course Requirements

Learners do not need any prior knowledge of Power BI, but must be comfortable using Microsoft Excel to an intermediate level. You must be confident creating Pivot Tables and advanced formula (such as If and CountIf). If you do not feel confident with this, we recommend that you take our Excel Core Level 2 course first.

People with Database, Programming, or other BI experience are also suitable for this course even if they don’t have direct Excel experience.

What You Will Learn

  • You will get an in-depth understanding of the Power BI components and how Power BI works in different scenarios.
  • You will learn how to combine data from different sources to create a relational model
  • You will discover different ways to visualise the data

If you want to expand your knowledge after taking this course, please see our Intermediate Power BI Desktop Level 2 training course.

Timetable

Introduction to self-service business intelligence and the Power BI suite of tools

  • Overview of the tools
    • Power BI Service, Power BI desktop & Power BI Mobile
    • Free versus Pro
    • 32 bit v 64 bit
    • Comparison with Excel Power Pivot tool
  • Overview of the various types of data that can be imported into Power BI
  • Preview of the example dashboard report we will create during the training

Getting started with Power BI Desktop and connecting to data sources

  • Desktop interface: overview of Ribbon and QAT
  • Connecting to various data sources
  • Use Query Editor to ‘clean’ and filter data, such as removing rows, find and replacing incorrect spellings, splitting data into separate columns
  • Saving, editing and deleting queries
  • Saving, editing and deleting with query ‘Steps’
  • Refreshing data
  • Building the Data Model by creating relationships between the different data sources
  • Creating Calculated Columns within your Data Model
  • Saving a pbix file

Creating, formatting, moving and deleting Visualisations

  • Chart Visualisations
  • Table Visualisations
  • Matrix Visualisations
  • Map Visualisations
  • Turning Interaction On or Off

Formatting and filtering your report

  • Adding Pages to your Reports
  • Applying a theme
  • Including text boxes, shapes, a company logo and a background
  • Working with Filters (including slicers, field filters, Top N, page filters v report filters)
  • Introduction to conditional formatting
Enquire now

 

NEXT STEPS

If you want to expand your knowledge after taking this course, please see our Intermediate Power BI Desktop Level 2 training course.

SMALL PRINT

The course runs 10am to 4:30pm (hot buffet lunch 1pm to 1:45pm). Please be careful to arrive by 9:45am for registration and refreshments. The course will start precisely on time and it may not be possible to go back over material missed by late arrivals. If you arrive over 20 minutes late you may be asked to leave and attend another day.

Please ensure you read our Terms and Conditions before booking for our payment terms and cancellation policy.


THE HAPPY GUARANTEE

We want everyone to go away from our courses feeling as though they have learnt useful, practical skills that they can use straight away when they go back to work.

If you don’t feel that your training has been useful or if you are unhappy in any way, please just get in touch with our Customer Services team within 30 days of the course. We will be happy to offer you additional support and training free of charge to help you to gain the skills you need, or if you’d prefer, a full refund.

Your Course Trainers

Serena McCusker

Serena McCusker

Serena is an experienced IT trainer with a background as a business analyst. She has 20+ years’ experience of managing training projects, writing training materials and delivering customised workshops. A Microsoft certified and TPMA qualified trainer, Serena provides training to an advanced level for both private and public sector clients, specialising in data analysis. She has a relaxed, approachable style and makes even the most advanced topics easy to follow.

Ed Lepre

Ed Lepre

Ed is a Microsoft Certified Trainer (MCT) and has worked at Happy for over 12 years. Although he trains the full suite of MS Office and non-Office packages at all levels, his favourite package is Excel. A previous winner of the prestigious Learning and Performance Institute's 'Learning Professional of the Year' award, as well as other training accolades, he is also the IT Helpline Manager.