Product and service reviews are conducted independently by our editorial team, but we sometimes make money when you click on links. Learn more.
 

Data Warehousing: The Compelling Business Case

Data Warehousing: The Compelling Business Case
By

How to determine the goal and objective of a Data Warehousing platform.

Content in all forms is exploding! Global digital information doubles every 18 months and there are over 20 quadrillion containers of information (files, images, etc).  Over the past several years, Business Intelligence and Data Warehousing have evolved from a tactical program to a strategic initiative. 

So, as a follow on to my quest for providing a better understanding of how Business Intelligence and Data Warehousing has evolved and became a big part of all of our corporate environments, I wanted to now touch on the “How To” go about building a Data Warehouse and the elements that need to be considered when partnering with your business users to develop a solid business case. 

In summary, we know that the goal and objective for this type of platform is to:

  • Leverage information as an asset
  • Relieve pressure to streamline costs, and increase the return on investment
  • Eliminate manually intensive data gathering and reporting processes.
  • Build the foundation for a fully integrated reporting platform.
  • Provide relevant, accurate and timely information to the business.

Specific project focus should be around solving data and reporting issues for business challenges.  For this article I am going to use the Television business as an example.  First and foremost it is important to have an understanding of the problem that the business is trying to solve and also have a clear and concise problem that impacts revenues, operating costs, or productivity.

Laura Paoletti holds a Bachelor of Science Degree in Computer Information Systems and has been the Vice President of Information Technology at NBC-Universal and Disney ABC Television.  She has also held positions at Ernst & Young LLP in the Technology practice.  In her role she has been responsible for Applications, Infrastructure and Digital Media.  Some of her notable accomplishments include the implementation of applications for Digital Media, Marketing, Finance, Manufacturing (supply chain), Sales and Consumer Products; Implementation of Enterprise Data Warehousing/Business Intelligence systems; Data Center management, including hardware, storage strategies, digital libraries and data center expansion; Implementation of a Project Management office; and Business transformation from a tape to a tapeless environment (digital media). See  here for all of Laura's Tom's IT Pro articles.