Data analysis using SQL and Excel /

• Main Author: Linoff, Gordon (Author)
• Format: eBook
• Language: English
• Published: Indianapolis, IN : John Wiley & Sons, Inc., [2016]
• Edition: Second edition.
• Subjects: Microsoft Excel (Computer file); SQL (Computer program language); Querying (Computer science); Data mining.; COMPUTERS > Programming Languages > SQL.; COMPUTERS > Databases > General.; COMPUTERS > Data Processing.; Electronic books.
• Item Description: Includes index.
• Physical Description: 1 online resource : illustrations
• ISBN: 9781119021445; 1119021448; 9781119183419; 1119183413; 111902143X; 9781119021438; 9781119021452; 1119021456
• DOI: 10.1002/9781119183419

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.