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 to create a data culture 

- Explore the adoption roadmap for business intelligence

- Identify the data literacy skills and artefacts required to demonstrate capability

Data Storytelling and Influencing Using Power BI

- Structure a compelling data narrative

- 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 practice to extract, clean, and transform data

- Develop skills in managing key data dimensions

- Explore M Script to customise transformation and queries

Data Model Development and Building Relationships

- Develop a complete data model using star schema design

- Build relationships for easy slicing and dicing of data

- Use tools to ensure all key relationships exist prior to build

Introducing Relationships and DAX

- Learn DAX 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 reporting page structure and user experience

- Customise reports using buttons, colours, and other design 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 have strong Excel skills, competency with functions such as V-Lookup and pivot tables, or experience with other reporting tools