Skip to main content

Dashboards, PowerPivot, Slicers, and DAX

Things you can do with Excel 2010

Why PowerPivot?
Dashboard Introduction
PowerPivot Example
PowerPivot Formulas
PowerPivot Resources
Why You Should Use PowerPivot
 1. You can download the full version of PowerPivot software  -- for free!  There is no cost, now or in the future.
 2. PowerPivot becomes part of Excel and provides powerful, new data analysis capabilities.
 3. No IT resources are required. (No additional servers or programmers.)
 4. An experienced Excel user in your organization can quickly implement and learn how to use PowerPivot.
 5. PowerPivot will provide real improvements to your ability to analyze and report on data.
 So what is this software and why is it free?
 The software is called "PowerPivot" and is available from Microsoft as a free add-in to Excel. Microsoft is making PowerPivot available for free to the hundreds of thousands of Excel users because it is counting on a small percentage of them buying additional Microsoft server products to publish PowerPivot data models. For the rest of us PowerPivot is completely free!
 Is this too good to be true?
 PowerPivot is an innovative adaptation of "Business Intelligence" software used by big companies to analyze data.   Microsoft's plan is to "bring Business Intelligence to the masses" and PowerPivot is their first step in the plan. Eventually Microsoft can make millions from expanded use of its Business Intelligence software. In the meantime you can take advantage of free PowerPivot software.
 Why should we spend time installing and learning to use PowerPivot?
 Almost every organization is drowning in data. Businesses need to analyze marketing data, service data and budget data. Schools need to analyze student performance data. Governmental agencies need to analyze demographic data. The list goes on and on.
 Most organizations have limited IT resources so they are spending hours and hours of time crunching data in Excel.  There is never enough time to fully analyze the data.
 By using PowerPivot you can analyze data in ways that go way beyond "regular Excel".  You can get more done in less time.
 PC World Magazine says it this way:
 As the name implies, PowerPivot is a PivotTable on steroids. With PowerPivot, you can pull into Excel large amounts of data from multiple database tables, databases or other sources of data, and sort and filter them almost instantly. Data can be reorganized around one column or compared against columns from another data source. You can divide the data by time, geographic origin or some other parameter. Since it runs Microsoft's business intelligence software on the back end, it can do much of what a full-fledged BI application can do.
 Gartner says:
 Microsoft Excel has been widely used for data aggregation and lightweight analysis, but limitations have precluded its use as a high-end ad hoc analysis tool, including limits to the data size it can handle and the number of rows it offers, its slow calculations, its lack of understanding of dimensional models and its lack of centralized spreadsheet management and control. ….. PowerPivot begins to address this limitation …... extending interactive analysis capabilities to Excel "power users."
 How Do You Learn More?
 Get your organization's best Excel user to download PowerPivot at
 Check out the downloadable PowerPivot Example and the PowerPivot Resources page at this site.