Exercise and use case overview
For this exercise, we will use two different customer support data sources to better understand how to analyze customer support data for insights. The sample data sources in this exercise are representative of data sources you would use in customer support data analytics. The queries in this chapter can be replicated and reused with actual business data.
Figure 13.2 – Customer support data solution overview
Figure 13.2 shows our two data sources with the columns we will use in this chapter. The diagram also shows an external connection with a service account and the identity and access management roles attached, along with a sentiment BigQuery Machine Learning (BQML) model. You may notice the column names are missing on the bitextcustomersupport table (string_field_x). During the data preparation process, we will fix these column names. In this exercise, we will attempt to find the following insights in queries and...
