使用查询服务创建仪表板
了解如何验证摄入的数据、从存储在数据湖中的数据中获得洞察力以及使用 Adobe Experience Platform 中的查询服务创建仪表板。
查询服务概述
了解Adobe Experience Platform中的查询服务如何帮助您了解客户行为并生成有影响力的见解。
492
{ "description": "了解Adobe Experience Platform中的查询服务如何帮助您了解客户行为并生成有影响力的见解。", "duration": "PT0H8M12S", "embedUrl": "https://video.tv.adobe.com/v/33591/", "name": "查询服务概述", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652508-100x56.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652508-150x84.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652508-200x113.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652509-220x124.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652509-236x133.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652510-290x186.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652510-420x236.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652510-640x360.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652511-666x374.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652511-720x405.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652512-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/83df592c-0019-4a8c-b00d-2ebe28093024/0d8fc552-af34-4c24-b16d-388b4838f362/dc8918d1181a4317a1a86daacf8d3d46_1587652512-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2020-04-23T14:30:36Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "查询服务概述" }
查询服务UI
了解如何在 Adobe Experience Platform 查询服务中编写和执行查询、查看以前执行的查询以及访问由 IMS 组织内的其他用户保存的查询。
419
{ "description": "了解如何在 Adobe Experience Platform 查询服务中编写和执行查询、查看以前执行的查询以及访问由 IMS 组织内的其他用户保存的查询。", "duration": "PT0H6M59S", "embedUrl": "https://video.tv.adobe.com/v/333403/", "name": "查询服务UI", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-100x56.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-150x84.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-200x113.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-220x124.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-236x133.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517107-290x186.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-420x236.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-640x360.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-666x374.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-720x405.jpg", "https://images-tv.adobe.com/mpcv3/52e74821-ed38-4203-83fb-db8aacc9b6e9/c8f466ff-cf60-4c4a-a4c9-d17b6ac2b2fa/54a3b0853c4f4876bdc6e634f85de60d_1622517108-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-05-19T20:47:28Z", "hasPart": [ { "@type": "Clip", "name": "Queries", "startOffset": 46, "endOffset": 141, "url": "https://video.tv.adobe.com/v/333403/?t=46" }, { "@type": "Clip", "name": "Output result to a dataset", "startOffset": 142, "endOffset": 246, "url": "https://video.tv.adobe.com/v/333403/?t=142" }, { "@type": "Clip", "name": "Schedule a query in the UI", "startOffset": 247, "endOffset": 368, "url": "https://video.tv.adobe.com/v/333403/?t=247" }, { "@type": "Clip", "name": "Connect Query Service to desktop applications", "startOffset": 369, "endOffset": 419, "url": "https://video.tv.adobe.com/v/333403/?t=369" } ], "educationLevel": [ "Beginner" ], "learningResourceType": "查询服务UI" }
查询服务API
了解如何使用Adobe Experience Platform查询服务API编写和执行查询、创建计划查询以及创建查询模板。
395
{ "description": "了解如何使用Adobe Experience Platform查询服务API编写和执行查询、创建计划查询以及创建查询模板。", "duration": "PT0H6M35S", "embedUrl": "https://video.tv.adobe.com/v/3414083/", "name": "查询服务API", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450772-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450772-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450772-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450772-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450772-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450773-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450773-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450773-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450773-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450774-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450774-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/e5414258-9f18-4dce-b27c-6be95d62c693/087772488af1422894c96bc66c7ee39c_1675450774-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:54:00Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "查询服务API" }
浏览数据
了解如何使用 SQL 函数验证提取的数据、预览数据以及探索数据的统计和分析属性。
220
{ "description": "了解如何使用 SQL 函数验证提取的数据、预览数据以及探索数据的统计和分析属性。", "duration": "PT0H3M40S", "embedUrl": "https://video.tv.adobe.com/v/3414053/", "name": "浏览数据", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448012-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448012-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448012-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448012-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448013-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448013-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448013-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448013-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448013-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448013-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448014-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/eac6bdb4-31f9-4d36-957a-4e338afb27e7/ca8958e155d24a58972e30086d77ea7e_1675448014-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:10:57Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "浏览数据" }
准备数据
了解如何清理、准备和合并来自多个数据集的数据,以使用CTAS(Create Table AS)和Spark SQL函数创建新的数据集以用于报告和仪表板。
217
{ "description": "了解如何清理、准备和合并来自多个数据集的数据,以使用CTAS(Create Table AS)和Spark SQL函数创建新的数据集以用于报告和仪表板。", "duration": "PT0H3M37S", "embedUrl": "https://video.tv.adobe.com/v/3414065/", "name": "准备数据", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449144-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449144-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449144-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449144-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449144-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449145-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449145-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449145-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449145-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449145-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449146-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/3b68299c-21b2-41b8-9e87-6afeb7a4c5d1/22ba510edb5744e2bb6dc7f3129317e9_1675449146-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T18:29:44Z", "hasPart": [], "educationLevel": [ "Beginner" ], "learningResourceType": "准备数据" }
将Tableau连接到查询服务
了解如何从各种支持PostgreSQL协议的桌面客户端应用程序连接到查询服务,以及如何使用PostgreSQL工具和驱动程序连接和写入查询。
254
{ "description": "了解如何从各种支持PostgreSQL协议的桌面客户端应用程序连接到查询服务,以及如何使用PostgreSQL工具和驱动程序连接和写入查询。", "duration": "PT0H4M14S", "embedUrl": "https://video.tv.adobe.com/v/3414041/", "name": "将Tableau连接到查询服务", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444766-100x56.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444767-150x85.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444767-200x113.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444767-220x124.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444767-236x133.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444767-290x163.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444767-420x236.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444768-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444768-640x360.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444768-666x375.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444768-720x405.jpg", "https://images-tv.adobe.com/mpcv3/bdc332ce-3e7a-429d-87b2-42548446b7ba/1edffa85-e451-47d5-a5ce-b40a4f551622/c641336a06c844ae8843c869f9190eb3_1675444768-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2023-02-03T17:15:55Z", "hasPart": [], "educationLevel": [ "Intermediate" ], "learningResourceType": "将Tableau连接到查询服务" }