20
Strategies for Using Excel
In this final chapter, we return to the main theme of this book: methods of retrieving data from relational databases. In the previous few chapters, we took a detour from data retrieval to the related topics of modifying data, maintaining tables, and designing databases. Now we want to focus again on the task of retrieving and displaying data. More specifically, we’ll compare the capabilities of SQL to other available reporting tools and discuss strategies for employing the most appropriate tool for the job at hand.
In the broad business and corporate world, Microsoft Excel is the most widely available and pervasive reporting tool for the end user. One would be hard-pressed to find a business analyst who doesn’t ...
Get The Language of SQL, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
