TechNet

1
Welcome
TechNet ????
2
??????????? Office PerformancePoint Server
2007
??? Mark Chen mark.chen_at_hp.com Consulting
Integration Service Hewlett-Packard Taiwan Ltd.
3
???? ??? Mark Chen

• ???
• ???? Consulting Integration Service ????
• ???????? (MVP)
• ??? 
• Tech - Ed 2006/2007 ??
• SQL Server 2005 ???????
• Microsoft Solution Day ? SQL Server ???????

• ??? 
• Microsoft SQL Server ????????
• ????????????????????
• ?? 
• MCTS?MCITP?MVP

4
HP BI Service ??????????
5
MS SQL Server-Specific HP BI Services

• SQL Server Database Consolidation
• Database Performance Monitoring, Analysis
  Tuning
• SQL Server 2000 to SQL Server 2005 Upgrades
• SQL Server Database engine
• Analysis/Reporting Services
• Data Transformation Services (DTS)toIntegration
  Services (IS)
• Database Migration (Oracle/SybasetoSQL Server)
• SQL Server Reporting Services
• (business requirements, design and
  implementation)

6
Agenda

• ????????
• ????????????
• ????????? - PerformancePoint Server
• Performancepoint Server ???????
• Performancepoint Server ???????
• Performancepoint Server ???????

7
????????

• ?????????????????????????????????
• ???????,?????????????????????,???????????????????,
  ?????????????????
• ?????????????????????????????,????????????????????
  ?????????

8
????????????????????????
??
??????
??
????
Strategy
??
?????? ????????
?????????,????????? Continuous business
improvement, not just an annual exercise
8
12 June 2006
9
?????????????

• (1)?????????
• (2)??????
• (3)?????????
• (4)??????
• (5)????????
• (6)??????
• (7)?????????????

10
??????????????

• ????????????????????????????????
• ??????????????????????????????????????????????
• ??????????????????????
• ????????????????????

11
?????????

• ????????,?????????
• ????????????????
• ???????????,????????
• ???????,???????????,???????????

12
????????????
????????????
??
?????
????
????
???
13
????????????
13
12 June 2006
14
???????????????????
15
???????????????
16
?????????????????
17
??????????????
18
?????????????
19
???????????????KPIs????????
20
????????????????????????????
21
??????????????????????
22
??????????????????
23
???????????????
24
Agenda

• ????????
• ????????????
• ????????? - PerformancePoint Server
• Performancepoint Server ???????
• Performancepoint Server ???????
• Performancepoint Server ???????

25
??????????
Performance Management Specialization
26
SQL Server 2005 ???????????

• Integration Services ????
• ??????,?? ETL ??
• ?????????
• ????? ( Slowly Changing Dimensions )
• Key Lookup
• ????????????

27
???????
Alerts escalation
????
ETL
Text Mining
????
????
????
ETL
Hand coding
Cleansing ETL
??
ETL
????
??????
27
12 June 2006
28
?? Integration Services ????
Alerts escalation
??????
????
??
SQL Server Integration Services
28
12 June 2006
29
SQL Server 2005 ???????????

• Analysis Services ????
• ?????????
• ?? Unify Dimensional Model ( UDM )
• ?????? cube ????
• ?? Distinct Count ??

30
SQL Server 2005 Analysis Services ???? OLAP ?
Data Mining ??

• Unified Dimensional Model ( UDM) ?? OLAP ??
• ?? real-time cube ??(Pro-active caching )
• ???????????
• ??Web services
• ???????? MDX ? DMX ??

• plus
• ?????
• ????
• ????

????
????
????
???
??
?????
????
Introduced in SQL Server 2000 And SQL Server 2005
SE
30
12 June 2006
31
SQL Server 2005 ???????????

• Reporting Services ????
• ????????
• ?? RDBMS ????? ( Analysis Services )
• ?????????
• ????? ( Report Builder )

31
12 June 2006
32
SQL Server 2005Reporting Services ????

• ???????????
• ????????????
• ???????????
• ?? Web Services ??
• ??????????????
• ????
• Visual Studio IDE
• XML ?? (RDL)
• 3rd party ??
• ????
• SOAP Web Service APIs
• Report Manager portal
• ??????????

