01483 688488 01483 688488 Request a callback Email us
Microsoft
AccessAccess
ExcelExcel
OutlookOutlook
Power BIPower BI
PowerPointPowerPoint
ProjectProject
SharePointSharePoint
VisioVisio
WordWord
Adobe
Adobe AcrobatAdobe Acrobat
Adobe After EffectsAdobe After Effects
CaptivateCaptivate
Creative CloudCreative Cloud
IllustratorIllustrator
InDesignInDesign
PhotoshopPhotoshop
Premiere ProPremiere Pro
CAD
AutoCADAutoCAD
RevitRevit
InventorInventor
SketchUpSketchUp
SolidWorksSolidWorks
Technical
Articulate StorylineArticulate Storyline
Crystal ReportsCrystal Reports
HTML5 and CSSHTML5 and CSS
MapInfoMapInfo
SQL ServerSQL Server
RR
SPSSSPSS
SQLSQL
Working With WordPressWorking With WordPress
Finance
Introduction To FinanceIntroduction To Finance
XeroXero
Soft Skills
Chairing Meetings
Deliver Confident & Impactful Presentations
Assertiveness Training
New Manager & Team Leader Skills Builder Training
Time Management
Minute Taking Training Course
Introduction to Power BI

Introduction to Power BI

Introduction

Build your Power BI skills fast on this 1-day introduction course.

This is a hands-on course which includes plenty of time to play with what you are being taught and ask questions.

Our expert instructors break the course into easily digestible sections and ensure that no-one is left behind.

By the time you finish, you’ll be a comfortable, capable Power BI user.

✔ A complete introduction to Power BI.
✔ Plenty of time to ask questions and one-to-one attention.
✔ Friendly expert trainers who make sure no-one is left behind.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support for 6 months after the course.

What Will I Learn?

By the end of this course, you will be able to confidently:

  1. Connect to a variety of data sources using Power BI
  2. Manipulate and transform your data.
  3. Create a wide variety of different data visualisations.
  4. Create reports which you can publish via the web or PDF.

Am I Ready For This Course?

It is recommended that you have completed our Excel Advanced level course, or have equivalent experience (particularly of Pivot Tables) before you attend this course.

It is also helpful if you have a basic understanding of relational databases.

Course Details

  • What is Power BI and when do I use it?
  • Power BI installation and versions.
  • Different data sources: Files, Databases and the Web.
  • Repointing to Moved Data Source
  • Removing Columns/Rows
  • Data Type Changes
  • Filters
  • Group
  • Split
  • Duplicate
  • Combine: Append and Merge
  • Pivot/Unpivot
  • Columns: Add Column, Custom Function, Conditional Column
  • Index
  • Extract
  • Model View and Relationship management
  • Join Kinds
  • Hierarchies
  • Working with Related Tables
  • Formula
  • Measures
  • Quick Measure
  • Date Table Rules
  • Setting the Date Table
  • External and Internal
  • Automatic Date Table
  • Time Intelligence Formulas and Measures
  • Matrix
  • Conditional Formatting
  • Chart
  • KPI (Key Performance Indicator)
  • Spatial Intelligence
  • Filter: Basic and Advanced
  • Top 10
  • Slicer
  • Drill Through
  • Publishing to the Web
  • PDF

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

✔ A full-colour A4 manual covering everything in the course to keep.
✔ A USB stick so that you can take the course exercises home with you.
✔ A Certificate of Attendance.