Self Service BI: doing a Customer 360 by querying and joining Salesforce, Marketing and log datasets

10 January 2018 in Querying / Version 4 / Tutorial - 1 minute read

In this demo we use the Editor to query credit card transaction data that is saved in an object store in the cloud (here S3) and in a Kudu table. The demos leverages the Data Catalog search and tagging as well as the Query Assistant.

Note: Do it Yourself! The queries and data are freely available on

Scenario: Digital Services International

You recently launched a new streaming service:

    • VP wants to understand support impact of this launch
    • Marketing wants to use this to better target campaigns
  • Goal: Build a 360-degree view of your customers to understand the support costs, product usage, time-to-resolution, and current activity in marketing channels

    What we’ll cover:

  • Find the right sales tables across all databases
  • Query Salesforce to see support activity by accounts and TTR
  • Join with Usage Logs (Kudu table) to correlate usage with support activity
  • Join with Marketing Database to see existing campaign activity and filter out support-heavy customers for special campaign
  • Save & share queries for other members of the team and other departments

    comments powered by Disqus

    More recent stories

    10 February 2020
    The Hue SQL Query Experience for your Data Warehouse
    Read More
    28 January 2020
    10 years of Data Querying Experience Evolution with Hue
    Read More
    05 December 2019
    Hue 4.6 and its improvements are out!
    Read More