SQL Server und SharePoint

1
SQL Server und SharePoint
Event vom 04.04.2006 in Aarau

• Business Intelligence

Referent Werner Durrer
2
Inhalt

• Microsoft Business Intelligence Infrastruktur
  und Anwendung
• SQL Server 2005 Analysis Services
• Architektur
• Demo
• SQL Server 2005 Reporting Services
• Architektur
• Demo
• Business Scorecard Manager
• Architektur
• Demo
• Beispiele

3
Analysis Services
Back to navigation slide
4
Business AnalysisAnalyze Your Business From
Every Angle

• Powerful, ubiquitous analysis tools using Office
• Excel for interactive query and analysis
• Collaborative analysis and decision making via
  SharePoint
• In-depth Web-based ad-hoc analysis using OWC
• Robust analytical engine
• 1 OLAP engine on the market
• Powerful data mining
• Enterprise Scalability
• Build and manage large multidimensional cubes
• 128 dimensions w/cross dimensional analysis
• 10 million MOLAP, 100s of million ROLAP members

Back to navigation slide
5
Business AnalysisTechnical Highlights

• Flexible architecture
• MOLAP
• ROLAP
• HOLAP
• Powerful analytic
• Star, snowflake, parent-child dimensions
• Complex yet performing aggregation
• Min, Max, SUM, Count, Distinct count
• MDX Express business logics Dimensionally
• Enterprise Scalability
• Data Partitioning
• Build and manage large multidimensional cubes
• 128 dimensions w/ cross dimensional analysis
• 10million MOLAP, 100s of million ROLAP members

Back to navigation slide
6
Analysis Services Architecture
Analysis Services
OLEDB for OLAP
PivotTable Service
OLAPServer
OLAPStore
7
SQL Server 2005 Analysis Services
8
Real-Time Reporting
Back to navigation slide
9
Enterprise Reporting

• Comprehensive enterprise reporting solution
• Author, manage, and deliver paper and
  interactive, Webbased reports
• Embed reporting functionality into LOB
  applications and business processes
• Reduce IT reporting burden
• Reduce report creation cycle times with
  refreshable, dynamic reports
• Publish scheduled and on-demand reporting
• Empower end users with flexible, familiar report
  layouts
• Excel full client or Office Web Components
• Dynamically publish reports to your intranet via
  Sharepoint Portal Server

Back to navigation slide
10
Enterprise ReportingTechnical Highlights

• Authoring Report Designer
• Integrated with VS.NET
• Based on industry standard RDL
• Pull heterogeneous data into a single report
• Managing Report Manager
• Web-based interface for scheduling, definitions,
  folders, resources
• Role and user based permissions for sensitive
  reports
• Delivery Report Server
• Multi-threaded parallel processing for complex
  reports
• Publication of single report in multiple formats
  using Web services
• Deliver based on schedule, event, or on demand

Back to navigation slide
11
Reporting Services Architecture
Custom Application
Browser
Office
Web UI
Security Services(NT, Passport, Custom)
Data Sources(SQL, OLE DB, XML/A, ODBC, Oracle,
Custom)
XML Web Service Interface
Report Server
Report Processing
Security
Data Processing
Scheduling and Delivery
Rendering
Delivery Targets(E-mail, SharePoint,Custom)
Output Formats (HTML, Excel, PDF, Custom)
SQL Server Catalog
Back to navigation slide
12
SQL Server 2005 Reporting Services
13
Performance Management
Back to navigation slide
14
Performance Management

• Web-based metrics management solution
• Provides unified view of your business
• Aligns strategy execution to business objectives
• Supports entire scorecard lifecycle
• From scorecard definition to strategy
  visualization
• Automates the management of scorecards
• Customizable to your specific business needs
• Embed scorecarding functionality into LOB
  applications

Back to navigation slide
15
Business Scorecards AcceleratorTechnical
Highlights

• Design
• Easily define and re-use Key Performance
  Indicators (KPIs)
• XML foundation and native support for OLAP cubes
• Manage
• Automate the management of multiple scorecards
• Easily customize scorecard views by role or
  function
• Deliver
• Fully integrated with Office and SharePoint
• Use Web services to support end user formats

Back to navigation slide
16
Business Scorecard Manager Architecture
StrategyMapBuilder
DataSources Editor
Scorecard Builder
Scorecard and Viewer Webparts
ScorecardBuilder
ScorecardsSharePoint Experience
Webparts provide rich, integrated analysis
experience leveraging key Microsoft technologies
Scorecards are created in a business user-focused
WinForms UI
Scorecard Application
Engine natively supports multiple data sources
Data-driven alerts available out-of-the-box
ScorecardMetadata DB
Metadata schema offers extensible KPI and
scorecard definitions
Scorecard Cubes
Source Systems
17
Microsoft Business Scorecard Manager
18
Die Elemente einer BSC
19
Core BenefitsDeep contextual insight
Benefits (Beispiele) Deep contextual insight

• Rapidly display and share scorecards on Web pages
• Gain immediate access to analysis and
  unstructured data functionality
• Drill down through KPIs for deeper transactional
  insight
• Get all-on-one-page interaction

Charting and Analysis
Scorecard
Report
Documents Spreadsheets
MapPoint / Visio / OWC / Reporting Services
Integration
20
Core BenefitsCollaborative group analysis and
action
Benefits (Beispiele) Collaborative group
analysis and action

• Enhance group analysis and collaboration
• Communicate in context
• Integrate with Microsoft Office platform
• Create customized scorecards and views
• Shorten response times with data-driven alerts
• Distribute easily to multiple formats

Cell-level annotations
21
Core BenefitsEnd-user empowerment
Benefits (Beispiele) End-user empowerment

• Business analysts
• Build, manage, and consume KPIs and scorecards
• Build comprehensive views
• Use scorecards and dashboards for decision making
  and prioritization
• End users
• Add/change personal scorecard views
• Leverage existing Microsoft Office skills
• Use scorecards and dashboards for decision making
  and prioritization

IntuitiveApplication
OWCIntegration
22
Core BenefitsExtensible platform
Benefits (Beispiele) Extensible platform

• Enables ISV and SI customization to
• Extend functionality
• Integrate scorecards into LOB applications
• Develop an end-to-end BPM offering
• Leverages Web Services APIs and SharePoint
  platform
• Eases extension development by BI Partners
• Promotes Web service accessibility
• Employs Webpart connections
• Enhances eventing
• All events can be written to MSMQ
• Third parties can integrate custom notifications

ISV integration
23
(No Transcript)
24
SQL Server und SharePoint

• Fragen

25
Kull AG

• Kull AG
• Entfelderstrasse 2
• 5000 Aarau (Switzerland)
• Tel [phone]
• Fax [phone]
• E-Mail info_at_kull.ch
• http//www.kull.ch

• Gegründet 1972
• Tätigkeitsgebiete
• Software-Entwicklung
• Systemintegration
• CTI (Computer Telephony Integration)
• Microsoft Gold Certified Partner
• Advanced Infrastructure Solutions
• ISV/Software Solutions