SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
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