Post reply

i need ideas

  • February 19, 2012 at 10:16 am

    #253321

    Hello I am new to BI.

    I am trying to learn ssas and I thought I start with a small project but I need your help for ideas.

    The project I had in mind is the following

    I work housing charity for the homeless. We have about 1600 clients (staying at our hostels)

    for each client when they stay at our hostels we do risk assessment, needs assessment and outcome star at 4 -6 weeks period. for now I am mainly focusing on outcome star

    the outcome star will include the following

    StarID

    StarDate

    ClientID

    ProjectID

    ProjectWorkerID

    MotivationAndTakingResponsibilityScale (this 1 - 10 scale)

    SelfCareAndLivingSkillsScale (this 1 - 10 scale)

    ManagingMoneyScale (this 1 - 10 scale)

    SocialNetworksScale (this 1 - 10 scale)

    DrugAndAlcoholMisuseScale (this 1 - 10 scale)

    PhysicalHealthScale (this 1 - 10 scale)

    EmotionalAndMentalHealthScale (this 1 - 10 scale)

    MeaningfulUseOfTimeScale (this 1 - 10 scale)

    ManagingTenancyAndAccommodationScale (this 1 - 10 scale)

    OffendingScale (this 1 - 10 scale)

    of course there's tables for clients, projects, project workers

    the typical enquires and reports would of the following nature

    For typically each three month what is the precantage of people move 1 point in scale, 2 point in scale , 3 points in scale etc for each area of the outcome star.

    or how many stars a project worker has done per project and and how many clients have more 2 stars in percentage

    how do approch this in terms of designing the fact and dims?

    many thanks

  • February 19, 2012 at 12:13 pm

    #1449004

    My recommendation would be to provide some test data for folks to work on so they might be better able to provide you with a coded answer. Please see the first link in my signature line below for how to do that.

    I also have a question on your requirements. Let's say a give scale entry had a 5 in it on the first of 3 months, a 10 for the second month, and it moved back to a 5 on the third month. Because of the 5 point jump in both directions, do you want it reported or, because there was no change between the first and 3rd month, do you want it NOT reported?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 19, 2012 at 1:12 pm

    #1449011

    Jeff

    thank you for your reply. I will post sample data tomorrow as I am at home now.

  • February 20, 2012 at 2:10 am

    #1449116

    mona770118 (2/19/2012)

    Jeff

    thank you for your reply. I will post sample data tomorrow as I am at home now.

    yeah..better give us some samples to work on it...so that we may help you as far as we can...

    Thanks,
    Charmer

  • February 24, 2012 at 6:14 pm

    #1451650

    mona770118 (2/19/2012)

    Jeff

    thank you for your reply. I will post sample data tomorrow as I am at home now.

    Did you work out an answer?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

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