Data Analysis Using SQL and Excel
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 more. 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 the results should look like.
What people are saying - Write a review
A Data Miner Looks at SQL
Whats In a Table? Getting Started with Data Exploration
How Different Is Different?
How Different Are the Averages?
Where Is It All Happening? Location Location Location
Its a Matter of Time
How Long Will Customers Last? Survival Analysis
Whats in a Shopping Cart? Market Basket Analysis
Data Mining Models in SQL
Linear Regression Models
Measuring Goodness of Fit Using R2
Weighted Linear Regression
More Than One Input Variable
Building Customer Signatures for Further Analysis
Other editions - View all
aggregation association rules average best-fit line bubble chart CALENDAR cells chapter chart chi-square clause columns combinations competing risk COUNT(DISTINCT counts the number customer signature customers who stop cutoff date data mining database dataflow dataflow diagram dataset dimensions example expected value Figure following query formula Gotham GROUP BY householdid hazard probabilities hazard ratio input JOIN customer LEFT OUTER JOIN left truncation linear regression look lookup median median household income month multiple mysql NULL number of customers number of orders numorders o.customerid o.orderid o.zipcode ol.productid order lines orderid orderline ol orders o JOIN output population at risk primary key product group productgroupname productid purchase query calculates question regression revenue scatter plot SELECT householdid shows Smallville start_date starts statistics stop rate stop_date stop_type string subquery subs SUM(CASE summary survival analysis tenure tomers totalprice types VARCHAR variables window functions Y-values zc.state zc.zipcode zero zip codes zipcensus zc