Data Analysis Using SQL and Excel

最新推荐文章于 2023-09-02 12:37:21 发布

原创最新推荐文章于 2023-09-02 12:37:21 发布 · 897 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sql #excel #statistics #transactions #warnings

Excel 专栏收录该内容

69 篇文章

订阅专栏

本书重点介绍如何利用SQL和Excel从关系数据库中提取业务信息，涵盖数据检索、展示及基本统计方法等内容。通过实际案例讲解了如何定义业务维度、记录客户交易并汇总关键数据。

版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。 http://blog.csdn.net/topmvp - topmvp
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 workand 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

http://rapidshare.com/files/75304870/0470099518.zip
http://depositfiles.com/files/2644873