000 03008cam a2200481Ii 4500
020 _a9781119021445
_q(electronic bk.)
020 _a1119021448
_q(electronic bk.)
020 _a9781119183419
_q(electronic bk.)
020 _a1119183413
_q(electronic bk.)
020 _a111902143X
020 _a9781119021438
020 _a9781119021452
_q(e-book)
020 _a1119021456
_q(e-book)
020 _z9781119021438
024 7 _a10.1002/9781119183419
_2doi
028 0 1 _aEB00658889
_bRecorded Books
037 _a9A84EF84-08BC-4A20-AA07-7F0149E60818
_bOverDrive, Inc.
_nhttp://www.overdrive.com
040 _cCUS
072 7 _aCOM
_x051170
_2bisacsh
072 7 _aCOM
_x021000
_2bisacsh
100 1 _aLinoff, Gordon,
_eauthor.
245 1 0 _aData analysis using SQL and Excel /
_cGordon S. Linoff.
260 _aSecond edition.
260 1 _aIndianapolis, IN :
_bJohn Wiley & Sons, Inc.,
_c[2016]
260 4 _c©2016
300 _a1 online resource :
_billustrations
500 _aIncludes index.
505 0 _aA 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.
520 _aUseful 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.
630 0 0 _aMicrosoft Excel (Computer file)
630 0 7 _aMicrosoft Excel (Computer file)
_2blmlsh
630 0 7 _aMicrosoft Excel (Computer file)
_2fast
_0(OCoLC)fst01366659
650 0 _aSQL (Computer program language)
650 0 _aQuerying (Computer science)
650 0 _aData mining.
650 7 _aCOMPUTERS
_xProgramming Languages
_xSQL.
_2bisacsh
650 7 _aCOMPUTERS
_xDatabases
_xGeneral.
_2bisacsh
650 7 _aCOMPUTERS
_xData Processing.
_2bisacsh
650 7 _aData mining.
_2fast
_0(OCoLC)fst00887946
650 7 _aQuerying (Computer science)
_2fast
_0(OCoLC)fst01739127
650 7 _aSQL (Computer program language)
_2fast
_0(OCoLC)fst01102869
856 4 0 _uhttps://doi.org/10.1002/9781119183419
_zWiley Online Library
942 _cEBK
999 _c208665
_d208665