Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #11 (permalink)  
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
Reply With Quote
  #12 (permalink)  
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
Reply With Quote
  #13 (permalink)  
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?
Reply With Quote
  #14 (permalink)  
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.
Reply With Quote
  #15 (permalink)  
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
Reply With Quote
  #16 (permalink)  
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.
Reply With Quote
  #17 (permalink)  
Old February 26th, 2013, 10: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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 06:20 AM
finding free book "Beginning Jsp Book" ruzdi JSP Basics 0 December 7th, 2007 12:46 PM
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



All times are GMT -4. The time now is 02:41 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.