_Paul_te_Braak.png

Paul te Braak

 

Paul te Braak is the principle consultant of abaX Data and has over a decade of experience in delivering reporting and business intelligence solutions across a variety of verticals.  This experience includes systems auditing, planning and business simulation models that predict activity through heuristic rules imbedded into the model.  He holds several qualifications including MCT, CA, MIT, MComm.

http://www.paultebraak.wordpress.com http://paultebraak.wordpress.com/feed/

Blog posts RSS

BIML I – Getting Started with BIML 22 Oct 2014
Traditional SSIS development requires the ETL developer to create a package and then manually add and configure tasks. While this method of visual development is fine, it suffers from reproducibility and maintenance overhead. For example, imagine (a very contrived scenario) where you create a ...

Changing Excel Table Connections in VBA 09 Sep 2014
In previous posts, I’ve discussed using VBA to extract connection information from Pivot Tables and hacking a tables command so that you can programmatically change the results of a query. But what if you have a table and you want to change its connection and its command? This can be achieved ...

The Wisdom of the (Tableau) Crowd? 11 Aug 2014
Ok … I’ll admit it … Tableau has some great features. One of the standout features of the new release (8.2) is the new data access method – ability to model data by dropping sheets from a file and manipulating it visually as a data source.  The benefit of this is that it removes ...

Brisbane SQL Saturday 08 Jul 2014
SQL Saturday in Brisbane is Back!! Im happy to announce that we are concreting arrangements for a Brisbane SQL Saturday .. its simply the best way to get SQL Server and BI training from some of Australia’s (and perhaps some international) best trainers and consultants.  Of course, the great thing ...

Flawless Excel in Business Intelligence 02 Jul 2014
Somewhat prompted by some recent posts about the inherent error associated with Excel as a BI tool (and more importantly how some magical tool solves this problem) I thought I’d discuss Excel as a BI tool. In-fact, it’s one of my favourite pondering points “what role should Excel ...