Microsoft Excel Power BI Training Course Beginners

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.

Other Excel training courses

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

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.

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.