Data Analysis with Microsoft Access 2010: From Simple Queries to Business Intelligence
Preț: 102,00 lei
Disponibilitate: la comandă
Autor: Larry Rockoff
ISBN: 9781435460102
Editura: Cengage
Anul publicării: 2012
Pagini: 400
DESCRIERE
DATA ANALYSIS WITH MICROSOFT ACCESS 2010 is an introduction to Access with an emphasis on topics relevant to data 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 is written in an easy-to-understand tutorial style, with new topics introduced in a logical and intuitive sequence. Numerous screenshots are included, so you won't need to sit with a computer as you read the book. The author also broadens the concept of data analysis to encompass business intelligence (BI) topics, including valuable material on how to use Access and Excel pivot tables. Additional features include "See the SQL" sidebars that allow interested readers to learn SQL as they are learning Access, and "Focus on Analysis" sidebars that provide details on a number of useful quantitative topics. A companion website has a sample database that correlates with the BI material in the book. In short, this is the only book you'll need to gain a working knowledge of Access, and how it can be used for data analysis.
Features
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.
Introduction.
Part I: GETTING STARTED.
1. What is Data Analysis?
2. Overview of Access.
Part II: ACCESS QUERIES.
3. Tables and External Data.
4. Select Queries.
5. Joins and Relationships.
6. Relational Database Design.
7. Expressions and Functions.
8. Selection Criteria.
9. Summarizing Data.
10. Subqueries and Set Logic.
11. Action Queries.
12. Crosstab Queries and Pivot Tables.
Part III: CREATING BUSINESS INTELLIGENCE.
13. What is Business Intelligence?
14. Dimensional Modeling.
15. The Data Warehouse.
16. Excel Pivot Tables.
Appendix A: Forms, Macros and Reports.
Appendix B: A Sample Business Intelligence Database.
Larry Rockoff
Larry Rockoff has been involved with Access, SQL, and business intelligence development for many years. He holds an MBA from the University of Chicago, with a specialization in Management Science. His prior book, THE LANGUAGE OF SQL, was published by Cengage Learning in 2010 and is available worldwide in both paper and electronic form.
Features
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.
Introduction.
Part I: GETTING STARTED.
1. What is Data Analysis?
2. Overview of Access.
Part II: ACCESS QUERIES.
3. Tables and External Data.
4. Select Queries.
5. Joins and Relationships.
6. Relational Database Design.
7. Expressions and Functions.
8. Selection Criteria.
9. Summarizing Data.
10. Subqueries and Set Logic.
11. Action Queries.
12. Crosstab Queries and Pivot Tables.
Part III: CREATING BUSINESS INTELLIGENCE.
13. What is Business Intelligence?
14. Dimensional Modeling.
15. The Data Warehouse.
16. Excel Pivot Tables.
Appendix A: Forms, Macros and Reports.
Appendix B: A Sample Business Intelligence Database.
Larry Rockoff
Larry Rockoff has been involved with Access, SQL, and business intelligence development for many years. He holds an MBA from the University of Chicago, with a specialization in Management Science. His prior book, THE LANGUAGE OF SQL, was published by Cengage Learning in 2010 and is available worldwide in both paper and electronic form.
Accesul clienţilor
-Top 10
-Cărţi noi
-- 344,25 leiPRP: 382,50 lei
- 1505,52 leiPRP: 1672,80 lei
- 546,21 leiPRP: 606,90 lei
Promoţii
-- 280,00 leiPRP: 350,00 lei
- 29,25 leiPRP: 45,00 lei
- 29,25 leiPRP: 45,00 lei
RECENZII