RECENT POSTS

Mining Data Vault Loading Views

I first heard about Data Vault (DV) in late 2011. As I learned about DV, I quickly realized its benefits in the realm of Data Warehousing (DW), however it was not until early 2012, after I had the opportunity to attend Dan Linsted’s 3-day DV “Boot camp” class, when I realized it’s true power. DV is flexible, scalable, auditable pattern-based…

Power to the People… the Business Intelligence way

When entering into any technology project, the team is typically is comprised of a blend of business and IT professionals. These can be from developers, analysts, business liaisons and business analysts; to the projects sponsors. When looking at a Business Intelligence project, this structure appears to be very similar on the surface. However, there is one component that changes drastically……

Blobitty Blob Blob Blob….

At my current client, we are working on a major rewrite of their Claims Management System, which has included moving the old data from an Oracle database to a new SQL database being designed by our team. Part of this conversion involved a particular challenge. We were tasked with extracting all of the documents stored in the Oracle DB as…