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.
The Data Analysts Toolkit: Microsoft Power BI & R
Description
The takeaways will focus on:
Module 1: Introduction to Data Visualisation and Dashboarding Theory
In this module, we will look at an overview of theory and scientific evidence about data visualisation. Understanding the 'why' can help to make us better at the 'how', regardless of the technology.We will also look at an overview of the Power BI suite of tools.
Module 2: Introduction to R for Business Analysis
In this module, we will look at an overview of R for business analysis and data analysis. We will look at its most commonly used features for implementing statistical and data analysis.
Module 3: The Big Picture: Putting Microsoft Power BI and R together
Delegates will have different degrees of experience with different tools, so it is important to paint broad brush strokes to show off the technology working together. We will look at the following technologies in an end-to-end environment:
R
Power Pivot
Power Query
Power View
Excel
Module 4: Further Data Visualisations
Learn about visualisations in accordance to theory and practice put forward by gurus such as Stephen Few and Edward Tufte. We will cover the complexities of displaying multivariate data since is potentially more complex by visualisations.
Module 5: Putting it all together - Dashboards
We will look at creating dashboards in Power View and Excel.To summarise, this precon aims to deliver a breadth of data visualisation knowledge, underpinned by cognitive psychology theory to provide deeper understanding of data visualisation, translated into Microsoft Power BI functionality.
Module 1: Introduction to Data Visualisation and Dashboarding Theory
In this module, we will look at an overview of theory and scientific evidence about data visualisation. Understanding the 'why' can help to make us better at the 'how', regardless of the technology.We will also look at an overview of the Power BI suite of tools.
Module 2: Introduction to R for Business Analysis
In this module, we will look at an overview of R for business analysis and data analysis. We will look at its most commonly used features for implementing statistical and data analysis.
Module 3: The Big Picture: Putting Microsoft Power BI and R together
Delegates will have different degrees of experience with different tools, so it is important to paint broad brush strokes to show off the technology working together. We will look at the following technologies in an end-to-end environment:
R
Power Pivot
Power Query
Power View
Excel
Module 4: Further Data Visualisations
Learn about visualisations in accordance to theory and practice put forward by gurus such as Stephen Few and Edward Tufte. We will cover the complexities of displaying multivariate data since is potentially more complex by visualisations.
Module 5: Putting it all together - Dashboards
We will look at creating dashboards in Power View and Excel.To summarise, this precon aims to deliver a breadth of data visualisation knowledge, underpinned by cognitive psychology theory to provide deeper understanding of data visualisation, translated into Microsoft Power BI functionality.
Learning Objectives
Previous Experience
Tech Covered
BI, Power BI, R