Online Public Access Catalogue (OPAC)
Library,Documentation and Information Science Division

“A research journal serves that narrow

borderland which separates the known from the unknown”

-P.C.Mahalanobis


Normal view MARC view ISBD view

Data analysis using SQL and Excel [electronic resource] / Gordon S. Linoff.

By: Linoff, Gordon.
Material type: TextTextPublisher: Indianapolis, Ind. : Wiley Pub., c2008Description: 1 online resource (xli, 645 p.) : ill.ISBN: 9780470228227 (electronic bk.); 0470228229 (electronic bk.); 9781621984504 (electronic bk.); 1621984508 (electronic bk.).Subject(s): SQL (Computer program language) | Querying (Computer science) | Data mining | Microsoft Excel (Computer file) | Microsoft Excel | SQL (Langage de programmation) | Interrogation (Informatique) | Exploration de donn�ees (Informatique) | COMPUTERS -- Data Processing | Dataprocessing | Microsoft Excel | SQL | Datamining | Microsoft Excel (Computer file) | SQL (Computer program language) | Querying (Computer science) | Data miningGenre/Form: Electronic books.Additional physical formats: Print version:: Data analysis using SQL and Excel.DDC classification: 005.75/85 Other classification: 54.64 Online resources: EBSCOhost
Contents:
Cover -- About the Author -- Credits -- Contents -- Foreword -- Acknowledgments -- Introduction -- Overview of the Book and Technology -- How This Book Is Organized -- Who Should Read this Book -- Tools You Will Need -- What's on the Web Site -- Summary -- Chapter 1: A Data Miner Looks at SQL -- Picturing the Structure of the Data -- Picturing Data Analysis Using Dataflows -- SQL Queries -- Subqueries Are Our Friend -- Lessons Learned -- Chapter 2: What's In a Table? Getting Started with Data Exploration -- What Is Data Exploration? -- Excel for Charting -- What Values Are in the Columns? -- More Values to Explore -- Min, Max, and Mode -- Exploring String Values -- Exploring Values in Two Columns -- From Summarizing One Column to Summarizing All Columns -- Lessons Learned -- Chapter 3: How Different Is Different? -- Basic Statistical Concepts -- How Different Are the Averages? -- Counting Possibilities -- Ratios, and Their Statistics -- Chi-Square -- Lessons Learned -- Chapter 4: Where Is It All Happening? Location, Location, Location -- Latitude and Longitude -- Census Demographics -- Geographic Hierarchies -- Mapping in Excel -- Lessons Learned -- Chapter 5: It's a Matter of Time -- Dates and Times in Databases -- Starting to Investigate Dates -- How Long between Two Dates? -- Year-over-Year Comparisons -- Counting Active Customers by Day -- Simple Chart Animation in Excel -- Lessons Learned -- Chapter 6: How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value -- Background on Survival Analysis -- The Hazard Calculation -- Survival and Retention -- Comparing Different Groups of Customers -- Comparing Survival over Time -- Important Measures Derived from Survival -- Using Survival for Customer Value Calculations -- Lessons Learned -- Chapter 7: Factors Affecting Survival: The What and Why of Customer Tenure -- What Factors Are Important and When -- Left Truncation -- Time Windowing -- Competing Risks -- Before and After -- Lessons Learned -- Chapter 8: Customer Purchases and Other Repeated Events -- Identifying Customers -- RFM Analysis -- Which Households Are Increasing Purchase Amounts Over Time? -- Time to Next Event -- Lessons Learned -- Chapter 9: What's in a Shopping Cart? Market Basket Analysis and Association Rules -- Exploratory Market Basket Analysis -- Combinations (Item Sets) -- The Simplest Association Rules -- One-Way Association Rules -- Two-Way Associations -- Extending Association Rules -- Lessons Learned -- Chapter 10: Data Mining Models in SQL -- Introduction to Directed Data Mining -- Look-Alike Models -- Lookup Model for Most Popular Product -- Lookup Model for Order Size -- Lookup Model for Probability of Response -- Na�ive Bayesian Models (Evidence Models) -- Lessons Learned -- Chapter 11: The Best-Fit Line: Linear Regression Models -- The Best-Fit Line -- Measuring Goodness of Fit Using R2 -- Direct Calculation of Best-Fit Line Coefficients -- Weighted Linear Regressio.
Review: "Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data to produce results." "Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what you can expect the results to look like." "Throughout the book, critical features of Excel are highlighted, interesting uses of Excel graphics are explained, and dataflows and graphical representations of data processing are used to illustrate how SQL works."--Jacket.
Tags from this library: No tags from this library for this title. Log in to add tags.
No physical items for this record

