SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

Hot Topics

The Next Big thing in BI by Bill Baker
Subscribe to Microsoft Business Intelligence Newsletter

Notes from the Field – Building Great Cubes: Tip 1 – Less is More

Training: Microsoft BI Bootcamps
Minneapolis, MN: 5/19-23
Beaverton, OR: 6/9-13
Click here for more info

New Case Study: Illinois Dept of Transportation

Upcoming Events

Developing Microsoft BI Solutions…
Peter Dryers, Tech-Ed Pre-Conference Seminar
June 2, 9am-6pm
Orlando, FL
Click here to register

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

Tech-Ed 2008
June 3-6 (Developers); June 10-13 (IT Professionals)
Orlando, FL
Click here to register

Selling Microsoft Business Intelligence for Partners
Tips and Tricks and Best Practices from a Sales & Technical Perspective
June 5, 8am-1pm (PDT)
Bellevue, WA
Click here to register

How does it all stack up?
6 part Seminar Series, sponsored by Inetium & Microsoft
June 5 & 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

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

Find Events & Webcasts

Upcoming Webcasts

PerformancePoint Server Webcast Demo
Click here to register:
May 20, 11am (PDT)
June 3, 11am (PDT)
June 17, 11am (PDT)

24 Hours of SQL Server 2008
Reach Users with the 2007 Office System
May 27, 12pm (PDT)
Click here to register

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

Training

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

Hitachi Consulting
Business Intelligence Education Services
Microsoft BI Bootcamp (3 day) - click here for more info

Solid Quality Mentors
BI Courses, including SQL 2005, PPS and ProClarity
Microsoft BI Bootcamp (5 day) - click here for more info

IT Mentors
Microsoft Office PerformancePoint Server 2007 Monitoring & Analytics

Premier Knowledge Solutions
ProClarity Training

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
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…
Pro PerformancePoint Server 2007 (not released yet)
Drive Business Performance (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
SQL 2008 CTP, November 2007
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

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?

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?
Podcast: Microsoft PerformancePoint Server basics…
SQL Server 2008 To Offer Spatial Data Type Support
Microsoft Confirms SQL Server 2005 SP3
Dynamics CRM Online now available
Microsoft Sets Sights on Data Mining Dominance

Business Intelligence and the Federal Brain Drain
Business Analytics – Getting the Point
The Most Successful Business Intelligence Tool
Is BI a Commodity?
How To Choose Among The Four Bright Lights Of BI
Your Business Intelligence Program
Gartner Business Intelligence Summit: Embed BI within business processes
Business intelligence demands an optimal services provider
Danger – BPM Ahead, Part 1
Implementing a Successful Business Intelligence Competency Center
Why Are Data Warehouses Growing So Fast?
Web 2.0 and Business Intelligence – How Do They Fit Together? Part 4
Business Intelligence and the Federal Brain Drain
Your Business Intelligence Program
Determining the Best BI Deployment Strategy
Data Warehousing Architecture
Data mashups meet business intelligence : “Bashups” explained
Gaining Insight through Analytics – It Takes More than OLAP
Communication in Business Intelligence Teams
Forrester Sees Convergence Trend In BI, Search
BI: Transforming Data Into Usable Information
Spreadsheet “Worst Practices”