Denny Lee

Ramblings of a data dork: from BI and Big Data to Travel and Food

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 3 of 3)

Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an … Continue reading

Rate this:

January 31, 2010 · 6 Comments

Reading your #PowerPivot Profiler trace

To help troubleshoot your PowerPivot for Excel workbook, you can click on Settings within the PowerPivot selection in the Office Ribbon which will bring up the Support & Diagnostics tab … Continue reading

Rate this:

January 30, 2010 · 3 Comments

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 2 of 3)

Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an … Continue reading

Rate this:

January 28, 2010 · 6 Comments

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)

Background I was recently working with a customer to help them solve an interesting PowerPivot problem where they had wanted to get the Top 10 users within their data set … Continue reading

Rate this:

January 27, 2010 · 12 Comments

#PowerPivot Data Refresh SSRS Report

As many of you already know, in order to figure out which workbooks had succeeded or failed execute in their data refresh, you need only to go the PowerPivot Management … Continue reading

Rate this:

January 19, 2010 · 3 Comments

How do I get the menu options for individual reports within the #PowerPivot Gallery?

When you start playing with the PowerPivot Gallery, some of you will be enamored by the various views of the Silverlight control included as part of the PowerPivot Gallery – … Continue reading

Rate this:

January 15, 2010 · 1 Comment

Pros/Cons of deploying #SSIS with the SQL engine server

I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL … Continue reading

Rate this:

January 10, 2010 · 5 Comments

The Great #PowerPivot FAQ is now accepting applications

Just in case you didn’t already know from the tweets, I figured I’d also give a shout out (again) to the “Great PowerPivot FAQ” and note the fact that it … Continue reading

Rate this:

January 9, 2010 · Leave a Comment

The Great PowerPivot FAQ!

Just in case you’re not already aware of this, some of great contributors to the PowerPivot community are now adding and moderating to the Great PowerPivot FAQ.  Please check it … Continue reading

Rate this:

January 6, 2010 · Leave a Comment

Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI

When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file.  … Continue reading

Rate this:

January 6, 2010 · 7 Comments

Quick Tips for clearing up space #PowerPivot for SharePoint Uploading

When you upload your PowerPivot for Excel workbook to your PowerPivot enabled SharePoint site, you typically will deal with much larger files than your other SharePoint sites.  This is the … Continue reading

Rate this:

January 6, 2010 · 2 Comments

More great PowerPivot resources!

As you already may know, we have a couple of forums for PowerPivot at: SQL Server 2008 R2 PowerPivot for Excel SQL Server 2008 R2 PowerPivot for SharePoint Dave Wickert … Continue reading

Rate this:

January 5, 2010 · 1 Comment

Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX

Analysis Services Multidimensional and Tabular Reference all in one handy book!

@dennylee

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,002 other followers

Copyright

Copyright © 2012 Denny G Lee - All Rights Reserved
Follow

Get every new post delivered to your Inbox.

Join 2,002 other followers