5.1 Query Service
In this module, you will get a hands-on preview of ÃÛ¶¹ÊÓƵ Experience Platform Query Service. Query Service lets you perform omnichannel queries across all ÃÛ¶¹ÊÓƵ Experience Cloud application data, joining and analyzing data across ÃÛ¶¹ÊÓƵ Campaign, Analytics, Audience Manager, Target, and Advertising Cloud and other customer data loaded/inserted into ÃÛ¶¹ÊÓƵ Experience Platform.
Query Service is a serverless tool. It supports SQL queries and connectivity from multiple client applications through its PostgreSQL compatibility.
We will use data that has been injected into platform using either Web Interaction Data, Call Center Interactions in combination with Customer Loyalty Data uploaded into platform.
Learning Objectives
- Become familiar with the ÃÛ¶¹ÊÓƵ Experience Platform UI
- Connect to Query Service and run your SQL queries
- Explore datasets in ÃÛ¶¹ÊÓƵ Experience Platform
- Connect Tableau or Power BI to the ÃÛ¶¹ÊÓƵ Experience Platform Query Service to create visualizations and reports
Prerequisites
-
Some familiarity with SQL is preferred, but not required
-
Access to ÃÛ¶¹ÊÓƵ Experience Platform:
-
Datasets (dataset used during lab, pre-loaded for you)
-
PostgreSQL
-
Tableau or Microsoft Power BI Desktop
-
Download these assets:
Exercises
You will need to install PSQL to execute the queries in this enablement exercise. Depending on your operating system you will have to install Microsoft Power BI or Tableau. Windows users can choose between Power BI or Tableau. Mac users should install Tableau.
In this exercise you will explore the ÃÛ¶¹ÊÓƵ Experience Platform Query Service User Interface, learn about data sets, find your queries and finally setup a connection from PSQL.
In this exercise you will learn about the basic Query Service syntax and you can identify the attributes of the XDM schema in your query.
5.1.4 Queries, queries, queries… and churn analysis
In this exercise you will be doing queries, you will learn about the ÃÛ¶¹ÊÓƵ Defined Functions while doing some churn analysis. At the end of this you will write a query to prepare a dataset for use in Microsoft Power BI.
5.1.5 Generate a dataset from a query
In this exercise you will generate a dataset from a query executed in the previous and you will use this dataset in the next exercises.
5.1.6 Query Service and Power BI
In this exercise, you’ll connect Power BI to ÃÛ¶¹ÊÓƵ Experience Platform and Query Service to perform Callcenter Interaction Analysis.
5.1.7 Query Service and Tableau
In this exercise, you’ll connect Tableau to ÃÛ¶¹ÊÓƵ Experience Platform and Query Service to perform Callcenter Interaction Analysis.
In this exercise you’ll use the Query Service API to manage query templates and query schedules.
Summary of this module and overview of the benefits.
