Archive of Category ‘Microsoft SQL Server’

OLAP Case Study

16. June 2010 from Ben Beres | No Comment

The best way to learn about OLAP is to take look at an example of where it would be useful. You can use this case study as a way to think about your own project. Just instead of trips we could be talking about sales, atmospheric changes, astronomical phenomena, or practically anything.

read more ...

Learning Cubes – For Beginners

3. June 2010 from Ben Beres | 1 Comment

The more information stored in a well-designed relational database, there are more ways a user may want to gather data. A user may want to implement queries to glean different patterns or produce specialized reports. This is where OLAP and Cubes enter the picture.

read more ...