Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional Microsoft PowerPivot for Excel and SharePoint
This is the forum to discuss the Wrox book Professional Microsoft PowerPivot for Excel and SharePoint by Sivakumar Harinath, Ron Pihlgren, Denny Guang-Yeu Lee ; ISBN: 978-0-470-58737-9
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft PowerPivot for Excel and SharePoint section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 6th, 2010, 01:33 PM
Authorized User
 
Join Date: Nov 2003
Location: Hollywood, Fl, USA.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to sonicDace Send a message via MSN to sonicDace Send a message via Yahoo to sonicDace
Default

Hi, Ron,

Didn't even know you had a Power Pivot book out. I'll put it on my wish list
__________________
thanks
 
Old October 7th, 2010, 05:20 AM
Registered User
 
Join Date: Oct 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Datawarehouse and PowerPivot

Hi, Ron

I got your book and I started to read it. I don't have much experience with this, so I want to know about data warehouses and PowerPivot? I don't understand that concept, for example my company wants to implement PowerPivot, so do we need to create data warehouse or data mart (SQL 2008 R2) and create tables for example like those from Contoso sample database to put it on that server or we can use already existing Excel sheets and data of our company? Any help to understand this, please

Thank you
 
Old October 11th, 2010, 07:27 PM
Registered User
 
Join Date: Oct 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't get past Chapter 2

Hello Ron, I purchased your book and have not been able to get past the second chapter because I get an import error for FactSalesQuota - 'Memory error: Allocation failure: Not enough storage is available to process this command.'

I have a 6 Gig RAM laptop and am using 32bit and I think the issue would resolve with 64bit, however, I need to be able to use 32bit. I tried filtering and removing all services so I was only running PowerPivot, but with no luck. Will I be able to work through the exercises in your book with 32bit? Can you help?
 
Old October 12th, 2010, 05:56 AM
Registered User
 
Join Date: Jul 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

To import the FactSalesQuota table you will probably need to make sure that the id column on the table isn't included in the import.

This is because these values are uniques identifiers and therefore don't compress - making the size of the imported data much larger. You don't need these columns and they shouldn't really be on the source database anyway as they serve no real purpose. You can do the same for all the fact tables in those sample dbs.

Hope that helps.
 
Old May 9th, 2011, 11:34 AM
lt2 lt2 is offline
Registered User
 
Join Date: May 2011
Posts: 1
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hi Ron,

Just received the book today. Looking forward to delving into PowerPivot.

Lynn
 
Old August 14th, 2012, 12:41 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ron, I am in the process of reading your book.

Ron, I am in the process of reading your book that I bought from Barnes & Noble but when I received your book I was disappointed that you did not include a cd with the code nor did you include a PDF version of your book either on a cd or as a download. After buying the hardcopy book I don't want to pay more for a PDF version. I need to have the option to read your book on my computer because last year I lost an eye and it is difficult to read the hardcopy. I have successfully downloaded the book's code from this wrox site. I have seen other posts that individuals can not restore/attach the SQL Server database Microsoft Contos BI Demp Dataset for Retail Industy to SQL Server 2012 Express. With Microsoft's help, I have obtained a modified version of this database that DOES restore/attach to SQL Server 2012 Express and it works great in PowerPivot for Excel 2010. I would be willing to trade this modified database for a copy of your book in PDF format.
 
Old February 26th, 2013, 11:11 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default free pdf download

Do you know can we download this pdf book download free?
Thank you so muck.




Similar Threads
Thread Thread Starter Forum Replies Last Post
After completing this book. Then which book shoul? zhshqzyc ASP.NET 2.0 Basics 4 January 28th, 2009 07:20 AM
Help,I can't find my book in your book list. 5uer All Other Wrox Books 2 August 21st, 2004 12:43 AM
I can't find my book in your book list. duxn_79 All Other Wrox Books 2 July 13th, 2004 01:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.