Data Analysis Using SQL and Excel und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr


oder
Loggen Sie sich ein, um 1-Click® einzuschalten.
oder
Mit kostenloser Probeteilnahme bei Amazon Prime. Melden Sie sich während des Bestellvorgangs an.
Jetzt eintauschen
und EUR 6,00 Gutschein erhalten
Eintausch
Alle Angebote
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Farbe:
Keine Abbildung vorhanden

 
Beginnen Sie mit dem Lesen von Data Analysis Using SQL and Excel auf Ihrem Kindle in weniger als einer Minute.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

Data Analysis Using SQL and Excel [Englisch] [Taschenbuch]

Gordon S. Linoff
5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
Statt: EUR 34,55
Jetzt: EUR 33,50 kostenlose Lieferung. Siehe Details.
Sie sparen: EUR 1,05 (3%)
  Alle Preisangaben inkl. MwSt.
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Nur noch 1 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.
Lieferung bis Samstag, 30. August: Wählen Sie an der Kasse Morning-Express. Siehe Details.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 25,12  
Taschenbuch EUR 33,50  

Kurzbeschreibung

16. Oktober 2007
Leverage the power of SQL and Excel to perform business analysis
 
Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. 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. Along the way, he shares stories based on his personal experience in the field, intended to enrich your understanding of why some things work--and others don't.
 
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.
 
Data Analysis Using SQL and Excel shares hints, warnings, and technical asides about Excel, SQL, and data analysis/mining. The book also discusses:
 
* How entity-relationship diagrams describe the structure of data
*
 
Ways to use SQL to generate SQL queries
*
 
Descriptive statistics, such as averages, p-values, and the chi-square test
*
 
How to incorporate geographic information into data analysis
*
 
Basic ideas of hazard probabilities and survival
*
 
How data structures summarize what a customer looks like at a specific point in time
*
 
Several variants of linear regression
 
The companion Web site provides the data sets, Excel spreadsheets, and examples featured in the book.

Hinweise und Aktionen

  • Studienbücher: Ob neu oder gebraucht, alle wichtigen Bücher für Ihr Studium finden Sie im großen Studium Special. Natürlich portofrei.



Produktinformation

  • Taschenbuch: 744 Seiten
  • Verlag: John Wiley & Sons; Auflage: 1. Auflage (16. Oktober 2007)
  • Sprache: Englisch
  • ISBN-10: 0470099518
  • ISBN-13: 978-0470099513
  • Größe und/oder Gewicht: 3,7 x 18,6 x 23 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 102.681 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
  • Komplettes Inhaltsverzeichnis ansehen

Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Synopsis

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.

Buchrückseite

Leverage the power of SQL and Excel to perform business analysis
 
Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. 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. Along the way, he shares stories based on his personal experience in the field, intended to enrich your understanding of why some things work--and others don't.
 
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.
 
Data Analysis Using SQL and Excel shares hints, warnings, and technical asides about Excel, SQL, and data analysis/mining. The book also discusses:
 
* How entity-relationship diagrams describe the structure of data
*
 
Ways to use SQL to generate SQL queries
*
 
Descriptive statistics, such as averages, p-values, and the chi-square test
*
 
How to incorporate geographic information into data analysis
*
 
Basic ideas of hazard probabilities and survival
*
 
How data structures summarize what a customer looks like at a specific point in time
*
 
Several variants of linear regression
 
The companion Web site provides the data sets, Excel spreadsheets, and examples featured in the book.

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Hier reinlesen und suchen:

Kundenrezensionen

4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
5.0 von 5 Sternen
5.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
5.0 von 5 Sternen Very good 25. Januar 2012
Von Rony
Format:Taschenbuch
Very good and also challenging book. This book defintevely improved my SQL skills and my understanding of analysing data with SQL and Excel.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 4.8 von 5 Sternen  25 Rezensionen
70 von 70 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Review from a non-statistician and business intelligence manager 27. Juni 2008
Von ThomasT - Veröffentlicht auf Amazon.com
Format:Taschenbuch
"Data Analysis Using SQL and Excel" is an valuable resource for business intelligence and data mining practitioners in all industries. Having said that, I would like to offer some solid practical advice to potential readers that might not be fluent in statistics or data mining.

