Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Best Learning Resources For SSAS 2005

Best Learning Resources For SSAS 2005

Best Learning Resources For SSAS 2005

i've been working through some books on ssas 2005 but they're not very good.

if you have any suggestions on books or websites that are helpful i'd really appreciate any input you have.

the book i'm currently using is Applied Microsoft Analysis Services 2005 but i'm not finding it very helpful.

RE: Best Learning Resources For SSAS 2005

I agree I'm finding good sources a bit hard to find.
I'm trying to get through the book 'SQL Server 2005 Analysis Services Step By Step' but I'm finding it heavy going.


Dazed and confused

RE: Best Learning Resources For SSAS 2005

The Microsoft Data Warehouse Toolkit published by Wiley, and the SSAS book published by Wrox are very good resources, and anything by Kimball.  As for online courses or anything like that I doubt you will find much.  The key is to learn the methodologies, techniques and mdx once you have these down pat the rest is just learning the tool set.  

Don't believe you are going to sit down and produce a cube capable of complex analytics in a week, you probably won't even do it in a month.  The reality is that creating a useable BI solution is a time consuming process, which is typically hard for mgmt to accept.  My Last company believed we should turn out a data mart from idea to useable product in 6-10 weeks, this was with out business requirements and included Design, Devlop, Document, Test.

Some tips are:
1) Build a solid sensible star schema.
2) Build natural heirarchies that make sense.
3) Limit the use of attribute hierarchis.
4) Limit the number of Calculated Measures (Calculated Members on the measures dim)
5) Start Small
6) Start with basic dimension usage avoid the reference, and many to many to you are more confident
7) Oh yeah Start Small.
8) Build, Test, Modify
9) Start Small
10) Start Small.


Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: Best Learning Resources For SSAS 2005

Excellent.  Thanks.  As luck would have it I ordered the
'Microsoft Data Warehouse Toolkit' yesterday.

Dazed and confused

RE: Best Learning Resources For SSAS 2005

...also for a complete introduction and an understanding of the arcitechture of OLAP with SQL Server 2005 I really like this link:-



Dazed and confused

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close