Tuesday, April 6, 2010

April 2010 v.36 – Business Intelligence Update

President Obama Appoints Edward Tufte – Big Victory for Data Visualization And Transparent Government
Obama’s Data Visionary

Why Predictive Analytics Is A Game-Changer

SQL Server 2008 R2 gets an official date
Microsoft ships the final Technology Preview for SQL 2008 R2 Parallel Data Warehouse
Overview: Parallel Data Warehouse
New Data Visualizations in SQL Server Reporting Services 2008 R2

Tableau Public – How it Works Blog: Tableau Public - A Powerful New Tool for Democratizing Data

Kerberos SPN Generation Setup Tool – RobertLambrecht.com

All webcast times are in Eastern Time Zone unless otherwise specified

System Center Service Manager 2010: The CMDB, Connectors, and Data Warehouse
Hosted by Microsoft
Apr 2, 2pm
Click here for more info

Unleash the Power of PowerPivot
Hosted by Panorama
Apr 20, 10am
Click here for more info

Insight Through Microsoft Business Intelligence Solutions
Hosted by ComFrame
Apr 22, 10am
Click here for more info

Visualizing Success – Visualization with SharePoint PerformancePoint Services
Hosted by Mariner
Apr 29, 8:30am
Click here for more info


Executive Business Intelligence Roundtable
Hosted by ComFrame
Apr 13, Jackson, MS
Click here for more info

Business Insight Lunch and Learn
Hosted by MPS Partners and Microsoft
Apr 20, Granger, IN
Click here for more info

Convergence 2010
Hosted by Microsoft
Apr 24-27, Atlanta, GA
Click here for more info

SQL Saturday #39 NYC
Hosted by NJ SQL Server User Group in NYC
Apr 24, New York, NY
Click here for more info

Microsoft Business Intelligence
Hosted by Quilogy
May 4, Naperville IL
Click here for more info

TechFuse 2010
Hosted by Benchmark Learning
May 6, Bloomington, MN
Click here for more info

Microsoft Business Intelligence Conference
Hosted by Microsoft
Jun 7-10, New Orleans, LA
Click here for more info


Web-based Training
SQL Server: Training Portal
SharePoint 2007: Training Portal
SharePoint 2010: Getting Started with SharePoint 2010
PerformancePoint Monitoring and Analytics: Dashboard basics IDashboard basics II
Up to Speed with PerformancePoint Dashboards and Web Parts
Excel 2007: Training Courses

Instructor Led Training
SQL Server and Business Intelligence Training
Pragmatic Works
April Courses, Online
Click here for more info

SQL Server Reporting Services (SSRS) Training
Apr 7-9, Minneapolis, MN
Click here for more info

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Apr 12-14, Online
Click here for more info

Solving Business Problems with MDX in SQL Server 2008
Solid Quality Mentors
Jun 15-17, Minneapolis, MN
Click here for more info


Microsoft BI
2010 Betas are here, including Office, SharePoint, Project, Visio

SQL Server Business Intelligence: SQL 2005, SQL 2008
SSAS: SQL Sentry, Performance Optimization Software
SSAS: list of front end applications
Data Mining: SQL 2005, SQL 2008
StreamInsight: Versions and SQL Server SKUs, Developers Training Kit
SQL Server 2008 R2 gets an official date

Download: SQL Server 2008 R2 November CTP
Hands On Lab: PowerPivot in SQL Server 2008 R2
SQL 2008 R2: Home, Parallel Data Warehouse
Whitepaper: Best Practices for Data Warehousing with SQL Server 2008

SQL 2008 Books Online: Planning and Architecture (Analysis Services – Data Mining)
SQL 2008 Books Online: Architecture of Integration Services
Whitepaper: Top 10 Performance and Productivity Reasons to Use SQL Server 2008 for Your Business Intelligence Solutions
Blog: SQL Server 2008 for Oracle DBA

SharePoint Server 2007
Business Intelligence: Overview, Using BI Features
Technical Library
Download: PerformancePoint SP2 (64-bit or 32-bit) Blog: Using Excel Services Reports with PerformancePoint Server (PPS)
Online Book: SharePoint guidance for SQL Server database administrators

SharePoint Server 2010
Describing SharePoint 2010 in 1 Sentence, 8 Categories and 40 Feature Areas
New Features in PerformancePoint Services 2010

Excel Services in SharePoint 2010 Feature Support, Dashboard Improvements, Upgrading PerformancePoint Server 2007 to PerformancePoint 2010
Planning for Upgrade from SharePoint Portal Server 2003 to SharePoint Server 2010
Blog: What is Time Intelligence?

