{"id":5685,"date":"2019-02-18T16:26:59","date_gmt":"2019-02-18T09:26:59","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/phan-tich-khoi-du-lieu-lon-voi-bigquery-va-google-sheets\/"},"modified":"2023-05-22T13:56:55","modified_gmt":"2023-05-22T06:56:55","slug":"phan-tich-khoi-du-lieu-lon-voi-bigquery-va-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/phan-tich-khoi-du-lieu-lon-voi-bigquery-va-google-sheets\/","title":{"rendered":"Analyze Big Data with BigQuery and Google Sheets"},"content":{"rendered":"<p style=\"text-align: justify;\"><b>What\u2019s new:<\/b><span style=\"font-weight: 400;\"> Google has connected Sheets and <a href=\"https:\/\/gcloudvn.com\/en\/bigquery\/\">BigQuery<\/a> to make data analysis and sharing easier. BigQuery Data Linker will help you<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Collaborate with colleagues and partners on the familiar spreadsheet interface<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ensure data is only taken from one unified source, users do not need to extract multiple CSV files<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Streamline the reporting process and synthesize and analyze data<\/span><\/li>\n<\/ul>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/phan-tich-khoi-du-lieu-lon-voi-bigquery-va-google-sheets\/#Ai_chiu_anh_huong\" >Who is affected?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/phan-tich-khoi-du-lieu-lon-voi-bigquery-va-google-sheets\/#Tai_sao_ban_nen_dung_tinh_nang_nay\" >Why should you use this feature?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/phan-tich-khoi-du-lieu-lon-voi-bigquery-va-google-sheets\/#De_bat_dau_su_dung\" >To start using<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/phan-tich-khoi-du-lieu-lon-voi-bigquery-va-google-sheets\/#Cac_thong_tin_bo_sung\" >Additional details<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ai_chiu_anh_huong\"><\/span><b>Who is affected?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">End users<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tai_sao_ban_nen_dung_tinh_nang_nay\"><\/span><b>Why should you use this feature?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">From the beginning, Google built BigQuery to help users easily process and understand large volumes of data \u2013 now users, employees, and members of non-analytics teams \u2013 can access and analyze data. By combining these two tools, people can together view up to 10,000 rows of data from BigQuery easily, in a familiar interface. This feature will make collaboration and information sharing simpler, thereby allowing the team to make faster decisions.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"De_bat_dau_su_dung\"><\/span><b>To start using<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>For Admins<\/b><span style=\"font-weight: 400;\">: No need to do anything<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>For end users:<\/b><span style=\"font-weight: 400;\"> Here are the steps to take to get data from BigQuery and analyze it in Sheets:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">From Menu, select <strong>Data<\/strong> &gt; <strong>Data Connectors<\/strong> &gt; <strong>BigQuery<\/strong><\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Use our <\/span><span style=\"font-weight: 400;\">feature <strong>Explore<\/strong><\/span><\/li>\n<li style=\"font-weight: 400;\"><strong>Create Chart<\/strong><span style=\"font-weight: 400;\"> (create charts)<\/span><\/li>\n<li style=\"font-weight: 400;\"><strong>Create Pivot Tales<\/strong><span style=\"font-weight: 400;\"> (create Pivot Tables)<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">To test key access permissions to the BigQuery data joiner, you can <\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/9077536\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">see here.<\/span><\/a><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-16341 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2019\/02\/ph\u00e2n-t\u00edch-d\u1eef-li\u1ec7u-b\u1eb1ng-big-query-v\u1edbi-Google-Sheet.png\" alt=\"Analyze big data with BigQuery and Google Sheets 1\" width=\"600\" height=\"405\" \/><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_thong_tin_bo_sung\"><\/span><b>Additional details<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Anyone you share the spreadsheet with will see the data saved in the Sheet. Only those with edit rights in the Sheet and view rights in the BigQuery table will be able to refresh the data.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">As always, use shared access to control who can see, edit, and share your data.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">In the coming weeks, you&#039;ll be able to use tools like <\/span><span style=\"font-weight: 400;\">App Scripts<\/span><span style=\"font-weight: 400;\"> and features <\/span><span style=\"font-weight: 400;\">Macro recorder<\/span><span style=\"font-weight: 400;\"> to schedule automatic updates of data from BigQuery to Sheet. For example, you can automatically update sales data in a spreadsheet so that it is always fresh and ready for analysis at the beginning of business hours each day. To learn more about recording and running macros in Sheets, <\/span><\/p>\n<p style=\"text-align: justify;\">If you have any questions regarding the application or need to sign up for a free consultation to learn about its features, <strong><a href=\"https:\/\/gcloudvn.com\/en\/google-cloud-platform\/\">Google Cloud Platform<\/a><\/strong> Please contact Gimasys immediately for advice:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Email<\/strong>: <em>gsuite@gimasys.com<\/em><\/li>\n<li><strong>Sign up for a free trial<\/strong>: <strong><a href=\"https:\/\/gcloudvn.com\/en\/dang-ky-dung-thu\/\" target=\"_blank\" rel=\"nofollow noopener\">Here<\/a><\/strong><\/li>\n<li><strong>Phone number:<\/strong> Hanoi: <em>0987 682 505<\/em> - Ho Chi Minh: <em>0974 417 099<\/em><\/li>\n<\/ul>\n<p style=\"text-align: right;\"><strong>Source: Gimasys<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Google \u0111\u00e3 k\u1ebft n\u1ed1i Sheets v\u00e0 BigQuery \u0111\u1ec3 gi\u00fap vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 chia s\u1ebb d\u1eef li\u1ec7u tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n. B\u1ed9 li\u00ean k\u1ebft d\u1eef li\u1ec7u BigQuery s\u1ebd gi\u00fap b\u1ea1n c\u1ed9ng t\u00e1c v\u1edbi \u0111\u1ed3ng nghi\u1ec7p, \u0111\u1ed1i t\u00e1c tr\u00ean giao di\u1ec7n quen thu\u1ed9c c\u1ee7a spreadsheet<\/p>","protected":false},"author":1,"featured_media":5686,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5685","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=5685"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5685\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/5686"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=5685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=5685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=5685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}