About the book
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—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the \"where\" and \"why\" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way.
Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS.
- Understand core analytic techniques that work with SQL and Excel
- Ensure your analytic approach gets you the results you need
- Design and perform your analysis using SQL and Excel
Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.
Editions of Data Analysis Using SQL and Excel
- Paperback
- ISBN 9781119021438
- EBook
- ISBN 9781119021452
- EBook
- ISBN 9781119183419
- EBook
- ISBN 9781119021445
Read an Excerpt
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—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the \"where\" and \"why\" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way.
Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS.
- Understand core analytic techniques that work with SQL and Excel
- Ensure your analytic approach gets you the results you need
- Design and perform your analysis using SQL and Excel
Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.
Frequently Asked Questions
What is Data Analysis Using SQL and Excel about?
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—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the \"where\" and \"why\" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way.
Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS.
- Understand core analytic techniques that work with SQL and Excel
- Ensure your analytic approach gets you the results you need
- Design and perform your analysis using SQL and Excel
Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.
What core themes, tropes, or subjects are explored in Data Analysis Using SQL and Excel?
Computing and Information Technology > Databases / Data management > Data warehousing
Where can I read a sample of Data Analysis Using SQL and Excel?
You can read an official preview of the few pages here https://www.book2look.com/book/9781119021438
Who is/are the Author/s of the book Data Analysis Using SQL and Excel?
Gordon S. Linoff
Who is the Publisher of the book Data Analysis Using SQL and Excel?
Wiley
What are the ISBN numbers for the physical and digital editions?
Data Analysis Using SQL and Excel is available as paperback(ISBN 9781119021438) and ebook(ISBN 9781119021452) and ebook(ISBN 9781119183419) and ebook(ISBN 9781119021445)
Where can I buy Data Analysis Using SQL and Excel online or support local independent bookshops?
You can buy Data Analysis Using SQL and Excel from below
Where can I buy Data Analysis Using SQL and Excel?