Power Pivot for the Data Analyst: Excel 2010 Sample Data does not match lessons...

[Jerid421]

I am learning PowerPivot and DAX with Power Pivot for the Data Analyst: Excel 2010 and the sample data provided by the link in the e-book do not match up (at all) to the lessons. Does anyone know if I have an old version of these sample files or am I missing something (banging head against wall)!

Please help! Thanks!

 

[Derek Brown]

Hello and welcome to The Board.
I had exactly the same problem a couple of years ago.
My solution was to get a different book (Practical PowerPivot & DAX Formulas for Excel 2010).
I did not get past Chapter 4 with the FIRST book because there were some sample files either missing or not provided, making it difficult to follow along with the text.
The other book was different. There are 15 small sample files (mainly giving some of the SQL) but the big advantage is that the book uses the Microsoft Northwind database and the text is therefore very easy to follow. The pre-Access 2007 (the better) version of Northwind can be downloaded online and you can even download an Excel version of Northwind for use if you do not have Access installed. The book also covers SQL Server.
However, this book is probably not for the Excel beginner and you need to persevere when reading some of it. Because some paragraphs may cover SQL Server, Access and Excel you will need to sometimes decide what you want to 'skip'.

 

[Jerid421]

Thanks Derek... I thought I was going crazy for a while there. The **** files just didn't match up! I'll look into another book. You would think that a moderator here would be able to answer this questions though! Especially considering that they wrote the book and I've already paid for the **** thing! ; )

 

[Derek Brown]

There is a "MrExcel's Products" section on the Message Board Homepage and it is possible that, had you posted the question there, you may have got an answer from the Administrator before I found your post. However, they are usually kept very busy with many others things .....
If you want more information about the other book have a look at the reviews at Amazon.co.uk. I gave you an extract from my review that you will find there.
It is likely that the book, that you have, was rushed to Press .....