Microsoft BI

Microsoft Business Intelligence from the field

Microsoft SAP Resources

Here are some great Microsoft SAP resources SAP and SAP BW data in PowerPivot...

Author: bi-king Date: 08/01/2012

New Office 2013 BI capabilities

Some new links to check out about what is coming from a BI perspective in Office/SharePoint 2013...

Author: bi-king Date: 07/30/2012

Microsoft Named a Self-Service Business Intelligence Leader by Forrester Research

Forrester Research has positioned Microsoft as a leader in the "The Forrester Wave™:...

Author: bi-king Date: 07/24/2012

Microsoft SQL Server training

Free MVA courses here

Author: bi-king Date: 07/19/2012

Intro to DQS

Looks like a good online training on Microsoft Data Quality Services....

Author: bi-king Date: 07/18/2012

Demo Image XII: SQL 2012

Latest and greatest All up Microsoft BI Demo image is located here...

Author: bi-king Date: 06/14/2012

64 bit version of the Data Mining Add-in for Excel 2010

FINALLY!!!! and updated for SQL Server 2012....

Author: bi-king Date: 05/17/2012

SQL Server 2012 Developer Training Kit

This is truly excellent content. Kudos to the MS Team. Links to presos and videos below....

Author: bi-king Date: 05/03/2012

Microsoft Business Intelligence 2012 - Single Server Install Guide

I just put this together for a customer and thought I would share it. It goes through the entire...

Author: bi-king Date: 05/01/2012

SQL Server 2012 Product Guide

Just released a new SQL Server 2012 Product Guide ready to download.

Author: bi-king Date: 04/12/2012

connect PowerPivot to an Oracle database

Not very well documented on how to connect PowerPivot to an Oracle database. You need the Oracle...

Author: bi-king Date: 04/10/2012

Reporting Services 2012 and Dashboard Designer

Alot of confusion on how to integrate the new SharePoint integrated mode of Reporting Services 2012...

Author: bi-king Date: 04/10/2012

Microsoft BI on an ipad

Microsoft has released new guidance on viewing reports and scorecards on Apple iPad devices, and a...

Author: bi-king Date: 02/17/2012

SharePoint Summit

For those in Toronto, I will be presenting a session at the SharePoint Summit on May14-16th on...

Author: bi-king Date: 01/27/2012

Launch BISM File (.bism) in Excel

BI semantic model connections from Excel require that you have Excel 2010 and the MSOLAP.5 OLE DB...

Author: bi-king Date: 01/11/2012

Project Barcelona (again)

check this out for what is coming...btw, it is in CTP1 release now....

Author: bi-king Date: 01/05/2012

DAT279 New Business Intelligence Functionality in Microsoft SQL Server Code-Named "Denali"

I am doing a session next week at our local techdays event. I hope to see...

Author: bi-king Date: 10/19/2011

Microsoft Big Data

Unlock business insights from all your structured and unstructured data, including large volumes of...

Author: bi-king Date: 10/13/2011

PerformancePoint Services SuperFlows

It's like a help file on steroids. There are 2. IT configuration - how to configure Performance...

Author: bi-king Date: 08/27/2011

Reporting Services 2012 SharePoint Service

There are couple of post install manual configs you need to do in order to get the reporting...

Author: bi-king Date: 07/27/2011

SQL Denali CTP3 is out

latest and greatest denali bits....

Author: bi-king Date: 07/12/2011

PowerPivot: DAX: Time Intelligence Functions

Useful list of time calcs for powerpivot and soon to be tabular bi models....

Author: bi-king Date: 07/08/2011

Cascading filters in PPS

here is a little known PPS feature add for SP1 for SharePoint 2010...

Author: bi-king Date: 06/30/2011

Twitter Analytics

A new cool FREE tool to gain valuable insight into your tweets using PowerPivot. Download it here

Author: bi-king Date: 06/15/2011

Windows 8

i can think of a few cool BI scenarios with this new UI [View:]

Author: bi-king Date: 06/03/2011

Business Intelligence with Cloud Data

This walkthrough discusses how businesses can take business intelligence to the cloud with SQL...

Author: bi-king Date: 05/25/2011

Fuzzy Lookup Add-in for Microsoft Excel 2010

New Project from MS Labs. Takes the fuzzy lookup functionality out of SSIS and puts into Excel 2010....

Author: bi-king Date: 05/06/2011

Project Barcelona

Another cool project starting up at Microsoft. Looks interesting. Find out more here...

Author: bi-king Date: 04/27/2011

Use PowerPivot To Analyze Your Outlook Calendar

Calendar Analytics is a FREE time management application that pulls information from Exchange and...

Author: bi-king Date: 04/27/2011

SharePoint Diagnostics Studio

The SharePoint Diagnostics Studio available in the SharePoint 2010 Administration Toolkit v2.0,...

Author: bi-king Date: 04/25/2011

How to build dashboards using PerformancePoint Services 2010

Here are some free PPS training videos to get up to speed on how to build dashboards using...

Author: bi-king Date: 04/05/2011

SSAS Benchmark

Found a nice benchmark doc from Unisys. It is SQL Server 2005 however but still very good....

Author: bi-king Date: 03/17/2011

PowerPivot models as a datasource for Report Builder and PPS

PowerPivot models, aka xlsx files can be used as datasources for report builder reports, also...

Author: bi-king Date: 03/11/2011

New MSDN Blog

I started a new blog over at msdn and will post there

Author: bi-king Date: 03/01/2011


moving content from

Author: bi-king Date: 02/28/2011

SQL Server 2008 R2 Business Intelligence Training Course

SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights), a new self-paced...

Author: bi-king Date: 02/09/2011

PerformancePoint 2010 Content Deployment Tool

It’s a command-line tool that allows you to deploy PerformancePoint content using an existing...

Author: bi-king Date: 02/09/2011

New Gartner BI Quad

We actually passed Oracle. Shows our message and capabilities are getting through to customers. Here...

Author: bi-king Date: 01/31/2011

SQL Server 2008 R2 Update for Developers Training Kit

Author: bi-king Date: 01/21/2011

MS BI End User Training

Make Better Business Decisions with this FREE course....

Author: bi-king Date: 01/20/2011

The new HP Business Decision Appliance

The new HP Business Decision Appliance comes with the complete Microsoft BI stack including Windows...

Author: bi-king Date: 01/18/2011

PerformancePoint 2010 and PowerPivot

All you need to know…....

Author: bi-king Date: 01/18/2011

New PowerPivot build

integrates into the Windows Azure Marketplace DataMarket Download here

Author: bi-king Date: 12/15/2010

Visio Forward Engineer

Came across a cool add in to Visio to model and create databases....

Author: bi-king Date: 12/15/2010

PowerPivot Training

Roadmap to Creating PowerPivot Workbooks in Excel:...

Author: bi-king Date: 11/30/2010