Excel Power BI Desktop Visualisations (Level 6)

 

Excel Power BI Desktop Visualisations (Level 6)

This training course is a practical guide to using the Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

What is Power BI?

Power BI (Business Intelligence) is a free downloadable application that allows you to combine and manipulate data to show meaningful insights through new charts and visualisations in a Dashboard suitable for Management Reports. When the Dashboard has been prepared, a user can simply click to see different headline information without seeing all the data behind the scenes. This can be used to base decisions on facts not opinion.


Duration 1 day

Classroom Training

Our course follows our Excel Business Intelligence Level 4 training where you will have learnt how to clean, combine, manipulate and refresh data from many sources suitable for use on your Dashboard. 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. This course focuses on creating DAX formulas and Measures used in the Chart Visualizations.

In simple language, we’ll help you find your data, get it ready and use it in Chart/visual format with easy to use buttons to switch views and this means you can present your data to management in an easy to understand format.

Data can be for any industry or sector – examples can be for Sales eg market segments, or Engineering eg impact of repairs and use of engineers, or Human Resoures eg Leavers, Inductions, Sickness, Holidays – there are thousands of applications of this tool.

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

Learn to create dashboards to analyse and interrogate large data sets.

Please note there are pre-requisite courses/knowledge that you will need to have to take this course. We advise you to attend Excel Business Intelligence Level 4 first. Please ask us for details, we are happy to discuss this with you.

Get A Quote

  • This field is for validation purposes and should be left unchanged.

Ways to attend

Public courses are available for individual bookings or for group training we can deliver Onsite Training.

Online Training – by appointment

Please call us on 01952 581 550 to speak to us

Looking for other topics?