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.
Business Intelligence Reporting Tools in SQL Server 2012
Description
9:00 Welcome and What is data visualisation? What it is not, and why is it important? What products make up the suite of SQL Server 2012 Business Intelligence stack?
09:30 Tabular Model - what is it? When is it best used? What distinguishes it from multidimensional cubes?
10:00 PowerPivot - what is it? When is it best used? What distinguishes it from multidimensional cubes? What are the new features in SQL Server 2012?
11:00 Break
11:15 Finding patterns in the data. You will learn about the process involved in finding patterns in the data, looking at some of the more well-known data visualisation examples. We will learn about: Power View, using PowerPivot and the Tabular model as a basis. We will also look at tips and tricks in optimising Tabular Models so that they can render Power View effectively.We will look at other helpful visualisations such as sparklines, bullet charts and marimekko charts.
12:30 Lunch
13:30 Further Data Visualisations. In this section, you will learn about visualisations and how they are best used. This includes bullet charts, and other visualisations based on Tufte's "small multiples" such as sparklines. We will learn:
- We will look at PerformancePoint, and how we can use PowerPivot as a basis and 'gotchas' in using PowerPivot as a basis for PerformancePoint - We will look at Excel Services, and how we can provision self-service using the Tabular Model and PowerPivot as the basis for Excel and Excel Services
15:00 Multivariate statistical data. In this section, we will cover the complexities of displaying multivariate data since is potentially more complex. Here, we look at ways of displaying multivariate data such as table lenses and crosstab arrangements of Tufte's 'small multiples'. We will use Reporting Services as a technology to surface multi-dimensional data.
15:15 Break
16:15 Dashboards - Putting it all together. We will look at different ways of implementing Dashboards, KPIs and other visualisations. This will involve a range of technologies, from KPIs in PowerPivot, to the new features in Power View.
17:30 Close
09:30 Tabular Model - what is it? When is it best used? What distinguishes it from multidimensional cubes?
10:00 PowerPivot - what is it? When is it best used? What distinguishes it from multidimensional cubes? What are the new features in SQL Server 2012?
11:00 Break
11:15 Finding patterns in the data. You will learn about the process involved in finding patterns in the data, looking at some of the more well-known data visualisation examples. We will learn about: Power View, using PowerPivot and the Tabular model as a basis. We will also look at tips and tricks in optimising Tabular Models so that they can render Power View effectively.We will look at other helpful visualisations such as sparklines, bullet charts and marimekko charts.
12:30 Lunch
13:30 Further Data Visualisations. In this section, you will learn about visualisations and how they are best used. This includes bullet charts, and other visualisations based on Tufte's "small multiples" such as sparklines. We will learn:
- We will look at PerformancePoint, and how we can use PowerPivot as a basis and 'gotchas' in using PowerPivot as a basis for PerformancePoint - We will look at Excel Services, and how we can provision self-service using the Tabular Model and PowerPivot as the basis for Excel and Excel Services
15:00 Multivariate statistical data. In this section, we will cover the complexities of displaying multivariate data since is potentially more complex. Here, we look at ways of displaying multivariate data such as table lenses and crosstab arrangements of Tufte's 'small multiples'. We will use Reporting Services as a technology to surface multi-dimensional data.
15:15 Break
16:15 Dashboards - Putting it all together. We will look at different ways of implementing Dashboards, KPIs and other visualisations. This will involve a range of technologies, from KPIs in PowerPivot, to the new features in Power View.
17:30 Close
Learning Objectives
Previous Experience
Tech Covered
SSRS, Power Pivot