Wednesday, December 10, 2008

PerformancePoint Server 2007 Service Pack 2 (x64)

PerformancePoint Server 2007 with Service Pack 2 (SP2) is a set of servers and integrated performance management applications that you can use to monitor, analyze, and plan your business and to assure alignment, accountability, and actionable insight across your entire organization.

Instructions

To install this download, do the following:
Download the service pack by clicking the Download button (above) and then save the file to your hard disk.
Double-click PPS2007_SP2x86_EN.exe to run the extraction process. You will be prompted to choose a location for your files.
To start the extraction, click Unzip.
After the extraction has completed, click OK.
Go to the location of the service pack files.
Double-click and run the individual patch files (*.msp) to update the PerformancePoint Server products as follows:
- To update the Planning Business Modeler components, run PBMCli.msp.
- To update the PPS Add-in for Excel, run PPLXCli.msp.
- To update the Planning Server, including Configuration Manager, run PSCSrv.msp.
- To update the Monitoring server and Dashboard Designer, run PSCSrv.msp

Microsoft ProClarity Analytics Server 6.3 SP2 - Available TODAY!

ProClarity Analytics Server 6.3 SP2 is a cumulative update that includes all fixes to ProClarity Analytics Server 6.3 since the public release of these two products.

(For detailed information about the fixes, please refer to kb article 958293 or the ProClarity 6.3 SP2 release notes.)

This service pack also includes the components to distribute ProClarity Professional 6.3 SP2, ProClarity KPI Designer 6.3, and ProClarity Selector from ProClarity Analytics Server 6.3


Monday, December 01, 2008

Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint

The Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

http://www.microsoft.com/downloads/details.aspx?FamilyID=200fd7b5-db7c-4b8c-a7dc-5efee6e19005&DisplayLang=en

Friday, November 14, 2008

Filtering Unneeded Dimension Members in PerformancePoint Filters - SQL Server Central

Filtering Unneeded Dimension Members in PerformancePoint Filters - SQL Server Central: "Sometimes we need to utilise dynamic dimension security in an Analysis Services solution and we also need to display dynamically the allowed members in a PerformancePoint filter."

Thursday, November 13, 2008

PPS and 2008 SQL and Windows Server

http://hmorgenstern.spaces.live.com/blog/cns!28A6BE83102A0EB3!419.entry: "I want to use SQL 2008 as for my PPSMonitoring repository DB, and connect to SQL 2008 cubes. There are some SQL 2005 redistributables that are required and available here
Sqlncli
SQLServer2005_ADOMD
SQLServer2005_ASOLEDB9
SQLServer2005_XMO"

Monday, November 10, 2008

Time for change...moving forward to iBIG'ger and Better

After several months of deep thought and self evaluation, I have decided to direct my attention back to my privately owned company, International Business Intelligence Group, LLC (iBIG) based out of New York.

Originally when I started the company some 3 1/2 years ago, I had the idea to bring BI to the masses and start with small to midsize clients as a starting point. As the business and the business relationships started to take shape, I realized at the time, BI was still too foreign for most small to midsize businesses to grasp and there was/is a strong need for application development and support services. Driven by the market demands I redirected focus to app dev and allowed the BI side of the business to take a back seat.

After a year of being in business I then realized I could not escape from BI and decided to join Avanade (joint venture between Microsoft and Accenture) to get back into the BI space. While I was with Avanade, I had the opportunity to meet some great people and work on some life changing projects. I quickly reaffirmed my love for BI and Enterprise Colloboration while establishing some long term relationships. Avanade offered the exposure to enterprise clients but lacked the internal technical sales team required to deliver on truely successful BI adoption. We were mostly feed by Accenture clients who expressed an interest in BI but required some real world examples around capability and integation. Needless to say,POC's (Proof of Concept) were a big part of the last two and half years. As PerformancePoint Server (PPS = Microsoft's full package BI Solution) was being launched, I realized it was time for me to focus my attention on PPS and it's capabilities. I then explored an opportunity with Solver, Inc.

Solver is a ten year old privately held company focused on Corporate Performance Management solutions on the Microsoft BI Stack. I had some great experiences with the Solver team in building solutions on PerformancePoint. With my background in Infrastructure and enterprise implementation strategy, I was tasked to write a whitepaper for HP on "PerformancePoint Server implementation Best Practices". I also had the opportunity to work with some of the really smart BI folks that came from Avanade as well as Solver's own team. Together we built some pretty cool solutions for our clients and developed some great relationships in the process...

Last week, we decided to take a different direction in our relationship. I am going back to the old company and revive the BI initiative with new clients and new friends!

More to come...

Friday, November 07, 2008

Performance and capacity requirements for Hyper-V

Performance and capacity requirements for Hyper-V:

"This article provides information about the performance and capacity requirements for deploying Microsoft Office SharePoint Server 2007 in a Hyper-V™ virtual environment.
In this article:
Introduction
Recommendations for configuring and optimizing Hyper-V
Hyper-V test environment and testing strategy
Test scenarios, results and analysis
Recommendations for deploying SharePoint on Hyper-V
Additional resources"

Monday, November 03, 2008

SharePoint SUSHI

SharePoint SUSHI - Home: "SUSHI is a powerful, user-friendly SharePoint application enabling you to accomplish common SharePoint administrative and development tasks. You can think of SUSHI as a Swiss army knife for SharePoint.
What does the name SUSHI stand for?
SUSHI = SharePoint Utility with a Smart, Helpful Interface"

Windows 7

Windows Developer Center: Information about WPF, WCF, Win32, Downloads, and More: "Build applications on a solid foundation; enable richer application experiences; and integrate the best of Windows and Web services. The features and technologies of the Windows 7 operating system enable you to build the next generation of software applications. This guide describes those features and includes vivid screenshots from the pre-Beta version released at PDC."

Friday, October 31, 2008

SQL Server 2005 SP3 Beta

Download details: SQL Server 2005 SP3 Beta: "Beta version of SQL Server 2005 Service Pack 3 (SP3) is now available.

Tuesday, October 28, 2008

Steve Balmer drops me a line...

A Platform for the Next Technology Revolution

During the past decade, a dramatic transformation in the world of information technology has been taking shape. It's a transformation that will change the way we experience the world and share our experiences with others. It's a transformation in which the barriers between technologies will fall away so we can connect to people and information no matter where we are. It's a transformation where new innovations will shorten the path from inspiration to accomplishment.

Many of the components of this transformation are already in place. Some have received a great deal of attention. "Cloud computing" that connects people to vast amounts of storage and computing power in massive datacenters is one example. Social networking sites that have changed the way people connect with family and friends is another.

Other components are so much a part of the inevitable march of progress that we take them for granted as soon as we start to use them: cell phones that double as digital cameras, large flat-screen PC monitors and HD TV screens, and hands-free digital car entertainment and navigation systems, to name just a few.

