Amazon.com Widgets

Data Analysis with Microsoft Access 2010: From Simple Queries to Business Intelligence

Larry Rockoff

Course Technology PTR

November 2011

Paperback, 304 pages

ISBN: 1435460103

Buy from Amazon

On-Site and On-Line Training Courses for Business Analysts

All About Use Cases
How to Analyze and Improve Business Processes
How to Build Business Data Models
How to Build Business Process Models
How to Elicit (Gather), Write, and Analyze Business Requirements
How to Model, Analyze, and Improve Business Data
How to Model, Analyze, and Improve Business Processes
Writing Effective Business Requirement Statements

DATA ANALYSIS WITH MICROSOFT ACCESS 2010 is an introductory text focused on those topics in Access that are most relevant to data analysis. The emphasis is on data retrieval and in transforming data into structures that are useful for analysis. The goal is to help the analyst gain a true understanding of data and the information it contains. Access queries are covered in detail, both in terms of the mechanics of their design, and how they can be used for typical data analysis tasks. The book pays close attention to the GUI (graphical user interface) of Access, and explains how the interface relates to the SQL logic that lies beneath all queries. The author also broadens the concept of data analysis to encompass Business Intelligence (BI) topics. This includes a discussion of basic dimensional modeling, as well as the use of Access and Excel pivot tables. While the emphasis in the book is on Access queries, there is also discussion of Access tables, and extra material on forms, macros and reports in an appendix. A companion website has a sample database that correlates with the Business Intelligence material in the book. Additional features include "See the SQL" sidebars that allow interested readers to learn SQL as they are learning Access, and "Focus on Analysis" sidebars with details on a number of quantitative topics.

New Features< br />

Covers the most recent version of Microsoft Access.
Emphasizes features beneficial for data analysis.
Addresses Business Intelligence (BI) concepts.
Relates Microsoft Access concepts to sql.
Focuses on Critical, but general concepts, without excessive detail.
Includes a companion website that provides a complete sample Microsoft Access database that illustrates how to effectively implement business intelligence concepts using Access.

About the Author:

Larry Rockoff

Larry Rockoff has been involved with SQL and Business Intelligence (BI) development for many years. His main area of expertise is with data warehouse systems and reporting tools. He recently developed a suite of BI tools for ASAP Software, which is now a subsidiary of Dell. He holds an MBA from the University of Chicago, with a specialization in Management Science.

Buy from Amazon