Post reply

how to start Datawarehouse project for adhoc reporting?plz help

  • August 22, 2013 at 12:56 pm

    #276401

    Can any 1 help me , from where should i start my datawarehouse project?

    Thanks,

    Archi

  • August 22, 2013 at 1:21 pm

    #1644103

    This question is way too broad to be answered in a simple forum reply.

    You can start by reading the Data Warehouse Toolkit by Ralph Kimball.

    A quick search on Amazon should lead you to his books.

    You can also do a Google search on "Kimball data warehouse" and read some of the articles/tutorials you find to get up to speed with the methodology.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 29, 2013 at 12:12 pm

    #1646075

    Yes, a question with no specific answer.

    You need to start by asking some questions of your own:

    what is the purpose of the cube?

    who are the users?

    what are we measuring?

    What dimensions will we want to include?

    It's hard to know if you are seeking business requirements help or technical design or quite what. Come on back when you have a bit more direction. The most specific questions have the best shot of generating helpful answers.

  • August 29, 2013 at 12:40 pm

    #1646082

    Thanks for your answers.

    I have created a POC project and also a powerpivot dhashboard using the SSAS cube.

    Now my problem is how can I share that with the end users.

    I know one solution is through sharepoint ,but i can't see power pivot gallary in my sharepoint 2010.

    Is there any another way, plz help

    Thanks in advance...

  • August 29, 2013 at 12:42 pm

    #1646085

    If you have a SSAS cube, users can access the cube using Excel and build pivottables and charts on top of it.

    If they have permissions of course.

    Regarding the PowerPivot gallery: did you install a BI site?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 29, 2013 at 12:45 pm

    #1646086

    but i have to create dashboard and present it to higher level peoples.

  • August 29, 2013 at 12:52 pm

    #1646087

    SharePoint is the way to go (if you have the correct version/license).

    Here's an article on the PowerPivot gallery:

    Create and Customize PowerPivot Gallery

    Make sure you install the PowerPivot for SharePoint instance.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 7 posts - 1 through 6 (of 6 total)

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