What's missing is the ability to connect these components in a seamless continuum of information, communication, and computing that isn't bounded by device or location. Today, some things that our intuition says should be simple still remain difficult, if not impossible. Why can't we easily access the documents we create at work on our home PCs? Why isn't all of the information that customers share with us available instantly in a single application? Why can't we create calendars that automatically merge our schedules at work and home?
This week at the Professional Developers Conference (PDC) in Los Angeles, we shared news with software developers about a new set of platform technologies that will help transcend these limits. Because you are a subscriber to Executive Emails from Microsoft, I wanted to share my thoughts about the impact that these technologies will have as developers begin to use them to create a new generation of experiences that extend uninterrupted from the desktop to the mobile phone, media player, car, and beyond-to places where we never thought information and communications would be available to us.

A New Platform for Cloud Computing
At PDC, we announced the availability of an early preview release of a new technology called Windows Azure. Windows Azure will enable developers to build applications that extend from the cloud to the enterprise datacenter and span the PC, the Web, and the mobile phone. For the first time, we shared pre-beta code for Windows 7 and for Windows Server 2008 R2. Windows 7, which is the next version of the Windows desktop operating system, will take advantage of software and hardware advances to help eliminate the boundaries between information, people, and devices.

We also previewed Office Web applications, which are light-weight versions of Word, Excel, PowerPoint, and OneNote that are designed to be accessed through a browser. Office Web applications will be part of the next version of Office and will enable people to view, edit, and share information and collaborate on documents on the desktop, the phone, and in a Web browser in a way that is consistent and familiar.

Windows Azure is part of the Azure Services Platform, a comprehensive set of storage, computing, and networking infrastructure services that reside in Microsoft's network of datacenters. Using the Azure Services Platform, developers will be able to build applications that run in the cloud and extend existing applications to take advantage of cloud-based capabilities. The Azure Services Platform provides the foundation for business and consumer applications that deliver a consistent way for people to store and share information easily and securely in the cloud, and access it on any device from any location.

Windows Azure is not software that companies will run on their own servers. It's something new: a service that runs in Microsoft's growing network of datacenters and provides the platform that helps companies respond to the realities of today's business environment, and tomorrow's. Windows Azure technologies are already finding their way into products such as Windows Server 2008 and System Center Virtual Machine Manager, enabling organizations and Microsoft partners to create their own cloud infrastructure.

Windows Azure will enable organizations to respond to realities such as the need to use the Web to provide customers with comprehensive information and to interact with an audience that has the potential to expand exponentially overnight; to integrate operations with partners-and sometimes even competitors-to meet customer needs; to add new capabilities quickly to respond to new opportunities; and to enable employees to work efficiently and effectively no matter where they are. These realities apply not just to businesses, but to organizations of all kinds: schools, governments, community groups, and more.

Traditional approaches to building technology infrastructure and delivering computing capabilities make it difficult and expensive to adjust to these realities. You need systems with enough capacity to meet the highest possible demand-capacity that includes servers and buildings to house them, the power to run them, and the people to manage them. You have to spread that capacity across locations so there's a backup if one part fails. You have to solve issues like access for different types of users and compliance with tax regulations in all countries where your customers reside.

Designed specifically to meet the global scale that today's organizations require, the Azure Services Platform will provide fundamentally new ways to deploy services and capabilities. It gives businesses the option to take advantage of the capacity available in the cloud as it is needed, reducing the need to make large upfront investments in infrastructure simply to be ready when demand spikes. It will enable developers to create applications that run in the cloud and provide the features, information, and interactivity that employees, partners, and customers expect-no matter how many of them there are, where they are in the world, or what device they have at hand.

Software Plus Services and the Power of Choice
The Azure Services Platform reflects our belief that choice is critical for developers, companies, and consumers. It is also based on our belief that the key to delivering value today and in the future lies in combining the best aspects of software running on PCs, servers, and devices with the best aspects of services running on the Web-an approach we call "software plus services."
Our software plus services approach lets people take full advantage of the incredible power of today's devices. While there are undeniable benefits to being able to tap into the wealth of information and services that can be accessed over the Web through a browser, the interactive experiences that people expect on their PC, mobile phone, and media player depend on sophisticated software running on powerful processors.

The richness of these experiences will only increase as multicore processors expand the computing capabilities of our devices and new programming languages open the door to a new generation of applications that let us use more natural ways to interact with digital technology such as voice, touch, and gestures.

Software plus services also recognizes that for most companies, the ideal way to build IT infrastructure is to find the right balance of applications that are run and managed within the organization and applications that are run and managed in the cloud.

This balance varies by company. A financial services company may choose to maintain customer records within its own datacenter to provide the extra layers of protection that it feels are needed to safeguard the privacy of personal information. It may outsource IT systems that provide basic capabilities such as email.

This balance will change over time within an organization, as well. A company may run its own online transaction system most of the year, but outsource for added capacity to meet extra demand during the holiday season. With software plus services, an organization can move applications back and forth between its own servers and the cloud quickly and smoothly.
Today, companies around the world are implementing Microsoft technologies to take advantage of the best combination of on-premise software and cloud-based services. Using Microsoft Online Services, businesses including Coca-Cola Enterprises, Blockbuster, and Energizer access and manage Microsoft Exchange, SharePoint, Office Communications Server, and Live Meeting over the Web through a single, secure infrastructure. In addition, 1 million people rely on Office Live Workspace for sharing and collaborating with friends, family, and colleagues.

Expanding the Definition of Personal Computing
Ultimately, the reason to create a cloud services platform is to continue to enhance the value that computing delivers, whether it's by improving productivity, making it easier to communicate with colleagues, or simplifying the way we access information and respond to changing business conditions.

In the world of software plus services and cloud computing, this means extending the definition of personal computing beyond the PC to include the Web and an ever-growing array of devices. Our goal is to make the combination of PCs, mobile devices, and the Web something that is significantly than more the sum of its parts.

The starting point is to recognize the unique value of each part. The value of the PC lies in its computing power, its storage capacity, and its ability to help us be more productive and create and consume rich and complex documents and content.

For the Web, it's the ability to bring together people, information, and services so we can connect, communicate, share, and transact with anyone, anywhere, at any time.

With the mobile phone and other devices, it's the ability to take action spontaneously-to make a call, take a picture, or send a text message in the flow of our activities.

Through Live Mesh-a service from Microsoft that we announced earlier this year and about which we shared new information week-we're beginning to bridge the PC, phone, and Web and create this next generation of connected experiences. Built on the Azure Services Platform, Live Mesh enables you to use programs and information stored on your work computer from your home PC, and vice versa. With Live Mesh, you can share folders and ensure that the information is automatically synchronized across your devices.

Live Mesh hints at how our lives will be transformed as the barriers between devices disappear and the option to connect instantly to people, devices, programs, and information becomes a reality.

We're not quite there yet. Today, the Azure Services Platform is available only as a limited technology preview release. But as developers begin to combine the capabilities of this new platform with the amazing ongoing hardware and software innovations that we are seeing from companies across the industry, it will bring us significantly closer to the time when information, communication, and computing flows along with us seamlessly as we move through our day-to-day activities.

