{"id":15443,"date":"2026-02-20T07:06:10","date_gmt":"2026-02-20T07:06:10","guid":{"rendered":"http:\/\/mariusz.bijok"},"modified":"2026-05-20T12:41:36","modified_gmt":"2026-05-20T12:41:36","password":"","slug":"business-intelligence-tools","status":"publish","type":"docs","link":"https:\/\/tenjin.com\/zh\/docs\/business-intelligence-tools\/","title":{"rendered":"BI tool \u53ef\u89c6\u5316"},"content":{"rendered":"<h2 class=\"wp-block-heading\">Querying DataVault \u67e5\u8be2\u6570\u636e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">DataVault \u57fa\u4e8e Redshift \u6784\u5efa\uff0c\u5e76\u5177\u6709\u4e0e PostgreSQL \u7c7b\u4f3c\u7684\u67e5\u8be2\u8bed\u6cd5\u3002\u5927\u591a\u6570BI\u5de5\u5177\u5141\u8bb8\u4f60\u901a\u8fc7PostgreSQL\u8bbf\u95ee\u6570\u636e\u5e93\u3002\u8fd9\u8db3\u4ee5\u8bbf\u95ee\u4f60\u7684DataVault\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Business Intelligence (BI) Tools<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0b\u662f\u4e00\u4e9b\u53ef\u4ee5\u4e0e DataVault \u914d\u5408\u4f7f\u7528\u7684BI\u5de5\u5177\u3002\u6211\u4eec\u8fd8\u4e0e\u5176\u4e2d\u4e00\u4e9b\u516c\u53f8\u5efa\u7acb\u4e86\u5408\u4f5c\u4f19\u4f34\u5173\u7cfb\u3002\u5982\u679c\u5bf9\u5408\u4f5c\u5173\u7cfb\u6709\u4efb\u4f55\u7591\u95ee\uff0c\u8bf7\u8054\u7cfbinfo@tenjin.io\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/tenjin.com\/wp-content\/uploads\/2026\/01\/image131.png?ssl=1\" alt=\"image.png\" class=\"wp-image-13100\" style=\"width:75px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/tenjin.com\/wp-content\/uploads\/2026\/01\/image132.png?ssl=1\" alt=\"image.png\" class=\"wp-image-13101\" style=\"width:129px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/tenjin.com\/wp-content\/uploads\/2026\/01\/image133.png?ssl=1\" alt=\"image.png\" class=\"wp-image-13102\" style=\"width:93px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/tenjin.com\/wp-content\/uploads\/2026\/01\/image134.png?ssl=1\" alt=\"image.png\" class=\"wp-image-13103\" style=\"width:159px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/tenjin.com\/wp-content\/uploads\/2026\/01\/image135.png?ssl=1\" alt=\"image.png\" class=\"wp-image-13104\" style=\"width:81px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/tenjin.com\/wp-content\/uploads\/2026\/01\/image136.png?ssl=1\" alt=\"image.png\" class=\"wp-image-13105\" style=\"aspect-ratio:3.8937235271467077;width:206px;height:auto\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/tenjin.com\/wp-content\/uploads\/2026\/01\/image290.png?ssl=1\" alt=\"image.png\" class=\"wp-image-13106\" style=\"width:110px;height:auto\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u5f00\u59cb\u4f7f\u7528 SQL \u67e5\u8be2\u6570\u636e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b66\u4e60\u7f16\u5199SQL\u53ef\u80fd\u6709\u70b9\u6311\u6218\uff0c\u4f46\u672a\u6765\u6240\u6709\u7684\u8425\u9500\u4eba\u5458\u90fd\u5c06\u9700\u8981\u6b64\u6280\u80fd\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tenjin \u6709\u8bb8\u591a\u793a\u4f8b\uff0c\u4f7f\u5b66\u4e60SQL\u548cDataVault\u53d8\u5f97\u5bb9\u6613\u3002\u968f\u7740\u4f60\u7684\u9002\u5e94\u7a0b\u5ea6\u63d0\u9ad8\uff0c\u4f60\u53ef\u4ee5\u4fee\u6539\u67e5\u8be2 query \u5e76\u7ee7\u7eed\u8fdb\u884c\u4f18\u5316\uff01<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b66\u4e60\u4f7f\u7528 SQL \u8bed\u8a00<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_select.asp\">SELECT<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_distinct.asp\">SELECT DISTINCT<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_distinct.asp\">WHERE<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_and_or.asp\">AND\/OR\/NOT<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_orderby.asp\">ORDER BY<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_join.asp\">JOIN<\/a>, <a href=\"https:\/\/www.w3schools.com\/sql\/sql_join_inner.asp\">INNER JOIN<\/a><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u7528\u4ee5\u4e0a\u57fa\u7840\u77e5\u8bc6\uff0c\u4f60\u53ef\u4ee5\u63d0\u53d6 DataVault \u4e2d\u5b58\u5728\u7684\u6570\u636e\u8868\uff0c\u5e76\u901a\u8fc7\u8054\u63a5\u5728 tables \u4e4b\u95f4\u6865\u63a5\u6570\u636e\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7ed3\u5408\u4ee5\u4e0b\u6765\u81ea Tenjin \u7684\u793a\u4f8b\uff0c\u4f60\u5e94\u8be5\u6709\u8db3\u591f\u7684\u80fd\u529b\u9002\u5e94\u8425\u9500\u6240\u9700\u7684\u4efb\u4f55\u4f18\u5316\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Tenjin \u7684\u6807\u51c6 Queries<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6bcf\u4e2a DataVault \u7684 Query \u90fd\u53ef\u4ee5\u6839\u636e\u4f60\u7684\u9700\u6c42\u8fdb\u884c\u4fee\u6539\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0b\u662f\u4e00\u4e2a query \u793a\u4f8b\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT COUNT(DISTINCT coalesce(advertising_id, developer_device_id)) as dau <br>FROM events <br>WHERE created_at :: DATE = &#8216;@DATE&#8217; AND bundle_id = &#8216;@BUNDLEID&#8217; AND platform = &#8216;@PLATFORM&#8217;;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8be5 Query \u5c06\u8ba1\u7b97\u7279\u5b9a\u65e5\u671f\u7684\u6bcf\u65e5\u6d3b\u52a8\u7528\u6237\uff08DAU\uff09\u3002\u5373\u4fbf\u4e0d\u77e5\u9053SQL\uff0c\u4f60\u4e5f\u80fd\u5927\u6982\u8bfb\u61c2\u5b83\u5728\u505a\u4ec0\u4e48\u3002\u4f46\u662f\uff0c\u73b0\u5728\u6682\u65f6\u5ffd\u7565\u4e0a\u4e0b\u6587\uff0c\u5047\u8bbe\u53ea\u662f\u77e5\u9053\u5b83\u4f1a\u8ba1\u7b97\u67d0\u4e00\u5929\u7684 DAU\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph translation-block\">\u4f5c\u4e3a\u521d\u5b66\u8005\uff0c\u4f60\u53ea\u9700\u4f7f\u7528@\u7684\u53d8\u91cf\uff0c\u5373\u53ef\u83b7\u5f97\u6240\u9700\u7684\u5185\u5bb9\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph translation-block\">\u5728\u8fd9\u4e2a\u4f8b\u5b50\u4e2d\uff0c\u6539\u53d8<code>@DATE<\/code>\u4e3a\u4f60\u8981\u5206\u6790\u7684\u65e5\u671f\uff0c\u5c06<code>@BUNDLEID<\/code>\u7684 <code>bundle_id<\/code> \u6539\u4e3a\u4f60\u6b63\u5728\u7528\u7684\u503c\uff0c<code>@PLATFORM<\/code> \u7684<code>platform<\/code>  \u6539\u4e3a\u4f60\u8981\u67e5\u8be2\u7684\u5e73\u53f0\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u540e\uff0c\u4f60\u53ef\u4ee5\u5c06\u67e5\u8be2\u4fee\u6539\u4e3a\u5982\u4e0b\u6240\u793a\uff1a <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT COUNT(DISTINCT coalesce(advertising_id, developer_device_id)) as dau <br>FROM events <br>WHERE created_at :: DATE = &#8216;2018-02-01&#8217; AND bundle_id = &#8216;com.tenjin.wordfinder&#8217; AND platform = &#8216;ios&#8217;;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u5c06\u81ea\u52a8\u8ba1\u7b97\u4f60\u5728\u5728ios\u4e0a App \u7684 DAU\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>","protected":false},"excerpt":{"rendered":"<p>Querying DataVault DataVault is built on Redshift and has a query syntax similar to PostgreSQL. Most BI tools allow you to access databases through PostgreSQL. This should be sufficient to access your DataVault. Business Intelligence (BI) Tools Here are a few BI tools that are known to work well with DataVault. We also have partnerships&#8230;<\/p>","protected":false},"author":17,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[96],"glossaries":[],"doc_tag":[],"class_list":["post-15443","docs","type-docs","status-publish","hentry","doc_category-datavault"],"acf":[],"year_month":"2026-06","word_count":393,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"anurag","author_nicename":"anurag","author_url":"https:\/\/tenjin.com\/zh\/blog\/author\/anurag\/"},"doc_category_info":[{"term_name":"DataVault","term_url":"https:\/\/tenjin.com\/zh\/docs\/category\/datavault\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>BI: Querying DataVault | Tenjin<\/title>\n<meta name=\"description\" content=\"Learn how to optimize SQL queries for DataVault on Redshift, and explore BI tools that enhance your data analysis skills. Start your journey today!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tenjin.com\/zh\/docs\/business-intelligence-tools\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BI: Querying DataVault | Tenjin\" \/>\n<meta property=\"og:description\" content=\"Learn how to optimize SQL queries for DataVault on Redshift, and explore BI tools that enhance your data analysis skills. Start your journey today!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tenjin.com\/zh\/docs\/business-intelligence-tools\/\" \/>\n<meta property=\"og:site_name\" content=\"Tenjin\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-20T12:41:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/01\/image131.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@TenjinMMP\" \/>\n<meta name=\"twitter:label1\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/\"},\"author\":{\"name\":\"anurag\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#\\\/schema\\\/person\\\/e039df04bf002f4a0825fce9d6d5f13b\"},\"headline\":\"Business Intelligence Tools\",\"datePublished\":\"2026-02-20T07:06:10+00:00\",\"dateModified\":\"2026-05-20T12:41:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/\"},\"wordCount\":387,\"publisher\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tenjin.com\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/image131.png\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/\",\"url\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/\",\"name\":\"BI: Querying DataVault | Tenjin\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tenjin.com\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/image131.png\",\"datePublished\":\"2026-02-20T07:06:10+00:00\",\"dateModified\":\"2026-05-20T12:41:36+00:00\",\"description\":\"Learn how to optimize SQL queries for DataVault on Redshift, and explore BI tools that enhance your data analysis skills. Start your journey today!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/#primaryimage\",\"url\":\"https:\\\/\\\/tenjin.com\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/image131.png\",\"contentUrl\":\"https:\\\/\\\/tenjin.com\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/image131.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/business-intelligence-tools\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/tenjin.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Docs\",\"item\":\"https:\\\/\\\/tenjin.com\\\/docs\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Business Intelligence Tools\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#website\",\"url\":\"https:\\\/\\\/tenjin.com\\\/\",\"name\":\"Tenjin\",\"description\":\"Growth Made Simple\",\"publisher\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/#organization\"},\"alternateName\":\"Tenjin - Mobile Measurement Partner\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/tenjin.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#organization\",\"name\":\"Tenjin\",\"url\":\"https:\\\/\\\/tenjin.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/tenjin.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/images.webp\",\"contentUrl\":\"https:\\\/\\\/tenjin.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/images.webp\",\"width\":429,\"height\":117,\"caption\":\"Tenjin\"},\"image\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/TenjinMMP\",\"https:\\\/\\\/www.youtube.com\\\/@TenjinMMP\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/tenjin\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#\\\/schema\\\/person\\\/e039df04bf002f4a0825fce9d6d5f13b\",\"name\":\"anurag\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g\",\"caption\":\"anurag\"},\"url\":\"https:\\\/\\\/tenjin.com\\\/zh\\\/blog\\\/author\\\/anurag\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BI: Querying DataVault | Tenjin","description":"Learn how to optimize SQL queries for DataVault on Redshift, and explore BI tools that enhance your data analysis skills. Start your journey today!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tenjin.com\/zh\/docs\/business-intelligence-tools\/","og_locale":"zh_CN","og_type":"article","og_title":"BI: Querying DataVault | Tenjin","og_description":"Learn how to optimize SQL queries for DataVault on Redshift, and explore BI tools that enhance your data analysis skills. Start your journey today!","og_url":"https:\/\/tenjin.com\/zh\/docs\/business-intelligence-tools\/","og_site_name":"Tenjin","article_modified_time":"2026-05-20T12:41:36+00:00","og_image":[{"url":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/01\/image131.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@TenjinMMP","twitter_misc":{"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/#article","isPartOf":{"@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/"},"author":{"name":"anurag","@id":"https:\/\/tenjin.com\/#\/schema\/person\/e039df04bf002f4a0825fce9d6d5f13b"},"headline":"Business Intelligence Tools","datePublished":"2026-02-20T07:06:10+00:00","dateModified":"2026-05-20T12:41:36+00:00","mainEntityOfPage":{"@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/"},"wordCount":387,"publisher":{"@id":"https:\/\/tenjin.com\/#organization"},"image":{"@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/01\/image131.png","inLanguage":"zh-Hans"},{"@type":"WebPage","@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/","url":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/","name":"BI: Querying DataVault | Tenjin","isPartOf":{"@id":"https:\/\/tenjin.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/#primaryimage"},"image":{"@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/01\/image131.png","datePublished":"2026-02-20T07:06:10+00:00","dateModified":"2026-05-20T12:41:36+00:00","description":"Learn how to optimize SQL queries for DataVault on Redshift, and explore BI tools that enhance your data analysis skills. Start your journey today!","breadcrumb":{"@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tenjin.com\/docs\/business-intelligence-tools\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/#primaryimage","url":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/01\/image131.png","contentUrl":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/01\/image131.png"},{"@type":"BreadcrumbList","@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tenjin.com\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/tenjin.com\/docs\/"},{"@type":"ListItem","position":3,"name":"Business Intelligence Tools"}]},{"@type":"WebSite","@id":"https:\/\/tenjin.com\/#website","url":"https:\/\/tenjin.com\/","name":"Tenjin","description":"\u8ba9\u589e\u957f\u53d8\u7b80\u5355","publisher":{"@id":"https:\/\/tenjin.com\/#organization"},"alternateName":"Tenjin - Mobile Measurement Partner","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tenjin.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Organization","@id":"https:\/\/tenjin.com\/#organization","name":"Tenjin","url":"https:\/\/tenjin.com\/","logo":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/tenjin.com\/#\/schema\/logo\/image\/","url":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/04\/images.webp","contentUrl":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/04\/images.webp","width":429,"height":117,"caption":"Tenjin"},"image":{"@id":"https:\/\/tenjin.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/TenjinMMP","https:\/\/www.youtube.com\/@TenjinMMP","https:\/\/www.linkedin.com\/company\/tenjin"]},{"@type":"Person","@id":"https:\/\/tenjin.com\/#\/schema\/person\/e039df04bf002f4a0825fce9d6d5f13b","name":"anurag","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/secure.gravatar.com\/avatar\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g","caption":"anurag"},"url":"https:\/\/tenjin.com\/zh\/blog\/author\/anurag\/"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/docs\/15443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/comments?post=15443"}],"version-history":[{"count":4,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/docs\/15443\/revisions"}],"predecessor-version":[{"id":16564,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/docs\/15443\/revisions\/16564"}],"wp:attachment":[{"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/media?parent=15443"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/doc_category?post=15443"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/glossaries?post=15443"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/doc_tag?post=15443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}