CLCTP3
LanguageENG
PublishYear2016
publishCompany
Wiley
EISBN
9781119021452
PISBN
9781119021438
- Product Details
- Contents
Data Analysis Using SQL and Excel, 2nd Edition, shows business managers and data analysts how to use the relatively simple tools of SQL and Excel to extract useful business information from relational databases. It provides an overview of the core analytic techniques, and shows how to execute them using SQL and Excel. The book is organized around chapters that become increasingly complex in the use of SQL, Excel, and data mining concepts. Each chapter will explain: Why and when to perform a particular type of business analysis to obtain a useful business result How to design and perform the analysis using SQL and Excel What the results look like in SQL and Excel Throughout the book, there will be hints, warnings, and technical asides about Excel, SQL, and data analysis/mining. All examples in the book will have adjoining SQL and Excel code. The appendix shows how non-standard constructs are implemented in other major databases, such as Oracle and IBM DB2/UDB. The companion website will include data sets for all of the examples used in the book, plus related Excel spreadsheets.
Collected by
- Princeton University
- Yale University
- University of Oxford
- Harvard University
- Stanford University
- Columbia University Library
- MIT
- Beijing Normal University at Zhuhai
- UCB