Getting Started with DB.RTD
DB.RTD allows creating refreshable reports and models, for business and trading, based on database data in Microsoft Excel in an easy way.
Suppose, we have two database tables, or views, like weblogs:
We want to create a simple dashboard to monitor visitors and downloads:
To solve this task using native Excel features, we have to create:
- A pivot table for pages and months from dbo.weblogs;
- A pivot table for pages and weeks from dbo.weblogs;
- A pivot table for files and months from dbo.downloads;
- A pivot table for files and weeks from dbo.downloads.
So, the target dashboard table will contain four types of formulas.
Moreover, if we want to refresh data periodically, we have to record a macro to refresh tables and call the macro on timer events.
DB.RTD has a simple and elegant solution.
Just use the RTD formula to get and refresh database data like this:
For example, the target table can look like this:
All formulas in the table are regular and have the same structure.
So, you can get refreshable data from any database and any table, with any supported aggregate formula like count, max or min.
As a result, you can create reports and models with fewer efforts, in less time, and with clear structures.
Start learning with the Using DB.RTD topic.
DB.RTD requires registration to start a trial. See the Product Registration topic for details.