Knowledge into
effective action is required for business analysis tools. This book and
business information extracted from relational databases to store data to
identify aspects of business transactions and offer customers more to use it to
help you use SQL and Excel. When and why do the design and analysis using SQL
and Excel to obtain useful results, and results should be similar to how the
company to perform some type of analysis are described in each chapter.
Back cover
Harness the
power of SQL and Excel to perform business analysis
Three major
efforts are required for efficient conversion of knowledge to action: Import
data from Excel data with SQL, the presentation and understanding of statistics
as the basis for data analysis. Data mining expert Gordon Linoff focuses on
these issues, SQL and shows you how to use Excel to extract business
information from relational databases. Start taking a look at the amount of
data, customers, products and markets is central to the task of understanding
the dimensions of business relationships to customers and then the store will
show you how to use these data to identify and summarize important data to
produce results. On the way, it aims to improve understanding of why some
things work and others' stories based on personal experience in the field, to
share.
When and why to
design and how to perform the analysis using SQL and Excel to obtain useful
results and outcomes for what they can expect to look like some type of
business to conduct the analysis described in each section. Throughout the
book, the essential features of Excel are highlighted, interesting uses of
Excel graphics are explained, and processing of data streams and graphical
representation of data in SQL Server is used to show you how.
SQL and Excel,
SQL, and advice to share data analysis / mining on the Excel Data Analysis
Using Alerts and technical asides. The book discusses:
- How to describe the structure of an entity-relationship diagrams, data
- Ways to use SQL to create SQL queries
- This means, as the descriptive statistics and chi-square p-values
- How to analyze data, including geographic information
- The basic ideas of risk and the probability of survival
- Data structures, how to summarize what he looks like a client at some point in
- Several variants of linear regression
- Companion Website, data sets, Excel spreadsheets and provides examples in the book.
About the Author
Gordon S. Linoff
data miners, Inc., a consulting firm specializing in data mining is one of the
founders. Data mining techniques that bestseller, Second Edition, and Mastering
Data Mining (Wiley both) is co-author. This, customer relations, marketing and
managing the implementation of data mining techniques to business problems that
have more than a decade.
