Tag Archives: PowerPivot

Watch the Power Pivot 101 Webinar Recording

Thank you to everyone that attended my webinar titled Power Pivot 101: An Introduction! Also, thank you to Thomas Leblanc (blog|twitter) for making it possible. I had a great time presenting to the PASS Excel BI Virtual Chapter and I’d love to be able to do it again any time.

If you weren’t able to make the webinar, you can easily view the entire recording right here!

If you’d like to play along with the webinar and follow through with my examples, you can download the data sources here.

If you want to download the Power Pivot model I created during the webinar and play around with it, that can be download here, as well.

Power Pivot Learning Resources

Read about options for upgrading a Power Pivot model.

Interested in hands on training with the experts from Pragmatic Works? Consider taking their Power Pivot modeling class.

Here is part 1 of 10 DAX calculations for your Power Pivot model.


We had a lot of questions at the end of the webinar and I didn’t have time to answer all the questions. If you had a question that I didn’t get to, please just leave a comment down below with your question.

If you had any other feedback, you can leave that comment down below, as well. Thanks for reading and I hope you enjoy the webinar.

Taking #PowerPivot to the Next Level

Power Pivot is an amazing, flexible and powerful business intelligence tool (among other things) and there is no doubt about that fact. As a feature included with Excel 2013 and 2016 (and an add-on for Excel 2010), Power Pivot allows user with a little technical expertise to integrate disparate data source together within a flexible data model. Once the data is loaded into Power Pivot, we easily have the ability to create powerful calculated measures, key performance indicators Continue reading Taking #PowerPivot to the Next Level

Importing Power Pivot & Power View into Power BI

Import Power Pivot into Power BI

The Power BI August update just rolled out today (8/20/2015) and in the latest update there’s a lot of cool, new enhancements such as writing custom MDX or DAX queries to access your SSAS data sources, connectors for Azure HDInsight Spark and Azure SQL Data Warehouse (so awesome!), some various UI improvements and a bunch more. But one of the coolest features (and much needed IMHO) is that we now have the ability to import Excel artifacts, such as Power Pivot models and Power View reports straight into Power BI Desktop!

New to Power BI Desktop? Read this first!

Import your Power Pivot Model into Power BI

To begin importing a Continue reading Importing Power Pivot & Power View into Power BI

Power BI Desktop: My First Run Through

If PowerPivot, Power Query, and Power View had a baby (don’t ask how) that baby would be called Power BI Desktop Designer. Yesterday the Power BI Desktop Designer was released for general availability, which I promptly downloaded last night at 11:30 PM EST and started playing with. Even as my wife turned out the light and begged me to go to sleep, I persisted! I was too excited. So here’s my first run through (I call it run through because it was late and I didn’t spend a ton of time looking at every little thing).

Here are 3 Power BI best practices to follow

Download Power BI Desktop

Ok first things first. Download the Power BI Desktop Designer so you can start playing!


Installing it is pretty straight forward so I’ll spare you the details.

Get Data with Power BI Desktop

The first thing I did after installing the Power BI Desktop Designer was Continue reading Power BI Desktop: My First Run Through

Choose Your Weapon: Power BI Edition

With an estimated 500 million Excel users in the world, it’s no wonder that Excel is the #1 business intelligence too in many organizations around the globe. And with the release of Excel 2013, the collection of powerful and flexible data analysis tools built into Excel has only continued to grow. Microsoft is constantly adding new features and functionality to Power BI at pretty fast rate, so now is a great time to start learning about everything that MS Power BI can offer your organization.

Because Excel is just full of a slew of incredible tools, its important for us to understand the difference between the tools, when you should choose each tool, and the Continue reading Choose Your Weapon: Power BI Edition

PowerPivot 101 Training Webinar with Q&A

To watch the free recording of my webinar called PowerPivot 101, just head over to PragmaticWorks.com, create a free login and you’re all set! Please let me know if you have any questions.

PowerPivot 101 free webinar training

Once again, thanks to everyone that attended my session on PowerPivot. Here are my responses to some of the questions I received during my session but did not have time to answer until now.

1. Does the current version of PP support drill through?

The current version of PowerPivot does support drill through. All you have to do is right-click a measure in your spreadsheet and select Show More Details or alternatively you can double-click the measure.


2. Is PowerPivot add-in required for SharePoint?

PowerPivot for SharePoint is required if you wish you share Excel workbooks that contain PowerPivot data via SharePoint. For more information on installing and setting up PowerPivot for SharePoint, check this out.

3. Where will a replay of the PowerPivot 101 webinar be available?

Head over to the Pragmatic Works Learning Center to view the recording of this webinar as well as the recordings of all the previous webinars!

4. Book/website recommendations?

Definitely check out PowerPivotPro.com run by Rob Collie. It’s a great website with tons of cool PowerPivot-y stuff, plus Rob is a cool dude.

Check out these books!


PowerPivot for Excel 2010: Give Your Data Meaning
Marco Russo & Alberto Ferrari


Practical PowerPivot & DAX Formulas for Excel 2010
Art Tennick

5. What is the name of the component/function in SharePoint that would make the “live” data connections possible in published PowerPivot?

I assume the question is directed at utilizing a live connection to a data source, such as SQL Server. To my knowledge, this is not natively supported with PowerPivot. The data in your PowerPivot workbook must be refreshed.

There are two ways to refresh data in a PowerPivot workbook. You can refresh it manually anytime you want or you can schedule a refresh through SharePoint like I showed during the webinar. For more information on refreshing data in a PowerPivot workbook, check out MSDN.

6. I thought DAX was only supported using the Tabular mode of SSAS. My understanding is that PowerPivot is built on the Multidimensional model. I wouldn’t think DAX would be supported. Can you comment?

DAX (Data Analysis Expression language) is the formula language for PowerPivot and Tabular modeling and is used to specify calculations and to create new columns. It’s basically an extension of the Excel formula language. For more information related to DAX in regards to PowerPivot and Tabular modeling, read this and this.

7. Can you blog about having a calculated field that I can put on a slicer to filter by number of records (i.e. products with more than 100 records).

To filter records where a measure is greater than or less than a certain amount is pretty easy. In your workbook, just click the drop down arrow above the attribute you wish to filter, go to Value Filters, and select Greater Than, Less Than, or whichever option you desire.


Then you can select which measure you want to use and what quantity to use.


Thanks for all the great questions everyone. Don’t forget to check the recording of the webinar in case you missed anything!

PowerPivot 101 Recording Now Available

Thanks to everyone who attended my PowerPivot 101 webinar last Tuesday morning! It was a blast and I had a great time presenting for the 300 strong crowd that attended!

In case you missed the webinar, you can easily view the recording here free of charge! Also, don’t forget to check out the dozens of other free webinar recordings. With this kind of free training available, there really is no excuse for you to not be learning something new!

If you’re looking for a great book to get you started with PowerPivot and DAX, I would suggest checking out the following books:


PowerPivot for Excel 2010: Give Your Data Meaning
Marco Russo & Alberto Ferrari





Practical PowerPivot & DAX Formulas for Excel 2010
Art Tennick




Also, check back for my PowerPivot Q&A responses in a later blog post! Thanks again to everyone who attended my session!