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 : John Wiley & Sons, Inc., [2016] ©2016
Edition/Format:   eBook : Document : English : Second editionView all editions and formats
Summary:
Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful  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

Genre/Form: Electronic books
Additional Physical Format: Print version:
Linoff, Gordon.
Data analysis using SQL and Excel
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Gordon Linoff
ISBN: 9781119021445 1119021448 9781119183419 1119183413 111902143X 9781119021438 9781119021452 1119021456
OCLC Number: 931864545
Notes: Includes index.
Description: 1 online resource : illustrations
Contents: 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's 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 --
Association Rules and Beyond --
Data Mining Models in SQL --
The Best-Fit Line: Linear Regression Models --
Building Customer Signatures for Further Analysis --
Performance Is the Issue: Using SQL Effectively --
Equivalent Constructs Among Databases.
Responsibility: Gordon S. Linoff.

Abstract:

A practical guide to data mining using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis SQL and Excel  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/931864545> # Data analysis using SQL and Excel
    a schema:MediaObject, schema:CreativeWork, schema:Book ;
    library:oclcnum "931864545" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/inu> ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://images.contentreserve.com/ImageType-100/0128-1/{9A84EF84-08BC-4A20-AA07-7F0149E60818}Img100.jpg'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/computers_data_processing> ; # COMPUTERS--Data Processing
    schema:about <http://dewey.info/class/005.7585/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/computers_databases_general> ; # COMPUTERS--Databases--General
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/sql_computer_program_language> ; # SQL (Computer program language)
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/data_mining> ; # Data mining
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/computers_programming_languages_sql> ; # COMPUTERS--Programming Languages--SQL
    schema:about <http://experiment.worldcat.org/entity/work/data/103503545#Topic/querying_computer_science> ; # Querying (Computer science)
    schema:author <http://experiment.worldcat.org/entity/work/data/103503545#Person/linoff_gordon> ; # Gordon Linoff
    schema:bookEdition "Second edition." ;
    schema:bookFormat schema:EBook ;
    schema:datePublished "2016" ;
    schema:description "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's 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 -- Association Rules and Beyond -- Data Mining Models in SQL -- The Best-Fit Line: Linear Regression Models -- Building Customer Signatures for Further Analysis -- Performance Is the Issue: Using SQL Effectively -- Equivalent Constructs Among Databases."@en ;
    schema:description "Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. 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 the results should look like."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/103503545> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/103503545#CreativeWork/data_analysis_using_sql_and_excel> ;
    schema:name "Data analysis using SQL and Excel"@en ;
    schema:productID "931864545" ;
    schema:url <http://ebookcentral.proquest.com/lib/rdc/detail.action?docID=4187166> ;
    schema:url <https://ebookcentral.proquest.com/lib/stanford-ebooks/detail.action?docID=4187166> ;
    schema:url "http://images.contentreserve.com/ImageType-100/0128-1/{9A84EF84-08BC-4A20-AA07-7F0149E60818}Img100.jpg" ;
    schema:url <http://0-onlinelibrary.wiley.com.pugwash.lib.warwick.ac.uk/book/10.1002/9781119183419> ;
    schema:url <http://ebookcentral.proquest.com/lib/gprc-ebooks/detail.action?docID=4187166> ;
    schema:url <https://ebookcentral.proquest.com/lib/ualberta/detail.action?docID=4187166> ;
    schema:url <http://rbdigital.oneclickdigital.com> ;
    schema:url <http://samples.overdrive.com/?crid=9a84ef84-08bc-4a20-aa07-7f0149e60818&.epub-sample.overdrive.com> ;
    schema:url <http://ebookcentral.proquest.com/lib/concordiaab-ebooks/detail.action?docID=4187166> ;
    schema:url <http://catalogimages.wiley.com/images/db/jimages/9781119021438.jpg> ;
    schema:url <http://www.myilibrary.com?id=879752> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=4187166_0> ;
    schema:url <http://gold.worcester.edu/login?url=http://site.ebrary.com/lib/worcesteruniv/Doc?id=11128093> ;
    schema:url <https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=4187166> ;
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=4187166> ;
    schema:url <http://www.utah.eblib.com/EBLWeb/patron/?target=patron&extendedid=P_4187166_0> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=1106926> ;
    schema:url <http://ebookcentral.proquest.com/lib/macewan-ebooks/detail.action?docID=4187166> ;
    schema:url <http://site.ebrary.com/id/11128093> ;
    schema:url <http://dx.doi.org/10.1002/9781119183419> ;
    schema:url <http://sfx.ethz.ch/sfx_locater?sid=ALEPH:EBI01&genre=book&isbn=9781119183419> ;
    schema:url <https://www.overdrive.com/search?q=9A84EF84-08BC-4A20-AA07-7F0149E60818> ;
    schema:workExample <http://worldcat.org/isbn/9781119021445> ;
    schema:workExample <http://worldcat.org/isbn/9781119183419> ;
    schema:workExample <http://dx.doi.org/10.1002/9781119183419> ;
    schema:workExample <http://worldcat.org/isbn/9781119021452> ;
    schema:workExample <http://worldcat.org/isbn/9781119021438> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/931864545> ;
    .


