Business Intelligence


Microsoft has released a very interesting Virtual PC on her downloads site. Unfortunately you can't find it directly on their site, but I added the links so you can download it easily. In these VPC sits everything what Microsoft has at this moment for BI, among Office Enterprise 2007, SharePoint Portal server 2007, SQL server 2005 SP2, ProClarity 6.3 and PerformancePoint server 2007! Naturally you can only use these VPC for demonstration and evaluation aims. 

THE VPC exist from seven downloads:

Total download size is about 5 GB, the Administrator password which is necessary to logon is pass@word1 (and this VPC will expire on 8/17/2009 - Hopefully just in time for PPS v2). To run the VPC nicely, you actually need 4 GB internal memory. So what is different. Version 6 includes new demos and presenter scripts for different verticals. When you extract the files it creates an additional demos folder which now contains all of the scripts so you don't need to try and pull them off the VPC at all. It still has all of the same programs installed and configured which is very nice. Here is everything it contains and I highlighted the new items.


Presenter Scripts Applications Installed Sample Databases / Cubes
  • Business Intelligence “All-Up” Presenter Script
    • Financial Analyst
    • VP of Sales
    • Sales Representative
    • Chief Financial Officer
    • Data Analyst
  • 2007 Microsoft Office System Launch Demo
  • Data Mining Deep Dive
  • Enterprise Manufacturing Intelligence Demo
  • Banking Demo
  • Federal Government Demo
  • State & Local Government Demo
  • Healthcare Demo
  • Oil & Gas Demo
  • Retail Demo
  • Project REAL Sample Demos
  • SQL Server 2005 Demos
  • PerformancePoint Launch Demo
  • PerformancePoint Budgeting Demo
  • PerformancePoint CRM Demo
  • PerformancePoint MAP (Monitoring, Analytics, and Planning) Demo
  • PerformancePoint Planning Demo
  • PerformancePoint Planning Consolidation Demo
  • PerformancePoint Management Reporter Demo
  • PerformancePoint Sales Forecasting Demo
  • PerformancePoint Strategic Planning Demo
  • OfficeWriter Demo
  • PerformancePoint Hands-On Labs
  • New Account Load Demo
  • Windows Server 2003 R2 Service Pack 2
  • Internet Explorer 7
  • Office Enterprise 2007
  • Office Visio 2007
  • SharePoint Portal Server 2007
  • SQL Server 2005 Service Pack 2 (w/ SSIS, SSAS, SSRS)
  • SQL Server 2005 Data Mining Add-ins
  • SQL Server 2005 SharePoint Integration Add-in
  • ProClarity Analytics Server 6.3
  • ProClarity Dashboard Server 6.3
  • ProClarity Desktop Professional 6.3
  • ProClarity Web Professional 6.3
  • PerformancePoint Planning Server 2007
  • PerformancePoint Planning Add-In for Excel
  • PerformancePoint Planning Business Modeler
  • PerformancePoint Monitoring Server
  • PerformancePoint Monitoring Scorecard Builder
  • OfficeWriter for Word Plug-In
  • OfficeWriter for Excel Plug-In
  • Project REAL Reference Implementation
  • Business Intelligence Metadata Samples
  • AdventureWorks
  • AdventureWorks_Mfg (for Lean Manufacturing)
  • AdventureWorksDW (for AdventureWorks data warehouse)
  • Camden (Local Government)
  • Contoso (for PerformancePoint Planning)
  • EP
  • Government_AppDB (PerformancePoint Planning)
  • HC
  • Healthcare_AppDB (PerformancePoint Planning)
  • OSS (Healthcare)
  • PDW (for PerformancePoint Planning)
  • PeoplSoft Financials_AppDB (PerformancePoint Planning)
  • PPS Launch (for PerformancePoint Planning)
  • PSFIN_Data_Mart
  • REAL_Source_Sample_V6 (for Project REAL)
  • REAL_Warehouse_Sample_V6 (for Project REAL)


Technorati tags: ,

On December 5, Microsoft announced the public availability of a Community Technology Preview (CTP) test build of PerformancePoint Server 2007. PerformancePoint Server is a highly-integrated performance management application, driven by the SQL Server platform and familiar Microsoft Office front end, allowing corporations to monitor, analyze, plan and make critical business decisions based on reliable data from all aspects of the company. Partners, customers and end-users are encouraged to visit the Web site at to download the application to begin building plans in a real-world environment and testing the overall power of the product for themselves.

If you're not a KPI (key-performance-indicator) jockey, you probably haven't paid much attention to Microsoft's PerformancePoint. But here's why it matters, in the grander Microsoft scheme of things.

Almost all of Microsoft's recent talk about Office has centered around the desktop application suite. But Microsoft also is angling for Office to be a front-end to back-end business applications. That's why Microsoft announced the release of OBA RAP for Supply Chain Management. OBA RAP is the abbreviation for Office Business Application Reference Application Pack. An RAP is a set of technical resources and guidance to enable architects and developers to design and build solutions using a reference application. If you want to know all about OBA read the blog Office Business Applications: What is it, and how can I get started? of Erika Ehrli (Site Manager for the Office Developer Center).  

Microsoft is expecting more OBA's from various third-party developers. OBA's are important to Microsoft because they provide yet another way to get Office entrenched in businesses. And via its related Line of Business Interoperability (LOBi) service, Microsoft is hoping to get SharePoint Server equally embedded inside corporate IT shops.

OBAs and LOBi are both part of Microsoft's overarching push to make Office more roles-based/verticalized. And it looks like Microsoft's planning a similar vertical — and horizontal — push with PerformancePoint Server, too.

Where is Office PerformancePoint heading for
Since Microsoft acquired ProClarity for its technology and its people, MS speeded up their entrance into the performance management space. Microsoft Business Scorecard Manager Server 2005 and ProClarity 6.2 where already often integrated as part of a customer solution. In the next picture I'll show you which areas the BSM and Proclarity are covering and at which areas OPS is aiming.

Performance Roadmap

Area 1

With Business Modeling, companies determine costs, capacity, activity levels and production volumes across the enterprise. Managers simulate, dynamically test, and compare alternate business scenarios and identify the optimal solution to maximize business performance and profitability.

Business Forecasting allows you to forecast your business needs. Define business scenarios and project your financial position. Manage your business, prepare detailed business forecasts including: sales, loans, salaries and investments.

Area 2

Pervasive Analytics is used to support and improve the decision-making process. And making faster and better decisions, based on the speed and format at which data is collected, sorted by relevance, and delivered, is key to a company’s survival and ability to stay competitive.

Area 3

Scorecarding / Dashboarding expands the reach of business intelligence and brings every employee into the performance management process through personalized Web-based scorecards.

Microsoft Resources: