The Problem: The client has a business partner who manages a particular application and its database for them. The client was relying on periodic data extracts for business intelligence and operational data. This was a real drag on business operations in an era when everyone expects near real-time information. We…
Says who? Says me! There is a received wisdom in the world of business intelligence that says you need a data warehouse in your business, but is this true? Why do you need a data warehouse? The most important reason is to get a single version of the truth, or…
For as long as I can remember I have been intimately involved with data. Moving it, cleaning it, providing it to the business; either pre-aggregated for immediate consumption or the raw stuff for further analysis. Always I have been concerned with automating the pipeline so that the latest data is…
Or a prescriptive pattern for automating the building of sophisticated data warehouses based upon a simple metadata store There are lots of Biml articles that discuss strategies for generating SSIS packages to load data warehouses that are essentially copies of the production DB. These strategies usually leverage the built in…