Excel Level 6 BI Visualisations

A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

Description

Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues. 

  • Prepare Reports for import
  • Import files
  • Importing text files
  • Creating DAX formulas
  • =RELATED
  • Calculated columns
  • Fields for slicers
  • Creating Measures
  • Visualisations 
  • Using Slicers to view data

Prerequisites

Delegates MUST have completed our Excel Levels 1 - 4 courses or provide evidence that they are already competent to this level to book onto this course. The earlier courses provide foundations for the techniques we teach on this training event. Delegates should be confident about their Excel skills before joining this class. 

Similar courses

Knowing your numbers - your core metrics - is absolutely critical to your success. Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to give it a glance. Yes, it's time to make a dashboard. It's like the instrument panel for your business. Your car has one. Planes have one. Let's make one for your business too.

More Information

Our Excel Level 1 course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!). You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know! We teach the secrets of formatting super-fast to make your spreadsheets look great.

More Information

Our Excel Level 1 course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!). You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know! We teach the secrets of formatting super-fast to make your spreadsheets look great.

More Information

Our Excel Level 1 course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!). You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know! We teach the secrets of formatting super-fast to make your spreadsheets look great.

More Information

This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use Business Intelligence tools –

More Information