Denny Lee

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

A Primer on PowerPivot Topologies and Configurations

For those who would like a quick primer on PowerPivot Topologies and Configurations, check out the SlideShare below. Enjoy!

Rate this:

March 29, 2012 · 2 Comments

Can I access PowerPivot via a data access API?

I recently got asked the question: Does PowerPivot have any data access APIs? Is there any way to to programmatically access the data store?   I figured that a lot … Continue reading

Rate this:

October 27, 2010 · 2 Comments

PowerPivot for SharePoint: Existing Farm Installation

So the fate… of the entire human race depends upon my wild guess      — Doctor Gaius Baltar (Battlestar Galactica)     Actually, the quote that I really wanted to … Continue reading

Rate this:

September 14, 2010 · Leave a Comment

PowerPivot for SharePoint: Single Server Installation

A long time ago, but not in a galaxy too far away…actually, just in Redmond, WA,… there was A NEW HOPE for easier PowerPivot for SharePoint installations! So hats off … Continue reading

Rate this:

August 30, 2010 · 3 Comments

Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!

One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an Atom feed) and its data can be imported directly into … Continue reading

Rate this:

August 21, 2010 · 9 Comments

PowerPivot Technical Diagram: PowerPivot Security Architecture

Just in case you didn’t already know, we just uploaded the PowerPivot Security Architecture technical diagram on to sqlcat.com / MSDN.  To get access to the PDF, XPS, and/or VSD … Continue reading

Rate this:

August 18, 2010 · Leave a Comment

Dude, Where’s my PowerPivot workbook?

In homage to Rob Collie’s blog posting style (yes!…he has style, he has grace, …) and of course the movie “Dude, Where’s my Car?”, let’s ask a new question: Dude, … Continue reading

Rate this:

April 14, 2010 · Leave a Comment

Ramblings about missing time … and #PowerPivot sneak peek!

Wow, I just checked and its been more than a month since I did my last blog post!  So for starters, apologies for the lack of cool PowerPivot stuff on … Continue reading

Rate this:

April 5, 2010 · 4 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

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

Troubleshooting #PowerPivot Excel Services connectivity

You’re on your way to PowerPivot for SharePoint functionality – you’ve uploaded your PowerPivot for Excel workbook to your SharePoint PowerPivot Gallery.  You view the thumbnails of your report and … Continue reading

Rate this:

November 18, 2009 · 5 Comments

SharePoint Prerequisite Lab Installation Tip (#PowerPivot CTP3 Install)

When you install SharePoint Beta 2 to go with your PowerPivot for SharePoint CTP3 install, some will install SharePoint on a set of servers (or VMs) that do not have … Continue reading

Rate this:

November 11, 2009 · 6 Comments

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