By Gordon S. Linoff

A useful consultant to facts mining utilizing SQL and Excel

Data research utilizing SQL and Excel, 2d Edition indicates you ways to leverage the 2 hottest instruments for facts question and analysis—SQL and Excel—to practice subtle information research with out the necessity for advanced and costly facts mining instruments. Written by way of a number one professional on enterprise info mining, this e-book exhibits you ways to extract necessary enterprise info from relational databases. you are going to study the elemental strategies sooner than stepping into the "where" and "why" of every research, after which methods to layout and practice those analyses utilizing SQL and Excel. Examples comprise SQL and Excel code, and the appendix exhibits how non-standard constructs are applied in different significant databases, together with Oracle and IBM DB2/UDB. The better half site contains datasets and Excel spreadsheets, and the publication offers 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 a variety of refined analyses utilizing those basic instruments, sparing you the numerous rate of proprietary information mining instruments like SAS.

  • Understand center analytic innovations that paintings with SQL and Excel
  • Ensure your analytic technique will get you the consequences you need
  • Design and practice your research utilizing SQL and Excel

Data research utilizing SQL and Excel, second Edition exhibits you ways to most sensible use the instruments to accomplish specialist results.

Show description

Read or Download Data Analysis Using SQL and Excel PDF

Best data mining books

The Elements of Statistical Learning: Data Mining, Inference, and Prediction, Second Edition (Springer Series in Statistics)

In past times decade there was an explosion in computation and knowledge expertise. With it have come big quantities of knowledge in numerous fields reminiscent of medication, biology, finance, and advertising. The problem of knowing those info has resulted in the advance of latest instruments within the box of records, and spawned new components reminiscent of info mining, computing device studying, and bioinformatics.

Robust Cluster Analysis and Variable Selection (Chapman & Hall/CRC Monographs on Statistics & Applied Probability)

Clustering is still a colourful sector of analysis in records. even if there are various books in this subject, there are fairly few which are good based within the theoretical facets. In powerful Cluster research and Variable choice, Gunter Ritter offers an summary of the speculation and functions of probabilistic clustering and variable choice, synthesizing the most important examine result of the final 50 years.

Machine Learning for the Web

Key FeaturesTargets monstrous and trendy markets the place refined net apps are of want and value. sensible examples of creating laptop studying internet program, that are effortless to stick to and reflect. A entire instructional on Python libraries and frameworks to get you up and began. ebook DescriptionPython is a basic function and likewise a relatively effortless to benefit programming language.

Proceedings of the International Congress on Information and Communication Technology: ICICT 2015, Volume 1 (Advances in Intelligent Systems and Computing)

This quantity includes 69papers provided at ICICT 2015: foreign Congress on details andCommunication expertise. The convention used to be held in the course of ninth and 10thOctober, 2015, Udaipur, India and arranged by way of CSI Udaipur bankruptcy, DivisionIV, SIG-WNS, SIG-e-Agriculture in organization with ACM Udaipur ProfessionalChapter, The establishment of Engineers (India), Udaipur neighborhood Centre and MiningEngineers organization of India, Rajasthan Udaipur bankruptcy.

Extra resources for Data Analysis Using SQL and Excel

Sample text

Download PDF sample

Rated 4.30 of 5 – based on 40 votes