Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    1

    Exclamation Need some help designing a data warehouse!!

    Firstly, I am working on AdventureWorks 2008 OLTP Schema. I am trying to design a data warehouse for the product team to satisfy these requirements:

    - Which products are the most profitable / least profitable and should be made widely available

    - What are the most/least popular products and how do these correlate to revenue and cost

    I am currently stuck and I have no idea where to start this planning from... can someone please point me to the right direction please.

    Thank you

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Your product team is using the AdventureWorks sample database?
    Sounds like a homework assignment to me...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    What have you covered in class so far? More importantly, what type of class is it (survey, intro, Computer Science, other)? When did you get this assignment? When is this assignment due?

    Without some insight into what is expected, I can't offer very good suggestions on how to accomplish it!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •