Power BI Fundamentals - Powering Up Your Data Insights

Introduction to Power BI Fundamentals

- Understand the key components of Power BI report development

- Review and analyse data using Power BI

- Develop strategies to explain the goals and purpose of data visualisation

The importance of data literacy in adopting Power BI 

- Understand how create a data culture 

- Explore the adoption roadmap for business intelligence

- Understand what ‘data literacy’ and ‘artefacts’ are required to demonstrate this  

Data storytelling and influencing using Power BI

- Structure a data narrative and story

- Understand the principles for visually presenting data

- Create effective visualisations for simple and complex cases

Shaping data using Power Query to Extract, Transform, and Load (ETL) 

- Hands on practical application - extract, clean, and transform data

- Develop skills with key aspects of data dimensions

- Explore M Script to customise your transformation and queries

Data model development and building relationships

- Develop a complete data model with the star schema design

- Build relationships within the data model for ease of slicing and dicing data

- Tools to ensure all key relationships exist prior to build

Introducing relationships and DAX

- Learn formula language and filter contexts 

- Calculate measures to answer specific questions 

- Develop grouping, segmenting, and editing DAX expressions

Creating reports and data visualisation part 1 - Basics of navigation and formatting

- Create dashboards and page navigation 

- Understand the structure of a reporting page and user experience

- Customise reports using buttons, colours, and other features

Report and data visualisation part 2 - Advanced visuals 

- Use tooltips to increase information density in visualisations

- Identify ways to measure the of Power BI adoption 

- Explore third-party extensions and AI visuals

- Please note this is an advanced Excel course. Attendees should possess good Excel skills, competency with functions such as V-Lookup and pivot tables, or experience with other reporting tools