Team Members
Clients
Reporting
Bigquery
Intouchcx
100

Mention team members who live in canada

Nick, Charlenne, Matthew

100

What is the Program with more headcount?

Airbnb

100

What is the country with more headcount?

Philippines

100

What SQL command is used in BigQuery to remove duplicate rows from query results?

DISTINCT

100

What is a recent company Intouch announced their acquisition? 

 WebPurify, a premier provider of AI-powered and human-driven content moderation solutions.

200

Who in our team lives in arizona?

Alex

200

what is the program with less headcount in the dashboard?

Ulta Beauty

200

How can you use calculated fields in Looker Studio to create custom metrics, and what types of operations can be performed?

In Looker Studio, calculated fields are used to create custom metrics or dimensions by applying mathematical, string, or date functions to existing data. You can perform operations like addition, subtraction, multiplication, division, as well as conditional logic (e.g., IF statements) and string manipulation (e.g., concatenation or text formatting).

200

What is the BigQuery feature that allows you to query data without loading it first?

Federated queries

200

when was intouch cx founded?

IntouchCX was founded in 2000

300

What is madeleine's favorite sport?

Cycling

300

What clients are using AI in their QA?

Maple Leaf (Email/Voice) y NCAA (Voice)

300

How many dashboards are in vision 2.0

39 

300

How many projects exists in bigquery?

8 projects:

DigitalSolutions GlobalData
LATAM Reporting
NORAM Reportingcrossbow-engine
APAC Reporting
Catapult Data
Workforce Management Data
Superpunch Data

300

What is the mission of Intouch CX?

To create world-class customer experiences

400

Who is the joungest and who is the oldest?

i dont know but to gets it right gets the points haha

400

what client is using ujet for the phone calls

instacart

400

In Looker Studio, how does using "Custom Dimensions" improve the flexibility of your reports, and what are some examples of custom dimensions you might create?

Custom dimensions allow users to define specific attributes that are not available in the data source by default. They can be used to create personalized or calculated fields, such as customer segments, product categories, or region-based aggregations.

400

what table / data has a Scheduled Query for: 1 of month 13:00 

DI_post_training_survey_final

400

In how many countries does Intouch CX operate globally?

Intouch CX operates in 12 countries globally

500

Who in the team has children?

i don't know but who gets it right, gets the points. 

500

What is the program that gives us more issues in their reports? 

I do not know the answer but if the provided answer is approved by the rest the person can get the points

500

In Looker Studio, what are the limitations when working with "Real-Time Data" and how can these limitations be mitigated?

 Real-time data reporting can be limited by the frequency of data updates, network latency, and the volume of data being processed. These limitations can be mitigated by optimizing data sources, using caching to store recent data, and ensuring efficient data streaming practices.

500

Which job consumes the most time and processes the largest amount of data (in bytes)? and or who created it?

script_job_970c0036751032baf96751f4ba8225ef_1

jgodinezpineda@intouchcx.com

digitalsolutions-globaldata

500
Mention the Acquisitions made in 2020 and 2021

Knoah Solutions in 2020 and Goodbay Technologies in 2021

M
e
n
u