With Microsoft’s release of Office 2013, now fully equipped with features such as PowerPivot and PowerView, news outlets and blogs are abuzz speculating this is a push to make Excel the next Business Intelligence (BI) tool. Software Advice sat down withRob Collie, CTO of PivotStream and one of the founding engineers of PowerPivot, to get his perspective on how the new Excel will affect Business Intelligence and Excel professionals.
1. More adoption of PowerPivot in the Excel community. PowerPivot has yet to receive a lot of attention among the Excel audience.
“Unlike programmers, BI specialists, and other IT pros, the Excel audience doesn’t congregate at conferences and they don’t closely monitor what Microsoft is saying about the next version of their toolset. Overwhelmingly, the way they learn about new Excel capabilities is by inspecting the latest version once it lands on their desktop.”
All of that is about to change now that Office 2013 has more tightly integrated PowerPivot into Excel. Originally a separate download, PowerPivot is now part of the original package upon purchase.
2. The PowerPivot community is growing.
“Using PowerPivotPro traffic as a guide, I’ve seen the PowerPivot audience double in size every year since 2009. But I’d still estimate that less than one percent of the eventual PowerPivot target audience has been exposed to the product as of today.”
You have opinions and we want to hear them. That’s why we’ve created OfficeWriter Asks, a new forum where you can post all of your feedback and wishlist items. Our aim: to bring you the features you desire. Each week we’ll pose a new question related to our OfficeWriter product and how we can improve upon the features you use and need.
This week on OfficeWriter Asks:
Love them? Hate them? How do you use them?
So now you have a PowerPivot workbook that’s far too awesome to keep to yourself. How do you go about sharing PowerPivot workbooks?
You could just distribute the workbook wholesale, but that’s not optimal because any user who wants to take advantage of the PowerPivot features needs to have PowerPivot for Excel 2010 installed on their machine to fully run the report.
Pitan here! In Part 3 of my PowerPivot blog series, I cover how to add slicers to a PowerPivot report.
This post covers how to format slicers in Excel 2010 – in particular, how to create a custom slicer style that can be applied to multiple slicers.
The first step is to select the slicer to activate Slice Tools tab in the ribbon.
There are default styles available, but in this case we want to make a customized slicer style. You can create a new style from scratch:
Pitan here! This is Part 2 of my series on PowerPivot, which started with looking at how PowerPivot handles data. This time we’re covering similarities and differences between PowerPivot and regular PivotTables.
PowerPivot offers all the existing functionality of PivotTables with stronger backend support for data sources. Most of PowerPivotTables is exactly the same as regular PivotTables, but there are a few minor differences. So rather than tell you how to create PivotTables with PowerPivot, since you should theroretically be able to reuse your existing PivotTable know-how, I’m going to focus on some of the differences that threw me for a loop.
If you’re familiar with PivotTables, then you probably know that if you make changes to the original data for your PivotTable, you have to refresh the PivotTable in order to see those changes take effect.
PowerPivot is no different, except that it’s a bit more explicit. When you refresh the data in PowerPivot for an existing PowerPivotTable, the PowerPivot field dialog will tell you that the PivotTable also needs to be refreshed.
Hello everyone, Pitan here! I’ve finally had the chance to get my head around PowerPivot, the new Excel 2010 add-in for grabbing, pivoting, and displaying data. The chronicles of my journey to set up my own PowerPivot report will be revealed in a series of blog posts over the coming weeks. Tune in as I give you some HOW-TOs with a healthy dose of side commentary! Continue reading PowerPivot Part 1: Bringing Data Together→
Before you decide whether Power View is the best damn thing to happen to self-service BI since graph paper or is just a smoke and mirrors, CamelCaseless extension to PowerPivot, you need to know its gist. The following blog posts and videos will give you just that, from a (mostly) business user perspective. Read ’em, and then get cracking with the CTP3 version, available for download here.
Dan English’s (b | t) “Intro to BI Semantic Model & Delivering Self-Service Reporting with Power View (Crescent)” video and slide deck
A comprehensive MSBI presentation that covers the BI Semantic Model concept, Power View and SQL Server Analysis Services with Power Pivot in SQL Server 2012.
In this episode of Masterpiece Theatre: SharePoint, we’re talking Cresent erPower View. Press play to learn why Power View is good for PowerPivot and bad for Tableau, how it transforms big Hadoop data into technophobe-friendly animated reports and what your edition of SharePoint needs to get it up and running.