Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The OLAP Sprint


The OLAP Sprint

Author
Message
Simon E Doubt
Simon E Doubt
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 892
Comments posted to this topic are about the item The OLAP Sprint
Ken Wymore
Ken Wymore
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4829 Visits: 2365
Good luck! I taught myself OLAP by taking a simplified copy of an existing relational database and reformatting everything to a more dimensional model. Even with a book on OLAP and plenty of web resources, it took me more than a week just to get the data elements correctly formatted so that I could actually use them in SSAS (key structures and all that). If you use the AdventureWorks or Contoso databases though, it isn't nearly as hard since they are already set up in a clean format and the data is pretty much perfect.
Simon E Doubt
Simon E Doubt
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 892
Thanks for the encouragement, KWymore.
It sounds like I'm mimicking your approach as well - taking an existing relational OLTP model and building from that. I've used view in my relational DB to act as my fact and dimension tables, so that I don't have to build a data warehouse and worry about ETL for my proof of concept. Although I know the Contoso and AW sample DBs are comprehensive, I really wanted to work with my data to see it come to life. So far the experience has been great.
Ken Wymore
Ken Wymore
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4829 Visits: 2365
It really started to come together for me when I used my own data too. The data in AW and Contoso is a little too perfect. That data is great for getting used SSAS but that is about it.

I also found that it helps to have a typical business question in mind when designing your cube. You want it flexible enough that you can answer the typical business questions plus some value added points (This way you can justify the need for the cube). If you try to pull in your entire universe of data and then filter it down, you will end up creating a huge mess. A lot of BI projects fail because the tool doesn't answer the important questions. it sounds like you already have an idea of what you want your cube to do though. +
Simon E Doubt
Simon E Doubt
SSC-Addicted
SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)SSC-Addicted (491 reputation)

Group: General Forum Members
Points: 491 Visits: 892
KWymore (11/12/2012)
It really started to come together for me when I used my own data too. The data in AW and Contoso is a little too perfect. That data is great for getting used SSAS but that is about it.

I also found that it helps to have a typical business question in mind when designing your cube. You want it flexible enough that you can answer the typical business questions plus some value added points (This way you can justify the need for the cube). If you try to pull in your entire universe of data and then filter it down, you will end up creating a huge mess. A lot of BI projects fail because the tool doesn't answer the important questions. it sounds like you already have an idea of what you want your cube to do though. +


It was definitely a priority to use my own data, for two main reasons:

1) I wanted one of the benefits of the development of the prototype to be some actual exploration of the data, not just by me, but by the executives and business analysts here, because I knew it would really engage their appetite for pursuing BI beyond the prototype. I also knew this would help with the justification for the conference expenses (registration, travel, lodging).

2) I knew that if I used my data, I'd be able to confirm that the results that the cube was producing were accurate.

"Nothing like sleeping in your own bed", as they say.
Ken Wymore
Ken Wymore
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4829 Visits: 2365
Exactly. We had a hard time selling dashboards to our executives until we decided to just do the work and show them what was possible. Now it is our main focus. Funny how that works, right?

Glad you are getting something out of the PASS Summit. I may have to talk my boss into sending me next year. Keep up the posts!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search