Friday, September 17, 2010

My takeaways from Adam Jorgensen's 24HOP session -- Zero to cube

Here are my takeaways from today's fantastic session of Adam


  • The first basic point was you can use "." instead of "localhost" to choose the localhost server.
  • Defining the attribute relationship was very clearly explained that the relatiosnhps should be from the lowest level to the highest level.
  • Proactive caching -- available in from SQL SERver 2008 but the refresh property is available in Excel 2007 but sometimes may not work properly.

The following two resources which are quite useful was also discussed.


The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

Microsoft SQL Server Product Samples: Database

No comments:

Free Databases and Data Visualisations course for kids Week 6

Week 6 update: Yesterday the class was a bit different because it started off with a Database Fundamentals test.  There were 20 questions ...