Mastering Dynamic Arrays and LAMBDA in Excel
Mastering Power BI for Desktop - Comprehensive Learning Experience
Advanced Visualizations in Power BI
Budgeting and forecasting modelling in Modern Excel
Master Your Data using Power Query
Building Interactive Dynamic Arrays Dashboards and Visualizations with Excel
21 October
The old rule—one formula, one cell—is gone. We no longer need to drag formulas, update ranges, and hope nothing breaks. With Excel’s new dynamic array engine, we can build smarter, more flexible, and more maintainable formulas.
This masterclass helps you break free from outdated ways of thinking and embrace a modern formula mindset.
By the end, you’ll understand how Excel’s modern calculation engine really works; equipping you to solve complex problems with fewer formulas and clearer logic.
21 October
Who is this for?
This Мasterclass is designed for data analysts, business intelligence professionals, and anyone interested in leveraging the power of Power BI to transform data into insightful reports and dashboards. The course targets individuals with a basic understanding of data concepts and a desire to enhance their skills in data modeling, visualization, and report publishing by providing the all-important answer to the WHY question: Why are we building it like this? And with a very important concept in mind—it’s called a semantic model.
This holistic approach ensures that participants learn to build robust Power BI models while keeping the overall goals and big picture in mind. This Мasterclass aims to equip learners with the skills needed to create insightful and impactful reports that drive business decisions with the overall picture in mind.
Course Outline:
Part 1: Planning the End Result
Part 2: Setting Up Our Power BI Desktop File
Part 3: Importing Data with Power Query
Part 4: Building the Data Model
Part 5: Writing DAX Measures to Service Our Reports
Part 6: Setting Up Reporting Logic and User Roles (Row Level Security)
Part 7: Visualizing Data the Right Way
Part 8: Publishing the Report and Setting Up the Workspace App
Technical / Software Requirements:
23 October
Part 1 – Planning Before Building
Objective: Get clarity before jumping into visuals.
Part 2 – Getting more out of Native Power BI Visuals
Objective – Learn to use clever modelling and DAX tricks to get more out your visualizations
Part 3 – Adding Design and Polish
Objective – Learn to make your overall dashboard look clean and professional.
Technical / Software Requirements:
Power BI Desktop (latest version)
Windows operating system (Windows 10 or later)
23 October
This masterclass covers issues such as using budgets to measure staff performance, linking budgets to the strategic planning process and a comparison of budgeting techniques. We explore the difference between budgets and forecasts, and learn how to create your own budget model, perform what-if analysis, break-even and budget scenarios.
In this practical course we will explore the difference between budgets and forecasts and attendees are encouraged to share their own experiences with the class. During the class, participants will build their own capital expenditure forecasting model to bring a practical application to the skills they have learned. The model will include capex spend spend, cashflow and depreciation calculations as well as scenarios and sensitivity testing.
24 October
The sad reality is that not all data is stored in nicely curated databases and often – even when it is – the data analyst doesn’t have access. Instead we have to piece together data provided in text files, Excel files, web pages and even the body of emails to build the business intelligence solutions we need. Until now this has been a painful process with a great deal of cut and paste effort, and updates have been tedious and error prone. That stops today.
In this masterclass, you’ll learn how Power Query can clean up, reshape and combine your data with ease – no matter where it comes from. Converting ASCII files into tables, combining multiple text files in one shot and even un-pivoting data is not only simple, but an investment in the future refreshable with a single click when next needed.
If you need to learn one skill in Excel today, how to work with Power Query is it. Not only will it change the way you “Get & Transform” data in Excel, but it’s also the system used to collect data for Power BI desktop, meaning these skills are transferable to other programs.
24 October
Regular static Excel charts can become dynamically and interactively enriching by adding an amazing feature: spilled ranges with the newest functions: Dynamic Arrays.
Building the charts connected to pivot table slicers is one step, getting the data ready is another, but how about assembling these techniques along with many other ones to build fantastic tools for decision making? Let’s call these tools: “Dynamic Arrays Dashboards”.
Previously, we have seen these have been built with awesome VBA or the classic pivot tables, but now… let’s give the chance to dynamic arrays functions and spilled ranges to build fantastic interactive reporting sleek dashboards for smart decision making.
Be part of the most significant international Microsoft Excel event of the year! Reserve your spot now!