This resource is no longer available
Optimizing ETL: The Key to Accelerating Data‐Driven Business Decisions
Whether you’re analyzing information from a data warehouse, reviewing click-stream data to find the latest trends, or running a query on current sales figures, the elapsed time to perform these processes means lost revenue. Fortunately, there are numerous ETL-related steps you can follow to reduce the elapsed time needed to manage the data and run these various applications. The time savings that you can achieve by following any of these steps can translate into significant improvements in your business processes and decision-making abilities. And that added time translates into money.
Remember the old business saying “Time is money”? Well that certainly rings true today. Packages are sent across the world to arrive the next business day. Contracts are faxed in order to get signatures immediately. And critical decisions are made within minutes. But what happens if the data that’s needed to help make those decisions takes too long to access? Perhaps the data warehouse is too packed, or the database takes too long to load, or even simple queries are running too slow. A frequent problem is an over-abundance of data that needs to be streamlined, reformatted, or grouped in a different way. This article explains the various steps you can take when processing your data to reduce elapsed time and improve the results of many applications.