Data Academy consists of several core modules and each module performs a specific task during the construction of your data warehouse.
The full retail version consists of the following modules: LOAD-it, JAIL-it, TRANSFORM-it, STAR-it, CUBE-it, GOVERN-it, ORCHESTRATE-it, TRANS-it and SNAPSHOT-it.
Optional Modules and Companion Products
Optional modules and companion products for Data Academy are also available:
- Optional module: TRACK-it.
- Companion products: Data Academy Score Card, Data Academy File Keeper and Data Academy Form Builder.
TRACK-it
Provides a complete auditing capability for all or some of the data in your data warehouse
When data is changing, you may need to know who is changing it, when they changed it, and what changes were made - for information, for compliance, or even just for your own piece of mind.
- Record the date, time and user when data is changed.
- Record inserts, updates and deletes providing before and after images of the tracked data.
- Track whole tables or just selected fields.
- Exclude "system" users from tracking.
[ Top ]Score Card
A comprehensive reporting and analysis product that monitors and manages Key Performance Indicators (KPIs). It gathers enterprise data from multiple disparate sources into a fully configurable score card providing target versus actual values.
It facilitates the management of actions, events and business areas to help meet overall business objectives by providing "Traffic Lighting" alerts against KPIs.
All the information is presented through a web browser interface in an intuitive layout making it easy to share information across an entire organization.
It handles multiple score card capability, track period-to-date and year-to-date, full analysis and drill through and offers multiple security settings.
[ Top ]File Keeper
Data Academy File Keeper provides a facility for the logical filing and storing of residual unstructured data from your data warehouse build.
Files are organized in a folder tree, similar to the way you might use a shared network drive in Windows. Security is implemented at either the folder or individual file level via Data Academy Business Units, to which rights can be assigned or revoked at any time.
To add an additional degree of structure, files can be associated with specific data items (parent records) in your data warehouse. Used in conjunction with Data Academy Form Builder, this provides the capability to upload scanned documents such as letters or contracts and link them to individual records in a particular table.
Data Academy File Keeper is an "add-on" product, which can be used "stand alone" or with the Data Academy data warehouse.
[ Top ]Form Builder
As you develop your data warehouse, you may well come across scenarios where you need to edit or enter data manually.
Data Academy Form Builder allows you to extend your Data Academy data warehouse with fully functional, customized web forms, which allow you to add, delete and make changes to the data in your data warehouse.
Data Academy Form Builder is an add-in for Visual Studio 2008, which generates ASP.NET web forms, which are fully integrated with the rest of your data warehouse environment, providing a platform for login, control-based security, data input validation and user interface consistency - including aspects such as grid search/sort functionality and parent-child data relationships.
Using Data Academy Form Builder is simply a question of pointing it at a data table, and clicking "Generate". A typical output might be a pair of "list-drill" forms, with the basic functionality to select, add, edit and delete items from your data. With all the intelligent defaults provided by Data Academy, this may be literally all you need to do! But further customization is only a click away, allowing you to define foreign key relationships which feed through into UI controls as drop-down lists, to customize titles and labels and even to generate the output as ASP.NET Web Controls (.ascx) which you can drop into other pages. All of these outputs are based on Data Academy's own tried, tested and trusted framework, which also powers the Data Academy User Interface which you use every day!
Finally, because all of the output consists of standard ASP.NET forms and objects, coded in VB.NET, you even have the ability to actually debug and extend them manually, which means there is nothing you can't do.
----------
* Level 3 ODBC compliance required.
[ Top ]