Office 2010
PowerPivot Team Blog
The Great PowerPivot FAQ

Download: PowerPivot for Excel 2010
Blog: The Business User’s Perspective
Blog: How PowerPivot and SSAS could work together
Blog: Diagnostic Guide for Usage and the PowerPivot Management Dashboard
Screencast: Using datamining with PowerPivot in Excel

Microsoft BI Certifications
Blog: New 2008 Microsoft BI Certifications Reviewed
Blog: Obtaining Microsoft BI Certification
Learning Plan: BI Developer
Exam: 70-448
Exam: 70-452

Related BI Resources
Notes from the Field

Article: Microsoft PowerPivot vs. Tableau
Blog: Using a Data Warehouse for CRM
Blog: Thoughts on: Who are the BI Personas?

Strategy Companion’s Analyzer Named 2009 EDITOR’S BEST Award by SQL Server Magazine


A High Level Comparison Between Oracle and SQL Server
SharePoint 2010 Steps Up to the ECM Plate
SharePoint 2010: A More Viable Cloud Option
SharePoint 2010: An Evolutionary Step Toward Content-Centric Middleware

Launching an Analytics Practice: Ten Steps to Success
Zen BI: The Wisdom of Letting Go
It Takes a Village to Drive Predictive Analytics

Blog: PowerPivot/Excel/SharePoint and SSRS – should they merge?
Blog: Comparing Analysis Services and PowerPivot
Blog: Great Visualizers: Mike Deal Charts the Beatles


  1. Very nice list as always. Just thought I would include the links for SP3 for PPS 2007 - PerformancePoint Server 2007 Service Pack 3 (x64)[http://www.microsoft.com/downloads/info.aspx?na=47&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=cbbf9377-0220-4714-9517-2a99279258af&u=details.aspx%3ffamilyid%3d3AD75AE5-D2CD-4953-87CF-5F74D79804C6] PerformancePoint Server 2007 Service Pack 3 (x86)[http://www.microsoft.com/downloads/info.aspx?na=47&p=3&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=cbbf9377-0220-4714-9517-2a99279258af&u=details.aspx%3ffamilyid%3d90C596A5-ACA4-4DED-9072-FACF834BC0C6], a few virtual lab links: TechNet BI Labs [http://denglishbi.spaces.live.com/blog/cns!CD3E77E793DF6178!349.entry] and PowerPivot [https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d], there is also a new certification that I haven't had a chance to do yet 78-702 [http://www.microsoft.com/learning/en/us/Exam.aspx?ID=78-702] Designing and Managing a Microsoft Business Intelligence Solution, and there is a free eLearning course you can take to prep for this as well - 5046AE: Inside Look at Building and Developing Solutions with Microsoft Office SharePoint Server 2007 (2 Hours) [http://www.microsoft.com/learning/elearning/course/5046.asp]. They still have the PPS 2007 training videos available as well that people can check out in regards to M&A - http://www.microsoft.com/business/performancepoint/learning/training.aspx.

  2. Thanks Dan! I agree and I'll add the links you mention to next month's update.

    As you know, I refer to your blog for resources all the time... great posts!


  3. Dear Sir,

    I have the pleasure to brief on our Data Visualization software
    "Trend Compass".

    TC is a new concept in viewing statistics and trends in an animated
    way by displaying in one chart 5 axis (X, Y, Time, Bubble size &
    Bubble color) instead of just the traditional X and Y axis. It could
    be used in analysis, research, presentation etc. In the banking
    sector, we have Deutsche Bank New York as our client.

    Link on Chile's Earthquake (27/02/2010):


    This a link on weather data :


    This is a bank link to compare Deposits, Withdrawals and numbers of
    Customers for different branches over time ( all in 1 Chart) :


    Misc Examples :


    This is a project we did with Princeton University on US unemployment :

    A 3 minutes video presentation of above by Professor Alan Krueger
    Bendheim Professor of Economics and Public Affairs at Princeton
    University and currently Chief Economist at the US Treasury using
    Trend Compass :

    Latest financial links on the Central Bank of Egypt:


    I hope you could evaluate it and give me your comments. So many ideas
    are there.

    You can download a trial version. It has a feature to export
    EXE,PPS,HTML and AVI files. The most impressive is the AVI since you
    can record Audio/Video for the charts you create.


    All the best.

    Epic Systems