Showing posts with label MDX. Show all posts
Showing posts with label MDX. Show all posts

Tuesday, April 6, 2010

April 2010 v.36 – Business Intelligence Update


.
HOT TOPICS
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

WEBCASTS
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

EVENTS

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

TRAINING

Web-based Training
SQL Server: Training Portal
SharePoint 2007: Training Portal
SharePoint 2010: Getting Started with SharePoint 2010
PerformancePoint Monitoring and Analytics: Dashboard basics I,  Dashboard 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
Intertech
Apr 7-9, Minneapolis, MN
Click here for more info

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Accelebrate
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

RESOURCES

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
PerformancePoint:
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
www.PowerPivot.com
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

NEWS AND PRESS RELEASES

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
.

Wednesday, December 2, 2009

December 2009 v.32 - Business Intelligence Update

.

HOT TOPICS

2010 Betas are here, including Office, SharePoint, Project & Visio

PowerPivot Team Blog
Download: PowerPivot for Excel 2010
Blog: The Business User's Perspective

Demo: Extended Outlook - Put your business intelligence reporting inside Microsoft Outlook

CapstoneBI Blog: Analysis Services 2008 Metadata Report Pack


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

Beat the Competition with the Power of Analytics
Hosted by Panorama
Dec 3, 2pm
Click here for more info

FEDSPUG December Meeting (Webcast)
Hosted by Microsoft
Dec 3, 2pm
Click here for more info

SharePoint 2010 Preview
Hosted by Gig Werks
Dec 8, 1pm
Click here for more info

Is Your Data Warehousing Project Doomed from the Beginning?
Hosted by B2B Technologies
Dec 10, 12:30pm
Click here for more info

Best Practices for Pervasive BI
Hosted by Strategy Companion
Dec 10, 1pm
Click here for more info

Build More Powerful Solutions with Bing Maps
Hosted by Microsoft
Dec 10, 1pm
Click here for more info

Portfolio Management and Capital Planning with Microsoft Solutions
Hosted by Projility
Dec 12, 1pm
Click here for more info

Looping, Moving Files, and Splitting Data Streams: Intermediate SSIS Tasks for the DBA
Hosted by PASS DW/BI Virtual Chapter, with guest speaker Tim Mitchell
Dec 15, 12pm
Click here to attend

Zero to Cube in 60 minutes
Hosted by PASS DW/BI Virtual Chapter, with guest speaker Adam Jorgensen
Dec 18, 12pm
Click here to attend

The Many-to-Many Compression Algorithm
Hosted by PASS DW/BI Virtual Chapter, with guest speaker Eugene Asahara
Dec 21, 12pm
Click here to attend


EVENTS

SoCal BI User Group - featuring Bob Abernathy of Strategy Companion
Hosted by Xelleration
Dec 3, Irvine, CA
Click here for more info


IN-PERSON TRAINING

Deploying, Operating, and Tuning an Analysis Services 2008 Solution
Hosted by Solid Quality Mentors
Feb 1, Minneapolis, MN
Click here for more info

SQL Server 2008 End-to-End Business Intelligence Workshop
Hosted by Solid Quality Mentors
Feb 15, Minneapolis, MN
Click here for more info


RESOURCES
Microsoft BI

SQL Server
Business Intelligence: SQL 2005, SQL 2008
Data Mining: SQL 2005, SQL 2008
Whitepaper: New Data Warehouse Scalability Features in SQL Server
Whitepaper: Introducing Microsoft StreamInsight

Blog: Formatting Linked Server MDX Query Results Using CTEs

SharePoint Server 2007
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 2007

SharePoint Server 2010
Blog: Describing SharePoint 2010 in 1 Sentence, 8 Categories and 40 Feature Areas
Blog: New Features in PerformancePoint 2010
Blog: Excel Services in SharePoint 2010 Feature Support, Dashboard Improvements

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

Related BI Resources
Notes from the Field


NEW AND PRESS RELEASES

Microsoft Elevates Mission-Critical Commitment With New SQL Server 2008 R2 Premium Editions, Delivery of November CTP
Bruno Aziza interviews Stephon Elop, President of Microsoft's Business Division

BIDN Launches:  Business Intelligence Developer Network (http://www.bidn.com/)

Crossing the Chasm II - Departmental to Enterprise BI
Gartner enters into Agreement to Acquire AMR Research, Inc.
Gartner Says Performance Driven Culture Is One of Four Disciplines Required for a Successful Pattern-Based Strategy

.


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


.

Wednesday, September 30, 2009

SoCal BI User Group - Oct1, San Diego

For those of you in the SoCal area, take part in the SoCal BI User Group. 

Enhancing BI End-User Data Visualizations using MDX
Presented by Daniel Upton

Thursday, Oct 1, 6:30-8:30pm

7480 Mission Valley Road
Suite 100
San Diego, CA 92108