You can learn more about these technologies and the progress we are making by visiting the Microsoft Software + Services Web site.
I look forward to sharing more information with you about these new technologies in the near future.

Take care,
Your new BFF - Steve

Microsoft to Offer ‘Cloud’ Computing - NYTimes.com

Microsoft to Offer ‘Cloud’ Computing - NYTimes.com: "LOS ANGELES — Looking for growth in new markets where it is increasingly being bypassed, Microsoft said Monday that it would begin offering a new “cloud” operating system that would manage the relationship between software inside the computer and on the Web, where data and services are increasingly centralized. The software is expected to go on sale late next year."

Monday, October 20, 2008

Microsoft Business Intelligence VPC Release 7

So this past week I was at the MS BI Conference and finally got a copy of the MS BI VPC 7 release (July 23, 2008). Still waiting on the actual publication of the files for the community wide download like releases 5.1 and 6. The overview documentation has not been updated with the new items that were added, so I quickly went through and tried to pick out the new items and mark them below.

Sample 1

There were a couple of new demos that I wanted to point out in regards to IT and Hospitality. The IT demo has a nice overview and service level dashboard to take a look at:

Sample 2

And the Hospitality one has quite a few pages and here is a screenshot of the executive dashboard page:

Sample 3

I just thought this one was interesting since I worked in the casino industry for over ten years and it is kind of neat to get other points of view on how people like to analyze the data and take a look at the cubes that were designed.

The VPC is still running on Windows Server 2003 and SQL Server 2005 and has a time bomb expiration of December 4, 2009 (same password as before - pass@word1). Hopefully it will be available soon for everyone to download, so until then this will give you a sneak peek.

If you are going to be using these VPCs I would definitely recommend running it on an external USB drive, give it about 1.5 to 2GB of memory, and when you are done using it close the VPC with the ‘save state’ option from the Action menu within the virtual PC (this will speed up the start time for when you want to use it the next time since everything will already be loaded).

Thursday, October 16, 2008

Why Sales Is Ripe for Performance Management | Business Finance

Why Sales Is Ripe for Performance Management Business Finance: "With customers shaken by a jittery economy, the pressure is on for sales departments to step up and defend their company's profitability. To help them do so, organizations are increasingly turning to sales performance management, a discipline that Pleasanton, Calif.-based advisory firm Ventana Research defines as 'a coordinated and integrated set of sales-related activities, processes, and systems that help organizations meet customer revenue goals and objectives.'"

Sunday, October 12, 2008

Microsoft SQL Server 2008 Feature Pack, August 2008

Download details: Microsoft SQL Server 2008 Feature Pack, August 2008:

The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008.

It includes the latest versions of:

Redistributable components for SQL Server 2008.
Add-on providers for SQL Server 2008.
Backward compatibility components for SQL Server 2008.

Saturday, October 11, 2008

Jason Morales' Microsoft BI Update v.25 - October

Contents
Upcoming Events
Upcoming Webcasts
Training: online and regional options
Resources: whitepapers, case studies, datasheets, webcasts, books, etc
News Links and Press Releases

Hot Topics

SQL Server 2008 performs 1 trillion row query in seconds at BI Conference

Microsoft Focuses on BI for SQL Server Kilimanjaro
Microsoft BI: Gemini Lands at Kilimanjaro

DM Review Midmarket Business Intelligence Survey Results

Assessment Tool for Business Intelligence
- compare your infrastructure against industry best practices and the latest IT research


Upcoming Events

IT: A Strategic Asset for BI and Collaboration
Sponsored by CSG Professional Services & Microsoft
Oct 15 – Portland, OR
Click here to register

Capitalize on the Business Intelligence Opportunity
Partner Recruit Road Show
Oct 17 - San Francisco, CA
Click here to register

Driving Business Performance with Microsoft PerformancePoint Server Planning
Sponsored by GNET Group & Microsoft
Oct 21 – Golden Valley, MN
Click here to register

Streamlining the Budget Process
Presented by Analysts International
Oct 23 – Minneapolis, MN
Click here to register

Wine, Hor d’oeuvres, and Analytics: at the Ste. Michelle Wine Estates
Nov 4 – Woodinville, WA
Click here to register

Wine, Hor d’oeuvres, and Analytics: at Ponzi Winery
Sponsored by CSG Professional Services & Microsoft
Nov 11 – Beaverton, OR
Click here to register

Performance Management Executive Roundtable (invite only)
Sponsored by Brown Smith Wallace & Microsoft
Nov 12 – St. Louis, MO
Click here to receive an invite

Performance Management Executive Roundtable (invite only)
Sponsored by GNET Group & Microsoft
Nov 13 – Minneapolis, MN
Click here to receive an invite

Wine, Hor d’oeuvres, and Analytics: at the Ritz
Sponsored by Blackstone Technology Group & Microsoft
Nov 18 – San Francisco, CA
Click here to register

Sales Workshop with Dale Carnegie Training & Microsoft
Nov 18 – Portland, OR
Click here to register

Wine, Hor d’oeuvres, and Analytics: at The Mountain Winery
Sponsored by Convergent Computing (CCO) & Microsoft
Nov 19 – Saratoga, CA
Click here to register

Wine, Hor d’oeuvres, and Analytics: at the Wente Winery
Sponsored by Allin Consulting & Microsoft
Nov 20 – Livermore, CA
Click here to register

PASS Community Summit 2008
Nov 18-21 - Seattle, WA
Click here to learn more

Find Events & Webcasts


Upcoming Webcasts
* all times listed below are for Pacific time zone

A Day in the Life of a Budget Administrator Using PerformancePoint
Presented by Graham Hunter of Ninety & Jason Morales of Microsoft
Oct 23, 11am
Click here to register

Business Intelligence and SharePoint, Gain Knowledge from your Technology
Presented by Steve Muise and Jason Noble of Neudesic
Oct 21, 11am
Click here to register

Extend Your Investment with Autonomy Integrated Suite for SharePoint
Presented by MicroLink, LLC
Oct 22, 10am
Click here to register

How Dashboards and KPIs can Transform Your Services Business
Presented by PointBridge
Nov 5, 10am
Click here to register

Application Lifecycle Development
Presented by Neudesic
Nov 12, 10am
Click here to register

Performance Management Using Project Server 2007 and PerformancePoint Server 2007
Nov 13, 1pm
Click here to register

CRM & BI, Easily Leverage Your CRM Data
Presented by Darren Gooding & Steve Muise of Neudesic
Nov 18, 11am
Click here to register


Training

PerformancePoint Training Sites
Online: PPS Planning, Monitoring and Analytics (includes videos and workbooks)
Online: ProClarity


Hitachi Consulting
Business Intelligence Education Services
PerformancePoint 2007 Boot Camp (4 Day) - click here for more info
Nov 3 – Dallas, TX
Nov 7 – Bellevue, WA


