|
Top 10 Reasons to Build and Use a Reporting Data Repository
Many well-known enterprises are running their reporting environments directly against production data stores. Often, when new applications are built or deployed, the reporting solution is an after-thought, leaving the enterprise scrambling to build reports and dashboards. Because of this, reports are built directly against the production databases, usually in the interest of time. As more data is added and reports take longer to run, there is a greater chance for the solution to begin affecting overall performance.
By spending time to build a data integration/transformation process that pulls the tables and columns from your production databases to a central database built for reporting, you can realize significant benefits.
|