Madzy Stikkelorum
Data Analytics Consultant at Quanto
Utrecht, The Netherlands
Actions
Madzy is a Data Analytics Consultant at Quanto, organizer of the Power BI Summer School in the Netherlands and former Board Secretary of the Dutch Power BI User Group. With a master’s degree in Mathematics, analyzing data has always been one of her passions, but in the last few years this has extended to organizing events and sharing her knowledge with the community. She does this as a public speaker at conferences, and in blog posts that can be found at https://quanto-blog.eu/.
Links
Awards
Area of Expertise
Topics
Value level security in Power BI
The use of Power BI is increasing rapidly. More and more organizations use Power BI, and the number of users per organization grows. Data security has always been an important topic but becomes more prominent with an increasing number of users. How do you ensure that users have access to the information they need?
In Power BI, security within a data model can be implemented through row-level security (RLS). With RLS, complete parts of the model can be hidden from a user. But what to do when only certain attributes must be secured, like social security numbers or paygrade levels? In this session you will learn how to implement value-level security in Power BI.
Make your data shine - Data storytelling with Power BI visual reports
To get insights from data, insights need to be shown somehow. Power BI visual reports are all about showing results in a visual way. But users also need to understand and act upon the insights. How can insights be provided in such a way that users can take action? Applying storytelling principles turns out to be an effective approach to this.
In this session, I discuss data storytelling and how to apply storytelling concepts to the design of Power BI visual reports. We will also take a look at Power BI features that specifically support data storytelling.
Fresh produce: using Power BI as a calculation engine for BC
Power BI is the leading platform for business intelligence. The core of the Power BI platform is formed by datasets with DAX calculation capabilities that enable interactive reporting on large sets of data. Join this session to learn about another way to use this technology: perform hugely complex aggregations and calculations to enrich business processes.
In this session, we present a Power BI solution based on a real-life use case involving BC and the Power Platform. We deal with inventory analysis and financial settlements for perishable goods, like tomatoes, for which the age of inventory is relevant. The Power BI model requires recursive calculations over a period of one week, which is the base unit for the client’s business process. The calculation results are fed back to BC using Power Automate and Power Apps. The same set-up is used to run scenario analyses over extended periods of time. We discuss the solution architecture and do a deep dive on the specifics of the calculation engine implemented in Power BI.
AI in the Power platform: a case study
Microsoft runs an Azure Cognitive Service called Face Recognition. In this session we show a model that uses PowerApps, Power Automate flows and Power BI together with the Azure Face recognition. It is a real business project, made for a customer in the congress industry.
This case study uses a PowerApps model to get three photos of a participant, while he/she is looking at different colored pictures: blue, green or red. A Power Automate flow transfers the photos to the Face recognition, which will return the metrics of each photo. Based on the metrics the PowerApps model finds which color -picture- returns the highest “happiness” metric.
Based on this highest “happiness” factor and the color of the shown picture, the participant gets a lemonade in his/her “happiness” color. In the meantime, a Power Automate flow pushes the -aggregated- metrics, including gender and age into a live Power BI dashboard. The complete cycle takes less then a minute.
In this session we do a live demonstration of the model and show you the key elements in the PowerApp, the Power Automate flows and the Power BI dashboard to give you an idea of the real Power of the Power platform.
Advanced Interaction in Power BI Visual Reports
Power BI visual reports depend on interaction to focus on the most important insights, while enabling users to dive deeper into detailed information. The challenge with many Power BI models is that they offer many different insights, which easily leads to an overkill of interaction options in a report. How do we help report users to keep their focus while offering lots of interaction?
Using storytelling principles can be an effective approach in this. In this session, we will discuss data storytelling and how to combine storytelling concepts and advanced interaction in Power BI visual reports. We will also cover several techniques to help users navigate all insights provided. These include field parameters, conditional button actions, and dynamic drill through, among others.
Data Saturday Croatia 2023 Sessionize Event
Days Of Knowledge Central Sessionize Event
Data Saturday Stockholm 2023 Sessionize Event
SQLBits 2023 - General Sessions Sessionize Event
Global Power Platform Bootcamp 2023 - Belgium Edition Sessionize Event
DATA:Scotland 2022 Sessionize Event
Madzy Stikkelorum
Data Analytics Consultant at Quanto
Utrecht, The Netherlands
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top