New Data Visualization Techniques With MS SQL Server

New Data Visualization Techniques With MS SQL Server Name: Marie Wessels 2008 RS Title: Consultant Company: 3 fifteen Session Code: BIN 309

Session Objectives How to author reports in Microsoft SQL Server Reporting Services 2008 (SSRS) How to take advantage of new chart types & features. How to use the gauge data region. Data visualization as stand along and tablix Query MS SQL Server Analysis Services 2008 KPIs Built reports with sparklines & bullet graphs Upgrading Reports from SSRS 2005

Integrated End-To-End BI Offering DELIVERY Share. Point Server Reports Excel Dashboards Workbooks Analytic Views Scorecards Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS Excel Performance. Point Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services

The Value Of Data Visualization Good Data Visualization. . . Shows the data Represents large quantities of data coherently and efficiently Helps the user to discern relationships in the data Encourages the eye to compare different pieces of data Does not distort what the data has to say Source: Tufte, E. R. (2001). The Visual Display of Quantitative Information. Graphics Press.

The Value Of Data Visualization

Chart Types In SSRS 2008 Column (3 -D), Stacked (3 -D), 100% Stacked (3 -D), Clustered (3 -D), Cylinder (3 -D) , Stacked Cylinder (3 -D), 100% Stacked Cylinder (3 -D), Clustered Cylinder (3 -D) Line (3 -D), Smooth Line, Stepped Line, Line with Markers, Smooth Line with Markers Shape Pie (3 -D), Exploded Pie (3 -D), Doughnut, Exploded Doughnut, Funnel (3 -D), Pyramid (3 -D) Bar, Stacked (3 -D), 100% Stacked (3 -D), Clustered (3 -D), Stacked Horizontal Cylinder (3 -D), Stacked 100% Horizontal Cylinder (3 -D), Clustered Horizontal Cylinder (3 -D) Scatter Bubble Polar, Radar (3 -D) Pareto Histograms Area (3 -D), Smooth Area (3 -D), Stacked, 100% Stacked (3 -D) Range Smooth, Range Column, Range Bar, Stock, Candlestick, Error Bar, Boxplot CHART TYPES IN YELLOW ARE NEW TO SQL SERVER REPORTING SERVICES 2008

New Chart Features Multiple titles (can be expression based!) Multiple legends Tooltips on data points Multiple chart areas Secondary axis Custom palettes Calculated series Mean, moving average, Bollinger Bands, standard deviation, plus more Scale breaks

Chart Examples Frame Effects Scale Breaks Drawing Styles

Chart Examples Multiple Legends Calculated Series Striplines Multiple Chart Areas

demo Data Visualization – a few examples Name: Marie Wessels Title: Consultant Company: 3 fifteen

Charts Beyond Property Pages Pareto & Histograms Smart. Label settings Custom attributes Pie charts Call out lables, collected pie slices, additional label settings Bar & Column Charts Drawing Effects Empty point value rules Chart area custom positioning Inner Plot Area

Introducing Gauge is a new data region in SSRS 2008 Two main gauge types Radial and Linear Scenarios Typically bound to a single or a few data points (value, target, goal, etc. ) Perfect for KPIs

Introducing Gauge

Gauge Parts Gauge Panel Scale Ranges Pointer Frame

Gauge Types Meter Horizontal

Gauge Types Thermometers

demo Gauge, Sparklines & Bullet Graphs Name: Marie Wessels Title: Consultant Company: 3 fifteen

Sparklines & Bullet Graphs

Upgrade from SSRS 2005 Background 2008 report designers author 2008 RDL. The level of upgrade is the report Upgrade occurs in memory in the 2008 designer; a copy of the 2005 Report is saved locally SSRS 2008 Server can render SSRS 2005 reports (including 2005 custom report items)

Upgrade from SSRS 2005 Data Visualization Reports with SSRS 2005 charts (w/o Dundas) SSRS 2008 reports w/native charts Reports with Dundas Charts and/or Gauge CRI SSRS 2008 Reports w/native charts Reports with Dundas exclusive features Multiple options Upgrade to Dundas 2008 custom report items Keep report in SSRS 2005 format Convert to a native SSRS 2008 report and drop exclusive features

Additional Features Available With Dundas Custom Report Items Chart Annotations Custom code Custom Legend Items Time Series and Forecasting Formulas Gauge Numeric and State Indicators Custom code Images Map and Calendar

question & answer

Resources Tech·Ed Africa 2009 sessions will be made available for download the week after the event from: www. tech-ed. co. za www. microsoft. com/teched www. microsoft. com/learning International Content & Community Microsoft Certification & Training Resources http: //microsoft. com/technet http: //microsoft. com/msdn Resources for IT Professionals Resources for Developers

Related Content BIN 206: Upgrading DTS Packages to Microsoft SQL Server Integration Services DAT 309: Microsoft SQL Server 2008 Data Warehousing by Demonstration

Track Resources http: //www. youtube. com/watch? v=Yf. Up 4 pb 2 R 7 Y http: //www. microsoft. com/sqlserver/2008/en/us/reporting. aspx http: //www. devx. com/codemag/Article/39004

10 pairs of MP 3 sunglasses to be won Complete a session evaluation and enter to win!

© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U. S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.