Creating Linked Tables in PowerPivot for Excel

The PowerPivot march continues with a look at Creating Linked Tables in PowerPivot for Excel

Stairway to PowerPivot and DAX - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts - SQLServerCentral

SQL Server Central continues a look at PowerPivot's DAX language with Stairway to PowerPivot and DAX - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts

Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel

From MSSQLTips come help with Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel

More PowerPivot and Excel 2013

MSDynamicsWorld has a nice roundup of the Excel 2013 PowerPivot mess.

Mary Jo Foley has the PowerPivot Protest story on ZDNet too!

Mary Jo Foley has the PowerPivot Protest story on ZDNet as well.

In case you missed it, the core issue is that with the release of Office 2013 Microsoft pulled PowerPivot from all versions of Excel EXCEPT Office 2013 Professional PLUS. Professional is not enough.

We're not happy.

Occupy Excel

Power to the PowerPivotPros!

Revolutionaries in Redmond! PowerPivotPro Readers Quoted in ZDNet! « PowerPivotPro

Microsoft peed on my PowerPivot

Rob has a much nicer title on his post “Hey, Who Moved My (PowerPivot 2013) Cheese?”  but those of us who had to talk customers through the Performance Point debacle are getting that deja vu vibe here. I'm feeling a little like when my dog decides to pee six inches from the door as I'm reaching for the handle to let them out. We were almost there and then you had to go and do that.

The short version is that PowerPivot and the equally cool PowerView is only available in Excel 2013 as part of the Office Professional Plus version, NOT Office Professional. Apparently "Plus" is short for PowerPivot and PowerView. I'm resisting suggesting that it's an acronym for Please Let Us Screw you. Ok, I'm not resisting much.

The long version is...well...read Rob's post.

I'll be Microsoft's MVP Summit when this post goes up. Expect that this will be a topic of discussion.

Chandoo Launches PowerPivot Course! « PowerPivotPro

Have you been wanting to learn PowerPivot? Chandoo Launches PowerPivot Course!

United Nations Energy Consumption Insights Done with Microsoft Excel 2013, PowerPivot, Power View and the Azure Marketplace | Extended Results, Inc.

People are doing cool stuff with Excel 2013 like United Nations Energy Consumption Insights Done with Microsoft Excel 2013, PowerPivot, Power View and the Azure Marketplace .

What are you doing with Excel 2013 and Dynamics GP?

PowerPivot with Excel 2013

MS SQL Tips has a nice primer on PowerPivot with Excel 2013. There is chapter in my upcoming book, Building Dashboards with Dynamics GP 2013 and Excel 2013 on PowerPivot. You're going to love it.

Q&A with Rob Collie: Is Microsoft Excel the Next Great Business Intelligence Tool?

Q&A with Rob Collie: Is Microsoft Excel the Next Great Business Intelligence Tool?

You don't need any incentive from me. It's about PowerPivot, just read it.

Cloud Data Approaching Critical Mass

Power Pivot Pro looks at Cloud Data Approaching Critical Mass: Connection Cloud, SalesForce, PowerPivot, & Webinar on YouTube

Excel Blog - Introduction to PowerPivot in Excel 2013

From Excel Blog - Introduction to PowerPivot in Excel 2013

Weekly Review: PowerPivot and Multiple Cubes

Last week we looked at PowerPivot for analyzing Dynamics GP data. This week someone asked if you can connect to multiple cubes with PowerPivot. Yes you can. For testing I connected to the GP Financial Cube and Sales Cube and then was able to join them in PowerPivot. These cubes were both on the same server but given the way that PowerPivot connects that there is no reason that you couldn’t join cubes across servers assuming that the you have the right access.

Weekly Review: PowerPivot

If you are not already looking at PowerPivot from Microsoft for Business Intelligence now is the time to start. PowerPivot is designed to support end user/power user BI, including millions of records, from inside of Microsoft Excel. It works great with Dynamics GP tables, views or analysis cubes as a data source. Even better, it’s free.

PowerPivot required Microsoft Excel 2010 at a minimum and gains even more power with SQL Server 2008 R2 and Sharepoint PerformancePoint Services. If you need a compelling reason to start upgrading to Excel 2010, this is it.

You can find out more about PowerPivot and Dynamics GP here. The main PowerPivot page to download from is http://powerpivot.com/.

Mini-Post 2 of 2: PivotLink, Birst, QlikView, and “Desktop-Only” PowerPivot added to ROI Quadrant « PowerPivotPro

 

Since I’m working on a PowerPivot presentation for the GPUG Summit in October I thought this post on the ROI Quadrant might be interesting to you. Just a note, this is geared more toward ad hoc BI tools, not really CPM offerings.

PowerPivot Security Architecture Technical Diagram « Marcello Tonarelli Blog

Marcello shows off a pretty snazzy looking PowerPivot Security Architecture Technical Diagram

Download: PowerPivotSamples - Microsoft Download Center

I’m working on a presentation for the GPUG Summit that looks at PowerPivot and Dynamics GP. If you’ve been want to play with PowerPivot, check out the PowerPivotSamples from the  Microsoft Download Center

PowerPivot “Owns” Excel Now! « PowerPivotPro

Just a note from the folks at PowerPivotPro. PowerPivot “Owns” Excel Now! Specifically, the top 2 Excel books on Amazon are PowerPivot books.

Speaking of PowerPivot, I spent some time with Pivot Stream on Friday. They have options to move PowerPivot spreadsheets to the cloud including auto refresh via VPN.

I’ve had a number of folks ask about options to share and auto refresh PowerPivot based sheets without having to spend the dough for SharePoint Enterprise and this looks a great option.

Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX - SQLServerCentral

SQL Server Central shows us the Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX

I’m  a huge fan of PowerPivot for data analysis.