Apr 18, 2018 | Data Warehousing, Featured
By: Ken Adams If you interviewed a handful of database professionals and asked them to define an Enterprise Data Warehouse (EDW, for short), it’s likely you would get a slightly different interpretation from each of them! That’s not to say any of them would be...
May 8, 2017 | Data Warehousing, Featured, SQL Server, Technical Information
By: Ken Adams Senior BI Consultant at Key2 Consulting As was mentioned in a previous blog post comparing the pros and cons of Microsoft Azure SQL Database versus SQL Data Warehouse, Microsoft announced at SQL PASS 2016 that they are offering a free, 1-month...
Feb 27, 2017 | Data Warehousing, Featured, SQL Server, Technical Information
By: Ken Adams Sr. Business Intelligence Consultant at Key2 Consulting A junk dimension is seen occasionally inside of data warehouses. This type of dimension can be thought of as a flag table, or a collection of attributes that have low-cardinality. This...
Dec 21, 2016 | Business Intelligence, Data Warehousing, Featured
Are we getting the most out of our data warehouse? If you’ve ever asked yourself that question as an executive, IT manager, or business owner, you’re not alone. We know there are many Data Warehouse/Business Intelligence (DW/BI) solutions that have fallen...
