-
Book Overview & Buying
-
Table Of Contents
The Applied SQL Data Analytics Workshop - Second Edition
By :
Overview
This chapter covers how to make the most of your data by analyzing complex and alternative data types. While we typically think of data as numbers, in real-world examples, it frequently exists in other formats: text, dates and times, latitude, and longitude. In addition to these specialty data types, other data types provide the context in regard to the sequence or relationship. The goal of this chapter is to learn how we can use SQL and analytics techniques to produce insights from these other data types.
By the end of this chapter, you will be able to perform descriptive analytics on time series data using datetime. You will use geospatial data to identify relationships, then extract insights from complex data types (that is, arrays, JSON, and JSONB), and perform text analytics.