{"id":4149,"date":"2023-07-02T13:06:00","date_gmt":"2023-07-02T04:06:00","guid":{"rendered":"https:\/\/memotarou.bulog.jp\/?p=4149"},"modified":"2023-07-02T12:25:45","modified_gmt":"2023-07-02T03:25:45","slug":"data-analysis-powerbi-q022","status":"publish","type":"post","link":"https:\/\/memotarou.bulog.jp\/?p=4149","title":{"rendered":"\u3010PowerBI\u3011Q-022"},"content":{"rendered":"<h2>\u554f\u984c<\/h2>\n<div align=\"center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q022.jpg\" alt=\"\" width=\"600\" height=\"600\" class=\"alignnone size-full wp-image-4151\" srcset=\"https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q022.jpg 600w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q022-300x300.jpg 300w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q022-150x150.jpg 150w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q022-75x75.jpg 75w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q022-100x100.jpg 100w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q022-530x530.jpg 530w, https:\/\/memotarou.bulog.jp\/wp\/wp-content\/uploads\/2023\/07\/data-analysis-powerbi-q022-565x565.jpg 565w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/div>\n<h3>\u554f\u984c.022<\/h3>\n<p>SQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u7528\u3059\u308bPowerBI\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059SELECT\u3002SQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306fSQLServer\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u30af\u30a8\u30ea\u3057\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n<p>\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u304b\u3089PowerBI\u306b\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u5f8c\u3001\u7d50\u679c\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u306e\u5217\u306e1\u3064\u304c\u7a7a\u767d\u306b\u8868\u793a\u3055\u308c\u308b\u3053\u3068\u306b\u6c17\u4ed8\u304d\u307e\u3059\u3002\u30bd\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<p>\u554f\u984c\u3092\u89e3\u6c7a\u3059\u308b\u306b\u306f\u3069\u3046\u3059\u308c\u3070\u3088\u3044\u3067\u3059\u304b?<\/p>\n<p><H3>\u9078\u629e\u9805\u76ee\uff08\uff11\u3064\uff09<\/H3><\/p>\n<p><input type=\"radio\" id=\"radio1\" name=\"radio1\" value=\"radio1\" \/> CASTSQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u5185\u3067\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<p><input type=\"radio\" id=\"radio1\" name=\"radio1\" value=\"radio1\" \/> DATALENGTHSQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u5185\u3067\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<p><input type=\"radio\" id=\"radio1\" name=\"radio1\" value=\"radio1\" \/> \u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u306e\u30d7\u30e9\u30a4\u30d0\u30b7\u30fc \u30ec\u30d9\u30eb\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<p><input type=\"radio\" id=\"radio1\" name=\"radio1\" value=\"radio1\" \/> Power BI \u306e\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u306b\u5bfe\u3059\u308b\u30a2\u30af\u30bb\u30b9\u8a31\u53ef\u3092\u30af\u30ea\u30a2\u3057\u307e\u3059\u3002<br \/>\n&nbsp;<\/p>\n<hr \/>\n<p>&nbsp;<br \/>\n<div id=\"rinkerid3910\" class=\"yyi-rinker-contents  yyi-rinker-postid-3910 yyi-rinker-img-m yyi-rinker-catid-127 \">\n\t<div class=\"yyi-rinker-box\">\n\t\t<div class=\"yyi-rinker-image\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/B07N8NVYLV?tag=jackal13-22&#038;linkCode=ogi&#038;th=1&#038;psc=1\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/m.media-amazon.com\/images\/I\/41xV98eK10L._SL160_.jpg\" width=\"112\" height=\"160\" class=\"yyi-rinker-main-img\" style=\"border: none;\"><\/a>\t\t\t\t\t<\/div>\n\t\t<div class=\"yyi-rinker-info\">\n\t\t\t<div class=\"yyi-rinker-title\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/B07N8NVYLV?tag=jackal13-22&#038;linkCode=ogi&#038;th=1&#038;psc=1\" rel=\"nofollow\">\u30d6\u30e9\u30c3\u30af\u4f01\u696d\u306e\u793e\u54e1\u304c\u732b\u306b\u306a\u3063\u3066\u4eba\u751f\u304c\u5909\u308f\u3063\u305f\u8a71\u3000\u30e2\u30d5\u7530\u304f\u3093\u306e\u5834\u5408 (\u30b3\u30df\u30c3\u30af\u30a8\u30c3\u30bb\u30a4)<\/a>\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"yyi-rinker-detail\">\n\t\t\t\t\t\t\t<div class=\"credit-box\">created by&nbsp;<a href=\"https:\/\/oyakosodate.com\/rinker\/\" rel=\"nofollow noopener\" target=\"_blank\" >Rinker<\/a><\/div>\n\t\t\t\t\t\t\t\t\t\t<div class=\"price-box\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<ul class=\"yyi-rinker-links\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"amazonkindlelink\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/B07N8NVYLV?tag=jackal13-22&amp;linkCode=ogi&amp;th=1&amp;psc=1\" rel=\"nofollow\" class=\"yyi-rinker-link\">Kindle<\/a>\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t                    <li class=\"amazonlink\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/B07N8NVYLV?tag=jackal13-22&amp;linkCode=ogi&amp;th=1&amp;psc=1\" rel=\"nofollow\" class=\"yyi-rinker-link\">Amazon<\/a>\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"rakutenlink\">\n\t\t\t\t\t\t<a href=\"https:\/\/hb.afl.rakuten.co.jp\/hgc\/2b289990.68b764ea.2b289991.0223a3f8\/Rinker_o_20230604164806?pc=https%3A%2F%2Fsearch.rakuten.co.jp%2Fsearch%2Fmall%2F%25E3%2583%2596%25E3%2583%25A9%25E3%2583%2583%25E3%2582%25AF%25E4%25BC%2581%25E6%25A5%25AD%25E3%2581%25AE%25E7%25A4%25BE%25E5%2593%25A1%25E3%2581%258C%25E7%258C%25AB%25E3%2581%25AB%25E3%2581%25AA%25E3%2581%25A3%25E3%2581%25A6%2F%3Ff%3D1%26grp%3Dproduct&amp;m=https%3A%2F%2Fsearch.rakuten.co.jp%2Fsearch%2Fmall%2F%25E3%2583%2596%25E3%2583%25A9%25E3%2583%2583%25E3%2582%25AF%25E4%25BC%2581%25E6%25A5%25AD%25E3%2581%25AE%25E7%25A4%25BE%25E5%2593%25A1%25E3%2581%258C%25E7%258C%25AB%25E3%2581%25AB%25E3%2581%25AA%25E3%2581%25A3%25E3%2581%25A6%2F%3Ff%3D1%26grp%3Dproduct\" rel=\"nofollow\" class=\"yyi-rinker-link\">\u697d\u5929\u5e02\u5834<\/a>\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"yahoolink\">\n\t\t\t\t\t\t<a href=\"https:\/\/ck.jp.ap.valuecommerce.com\/servlet\/referral?sid=2742314&amp;pid=887951409&amp;vc_url=https%3A%2F%2Fshopping.yahoo.co.jp%2Fsearch%3Fp%3D%25E3%2583%2596%25E3%2583%25A9%25E3%2583%2583%25E3%2582%25AF%25E4%25BC%2581%25E6%25A5%25AD%25E3%2581%25AE%25E7%25A4%25BE%25E5%2593%25A1%25E3%2581%258C%25E7%258C%25AB%25E3%2581%25AB%25E3%2581%25AA%25E3%2581%25A3%25E3%2581%25A6\" rel=\"nofollow\" class=\"yyi-rinker-link\">Yahoo\u30b7\u30e7\u30c3\u30d4\u30f3\u30b0<\/a><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ad.jp.ap.valuecommerce.com\/servlet\/gifbanner?sid=2742314&pid=887951409\" height=\"1\" width=\"1\" border=\"0\">\t\t\t\t\t<\/li>\n\t\t\t\t                \t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n<br \/>\n&nbsp;<\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<p><H3>\u6b63\u89e3<\/H3><\/p>\n<p>CASTSQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u5185\u3067\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<br \/>\n&nbsp;<\/p>\n<p><H4>\u56de\u7b54\u306e\u88dc\u8db3\u8aac\u660e<\/H4><\/p>\n<p>\u3053\u306e\u554f\u984c\u306f\u3001PowerBI\u304c\u30bd\u30fc\u30b9\u5217\u3067\u4f7f\u7528\u3055\u308c\u308b\u30c7\u30fc\u30bf\u578b\u3092\u8aa4\u3063\u3066\u89e3\u91c8\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u3092\u89e3\u6c7a\u3059\u308b\u306b\u306f\u3001\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u76ee\u7684\u306e\u30c7\u30fc\u30bf\u578b\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059CAST\u3002DATALENGTH\u5f0f\u3092\u8868\u3059\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u30d0\u30a4\u30c8\u6570\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<p>\u30a2\u30af\u30bb\u30b9\u8a31\u53ef\u3092\u30af\u30ea\u30a2\u3059\u308b\u3068\u3001PowerBI\u304c\u30bf\u30fc\u30b2\u30c3\u30c8\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u304f\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u30d7\u30e9\u30a4\u30d0\u30b7\u30fc\u30ec\u30d9\u30eb\u3092\u8a2d\u5b9a\u3057\u3066\u3082\u3001\u30c7\u30fc\u30bf\u6b20\u843d\u306e\u554f\u984c\u3078\u306e\u5bfe\u51e6\u306b\u306f\u5f71\u97ff\u3057\u307e\u305b\u3093\u3002<br \/>\n&nbsp;<\/p>\n<h3>\u6b21\u306e\u554f\u984c<\/h3>\n<p><a href=\"https:\/\/memotarou.bulog.jp\/?p=4154\" data-blogcard=\"1\">\u3010PowerBI\u3011Q-023<\/a><\/p>\n<h3>\u8cc7\u683c\u53d6\u5f97<\/h3>\n<p><a href=\"https:\/\/memotarou.bulog.jp\/?p=3760\" data-blogcard=\"1\">PowerBI\u306e\u8cc7\u683c\u53d6\u5f97<\/a><\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>\u554f\u984c \u554f\u984c.022 SQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u7528\u3059\u308bPowerBI\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059SELECT\u3002SQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306fSQLServer\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u30af\u30a8\u30ea\u3057\u3001\u30b5\u30d6\u30af\u30a8\u30ea\u304c\u542b\u307e\u308c\u307e\u3059\u3002 \u30c7\u30fc\u30bf\u30bd\u30fc [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4151,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[127],"tags":[],"class_list":["post-4149","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-127"],"_links":{"self":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/4149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4149"}],"version-history":[{"count":2,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/4149\/revisions"}],"predecessor-version":[{"id":4158,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/posts\/4149\/revisions\/4158"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=\/wp\/v2\/media\/4151"}],"wp:attachment":[{"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/memotarou.bulog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}