Tera-Tom here! The Garden of Analysis is a paradise for business users after they receive an answer set. By merely dragging and dropping answer set columns to simple templates, the business user can analyze and build hundreds of reports without ever leaving their desktop.

 

Victor Hugo once said, “An invasion of Armies can be resisted, but not an idea whose time has come.”  Users today need the ability to query any system, and once the answer set comes back, they need to be able to analyze that data 50 different ways and do so in mere seconds.

 

Here are some facts you should consider. It is estimated that, for every hour a major data warehouse is down, it costs the company $1 million. Here is another scary fact, 2% of the bad queries take up almost 50% of the machine time.   The most expensive and overused resource in every company is the data warehouse, and the most under used resource is the PC.  Your data warehouse might have 1,000 processors, but you have 50,000 PCs in your organization meaning you literally have 50 times the power.

 

The Garden of Analysis will cut down on the most expensive and overused resource by allowing users to grow their own data garden inside their own PC.

 

After a user receives an answer set or multiple answer sets, they are each placed in the garden of analysis.  The user can then drag and drop columns from any answer set to beautiful and easy-to-use templates.  There are templates for aggregation, ordered analytics, grouping sets, group by rollup, group by cube, ranks, dense ranks, percentage ranks, top, quantiles, dynamic charting, and all kinds of different pie and line graphs.

 

The Garden of Analysis is designed to do everything to an answer set that a database does to a table, but it does so without using any network or system resources outside of your PC. Now that is an idea whose time has come!

 

The Garden of Analysis is just another reason your enterprise will thrive with Nexus.  The Nexus is the only tool that allows companies to query every database.  The Nexus is the only tool that allows companies to load their ERwin model and then show users every table and view graphically, while also showing what objects are joinable.  Nexus is the only tool that then builds the SQL for you as you point and click on the tables you want to join.  Nexus is the only tool that allows you to see underlying indexes for every table or view.  And now, Nexus allows users to analyze an answer set easily and quickly without leaving the PC.

 

Set up a demo with us, and we’ll show you the Garden of Analysis.  You can let us know what calculations you’d like to add.  We’ll put them in.  Plant your garden and grow your knowledge!

 

Sincerely,

 

Tom

 

Tom Coffing

CEO, Coffing Data Warehousing

Direct: 513 300-0341

Website: www.CoffingDW.com

Email:  Tom.Coffing@CoffingDW.com

Posted in Blog