|
|
 |
|
Viewing report
|
|
|
|
Data Analysis Using SQL and Excel
John Wiley and Sons Ltd, Sep 2007, Pages: 744
Data Analysis using SQL and Excel 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. 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 SQL will be available in both T-SQL and mysql. Appendixes show how non-standard constructs are implemented in other major databases, such as Oracle and IBM DB2/UDB. A second appendix will also explain how to run the examples in the book.
The companion website will include data sets and the examples used in the book for reference, particularly many of the data sets and Excel spreadsheets used for illustrations and examples.
Authors Bio:
Gordon Linoff is co-author (with Michael Berry) of the two best-selling data mining books geared to business analysis--Data Mining Techniques, 2E, and Mastering Data Mining. He is a co-founder of Data Miners, a consulting company that specializes in data mining and data analysis.
Product samples
A sample for this product is available. Please Login/Register to download this sample.
Customers who bought this item also bought
Data Mining with Microsoft SQL Server 2008
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
SQL Bible, 2nd Edition
Microsoft SQL Server 2008 Bible
Professional Microsoft SQL Server Analysis Services 2008 with MDX
Mastering SQL Server 2008
Microsoft SQL Server 2008 Administration with Windows PowerShell
SQL Server 2008: How Does it Measure Up?
SQL All-in-One Desk Reference For Dummies
Professional SQL Server 2005 Performance Tuning
Excel 2007 PivotTables and PivotCharts: Your visual blueprintTM for interpreting and presenting Excel data
Mastering SQL Server 2005 Reporting Services Infrastructure Design
|
|
|
|
