Customer Reviews

Excel Advanced Report Development

5 star:		(10)
4 star:		(3)
3 star:		(1)
2 star:		(1)
1 star:		(0)

 

 

I would highly recommend this book to anyone who is interested in -- or who needs to learn about -- PivotTables, as well as Excel reporting in general. The coverage in this book is comprehensive, providing information on Excel report topics that just isn't available in most other books.
Here are just 10 items that I learned about from this book:

1. Prompting the user for parameters in Excel reports (Chapter 11): Parameters can be used with PivotTable lists or Spreadsheet reports, and they can also make the report run much faster and filter the returned dataset to a particular date range, division or product line.

2. Building Report Control Centers (Chapter 11): I learned how to build Spreadsheet report control centers that accept parameters and support a number of helpful functions, including:
* Automatic report refreshes when a parameter value is changed
* Drop-down lists of valid values that the user can choose to automatically refresh a report
* Specific field formats to ensure that the data is entered correctly
And, I learned how to do all this through simple, native graphical tools - there was no need for complex VBA programming!

3. Creating ultra-fast client-side OLAP cubes (Chapter 10): Given that I'm not actually data warehouse savvy, nor do I have the time to learn Analysis Services, Excel's client-side OLAP was perfect for me. I've been able to use it to organize data into dimension-level hierarchies for drilling-through data. And I was able to automatically rebuild OLAP cubes directly from Excel. The best part -- all 3 client-side OLAP cubes are covered in extensive detail in this book, unlike most other books on this topic which tend to just cover OLAP cubes in passing.

4. Hiding SQL queries (Chapter 6): I learned how to hide SQL queries from users in order to prevent them from viewing or modifying my report query.

5. Retrieving Data from OLTP databases (Chapter 2-9, 11, and 12): This book provides numerous examples of how data can be extracted from Access, SQL and Oracle databases, which has proved to be invaluable to me at work. And, this book also covers Text files (Chapter 3), OLAP cubes (Chapter 10), Web Sites (Chapter 11) and other data sources (Chapter 3). I even learned how to extract data from multiple databases - on the same or different servers (Chapter 6).

6. Fixing annoying problems with field names (Chapter 7): I learned how field headings from SQL queries can get corrupted - this book explained why this happens and, more importantly, how to fix it.

7. Publishing and using web-enabled reports (Chapter 12): This book dedicates an entire chapter to web-enabled reports. It shows how the best features of PivotTable and Spreadsheet reports are combined into PivotTable lists - and how to navigate through all the new functions, features and tools.

8. Restricting the number of rows returned (Chapter 7): This book showed me how to restrict the number of rows returned in a PivotTable and Spreadsheet reports.

9. Comprehensive coverage of PivotCharts (Chapter 9): This book dedicates an entire chapter to PivotCharts - and it focuses only on the important and relevant tools, techniques, features and functions of PivotCharts.

10. Complete SQL reference (Appendix B): I just have a basic knowledge of writing SQL. The appendix in this book was great! It really helped me fill in some of my gaps with basic SQL and I'm not writing more advanced SQL queries - thanks to this book!

The author even helped me out with a few questions that I had about using text files (his email address is in the last chapter). I highly recommend that you buy this book if you have any interest in PivotTable or other types of Excel reporting books. It's truly the best on the subject!

The MS Query Program is one of Microsoft's best-kept secrets. It is almost impossible to find *thorough* documentation, much less good examples of how to use it.

After struggling for over two years learning to use MS Query by trial and error, I was extremely pleased to find this book.

I just wish the author had covered Oracle a bit more, since I have discovered that MS Query doesn't always work as advertised with Oracle, or at least Oracle 8i. For example, you cannot rename columns when accessing Oracle.

I am also curious about a statement on page 70, where he is describing the process of setting up a DSN for a CSV file. He states, "WARNING: A software bug in Microsoft Excel requires that fields with a data type of Char be set to LongChar." There is no further explanation for this, except that he mentions that the data may be corrupted.

I have used DSNs for text files (CSV and tab-delimited)in MS Query and in other programs for about two years, and have never encountered a problem with this. In fact, I had never heard of "LongChar" before this.

Furthermore, I tried to set up a query using a DSN that I had created using this advice, and it did not work. It worked fine once I changed the data type back to Char.

But I gave it five stars anyway, because it is the best book available on this subject, which seems to have eluded other Excel users and authors.

Marty Ryerson.

Wow!! This book has everything in it on PivotTable reports, PivotTable lists, parameter queries and the MS Query program. And the SQL queries that are used in some of these reports are amazing. This is definitely the best book I've read on the topic. Finally a book that has some SQL and more advanced topics of PivotTable reporting. I was especially impressed with the coverage of Excel's client-based OLAP tools. This is also the first book I've seen with videos.

I never knew how much reporting capability there was in Excel until I read this book. I have a decent knowledge of SQL, but this guy really shows how it can work with PivotTables, Spreadsheet reports and even web-enabled reports. I finally found out how parameters are used with stored procedures. Very well written and organized.

This is the first book that I've seen on PivotTable reports that uses SQL for many of the report examples. It also thoroughly covers the Microsoft Query program and using external data sources. Excellent book - I highly recommend it.

This book covers all the tricks I've picked up slogging through trying to create pivot table reports for the company I work for - and then some. Boy, do I wish I had it before I spent all that time.

Clearly written and easy to follow I think this a good book for users of all levels. You do need some knowledge of Excel and SQL - but not as much as you might think.

This book has been tremendously helpful to me. If you ever have reason to pull data from a SQL database into Excel, you really owe it to yourself to read this book. In addition to being packed with great information, it is a very easy read. It is one of the few books out there that has something to offer to users of all experience levels. Highly, highly recommended.

Our company has been trying to implement data cubes and PivotTable reports, but we were struggling with the implementation. After reading this book, I finally understood how the multitude of options can actually be 'applied' to develop powerful reports. For example, the author shows how you can specify beginning and ending dates to refresh report data, change database locations and even query multiple databases on different servers. The coverage on the MS Query program, web-enabled reports and data options is by far the best out there. And if you're looking for a book that really uses SQL, this is it!

I have looked forever for a book that covers the basics *and* advanced concepts of using Microsoft Query as a tool to access data from a SQL database. This book is it. As someone who has learned how to do this through nothing but trial and error, this book offered a lot of insight on how things should be done and why those strange bugs appear. I highly recommend it.

This book is an excellent introduction to the reporting capabilities available in Excel. Prior to reading this book I had no idea that these capabilites existed. There is an assumption that you have access to a MS SQL Server for some of the content, but other than that I have no complaints.