Data analysis with Microsoft Access 2010 : from simple queries to business intelligence /
| Основен автор: | Rockoff, Larry. |
|---|---|
| Формат: | Електронна книга |
| Език: | English |
| Публикувано: |
Boston, MA :
Course Technology Ptr,
℗♭2012.
|
| Предмети: | |
| Онлайн достъп: |
http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=400093 |
| Подобни документи: |
Print version::
Data analysis with Microsoft Access 2010. |
Съдържание:
- What is data analysis?
- An overview of Access
- Tables and external data
- Select queries
- Joins and relationships
- Relational database design
- Expressions and functions
- Selection criteria
- Summarizing data
- Subqueries and set logic
- Action queries
- Crosstab queries and pivot tables
- What is business intelligence?
- Dimensional modeling
- The data warehouse
- Excel pivot tables
- Appendix A. Forms, macros, and reports
- Appendix B.A sample business intelligence database.