SQL for Data Analysis

SQL for Data Analysis
Author :
Publisher : "O'Reilly Media, Inc."
Total Pages : 359
Release :
ISBN-10 : 9781492088752
ISBN-13 : 1492088757
Rating : 4/5 (757 Downloads)

Book Synopsis SQL for Data Analysis by : Cathy Tanimura

Download or read book SQL for Data Analysis written by Cathy Tanimura and published by "O'Reilly Media, Inc.". This book was released on 2021-09-09 with total page 359 pages. Available in PDF, EPUB and Kindle. Book excerpt: With the explosion of data, computing power, and cloud data warehouses, SQL has become an even more indispensable tool for the savvy analyst or data scientist. This practical book reveals new and hidden ways to improve your SQL skills, solve problems, and make the most of SQL as part of your workflow. You'll learn how to use both common and exotic SQL functions such as joins, window functions, subqueries, and regular expressions in new, innovative ways--as well as how to combine SQL techniques to accomplish your goals faster, with understandable code. If you work with SQL databases, this is a must-have reference. Learn the key steps for preparing your data for analysis Perform time series analysis using SQL's date and time manipulations Use cohort analysis to investigate how groups change over time Use SQL's powerful functions and operators for text analysis Detect outliers in your data and replace them with alternate values Establish causality using experiment analysis, also known as A/B testing


SQL for Data Analysis Related Books

SQL for Data Analysis
Language: en
Pages: 359
Authors: Cathy Tanimura
Categories: Computers
Type: BOOK - Published: 2021-09-09 - Publisher: "O'Reilly Media, Inc."

GET EBOOK

With the explosion of data, computing power, and cloud data warehouses, SQL has become an even more indispensable tool for the savvy analyst or data scientist.
Data Analysis Using SQL and Excel
Language: en
Pages: 698
Authors: Gordon S. Linoff
Categories: Computers
Type: BOOK - Published: 2010-09-16 - Publisher: John Wiley & Sons

GET EBOOK

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business infor
The Applied SQL Data Analytics Workshop, Second Edition
Language: en
Pages: 404
Authors: Upom Malik
Categories: Computers
Type: BOOK - Published: 2020-02-27 - Publisher:

GET EBOOK

SQL for Data Analytics
Language: en
Pages: 540
Authors: Jun Shan
Categories: Computers
Type: BOOK - Published: 2022-08-29 - Publisher: Packt Publishing Ltd

GET EBOOK

Take your first steps to becoming a fully qualified data analyst by learning how to explore complex datasets Key Features Master each concept through practical
SQL for Data Analytics
Language: en
Pages: 92
Authors: Andrew David
Categories:
Type: BOOK - Published: 2021-06-16 - Publisher: Independently Published

GET EBOOK

SQL FOR DATA ANALYTICS Perform Fast and Efficient Data Analysis with SQL for Beginners Data analytics is used in business to support organizations make great bu