MS BI # 85 – PowerPivot #2 – Download , Install , Connect to SQL Server and Getting Started

Hi friends

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 :

Link Resource Website

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

| FaceBook |Twitter | linkedIn| Google+ | WordPress | RSS |