Data Analysis Using SQL and Excel by Gordon S. Linoff

By Gordon S. Linoff

A sensible advisor to info 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 info question and analysis—SQL and Excel—to practice subtle info research with out the necessity for advanced and dear facts mining instruments. Written by means of a number one professional on company facts mining, this e-book exhibits you ways to extract necessary company info from relational databases. you will research the basic innovations earlier than entering 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 exhibits how non-standard constructs are applied in different significant databases, together with Oracle and IBM DB2/UDB. The significant other site comprises datasets and Excel spreadsheets, and the e-book 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 a variety of subtle analyses utilizing those basic instruments, sparing you the numerous fee of proprietary info mining instruments like SAS.

  • Understand center analytic recommendations 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 the way to most sensible use the instruments you know to accomplish specialist results.

Show description

Read Online or Download Data Analysis Using SQL and Excel PDF

Best data mining books

MDX with SSAS 2012 Cookbook

In DetailMDX is the BI ordinary for multidimensional calculations and queries. skillability with this language is key for the belief of your research prone’ complete strength. MDX is a sublime and strong language, and in addition has a steep studying curve. SQL Server 2012 research prone has brought a brand new BISM tabular version and a brand new formulation language, info research Expressions (DAX).

Clinical Data-Mining: Integrating Practice and Research (Pocket Guide to Social Work Research Methods)

Scientific Data-Mining (CDM) consists of the conceptualization, extraction, research, and interpretation of accessible scientific facts for perform knowledge-building, scientific decision-making and practitioner mirrored image. based upon the kind of info mined, CDM could be qualitative or quantitative; it's ordinarily retrospective, yet could be meaningfully mixed with unique information assortment.

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

Become aware of fraud previous 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 think about mitigating fraud harm, however it consists of extra really expert ideas than detecting fraud on the extra complex phases.

Apache Hive Cookbook

Effortless, hands-on recipes that will help you comprehend Hive and its integration with frameworks which are used commonly in modern-day large information worldAbout This BookGrasp an entire reference of other Hive themes. Get to understand the newest recipes in improvement in Hive together with CRUD operationsUnderstand Hive internals and integration of Hive with diversified frameworks utilized in present day international.

Extra info for Data Analysis Using SQL and Excel

Example text

Download PDF sample

Rated 4.53 of 5 – based on 42 votes