Title from title screen.

Includes index.

Cover -- About the Author -- Credits -- Contents -- Foreword -- Acknowledgments -- Introduction -- Overview of the Book and Technology -- How This Book Is Organized -- Who Should Read this Book -- Tools You Will Need -- What's on the Web Site -- Summary -- Chapter 1: A Data Miner Looks at SQL -- Picturing the Structure of the Data -- Picturing Data Analysis Using Dataflows -- SQL Queries -- Subqueries Are Our Friend -- Lessons Learned -- Chapter 2: What's In a Table? Getting Started with Data Exploration -- What Is Data Exploration? -- Excel for Charting -- What Values Are in the Columns? -- More Values to Explore -- Min, Max, and Mode -- Exploring String Values -- Exploring Values in Two Columns -- From Summarizing One Column to Summarizing All Columns -- Lessons Learned -- Chapter 3: How Different Is Different? -- Basic Statistical Concepts -- How Different Are the Averages? -- Counting Possibilities -- Ratios, and Their Statistics -- Chi-Square -- Lessons Learned -- Chapter 4: Where Is It All Happening? Location, Location, Location -- Latitude and Longitude -- Census Demographics -- Geographic Hierarchies -- Mapping in Excel -- Lessons Learned -- Chapter 5: It's a Matter of Time -- Dates and Times in Databases -- Starting to Investigate Dates -- How Long between Two Dates? -- Year-over-Year Comparisons -- Counting Active Customers by Day -- Simple Chart Animation in Excel -- Lessons Learned -- Chapter 6: How Long Will Customers Last? Survival Analysis to Understand Customers and Their Value -- Background on Survival Analysis -- The Hazard Calculation -- Survival and Retention -- Comparing Different Groups of Customers -- Comparing Survival over Time -- Important Measures Derived from Survival -- Using Survival for Customer Value Calculations -- Lessons Learned -- Chapter 7: Factors Affecting Survival: The What and Why of Customer Tenure -- What Factors Are Important and When -- Left Truncation -- Time Windowing -- Competing Risks -- Before and After -- Lessons Learned -- Chapter 8: Customer Purchases and Other Repeated Events -- Identifying Customers -- RFM Analysis -- Which Households Are Increasing Purchase Amounts Over Time? -- Time to Next Event -- Lessons Learned -- Chapter 9: What's in a Shopping Cart? Market Basket Analysis and Association Rules -- Exploratory Market Basket Analysis -- Combinations (Item Sets) -- The Simplest Association Rules -- One-Way Association Rules -- Two-Way Associations -- Extending Association Rules -- Lessons Learned -- Chapter 10: Data Mining Models in SQL -- Introduction to Directed Data Mining -- Look-Alike Models -- Lookup Model for Most Popular Product -- Lookup Model for Order Size -- Lookup Model for Probability of Response -- Na�ive Bayesian Models (Evidence Models) -- Lessons Learned -- Chapter 11: The Best-Fit Line: Linear Regression Models -- The Best-Fit Line -- Measuring Goodness of Fit Using R2 -- Direct Calculation of Best-Fit Line Coefficients -- Weighted Linear Regressio.

"Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data to produce results." "Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what you can expect the results to look like." "Throughout the book, critical features of Excel are highlighted, interesting uses of Excel graphics are explained, and dataflows and graphical representations of data processing are used to illustrate how SQL works."--Jacket.

There are no comments for this item.

Log in to your account to post a comment.

Other editions of this work

Data analysis using SQL and Excel by Linoff, Gordon. ©2008
Library, Documentation and Information Science Division, Indian Statistical Institute, 203 B T Road, Kolkata 700108, INDIA
Phone no. 91-33-2575 2100, Fax no. 91-33-2578 1412, ksatpathy@isical.ac.in


Visitor Counter