Solid Quality Mentors
BI Courses, including SQL 2005, PerformancePoint and ProClarity

Enterprise ETL with SQL Server 2005 (4 day) – click here for more info
Oct 13-16 – Beaverton, OR
Nov 17-20 – Bellevue, WA

Microsoft BI Bootcamp (5 day) - click here for more info
Dec 8-12 - Seattle, WA

SQL Server 2005 Analysis Services (3 day) – click here for more info
Nov 11-13 – Bellevue, WA

Solving Business Problems in MDX (2 day) – click here for more info
Nov 11-12 – Minneapolis, MN

SQL Server 2005 End-to-End Business Intelligence Workshop (5 day) – click here for more info
Oct 27-31 – Sacramento, CA
Dec 1-5 – Beaverton, OR

Microsoft Office PerformancePoint Server 2007 End-to-End – click here for more info
Oct 20-24 – Sacramento, CA
Oct 27-31 – Minneapolis, MN


Premier Knowledge Solutions
PerformancePoint Bootcamp - click here for more info
Nov 17 – St Louis, MO

PerformancePoint Planning
Oct 29-31 – St Louis, MO
Additional course info available by request - contact Andrew Petroline


Kimball Group
Data Warehouse Lifecycle in Depth
Taught by Margy Ross & Warren Thornthwaite
Nov 18-21 – San Francisco, CA
Click here to learn more & register

Microsoft Data Warehouse in Depth
Taught by Joy Mundy & Warren Thornthwaite
Dec 2-5 – Dallas, TX
Click here to learn more & register


IT Mentors
Microsoft Office PerformancePoint Server 2007 Monitoring & Analytics


ONLC Training Centers
PerformancePoint Training, Class, Course Information

Microsoft Office PerformancePoint Server 2007 Technical Training (4 days)
Dec 8-11 – Omaha, NE
Click here to learn more & register

Microsoft Office PerformancePoint Server 2007 Bootcamp (5 days)
Oct 13-17 – Omaha, NE
Dec 15-19 – Omaha, NE
Click here to learn more & register


AppDev - CD-ROM & DVD-ROM Training
SQL Server 2005 and BI Learning Suite


Partner Program - webcasts
Online Training Webcasts - (keyword = performancepoint)

Resources

Microsoft BI
Whitepapers, Demos, Product Evaluations
Consulting Partner Directory
Subscribe - Microsoft Business Intelligence Newsletter

PerformancePoint Server 2007
System Requirements
Download: PerformancePoint Server 2007 Trial Software
Flash Demo: Virtual Experience
Datasheets: Overview, Monitor, Analyze, Plan, Management Reporting
Video: PerformancePoint Server Team Video
Video: Business Intelligence by Role (CFO, Operations Mgr, IT Director, Sales Mgr)
Wikis: Wikipedia, Channel 9

On-Demand Webcasts of PerformancePoint Server 2007

PPS Technical Library
PPS Developer Portal

Books on PerformancePoint Server 2007
The Rational Guide to Monitoring and Analyzing with…
The Rational Guide to Planning with…
Business Intelligence with…
Pro PerformancePoint Server 2007
Microsoft Office PerformancePoint Server 2007
Microsoft PerformancePoint 2007 for Dummies

Downloadable Books for PerformancePoint Server 2007

ProClarity
Download: ProClarity Analytic Server Evaluation 6.3
Search the Support Knowledge Base
Microsoft ProClarity Software Developer’s Kit 6.3

PerformancePoint 2007 Management Reporter
Overview

SQL Server 2005
SQL Server 2005 Business Intelligence
Best Practices
BI Presentations
SQL Server 2005 – Learning Portal
Archived Webcasts, Virtual Labs and Podcasts

SQL Server 2008
Business Intelligence
Data Warehousing
Demo: SQL Server 2008 Overview
Video: SQL Server 2008 Business Intelligence
Datasheet: Business Intelligence

SQL Server 2008 Virtual Labs:
Analysis Services: Delivering Analysis Services capabilities through Microsoft Office
Analysis Services: Managing Analysis Services Solutions
Reporting Services: Managing the Report Services Infrastructure
Data Mining

SharePoint Server 2007
SharePoint Business Intelligence
Evaluation Guide
Case Study: Microsoft Team Closes Books 33 Percent Faster, Files Financials 40 Percent Sooner

Data Mining
SQL Server Data Mining
Webcast: Building Adaptive Applications with SQL Server Data Mining
Video: SQL Server 2008 Data Mining Enhancements

Dynamics
Microsoft Dynamics-Everyone Gets It
Evaluate Microsoft Dynamics—What is Microsoft Dynamics?
Dynamic Communities
Microsoft Dynamics AX 2009
Microsoft Dynamics Integration with Microsoft Technologies
Whitepaper: Evaluating Financial Management Software…Is it time for a change?

Technical Forums
PPS Monitoring and Analytics
PPS Planning
ProClarity
SQL Server Reporting Services
SQL Server Analysis Services
SQL Server Integration Services
SQL Server Database Engine
Data Mining

Case Studies
Oticon, Gemplus, Capella, Premier Bankcard, ITV, Coppin State University, Amaren, Potbelly Sandwich Works, Illinois Dept of Transportation, GPX International Tire Corp, OSIsoft, Community Health Network, The Credit Valley Hospital, Graham Field Health Products, University of Gothenburg, Heel Inc., Sentara Healthcare, Wandsworth Primary Care Trust, Charlotte Mecklenburg Schools, Culver Franchising Systems, Inc., Wenatex, American of Martinsville, Westminster City Council

Microsoft & BI Blogs
The Microsoft PerformancePoint Team Blog
The BI Blog
Intelligent Insight on PerformancePoint – PerformancePoint Server
Adrian Downe’s Blog – Great 7 Part Series on PPS Planning Features!
Ian Tien’s Unofficial PerformancePoint Server and Business Scorecard Manager Blog
Microsoft BI Blog – by Patrick Husting
Nick Barclay’s BI Blog –PerformancePoint Server resources
Norm’s PerformancePoint Server Blog
Patrick Baumgartner’s Unofficial PPS Blog
Chris Webb’s BI Blog – MDXtreme Programming
Vidas Matelis BI Blog – SQL 2005 resources
Sacha Tomey’s blog – Molding the Microsoft BI Stack
Microsoft OLAP by Mosha Pasumansky – Deep Insights into SSAS & MDX
Prologika (Teo Lachev’s Weblog) – Reporting Services insights
Direct Reports (Brian Welcker’s Weblog) - Reporting Services
The Data Puzzle
Notes from the Field – Pete Sprague’s PerformancePoint and Microsoft BI blog
Microsoft Excel – team blog for Excel & Excel Services
Reporting Services – team blog for SQL Server Reporting Services
DBCF – Database Consolidation Framework
Jason Morales’ Microsoft BI Update
Howard @ MSFT selling BI
Alan Whitehouse’s Ramblings – Solution Architect at TGO Consulting working with PerformancePoint

