What is a slow changing dimension? SCD Type 0? SCD Type 1? SCD Type 2? Hybrid SCD? This video defines SCD and demonstrate the application of several SCD types.
Building a business intelligence solution requires specialized skillsets such as data modeling, data integration, data analytics, and visualization design. Leveraging a consulting firm’s services can offer a cost effective alternative to hiring permanent specialized resources while also acquiring some of the most skilled practitioners. However, there are risks involved in depending on a consulting firm […]
If you are preparing to start a business intelligence and/or data warehousing project, then you probably already know that BI project failure is not uncommon. While there are many reasons why projects fail, we can boil it all down to a handful of mistakes that can be avoided 100% of the time. When picking your […]
Ok, so you probably already know that Mike Rowe never shot a ”˜Dirty Jobs’ episode on data warehousing, but if he had there is no doubt that it would have been the episode that turned stomachs like no other. Mothers would have turned the channel to protect their sweet babies from being exposed to the […]
You know how there are times in life when you see something, and you know from experience that someone is headed for a world of problems (to put it mildly)? In situations like this a time machine could really be valuable. We could go back in time to a date when the upcoming catastrophe could […]