The Agenda
Agenda HomeSQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
Intelligence and Analytics
Analytics at scale with Power BI and Azure Synapse
Description
To really understand what this session is about, I want you to get to know these 2 personas!
» Meet Marc: over the years he has developed a self-service Power BI solution that is now being used by dozens of people! But his solution is in trouble... The business is asking him to load data from various APIs. And, they want him to store historical data in Power BI for trend analysis! ... How can he do this?
» Meet Dave: his data lakehouse solution in Azure Synapse Analytics is vital for multiple decision making processes. But his solution is in trouble... the Power BI reports on top of it can't seem to handle the volume of data, and at the same time the business is asking for near real-time data! ... What can he do?
Marc & Dave need to work together and combine their expertise to solve their challenges! Interested in the end result? Then you are the right audience for this session, come join us!
We will train you how to design and build a solution that will span both Power BI and Azure Synapse Analytics. We will help you to get the best out of both worlds, sharing 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.
Feedback link https://sqlb.it/?6199
» Meet Marc: over the years he has developed a self-service Power BI solution that is now being used by dozens of people! But his solution is in trouble... The business is asking him to load data from various APIs. And, they want him to store historical data in Power BI for trend analysis! ... How can he do this?
» Meet Dave: his data lakehouse solution in Azure Synapse Analytics is vital for multiple decision making processes. But his solution is in trouble... the Power BI reports on top of it can't seem to handle the volume of data, and at the same time the business is asking for near real-time data! ... What can he do?
Marc & Dave need to work together and combine their expertise to solve their challenges! Interested in the end result? Then you are the right audience for this session, come join us!
We will train you how to design and build a solution that will span both Power BI and Azure Synapse Analytics. We will help you to get the best out of both worlds, sharing 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.
Feedback link https://sqlb.it/?6199
Learning Objectives
Previous Experience
Tech Covered
Azure, Synapse Analytics, Power BI, Data Lake, Modern Analytics, Data transformation and integration, Intelligence and Analytics, Managing Big Data, NoCode Data Engineer, Visualising and Actioning Data, Developing, Managing, Monitoring, Modelling, Optimising