Business Intelligence Virtual Labs
Try out a BI virtual lab to test out the technology stack, including:
Analysis Services, Excel 2007, ProClarity, Report Builder, Integration Services, Data Mining

OLAP Report - summaries
Preview of PerformancePoint Server 2007
Market share analysis
SQL Server Analysis Services 2005 (Microsoft)
What is OLAP?
Commentary: Business Intelligence Competency Centers

Dimensional Relational vs. OLAP: The Final Deployment Conundrum

Other Recommended Reading
Drive Business Performance
Performance Dashboards: Measuring, Monitoring, and Managing Your Business
Business Dashboards: A Visual Catalog for Design and Deployment – not yet released

Analyst Reports
AMR Research: Microsoft’s Looming Impact on the Business Intelligence and Performance Management Market
Forrester Report Detail BPM Growth and Market Leadership
Gartner: Microsoft Gets Gartner’s Business Intelligence Top Ranking
Gartner: Business intelligence ROI, value a matter of mind over money
IDC Report Sees Steady Growth for BI, Pent-Up Demand for Analytics

News Links & Press Releases
Microsoft Bundling for BI
Microsoft Aims to Spread BI Throughout the Enterprise
Microsoft to Add Muscle To SQL Server
Microsoft lays out SQL Server Improvements
Microsoft’s (un)secret weapon for winning the BI battle

Roles and Responsibilities in Business Intelligence Teams, Part 2
Special Report: Business Intelligence Gets Smart
New Rules for Performance Management, Part 1
Operational Performance: What Sets Best-In-Class Companies Apart?
Exploring Ethics in Business Intelligence
Using Enterprise 2.0 for Business Intelligence, Part 6
How BI could have provided early warning to financial market meltdown
Business intelligence oils the wheels of the oil sector profit

Tuesday, October 07, 2008

BI Conference in Seattle

I don't usually post my own comments but this event is a pretty big deal for me as it encompasses everything I do (from a career perspective).

This year the BI Conference was moved from May to October to align with Microsoft's pre/post releases. Last year, I was with Avanade and had a chance to meet a ton of people from all over the world interested in many if not all of the same things I am into with varying technical expertise. Microsoft and a few sponsors hosted events around Seattle's landmarks (Needle and Music Experience) which if you haven't been, I highly recommend it. Weather was awesome and I stayed at the Marriott by the pier. Anyway, meeting the various teams from Microsoft responsible for the development of SQL Server, SharePoint and of course my ultimate favorite Data Mining was awesome. I had a great time in every way last year. We partied like Rock Stars :)

This week, we have not only had Seattle's typical rain but a storm coming through and the winds have been rough. Back to the conference- One of the all time lead BI Evangelist, Bill Baker, left Microsoft this year and it has really disrupted the mood. Rather than technically driven sessions and deep dives into new product functionality, everything is overflowing with typical Marketing crap which I have no patience for and would rather have root canal than listen to. The new functionality of SQL 2008 and the promise of upgrades to PerformancePoint and SharePoint are always exciting but all the examples shown are of overly well formatted data and do not represent a real world experience. This was something Bill (I can call him that now that I have met him :) would focus on and specifically try to address with partners. Today, when you post to some of the Microsoft Blogs (not giving out names), there is a real chance you will not get a response except from someone else reading the post and now some blogs have turned that functionality off.

Microsoft is initiating a new (or maybe not so new) concept called "self service BI". This simplifies the access to BI type information through MS Office products namely Excel. Sounds all well and good but at the end of the day, process change is required and that isn't quite spelled out- who, what, etc... This so typical Microsoft, over simplify and spending twice as much time service packing the fallout (people and process). On the brighter side, the tools are getting alot easier and we at Solver are working hard to improve PerformancePoint Planning functionality. Our partner Orange Peel with us have developed a tool called BI Studio (Not BIDS) which addresses many areas of PerformancePoint Planning that are currently not addressed but required for true financial management (integration). We have had some great traction at the booth.

So that was the first day... Let's see what today has to offer.

Project Gemini

Microsoft OLAP by Mosha Pasumansky : So what is exactly “Project Gemini”: "So what is exactly “Project Gemini”
In the couple of hours since the announcement here at MS BI conference, I talked with few people already and saw few threads and comments in the Web, and (as expected), there is plenty of confusion about what “Project Gemini” is and isn’t etc. Here are the facts:
1. Project Gemini is the Analysis Services
2. It is next version of Analysis Services, which will ship before SQL11, as part of SQL Server “Kilimanjaro”
3. It uses column oriented processing and in memory storage as core technological principals"

Monday, September 29, 2008

Amazon.co.uk: Microsoft PerformancePoint 2007 for Dummies (For Dummies): Rachel Blum, Mark Chen: Books

Amazon.co.uk: Microsoft PerformancePoint 2007 for Dummies (For Dummies): Rachel Blum, Mark Chen: Books: "Microsoft PerformancePoint 2007 for Dummies (For Dummies) (Paperback)"

Kevin White's PerformancePoint Blog : A brief overview of PerformancePoint Planning business rules

Kevin White's PerformancePoint Blog : A brief overview of PerformancePoint Planning business rules: "Over the course of the past year I’ve had a number of conversations on what type of business rule to choose for a PerformancePoint model. The answer is always - ‘it depends’. Choosing the right type of business rule depends on the the context of your business requirements. For example, technical accuracy of a rule (i.e. Sales Volume * Product Price) can be done through any rule type - but choosing the right rule type requires you to consider how the resulting data is processed and stored in the system and how that impacts or aligns with your business requirements."

Friday, September 26, 2008

Jason Morales' Microsoft BI Update : Webcast Demo - PerformancePoint Dashboards for Dynamics AX

Jason Morales' Microsoft BI Update : Webcast Demo - PerformancePoint Dashboards for Dynamics AX: "I will be co-hosting an upcoming webcast demo showcasing PerformancePoint Dashboards for Dynamics AX.
Solver, a Microsoft Gold Certified partner, will provide the demo content.

Click here to register.

The webcast session is scheduled for a full hour.
The presentation will be about 30 minutes, and we'll be available for Questions for the remaining 30 minutes."

Tuesday, September 23, 2008

Business Intelligence for the IT Pro | TechNet Edge | TechNet Edge

Business Intelligence for the IT Pro TechNet Edge TechNet Edge: "Microsoft has just released a Business Intelligence framework solution for those of you out there running Systems Center Operations framework. This enables you as the IT Pro to enable web-based dashboards and scorecards about key performance of your overall IT systems. Since the typical IT Pro doesn't think much about BI I thought it would be a good idea to talk to Michael Tejedor the Senior Product Manager behind this solution. Michael gives us the inside scoop on the solution and it's architecture."

Tuesday, September 09, 2008

Microsoft to give away upgraded Hyper-V software | InfoWorld | News | 2008-09-08 | By Jeremy Kirk, IDG News Service

