If you are looking for a product to make your data warehouse creation time shorter as well as fully documented, then do not look past Wherescape RED.
One project took over 8 months to build a data warehouse, with Wherescape RED I built a Data Mart in 3 days!
- Ability to create staging tables with transformations by simple drag-n-drop and double-click capabilities.
- Creation of slowly changing dimensions is a simple drag-n-drop followed by a wizard answering questions.
- Building fact tables is again, a drag-n-drop operation including adding the dimensions to build your star schemas
- It even has the ability to publish the SSAS cubes
- All this with documentation including data flow diagrams!
I look forward to understanding this software deeper to empower me in my deliverable.