32
12 June 2006
33
SQL Server Report Builder ?????

• End-User ad hoc Reporting
• Report Model ???????
• ?? Excel ?????
• ???????????????????
• ??Report Builder ??
• ???????
• ??? Relational Database? OLAP ?????????
• ??????????????

33
12 June 2006
34
????????SQL Server 2005 Management Studio

• ? Visual Studio 2005 ???????????
• ?????????
• SQL Server
• Integration Services
• Analysis Services
• Reporting Services
• SQL Mobile
• ????
• Transact-SQL
• XML/A?MDX?DMX
• XQuery scripts

35
???????????????Business Intelligence Development
Studio

• ??????????
• Relational Database, OLAP, Data Mining, SSIS,
  Reporting, Code, Web pages
• ??????
• ?? Visual Studio.NET
• Team development, source control, versioning,
  developer isolation, resource independent coding
• Development cycle lifetime support
• Develop, Test, Deploy, Modify, Test
• ???????

36
SQL Server 2005 ? PerformancePoint Server 2007

• ???????????????????
• Excel?Excel Services
• SharePoint Lists
• SQL Server?Analysis Services
• ODBC
• ???????????
• Analysis Services
• Excel
• SharePoint List
• SQL Tabular
• ?? Reporting Services

37
Agenda

• ????????
• ????????????
• ????????? - PerformancePoint Server
• Performancepoint Server ???????
• Performancepoint Server ???????
• Performancepoint Server ???????

38
PerformancePoint Server 2007
39
?? Monitor?????????????????,???????
????Centralized authoring and accessrights
management of scorecardsand KPIs
???? Contextualized analysis of scorecards,
KPIs, reports and unstructured data
?????Strong integration with portal and 2007
Microsoft Office system
????Data-driven e-mail notifications
for scorecard and KPIs
40
?? Analyze??????????????????????
????ProClarity simplifies how decision makers
receive information and gain insight into their
business
???? ProClarity provides organizations with the
tools they need to conduct powerful analytic
modeling
????ProClarity works with a companys existing
business and technical infrastructure and adapts
to ongoing needs and changes.
???????????Fully integrated with SQL Server,
Business Scorecard Manager, SharePoint and Office
applications
41
?? Plan??????????????????????????
??????? PerformancePoint Planning utilizes Office
Excel as its primary user interface providing
rich planning and forecasting, contribution and
reporting capabilities
???? PerformancePoint Business Modeler puts the
creation of Plans, Budgets, Forecasts in the
hands of the business users dramatically lowering
time and investment on new model creation
????? PerformancePoint provides support for both
simple and complex business modeling scenarios
with constant and shareable business rules and
calculations
?????? PerformancePoint supports a companies
Performance Management business processes with
flexible and powerful business rules and routing
capabilities
42
Agenda

• ????????
• ????????????
• ????????? - PerformancePoint Server
• Performancepoint Server ???????
• Performancepoint Server ???????
• Performancepoint Server ???????

43
???????
?????????????????,???????????,???????
43
12 June 2006
44
PerformancePoint Server 2007?????????

• ???
• Dashboard Designer
• Parameterization
• ????????
• Thin, Interactive OLAP Charts
• Thin, Interactive OLAP Grids
• Strategy Maps
• Data Mining Trend Charts
• ????????
• Import Analysis Services KPIs
• Export to PowerPoint
• Export to Excel

• ?????????
• Excel 2007
• SharePoint lists
• ????????
• Usability for Content Creators
• Analytic View Designer
• ?????

45
????
46
??
47
????
48
????
49
???????????
50
Elements
51
Dashboard Designer
???????????????????, ???????

• ????????
• Office 2007 ?????
• ???????, ????????????
• ???????????
• ????
• ????????
• ??????, ??????
• ????
• ????????????????
• ???
• ?????
• ?????
• ????(Excel, SSRS)
• ???????
• ???????
• ?????(WYSIWYG)
• ?????SharePoint

52
????
??????????????????? ???????????

• ???????
• Excel
• Excel Services
• SharePoint Lists
• SQL Server
• Analysis Services
• ODBC
• Extensible

