Post reply

CUBE question

  • February 17, 2016 at 1:16 pm

    #304800

    Can anyone suggest a article/site for me to get started with learning about CUBES

  • February 17, 2016 at 1:48 pm

    #1859367

    mw112009 (2/17/2016)

    Can anyone suggest a article/site for me to get started with learning about CUBES

    Do you know the concepts of a data warehouse? I'd start with that.

    Do you want to learn about SSAS? Or cubes in general?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • February 17, 2016 at 2:20 pm

    #1859375

    The SQL Server Analysis Services (SSAS) Tutorial[/url] on mssqltips aint bad as it uses adventureworks as an example which is available online for free. If you are serious, I strongly suggest investing in a book or two.

    IMHO the best book for developing a a BI solution, including and OLAP cube, is:

    The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset 2nd Edition Although it's specific to 2008R2, it's a great read with respect to walking you through planning > ETL design, > collecting OLTP and other data for your Data Warehouse > Cube Processing > Reporting & Analysis. Note that the 3rd edition looks great but I have not read it and does not appear to be platform specific like the aforementioned edition.

    As Luis eluded, you need to understand data warehousing before a cube makes any sense. E.g. Concepts such as denormalization, facts, dimensions, measures, and multidimensional data modeling. A fantastic book about multidimensional data modeling is: Star Schema The Complete Reference

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply