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 Smile !

    image

    Click on above specified link will open following page, Click on Download

    image

    Installation Selection based on 64 Bit or 32 Bit

    Above link will forward you on Microsoft Download Center page

    image

    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.

    image

    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.

    image

    We can see PowerPivot onside excel tab/ ribbon image

    Zooming bit !!

    image

    On clicking above tab we can see many interesting things

    image 

    Now lets click on PowerPivot Window to open PowerPivot dashboard , Which will open following screen

    image

    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

    image

    Zooming little bit !

    image

    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

    image 

    image

    Select required table and Relation

    image

    PowerPivote will import all data for you

    image

    Also shows you how many record it have transformed

    image

    Here you go starting with actual Data inside power pivot 

    image

    image

    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 : image

    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 |

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: