-
Archives
- October 2021
- June 2020
- June 2017
- March 2017
- September 2016
- June 2016
- February 2016
- November 2015
- July 2015
- May 2015
- March 2015
- January 2015
- September 2014
- August 2014
- July 2014
- June 2014
- March 2014
- February 2014
- January 2014
- December 2013
- October 2013
- August 2013
- July 2013
- June 2013
- April 2013
- March 2013
- February 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
-
Meta
Category Archives: Data Warehousing
Nulls are evil (or at the very least mischievous)
If you have been involved in hands on database development for a while, or in any kind of BI / reporting initiative, you probably already know this. Nulls are evil (or at the very least mischievous). A null value in … Continue reading
Posted in BI At Large, Data Warehousing, SAP HANA
Tagged database design, nulls in database
Comments Off on Nulls are evil (or at the very least mischievous)
Medicare Advantage Enrollment Dashboard
About a month ago, my colleague, Josh Tapley (http://data-ink.com/) and I set out to build an Xcelsius based BI application. Our goals were to demonstrate the capabilities of the technology, when combined with some fundamental data warehousing and BI techniques … Continue reading
Time lapse or high speed your business processes with history preservation techniques
High speed and time lapse photography are two techniques that allow us to understand the world around us by slowing down or speeding up processes that we could otherwise not be able to observe. High speed photography allows us to … Continue reading
Posted in BI At Large, Data Warehousing
Tagged forecast analysis, forecast time lapse, forecast time warp, high speed data warehousing, History preservation, slowly changing dimensions, snapshots, Time lapse data warehouse
Comments Off on Time lapse or high speed your business processes with history preservation techniques
Why Isn’t Data Enrichment A Standard Practice In Every Data Warehousing Project?
Data enrichment is a terrific way to increase the value proposition of your data warehouse, and yet, it is implemented quite rarely. With data enrichment you can almost overnight provide your sales team with additional mountains of information about the … Continue reading
Posted in BI At Large, Data Warehousing
Tagged Data Enrichment, data warehousing
Comments Off on Why Isn’t Data Enrichment A Standard Practice In Every Data Warehousing Project?
Abusing the date dimension: when does it make sense to NOT use it
The date dimension is a dimensional model staple. You will not find a data mart, data warehouse or any kind of a reporting database that does not have one form or another of a date dimension. The benefits of using … Continue reading
Posted in BI At Large, Data Warehousing
Tagged Date dimension, semantic model, slowly changing dimension, sql date gymnastic
3 Comments
Why Data Modeling Fall Sideways?
One of the most surprising aspects I have come to expect during the years of data integration and warehousing consulting is how little data modeling is actually being practiced in this field. While it is hard to find a database … Continue reading
Posted in BI At Large, Data Warehousing, Universe Design
Tagged BI SDLC, Data modeling, data warehousing
Comments Off on Why Data Modeling Fall Sideways?
Naming Conventions In The Data Mart
What you call things matter. It matters to you, and it matters to others who interact with you. When you name things, your project, your children, your children’s stuffed animals, you typically consider two perspectives: what YOU think the name … Continue reading
Posted in Data Warehousing
Tagged Data mart, Data warehouse, naming convention, standards
Comments Off on Naming Conventions In The Data Mart