Soldier: Damn Trekkies, always crashing the party pretending they’re time travelers. Claudia: What a nerd. – Warehouse 13 episode “Queen for a Day” I was asked the question “What’s the point of a data warehouse if I have Hadoop”? And if you know me – I tend to answer in terms of an analogy: The [...]
Archive for the ‘Data Warehousing’ Category
Warehouse: Relational DW or Hadoop?
Posted in BigData, Data Warehousing on December 7, 2011 | 2 Comments »
Before Big Data mining, we need to ensure privacy–but how?
Posted in BigData, Data Warehousing, Medical Informatics, tagged Privacy on August 16, 2011 | Leave a Comment »
First things first, but not necessarily in that order! – words of wisdom from Doctor Who The tweet below got me thinking about the importance of privacy. Data mining demands sound privacy policies in age of ‘big data’ http://t.co/1N0gZhz #datamining #BI #bigdata After all, in this day of age, [...]
SQL Server 2008 Data Warehousing Channel 9 Videos
Posted in Data Warehousing, SQL, tagged Videos on July 2, 2009 | Leave a Comment »
Eric Hanson has created a series of SQL Server 2008 data warehousing videos posted on Channel 9. They cover data compression, backup compression, star join enhancements, parallel query enhancements, change data capture, grouping sets, and partition-aligned indexed views. Quick and informative videos to get you up to speed on SQL Server Data Warehousing. For these [...]
Web Analytics and Data Warehousing
Posted in Data Warehousing on April 3, 2006 | 100 Comments »
Extracted from Graves et. al., Professional SQL Server 2000 Data Warehousing with Analysis Services, Wrox Press, ISBN: 1861005407; Chapter 18: Web Analytics is the analysis of web data. More specifically, it is business intelligence that allows analysts to gain insight into their web-based businesses (e.g. e-commerce, customer support, etc.). Web Analytics allows you to [...]
Data Warehousing Planning
Posted in Data Warehousing on February 14, 2006 | 32 Comments »
When planning to build an enterprise data warehouse, there are many of small details ranging from hardware allocation to error reporting. So unless you plan for this correctly, you may deliver an inadequate system. A good article to review on the issues to resolve when planning a data warehouse can be found in Craig [...]

