Excel Advanced Report Developmentby Timothy Zapawa
If you're a SQL programmer or an experienced Excel user, here at last is the ultimate resource on developing reporting solutions with Excel. Focused on report development using OLTP databases, this book is packed with comprehensive information on both technical and strategic aspects. You'll thoroughly examine the main features of Excel's reporting
If you're a SQL programmer or an experienced Excel user, here at last is the ultimate resource on developing reporting solutions with Excel. Focused on report development using OLTP databases, this book is packed with comprehensive information on both technical and strategic aspects. You'll thoroughly examine the main features of Excel's reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components. With notes, tips, warnings, and real-world examples in each chapter, you'll be able to put your knowledge to work immediately. This book includes:
- Single-source coverage of Excel's report development features
- Extensive and in-depth information on PivotTable and Spreadsheet report features, functions, and capabilities
- Thorough documentation of the Microsoft Query program included with Excel
- Comprehensive information on Excel's client-based OLAP cube tools for processing very large datasets from OLTP data sources
- Detailed information on creating and working with web-enabled Excel reports
- Publication date:
- Product dimensions:
- 7.32(w) x 9.24(h) x 1.06(d)
Meet the Author
Timothy Zapawa is a project director atAdvantage Computing Systems, Inc., where he leads teams of engineers, developers, and managers through long-term software implementations. He has developed software training programs and has obtained several professional and technical certifications, including Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Database Administrator (MCDBA).
Most Helpful Customer Reviews
See all customer reviews
I went to the book store looking for another title concerning Excel reporting. The book was not available so I started looking at other books on the subject. This book caught my eye because of the title and subject matter. I was not disappointed. I have found this book to be on point. I really appreciated the examples since I am a strong visual learner and the SQL queries. I had problems with the video examples that was okay because I did not need them. This book is a winner.
Excellent book! This is by far the best book I've read on PivotTable reporting. It's jam-packed with SQL query examples and it is the first book I've seen that shows how client OLAP and web-enabled reporting really work. The author really shows his expertise on how reports really work in the enterprise.