You are here

Data Virtualization for Agile BI

IT cannot keep up with the demands for more timely information from the business. Three months to create an ETL process to load data into a data warehouse is no longer acceptable – even three weeks is not acceptable! People want to access the data immediately and IT’s inability to satisfy this need has resulted in ‘shadow IT’ projects which have circumnavigated normal IT processes to get to information.

The Denodo Data Virtualization Platform enables IT to be more agile in responding to the businesses almost insatiable demand for actionable information – usually in the form of reports or dashboards. With the Denodo Platform, the data remains in the source data stores – replication, with its accompanying staging, transformation, and batch copying tools and processes, is not required. Access to the data is through virtual views created in the Denodo Platform – virtual views are lightweight and quickly created (and discarded, if necessary).

Changes are similarly quick, making iterative report and dashboard creation, with almost immediate involvement and feedback from the business stakeholders, a reality. No more waiting for the ETL load to be configured and processed before deciding if you’ve got the data that the business actually wants – the Denodo Platform makes reviews and changes very simple and quick.

The Denodo Platform also provides a common and consistent view onto the underlying data. One of the usual complaints from the business users is that reports from different teams – sometimes using different reporting or visualization tools - often provide conflicting information when they are ostensibly reports based on the same data. This inability to get a consistent view of the business through reports and dashboards is a common driver for using data virtualization in Agile BI projects. Having a single and consistent view of a customer, or product, or an asset is critical if decisions are going to be based on information derived from this data.

Using the Denodo Platform for Agile BI Projects Can:

  • Significantly minimizes replication: from the data virtualization layer the user can point to the original data sources, partially cache any data and also build “virtual data marts” that are defined in the data virtualization layer thus avoiding the creation of new repositories (and yet more copies of the data).
  • Make it easier to change views and be more reactive to business requests: changes are carried out in the data virtualization layer, avoiding modifying ETL scripts across the whole replication chain.
  • Access to real-time data for Operational BI by enabling direct access to operational systems.
  • Provide a shorter time to market for delivering reports to users.
  • Integrate of any type of data from semi-structured, to structured and unstructured.
  • Enable self-service BI: the users can run any report against “self-service ready” data services created and managed by IT.