Data Analysis Using SQL and Excel by Gordon S. Linoff

By Gordon S. Linoff

A sensible consultant to information mining utilizing SQL and Excel

Data research utilizing SQL and Excel, 2d Edition exhibits you ways to leverage the 2 most well liked instruments for information question and analysis—SQL and Excel—to practice refined info research with no the necessity for advanced and dear info mining instruments. Written by means of a number one specialist on company information mining, this booklet exhibits you the way to extract valuable enterprise info from relational databases. you are going to research the elemental recommendations prior to getting into the "where" and "why" of every research, after which how to layout and practice those analyses utilizing SQL and Excel. Examples comprise SQL and Excel code, and the appendix indicates how non-standard constructs are carried out in different significant databases, together with Oracle and IBM DB2/UDB. The spouse web site contains datasets and Excel spreadsheets, and the booklet presents tricks, warnings, and technical asides that will help you each step of the way.

Data research utilizing SQL and Excel, second Edition indicates you the way to accomplish quite a lot of refined analyses utilizing those easy instruments, sparing you the numerous cost of proprietary info mining instruments like SAS.

  • Understand middle analytic options that paintings with SQL and Excel
  • Ensure your analytic procedure will get you the consequences you need
  • Design and practice your research utilizing SQL and Excel

Data research utilizing SQL and Excel, 2d Edition exhibits you the way to top use the instruments you realize to accomplish professional results.

Show description

Read Online or Download Data Analysis Using SQL and Excel PDF

Similar data mining books

Recommender Systems for Location-based Social Networks (SpringerBriefs in Electrical and Computer Engineering)

On-line social networks acquire info from clients' social contacts and their day-by-day interactions (co-tagging of images, co-rating of goods and so forth. ) to supply them with suggestions of latest items or friends. Lately, technological progressions in cellular units (i. e. clever telephones) enabled the incorporation of geo-location facts within the conventional web-based on-line social networks, bringing the hot period of Social and cellular internet.

Fraud Analytics Using Descriptive, Predictive, and Social Network Techniques: A Guide to Data Science for Fraud Detection (Wiley and SAS Business Series)

Notice fraud past to mitigate loss and stop cascading harm Fraud Analytics utilizing Descriptive, Predictive, and Social community Techniques is an authoritative guidebook for developing a accomplished fraud detection analytics answer. Early detection is a key consider mitigating fraud harm, however it includes extra really good ideas than detecting fraud on the extra complicated levels.

A User's Guide to Business Analytics

A User's advisor to company Analytics offers a complete dialogue of statistical equipment important to the company analyst. equipment are constructed from a reasonably simple point to house readers who've restricted education within the concept of information. a considerable variety of case reports and numerical illustrations utilizing the R-software package deal are supplied for the advantage of inspired newcomers who are looking to get a head commence in analytics in addition to for specialists at the activity who will profit by utilizing this article as a reference e-book.

Time Series Analysis Methods and Applications for Flight Data

This ebook makes a speciality of varied aspects of flight info research, together with the fundamental ambitions, equipment, and implementation strategies. As mass flight info possesses the common features of time sequence, the time sequence research tools and their software for flight information were illustrated from numerous facets, reminiscent of info filtering, info extension, characteristic optimization, similarity seek, development tracking, fault analysis, and parameter prediction, and so forth.

Additional resources for Data Analysis Using SQL and Excel

Sample text

Download PDF sample

Rated 4.29 of 5 – based on 18 votes