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
  #1 (permalink)  
Old June 30th, 2010, 03:00 AM
Registered User
 
Join Date: Jun 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Anyone Reading Our Book?

Hello Out there. This is Ron, one of the co-authors of this book. Is there anyone out there who has read our booK? Any questions or feedback for us?

Thanks,
-Ron Pihlgren
  #2 (permalink)  
Old July 2nd, 2010, 07:54 AM
Registered User
 
Join Date: Jul 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up

Hi Ron,
Got your book yesterday! :)
I am already working with Power Pivot since 4 months or so but your book gave me some great insight into some parts (e.g. DAX) where before I only was using the try & error principle.

Looking forward to the SharePoint section - will start reading it over the weekend.

But one question: Where is this bloody download section on the wrox.com page?

Have a great day and weekend!

Best regards,
Andreas
  #3 (permalink)  
Old July 2nd, 2010, 12:27 PM
Registered User
 
Join Date: Feb 2009
Location: Seattle, WA
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey Andreas,

Glad you've enjoyed the book so far - hope the SharePoint section is meaningful, eh?! :) Saying this, the download section of the book is in the above section of the forum, the 2nd bullet to the right of the image of the book. Here's the link as well: http://www.wrox.com/WileyCDA/WroxTit...-DOWNLOAD.html

Hope this helps! And don't forget if it is warranted, please do prop up a review of the book on Amazon.com, eh?!

Thanks!
Denny
  #4 (permalink)  
Old July 5th, 2010, 06:58 AM
Registered User
 
Join Date: Jul 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Ron

Got your book the other day and am working through it. Very good so far, and already answered my first question - 'where does PowerPivot fit in with Microsoft's existing BI stack?'

One problem though - I've restored from the SDRAudit.bak file but some of the tables referenced on page 82 of the book (ie. AuditedObject) are missing - others have different names - ie. DatabasePrincipleName/mapDatabaseGroupName.

Have I missed something here?

As an aside, I don't have access to Sharepoint so was hoping to get as far as I can just on the Excel side of things - I'll see how I get on with that.

Thanks!
  #5 (permalink)  
Old July 6th, 2010, 01:01 PM
Registered User
 
Join Date: Jun 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Andre,

We're glad you are liking the book so far. We would appreciate an Amazon review once you have completed the book.

On the database issue, I will check on it today (I haven't actually looked at the bits available on the Wrox site yet but will) and reply later this evening.

Thanks!
-Ron
  #6 (permalink)  
Old July 7th, 2010, 01:12 AM
Registered User
 
Join Date: Jun 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Andre, looks like you are correct - the database file isn't the one that's expected. I'll work on getting the right DB backup file posted. Thanks for posting the issue.
  #7 (permalink)  
Old July 7th, 2010, 09:36 AM
Registered User
 
Join Date: Jul 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for looking into that Ron.

Have posted a brief review on Amazon - good book!
  #8 (permalink)  
Old July 14th, 2010, 12:45 AM
Registered User
 
Join Date: Jul 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Ron,
I am going through your book, and in Chapter 3 you still have issues. Here are the issues as I see them:
1. The SDR_Healtcare.xlsx workbook already has the data loaded. On page 84, you are walking through the steps of loading the data from the SRAudit DB, but the data is already loaded. This applies to the DB tables, as well as the linked Excel Sheet
2. As previously mentioned, the SRAudit database (restored from the Appendix A files) is the incorrect database.

When you combine both of these issues, it becomes kind of a sad story. I don't post to post a negative review on Amazon, so I think it would be great if you guys could fix both the .xlsx file AND the database as soon as possbile.

Thanks,
Bennie
  #9 (permalink)  
Old July 14th, 2010, 04:55 AM
Registered User
 
Join Date: Jul 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Personally I don't think the problems with the online content should prevent anyone from buying the book and they tend to become fairly obvious as you work through the chapters. This was the first book available on PowerPivot and I'd much rather have it now, glitches and all, rather than having to wait another couple of months. The issues with the online content can easily be resolved by the authors as they are reported.

I would like to point out one thing though - I had problems importing some of the fact table data (Contoso DB I think) due to lack of memory on my 32 bit OS. I see that others had experienced this too and the answer seems to be to remove some of the columns on the fact table - particularly the id column as this doesn't compress well. All was good once I did that.

-Andre
  #10 (permalink)  
Old July 14th, 2010, 07:53 PM
Registered User
 
Join Date: Jun 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Apologies folks for the confusion. Here's an update:

WRT the SDRAudit.bak database issue: the tables that are missing aren't used in later chapters building the healthcare application. The related tables you need to import are only the auditedAction table and the AuditedClassType tables. The other tables were initially considered to be used but later they weren't. So you can build the app without those tables.

This also affects Chapter 4. On Page 108 (#16), you are asked to create a relationship using the AuditedObject table. This relationship also isn't needed later in the book.

WRT the SDR_Healthcare.xlsx already having the data loaded: The AppendixA.zip file (used to create the starting state of the healthcare app) doesn't contain SDR_Healthcare.xlsx. The various chapter downloads do contain versions of this spreadsheet with data already loaded but that is by design - those chapter downloads are intended to be the state of the workbook at the end of each of those chapters. They are available in case you wanted to play around with those chapters' results without going through the steps of actually creating the app or for working through the instructions of the following chapters without starting from scratch.

I'll send some email to the Wrox folks so that the errata gets updated for these issues.

Just another comment: we did rush to get the book out in time for the release of PowerPivot and apologize for the "rough edges" folks are finding. We appreciate you folks who raise these issues and we will work through them to help get you answers and update the errata pages. Thank you all.

-Denny, Ron, Siva




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.