1 / 25

SQL Server 2008 R2 REPORTING SERVICES

SQL Server 2008 R2 REPORTING SERVICES. SQL Bits Goes West. +. Empowering end users through “Managed Self-Service BI”. End User Empowerment. IT Management & Compliance. “Managed Self Service BI” delivered through: Self Service Analysis  Desktop Analytics

gay
Download Presentation

SQL Server 2008 R2 REPORTING SERVICES

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server 2008 R2REPORTING SERVICES SQL Bits Goes West http://blogs.technet.com/andrew @DeepFAT on TWitter

  2. + Empowering end users through “Managed Self-Service BI” End User Empowerment IT Management & Compliance • “Managed Self Service BI” delivered through: • Self Service Analysis  Desktop Analytics • Self Service Reporting  End User Reporting • SharePoint Integration  Sharing, Collaboration & Management

  3. Self Service Report Authoring • Empowering IT • Deploy managed, shared report components • Publish and share visualizations • Expose data sets for reuse • Leverage existing investments in report design • Enabling end users • New getting started experience • Reuse existing components and data sets • Design reports is as simple as “Grab & Go”

  4. Self Service Reporting

  5. Reports as Data Feeds • Data regions in reports are standards-compliant data feeds • With PowerPivot, IW can consume all the operational, corporate reports for their analysis. • Reports as the primary data source for information worker analysis • IT provisioned. Secure, well-defined, optionally pre-cached • Build SSRS reports on top of Information Worker analysis models

  6. Enhanced Data Visualization • Layout • Tables, Matrices or any combination of it… • Parallel Groupings • Asymetrical columns/rows • Mix dynamics/static items • Visualizations • Charts, Pyramids, Pie, Donuts, Gauges, Maps, Sparklines, Data bars, Indicators...

  7. Building ReportsMany types of visualizations

  8. Building ReportsMany types of layouts Custom Subtotals Non-pivot columns Custom Headers Pivot Multi-Pivot Stepped or Block grouping Nested controls

  9. Tablix Visualizations: Sparklines and Data Bars • Sparklines • “Data intense, word-sized graphics” – Tufte • Automatic axis alignment. • Can be converted into full charts to support additional small multiple scenarios. • Data Bars • Usually depicts a single value in a cell. • Min and Max are automatically determined, but are configurable. Sparklines Data Bars

  10. Map Features • Support for SQL Spatial • Integration with Virtual Earth tiles • Data Grouping • Equal intervals, equal distribution, optimal, user-defined • Multiple Map layers

  11. Cool looking Data Visualization: and soon… Colored maps based on auto or user defined scales Routes, pinpoint…

  12. Report Layout enhancements • Lookup functions • Aggregate of aggregates • New Data sources: Madison, SQL Azure • Reset page number on groups • Expression-based page breaks • Excel worksheet tab naming • Session variables • Renderer-dependent layout • Bottom-to-top text rotation

  13. Enhanced Report Viewer and report Manager Experience • Refreshed viewer look and feel • Smooth and fluid navigation experience (AJAX Report Viewer) • Updated Report Manager. Workflow optimized (no need to preview report to access its properties or manage it) • Updated Report Manager look and feel: More Office 14ish

  14. Aggregates of Aggregates • Expressions now support nesting of aggregate functions • Example: Average Monthly Sales =Avg(Sum(Sales, "Month"), "Year") • Enables “visual totals” scenarios • Aggregates respect group filters

  15. Excel Renderer Worksheet Tab Naming

  16. Reset Page Number on Group • Reset page number for each new group instance. • Get current page and total page count for each group, and overall

  17. Bottom-to-Top Text Rotation New text orientation option provides more flexibility to your report layouts

  18. Renderer-based expressions • Control layout and write expressions that consider renderer format • Example, dynamically disable drillthrough expressions for non-interactive renderers and enable them for interactive ones

  19. Dynamic page breaks • Use expressions to determine what renderer is being used • Dynamically disable/enable page breaks • Example, disable page breaks if exporting to Excel. Otherwise, enable them:

  20. The Road Ahead • SQL Server 2008 available now • Innovation coming in H1 Calendar Year 2010 • SQL Server 2008 R2 • SQL Server 2008 R2 Parallel Data Warehouse • Continue to deliver innovation 24-36 months from the release of SQL Server 2008 • Next major release of SQL Server

  21. Questions

  22. Europe’s Premier Community SQL Server Conference

  23. Up and coming events.. November 2009 Tuesday 24th London – Storage and Query Optimisation - www.sqlpass.org.uk Thursday 26th London – SQL Internals and MS BI – SQLServerFAQ.com Thursday 26th London – Looking at newsgroups for Info – SQLServerFAQ.com December 2009 Thursday 3rd Online – PowerUp with SQL Server (see next slide) Tuesday 8th Cork – Query Optimisation – MTUG.ie Wednesday 9th Dublin – Query Optimisation – IrishDev.com Thursday 10th Leeds – Service Broker and Powershell – SQLServerFAQ.com Tuesday 15th Cambridge – Christmas Special down the pub – SQLSocial.com Thursday 17th Manchester – SQL Server Internals – SQLServerFAQ.com

  24. Time to Power Up with SQL Server within your organization! • Who Should Attend: • Database administrators • Application developers/programmers • Database developers • - IT Professionals responsible for SQL Server management • Sign Up Today at http://tinyurl.com/PowerUpSQLServer • During the day's presentations by SQL Server experts, Greg Low, Javier Loria, and Niels Berglund, you'll get detailed information and time to ask your questions. • Three sessions, directly from your own computer: • - Understanding Query Plan Caching in SQL Server • - SQL Server High Availability • - SQL Server Performance

  25. It’s party time! Coming up next in the Atrium: Time to relax and let your hair down. Rockband Table football Air Hockey and more Don’t forget speakers and sponsors have drinks vouchers

More Related