Monday, March 12, 2012

CRM and data mining Day 04

The following shows some reasons to create a data cube.



Data cube.


The architecture behind BI



a clustered index
To add a clustered index to the fact table, usually use one of the date keys.
It will be helpful to have the fact data physically arranged in date order.
It is assumed that you are familiar with views, tables (relational database concepts) and the difference between the two. To avoid unnecessary modifications to the original data, we will make use of views rather than the tables for cube development.

SQL Server Business Intelligence Development Studio (BIDS)

Choose "Native OLE DB\SQL Native Client 10.0" as the provider

Import an existing database using the "restore" option. Note: you might need to use the option overwrite the existing database.

References
Amit Bansal , Microsoft SQL Server 2008 - Create a Cube, http://www.youtube.com/watch?v=aglwqC8irMA&feature=relmfu


No comments:

Post a Comment

Mounting USB drives in Windows Subsystem for Linux

Windows Subsystem for Linux can use (mount): SD card USB drives CD drives (CDFS) Network drives UNC paths Local storage / drives Drives form...