Title: SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights (eng)
Publisher: O'Reilly Media
Publication Date: 2021
Language: English
ISBN 10: 1492088781
ISBN 13: 9781492088783
Binding: Soft cover
Condition: new
Weight: 1.05 kilograms

About this title

Synopsis

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

About the Author

Cathy Tanimura has a passion for connecting people and organizations to the data they need to make an impact. She has been analyzing data for over 20 years across a wide range of industries, from finance to B2B software to consumer services. She has experience analyzing data with SQL across most of the major proprietary and open source databases. She has built and managed data teams and data infrastructure at a number of leading tech companies. Cathy is also a frequent speaker at top conferences, on topics including building data cultures, data-driven product development, and inclusive data analysis.

"About this title" may belong to another edition of this title.

Store Description

Account dedicated to Print on Demand titles. Brook Bookstore offers a wide selection of books with a continuously updated catalog and fast shipments all over the world. We hold distribution rights with all of the publishers we promote and are in continuous search of new interesting titles to propose to our customers. We are part of Brandon Group SRL (an Italian company) and all of the orders are shipped from Europe. Depending on availability orders will be picked from our different warehouses. CONTACT US If you have any questions please do not hesitate to contact us sending a message to our store. We have a well prepared customer service team who will be happy to assist you. Our working hours are from Monday to Friday from 9:30 to 18:30 (CET, UTC +1) so messages received during the weekends might be responded with a slight delay but we guarantee you will get back to you as soon as possible. RETURNS If you want to return your order, please submit your request through Abebooks platform. Returns requests are managed case by case by our team and always in line with Abebooks policies: AbeBooks? Return Policy guarantees that you can return any book for a refund within 30 days, when the return is due to an error on the bookseller?s part. When the motive of the return is not due to an error of the seller it is up to Brook Bookstore to accept the return or else after studying the case. CANCELLATION You can send a cancellation request to our customer service team while the package has not yet been shipped. After that we cannot ensure we can retrieve the parcel but we suggest you to get in touch with us in order to verify the case. INVOICE You can request the invoice to be issued together with the shipment of the order or, at the latest, in the same month of the shipment.

Visit Seller's Storefront

Seller's business information

Brandon Group S.R.L.
Via Vannella Gaetani 27, Brandon Group, Napoli, NA, 80121, Italy

Sale & Shipping Terms

Terms of Sale

Account dedicated to Print on Demand titles.

CANCELLATION
You can send a cancellation request from the order page while the package has not yet been shipped. After that we cannot ensure we can retrieve the parcel but we suggest you to get in touch with us in order to verify the case.

INVOICE
You can request the invoice to be issued together with the shipment of the order or, at the latest, in the same month of the shipment.

RETURNS
If you want to return your order, please contact us for authoriz...

More Information

Shipping Terms

Shipping rates from Italy to U.S.A.

Shipping rates from Italy to U.S.A.
Order quantity	25 to 40 business days	60 to 60 business days
First item	US$ 12.80	US$ 594.62

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.