Microsoft to give away upgraded Hyper-V software InfoWorld News 2008-09-08 By Jeremy Kirk, IDG News Service: "Microsoft is set to release over the next 30 days an upgraded version of its Hyper-V technology for free, upping the game in the virtualization sector as it chases VMware.
Hyper-V, released in June, is included in most versions of Windows Server 2008. But the company has been charging $28 for a stand-alone version that could be downloaded from Microsoft's Web site."

Monday, September 08, 2008

DBA Morning Check List - SQL Server Central

DBA Morning Check List - SQL Server Central: "Database Administrators can sometimes have one of the most stressful jobs in the company. If you have been a DBA for long, you know the scenario. You have just sat in your chair with your cup of coffee, and your phone starts ringing off the hook. The voice on the other end states that they can't pull up their data or they are getting timeouts, or the system is running slow. Okay, time to dig in; it's going to be one of those days! Is it Friday yet?"

Wednesday, September 03, 2008

Best Practices Resource Center for SharePoint Server 2007

Best Practices Resource Center for SharePoint Server 2007: "To avoid common pitfalls and keep your Office SharePoint Server 2007 environment available and performing well, follow these best practices based on real-world experience from Microsoft Consulting Services and the product team."

Monday, August 11, 2008

Visual How Tos

Visual How Tos: "Visual How Tos"

Adding Code-Behind Files to Master Pages and Page Layouts in SharePoint Server 2007
Adding Custom Quick Access Buttons to the Page Editing Toolbar in SharePoint Server 2007
Adding Excel Web Parts to Pages Programmatically in SharePoint Server 2007
Building an Expense Report Approval Workflow for SharePoint Server 2007 Using Visual Studio 2008
Building Custom Activities for Use in SharePoint Designer 2007
Building Simple Custom Approval Workflows with InfoPath 2007 Forms
Building State Machine Document Approval Workflows for SharePoint Server 2007 Using Visual Studio 2008
Configuring and Deploying Workflows to SharePoint Server 2007 Using Solution Packages
Creating a Custom Approval Workflow for SharePoint Server 2007 Using SharePoint Designer 2007
Creating a Custom Expiration Formula Based on Metadata in SharePoint Server 2007 (Part 1 of 2)
Creating a Custom Expiration Formula Based on Metadata in SharePoint Server 2007 (Part 2 of 2)
Creating a Custom Search Page and Tabs in the Search Center of SharePoint Server
Creating and Editing Custom Document Information Panels from Office SharePoint Server 2007
Creating and Exposing Managed Properties in the Advanced Search Page of SharePoint Server Enterprise Search
Creating and Exposing Search Scopes in SharePoint Server 2007 Enterprise Search
Creating Business Data Catalog Entities in SharePoint Server 2007
Creating Content Sources to Crawl Business Data in SharePoint Server 2007 Enterprise Search
Creating Custom Enterprise Search Web Parts in SharePoint Server 2007
Creating Custom Routers in SharePoint Server 2007
Creating Custom Workflow Activities for SharePoint Server 2007 Using Visual Studio 2008
Creating Managed-Code UDFs for Excel Services
Creating Search Queries Programmatically by Using the Search Object Model in SharePoint Server 2007
Creating Search Queries Programmatically by Using the Search Web Service in SharePoint Server 2007
Creating User Profiles in the User Profile Store in SharePoint Server 2007
Creating Workflows to Transfer Records Upon Expiration in SharePoint Server 2007
Customizing Content Query Web Parts by Using Custom Properties in Office SharePoint Server 2007
Customizing Page Editing Toolbar Components in SharePoint Server 2007
Customizing Search Results with Custom XSLTs in SharePoint Server 2007
Designing InfoPath Forms for Workflows in SharePoint Server 2007
Developing Custom Applications by Using Excel Web Services in SharePoint Server 2007
Displaying Custom Fields in Content Query Web Parts in Office SharePoint Server 2007
Displaying Search Results in a Grid View in SharePoint Server 2007
Enabling Users to Act on LOB Data with Business Data Catalog Actions
Exposing Enterprise Search in SharePoint Server 2007 by Using Internet Explorer 7 and the Office Research Pane
Filtering One Business Data Catalog List from Another by Using Associations in SharePoint Server 2007
Putting Multiple Items on Hold in SharePoint Server 2007
Referencing and Linking: Using Custom Fields to Display Relationships in SharePoint Server 2007
Referencing and Linking: Using Secondary Lists to Maintain Relationships in SharePoint Server 2007
Referencing and Linking: Using the Asset URL Selector in SharePoint Server 2007
Refining Business Data Catalog Search with Scopes
Retrieving an Entire Workbook or a Snapshot of a Workbook in Excel Services
Updating Document Information Panels for Content Type Changes in SharePoint Server 2007
Using Business Data Catalog Actions to Pass Parameters to InfoPath 2007 Browser Forms
Using Metadata Tags to Route Documents to Libraries in SharePoint Server 2007

Tuesday, July 29, 2008

Download details: Windows Server 2003 Service Pack 1 32-bit Support Tools

Download details: Windows Server 2003 Service Pack 1 32-bit Support Tools: "The Windows Support Tools for Microsoft Windows Server 2003 are intended for use by Microsoft support personnel and experienced users to assist in diagnosing and resolving computer problems. For individual tool descriptions, see the Windows Support Tools documentation (Suptools.chm).

The Windows Support Tools for Windows Server 2003 Service Pack 1 can be installed only on a computer that is running Windows XP or Windows Server 2003 operating systems.

It is highly recommended that you remove all previous versions of Support Tools, including beta versions of the Windows Support Tools for Microsoft Windows Server 2003, before you run the Support Tools installation program."

Plan for administrative and service accounts (Office SharePoint Server)

Plan for administrative and service accounts (Office SharePoint Server): "About administrative and service accounts
Single server standard requirements
Server farm standard requirements
Least-privilege administration requirements when using domain user accounts
Least-privilege administration requirements when using SQL authentication
Least-privilege administration requirements when connecting to pre-created databases
Technical reference: Account requirements by scenarioAbout administrative and service accounts
Single server standard requirements
Server farm standard requirements
Least-privilege administration requirements when using domain user accounts
Least-privilege administration requirements when using SQL authentication
Least-privilege administration requirements when connecting to pre-created databases
Technical reference: Account requirements by scenario"

To the SharePoint

To the SharePoint: "We're the Microsoft SharePoint IT Pro documentation team. We're passionate about providing the right documentation for anyone who is planning, designing, deploying, managing, or supporting SharePoint in their environment.
Our blog is intended to:
Help you find relevant and/or new content on TechNet
Highlight product features and associated content
Let you know when we make major updates to a content area
Preview content for new releases as early as we can (even before we publish it on the TechNet Library)
We'd love to hear your suggestions about ways we can improve content for you! In particular, we’d like to know about your pain points. What don’t we cover that you need? Does the content organization make sense?"

Wednesday, July 23, 2008