First, the reader should have a solid understanding of SQL. If the extent of your SQL interaction comes through a program on the level of Access, then you can still benefit from this book, but you will have to apply yourself more than others. Keep in mind, that proprietary releases of SQL might cause problems in directly translating the author's examples.

Second, if your statistics knowledge is a little rusty, have a secondary resource on-hand. Sometimes the definitions or explanations of the statistical concepts may not be as intuitive for some readers as they are for others.

With those caveats in mind, the reader need only to keep his or her patience and work through the concepts of the first 4-5 chapters. These chapters tend toward simple exposition of the concepts. For those with little patience, it may seem as if it is just a laundry list of concepts with little effort to tie those concepts into practical uses. Thinking like this is a great way to miss the enormous benefits of the book!

For me, the "Ah Ha!" moment came in Chapter 6 and 7. The concepts I had worked on in the previous chapters suddenly came together with customer tenure onward, when the techniques use will call to mind everything learned in the previous chapters.

In short, spend plenty of time in the first few chapters - the extra effort to master those concepts will only enhance the benefits of later chapters.

Lastly, there are a few odd differences between the text and the files downloadable from the web site. Whenever I hit a snag based on the text, opening the accompanying Excel files and seeing the formulas, queries or table/graph structures resolved all issues for me.

This is a text that will always have a place on my shelves.
20 von 21 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen A "Must Have" Reference for Analysts in All Fields 28. Januar 2008
Von MTB NYC - Veröffentlicht auf Amazon.com
Format:Taschenbuch
Unlike textbooks related to stats and data analysis, this practical, "easy to read" book actually bridges the gap between theory and practice. The reader will understand both the "how" and "why" behind common approaches to data analysis. Best of all, the book targets a general audience and avoids intimidating language and notations. The author tackles the most common statistical concepts with colorful vinets. In fact, the explanations behind such ideas as "degrees of freedom" and "chi-square" are the clearest that I have ever seen in any reference or textbook.

Bototm line: whether you are a seasoned expert or novice, this is an invaluable, practical guide that will provide quick answers for anyone needing to analyze data using Excel.
17 von 18 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen At last .. a practical data analysis guide! 31. Juli 2008
Von Hugh Ujhazy - Veröffentlicht auf Amazon.com
Format:Taschenbuch
Having seen a multitude of books offering either statistical analysis techniques or suggestions around data mining tools, it is refreshing to see someone approach the subject using simple, readily available tools and a practical, business oriented approach to the topic. The apparently mundane subject of customer retention coupled with buying patterns and market basket analysis is laid out in an effective and sequential manner. The SQL examples take some getting used to but, once understood, offer a series of easily implemented and highly effective methods to illustrate the concepts shown in the book. As a reference guide and an illustration that one needs to know the questions to be asked of the data before investing in the latest drag and drop business intelligence tools, this book is unparalleled. The author has not stinted on providing a wealth of examples and explanation. If this tome is a reflection of how Mr Linoff and his team approach their real world consulting activities, they must be a formidable team indeed.

