Data Analysis Using SQL and Excelby Gordon S. Linoff
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
- LendMe LendMe™ Learn More
Most Helpful Customer Reviews
See all customer reviews
Data Analysis Using SQL and Excel based on 0 ratings. 2 reviews.
Utilizing data to drive results is critical to the success of any organization. Many know this to be true, but don¿t know how to go about it. 'Data Analysis Using SQL and Excel' by Gordon Linoff successfully shows the way using a holistic approach of ¿data ¿ analysis ¿ presentation¿. Its success is based on a number attributes including.... 1. Wide Audience: Different groups of people are addressed. Management and leadership will see what is possible with great examples 'e.g. Three Scenarios' on pg 333'. 'Doers' 'e.g. analysts' get a clear view of the big picture along with the ever so important how-to aspects 'which is often not included in other texts'. 2. Popular Tools: As the title states, this book utilizes Microsoft Excel and SQL. Not only are these tools often readily available, but many people are familiar with at least one of these, if not both. This familiarity enables the reader to focus more on learning useful approaches than the tools themselves. 3. Methods: A host of useful methods are covered from Survival Analysis to the more traditional like RFM. All, especially those related to statistics, are explained well ¿ simple but not so simple as to be inaccurate or incomplete. In my opinion, ¿Data Analysis Using SQL and Excel¿ is invaluable to those who want to get the most out of their organization¿s data.