Download details: Microsoft Office Outlook Connector 12.1

Download details: Microsoft Office Outlook Connector 12.1

With Microsoft Office Outlook Connector, you can use Microsoft Office Outlook 2003 or Microsoft Office Outlook 2007 to access and manage your Microsoft Windows Live Hotmail or Microsoft Office Live Mail accounts, including e-mail messages, contacts and calendars for free!

Monday, July 21, 2008

PerformancePoint Implmentation Best Practices

Whitepaper I wrote for HP.

Here's a direct link to the page:

http://h71019.www7.hp.com/ActiveAnswers/library/GetPage.aspx?pageid=600251&statusid=0&audienceid=0&ccid=0&langid=121

It's also available on the SQL Solutions page on HP ActiveAnswers:

http://h71019.www7.hp.com/ActiveAnswers/cache/70729-0-0-0-121.html

White papers: Master data management

White papers: Master data management: "This series of white papers discusses a centralized approach to defining, deploying, and managing master data and hierarchies. When the series is complete, there will be a total of six white papers. Two are available at this time, with the first paper consisting of two parts. There are links to the papers below. They can be downloaded as Microsoft Word (.doc) files."

Thursday, July 03, 2008

Run IT on a Virtual Hard Disk

Run IT on a Virtual Hard Disk: "Run IT on a Virtual Hard Disk
The Microsoft VHD format is the common virtualization file format that provides a uniform product support system, and provides more seamless manageability, security, reliability and cost-efficiency for customers."

Monday, June 30, 2008

Compare SQL Server Enterprise & Standard Editions - Business Intelligence features

Jason Morales' Microsoft BI Update : Compare SQL Server Enterprise & Standard Editions - Business Intelligence features:

Enterprise & Standard Edition Feature Comparisons:
- Microsoft SQL Server 2008
- Microsoft SQL Server 2005

Business Intelligence features of SQL Server Enterprise Edition:
(that are not in the Standard Edition)

Advanced Analytics
- Account intelligence
- Linked measures and dimensions
- Perspectives
- Semiadditive measures
- Writeback dimensions
Scalability and Performance
- Proactive caching
- Partitioned cubes and distributed partitioned cubes
- Auto parallel partition processing
Integration Services
- Data mining query transformation
- Data mining model training destination adapter
- Fuzzy Grouping transformation
- Fuzzy Lookup transformation
- Term Extraction transformation
- Dimension processing destination adapter
- Partition processing destination adapter
Reporting Services
- Data-driven subscriptions
- Report scale-out deployment
- Infinite clickthrough in ad-hoc reports
- Scale-out operational report configuration**
Data Warehousing
- Data compression**
- Star join query optimizations**
- Change data capture (CDC)**
- Scalable data marts and reporting**
Data Mining
- Parallelism for model processing & prediction
- Advanced Data Mining algorithms with algorithm plug-in API
- Advanced configuration and tuning options for data mining algorithms
- Time series capabilities**

** double-star denotes feature of SQL Server 2008
Introduction to New Data Warehouse Scalability Features in SQL Server 2008


PerformancePoint Planning Server requires SQL Server 2005 Enterprise Edition
PerformancePoint Monitoring and Analytics do not require SQL Enterprise Edition, although features listed above may compel upgrade

Tuesday, June 24, 2008

Microsoft SharePoint Sales To Hit $1 Billion In 2008 -- Microsoft -- InformationWeek

Microsoft SharePoint Sales To Hit $1 Billion In 2008 -- Microsoft -- InformationWeek: "With more companies looking to make critical information easily accessible to and shareable with employees, Microsoft (NSDQ: MSFT) said Monday that it expects total sales of its SharePoint online collaboration software will surpass the $1 billion mark in 2008."

Monday, June 09, 2008

Jason Morales' Microsoft BI Update v.21 - June

Please bookmark my blog site, link to it, sign up for feeds, and forward to friends!


Contents:
Upcoming Events
Upcoming Webcasts
Training: online and regional options
Resources: whitepapers, case studies, datasheets, webcasts, books, etc
News Links and Press Releases


Hot Topics

PerformancePoint Webcast Demo – hosted by Jason Morales
June 17, 11am (PDT)


Announcing PerformancePoint Server 2007 Service Pack 1
The Payoff of Pervasive Performance Management
Results from The BI Survey 7
‘The BI Survey 7’ Details Purchase Practices, Ranks Loyalty by Brand
Business intelligence and data warehousing salaries continue to rise

New Case Studies: GPX International Tire Corp, OSIsoft, Community Health Network, The Credit Valley Hospital, Graham Field Health Products, University of Gothenburg, Heel Inc.

BI Video by Role – CFO, Operations Manager, IT Director, Sales Manager
Subscribe to Microsoft Business Intelligence Newsletter

Upcoming Events

Business Intelligence Using the Microsoft BI Suite
Craig Utley, Tech-Ed Pre-Conference Seminar
June 9, 9:30am-6pm
Orlando, FL
Click here to register

How does it all stack up?
6 part Seminar Series, sponsored by Inetium & Microsoft
June 26, July 17, Aug 7 & 28, Sept 18
Omaha, NE
Click here to register

SQL Server User Group
Featuring Kalen Delaney, author of “Inside SQL Server
June 25, 5:30pm
Boise, ID
Click here to learn more

Dashboard in a Day – sponsored by Quilogy
Kansas City, MO: Sept 9
Fairview Heights, IL: Sept 11
Omaha, NE: Sept 16
Chicago, IL: Sept 18
Click here to learn more and register

Microsoft BI Conference
Oct 6-8
Seattle, WA
www.microsoftbiconference.com

Find Events & Webcasts

Upcoming Webcasts

PerformancePoint Server Webcast Demo
Click here to register:
June 17, 11am (Pacific Time)
July 15, 11am
July 29, 11am

PerformancePoint Server 2007: Planning Implementation…
June 10, 8am (Pacific Time)
Click here to register

PerformancePoint Server 2007: M&A Implementation…
June 12, 11:30am (Pacific Time)
Click here to register

Achieving Business Intelligence Across the Enterprise
June 19, 9am (Pacific Time) – Streamline Reporting
July 17, 9am – Increase Accessibility of Information
Aug 21, 9am – Maximize Business Performance
Sept 18, 9am – Realize Fast & Effective Planning, Budgeting & Forecasting

Training

PerformancePoint Server 2007 Training Sites
Online: PPS Planning, Monitoring and Analytics (includes videos and workbooks)
Online: ProClarity

Hitachi Consulting
Business Intelligence Education Services
Microsoft BI Bootcamp (4 day) - click here for more info
Seattle, WA: June 30-July 3
London, UK: July 7-10

Solid Quality Mentors
BI Courses, including SQL 2005, PPS and ProClarity
Microsoft BI Bootcamp (5 day) - Click here for more info
Bellevue, WA: June 9-13
Beaverton, OR: Sept 8-12

