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.
Data Visualisation & Modelling
Power BI Report Design and Development workshop
Description
This one-day collaborative workshop will cover the various Power BI design stages learned from years of consulting and working with some of the largest enterprises. The workshop, divided into five modules, enables you to bring your end user's data to life with Power BI.
1 The Basics of Data Visualization
In this first module, you will get an introduction to data visualization and discover why telling the right story to the right audience is so important.
2 Aligning people and data
This module will teach you how to conduct workshops and gather requirements from stakeholders and end users. Then you will learn techniques to explore data and identify meaningful patterns. In the hands-on workshops, we will use sample templates to ask the right questions and convert captured requirements to use cases. By the end of this section, you will be able to determine the 5W's and How (who, what, why, where, and how) to create an optimal Power BI model.
3 Drive use cases and data patterns to drive visualizations
In this section, you will learn concepts and techniques that will assist you in identifying the right visual based on data and use cases. You will understand the most used visual categories like Key Metrics, charts, Maps etc. and then learn how to use them in Power BI to create stand-out visuals.
4 How to find the right visuals
In this section, you will learn tips and techniques to identify the right visual for the right audience and their use cases. The section also includes an exercise to find the right visuals based on your previously identified use cases.
5 Putting the story together
In this module, we will tie it all together using my top 10 techniques to create a stunning Power BI report. We will cover everything, from a blank canvas to an actionable report, and ensure it is accessible to all users. We will end the day with a final workshop to create reports based on different audiences. A ready-to-use Power BI model, personas and use cases will be provided.
1 The Basics of Data Visualization
In this first module, you will get an introduction to data visualization and discover why telling the right story to the right audience is so important.
2 Aligning people and data
This module will teach you how to conduct workshops and gather requirements from stakeholders and end users. Then you will learn techniques to explore data and identify meaningful patterns. In the hands-on workshops, we will use sample templates to ask the right questions and convert captured requirements to use cases. By the end of this section, you will be able to determine the 5W's and How (who, what, why, where, and how) to create an optimal Power BI model.
3 Drive use cases and data patterns to drive visualizations
In this section, you will learn concepts and techniques that will assist you in identifying the right visual based on data and use cases. You will understand the most used visual categories like Key Metrics, charts, Maps etc. and then learn how to use them in Power BI to create stand-out visuals.
4 How to find the right visuals
In this section, you will learn tips and techniques to identify the right visual for the right audience and their use cases. The section also includes an exercise to find the right visuals based on your previously identified use cases.
5 Putting the story together
In this module, we will tie it all together using my top 10 techniques to create a stunning Power BI report. We will cover everything, from a blank canvas to an actionable report, and ensure it is accessible to all users. We will end the day with a final workshop to create reports based on different audiences. A ready-to-use Power BI model, personas and use cases will be provided.
Learning Objectives
What an attendee will get out of this session
By the end of the day, you will learn how to bring data to life.
In summary, an attendee will get a brief understanding of below:
Data visualisation and the importance of good data visualisation
How to explore data to identify meaningful findings
How to engage with people involved like Stakeholders and Audience
How to conduct workshops and how to create personas
How to gather requirements and convert them to use cases
How to design a Power BI model through use cases
How to find visualisation types through use cases
Ways you could visualise the most used visual categories in Power BI.
How to find the right visuals based on Data patterns and use cases
How to put a story together to communicate data visually
Previous Experience
Experience with Power BI, functionalities of Power BI and Report design
Tech Covered
Power BI, Developing, Platform Agnostic, Data Visualisation & Modelling