Microsoft PowerPivot for Excel 2010 – Introduction

In this blog, I am going to briefly discuss what PowerPivot can do.

After you installed PowerPivot, PowerPivot appears on the Excel 2010 ribbon:

alt

After you click on the PowerPivot Window Launch button, you would see a new window come up.

alt

Importing Data

You may have data in many different places, e.g. database, Excel, reports, or even internet.  Microsoft PowerPivot offers 5 different ways to get external data:

  • Database
  • Reports
  • Data Feeds
  • Text Files
  • Other Sources

alt

After the import, each table shows up as a tab in the PowerPivot client window.

alt

Managing Relationships

After data is imported, the next step is to define the relationships among tables. You can create relationships and give it a meaningful name.

alt

After you click the Create Relationship button, you can specify the relationship  in the Create Relationship dialogue.

alt

And you can manage existing relationships.

alt

Presenting Information

Once your data is ready and relationships have been properly established, then you can create pivot table to do analysis or pivot chart to present information; an environment that you are very familiar.  PowerPivot enhances the Excel experience by providing quick templates for frequently used layouts:

alt

However, since your data is stored in PowerPivot, you must start the PivotTable within the PowerPivot, and PowerPivot overrides the default PivotTable Field List by providing its own Task Pane:

alt

Pivot Table

You probably can’t tell if the following pivot table is from Excel or PowerPivot.

alt

Pivot Chart

alt

Slicer is a new feature for Excel 2010 and you can use it with PowerPivot as well.

 alt

Hold on here!  I can use Pivot Table / Pivot Chart / Slicer in Excel without installing PowerPivot.  Why do I need PowerPivot at all? Why waste all my effort to import data and establish relationships?  I have better thing to do!  Good questions!  And I am going to answer your questions and explain the real benefits of PowerPivot in my next blog.

 

Andrew Chan is the owner and founder of ALG Inc.

We help you to make better and faster decisions!

About Andrew Chan
Andrew Chan is an Business Consultant who gives you accurate, consistent and timely information so that you can make better and faster decisions. He is an Associate of Society of Actuaries with over 20 years of IT experience. Apart from strong analytical skills and proven technical background, he was also a former system director at Manulife who had extensive project management experience. If you are looking for someone to gather, consolidate, validate, visualize and analyze data, look no further! Andrew can provide the most cost effective business analytics solution so that you can explore, optimize, predict and visualize your business. Don’t guess on any decision, no matter it is finance, operation, marketing or sales! Always ask for evidence!

12 Responses to Microsoft PowerPivot for Excel 2010 – Introduction

  1. Pingback: Why Microsoft PowerPivot? | Technologies and your business

  2. Pingback: Excel 2010 – PowerPivot | Technologies and your business

  3. Pingback: Microsoft PowerPivot for Excel 2010 – Importing Data | Technologies and your business

  4. Pingback: Microsoft PowerPivot for Excel 2010 – Creating Relationships Among Data | Technologies and your business

  5. Pingback: Microsoft PowerPivot for Excel 2010 – Adding Slicer | Technologies and your business

  6. Pingback: Microsoft PowerPivot for Excel 2010 – Adding Pivot Chart | Technologies and your business

  7. Pingback: Microsoft PowerPivot for Excel 2010 – Adding Pivot Table | Technologies and your business

  8. Pingback: Microsoft PowerPivot for Excel 2010 – Data Analysis Expressions (DAX) | Technologies and your business

  9. Pingback: Business analytic can turn your data to success « Technologies and your business

  10. Pingback: Is Excel our only option? « Technologies and your business

  11. Interesting work Andrew, though a number of your images in some of your articles are missing.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: