Home Courses Enquiries Online Training Testimonials Locations Prices

Total Price:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

Testimonials

Faccenda

"Excellent training, relaxed atmosphere and Simon really knows his stuff!"

Belkin

"Informative and well paced. Instructor demonstrated a good knowledge of the subject matter throughout the course."

Network Rail

"Very good, pitched at the right level. Simon was very engaged, enthusiastic and knowledgeable and was left plenty of time at the end for specific queries.

Print & Desktop Publishing

Apple

Presentation

Online Videos

Locations

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.

Power BI Example Dashboard.

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 Power BI

Installing Power BI
The different parts of Power BI (Desktop and Web service)
Correctly structuring your data

Data Cleansing

Handy Excel functions to clean your data
Excel Tables / Ranges

Handling Data

Upload Data into Power BI
Creating Relationships with Power BI

Introduction to DAX (Data Analysis Expressions)

Calculated Columns
Measures
Basic DAX Functions

Power BI functionality

Natural Language Queries
Quick Insights
Reports
Creating Dashboard with Drill down capability

Managing your Data

Sharing your reports
Refreshing your data
Publishing your data
Choosing the right Visualisations/Charts
Custom Visualisations
Publish Excel data models in Power BI

Beginners Power BI Prices from:

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

If you are interested in this course fill out the following form for further details:

Power Pivot Tables 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: