I'm delighted to announce that I'm holding a pre-conference one-day training in Data Visualisation in SQL Server 2012 in Cambridge on 7th September, 2012. For more details, and to register for the precon, please click here and to register for SQL Saturday 162 event, please click here.
My thanks go to SQLPass and to Mark Broadbent in particular, who have worked extremely hard in order to put on this community event. Here is an outline for my precon and please don't hesitate to get in touch if you have any other queries!
10:30 PowerPivot - what is it? When is it best used? What distinguishes it from multidimensional cubes? What are the new features in SQL Server 2012?
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.
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.