Power BI Fundamentals - Powering Up Your Data Insights

Introduction to Power BI Fundamentals

- Understand the key components of Power BI report development - data sources, data transformations, data modelling, and data visualisation

- Learn how to review and analyse data using Power BI

- Develop strategies for explaining the goals and purpose of your 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

- Learn how to structure a data narrative and story

- Understand the principles for visually presenting data

- Apply these principles to create effective visualisations for simple and complex cases

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

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

- Develop skills with key aspects of data dimensions including the calendar or dates table

- 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

Bringing the data model to life - Introducing relationships and DAX

- Getting started with DAX - learn formula language and filter contexts 

- How to calculate measures to answer specific questions 

- Develop a hands-on approach to grouping and segmenting DAX and creating and editing

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

- Learn how to 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 

- Learn how to use tooltips to increase information density in your visualisations

- Identify ways to measure the of Power BI adoption 

- Explore third-party extensions and AI visuals to expand your visualisations

- 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