Product DescriptionIf 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
Customer Reviews
Average Rating:
Rating: - "Advance" means for DBAs Level
Ok...guys...I got this book today and I spend all day just to understand how I can apply available files on Author's web site by reading the text at the same time. It's very hard and complicated process!!!! Owww my god!!!! Text is nice, but files are horrible. The way author drives you through his material ... let me say easy: you have to possess some knowledge about SQL Server 2000 and SQL ,and Access ,and about many other aspects of software. Guys on the bottom are correct: this book covers some ... Read More
Rating: - Help for Business Application Sufferers
This book is an immense help to someone at a small- to medium-sized company who is laboring to create to create printed reports using their business application's report-writing tools. The author shows you how to use SQL Query to access the database directly from Excel to create electronic reports with drill-down functionality. My users love them, and it is so Lean not to waste people's time re-entering information from a printed report.
The chapters on pivot tables are better than some ... Read More
Rating: - Very Good...
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.
Rating: - Very good quick start guide, focused on reporting
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.
Rating: - Great book from basics to advanced
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.
- "Advance" means for DBAs Level
- Help for Business Application Sufferers
- Very good quick start guide, focused on reporting
