We have started analyzing PowerPivot a way back in Sept 2011.
I have only one post written on it which as below, In which I have explained all basic stuff related to it :
MSBI # 39 – PowerPivot #1 – Introduction to Microsoft SQL Server PowerPivot (Features,Architecture,Self-Service BI,Reference)
In this article we are going to cover
- How to download PowerPivot
- Installation Selection based on 64 Bit or 32 Bit
- How to open PowerPivot inside excel
- How to connect to SQL Server using PowerPivot
- How to fetch table from SQL Server inside PowerPivot
- Books to study DAX language
How to download PowerPivot
Just go to Bing and Google It !
Click on above specified link will open following page, Click on Download
Installation Selection based on 64 Bit or 32 Bit
Above link will forward you on Microsoft Download Center page
Select your installation based on 64 bit or 32 Bit.
Once download is complete complete all installation step.
How to open PowerPivot inside excel
Lets get started !
Open Excel as normal as you are opening before.
Also observe during starting windows we can see addin about PowerPivot inside excel starting page.
This will so quick and fast you hardly able to observe it ! , Forget if you are not able to see , No problem move ahead.
We can see PowerPivot onside excel tab/ ribbon
Zooming bit !!
On clicking above tab we can see many interesting things
Now lets click on PowerPivot Window to open PowerPivot dashboard , Which will open following screen
Now lets see some of features to play with it !
How to connect to SQL Server using PowerPivot
Click on From Database Tab which open multiple option for Data Source
Zooming little bit !
How to fetch table from SQL Server inside PowerPivot
Now go on selecting “From SQL Server ” on above tab follow setps as shown
Select Database where you want to analyze
Select required table and Relation
PowerPivote will import all data for you
Also shows you how many record it have transformed
Here you go starting with actual Data inside power pivot
Books to study DAX language
- Don’t forget to download DAX book.
Through DAX we can play in in power pivot , I will surely have lot more post on this topic :
Hope you will download and share your experience with PowerPivot to all of us.
If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.
If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :
For More information related to BI World visit my Mentalist Blog
SQL Server Mentalist >> SQL Learning Blog
Business Intelligence Mentalist >> BI World
Connect With me on