Today every business enterprise needs extensive business insights and Power BI puts the power in your hands.

Power BI gives Excel users the capacity to draw on large amounts of information from multiple sources, link it all together and then perform calculations on the data so it can then be sliced and diced any way you want. This highly interactive course is focused on proven techniques which utilise the amazing capabilities of Power BI as a reporting and data visualisation tool.

The course covers the fundamentals of data storytelling and how to convert a complex data set within a 3- way financial model into a beautifully designed interactive dashboard that can be displayed and distributed using the world’s best BI tool.

There will also be other core elements needed to get an understanding of how Power BI can help take the myriad of linked spreadsheets and Access databases and move them into Power BI.

A program which has the capacity to crunch millions of records to quickly summarise and report on key trends and business insights.

You will use Power BI to extract and shape data; you will build a Power BI Model from scratch, create relationships, write DAX formulas and set up interactive reports.

Making this a hands-on workshop which enables participants to walk away with practical skills they can reuse in their workplace or business.

• Understand how the Power BI desktop builds on the functionality of Excel’s formula, PivotTables, slicers and many more key analytical functions.

• Be able to import data from a variety of different sources and relate them quickly to deliver key data insights without the aid of IT departments.

• Utilise best practice database design, realising the power of the Data Model by using LOOKUP lists and efficient database design.

• Create stunning, highly interactive and changeable dashboards which draw on source data in real-time.

• Refreshing the data model to incorporate fresh datasets.

• Introduces Power BI’s Data Analysis Expressions (DAX) language below.

• Publish reports to the web and how to manage and maintain these reports for your users.