Welcome

1. Welcome What's New in Reporting Services and introducing to Power View November 2012Meinrad Weiss Highlights SQL Server 2012: Reporting Services and Power View

2. INTRODUCTION • Reporting Services (SSRS) in SQL Server 2012 has been upgraded with new features and capabilities: • Empower users with a new visual design experience named Power View • Increase productivity with user-defined data alerts • Increase performance and improve administration within SharePoint • Excel renderer for Excel 2007-2010 • Word renderer for Word 2007-2010 • Designers have been upgraded for SQL Server Data Tools (Visual Studio 2010) Highlights SQL Server 2012: Reporting Services and Power View

3. Authoring Reports Many types of visualizations Highlights SQL Server 2012: Reporting Services and Power View

4. Hichert Success Rules Highlights SQL Server 2012: Reporting Services and Power View

5. DATA ALERTS • Data alerts can be defined on report feed(s) • Intuitive alert rules based on conditions (AND and OR) • Scheduling settings • Advanced: • Start/End dates • Send message only if results change checkbox • Email address(es), Subject and Description • Can only be based on reports that use data sources with stored credentials • Alerts can be managed by users and administrators • View status, Edit, Delete, Run • Only available with SSRS in SharePoint integrated mode • Available with SharePoint Foundation or above Highlights SQL Server 2012: Reporting Services and Power View

6. Data Alerts Highlights SQL Server 2012: Reporting Services and Power View

7. Self-Service Alerting – How it works Highlights SQL Server 2012: Reporting Services and Power View

8. POWER VIEW Highlights SQL Server 2012: Reporting Services and Power View

9. INTRODUCTION • Power View is an interactive data exploration, visualization, and presentation experience • Highly visual design experience • Rich meta-driven interactivity • Presentation-ready at all times • Provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers • Ordinarily, a Power View report needs to be based on a tabular BI Semantic Model that has been optimized for the report authoring tool Highlights SQL Server 2012: Reporting Services and Power View

10. POWER VIEW Highlights SQL Server 2012: Reporting Services and Power View

11. POWER VIEW • Server(s): • SharePoint Server 2010 SP1 Enterprise Edition • SQL Server 2012 Reporting Services Add-in for SharePoint • Client: • Supported browsers: • Windows Vista: IE7 32-bit, FireFox 4 • Windows 7: IE8 32-bit, IE9 32-bit, FireFox 4, Safari • Note the InPrivate browsing feature of IE is not supported • Silverlight 5 Highlights SQL Server 2012: Reporting Services and Power View

12. POWER VIEW • A Power View report must be based on a deployed tabular BI Semantic Model: • Published PowerPivot workbook in a SharePoint library • Tabular database • DAX Query is used to query the model • Ordinarily, the model needs to be optimized for the Power View experience Highlights SQL Server 2012: Reporting Services and Power View

13. POWER VIEW • Users create a new Power View report (.rdlx) from: • A BISM Connection File (.bism) • A PowerPivot workbook (.xlsx) in the PowerPivot Gallery (in Gallery view) • An SSRS shared data source (.rsds) based on a tabular BI Semantic Model • Reports can consist of multiple views and each view can be filtered • Reports may be: • Printed • Saved to SharePoint libraries • Exported to PowerPoint • Clicking the report will open it in Preview mode • If the user has permission, they can switch to Edit mode Highlights SQL Server 2012: Reporting Services and Power View

14. Tabular BI Semantic Model Optimization • Reporting properties can also be configured • The properties apply to tables and columns Highlights SQL Server 2012: Reporting Services and Power View

15. Wettbewerb Let‘sgo. Highlights SQL Server 2012: Reporting Services and Power View