Platinum Sponsor
marco_schreuder.jpg

Marco Schreuder

Runs the consulting firm IN2BI (www.in2bi.com) dedicated to helping companies get the most out of their investment in Microsoft Business Intelligence tools. His field of interest is broad and ranges from presenting relevant information in dashboards and reports to efficiently collecting data in data warehouses.

He is the architect behind the following BI products:



- Webdashboard from his previous company In Summa (www.insumma.nl



- Het DWH Deck from IN2BI.

http://www.in2bi.com http://feeds.feedburner.com/in2bi

In this session you'll get a good introduction of the concepts and advantages of Biml as we walk to the creation of Meta Data Driven SSIS Solution.

Blog posts RSS

Truncate all Tables 28 Jul 2014
There are many reasons for me to blog. One of the less vain is to recover and reuse code I wrote earlier. In my current project we have a need to test, test and retest the initial load of the data warehouse. For this purpose I wrote this T-SQL script that: Drops all foreign key constraints; ...

Viewing or Saving the Compiled Biml File(s) 21 Jul 2014
Some time ago a BIML enthusiast asked me for the location of the temporary files that BIDSHelper create when you generate the SSIS packages in BIDSHelper. I couldn't help him and explained that the Biml Engine first compiles the Biml documents,  applying any BimlScript in memory and then ...

Building a data warehouse while the source systems are still in development 04 May 2014
Some years ago the client of a contractor I worked for made some major investments in their IT-landscape. They replaced their ERP - and CRM system and of course BI/Reporting was part of the acceptance criteria for the new system. It was a big project and a disaster! ERP, CRM and BI consultants from ...

Many Happy User Peaks 02 Jan 2014
I wrote this blog post in august 2012, but somehow I forgot to post it. At the start of 2014 I wish every one many happy user peaks and wisdom in creating them… Recently I have been involved in converting a business intelligence (dashboard) web application. Making it more suitable for tablets and ...

Run as Different User 18 Dec 2013
As a consultant I often need to run a program as a different user. For future reference I collected the information about RunAs in this article. In Windows 7 en Windows Server 2008R2 you can run an application as a different user  by holding down the shift key and right clicking the ...