skip to content
Data analysis using SQL and Excel Preview this item
ClosePreview this item
Checking...

Data analysis using SQL and Excel

Author: Gordon Linoff
Publisher: Indianapolis, IN : Wiley Pub., ©2008.
Edition/Format:   Print book : EnglishView all editions and formats
Summary:
"Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Gordon Linoff
ISBN: 9780470099513 0470099518 9780470228227 0470228229
OCLC Number: 145732996
Notes: Includes index.
Description: xli, 645 pages : illustrations ; 24 cm
Contents: Introduction --
A Data Miner Looks at SQL --
What's in a Table? Getting Started with Data Exploration --
How Different is Different? --
Where is it all Happening? Location, Location, Location --
It is a Matter of Time --
How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value --
Factors Affecting Survival: The What and Why of Customer Tenure --
Customer Purchases and Other Repeated Events --
What's in a Shopping Cart? Market Basket Analysis and Association Rules --
Data Mining Models in SQL --
The Best Fit Line: Linear Regression Models --
Building Customer Signatures for Further Analysis --
Appendix A. Equivalent Constructs Among Databases --
Index.
Responsibility: Gordon S. Linoff.
More information:

Abstract:

Mastering Data Analysis and Mining with SQL and Excel shows business managers and data analysts how to use the relatively simple tools of SQL and Excel to extract useful business information from  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/145732996> # Data analysis using SQL and Excel
    a schema:Book, schema:CreativeWork ;
    library:oclcnum "145732996" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/inu> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/103503545#Place/indianapolis_in> ; # Indianapolis, IN
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/dataprocessing> ; # Dataprocessing
    schema:about <http://id.worldcat.org/fast/1102869> ; # SQL (Computer program language)
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/sql> ; # SQL
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/interrogation_informatique> ; # Interrogation (Informatique)
    schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/exploration_de_donnees_informatique> ; # Exploration de données (Informatique)
    schema:about <http://id.worldcat.org/fast/1739127> ; # Querying (Computer science)
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/sql_langage_de_programmation> ; # SQL (Langage de programmation)
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/datamining> ; # Datamining
    schema:about <http://dewey.info/class/005.7585/e22/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
    schema:about <http://id.worldcat.org/fast/887946> ; # Data mining
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#CreativeWork/microsoft_excel> ; # Microsoft Excel.
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/microsoft_excel> ; # Microsoft Excel
    schema:bookFormat bgn:PrintBook ;
    schema:copyrightYear "2008" ;
    schema:creator <http://viaf.org/viaf/85292409> ; # Gordon Linoff
    schema:datePublished "2008" ;
    schema:description "Introduction -- A Data Miner Looks at SQL -- What's in a Table? Getting Started with Data Exploration -- How Different is Different? -- Where is it all Happening? Location, Location, Location -- It is a Matter of Time -- How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value -- Factors Affecting Survival: The What and Why of Customer Tenure -- Customer Purchases and Other Repeated Events -- What's in a Shopping Cart? Market Basket Analysis and Association Rules -- Data Mining Models in SQL -- The Best Fit Line: Linear Regression Models -- Building Customer Signatures for Further Analysis -- Appendix A. Equivalent Constructs Among Databases -- Index."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/103503545> ;
    schema:inLanguage "en" ;
    schema:name "Data analysis using SQL and Excel"@en ;
    schema:productID "145732996" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/145732996#PublicationEvent/indianapolis_in_wiley_pub_2008> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/103503545#Agent/wiley_pub> ; # Wiley Pub.
    schema:reviews <http://www.worldcat.org/title/-/oclc/145732996#Review/-1298988413> ;
    schema:url <http://www.dawsonera.com/depp/reader/protected/external/AbstractView/S9780470228227> ;
    schema:url <http://catdir.loc.gov/catdir/enhancements/fy0740/2007026313-t.html> ;
    schema:url <http://www.dawsonera.com/guard/protected/dawson.jsp?name=London%20Metropolitan%20University&dest=http://www.dawsonera.com/depp/reader/protected/external/AbstractView/S9780470228227> ;
    schema:workExample <http://worldcat.org/isbn/9780470228227> ;
    schema:workExample <http://worldcat.org/isbn/9780470099513> ;
    umbel:isLike <http://bnb.data.bl.uk/id/resource/GBA757631> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/145732996> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/103503545#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Place/indianapolis_in> # Indianapolis, IN
    a schema:Place ;
    schema:name "Indianapolis, IN" ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Topic/exploration_de_donnees_informatique> # Exploration de données (Informatique)
    a schema:Intangible ;
    schema:name "Exploration de données (Informatique)"@fr ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Topic/interrogation_informatique> # Interrogation (Informatique)
    a schema:Intangible ;
    schema:name "Interrogation (Informatique)"@fr ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Topic/sql_langage_de_programmation> # SQL (Langage de programmation)
    a schema:Intangible ;
    schema:name "SQL (Langage de programmation)"@fr ;
    .

<http://id.worldcat.org/fast/1102869> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://id.worldcat.org/fast/1739127> # Querying (Computer science)
    a schema:Intangible ;
    schema:name "Querying (Computer science)"@en ;
    .

<http://id.worldcat.org/fast/887946> # Data mining
    a schema:Intangible ;
    schema:name "Data mining"@en ;
    .

<http://viaf.org/viaf/85292409> # Gordon Linoff
    a schema:Person ;
    schema:familyName "Linoff" ;
    schema:givenName "Gordon" ;
    schema:name "Gordon Linoff" ;
    .

<http://worldcat.org/isbn/9780470099513>
    a schema:ProductModel ;
    schema:isbn "0470099518" ;
    schema:isbn "9780470099513" ;
    .

<http://worldcat.org/isbn/9780470228227>
    a schema:ProductModel ;
    schema:isbn "0470228229" ;
    schema:isbn "9780470228227" ;
    .

<http://www.worldcat.org/title/-/oclc/145732996#Review/-1298988413>
    a schema:Review ;
    schema:itemReviewed <http://www.worldcat.org/oclc/145732996> ; # Data analysis using SQL and Excel
    schema:reviewBody ""Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data to produce results." "Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what you can expect the results to look like." "Throughout the book, critical features of Excel are highlighted, interesting uses of Excel graphics are explained, and dataflows and graphical representations of data processing are used to illustrate how SQL works."--Jacket." ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.