Data Analysis Using SQL and Excel 2/e (Paperback)

Gordon S. Linoff

  • 出版商: Wiley
  • 出版日期: 2015-12-14
  • 定價: $1,750
  • 售價: 9.5$1,663
  • 語言: 英文
  • 頁數: 792
  • 裝訂: Paperback
  • ISBN: 111902143X
  • ISBN-13: 9781119021438
  • 相關分類: ExcelSQLData Science
  • 立即出貨 (庫存 < 3)

買這商品的人也買了...

商品描述

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.

商品描述(中文翻譯)

《使用SQL和Excel進行數據挖掘的實用指南》

《使用SQL和Excel進行數據分析,第二版》向您展示如何利用兩種最流行的數據查詢和分析工具——SQL和Excel,進行複雜的數據分析,而無需使用複雜昂貴的數據挖掘工具。本書由業務數據挖掘的領先專家撰寫,向您展示如何從關聯數據庫中提取有用的業務信息。您將學習基本技術,然後深入了解每個分析的“何時”和“為什麼”,並學習如何使用SQL和Excel設計和執行這些分析。示例包括SQL和Excel代碼,附錄展示了如何在其他主要數據庫中實現非標準結構,包括Oracle和IBM DB2/UDB。配套網站提供數據集和Excel電子表格,本書提供提示、警告和技術說明,以幫助您一步步進行。

《使用SQL和Excel進行數據分析,第二版》向您展示如何使用這些簡單工具進行各種複雜的分析,節省了使用SAS等專有數據挖掘工具的巨大開支。

本書包括以下內容:
- 理解與SQL和Excel配合使用的核心分析技術
- 確保您的分析方法能夠獲得所需結果
- 使用SQL和Excel設計和執行分析

《使用SQL和Excel進行數據分析,第二版》向您展示如何充分利用您已經熟悉的工具,以達到專業的結果。