53
Scorecard Template
??????????????????? ???????????

• ???????????
• Analysis Services
• Excel
• SharePoint List
• SQL Tabular

54
?? KPI

• ??????Measure??KPI
• ??SSAS KPI??

55
?????
56

• demo

• Build Data Source
• Create New Scorecard
• KPI

57
Reports Template
58
Analytic View Designer
?????????SSAS?????????????

• ????
• ???????
• ??????????
• ???????
• ??????
• ???
• MDX ????

59
Analytic Charts
???????SSAS????????????

• ????
• ????/??
• ????/??
• ??????
• Drill Down To (Cross Drill)
• ???Excel

60
Analytic Grids
???????SSAS????????????

• ????
• ????/??
• ????/??
• ??????
• Drill Down To (Cross Drill)
• ???Excel
• ??CSS????????????

61
Strategy Maps
???????????????????????????

• ????
• ??Visio????????
• ?????????????
• ?????????????

62
Trend Charts and Analysis
??????????SSAS ???????????????

• ????
• ??scorecards and KPIs??????
• ??????
• ??????????

63
Dashboards
??????????????, ?????????????????????

• ????
• ????????????
• ??????????
• ?SharePoint??
• ???
• ????????????

64
Dashboards
Parameter
Scorecard
Analytic Chart
Perspective/Objective
Data
Analytic Grid
KPI
Analytic Chart
65

• demo

• Define a New Report
• Build Dashboard Layout
• Publish Dashboard to SharePoint

66
Export to PowerPoint 2007
?????????????PowerPoint

• ????
• Export scorecards, dashboards to PowerPoint 2007
• Static export from Monitoring Builder

67
Export to Excel 2007
?????????????Excel 2007

• ????
• Export scorecards, dashboards to Excel 2007
• Static export from Monitoring Builder

68
Performancepoint Server????????
????????????????????????????????????????

• ???????????????????????????,???????????
• ?????????????????????,????????
• ??????????????
• IT ???????????????????????,?????????????

69
Agenda

• ????????
• ????????????
• ????????? - PerformancePoint Server
• Performancepoint Server ???????
• Performancepoint Server ???????
• Performancepoint Server ???????

70
???????????? ProClarity Analytics

• ?????????????????????
• ???????,?????????????
• ?????????,?????????,???????????????

71
ProClarity Analytics ???
72
ProClarity????
????????????
????????????
????????????
73
??????????????

• ???????,?????????????????
• ?????????????????????????????

?????????
?????, ????????????????
??ProClarity Analytics ????,???????
74
?????????

• ????????????,???????
• ????????????????

75
???????

• ????????KPIs????????
• ?? ProClarity Analytics ?????????

76
???????

• ???????,????????????????????

????????????,???????????????
77
??????
?????????????????????????

• ProClarity??(???)
• ???????????????????????????

78
Powerful?????

• ?????????,????IT?????
• ProClarity Selector ? KPI Designer
  ???????,????IT?????

????????????????????? KPIs?????
79
???????

• ????????????????
• ????????????KPIs??????
• ????????

80
???????

• ??????????,???? Desktop Analytic Client ?? Web
  Analytic Client ????

Desktop and Web Analytic Clients
81
?? SQL Server ????

• ProClarity Publishing Server ?? SQL Server 2005
  ??????????,????????????ProClarity Analytics
  ???????

82
?? SharePoint Portal Server

• ???????????????,???????????

???? ????? KPIs ??? ???
83

• demo

?? ProClarityAnalytics ?????
84
Agenda

• ????????
• ????????????
• ????????? - PerformancePoint Server
• Performancepoint Server ???????
• Performancepoint Server ???????
• Performancepoint Server ???????

85
Microsoft Office PerformancePoint Server 2007
Planning

• ???????????????
• ???????,??????
• ????????????
• ???????????
• ?? Excel ??????????
• ?????IT??????????