For anyone who has wrestled with a means to understand their customer buying patterns and product affinity patterns in their historical sales data, this book cannot be beaten
46 von 56 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Comments from a colleague 19. Oktober 2007
Von Michael Berry - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
Gordon Linoff and I have written three an a half books together. (Four, if we get to count the second edition of Data Mining Techniques as a whole new book; it didn't feel like any less work.) Neither of us has written a book without the other before, so I must admit to a tiny twinge of regret upon first seeing the cover of this one without my name on it next to Gordon's. The feeling passed very quickly as recollections of the authorial life came flooding back--vacations spent at the keyboard instead of in or on the lake, opportunities missed, relationships strained. More importantly, this is a book that only Gordon Linoff could have written. His unique combination of talents and experiences informs every chapter.

I first met Gordon at Thinking Machines Corporation, a now long-defunct manufacturer of parallel supercomputers where we both worked in the late eighties and early nineties. Among other roles, Gordon managed the implementation of a parallel relational database designed to support complex analytical queries on very large databases. The design point for this database was radically different from other relational database systems available at the time in that no trade-offs were made to support transaction processing. The requirements for a system designed to quickly retrieve or update a single record are quite different from the requirements for a system to scan and join huge tables. Jettisoning the requirement to support transaction processing made for a cleaner, more efficient database for analytical processing. This part of Gordon's background means he understands SQL for data analysis literally from the inside out.

Just as a database designed to answer big important questions has a different structure from one designed to process many individual transactions, a book about using databases to answer big important questions requires a different approach to SQL. Many books on SQL are written for database administrators. Others are written for users wishing to prepare simple reports. Still others attempt to introduce some particular dialect of SQL in every detail. This one is written for data analysts, data miners, and anyone who wants to extract maximum information value from large corporate databases. Jettisoning the requirement to address all the disparate types of database user makes this a better, more focused book for the intended audience. In short, this is a book about how to use databases the way we ourselves use them.

Even more important than Gordon's database technology background, is his many years as a data mining consultant. This has given him a deep understanding of the kinds of questions businesses need to ask and of the data they are likely to have available to answer them. Years spent exploring corporate databases has given Gordon an intuitive feel for how to approach the kinds of problems that crop up time and again across many different business domains:

* How to take advantage of geographic data. A zip code field looks much richer when you realize that from zip code you can get to latitude and longitude and from latitude and longitude you can get to distance. It looks richer still when your realize that you can use it to join in census bureau data to get at important attributes such as population density, median income, percentage of people on public assistance, and the like.

* How to take advantage of dates. Order dates, ship dates, enrollment dates, birth dates. Corporate data is full of dates. These fields look richer when you understand how to turn dates into tenures, analyze purchases by day of week, and track trends in fulfillment time. They look richer still when you know how to use this data to analyze time-to-event problems such as time to next purchase or expected remaining life time of a customer relationship.

* How to build data mining models directly in SQL. This book shows you how to do things in SQL that you probably never imagined possible including generating association rules for market basket analysis, building regression models, and implementing naïve Bayes classifiers and scorecards.

* How to prepare data for use with data mining tools. Although more than most people realize can be done using just SQL and Excel, eventually you will want to use more specialized data mining tools. These tools need data in a specific format known as a customer signature. This book shows you how to create these data mining extracts.

The book is rich in examples and they all use real data. This point is worth saying more about. Unrealistic datasets lead to unrealistic results. This is frustrating to the student. In real life, the more you know about the business context, the better your data mining results will be. Subject matter expertise gives you a head start. You know what variables ought to be predictive and have good ideas about new ones to derive. Fake data does not reward these good ideas because patterns that should be in the data are missing and patterns that shouldn't be there have been introduced inadvertently. Real data is hard to come by, not least because real data may reveal more than its owners are willing to share about their business operations. As a result, many books and courses make do with artificially constructed datasets. Best of all, the datasets used in the book are all available for download at the companion web site [...]

I reviewed the chapters of this book as they were written. This process was very beneficial to my own use of SQL and Excel. The exercise of thinking about the fairly complex queries used in the examples greatly increased my understanding of how SQL actually works. As a result, I have lost my fear of nested queries, multi-way joins, giant case statements, and other formerly daunting aspects of the language. In well over a decade of collaboration, I have always turned to Gordon for help using SQL to best advantage. Now, I can turn to this book. And you can too.
8 von 8 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen great book about excel, statistics & sql 4. September 2009
Von S. Ward - Veröffentlicht auf Amazon.com
Format:Taschenbuch
I have been teaching introductory and intermediate statistics to public policy graduate students for the past ten years. I also work in the media industry where (very) large data needs to be analyzed daily. This is one of the books that I highly recommend to my students and colleagues, because it recognizes a reality in the world: most data is stored in relational databases and most analysis is in Excel. This book is excellent, so you'll need two copies... Someone is always borrowing mine.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden


Ihr Kommentar