Data analysis using sql and excel

7.56  ·  3,667 ratings  ·  573 reviews
data analysis using sql and excel

Data Analysis Using SQL and Excel by 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 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.
File Name: data analysis using sql and
Size: 50980 Kb
Published 04.01.2019

Business Analytics with Excel - Data Science Tutorial - Simplilearn

SQL for Data Analysis – Tutorial for Beginners – ep1

Goodreads helps you keep track of books you want to read. Want to Read saving…. Want to Read Currently Reading Read. Other editions. Enlarge cover. Error rating book. Refresh and try again.

I have been involved in the data analytics realm for about 3 years. During my masters I was particularly interested in predictive modeling techniques using python and I still am. They make the sounds, but I conduct and transpose the melody and harmony into reports, deliverables, and analyses. Throughout consulting projects, personal budgeting, and side hustles, Excel has always been my go-to tool of choice. I have known about SQL and its basic concepts for a long time. Excel is a program.

Powered by WordPress. SQL is simple and easy to understand. If you do so, you will need a data server to practice. What is SQL? As you can see, SQL and Excel are quite similar. Both of them present data in a 2-dimensional table format with rows and columns.


Data Analysis in MySQL and Excel 2013 - Example

You are currently using the site but have requested a page in the site. Would you like to change to the site? Gordon S. Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the "where" and "why" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way.




  1. Quinta A. says:

    Data Analysis Using SQL and Excel [Gordon S. Linoff] on *FREE* shipping on qualifying offers. Useful business analysis requires you to effectively .

  2. Ben H. says:

    One of the leading experts on business data mining shows managers how to leverage SQL and Excel to perform sophisticated types of business analysis without the expense of data mining tools and consultants.

Leave a Reply

Your email address will not be published. Required fields are marked *