
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