Business Intelligence Reporting Tools in SQL Server 2012
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.
Sorry, there are no downloads available for this session.
Jen Stirrup is an award-winning, world recognised Business Intelligence and Data Visualisation expert, author, data strategist, MVP, and technical community advocate who is repeatedly honoured with peer recognition as one of the top 100 most global influential tweeters on Big Data topics. Jen has over 16 years experience in delivering BI and dataviz projects for companies of various sizes around the world.
Jen is an elected member of the Board of Directors for the Professional Association of SQL Server, holding the seat for Europe and holder of the Virtual Chapters portfolio worldwide. Jen has presented at TechEd North America and Europe, Summit, SQLBits, as well as at SQLSaturday and other SQL events in the UK, in the US and on many occasions across Europe such as Hungary, France, Belgium, Germany, Portugal, Poland, Sweden, Norway, Switzerland, Ireland, Denmark, Bulgaria, Austria and the Netherlands. Therefore she works hard! She has proven evidence of being extremely involved in the SQL Community across the UK, Europe and the US, and has been for a number of years now.
She has also presented preconference sessions in Microsoft Business Intelligence and Data Visualisation for SQLPass, SQLSummit and at various countries around Europe. When she is not working for the SQLFamily, Jen jointly runs a Copper Blue Consulting based in Hertfordshire with Allan Mitchell, where they helps business leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investment both here in the UK, Europe and the US, and more recently in Africa. Jen has also won awards for her blog and community work, most notably from SQLServiaPedia as runner-up for best Business Intelligence blog. She is a former Awardee of PASS's prestigious PASSion Award in 2012.
The video is not available to view online.