{"id":15443,"date":"2026-02-20T07:06:10","date_gmt":"2026-02-20T07:06:10","guid":{"rendered":"http:\/\/mariusz.bijok"},"modified":"2026-03-13T17:15:56","modified_gmt":"2026-03-13T17:15:56","password":"","slug":"business-intelligence-tools","status":"publish","type":"docs","link":"https:\/\/tenjin.com\/ja\/docs\/business-intelligence-tools\/","title":{"rendered":"\u30d3\u30b8\u30cd\u30b9\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9\u30c4\u30fc\u30eb"},"content":{"rendered":"<h2 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30dc\u30eb\u30c8\u4e0a\u3067\u306e\u30af\u30a8\u30ea<\/h2>\n\n\n\n<p>\u30c7\u30fc\u30bf\u30dc\u30eb\u30c8\u306f\u30a2\u30de\u30be\u30f3\u30ec\u30c3\u30c9\u30b7\u30d5\u30c8\u4e0a\u306b\u69cb\u7bc9\u3055\u308c\u3066\u3044\u3066\u3001PostgreSQL\u3068\u540c\u69d8\u306e\u30b7\u30f3\u30bf\u30c3\u30af\u30b9\u3067\u30af\u30a8\u30ea\u3092\u767a\u884c\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002\u307b\u3068\u3093\u3069\u306e\u30d3\u30b8\u30cd\u30b9\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9\u30c4\u30fc\u30eb\u3067PostgreSQL\u3078\u306e\u30a2\u30af\u30bb\u30b9\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u30d3\u30b8\u30cd\u30b9\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9(BI)\u30c4\u30fc\u30eb<\/h3>\n\n\n\n<p>\u4e0b\u8a18\u304c\u30c7\u30fc\u30bf\u30dc\u30eb\u30c8\u3068\u76f8\u6027\u306e\u3088\u3044BI\u30c4\u30fc\u30eb\u306e\u4e00\u89a7\u3067\u3059\u3002Tenjin\u306f\u3053\u308c\u3089\u306e\u30c4\u30fc\u30eb\u63d0\u4f9b\u4f1a\u793e\u3068\u30d1\u30fc\u30c8\u30ca\u30fc\u30b7\u30c3\u30d7\u3092\u7de0\u7d50\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u306b\u3064\u3044\u3066\u306e\u8a73\u7d30\u306f\u3001info@tenjin.io\u3078\u304a\u554f\u3044\u5408\u308f\u305b\u304f\u3060\u3055\u3044\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=\"\u753b\u50cf.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=\"\u753b\u50cf.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=\"\u753b\u50cf.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=\"\u753b\u50cf.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=\"\u753b\u50cf.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=\"\u753b\u50cf.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=\"\u753b\u50cf.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\">\u307e\u305a\u521d\u3081\u306b<\/h3>\n\n\n\n<p>SQL\u306e\u7fd2\u5f97\u306b\u306f\u6642\u9593\u304c\u304b\u304b\u308a\u307e\u3059\u304c\u3001\u5168\u3066\u306e\u30de\u30fc\u30b1\u30bf\u30fc\u306f\u3053\u306e\u30b9\u30ad\u30eb\u3092\u8eab\u306b\u3064\u3051\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>Tenjin\u3067\u306f\u3001\u30c7\u30fc\u30bf\u30dc\u30eb\u30c8\u4e0a\u3067SQL\u3092\u5b9f\u884c\u3059\u308b\u306e\u306b\u3044\u304f\u3064\u304b\u4f8b\u3092\u4e0a\u3052\u3066\u3044\u307e\u3059\u3002SQL\u306e\u7fd2\u719f\u5ea6\u306b\u5fdc\u3058\u3066\u3001\u81ea\u7531\u306b\u30af\u30a8\u30ea\u3092\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">SQL\u306e\u5b66\u7fd2<\/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>\u4e0a\u8a18\u306e\u57fa\u672c\u4e8b\u9805\u3092\u5229\u7528\u3059\u308c\u3070\u3001DataVault\u306b\u5b58\u5728\u3059\u308b\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\u3092\u62bd\u51fa\u3057\u3001\u7d50\u5408\u306b\u3088\u3063\u3066\u30c6\u30fc\u30d6\u30eb\u9593\u306e\u30c7\u30fc\u30bf\u3092\u6a4b\u6e21\u3057\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>Tenjin\u3088\u308b\u4ee5\u4e0b\u306e\u4f8b\u3068\u7d44\u307f\u5408\u308f\u305b\u308c\u3070\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u306b\u5fc5\u8981\u306a\u6700\u9069\u5316\u3092\u958b\u59cb\u3059\u308b\u306e\u306b\u5341\u5206\u306a\u60c5\u5831\u304c\u63c3\u3046\u306f\u305a\u3067\u3059\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\u306e\u30af\u30a8\u30ea\u306b\u3064\u3044\u3066<\/h3>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306e\u30af\u30a8\u30ea\u306f\u30cb\u30fc\u30ba\u306b\u5408\u308f\u305b\u3066\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u4e0b\u8a18\u304c\u30b5\u30f3\u30d7\u30eb\u30af\u30a8\u30ea\u3067\u3059\u3002<\/p>\n\n\n\n<p>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>\u3053\u306e\u30af\u30a8\u30ea\u306f\u3001\u7279\u5b9a\u306e\u65e5\u4ed8\u306e1\u65e5\u3042\u305f\u308a\u306e\u30a2\u30af\u30c6\u30a3\u30d6\u30e6\u30fc\u30b6\u30fc\u6570(DAU)\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002SQL\u306e\u77e5\u8b58\u304c\u306a\u304f\u3066\u3082\u3001\u304a\u304a\u3088\u305d\u4f55\u3092\u3057\u3066\u3044\u308b\u306e\u304b\u306f\u7406\u89e3\u3067\u304d\u308b\u3067\u3057\u3087\u3046\u3002\u305f\u3060\u3057\u3001\u4eca\u306f\u8a73\u7d30\u306a\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u306f\u7121\u8996\u3057\u3066\u3001\u7279\u5b9a\u306e\u65e5\u4ed8\u306eDAU\u3092\u8a08\u7b97\u3057\u3066\u3044\u308b\u3068\u3044\u3046\u70b9\u3060\u3051\u3092\u7406\u89e3\u3057\u3066\u304a\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"translation-block\">\u521d\u5fc3\u8005\u306e\u65b9\u306f\u3001<code>@<\/code>\u8a18\u53f7\u3092\u4f7f\u3063\u3066\u3059\u3079\u3066\u306e\u5909\u6570\u3092\u5909\u66f4\u3059\u308b\u3060\u3051\u3067\u5fc5\u8981\u306a\u3082\u306e\u304c\u5f97\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"translation-block\">\u3053\u306e\u30b1\u30fc\u30b9\u3067\u306f\u3001@DATE\u3092DAU\u3092\u8a08\u7b97\u3057\u305f\u3044\u65e5\u4ed8, @BUNDLEID\u3092\u8a72\u5f53\u306e\u30a2\u30d7\u30ea\u306e\u30d0\u30f3\u30c9\u30ebID, \u305d\u3057\u3066@PLATFORM\u3092\u8a72\u5f53\u306e\u30a2\u30d7\u30ea\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0(ios, android)\u306b\u7f6e\u304d\u63db\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6700\u7d42\u7684\u306b\u306f\u3001\u30af\u30a8\u30ea\u3092\u6b21\u306e\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3059\u3002 <\/p>\n\n\n\n<p>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>\u3053\u308c\u306b\u3088\u308a\u3001\u81ea\u52d5\u7684\u306biOS\u30a2\u30d7\u30ea\u306e2018\/2\/1\u306eDAU\u304c\u8a08\u7b97\u3067\u304d\u307e\u3059\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":25,"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-04","word_count":393,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"mariusz.bijok","author_nicename":"mariusz-bijok","author_url":"https:\/\/tenjin.com\/ja\/blog\/author\/mariusz-bijok\/"},"doc_category_info":[{"term_name":"DataVault","term_url":"https:\/\/tenjin.com\/ja\/docs\/category\/datavault\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>BI Tools - Querying DataVault - Tenjin Help Center<\/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\/ja\/docs\/business-intelligence-tools\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BI Tools - Querying DataVault - Tenjin Help Center\" \/>\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\/ja\/docs\/business-intelligence-tools\/\" \/>\n<meta property=\"og:site_name\" content=\"Tenjin\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-13T17:15:56+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=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\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\":\"mariusz.bijok\",\"@id\":\"https:\/\/tenjin.com\/#\/schema\/person\/2df6a56c45e0493e93ec6d7100750b77\"},\"headline\":\"Business Intelligence Tools\",\"datePublished\":\"2026-02-20T07:06:10+00:00\",\"dateModified\":\"2026-03-13T17:15:56+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\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/\",\"url\":\"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/\",\"name\":\"BI Tools - Querying DataVault - Tenjin Help Center\",\"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-03-13T17:15:56+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\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@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\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/tenjin.com\/#organization\",\"name\":\"Tenjin\",\"url\":\"https:\/\/tenjin.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@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\/2df6a56c45e0493e93ec6d7100750b77\",\"name\":\"mariusz.bijok\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/tenjin.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ed77b923271ae0c54cf6cc2b3d031d191c17791d92b8a5f5d186753477fbbdb9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ed77b923271ae0c54cf6cc2b3d031d191c17791d92b8a5f5d186753477fbbdb9?s=96&d=mm&r=g\",\"caption\":\"mariusz.bijok\"},\"url\":\"https:\/\/tenjin.com\/ja\/blog\/author\/mariusz-bijok\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BI Tools - Querying DataVault - Tenjin Help Center","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\/ja\/docs\/business-intelligence-tools\/","og_locale":"ja_JP","og_type":"article","og_title":"BI Tools - Querying DataVault - Tenjin Help Center","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\/ja\/docs\/business-intelligence-tools\/","og_site_name":"Tenjin","article_modified_time":"2026-03-13T17:15:56+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":{"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"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":"mariusz.bijok","@id":"https:\/\/tenjin.com\/#\/schema\/person\/2df6a56c45e0493e93ec6d7100750b77"},"headline":"Business Intelligence Tools","datePublished":"2026-02-20T07:06:10+00:00","dateModified":"2026-03-13T17:15:56+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":"ja"},{"@type":"WebPage","@id":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/","url":"https:\/\/tenjin.com\/docs\/business-intelligence-tools\/","name":"BI Tools - Querying DataVault - Tenjin Help Center","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-03-13T17:15:56+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":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tenjin.com\/docs\/business-intelligence-tools\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@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":"ja"},{"@type":"Organization","@id":"https:\/\/tenjin.com\/#organization","name":"Tenjin","url":"https:\/\/tenjin.com\/","logo":{"@type":"ImageObject","inLanguage":"ja","@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\/2df6a56c45e0493e93ec6d7100750b77","name":"mariusz.bijok","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/tenjin.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ed77b923271ae0c54cf6cc2b3d031d191c17791d92b8a5f5d186753477fbbdb9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed77b923271ae0c54cf6cc2b3d031d191c17791d92b8a5f5d186753477fbbdb9?s=96&d=mm&r=g","caption":"mariusz.bijok"},"url":"https:\/\/tenjin.com\/ja\/blog\/author\/mariusz-bijok\/"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/docs\/15443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/comments?post=15443"}],"version-history":[{"count":4,"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/docs\/15443\/revisions"}],"predecessor-version":[{"id":16564,"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/docs\/15443\/revisions\/16564"}],"wp:attachment":[{"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/media?parent=15443"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/doc_category?post=15443"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/glossaries?post=15443"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/tenjin.com\/ja\/wp-json\/wp\/v2\/doc_tag?post=15443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}