DAT221 Office SharePoint 2007 âlights upâ Business Intelligence Grant Paisley MVP SQL Server A ngry K oala stipend @ angrykoala.com.auSlide 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 CatalogSlide 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 choiceSlide 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â decisionsSlide 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 RDBMSSlide 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 lookSlide 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 CatalogSlide 11
Excel & Excel ServicesSlide 12
Excel On Servers â Challenges â To numerous renditions of reality Can â t effectively share Hard to ensure restrictive data Not adaptableSlide 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 recordSlide 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 reportsSlide 15
Excel Services Zero-foot shaped impression, intuitive, program access to spreadsheets Pivot Tables KPIs from SQL Graphs & Charts Table FormattingSlide 16
Excel & Excel ServicesSlide 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 everSlide 18
Key Performance IndicatorsSlide 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 oversawSlide 20
KPI â s and KPI recordsSlide 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 ManagementSlide 22
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 pageSlide 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 PartsSlide 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 FilteringSlide 27
Business Data CatalogSlide 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, ODBCSlide 29
Business Data CatalogSlide 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 - whySlide 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 - howSlide 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 InformationSlide 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 processSlide 37
Document Library UISlide 38
Viewing Reports (Full Screen) .:tslidesep
Helped city by minimizing unlighted night lightings through dynamic repairing framework ... Acco ...
What is Business Intelligence? Roots in military knowledge. NOT keeping an eye on contenders
Business Intelligence Tools. Standard Edition. Endeavor Edition. In Review - Platforms ... Audit ...
Utilize the same example to server different occupants. Both the Service Application and ... Mos ...
Docs/undertakings/timetables, online journals, wikis, email mix, venture administration
Microsoft Office SharePoint Server 2007 (MOSS) And Windows SharePoint ... United Search taking i ...
SQL Server Integration. PowerPivot. Business Connectivity Services ... Server 2010 will require ...
Microsoft Office SharePoint Portal Server. Gives a focal center point to sort out and empower ac ...
Joint effort Services, conveyed as free Windows Server 2003 part ... information from SharePoint ...
7TN25 Tech@Night Office 2007 und Office SharePoint Server 2007 Zusammenarbeit leicht gemacht. ...
Motivation. Updating Projects to Visual Studio 2010Upgrading Projects to SharePoint 2010Integrat ...
Diagram. Presenting the new User ExperienceThe SharePoint Fluent User InterfaceSites as Collecti ...
THE DEFENCE INTELLIGENCE STAFF UK Strategic Intelligence, Planning and Decision Making . The ...
Speedy IntroductionGeneral OverviewSitesCommunitiesContentBreakSearch InsightsCompositesQ
2. Insight. What is Intelligence?Is Intelligence One General Ability or Several Specific Abiliti ...
IT Pro Tools for Customizing SharePoint 2010. NameTitleCompany. Plan. Stage InvestmentsProgramma ...
Plot. What\'s New in SharePoint 2010SharePoint 2010 Development PrimerNew Developer Tools for Sh ...