23 April, Metropolitan Hotel, Sofia
23 April, Metropolitan Hotel, Sofia
25 April, Metropolitan Hotel, Sofia
25 April, Metropolitan Hotel, Sofia
A Minute To Decide (a Data Visualization MasterClass)
23 April, Metropolitan Hotel, Sofia
Masterclass description:
All these questions (and many more) will be answered in this Masterclass. We will dig deep into theory and be able to understand and design good reports. This is also one of those: “Once you see it, you cannot unsee it” moments, as you will now look at reports differently, and reporting errors will immediately stand out to you.
Advanced Formulas in Excel: Beyond the Basics
23 April, Metropolitan Hotel, Sofia
Masterclass description:
What are spill ranges, array of constants, and LAMBDA functions?
Should I be using SUMIFS or SUMPRODUCT, CHOOSECOLS or CHOOSE, XLOOKUP or INDEX, TAKE or OFFSET?
Join me and unlock the full potential of Excel in our Advanced Formulas Masterclass. This session is designed to elevate your skills, offering expert insights into complex array formulas, advanced lookup functions and dynamic reporting techniques.
This masterclass aims to provide attendees with a comprehensive understanding of Excel’s advanced capabilities, enabling them to handle complex data tasks with greater confidence and efficiency.
It is a project-based session, and we will be going from data to insight as we complete multiple projects and learn many Excel functions and pro tips along the way.
Course Contents
Software and Technical Requirements.
Masterclass attendees should have a supported Excel version installed: 2016, 2019, 2021, or Microsoft 365. There will be examples that utilise the power of Excel for Microsoft 365, so attendees that use an older version can use a free Microsoft 365 account and use Excel Online (https://www.microsoft.com/en-us/microsoft-365/free-office-online-for-the-web
Dimensional Modeling for the Excel Pro
25 April, Metropolitan Hotel, Sofia
Masterclass description:
Built-in to Microsoft Excel, Power Pivot is a technology that is revolutionizing the way that we look at data. Allowing us to link multiple tables together without a single VLOOKUP statement, it enables us to pull data together from different tables, databases and even external sources, where we never could before.
The capabilities of Power Pivot are amazing, but they require a sound understanding of a concept called “Dimensional Modeling” in order to get started.
You’ll learn key concepts and terminology around data warehousing and dimensional modelling including Facts, Dimensions, Relationships, Schemas, Keys and more. You’ll learn why the PivotTable has been “too helpful”, and how it can impact your ability to extend your data models.
Armed with the background theory on modeling, it’s then time to get your hands dirty with hands-on examples of solving several “many to many” join problems. From composite keys to bridge tables, slowly changing dimensions to flattening snowflakes, you’ll learn which tools and techniques to use and when.
In this Masterclass we will explore what this means, teach you how to design your tables properly as well as link them together in the correct way to set you up for success. Developed by a CPA with real world experience who is also a renowned Business Intelligence expert, this course is intended to teach you the right way to set up your Dimensional Model in order to make the next stage – writing DAX formulas – easy. (Please note that this course is not a course on writing DAX formulas.)
Technical requirements:
1. Microsoft Excel 2016 or higher, AND
2. The Power Pivot tab must be visible in the ribbon
If the Power Pivot tab is not visible, it can be enabled via the following method:
• Go to File -> Options -> Add-ins
• Manage COM Add-ins -> Go
• Check the box next to Microsoft Power Pivot for Excel -> OK
Solving Advanced Data Cleaning Problems with M Language in Power Query
25 April, Metropolitan Hotel, Sofia
Masterclass description:
In this Masterclass you will learn to work beyond Power Query’s User Interface and solve difficult data cleaning problems using the M Language in Power Query.
What topics will be covered?
Ideal Audience
This Masterclass is for people who already know and have worked with Power Query’s user interface (either in Excel or Power BI) and want to explore advanced problem solving using the M Language.
Training requirements.
23, 24, 25 April 2024
HYATT Regency hotel, Sofia