DAT221 Office SharePoint 2007 "lights up" Business Insight.

Uploaded on:
Category: Sports / Games
DAT221 Office SharePoint 2007 "lights up" Business Knowledge Stipend Paisley MVP SQL Server A ngry K oala award @ angrykoala.com.au I have seen the light … Motivation Microsoft " s BI Methodology M icrosoft O ffice S harePoint S erver 2007 Greenery 2007 – what do I get Demos
Slide 2

DAT221 Office SharePoint 2007 “lights up” Business Intelligence Grant Paisley MVP SQL Server A ngry K oala stipend @ angrykoala.com.au

Slide 3

I have seen the light …

Slide 4

Agenda Microsoft ’ s BI Strategy M icrosoft O ffice S harePoint S erver 2007 MOSS 2007 – what do I get Demos Excel and Excel Services KPI ’ s Build a dashboard BI Filtering Business Data Catalog

Slide 5

Business Intelligence “ transforming information into learning ” Why? better choices What is the contrast between a right choice wrong choice awful choice? An awful choice is a clueless choice

Slide 6

Complete and incorporated BI offering Widespread conveyance of knowledge through Microsoft Office Enterprise grade and moderate Microsoft Business Intelligence Vision and procedure Providing so as to improve associations business bits of knowledge to all representatives prompting better, speedier, more relevantâ decisions

Slide 7

Integrated Offering Analytic Applications End-client Tools BI Platform Business Scorecarding (BSM) Microsoft Office SharePoint Server 2007 End-client Analysis (Excel) SSIS SSAS SSRS SQL RDBMS

Slide 8

SharePoint Investment Areas Platform Services Workspaces, Mgmt, Security, Storage, Topology, Site Model Server-based Excel spreadsheets and information perception, Report Center, BI Web Parts, KPIs/Dashboards Docs/undertakings/timetables, websites, Wikis, email coordination, venture administration “lite”, Outlook combination, logged off docs/records Business Intelligence Collaboration Enterprise Portal layout, Site Directory, My Sites, long range interpersonal communication, security control Rich and Web structures based front-closures, LOB activities, pluggable SSO Business Process & Forms Portal Content Management Search Integrated archive administration, records administration, and Web content administration with arrangements and work process Enterprise versatility, logical significance, rich individuals and business information look

Slide 9

What clients need Easily impart and track objectives BI for data laborers Reuse existing spreadsheets, reports …

Slide 10

2007 Office System BI Investments Excel customer/Excel Services Key Performance Indicators Dashboards Filter Web Parts Report Center/Report Library Business Data Catalog

Slide 11

Excel & Excel Services

Slide 12

Excel On Servers “ Challenges ” To numerous renditions of reality Can ’ t effectively share Hard to ensure restrictive data Not adaptable

Slide 13

Excel Services Overview High quality web tearing Zero-foot shaped impression Interactive: Set parameters, sort, channel, investigate Limit to program access Browser Excel 2007 View and Interact Publish Spreadsheets Design and writer Export/Snapshot into Excel 2007 Programmatic Access Open in Excel for rich investigation and examination Open previews SharePoint stage and Excel administrations Spreadsheets put away in archive libraries Spreadsheet computation and rendering External information recovery and reserving 100% count loyalty Custom applications Set qualities, perform figurings, get upgraded qualities by means of web administrations Retrieve full exercise manual record

Slide 14

Excel and SharePoint Server Get more out of the #1 BI front end Best with Microsoft SQL Server 2005 Easily discover patterns in information Excel Conditional Formatting Knowledge, Discovery & Insight Excel 2007 offers complete backing for SQL Server 2005 Analysis Services Dashboards and Web Parts Easily make intense BI entryways Report Center Centralize stockpiling of business reports

Slide 15

Excel Services Zero-foot shaped impression, intuitive, program access to spreadsheets Pivot Tables KPIs from SQL Graphs & Charts Table Formatting

Slide 16

Excel & Excel Services

Slide 17

Excel Services Summary Secure, server based rendering and estimation of Excel exercise manuals Scalable Custom applications by means of web administrations Biggest arrival of Excel ever

Slide 18

Key Performance Indicators

Slide 19

KPIs are: Expression and representation of a methodology Entry point to examination for most business clients Reduces the danger of giving crude information or information in extensive volumes Key Performance Indicators Microsoft KPIs are: Visual Multidimensional Contextual/‘ drifted ’ Centrally oversaw

Slide 20

KPI ’ s and KPI records

Slide 21

Report Center and Dashboard BI center point for the Microsoft Office SharePoint Server 2007 Make new BI includes simple to find & utilization Provide a format for fruitful BI gateways A report library tuned for “ reports ” Excel exercise manuals, SSRS reports, and so forth. Unite BI, joint effort, Enterprise Content Management

Slide 22


Slide 23

Filter Web Parts Scenarios One size does not fit all – dashboards should be made pertinent to the client Filter for eastern locale, last quarter Automatically demonstrate only your clients when you load page

Slide 24

OOB Filter worth sources User entered quality Authored rundown SharePoint list SQL Server 2005 Analysis Services Bus. Information Catalog SharePoint profile Query string OOB Display Options Type in worth Pick from rundown Tree perspective Hidden Extensibility Custom suppliers & buyers Standard interfaces that ship in WSS Filter Web Parts

Slide 25

OOB Web Parts That Filter 2007 Office framework Excel Services KPI List Business Data Catalog Item & List WSS List view Microsoft Office SharePoint Designer Data View SQL Server 2005 Reporting Services The environment Cross Microsoft exertion with additional to come … and more from accomplices!

Slide 26

KPI ’ s Dashboards Filtering

Slide 27

Business Data Catalog

Slide 28

Business Data Catalog (BDC) Connects Office servers to business information Web Parts Lists Search User Profiles Custom Apps List store Search Index Profile Store Metadata Business Data Catalog WS Proxy ADO.NET Web Service Database Microsoft BizTalk, SAP, Siebel, Legacy, … SQL Server, Oracle, OLEDB, ODBC

Slide 29

Business Data Catalog

Slide 30

You requesting that we help you … Track and convey objectives Reuse & improve existing BI resources Enable IWs to understand the capability of BI Bring BI, cooperation & ECM together Recap - why

Slide 31

2007 Office framework conveys … OOB BI in SharePoint Exposes all Microsoft BI in one spot Author and distribute with Excel Easy to utilize apparatuses KPIs Dashboards Filter Web Parts Report Center Recap - how

Slide 32

Call To Action Get the beta and begin assessing http://www.microsoft.com/office/review Get the Customer DVD with HOLs and Tech Materials Get included with the group New Community webpage – http://www.microsoft.com/sharepoint/group SharePoint blog – http://blogs.msdn.com/sharepoint/Records Management blog – http://blogs.msdn.com/recman/

Slide 35

Additional Information

Slide 36

SSRS and the 2007 Office System Microsoft SQL Server 2005 Reporting Services (SSRS) is coordinated with Windows SharePoint Services “ v3 ” Seamless distributed, survey and administration of SSRS reports inside of Windows SharePoint Services One reliable area for BI Office SharePoint Server 2007 “ light up ” with SSRS Report Center joining Dashboards and Filter Web Parts Integration with archive administration and work process

Slide 37

Document Library UI

Slide 38

Viewing Reports (Full Screen) .:tslidesep

View more...