Power BI and Excel Fundamentals

Date: 23 – 25 June 2025
Virtual Instructor-Led Training (VILT).

Key Benefits of Attending
  • SET UP a robust model to cater for automatic updates
  • IMPORT and TRANSFORM data using Power Query
  • CREATE interactive pivot tables, pivot charts, slicers and timeline without formulas
  • ADD features such as conditional format and interactive form controls
  • USE dynamic array formulas to automatically update your visuals/charts
  • APPLY powerful functions that summarize and lookup data across variable date horizons
  • CREATE advanced charts such as Sparklines, maps, waterfall chart, histogram and combined chart
  • CONNECT to a plethora of various data sources anywhere, anytime.
  • TRANSFORM data from multiple sources into a cleansed data model using the Query Editor
  • DEVELOP impressive, visually rich, and interactive reports and dashboards that will wow your audience
  • EXPLORE your business data intelligently and FIND new insights by using the power of artificial intelligence, cross-filtering, drill-through, drill-up, and bookmarks
  • SHARE your dashboard in the cloud