Microsoft Excel Power BI Training Course Beginners

Microsoft Excel Power BI Overview

A Power BI training course is essential in understanding how to use this Microsoft tool to handle the onslaught of data we receive in today's world. Organising that data can be hard. Getting any specific, meaningful answers from the data is difficult. Presenting that data in a manner simple to understand for various people is nearly impossible.

Power BI is the answer to all of the above. Allowing you to import data from pretty much any source. This course focuses on using data in Excel to produce Charts and other visualisations including interactive dashboards. You will then learn how to use the Power BI web service to share these reports with others.

Power BI DAX Training Course

On completion of the course the delegates will be able to:

• Use Excel to produce interactive Charts and Visualisations that can be easily shared
• Organise and Analyse vast amounts of data with ease
• Create Interactive Dashboards
• Learn how to use the Power BI Web Service to share these reports with others

Click on the below image and have a play about with with an example dashboard. Select Time, Colour, Customer or Geographic Analysis to explore a wide variety of dashboard options that you will be able to create on completion of this course.

Course Duration: 1 Day

Course Prerequisites:

Power BI desktop is a separate application to Excel, but knowledge of Excel is really a must before undertaking this course.

Before the course it might be an idea to take a look at:

• Formatting ranges as a Table
• Slicers
• Various Charts

Although not absolutely essential an understanding of data storage, fields and how data should be stored would put you at an advantage.

Course Outline

Introduction to Excel Power BI

• Business Analysis
• Installing Power BI
• Check your version of Office

Getting Data

• Excel

Creating Calculated Columns

• Concatenation
• Date Formulas

Visualisations with Power BI

• Formatting Visualisations
• Adding a Slicer
• Sorting the Month Order Problem
• Multiple Labels on Axis
• Drilling Down
• Creating Hierarchies - Multiple Labels on the same Axis
• When to use a Tree Map

Filters

• Adding Arrows and Comments

Edit Interactions

Calendar Table

Relationships and Keys

• Showing Rows with no Data
• Using Excel Tables

Laying out a Page

DAX

• YTD - Year to Date
• Previous Year
• HASONEVALUE
• The Process of RANKING

Importing Visualisations

• Importing Custom Visual from the Web
• Timeline Slicer Visualisation

Publishing

• Signing in

Navigating Online Power BI

• Pinning Dashboards
• Asking Questions of your Data
• Custom Q&A Questions
• Removing a Visualisation from the Dashboard

Insights

• Importing Custom Visuals

Power Query

• Removing Errors
• Applied Steps
• Removing the Rows Entirely
• Custom Columns and Try
• Adding an Index Column

Live Online Instructor Led Training

1 - 8 Students

£250 + VAT - 3hrs (bespoke)

£500 + VAT - 6hrs (full day*)

* Full training days can be split into 2 sessions

Classroom based Beginners Power BI Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the the following form to calculate how much.

So where do you go from a beginners Power BI course? Well one of the aspects we touched upon was the DAX language. DAX stands for Data Analysis Expressions and is a Data Modeling language.

Comprehensive coverage of DAX is covered in our Power BI DAX Training Course where we cover more of the functions in Detail, including the Calculate function and multiple time analysis functions.

One other course you might be interested in taking in conjunction with this would be the SQL Server Fundamentals course. By taking this course you will be able to either:

1. Prepare your data before loading into Power BI
2. Type SQL directly into Power BI.

Microsoft Excel 2016 Training Course Advanced

Microsoft Excel 2016 Training Course Intermediate

Microsoft Excel Pivot Tables Training Course Beginners