Data analysis using SQL and Excel /
Linoff, Gordon,
Data analysis using SQL and Excel / Gordon S. Linoff. - Second edition. Indianapolis, IN : John Wiley & Sons, Inc., [2016] ©2016 - 1 online resource : illustrations
Includes index.
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.
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.
9781119021445 1119021448 9781119183419 1119183413 111902143X 9781119021438 9781119021452 1119021456
10.1002/9781119183419 doi
EB00658889 Recorded Books
9A84EF84-08BC-4A20-AA07-7F0149E60818 OverDrive, Inc. http://www.overdrive.com
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
SQL (Computer program language)
Querying (Computer science)
Data mining.
COMPUTERS--Programming Languages--SQL.
COMPUTERS--Databases--General.
COMPUTERS--Data Processing.
Data mining.
Querying (Computer science)
SQL (Computer program language)
Data analysis using SQL and Excel / Gordon S. Linoff. - Second edition. Indianapolis, IN : John Wiley & Sons, Inc., [2016] ©2016 - 1 online resource : illustrations
Includes index.
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.
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.
9781119021445 1119021448 9781119183419 1119183413 111902143X 9781119021438 9781119021452 1119021456
10.1002/9781119183419 doi
EB00658889 Recorded Books
9A84EF84-08BC-4A20-AA07-7F0149E60818 OverDrive, Inc. http://www.overdrive.com
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
SQL (Computer program language)
Querying (Computer science)
Data mining.
COMPUTERS--Programming Languages--SQL.
COMPUTERS--Databases--General.
COMPUTERS--Data Processing.
Data mining.
Querying (Computer science)
SQL (Computer program language)