Database Business Analyses with Microsoft Tools.
This is an example how to:
- Define your databases facts tables.
- Build data warehouse.
- Create new Dimensions.
- Create a Cube.
- Define reports based on your cube.
We shall use:
- Microsoft Server Management Studio. (Only for creating databases, steps 1-2)
- SQL Business Intelligence Development Studio. (I'll call it just Studio)
This is simple project, and there are no guarantees as usual.