Next-Level Self-Service BI with Data Virtuality Web

Next-Level Self-Service BI with Data Virtuality Web

Did you already hear the news? We recently released the latest version of our revolutionary data integration solution, the Data Virtuality Logical Data Warehouse (LDW) 2.1! The LDW 2.1 comes fully equipped with a range of exciting new capabilities and significant advancements that enable you to integrate and model all your data with unprecedented flexibility and scalability – even in the most demanding big data environment.

We want to share our excitement with a three-part mini-series. Each feature story will introduce you to one of the LDW 2.1’s key features and outline how they enable you to leverage the full potential of your data. To kick it off, let’s have a look at the brand-new Data Virtuality Web, our one-stop data shop for business users and applications.

The Challenge: Data Management

With huge amounts of data now being generated and integrated on a daily basis, data management is becoming more and more complex. To make things even more complicated, your business users expect speedy and comprehensive analytical data access without so much as having to approach the IT department for support. The solution to this problem? Our state-of-the-art Data Virtuality Web client! With our DV Web we provide self-service agility and freedom while your IT can enforce security and governance rules. Simply explore and query the data that is available on the server, combine data in the BI tool of your choice, and create self-service reports – without worrying about the underlying IT infrastructure. Take data management to the next level, with Data Virtuality Web!

The Solution: Data Virtuality Web

Data Virtuality Web is an out-of-the-box feature in LDW 2.1. That means it comes at no extra cost and you do not have to implement it manually. The only setup requirement is to update your Data Virtuality Logical Data Warehouse to 2.1 (contact us for more information). Once the update is finished, you can log into DV Web with your Data Virtuality credentials and get started. DV Web has an easy-to-use interface for business-oriented users that bridges the gap between technological complexity and data consumers by separating the logical and business data layer. In other words, DV Web simplifies and accelerates the access to the information your business users require and exposes the data in a business-friendly manner.

The DV Web client enables all business users (depending on their permissions) to search metadata and query SQL from the web browser without using the DV Studio.

  • Inspect available data sources and their contents
  • Create simple or advanced SQL statements
  • Generate SQL queries directly from the data source
  • Download results as .cs-files to process further and/or import into e.g. Excel

Data Virtuality Web’s Key Functionalities at a Glance

The interface of DV Web is divided into four sections: Browse, Samples, Functions and Metadata Search. Here’s a detailed look at each functionality:

1. Browse

Our Data Virtuality Web gives business users full self-service freedom in their data discovery and exploration process. Browse and navigate through a preview of all metadata available in the data delivery layer and get in-depth information on your data that a frontend BI tool alone can’t provide. You can browse all data sets that are connected to your target source, such as schemata, tables, procedures, views of data, comments etc. If you want to look at the data directly, simply generate the respective SQL command from the table and execute it. In addition, you can download all tables generated from the available datasets as .cvs files for final consumption e.g. in Excel.

2. Samples and Functions

These two are relatively straight forward: You can find here a range of sample procedures as well as a collection of template functions. Use them as reference for optimized metadata querying and browsing!

3. Metadata Search

Our Data Virtuality Web gives business users full self-service freedom in their data discovery and exploration process. Browse and navigate through a preview of all metadata available in the data delivery layer and get in-depth information on your data that a frontend BI tool alone can’t provide. You can browse all data sets that are connected to your target source, such as schemata, tables, procedures, views of data, comments etc. If you want to look at the data directly, simply generate the respective SQL command from the table and execute it. In addition, you can download all tables generated from the available datasets as .cvs files for final consumption e.g. in Excel.

To Sum It Up ...

Leverage the powerful searching and browsing capabilities of the DV Web to get access not only to metadata but also to the actual data. View the data you need in real time and create reports with the agility and freedom of a self-service tool.  And all that without having to know anything about complex SQL constructs! Indeed, you do not have to worry about the technical complexities of your data integration solution at all. They are hidden behind a business user-friendly web-based interface. You can simply start working with your data! With the DV Web, the LDW 2.1 creates a one-stop data-shop that empowers all data consumers, from analysts to business users and decision makers, to find and use information assets quickly, which is essential in today’s self-service world.

Want to find out more about our Data Virtuality Logical Data Warehouse and how it simplifies and accelerates data management with minimum effort and maximum flexibility?

 
Follow the link or schedule a demo with our experts today!