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

作者: Larry Rockoff 著

出版社: Cengage Learning

出版时间: 2011-10

版次: 1

ISBN: 9781435460102

定价: 315.10

装帧: 平装

开本: 其他

纸张: 其他

页数: 400页

正文语种: 英语

分类: 外文古旧书>英文书>计算机与互联网

DATAANALYSISWITHMICROSOFTACCESS2010isanintroductiontoAccesswithanemphasisontopicsrelevanttodataanalysis.Thegoalistohelptheanalystgainatrueunderstandingofdataandtheinformationitcontains.Accessqueriesarecoveredindetail,bothintermsofthemechanicsoftheirdesign,andhowtheycanbeusedfortypicaldataanalysistasks.Thebookiswritteninaneasy-to-understandtutorialstyle,withnewtopicsintroducedinalogicalandintuitivesequence.Numerousscreenshotsareincluded,soyouwon'tneedtositwithacomputerasyoureadthebook.Theauthoralsobroadenstheconceptofdataanalysistoencompassbusinessintelligence(BI)topics,includingvaluablematerialonhowtouseAccessandExcelpivottables.Additionalfeaturesinclude"SeetheSQL"sidebarsthatallowinterestedreaderstolearnSQLastheyarelearningAccess,and"FocusonAnalysis"sidebarsthatprovidedetailsonanumberofusefulquantitativetopics.AcompanionwebsitehasasampledatabasethatcorrelateswiththeBImaterialinthebook.Inshort,thisistheonlybookyou'llneedtogainaworkingknowledgeofAccess,andhowitcanbeusedfordataanalysis. LarryRockoffhasbeeninvolvedwithAccess,SQL,andbusinessintelligencedevelopmentformanyyears.HeholdsanMBAfromtheUniversityofChicago,withaspecializationinManagementScience.Hispriorbook,THELANGUAGEOFSQL,waspublishedbyCengageLearningin2010andisavailableworldwideinbothpaperandelectronicform. Introduction.
PartI:GETTINGSTARTED.
1.WhatisDataAnalysis?
2.OverviewofAccess.
PartII:ACCESSQUERIES.
3.TablesandExternalData.
4.SelectQueries.
5.JoinsandRelationships.
6.RelationalDatabaseDesign.
7.ExpressionsandFunctions.
8.SelectionCriteria.
9.SummarizingData.
10.SubqueriesandSetLogic.
11.ActionQueries.
12.CrosstabQueriesandPivotTables.
PartIII:CREATINGBUSINESSINTELLIGENCE.
13.WhatisBusinessIntelligence?
14.DimensionalModeling.
15.TheDataWarehouse.
16.ExcelPivotTables.
AppendixA:Forms,MacrosandReports.
AppendixB:ASampleBusinessIntelligenceDatabase.
内容简介:
DATAANALYSISWITHMICROSOFTACCESS2010isanintroductiontoAccesswithanemphasisontopicsrelevanttodataanalysis.Thegoalistohelptheanalystgainatrueunderstandingofdataandtheinformationitcontains.Accessqueriesarecoveredindetail,bothintermsofthemechanicsoftheirdesign,andhowtheycanbeusedfortypicaldataanalysistasks.Thebookiswritteninaneasy-to-understandtutorialstyle,withnewtopicsintroducedinalogicalandintuitivesequence.Numerousscreenshotsareincluded,soyouwon'tneedtositwithacomputerasyoureadthebook.Theauthoralsobroadenstheconceptofdataanalysistoencompassbusinessintelligence(BI)topics,includingvaluablematerialonhowtouseAccessandExcelpivottables.Additionalfeaturesinclude"SeetheSQL"sidebarsthatallowinterestedreaderstolearnSQLastheyarelearningAccess,and"FocusonAnalysis"sidebarsthatprovidedetailsonanumberofusefulquantitativetopics.AcompanionwebsitehasasampledatabasethatcorrelateswiththeBImaterialinthebook.Inshort,thisistheonlybookyou'llneedtogainaworkingknowledgeofAccess,andhowitcanbeusedfordataanalysis.
作者简介:
LarryRockoffhasbeeninvolvedwithAccess,SQL,andbusinessintelligencedevelopmentformanyyears.HeholdsanMBAfromtheUniversityofChicago,withaspecializationinManagementScience.Hispriorbook,THELANGUAGEOFSQL,waspublishedbyCengageLearningin2010andisavailableworldwideinbothpaperandelectronicform.
目录:
Introduction.
PartI:GETTINGSTARTED.
1.WhatisDataAnalysis?
2.OverviewofAccess.
PartII:ACCESSQUERIES.
3.TablesandExternalData.
4.SelectQueries.
5.JoinsandRelationships.
6.RelationalDatabaseDesign.
7.ExpressionsandFunctions.
8.SelectionCriteria.
9.SummarizingData.
10.SubqueriesandSetLogic.
11.ActionQueries.
12.CrosstabQueriesandPivotTables.
PartIII:CREATINGBUSINESSINTELLIGENCE.
13.WhatisBusinessIntelligence?
14.DimensionalModeling.
15.TheDataWarehouse.
16.ExcelPivotTables.
AppendixA:Forms,MacrosandReports.
AppendixB:ASampleBusinessIntelligenceDatabase.

查看详情

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

内容简介:

作者简介:

目录: