Course Code: pbinlbesp
Duration: 14 hours
Prerequisites:

A good basic understanding of Power BI

Audience

  • Those who have completed the Power BI Foundations course and want to advance their skills.
  • Professionals already working with Power BI who want to gain deeper insights into next level concepts and techniques. 
  • Individuals seeking to enhance their ability to create impactful reports, perform complex data analysis and optimise their Power BI workflow.
Overview:

The Power BI Next Level course is designed for data analysts and report authors who have completed our Power BI Foundations course and want to further enhance their skills in Power BI. This instructor- led, 2-day course delves into next level concepts and techniques that empower learners to create highly effective reports, analyse complex data, and optimise their Power BI workflow. Participants will gain in-depth knowledge of that will empower them to take their Power BI reports to the 'Next Level'

Course Outline:

DAY 1

Review and Optimisation of Core Concepts

  • Refreshing data import and connection techniques
  • Data modelling for improved performance
  • Techniques for creating impactful reports
  • Exploring cloud features and functionalities for collaborative workspaces, dashboards, and apps

Enhanced Data Visualisation and Storytelling Techniques

  • Optimizing KPI cards for effective data communication
  • Selecting appropriate visuals based on context
  • Enhancing reports with tooltip report pages
  • Implementing drill-down functionality for deeper insights
  • Using visuals to represent complex data relationships
  • Adding analysis features to visuals for data exploration
  • Grouping and binning data to uncover patterns and trends

Calculations with DAX

  • Mastering iterator functions for complex calculations
  • Referencing inactive relationships in the data model
  • Exploring the capabilities of the HASONEVALUE function
  • Implementing index functions for baseline comparisons
  • Utilising offset functions for relative value comparisons
  • Window functions for running totals and moving averages

Next Level Analytics and What-if Analysis

  • Concepts and applications of what-if parameters
  • Building what-if analysis reports for scenario planning
  • Utilising numeric parameters for dynamic slicing
  • Creating calculated tables to support complex calculations
  • Capture Slicer Selections with DAX
  • Switching comparison metrics for dynamic insights
  • Utilising field parameters for flexible analysis:
  • Switching between multiple measures
  • Switching between multiple dimensions

Filter Contexts with DAX

  • Unravelling the DAX filter context
  • Dynamically modifying the filter context with 'CALCULATE’
  • Manipulate filter context:
    • ALL
    • ALLEXCEPT
    • VALUES
  • Leveraging the 'FILTER' function
  • Implementing Time Intelligence functions
    • ‘TOTALYTD’
    • ‘SAMEPERIODLASTYEAR'
  • Streamline DAX with Variables
  • Employing variables for DAX function debugging

 

DAY 2

Dynamic Visuals and Bookmarking

  • Implementing dynamic binning techniques
  • Adding dynamic subtitles to reports
  • Creating dynamic headers for interactivity
  • Harnessing the power of bookmarks
  • Switching between chart types dynamically
  • Adding bookmark links to buttons, shapes and Images
  • Creating report menu pages with bookmarks
  • Consolidating report views onto a single page
  • Exploring the Q&A Visual (natural language queries)
  • Assign page to a Q&A for targeted and contextually

Live Connect and External Data Integration

  • Connecting to APIs for real-time data integration
  • Using Power BI in other Apps
  • Accessing internet databases for enriched data analysis
  • Connecting to Power BI Data Sets (Live Connect)
  • Power Query in the Cloud - Self-Service Data Prep
  • How Power BI Data Flows work
  • Connecting to and Managing Power BI Data Flows
  • Using OneLake and Power BI Datalakes

Next Level Security and Governance

  • Implementing dynamic row-level security
  • Mapping user IDs to the data model for personalized access
  • Utilising DAX functions for returning usernames
  • Assigning users to Power BI security roles for controlled access

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

Cloud Service Administration and Next Level Dashboards

  • Utilizing on-demand data refreshing
  • Scheduling data refreshes to automate data updates
  • Managing workspaces, users, and permissions
  • Creating next level dashboards with snapshot capabilities
  • Monitoring usage metrics