Lifestream / Bio / Archive
Joy Mundy
Articles
-
News
Kimball University: Five Alternatives for Better Employee Dimension Modeling
August 17, 2009 02:30 PM 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.
-
News
Kimball University: Maintaining Dimension Hierarchies
October 27, 2008 09:02 AM Dimension hierarchies and pre-computed aggregations can make or break your data warehouse. Here's how to design, load and maintain true hierarchies while working around bad data sources and optimizing for usability and performance.
-
News
Kimball University: Should You Use An ETL Tool?
April 06, 2008 09:30 PM You can still hand-code an extract, transform and load system, but in most cases the self-documentation, structured development path and extensibility of an ETL tool is well worth the cost. Here's a close look at the pros and cons of buying rather than building.
-
News
Kimball University: Handling Arbitrary Restatements of History
December 09, 2007 10:13 PM How do you cope with an executive's request to "bring back a time series of activity for all subscribers who were in platinum status as of X date," or "show me a time series of orders by sales region according to the sales organization as of Y"? Here's how data warehouse pros can cope with the common requirement to look back in time.
-
News
Kimball University: Building a Foundation for Smart Applications
December 01, 2006 12:00 AM Off-the-shelf apps may offer built-in analytics, but the best approach to supporting operational decisions is to rely on a solid data warehouse that cleans, integrates.
-
News
Don't Forget the Owners Manual
July 01, 2005 05:00 AM Ensure trouble-free data warehouse and BI deployments by answering critical planning questions.
By The Numbers
Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012
What Do You Think?
|
|








