1. complete and integrated bi and performance management offering complete and integrated bi and...
TRANSCRIPT
Tom CaseyGeneral ManagerMicrosoft SQL [email protected]
1
Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions
Complete and integrated BI and Performance Management offering
Widespread delivery of business intelligence through Microsoft Office
Enterprise grade and affordable
Microsoft Business Intelligence
2
People Ready Insights
End UserReal-time insightFamiliar toolsDecisions at all levels
IT ProfessionalSecure
ReliableManageable
Pervasive Insight
DeveloperEmbedded BICommon ToolsConsistent practices
3
Integrated and Agile BI Offering
END USER TOOLS & PERFORMANCE MANAGEMENT APPS
ExcelPerformancePoint
Server
BI PLATFORM
SQL Server Reporting Services
SQL Server Analysis Services
SQL Server DBMS
SQL Server Integration Services
SharePoint Server
DELIVERY
Reports Dashboards Excel Workbooks
AnalyticViews Scorecards Plans
4
END USER TOOLS & PERFORMANCE MANAGEMENT APPS
ExcelPerformancePoint
Server
BI PLATFORM
SQL Server Reporting Services
SQL Server Analysis Services
SQL Server DBMS
SQL Server Integration Services
SharePoint Server
DELIVERY
Reports Dashboards Excel Workbooks
AnalyticViews Scorecards Plans
Integrated and Agile BI Offering
5
Microsoft SQL Server 2005 Solution Architecture : Using Analysis Services with Teradatao Extend the reach of Teradata solutions to more users through collaboration on
optimized SQL Server Analysis Services adapter and cartridge for Teradata.
BI PLATFORM
SQL Server DBMS
SQL Server Integration Services
PERFORMANCE MANAGEMENT & COLLABORATION
SharePoint Server
CLIENT
Reports Dashboards Excel Workbooks
AnalyticViews Scorecards Plans
PerformancePoint Server
SQL Server Analysis Services
• ADO.NET or OLE-DB Provider for Teradata
• SQL Server Analysis Services cartridge for Teradata helps translate MDX expressions for MOLAP and ROLAP access to Teradata
• SQL Server Analysis Services enables direct and seamless integration for content delivery and navigation using familiar tools
• Make use of Reporting Services and Excel via Analysis Services integration
.NET Data Provider SQL Server Reporting Services
6
Analyze information with powerful and familiar tools– New Office Excel Pivot Tables for analyzing information using business terms– Tight integration between Office Excel and Microsoft SQL Server Analysis
Services– Data Mining add-ins for advanced analysis and new visualization capabilities
Enabling end-users with ad hoc reporting capabilities– Report Builder for ad hoc reporting of relational or OLAP data– Microsoft SQL Server Reporting Services for personalized
views of management data
Share reports and analysis over the web– Excel Services for web based viewing of analysis– Scorecards and dashboards for quickly
disseminating information– Report Center in SharePoint for centralized report management
Analysis and ReportingBroad reach tools for insight
7
Office Excel 2007New powerful analysis tools for your data
Conditional Formatting
Spot trends and exceptions in your data to better inform your decisions
Data Connection Library
Quickly access the most common data sources in your enterprise for data analysis
Rich Interactivity
Analyze data with new PivotTable tools and enhanced support for SQL Server Analysis Services
Excel Services
Enhanced Sorting and FilteringSort by cell color or filter data by quarter to work with only the data you need
8
Report Authoring
Visually design reports & layout via the Report Designer
Report Management
Manage report categorization, data sources, security, subscriptions via the Report Manager
End user report creation
Enable end users to create their own Ad-hoc reports via the Report Builder
Model design
Design semantic models that map to real business entities via the Model Designer
SQL Server 2005 Reporting ServicesPresentation Quality Enterprise Reporting
9
SQL Server 2005 Analysis Services
SQL Sever 2005 Analysis Services Architecture Overview
10
Visual Studio 2005
SQL Server 2005Management
Studio
Multi-dimensional (MDX) Engine
Data Mining (DMX) Engine
Storage Engine
KPI Engine
MOLAP
Analy
sis Serv
ices
Managem
ent O
bje
cts
XM
L for A
naly
sis (XM
L/A)
UNIFIED DIMENSIONAL MODEL
ROLAP HOLAP
Local cube
Teradata .NET Provider
CartridgeCartridge
CartridgeCartridge
Driv
er
XM
L/A || O
DB
O
DDL XML/A (MDX)
Microsoft SQL Server
Client applications
Developer &
Admin Tools
Performance ManagementIntegrated solution to align and measure the business
Improve corporate performance– Scorecards to orient measurement to corporate goals– Single model to align planning and analysis to the business process– Span the organization with planning and measurement capabilities
Accelerate management decision making– Office Performance Point Server to integrate scorecarding, analysis and
planning– Integrated workflow for simpler consolidation and reporting – Common model for planning used in analysis
Enable collaborative analysis– Integration with Office Excel for broad deployment
of analysis capabilities– Personalized scorecards and KPIs for individual views– Collaborative environment with context for analysis
11
Planning & Budgeting
Plan, budget, forecast at corporate, divisional, and operational levels with visual modeling,
Office PerformancePoint Server 2007An Integrated Performance Management Solution
Scorecards
Cascading scorecards with interactive charts and data from multiple sources
Analytics
Multi-dimensional slice and dice for advanced analytics including decomposition tree, performance map, and perspective view
Consolidation & Reporting
Multiple GL data integration including pre-built integration with Dynamics AX, intercompany eliminations , reconciliations, multiple currency translations, and report wizards.
12
Futures: Improved Data IntegrationSolution Architecture : Integration Services for Teradatao Cost effective and efficient integration for TERADATA via high performance
load/unload through collaboration on optimized SQL Server Integration Services Adapter for Teradata
BI PLATFORM
SQL Server DBMS
SQL Server Integration Services
PERFORMANCE MANAGEMENT & COLLABORATION
SharePoint Server
CLIENT
Reports Dashboards Excel Workbooks
AnalyticViews Scorecards Plans
PerformancePoint Server
SQL Server Analysis Services
• Availability & release vehicle TBD
• New provider using Teradata’s high performance interfaces for use with SQL Server Integration Services and Teradata
• Support for Load and Unload using TPT
• SSIS (ETL) tools integration to make connectivity easier, lower cost of integration
New SSIS Adapter
SQL Server Reporting Services
13
Futures: Improved ReportingSolution Architecture : Using Reporting Services with Teradatao Extend the reach of Teradata solutions to more users through collaboration on
optimized SQL Server Reporting Services provider for Teradata.
BI PLATFORM
SQL Server DBMS
SQL Server Integration Services
PERFORMANCE MANAGEMENT & COLLABORATION
SharePoint Server
CLIENT
Reports Dashboards Excel Workbooks
AnalyticViews Scorecards Plans
PerformancePoint Server
SQL Server Analysis Services
• Availability & release vehicle TBD
• SQL Server Reporting Services options to connect to and translate semantics for query access to Teradata
• SQL Server Reporting Services enables direct and seamless integration for content delivery and collaboration using familiar tools
.NET Provider for TeradataSQL Server Reporting Services
14
People Ready Partnership
End UserReal-time insightFamiliar toolsDecisions at all levels
IT ProfessionalSecure
AvailableManageable
DeveloperEmbedded BICommon ToolsConsistent practices
• History of innovation & partnership
• Shared goals to bring insights to all employees
• Take advantage of better integration today!
15
© 2007 Microsoft Corporation. All rights reserved.This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
16