Related Entities

<http://dx.doi.org/10.1002/9781119183419>
    a schema:IndividualProduct ;
    rdfs:comment "Connect to resource (off-campus)" ;
    .

<http://ebookcentral.proquest.com/lib/concordiaab-ebooks/detail.action?docID=4187166>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://ebookcentral.proquest.com/lib/gprc-ebooks/detail.action?docID=4187166>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://ebookcentral.proquest.com/lib/macewan-ebooks/detail.action?docID=4187166>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://ebookcentral.proquest.com/lib/rdc/detail.action?docID=4187166>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<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#Person/linoff_gordon> # Gordon Linoff
    a schema:Person ;
    schema:familyName "Linoff" ;
    schema:givenName "Gordon" ;
    schema:name "Gordon Linoff" ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Topic/computers_data_processing> # COMPUTERS--Data Processing
    a schema:Intangible ;
    schema:name "COMPUTERS--Data Processing"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Topic/computers_databases_general> # COMPUTERS--Databases--General
    a schema:Intangible ;
    schema:name "COMPUTERS--Databases--General"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Topic/computers_programming_languages_sql> # COMPUTERS--Programming Languages--SQL
    a schema:Intangible ;
    schema:name "COMPUTERS--Programming Languages--SQL"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Topic/querying_computer_science> # Querying (Computer science)
    a schema:Intangible ;
    schema:name "Querying (Computer science)"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/103503545#Topic/sql_computer_program_language> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://worldcat.org/entity/work/data/103503545#CreativeWork/data_analysis_using_sql_and_excel>
    a schema:CreativeWork ;
    rdfs:label "Data analysis using SQL and Excel" ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/931864545> ; # Data analysis using SQL and Excel
    .

<http://worldcat.org/isbn/9781119021438>
    a schema:ProductModel ;
    schema:isbn "111902143X" ;
    schema:isbn "9781119021438" ;
    .

<http://worldcat.org/isbn/9781119021445>
    a schema:ProductModel ;
    schema:isbn "1119021448" ;
    schema:isbn "9781119021445" ;
    .

<http://worldcat.org/isbn/9781119021452>
    a schema:ProductModel ;
    schema:isbn "1119021456" ;
    schema:isbn "9781119021452" ;
    .

<http://worldcat.org/isbn/9781119183419>
    a schema:ProductModel ;
    schema:isbn "1119183413" ;
    schema:isbn "9781119183419" ;
    .

<https://ebookcentral.proquest.com/lib/stanford-ebooks/detail.action?docID=4187166>
    rdfs:comment "Available to Stanford-affiliated users." ;
    .

<https://ebookcentral.proquest.com/lib/ualberta/detail.action?docID=4187166>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

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