Data Academy is a browser-based data warehousing framework developed for SQL 2005 using Microsoft .NET.
Here are some of Data Academy key features:
Ease of Use
- Doesn't require any client side components to be installed.
- Allows easy changes and design corrections to your data warehouse.
- Lets you expand or fine-tune existing data warehouses.
- Has a centralized administration audit and error logging interface for each module.
- Has a user configuration facility that allows each user to access relevant areas of data for their role.
Flexibility
- Handles rogue data flexibly with the ability to hold back only the bad data in a staging area or quarantine everything in the load.
- Allows UDF-based field-level transformations.
- Can integrate existing SSIS packages in your data warehouse.
- Lets you import/export individual module instances.
Power
- Supports incremental data load, including deletes.
- Has an auto-correct facility to correct the data in the staging area.
- Has transform, pivot and un-pivot engines supporting flexible output options (such as grouping, aggregation and summarization).
- Allows field mapping.
- Creates star schemas and constellation schemas.
- Handles slowly changing dimensions in star schemas.
- Handles inferred (missing) members in star schemas.
- Generates SQL Server Analysis Services (OLAP Server) cubes.
- Supports multi-dimensional hierarchies (e.g. City >> County/State >> Country).
- Lets you assign dependencies between output objects to create a sequence in which data loaders, transformations and cubes can be run.
- Has a data warehouse SQL business rules repository.
- Allows critical information to be distributed to decision makers.
- Supports grouping and summarizing (within TRANSFORM-it and STAR-it modules).
- Supports table indexing (within LOAD-it and TRANSFORM-it modules).