Next-Step Consultores are Gold Sponsors of Power Platform Madrid 2023
Next-Step Consultores, we are co-sponsors of Power Platform Madrid 2023the most important community face-to-face event of the year. Power Platform Madrid.
As always, we will once again enjoy the company of the best professionals in the sector, who will share knowledge and best practices in relation to Microsoft Power Platform. The aim is to continue to grow this great family that makes up the community of Power Platform users.
Don't miss the workshop and the sessions of our colleagues from Next-Step Consultants:
- Friday 23 June, our Director José Luis Cano and Miguel Stephen will give a workshop on Microsoft Fabric
- Saturday 24 June, at 10 a.m. in Room M, José Luis Cano will give the sessionFirst steps with Fabric" : "First steps with Fabric
- Saturday 24 June, at 10 a.m. in Room 0, our colleagues Mª José Vidal Paz and Eva Higueras will give this session: "What's new in Power BI 2023: Dynamic formatting for metrics and changes in interaction with visuals"
GPPB Madrid 2023 Agenda
Full Agenda Power Platform Madrid 2023
Measuring and optimising the composition and performance of the tabular model
The tabular model is a database with columnar storage that has a very efficient structure for querying and is designed for analytical and BI processes.
It is important to ensure the composition of the model, storing only the necessary elements, with the appropriate format and composition to guarantee the quality of its operation.
The effectiveness of model queries also depends on the quality of the DAX language used.
In the workshop we will see how to measure, with external tools in Power BI, the composition of the model, apply techniques that comply with best practices and help to optimise queries that access internal engines with effectiveness and optimal performance.
WORKSHOP 1
Fri 9:30 am - 1:40 pm
ETL with Microsoft Fabric
We will explore the options available in Microsoft Fabric for obtaining, transforming and loading data through case studies.
We will look at how gen2 data flows differ from current data flows and how to migrate Power Query queries to gen2.
We will also see how to use a pipeline to combine the execution of a data stream with other tasks, such as sending an email notification.
And finally, we will see how to combine the execution of a Spark notebook with a gen2 data flow to read data from an API and create a snaphop fact table in which the data obtained from the API is periodically recorded.
WORKSHOP 2
Fri 9:30 am - 1:40 pm
Microsoft Fabric: Exploring the platform's capabilities and applications
In this workshop we will conduct practical sessions in the different areas of Fabric to get an overview of the platform and understand the paradigm shift.
WORKSHOP 3
Fri 9:30 am - 1:40 pm
Sessions Saturday 24 June 2023
8:25 a.m.: Opening and Registration
ROOM M:
ETL with Microsoft Fabric
With the arrival of Fabric, the tools available for ETL have improved and expanded. In this session we will talk about the components of Fabric: Data Factory and Synapse Data Engineering and in particular the new version of data flows (GEN2), pipelines and SPARK notebooks.
ROOM M
Sat 9:15 am - 10:00 am
Getting started with Fabric
In this session we will explore the recent changes that have come about with Datafabric and discover why it has sparked so much enthusiasm in the data professional community.
ROOM M
Sat 10:05 am - 10:50 am
10:45 a.m.: Coffee and Networking
Fabric From Cape to Lake
We will focus on the data engineering experience that Fabric provides through tools such as Data Factory and Power BI. We will start with the extraction of data and its integration into the One Lake and we will end up creating a data model for Direct Lake, the new connection mode announced by Microsoft in Fabric that promises to take advantage of the best of the traditional modes.
ROOM M
Sat 11:20 am - 12:05 pm
Decoding sentiment with Azure, Python and OpenAI
As textual data proliferates from a variety of sources such as tweets and social media posts, it is crucial to understand the key emotions and themes behind the words. In this session, you will learn how to leverage the power of Azure Cognitive Services, Python libraries and OpenAI embeddings to gain valuable insights from your textual data.
ROOM M
Sat 12:10 pm - 12:55 pm
From "Virtual Campus" to "Campus 365".
Any educational environment, both at enterprise and academic level, can benefit from the great advantages of integrating the functionality of Microsoft 365 and Power Platform. In this session you will learn about "Campus 365", an end-to-end case in which the data4all team has standardised the use of these tools to facilitate the interaction of students and teachers in any field.
The most relevant blocks we will deal with will be:
- Potential benefits of using Teams as an LMS (Learning Management System).
- Explanation of the "Campus 365" methodology.
- Improving the user experience in Teams.
- Massively generating meeting requests in Teams with Power Automate.
- Empowering Sharepoint to be used as a content management system (CMS).
- Measuring the quality of academic or business sessions using MS Forms and Power BI.
Join us to learn how Microsoft 365 and Power Platform can transform education.
ROOM M
Sat 1:00 pm - 1:45 pm
ROOM 0:
Let's take standard Power BI visuals to the next level!
Microsoft's visuals team is starting a revolution that will take native Power BI visuals to the next level. Power and flexibility come together with these new formatting options.
ROOM O
Sat 9:15 am - 10:00 am
What's new in Power BI 2023: Dynamic formatting for metrics and changes in interaction with visuals
Practical examples of how to use measurements in dynamic format and demonstration of how to use the new configuration for visuals.
ROOM O
Sat 10:05 am - 10:50 am
Financial Diagnostics 2.0: An Artificial Intelligence and Power BI Approach
In the dynamic and competitive world of finance, data analytics has become an indispensable tool. In our talk, 'Financial Diagnostics 2.0: An Artificial Intelligence and Power BI Approach', we will explore how emerging technologies can redefine the way we understand and apply financial diagnostics.
We will discuss how Artificial Intelligence (AI) can help us decipher hidden patterns, anticipate trends and predict future economic conditions more accurately. We will reveal how Power BI, a powerful business analytics tool, can transform raw data into valuable and visually appealing information for decision making.
ROOM O
Sat 11:20 am - 12:05 pm
Single table model in Power BI? No thanks!
Good modelling in Power BI is essential to optimise the performance of our reports. The star model is the optimal model for Power BI, but according to a Microsoft study more than 80% of the models in the Power BI service consist of a single table. In this session I propose to analyse the differences of using a star model versus a single table model, such as smaller model size and therefore faster data updates, easier DAX calculations or higher scalability of the model.
ROOM O
Sat 12:10 pm - 12:55 pm
The AI is after me!
What could we do with €100, Power Platform and Artificial Intelligence? Could we follow a person in the street? Could we replace someone? Come to this session to see the real possibilities of staging (not spoiler) various artefacts and the application of artificial intelligence.
ROOM O
Sat 1:00 pm - 1:45 pm
ROOM P
The user interface is like a joke...
...if you have to explain it, maybe it's not so good.
Successful user adoption is one of the biggest risks in any CRM implementation. But there are many ways to increase the likelihood of success using native functionality for Model-Driven Apps.
So let's take a look at different strategies for creating clean, intuitive and even minimalistic model-driven applications! As an added bonus, let's point out some of the most common mistakes to avoid when it comes to user interface design.
ROOM P
Sat 9:15 am - 10:00 am
Circe, can you make me a potion with Copilot?
We will have a conversation with Circe 🧙♀️, a Virtual Agents bot inspired by the Greek mythological legend, and Copilot, about all the new features and possibilities that are being incorporated into Virtual Agents. And what about the rest of the power platform? ... there may be surprises.
ROOM P
Sat 10:05 am - 10:50 am
Document generation with Power Automate
In this session we will see how to generate documents with Power Automate from different templates, and with different data sources.
ROOM P
Sat 11:20 am - 12:05 pm
ALM with Power Pipelines
The session will discuss Power Pipelines in general, the latest announcements of best practices introduced such as scheduling or the extensibility model to streamline development in the plarafeomwww.
ROOM P
Sat 12:10 pm - 12:55 pm
One ring to rule them all! Power Platform governance
One Ring to find them, one Ring to lure them all and bind them in the low-code!
The potential of Power Platform is immense, but... What if we optimise it by governing it correctly?
We will explore the opportunities and challenges of governance in Microsoft Power Platform, the means at our disposal and share some experiences of how to survive the process of implementing a governance model.
ROOM P
Sat 1:00 pm - 1:45 pm
13: 45 Hours: ROOM AB: Farewell and closing
Don't miss it! We are waiting for you