SQL Server 2012 Crescent: BI Candy or BI Core? – Russ Blake
SQL Server 2012 introduces Crescent for data visualization and exploration. Crescent, recently renamed Power View, employs an innovative UX with no context menus and at most two clicks to visualize a change. It’s built on top of a Tabular Analysis Services database instead of the traditional Multidimensional Cube. So without all the great features of the Cube developed over the past 15 years, can it really be a core tool for information workers, or is it just another way for Microsoft to demo SharePoint? To help us decide, we’ll demonstrate how to construct a Tabular database, import the data, and examine how to modify its metadata to support Power View. We’ll take a look at constructing measures and computed columns, and then see how to use Power View to expose and explore the Tabular data in SharePoint. We’ll examine the Power View UI, and show how to use it to quickly build dynamic BI dashboards. We’ll show how to explore data with entrancing features like time animation charts and the visual index cards. By the end of this talk you will be much closer to deciding: BI candy or BI core?
About the Presenter
Russ Blake is the inventor/author of the Windows Performance Monitor (Perfmon), and author of the book “Optimizing Windows NT”. Prior to settling in Brisbane, Russ worked at Microsoft for 8 years, and was a Senior Researcher in Microsoft Research. He holds three US patents in software and one Chinese patent, and has written numerous technical articles. Russ consults for Readify Pty Ltd specializing in SQL Architecture and BI solutions.
Venue: Microsoft Brisbane, Level 28/400 George Street
Duration: Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)
On: Thursday, 24th November 2011
RSVP: to email@example.com will help with catering