Coverart for item
The Resource Data analysis using SQL and Excel, Gordon S. Linoff

Data analysis using SQL and Excel, Gordon S. Linoff

Label
Data analysis using SQL and Excel
Title
Data analysis using SQL and Excel
Statement of responsibility
Gordon S. Linoff
Creator
Subject
Genre
Language
eng
Summary
"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
Related
Cataloging source
NTG
http://library.link/vocab/creatorName
Linoff, Gordon
Dewey number
005.75/85
Illustrations
illustrations
Index
index present
LC call number
QA76.73.S67
LC item number
L56 2008eb
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/subjectName
  • SQL (Computer program language)
  • Querying (Computer science)
  • Data mining
  • SQL (Computer program language)
  • Querying (Computer science)
  • Data mining
  • SQL (Langage de programmation)
  • Interrogation (Informatique)
  • Exploration de données (Informatique)
  • COMPUTERS
  • Data mining
  • Querying (Computer science)
  • SQL (Computer program language)
  • Dataprocessing
  • Microsoft Excel
  • SQL
  • Datamining
  • SQL (Computer program language)
  • Querying (Computer science)
  • Data mining
Label
Data analysis using SQL and Excel, Gordon S. Linoff
Link
Instantiates
Publication
Note
  • Title from title screen
  • Includes index
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
other
Content category
text
Content type code
txt
Content type MARC source
rdacontent
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ïve 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
Control code
ocn189105261
Dimensions
unknown
Extent
1 online resource (xli, 645 pages)
Form of item
online
Isbn
9781621984504
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other control number
9786611100339
Other physical details
illustrations
Specific material designation
remote
Stock number
  • CL0500000024
  • FA9A95F8-FF89-44F6-8724-B0223ED2A45D
System control number
  • (Sirsi) o189105261
  • (OCoLC)189105261
Label
Data analysis using SQL and Excel, Gordon S. Linoff
Link
Publication
Note
  • Title from title screen
  • Includes index
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
other
Content category
text
Content type code
txt
Content type MARC source
rdacontent
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ïve 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
Control code
ocn189105261
Dimensions
unknown
Extent
1 online resource (xli, 645 pages)
Form of item
online
Isbn
9781621984504
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other control number
9786611100339
Other physical details
illustrations
Specific material designation
remote
Stock number
  • CL0500000024
  • FA9A95F8-FF89-44F6-8724-B0223ED2A45D
System control number
  • (Sirsi) o189105261
  • (OCoLC)189105261

Library Locations

    • Waubonsee: Sugar Grove Campus - Todd LibraryBorrow it
      Collins Hall 2nd Floor Waubonsee Community College Route 47 at Waubonsee Drive, Sugar Grove, IL, 60554-9454, US
      41.7974 -88.45785
Processing Feedback ...