With Power Business Intelligence (BI) tools of Excel 2013, one can metamorphose raw data and/or results of complex calculations into stunning and interactive visualizations. Power View (one of the four components of Power BI) allows one to create a PPT like flow in Excel thus allowing one to weave a story. To be able to interact with/create visualizations, you will need to install Microsoft Office Professional Plus 2013 (this version will already have two of the four components of Power BI - PowerPivot and Power View). Additionally, you will have to install the following add-ins from Microsoft (the other two components of Power BI)
1. Power Query; and
2. Power Map
I have tried to showcase the prowess of Power BI tools of Excel 2013 in these two workbooks:
1. An overview of the BRIC Economies
2. Sales data analysis
Just in case you do not have Microsoft Office Professional Plus 2013, you can see the features of Power BI in this 10 minutes video of the first workbook - "An overview of the BRIC Economies".
Hi Sir,
I want to Addon – Power Pivot in my system.
I am using excel 2010 with 64 Bits
Could you please send me link to download the same
Thanks
sanjay
Hi,
A simple Google search revealed this link - http://www.microsoft.com/en-us/download/details.aspx?id=29074
I think I have downloaded Power Query from a MS site. I do not have Excel 2013 (I have 2010) or certain insurance (etc.) as mentioned on a certain (I don't remember which one) MS-site but apparently that was no problem when I downloaded from the MS site Ashish Mathur mentioned. After downloading I got the message "thank you for downloading" or a message with similar meaning. But ... where is that Power Query? I can't find it at "file", the first tab of the ribbon) , left column "add ins" (I translated roughly from Dutch,. In the Dutch version it's the tab "bestand" and there item "invoegtoepassingen". Please help. Thanks in advance.
Jack Sons
Hi,
Had it installed properly, it would have appeared automatically in the Ribbon. I suggest you post your question in the Power Query forums - http://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery
I saw the Power Query forum but I didn't see the way how to post my question. Please show me how.
Jack.
Hi,
Click on the Big Blue "Ask a Question" button and then please proceed on your own.