welcome
Download
Skip this Video
Download Presentation
Welcome

Loading in 2 Seconds...

play fullscreen
1 / 15

Welcome - PowerPoint PPT Presentation


  • 118 Views
  • Uploaded on

Welcome. What's New in Reporting Services and introducing to Power View November 2012 Meinrad Weiss. 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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Welcome' - taite


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
welcome

Welcome

What's New in Reporting Services and introducing to Power View

November 2012Meinrad Weiss

Highlights SQL Server 2012: Reporting Services and Power View

introduction
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

authoring reports many types of visualizations
Authoring Reports Many types of visualizations

Highlights SQL Server 2012: Reporting Services and Power View

hichert success rules
Hichert Success Rules

Highlights SQL Server 2012: Reporting Services and Power View

data alerts
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

data alerts1
Data Alerts

Highlights SQL Server 2012: Reporting Services and Power View

self service alerting how it works
Self-Service Alerting – How it works

Highlights SQL Server 2012: Reporting Services and Power View

power view
POWER VIEW

Highlights SQL Server 2012: Reporting Services and Power View

introduction1
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

power view1
POWER VIEW

Highlights SQL Server 2012: Reporting Services and Power View

power view2
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

power view3
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

power view4
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

tabular bi semantic model optimization
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

let s go
Wettbewerb

Let‘sgo.

Highlights SQL Server 2012: Reporting Services and Power View

ad