Business Intelligence

Biml Tutorial Part 3 – Adding Connection Managers to our Package Generator

Simon Kingaby BIML, Business Intelligence, ETL, SSIS

Now that we can generate simple empty packages, the next step is to add connection managers to the project and package.  After that, we will add a DataFlow.  This article will focus on the Connections though, and we will start with a pair of standard OleDb Connections.  Recall the metadata tables from the last article: … Continue reading Biml Tutorial Part 3 – Adding Connection Managers to our Package Generator

BI Data Source – SSAS

Simon Kingaby Business Intelligence , , , , , ,

Well now.  It turns out that PerformancePoint for SharePoint has quite a few nifty little features (after reading the help topics on the blank PerformancePoint site), but to work with it properly I need to have some data in a SQL Server Analysis Services (SSAS) Cube.  Since we are still in the stone ages and … Continue reading BI Data Source – SSAS

On a Different Track

Simon Kingaby Business Intelligence , , , ,

The other thing I am working on is presentation of BI data. Our current toolset is the Microsoft stack: SQL Server 2008 R2 (I know, I know, it's 2014 already, sheesh!) SSAS PowerPivot Excel 2010 (yes, it is 2014...  the wheels on the bus move a little slower here) SharePoint 2010 (I know again) PerformancePoint … Continue reading On a Different Track