Data analysis and analytics. Uncover insights and transform your organisation.

This intermediate Power BI course will expand on your knowledge and skills, showing you how to create more complex data models, which in turn will result in enhanced visuals and more interactive dashboards.

Using custom slicers, defined functions and calculated measures we will move beyond the basics and build your confidence in connecting, cleansing, and presenting your data in a variety of enriched and valuable formats.

You will also learn the language behind Power Query – allowing you to engineer more complex queries and extract results from a variety of data sources.

Finally – it is important that shared reports are both flexible and secure. We will show you options for sharing and collaborating on dashboards and reports with stakeholders securely via the Power BI cloud Service.

Aims

We want to elevate your dashboards and take your reports to the next level with custom visuals and data transformations from multiple sources. You will also learn to protect and secure the business intelligence that you build, analyse and share with your colleagues.

Outcomes

By the end of this course, you should be able to:

• understand procedures related to data acquisition and transformation
• comprehend the concept of DAX hierarchies
• comprehend necessity and procedure for creating a date table
• identify the purpose of the Calculate and Related DAX functions
• work with DAX measures
• work with aggregatio