Using CLAIRE GPT > Data Integration > Break down customers by age group
  

Break down customers by age group

You’re a data analyst at a retail company and you want to break down your customer base by age group to create targeted marketing initiatives. You can submit a single prompt to CLAIRE GPT to identify the right tables to use for the analysis, select a source table, and create an ELT pipeline as a mapping that transforms the data and writes it to a target.
To achieve the goal, perform the following steps:
    1Log in to CLAIRE GPT.
    2Start a conversation by entering the following prompt:
    Create a mapping to show the demographic breakdown of our customer base by age groups
    The following image shows the response:
    The response creates a plan to use the data discovery agent to identify customer tables and the data integration agent to create a mapping. Then, it asks you to select the source table that you want to use.
    3To view the identified source tables, select the card for the customer datasets.
    The following image shows the customer datasets:
    The canvas displays the customer datasets.
    4To use the CUSTOMERS table to create the mapping, enter CUSTOMERS.
    The following image shows the response:
    The response provides a demographic analysis and creates a mapping to group customers by age and write the transformed data to a target table.
    5To view the demographic breakdown, select the card for the customer distribution by age group.
    The following image shows the customer distribution by age group:
    The canvas displays the customer distribution by age group.
    6To view the mapping, select the card for the mapping.
    The following image shows the proposed mapping:
    The canvas displays the proposed mapping.
    7To view and save the mapping in Data Integration, select Open in Data Integration.
    In Data Integration, you can also edit the mapping or create a mapping task to run it. For more information, see the Data Integration help.