|Excel PowerPivot Disrupts Business Intelligence|
|Written by Joab Jackson|
|Sunday, 12 September 2010 23:46|
Could the age of self-service BI (business intelligence) finally be near? And, if so, are organizations ready?
For years, BI vendors have promised a way for managers to easily build their own reports from scratch, without the help of IT staff. Now, with the release of Microsoft Office 2010, managers are finding they can do these tasks using a powerful new Excel feature, called PowerPivot. And, by its ease of availability if nothing else, this feature is promising to shake up the field of BI.
"It will spread like wildfire. As organizations upgrade to Office 2010, Excel users will adopt PowerPivot, whether the [IT staff] likes it or not," said Gartner analyst Rita Sallam.
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- List of suggested datasets to test PowerPivot
- Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
- DAX cheat sheet
- Learning PowerPivot and DAX
- Using Power Pivot and Power View for Profit Analysis