Further Microsoft Power BI (two-day)

Bring together other software like SharePoint, Excel and Power Automate into your Power BI environment and start to understand how you already have all the tools at your fingertips. You just need to harness them.

N/A

Transforming Data

• Import data from different sources into Power Query
• Connect SharePoint sites to data models
• Practise advanced data transformation techniques via Power Query
• Learn how to merge and append queries
• Pivot and unpivot data
• Group data
• Add calculated columns in Power Query

Data Models and Relationships

• Create a data model
• Understand the star schema
• Build different types of cardinalities between data sets
• Explore the importance of relationships to reports and visualisations

Shaping Data

• Work with more complex DAX in Power BI
• Understand the difference between calculated columns and measures
• Create calculated columns and measures to data models

Creating Reports

• Explore different types of visualisation
• Build meaningful reports from data sets
• Format the appearance of reports

Power BI Navigation and Security​

• Understand the behaviour of slicers within reports and dashboards
• Explore Multi-level Security
• Apply and share roles to reports and dashboards

 Working with the Online Service​

• Assign security roles to colleagues
• Build dashboards from published reports
• Share dashboards and review roles
• Create automatic refresh schedules

Day 2 entails working on Power BI data projects using your own data and systems. 

You will learn on-site.

For more information, contact dcgprofessional@dcg.ac.uk