IT Mentors
Microsoft Office PerformancePoint Server 2007 Monitoring & Analytics

Premier Knowledge Solutions
BI Courses, including SQL 2005, PPS and ProClarity
Microsoft BI Bootcamp (5 day) – click here for more info
St. Louis, MO: Aug 4-8

AppDev – CD-ROM & DVD-ROM Training
SQL Server 2005 and BI Learning Suite

SQL Server Training Courses
Online & Instructor led

Partner Program – webcasts
Online Training Webcasts - (keyword = performancepoint)

Resources

Microsoft BI
Whitepapers
Demos
Product Evaluations
Consulting Partner Directory


PerformancePoint Server 2007
System Requirements

Technical Forums: PPS Monitoring and Analytics, PPS Planning
Flash Demo: Virtual Experience
Datasheets: Overview, Monitor, Analyze, Plan, Management Reporting
Case Studies: Energizer, Oticon, Skanska, Gemplus, Capella, CompUSA, Premier Bankcard, ITV, Coppin State University, Amaren, Potbelly Sandwich Works; Illinois Dept of Transportation
Video: PerformancePoint Server Team Video
Wikis: Wikipedia, Channel 9

On-Demand Webcasts of PerformancePoint Server 2007

Books on PerformancePoint Server 2007
The Rational Guide to Monitoring and Analyzing with…
The Rational Guide to Planning with…
Business Intelligence with…
Drive Business Performance
Pro PerformancePoint Server 2007 (not released yet)

Downloadable Books for PerformancePoint Server 2007
PPS Technical Library
PPS Developer Portal

Download PerformancePoint Server 2007 Evaluation Version (x86)
Download PerformancePoint Server 2007 Evaluation Version (x64)
Sample Data : Monitoring, Planning
Data Import Wizard for Microsoft Dynamics AX Tool here
Scorecard Migration Tool here

ProClarity
Technical Forum: ProClarity
Search the Support Knowledge Base
Microsoft ProClarity Software Developer’s Kit 6.3

PerformancePoint 2007 Management Reporter
Overview

SQL Server 2005
Best Practices
SQL Server 2005 Business Intelligence
BI Presentations
SQL Server 2005 – Learning Portal
Archived Webcasts, Virtual Labs and Podcasts
Microsoft SQL Server 2005: Scales to your growing business needs

Technical Forums: SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Database Engine
Case Studies: Kelley Blue Book, National Aquarium, Barnes & Noble, Children’s Hospital of Philadelphia, Danske Supermarket, Citi, TDC, Acosta
Book: The Microsoft Data Warehouse Toolkit: With SQL Server 2005…
Channel 9: Business Intelligence Platform Overview

SQL Server 2008
Business Intelligence
Data Warehousing
Performance Improvements for MDX in AS 2008
Evaluate: SQL Server 2008 – latest CTP trial software
Demo: SQL Server 2008 Overview
Videos: SQL Server 2008 Business Intelligence
Datasheet: Business Intelligence
Whitepaper: Business Intelligence, Data Warehousing

SQL Server 2008 Virtual Labs:
Data Mining with SQL Server 2008

SQL Server 2008 Analysis Services: Delivering Analysis Services capabilities through Microsoft Office
SQL Server 2008 Reporting Services- Managing the Report Services Infrastructure
SQL Server Analysis Services- Managing Analysis Services Solutions


Analysis Services
Microsoft SQL Server 2005 Analysis Services Step by Step
Microsoft SQL Server 2005 Analysis Services (Paperback)
Applied Microsoft Analysis Services 2005… (Paperback)
Delivering Business Intelligence with… (Paperback)
Microsoft Technet Whitepapers
Whitepaper: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services

SharePoint Server 2007
SharePoint Business Intelligence
Evaluation Guide
Case Study: Microsoft Team Closes Books 33 Percent Faster, Files Financials 40 Percent Sooner

Data Mining
SQL Server Data Mining
Technical Forum: Data Mining
Webcast: Building Adaptive Applications with SQL Server Data Mining
Video: SQL Server 2008 Data Mining Enhancements

Dynamics
Microsoft Dynamics-Everyone Gets It
Evaluate Microsoft Dynamics—What is Microsoft Dynamics?
Whitepaper: Evaluating Financial Management Software…Is it time for a change?

Dynamics AX 2009 Gets Role Center, Ribbon UI
Microsoft Dynamics CRM 4.0 Ready for Download
Microsoft Offers ‘Premier’ Support for Dynamics

Microsoft & BI Blogs
The Microsoft PerformancePoint Team Blog
The BI Blog
Intelligent Insight on PerformancePoint – PerformancePoint Server
Adrian Downe’s Blog – Great 7 Part Series on PPS Planning Features!
Ian Tien’s Unofficial PerformancePoint Server and Business Scorecard Manager Blog
Microsoft BI Blog – by Patrick Husting
Nick Barclay’s BI Blog –PerformancePoint Server resources
Norm’s PerformancePoint Server Blog
Patrick Baumgartner’s Unofficial PPS Blog
Chris Webb’s BI Blog – MDXtreme Programming
Vidas Matelis BI Blog – SQL 2005 resources
Sacha Tomey’s blog – Molding the Microsoft BI Stack
Microsoft OLAP by Mosha Pasumansky – Deep Insights into SSAS & MDX
Prologika (Teo Lachev’s Weblog) – Reporting Services insights
Direct Reports (Brian Welcker’s Weblog) - Reporting Services
The Data Puzzle
Notes from the Field – Pete Sprague’s PerformancePoint and Microsoft BI blog
Microsoft Excel – team blog for Excel & Excel Services
Reporting Services – team blog for SQL Server Reporting Services
DBCF – Database Consolidation Framework

OLAP Report - summaries
Preview of PerformancePoint Server 2007
Market share analysis
SQL Server Analysis Services 2005 (Microsoft)
What is OLAP?
Commentary: Business Intelligence Competency Centers

Dimensional Relational vs. OLAP: The Final Deployment Conundrum

Analyst Reports
AMR Research: Microsoft’s Looming Impact on the Business Intelligence and Performance Management Market
Forrester Report Detail BPM Growth and Market Leadership
Gartner: Microsoft Gets Gartner’s Business Intelligence Top Ranking
Gartner: Business intelligence ROI, value a matter of mind over money


Business Intelligence Virtual Labs
Try out a business intelligence virtual lab to test out the technology stack, including:
· Analysis Services
· Excel 2007
· Business Scorecard Manager 2005 (BSM)
· ProClarity
· Report Builder
· Integration Services
· Data Mining

News Links & Press Releases

What is Microsoft PerformancePoint Server 2007?
The Next Stage of Workplace Evolution
The Next Big thing in BI by Bill Baker
Microsoft’s CFO Chris Liddell

Performance Management Goes Green
Self-Service Business Intelligence Is a Myth
Business Intelligence and the IT Portfolio
Using Enterprise 2.0 for Business Intelligence, Part 4Analytic Culture – Does It Matter?