locked
PowerPivot VS regular Excel. RRS feed

  • Question

  • Hi guys. Could you please give some examples of why PowerPivot table is used for MDX SSAS vs regular excel. I mean what is it about PowerPivot that is more special than regular excel. I connect to SSAS cubes in excel and do all the stuff but i want to know what is special about PowerPivot. Please help me understand. Thanks.
    svk
    Thursday, January 26, 2012 7:46 PM

Answers

  • With PowerPivot you can build your own cube that gets embedded in your Excel file.

    When was the last time you tried to get your IT department to let you build your own cubes or add your own calculations or import tables from other sources and then integrate them into your model?

    Right, I didn't think so.


    • Edited by ruve1k Thursday, January 26, 2012 10:29 PM
    • Marked as answer by czarvk Sunday, January 29, 2012 9:46 PM
    Thursday, January 26, 2012 10:28 PM
  • Hi varunsvk,

    Power pivot is basically designed for business users who don't know any thing about BIDS and modeling etc. Since excel is a well known environment for them they can start building the models easily using power pivot and send them back to IT department for further enhancements. Basically power pivot is to enable "self service BI". So any one who is new to analysis services/who don't know what a cube is can get insights from their data on their own with out much support from IT department.

    Once a business user create a power pivot model and created some reports, they can publish it onto the share point server so that the colleagues of that user (management/ team members) can have a look at it and they can make changes/interact with it.

    Overall, this power pivot mainly serves as "self service bi" tool for business users. And it is also a very good tool for developers who are new to analysis services. This is a good tool for those who want to learn DAX which is the FUTURE OF SSAS.

    More over using DAX is very much easier than MDX. As per the ssas team the future will be tabular modeling. You can see there are not much enhancements over MDM. You may not know that we are developing a cube inside excel. That cube is nothing but a BISM tabular model.

    change the extension of your excel work book from .xlsx to .zip and inside xl folder in it you can see a .data file. That is the cube . you can restore it in ssms too. 

     

    Please mark as answer if this is helpful.

     


    • Proposed as answer by Dhwani S Friday, January 27, 2012 8:48 AM
    • Edited by Dhanumjay K Friday, January 27, 2012 8:58 AM
    • Marked as answer by czarvk Sunday, January 29, 2012 9:46 PM
    Friday, January 27, 2012 8:47 AM

All replies

  • With PowerPivot you can build your own cube that gets embedded in your Excel file.

    When was the last time you tried to get your IT department to let you build your own cubes or add your own calculations or import tables from other sources and then integrate them into your model?

    Right, I didn't think so.


    • Edited by ruve1k Thursday, January 26, 2012 10:29 PM
    • Marked as answer by czarvk Sunday, January 29, 2012 9:46 PM
    Thursday, January 26, 2012 10:28 PM
  • Hi varunsvk,

    Power pivot is basically designed for business users who don't know any thing about BIDS and modeling etc. Since excel is a well known environment for them they can start building the models easily using power pivot and send them back to IT department for further enhancements. Basically power pivot is to enable "self service BI". So any one who is new to analysis services/who don't know what a cube is can get insights from their data on their own with out much support from IT department.

    Once a business user create a power pivot model and created some reports, they can publish it onto the share point server so that the colleagues of that user (management/ team members) can have a look at it and they can make changes/interact with it.

    Overall, this power pivot mainly serves as "self service bi" tool for business users. And it is also a very good tool for developers who are new to analysis services. This is a good tool for those who want to learn DAX which is the FUTURE OF SSAS.

    More over using DAX is very much easier than MDX. As per the ssas team the future will be tabular modeling. You can see there are not much enhancements over MDM. You may not know that we are developing a cube inside excel. That cube is nothing but a BISM tabular model.

    change the extension of your excel work book from .xlsx to .zip and inside xl folder in it you can see a .data file. That is the cube . you can restore it in ssms too. 

     

    Please mark as answer if this is helpful.

     


    • Proposed as answer by Dhwani S Friday, January 27, 2012 8:48 AM
    • Edited by Dhanumjay K Friday, January 27, 2012 8:58 AM
    • Marked as answer by czarvk Sunday, January 29, 2012 9:46 PM
    Friday, January 27, 2012 8:47 AM