Course Code: pwrbibesp
Duration: 14 hours
Prerequisites:
  • An understanding of basic data concepts and structures
  • Experience with Microsoft Excel and data manipulation
  • Familiarity with basic statistical concepts
Course Outline:

Day 1

Overview of Power BI

  • Introduction to Power BI and its features
  • The Value Offering
  • Licensing and Pricing
  • Overview of Power BI Components and Workflow

Power BI Desktop Introduction

  • Power BI Desktop Help and Updates
  • Understanding Updates & Preview Features
  • Technical Options & Settings
  • Exploring Power BI Desktop Components and Terminology

Extracting, Transforming & Loading Data

  • Introduction to Query Building
  • Understanding Query Design & the ETL Process Query Editor Overview
  • Importing Data from various sources
  • Importing Queries from other PBIX files
  • Understanding the Concept of Applied Steps
  • Query Building Best Practices
  • Fact & Dimension Tables
  • Non-loading Datasets

Data Modelling Concepts

  • Data Modelling Best Practice
  • Handling of different data structures
  • The purpose of Relationships between Data Tables
  • What is a Star Schema & why would I need it?
  • Combining data from multiple sources

Data Transformations and Query Techniques

  • Data Validation
  • Understanding the Concepts of Applied Steps
  • Common Data Transformations
    • Cleaning data (covers many different methods)
    • Merging Datasets
    • Unpivoting Data
    • Appending Datasets
  • Adding a Dynamic Calendar Table

Data Transformations and Query Techniques

  • Cloud based query building best practices
  • Efficient data transformations
    • conditional columns
    • columns from examples
  • Combining files from a folder to streamline processes
  • Referencing queries for complex data manipulations
  • Overcoming Layout Limitations with custom mapping
  • Building a star schema from a flat file for optimised models
  • Handling multiple fact tables for comprehensive analysis

Day 2

The Data Model

  • Creating Relationships between Tables
  • Types of Relationships
  • Working with Inactive Relationships
  • Optimising Q&A - Creating Data Synonyms
  • Optimising & Tidying Up the Model
  • Power BI Model View Updates
  • Creating Multiple Model Layouts

Introduction to DAX (Data Analysis Expressions)

  • Introduction to measures in Power BI
  • Difference between Implicit Vs Explicit Measures
  • Working with Base functions and Metrics
  • Introduction to DAX (Formula Language)
  • Understanding DAX Syntax
  • Commonly Used DAX Functions
  • Understanding Evaluation Context
  • Creating Calculated Measures Vs Calculated Columns

Report Building

  • Adding and Formatting Visualisations
  • Working with the On-object feature
  • Understanding Visual Interactivity
  • Customising Report Visual Interactivity
  • Choosing Appropriate Visuals Based on Context
  • Using Buttons to Enhance Navigation
  • Adding Conditional formatting
  • Creating or Modifying Visual Themes
  • Best Practice Guidelines and Development Tips

Enhance Reports to Answer More Questions

  • Optimising the Message of Default Report Tooltips
  • Understanding the Drills feature
  • Creating Drill through reports
  • Harnessing the power of bookmarks
  • Switching between chart types dynamically
  • Adding bookmark links to buttons, shapes and images
  • Switching comparison metrics for dynamic insights
  • Switching between multiple dimensions

Report Functionality

  • Filtering Concepts
  • Using the Filters Pane
  • Top 5 & Bottom 5 Filters
  • Adding Relative Date Filter
  • Filtering with DAX
  • Syncing Slicers
  • Time Intelligence Filters

Governance

  • Scenarios for Sharing Reports & Dashboards
  • Understanding Row Level Security
  • Creating Security Roles
  • Viewing and Testing Security Roles

Conclusion