2013 03 Why You Need A Data Warehouse
Why You Need a Data Warehouse
Joseph Guerra, SVP, CTO & Chief Architect
David Andrews, Founder
Introduction
Chances are that you have heard of data warehousing but are a little fuzzy on exactly how it works and whether your organization needs it. It is also highly likely that once you fully understand exactly what a data warehouse can do, you will decide that one is needed.
700 West Johnson Avenue
Cheshire, CT 06410
800.775.4261
www.rapiddecision.net
© Copyright RapidDecision 2013
All trademarks are the property of their respective owners.
Data warehouses are widely used within the largest and most complex businesses in the world. Use with in moderately large organizations, even those with more than 1,000 employees remains surprisingly low at the moment. We are confident that use of this technology will grow dramatically in the next few years. In challenging times good decision-making becomes critical. The best decisions are made when all the relevant data available is taken into consideration. The best possible source for that data is a well-designed data warehouse.
The concept of data warehousing is deceptively simple. Data is extracted periodically from the applications that support business processes and copied onto special dedicated computers. There it can be validated, reformatted, reorganized, summarized, restructured, and supplemented with data from other sources. The resulting data warehouse becomes the main source of information for report generation, analysis, and presentation through ad hoc reports, portals, and dashboards.
Why You Need a Data Warehouse
Building data warehouses used to be difficult. Many early adopters found it to be costly, time consuming, and resource intensive. Over the years, it has earned a reputation for being risky. This is especially true for those who have tried to build data warehouses themselves without the help of real experts. Fortunately, it is usually no longer necessary to custom build your own data warehouse. The
Joseph Guerra, SVP, CTO & Chief Architect
David Andrews, Founder
Introduction
Chances are that you have heard of data warehousing but are a little fuzzy on exactly how it works and whether your organization needs it. It is also highly likely that once you fully understand exactly what a data warehouse can do, you will decide that one is needed.
700 West Johnson Avenue
Cheshire, CT 06410
800.775.4261
www.rapiddecision.net
© Copyright RapidDecision 2013
All trademarks are the property of their respective owners.
Data warehouses are widely used within the largest and most complex businesses in the world. Use with in moderately large organizations, even those with more than 1,000 employees remains surprisingly low at the moment. We are confident that use of this technology will grow dramatically in the next few years. In challenging times good decision-making becomes critical. The best decisions are made when all the relevant data available is taken into consideration. The best possible source for that data is a well-designed data warehouse.
The concept of data warehousing is deceptively simple. Data is extracted periodically from the applications that support business processes and copied onto special dedicated computers. There it can be validated, reformatted, reorganized, summarized, restructured, and supplemented with data from other sources. The resulting data warehouse becomes the main source of information for report generation, analysis, and presentation through ad hoc reports, portals, and dashboards.
Why You Need a Data Warehouse
Building data warehouses used to be difficult. Many early adopters found it to be costly, time consuming, and resource intensive. Over the years, it has earned a reputation for being risky. This is especially true for those who have tried to build data warehouses themselves without the help of real experts. Fortunately, it is usually no longer necessary to custom build your own data warehouse. The