As professionals, anything that makes our job significantly easier, can be conceived as a threat. I must be honest, when Microsoft started on its journey of ‘Self Service BI’, PowerPivot, PowerView etc, I perceived this as a threat, and as a watering down of my skillset. However there is two truths that you can’t get away…
Jet Reports have written an interesting article on Data Warehouse Automation. It appears this concept is gaining recognition. TDWI has also recognized the value of Data Warehouse Automation, as one of the emerging trends for 2015 and beyond. I’ve also written an introduction article on the who, what, where, when and why of Data Warehouse Automation….
This post shows you how to use EzAPI to load and modify an existing SSIS package. Create a template SSIS packages, and generate a suite of packages from the template. As far as I can tell, this is the first time this really useful feature of EzAPI has been documented. Its always been hinted at in…
This post describes how to use MSBUILD to automate the build and deployment of a SSAS Analysis Services Cube. This solution relies on calling Visual Studio (devenv.exe) from within MSBUILD to first build the Cube and then using the SSAS deployment wizard from the command line to deploy the Cube. The first thing to understand…
Connect a PowerView report to a SSAS Multidimensional (Cube) Source : Quick Tip
10 Page Guide – Free PDF Download. Download our free PDF Guide to Data Warehousing and Business Intelligence Concepts. The Guide covers Basic concepts of Data Warehousing including: Facts, Dimensions, Star Schemas and Data Warehouse Design. Definitions – Business Intelligence vs Data Warehouse vs Data Mining etc. Extract Transform and Load (ETL). OLAP and Cubes….
When you build an SSIS Project, you can optionally also generate an SSIS deployment Utility. The Deployment Utility can be used to Deploy the SSIS Packages and Configuration Files on a Server. Below is an example SSIS Project configuration, which will trigger the generation of a Deployment Utility. In the image you can see that…
Understanding the Visual Studio Solution Configuration Manager Dialog. Below is an example screenshot of a Visual Studio Solution Configuration. This example shows a solution configuration called DEV. Within the project are two projects called Data_Integration and Data_Integration_Database. Associated with the DEV Solution configuration is the DEV Project Configuration of the Data_Integration and Data_Integration_Database projects. The…
An introduction to using Data Driven Design and the Agile Project Methodology to quickly deliver a Data Warehouse.
ezAPI is an API written by the Microsoft SSIS Team which makes it easy to generate SSIS packages programmatically. ezAPI is the API that Dimodelo Data Warehouse Studio uses to generate SSIS packages. This post describes getting started with ezAPI.
