Technical Blog

Star Schema: The Complete Reference

Back in 2008, I was lucky enough to attend a Dimensional Data Modeling course in Auckland run by Ralph Kimball and Margy Ross. My team and I were thrilled at the opportunity to meet two “rock stars” of the Data Warehousing world (yes, sad geeks that we were). Being taught dimensional modeling techniques by the man famous for kicking it all off was a great experience. Although Ralph didn’t claim to be the inventor of dimensional modeling or star schemas, his workshops offered through the Kimball Group, and books such as The Data Warehouse Toolkit were instrumental in getting the techniques widely known and deployed as the de facto standard for data warehousing. To those in our part of the world at least, Ralph Kimball was “Mr Data Warehousing”. Read More...

Change Management for Business Intelligence Projects: Part 2

Leading the Case for Change
In part 1, last week, I described how a Change Management Framework can be used to consider and plan the activities for your proposed change. This week in part 2, I will describe more about what’s involved to help sell your change and actually get the organisational commitment to do it. Unfortunately, with so many competing demands, a good idea by itself often isn’t enough. You need to fight to get attention, and to get commitment from your management team that thdea is worthwhile pursuing. Read More...
© 2015 Andrew Mercer