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 m
Data Mining and Statistical Analysis Using SQL
โ Scribed by Robert P. Trueblood, John N. Lovett Jr. (auth.)
- Publisher
- Apress
- Year
- 2001
- Tongue
- English
- Leaves
- 423
- Edition
- 1
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
This book is not just another theoretical text about statistics or data mining. No, instead it is aimed for database administrators who want to use SQL or bolster their understanding of statistics to support data mining and customer relationship management analytics.
Each chapter is self-contained, with examples tailored to real business applications. And each analysis technique will be expressed in a mathematical format for coding as either a database query or a Visual Basic procedure using SQL. Chapter contents include formulas, graphs, charts, tables, data mining techniques, and more!
โฆ Table of Contents
Front Matter....Pages i-xvi
Basic Statistical Principles and Diagnostic Tree....Pages 1-8
Measures of Central Tendency and Dispersion....Pages 9-40
Goodness of Fit....Pages 41-83
Additional Tests of Hypothesis....Pages 85-117
Curve Fitting....Pages 119-180
Control Charting....Pages 181-228
Analysis of Experimental Designs....Pages 229-275
Time Series Analysis....Pages 277-335
Back Matter....Pages 337-414
โฆ Subjects
Software Engineering/Programming and Operating Systems
๐ SIMILAR VOLUMES
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 m
<b>A practical guide to data mining using SQL and Excel</b> <p><i>Data Analysis Using SQL and Excel, 2nd Edition</i> 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 m