Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.  Read more...

The employee dimension presents one of the trickier challenges in data warehouse modeling. These five approaches ease the complication of designing and maintaining a 'Reports To' hierarchy for ever-changing reporting relationships and organizational structures.  Read more...

Join BI Architect Bill Pearson as he continues to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.  Read more...