FORGOT YOUR DETAILS?

A Complete Introduction to Power BI
Live Online Course

Learn in-demand skills and bring your data and your CV to life!

Course dates

Please call us to arrange a date

Duration

1-day course and 2-day course available

Format

Delivered live online by a trainer

Price

1-day course: £395 plus VAT per person
2-day course: £495 plus VAT per person

A Complete Introduction to Power BI

Learn how to create stunning interactive reports and dashboards, visualize data, provide actionable insights and drive business results!

The Microsoft Power BI complete introduction course is available on the dates shown (for anyone, anywhere bookings) and for organisations to book as 'in-house' virtual courses. The introduction course is split into the five modules below. A further 3 modules are available for those wishing to progress onto the advanced course. The training is delivered in small class sizes of no more than 8 delegates.

By the end of the course, you'll:

  • Be able to use the key components of Power BI

  • Learn how to connect to a wide variety of data sources

  • Use the query editor to transform and morph data into the right format

  • Perform complex data modelling operations using relationships, calculated columns, measures and Dax

  • Create visual and interactive dashboards and reports

  • Share Dashboards and report

  • And lots more!

In a nutshell you'll have the skills to start using Power BI with confidence.

Book course or request more information.

Course Content (1-day)

· What is Power BI and when do I use it?

· Power BI Desktop installation and versions

· Overview of Power BI service, Power BI Report Server

· Understanding Reports, Datasets and Dashboards

· Overview of Power BI, Power Pivot and Power Query

· The Building blocks of Power BI Desktop

· Creating and saving PBIX files

· Methods of loading data

· Connecting to Excel Workbooks

· Understanding the Data Model view

· Creating relationships

· Editing relationships

· Creating a simple DAX Measure

· Using Report View to create visualisations

· Using the Visualizations Pane

· Using the Fields Pane

· Interacting with Visualizations

· Changing the Visualization Type

· Moving and Resizing Visualizations

· Formatting Visualizations

· Changing Themes

· What is a DAX Measure?

· Named reference syntax

· DAX Functions

· CALCULATE function and its uses

· Implicit vs Explicit Measures

· Quick Measures

· Navigating Through Pages

· Showing and Hiding Pages

· Adding, Deleting Pages

· Renaming Pages

· Changing Page Order

Course Content (2-day)

· What is Power BI and when do I use it?

· Power BI Desktop installation and versions

· Important Information About Power BI Updates

· The Power BI service

· Power BI Report Server

· Understanding Reports, Datasets and Dashboards

· Overview of Power BI, Power Pivot and Power Query

· The Building blocks of Power BI Desktop

· Creating and saving PBIX files

· Methods of loading data

· Importing a variety of data sources into Power BI Desktop

· Connecting to Excel Workbooks

· Connecting to CSV Files

· Understanding the Data Model view

· Creating relationships

· Editing relationships

· Using Data View to sort and Format data

· Exploring the importance of custom calculation within the Data Model

· Creating a simple DAX Measure

· Using Report View to create visualisations

· Using the Visualisations Pane

· Using the Fields Pane

· Interacting with Visualisations

· Changing the Visualisation Type

· Moving and Resizing Visualisations

· Formatting Visualisations

· Removing a Visualisation

· Sorting data

· Changing Themes

· What is a DAX Measure?

· Named reference syntax

· DAX Functions

· CALCULATE function and its uses

· Implicit vs Explicit Measures

· Calculated Columns

· Measures (Calc Fields) vs. Calc Columns

· Quick Measures

· COUNTROWS(), DISTINTCOUNT(), DIVIDE()

· Creating Variables within measures & using Return / return if

· The Query Editor window in Excel and Power BI Desktop

· Applied Steps

· Shaping Data

· Formatting Data

· Transforming Data

· Combining Data

· Merging Data

· Navigating Through Pages

· Showing and Hiding Pages

· Adding, Deleting Pages

· Renaming Pages

· Changing Page Order

· Setting Page View Options

· Using Phone vs. Desktop Layout

· Filters by Visual, Page, Report

· Inserting Pictures

· Inserting Text Boxes

· Inserting Shapes

· Working with Static Objects

 

Who should attend?

Our Power BI Courses are suitable for Business Analysts and other professionals who want to create visual representations of data and produce user friendly reports and dashboards using data from Excel or databases.

Which course(s) is right for me?

This course is designed for beginners but it's recommended that you have a good knowledge of Excel (particularly Pivot Tables) or databases.

How Can Live Online Help You?

The way in which training is delivered has evolved considerably in the last few years. Our Live Online Learning is a practical, personalised and role-centred solution to training your staff remotely. Also available as a scheduled course.

Learners receive online support from highly-experienced trainers, gaining the confidence and specific skills they need, organised within their workloads.

Our accredited (Certified On-line Facilitators) Live-On-Line trainers understand how to deliver effective training in this digital environment and they have designed our virtual courses to be topic driven, so that learners get the maximum learning experience in the shortest period of time.

TOP