Excel Advanced Report Development
(Sprache: Englisch)
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.
Leider schon ausverkauft
versandkostenfrei
Buch
34.90 €
Produktdetails
Produktinformationen zu „Excel Advanced Report Development “
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.
Klappentext zu „Excel Advanced Report Development “
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 andworking with web-enabled Excel reports
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.
* Single-source coverage of Excel's report development features
* Extensive and in-depth information on PivotTable(r) and Spreadsheet report features, functions, and capabilities
* Thorough documentation of the Microsoft(r) 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
Companion web site
Example files for all the exercises in the book are available for download at www.wiley.com/go/excelreporting, where you can also watch videos illustrating various lessons.
* Single-source coverage of Excel's report development features
* Extensive and in-depth information on PivotTable(r) and Spreadsheet report features, functions, and capabilities
* Thorough documentation of the Microsoft(r) 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
Companion web site
Example files for all the exercises in the book are available for download at www.wiley.com/go/excelreporting, where you can also watch videos illustrating various lessons.
Inhaltsverzeichnis zu „Excel Advanced Report Development “
Acknowledgments.Introduction.
Part I: Report Initiation and Source Data.
Chapter 1: Taking a First Look at Excel's Reporting Tools.
Chapter 2: Getting Started with PivotTables.
Chapter 3: Understanding and Accessing Source Data.
Chapter 4: Using the Query Wizard.
Chapter 5: Getting Started with Microsoft Query.
Chapter 6: Working with SQL in Microsoft Query.
Part II: Advanced Reporting Features.
Chapter 7: Designing PivotTable Reports.
Chapter 8: Managing PivotTable Data.
Chapter 9: Exploring PivotChart Functionality.
Chapter 10: Working with OLAP Cubes.
Chapter 11: Creating and Using Spreadsheet Reports.
Chapter 12" Using Excel Reports on the Web.
Part III: Appendixes.
Appendix A: Configuring Your System.
Appendix B: SQL Reference.
Index.
Autoren-Porträt von Timothy Zapawa
Timothy Zapawa is a Project Director at AdvantageComputing Systems in Ann Arbor, Michigan, where he manages implementation projects of enterprise softwaresystems for book and magazine publishers around the world. He holds several professional and technical certifications and has developed training courses on delivering business intelligence, building report solutions, and developing SQL queries and programs in SQL and Oracle databases.
Bibliographische Angaben
- Autor: Timothy Zapawa
- 2005, 1. Auflage., 550 Seiten, Kartoniert (TB), Englisch
- Verlag: Wiley & Sons
- ISBN-10: 0764588117
- ISBN-13: 9780764588112
Sprache:
Englisch
Kommentar zu "Excel Advanced Report Development"
0 Gebrauchte Artikel zu „Excel Advanced Report Development“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Excel Advanced Report Development".
Kommentar verfassen