Getting Started with DB RTD
The DB RTD add-in allows creating refreshable reports and models 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, we should record a macro to refresh tables and call the macro on timer events if we want to refresh data periodically.
DB RTD has a simple and elegant solution.
Just use RTD formulas 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.