31 March 2022
09:00 - 17:00
Jaarbeurs MeetUp (Beatrixgebouw)
Precon: Analytics at scale with Power BI and Azure Synapse
This training day we will learn how Power BI and Azure Synapse Analytics can form a solid marriage, and provide a truly scalable analytical platform. Together we will explore the tricky parts of an enterprise-grade Power BI solution, and how advanced modelling capabilities of Power BI with a solid data lakehouse / warehouse in Azure Synapse Analytics can save the day!
For Power BI solutions, we see it can be challenging to load data from APIs, or to store historical snapshots. This is where you can really benefit from the capabilities of a data platform. Also, if you already have an amazing data platform, we see it can be challenging to load all of its data into a Power BI dataset and still have a performant solution, or to refresh data in near real-time. Finally, daisy-chaining all the steps in the data flow – from source to report/dashboard – can be tricky to design, especially if you don’t want to do a full refresh of the Power BI dataset for performance reasons.
The advanced capabilities of both worlds can really complement each other. We will train you how to design and build a solution, share our learnings and best-practices along the way in a demo-rich day.
After the training you will be able to:
• Better design and implement complex data models, including hybrid tables, aggregations, and combined storage modes (import, DirectQuery, dual).
• Orchestrate the end-to-end data processing, with a pipeline chain from data ingest in the data lakehouse to the incremental Power BI dataset refresh.
• Use different techniques to identify performance bottlenecks in your solutions and how to solve those (“does it fold”?).
• Implement a cost-efficient solution, that still meets the scalability demands.
You will be guided by Data Platform MVP Dave Ruijter and Power BI MVP Marc Lelijveld, both of whom bring a wealth of practical experience to the table across the entire stack of Power BI and Azure Synapse Analytics.
Data Platform MVP, FastTrack Recognized Solution Architect, Microsoft Certified Trainer, Power BI enthusiastic, public speaker and passionate for everything which transforms data into action! Working at Macaw in the Netherlands as a Data & AI consultant. What I like the most? Sharing my thoughts, experience, best-practices and enthusiasm about Microsoft data platform with others. I mostly do this in public speaking at usergroups, conferences, customer presentations and end-user training. Besides that I also have my own blog which you can find at https://data-marc.com/
Dave is a Microsoft MVP, public speaker, and consultant, helping organizations realize the full potential of the Azure Cloud & Power Platform. He brings a decade’s worth of experience to the table and is a passionate Power BI evangelist, eager to share his knowledge and experiences from the field.
Price: € 350 ex BTW
Registration: Please select “Precon – Analytics At Scale (alleen donderdag)” in the form below and press “Bestellen”.