Op vrijdag 5 april, de vrijdag voor de SQL Zaterdag organiseren we ditmaal 2 pre-conference trainingen van een hele dag bij hotel Mitland in Utrecht.
We kunnen dit helaas niet kostenloos aanbieden maar met een prijs van 249,- Euro, of zelfs 199,- als je gebruik maakt van de Early Bird korting, zijn we er van overtuigd dat we erg veel waar voor je geld bieden.
(De Early Bird prijs is beschikbaar tot en met zondag 10 maart!)
De vorige keer was de pre-con vrij snel volgeboekt, nog binnen de pre-con periode. Wees er dus snel bij.
We hebben 40 plaatsen per pre-con.
Aanmelden kan heel simpel door het onderstaande formulier in te vullen, wij nemen vervolgens via de mail contact met je op om de details kort te sluiten
(En we sturen je vervolgens een factuur per mail)
Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 – 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008. Klaus is also a Microsoft Certified Master.
Execution Plans & Plan Caching in SQL Server
Do you know SQL Server Execution Plans? Yes! – and can you read/analyze them? No… For the beginner it is not very easy to understand and explain Execution Plans generated by SQL Server for your queries. Therefore this precon gives you a good overview and understanding about SQL Server Execution Plans and how you can read them without reading through complete books. You will see the basic constructs of an Execution Plan, and how SQL Server uses them to translate your SQL based query to an internal format which is executed by the Execution Engine of SQL Server.
After we have laid out the foundation of Execution Plans, we move into the Plan Cache – the memory area in SQL Server where generated Execution Plans are cached. The Plan Cache is the most powerful concept in SQL Server. But on the other hand it’s also the most dangerous thing that can lead to queries that are executed with a completely wrong Execution Plan. During this precon we will have a more detailed look into the Plan Cache of SQL Server, in which different ways SQL Server can cache Execution Plans in the Plan Cache, and how you can troubleshooting wrong performing queries directly from the Plan Cache.
Jennifer Stirrup is a newly-awarded SQL Server MVP. She is an independent consultant who specialises in Business Intelligence, with a focus on Data Visualisation. Jen has conducted projects in the UK and mainland Europe. Jen has previously spoken at SQLBits, SQLPASS and other community events on the topic of Business Intelligence and Data Visualisation. She blogs regularly on these topics at www.jenstirrup.com and can be found tweeting at http://twitter.com/jenstirrup
Business Intelligence Reporting Tools in SQL Server 2012 by Jen Stirrup
Using the new SQL Server 2012 Tabular Model and PowerPivot as data sources, this course will aim to teach about the new self-service Business Intelligence features in SQL Server 2012 whilst focusing on data visualisation. This session is aimed at developers who want to make informed data visualisation decisions about reporting, with supporting cognitive psychology theory where relevant. We will focus on:
* Finding patterns in the data.
* Further Data Visualisations – Stephen Few’s bullet charts and Tufte’s Sparklines in SSRS.
* The complexities of displaying multivariate data.
* Putting it all together: Dashboards
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: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.
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.
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.