86
Planning, Budgeting, and Forecasting Goals
Planning
Budgeting
Forecasting
87
Financial Intelligence
88
Excel Integration
89
Security
90
Process Management
91
Data Management Control
92
Financial and Business Intelligence
configurable
Intelligence
Financial
Intelligence
Business
behavior
93
Business Type Libraries
Configurable
Behavior
94
Business Type Library Example
Models
95
PerformancePoint Server Solution Overview
96
PerformancePoint Server Architecture
PerformancePoint Server Client
SAP
Siebel
MBS
Oracle
PeopleSoft
Custom
97
PerformancePoint Server Application Components
Account
CORPORATE Root Site
Entity
Scenario
Time
Product
Division Subsite
Models
Dimensions
Forms
Account
OPEX
Entity
Approver
Scenario
HR
Time
Analyst 1
Product
Analyst 2
Revenue
HR
Assignments
Dimensions
Business Roles
Models
Cycle
98
Architecture for Dynamics AX
Windows credentials
Windows credentials
Microsoft Dynamics AX .NET Business Connector
Web Services Client
PerformancePoint Front End Server
Microsoft Dynamics AX Application Object Server
PerformancePoint Data Import Wizard
Processor
Windows or database2 credentials
Windows credentials
Microsoft SQL Server ADO.NET Provider
Microsoft ADO.NET Provider
Microsoft Dynamics AX Database1
PerformancePoint Databases
99
Write-back functionality in PPS-Plan
3. Async Service translates change list
1. Submit data in Excel
2. Excel Changelist stored in the back end
database
PerformancePoint Models
4. Adds the new records to a fact table data
5. Cube refreshes with new values
100

• demo

• ??PerformancePoint Server 2007
• ??????
• ??PerformancePoint Server 2007
• ????????

101
?? Microsoft Office PerformancePoint Server 2007

• ?????????????
• ???????????
• ????????????
• ????????????????
• ?????IT ?????
• ?? Office ????

102
For More Information

• Visit TechNet at www.microsoft.com/technet
• Visit the url below for additional information

www.microsoft.com/taiwan/business/performancepoint
103
Non-Microsoft Publications
http//www.microsoft.com/taiwan/business/performan
cepoint/resources/training.aspx
104
Training Resources

• www.microsoft.com/taiwan/business/performancepoint
  /resources/training.aspx

For training information and availability
www.microsoft.com/learning
105
Readiness with Skills Assessment

• Self-study learning tool free to anyone.
• Determines skills gaps.
• Provides learning plans.
• Post your Score, see how you stack up.

Visit www.microsoft.com/assessment
106
(No Transcript)
107
Become a Microsoft Certified Professional

• What are MCP certifications?
• Validation in performing critical IT functions.
• Why Certify?
• WW recognition of skills gained via experience.
• More effective deployments with reduced costs
• What Certifications are there for IT Pros?
• MCP, MCSE, MCSA, MCDST, MCDBA.

www.microsoft.com/learning/mcp
108
Heard the News about TechNet?

• Software without time limits!
• Complimentary technical support.
• The most current resources on hand

109
???,??????????????????? www.microsoft.com/taiwan/t
echnet
1. IT ?????? TechNet ???? TechNet ?????? IT
??? (TDM) ? IT ???? (IT Pro) ????????????????????
IT ???????????? Tech Ed ???1995?????,????????????
??????????Microsoft Tech Ed Taipei ??????Tech Ed
????????,????????????,??????? IT
??????????????,???? Microsoft ???????????????,????
,??????????? WebCast??????,?????????,???? IT
?????????????????????,??????????????? ????????????
??,??????????,?????????????????????
2. ???? TechNet Flash ???? TechNet
?????????????????? 1. IT ?????????? 2. TechNet
???????? 3. TechNet ????????? 4. ??????? 5.
?????? 6. ???????????? ?????? ????????????????????
?,????????????????????
3. ?????? TechNet ???????????? IT
?????????????????????
4. ???? TechNet SubscriptionTechNet Subscription
? IT ????????????? IT ???????????????????
Microsoft ????,???????????? ?????? DVD ? CD
?????,???????? 1. ?? Microsoft ????Service
Pack??????? Resource Kit ? How-to ??? 2.
????????????????????? Microsoft
??????,???????? 3. ???????????,?????????????,????
?????????
110
(No Transcript)
111
(No Transcript)
112

• QA