Friday, November 6, 2009

November 2009 v.31 - Business Intelligence Update

.

HOT TOPICS

SQL Pass - Seattle, Nov 2-5

SQL Server 2008 R2 - Managed Self Service Business Intelligence
http://www.powerpivot.com/ for Excel 2010
Blog: Excel 2010, Interacting with Slicers
Bruno Aziza interviews Stephon Elop, President of Microsoft's Business Division

deFacto... a new alternative to PerformancePoint Planning?


WEBCASTS
All webcast times are in Eastern Time Zone unless otherwise specified

Emerge Stronger with Microsoft Business Intelligence
Hosted by Microsoft
Nov 9, 2pm
Click here for more info

deFacto Performance Management Webinar
Hosted by deFacto Global
Nov 10, 12pm
Nov 19, 2pm
Nov 24, 12pm
Click here for more info

Increase Transparency Through Business Intelligence
Hosted by MicroLink LLC
Nov 12, 2pm
Click here for more info

Emerge Stronger with Microsoft BI: Operational Improvement
Hosted by Microsoft
Nov 17, 2pm
Click here for more info

How Hospitals Use Microsoft Technology to Manage Clinical Trials
Hosted by Quilogy
Nov 18, 1pm
Click here for more info

Turn insight into a winning strategy with cost-effective BI solutions
Hosted by twentysix New York
Dec 1, 2pm
Click here for more info

Emerge Stronger with Microsoft BI: Sales and Marketing
Hosted by Microsoft
Jan 26, 2pm
Click here for more info


EVENTS

TDWI World Conference
Hosted by The Data Warehouse Institute
Nov 1-6, Orlando, FL
Click here for more info

SQL PASS
Hosted by Microsoft
Nov 2-5, Seattle, WA
Click here for more info


SharePoint Unleashed
Hosted by Microsoft
Nov 3, Irvine, CA
Click here for more info

Discover Business Intelligence Capabilities within SharePoint
Hosted by Microsoft
Nov 3, Denver, CO
Click here for more info

SoCal BI User Group
Hosted by Xelleration
Nov 5, Irvine, CA
Click here for more info

Data Warehousing and Business Intelligence Strategies for the New Economy
Hosted by Hitachi Consulting
Nov 5, Denver, CO
Nov 10, San Francisco, CA
Nov 11, Los Angeles, CA
Click here for more info

Los Angeles SQL Server Professionals Group
Nov 19, Los Angeles, CA
Click here for more info

Microsoft Reporting Services and Business Intelligence
Hosted by CSG Professionals
Nov 24, Portland, OR
Click here for more info


TRAINING

Web-based Training

SQL Server: Training Portal
SharePoint Server 2007: Training Portal
PerformancePoint Monitoring & Analytics: Dashboard basics I, Dashboard Basics II
Excel 2007: Training Courses


In-Person Training

Enterprise ETL with SSIS
Solid Quality Mentors
Nov 9, Beaverton, OR
Click here for more info

SQL Server 2008 Fast Track Data Warehouse
Solid Quality Mentors
Nov 13, Irving, TX
Nov 17, Reston, VA
Nov 19, Iselin, NJ
Nov 20, Chicago, IL
Click here for more info

SQL Server 2008 End-to-End Business Intelligence Workshop
Solid Quality Mentors
Dec 7, Bellevue, WA
Click here for more info

Microsoft BI Bootcamp
Solid Quality Mentors
Dec 14, Beaverton, OR
Click here for more info


RESOURCES
Microsoft BI
CapstoneBI Architects
Notes from the Field

SQL Server
Business Intelligence: SQL 2005, SQL 2008
Data Mining: SQL 2005, SQL 2008
Whitepaper: New Data Warehouse Scalability Features in SQL Server
Whitepaper: Predictive Analysis with SQL Server 2008
Whitepaper: Introducing Microsoft StreamInsight
OLAP Heartbeat - monitor activity on Analysis Services

SQL Server 2008: Project "Madison"
Blog: Introduction to SQL Server Project Madison

SSIS: Kimball Method SSIS Slowly Changing Dimension Component
Blog: Formatting Linked Server MDX Query Results Using CTEs

SSAS: SQL Sentry, Performance Optimization Software
SSAS: list of front end applications


SharePoint Server
Business Intelligence: Overview, Using BI Features

PerformancePoint: Technical Library
Download: PerformancePoint SP2 (64-bit or 32-bit)
Whitepaper: Publishing PerformancePoint Server in Extranet Scenarios
Whitepaper: Accessing large scale ROLAP environments with PerformancePoint Server 2007

Office 2010
PowerPivot
http://www.powerpivot.com/ for Excel 2010
Blog: Using PowerPivot with Excel 2010


Related BI Resources
Caveman Forecaster - great resource for data mining/time series formatting
Federal IT Dashboard
http://it.usaspending.gov/ - track Stimulus Spending
Data.gov Catalogs, FAQ


NEWS AND PRESS RELEASES

Microsoft sets SQL Server 2008 R2 preview
Q&A: Business Intelligence gets a facelift in SQL Server 2008 R2
Microsoft Previews SQL Server Upgrades, In-Memory Analysis
End of life comes for SQL Server 2005 SP2

DBA career paths could lead to business intelligence

Peter Drucker as Life Coach: Book Shares His Wisdom


.