Microsoft Excel Power BI Training Course Beginners Hammersmith

Hammersmith Beginners Microsoft Excel Power BI Course Overview

If you're wanting to book your Microsoft Excel Power BI Training Course and are wondering about the following:

• You don't know what course to take!
• You have no idea of your skill level.
• You are wanting training for your team.

Then we'll be happy to help you choose or design a course that suits you. We can come to you but should you want to get away to do the Microsoft Excel Power BI Training Course then the offices we use in Hammersmith are at:

Hammersmith
Crown House
72 Hammersmith Rd
Hammersmith
London W14 8TH

An ideal location for your Microsoft Excel Power BI Training Course Beginners training course. The training centre is situated in the heart of west London between Hammersmith and Kensington.

The building, Crown House, is bright and modern with large windows giving the training course location a spacious, airy and comfortable feel. Within easy walking distance of Hammersmith High Street.

The training course location is close to major roads, local bus routes and several London Underground stations the closest being Barons Court.

There are many other computer training courses in Hammersmith & Fulham available. Please see if there is a course for you.

Hammersmith is a lively area with a thriving arts scene, including the famous Hammersmith Apollo.

Course Duration: 1 Day

Complete 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

This course is suitable for those using Microsoft Office 365 (O365).

Microsoft Excel Power BI training is also available for online training via Zoom or Teams.

All you need to know about our Live Online Training.

Live Online Training

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 SharePoint 365 Training Course Beginners

Microsoft Excel 2016 Training Course Advanced

Microsoft Excel 2016 Training Course Intermediate

Microsoft Excel Pivot Tables Training Course Beginners

Keep yourself updated with our Free Power BI Training