Welcome back to the weekly #thresqlips series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary: Continue reading #Thresqlips series #XML, Auto & Path – Episode 2
Today I’m going get into the specific characteristics of OLTP Databases versus Data Warehouses and how the dimensional model fits into the overall picture in the interesting world of investment banking data warehouse and business intelligence reporting. Continue reading Banking OLTP Databases, Datawarehouses & Dimensions
Welcome to the first article of the weekly #thresqlips series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary: Continue reading #Thresqlips series Metadata, XML & Text files – Episode 1
When working on the design and implementation of a data-warehouse / business intelligence solution some of the most common questions that I receive are in relation to the ODS or Operational Data Store. In today’s post I’ll explain it’s purpose and the proper way to interact with it.
The definition of the Operational Data Store Continue reading What an ODS is and how should you use it
Over the past two weeks I’ve covered a summary for the implementation of a Credit Risk Reporting project which is available in two parts, How to Implement a Credit Risk Data Warehouse – Part 1 and How to Implement a Credit Risk Data Warehouse – Part 2 holding the overview of the implications and a structured best practices approach to be considered when enrolling on the delivery of such a project.
Today I will focus on a common preconception that could have a severe impact to the schedule, resources, cost, development and ultimately the delivery of your Credit Risk Data Warehouse & Reporting project. Continue reading First assumption that could CRASH your Credit Risk Data Warehouse project