{"id":7949,"date":"2020-01-07T21:48:55","date_gmt":"2020-01-08T05:48:55","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=7949"},"modified":"2025-06-13T17:21:51","modified_gmt":"2025-06-14T00:21:51","slug":"simple-dataviz-with-n1ql-and-google-sheets","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/simple-dataviz-with-n1ql-and-google-sheets\/","title":{"rendered":"Visualiza\u00e7\u00e3o de dados simples com N1QL e Google Sheets."},"content":{"rendered":"

Fa\u00e7a o que for necess\u00e1rio para apresentar os dados de modo a ajudar na an\u00e1lise e no racioc\u00ednio. - Edward Tufte<\/p><\/blockquote>\n

Como criar gr\u00e1ficos como esses se voc\u00ea ainda n\u00e3o tem uma ferramenta de visualiza\u00e7\u00e3o de dados pronta e bacana?<\/p>\n

\"\"<\/a><\/p>\n

Voc\u00ea pode executar consultas para manipular os dados e obter os resultados. Muitas vezes, voc\u00ea deseja apresentar os dados visualmente em gr\u00e1ficos de pizza, gr\u00e1ficos de bolhas, histogramas e gr\u00e1ficos de linha. Se voc\u00ea tiver o Tableau, o Cognos, etc., ser\u00e1 mais f\u00e1cil visualizar. Caso contr\u00e1rio, voc\u00ea ter\u00e1 que copiar os resultados no Google Sheets ou no Excel. Recortar e colar os resultados no Google Sheets \u00e9 dif\u00edcil, devido \u00e0 formata\u00e7\u00e3o, problemas de linhas de cabe\u00e7alho etc. No entanto, o Couchbase Query Workbench facilita isso. Ao lado dos resultados da consulta, temos um c\u00f3pia<\/strong> que copia o resultado em um formato tabular que pode ser colado em planilhas como o Google Sheets, Excel etc. Esse recurso est\u00e1 dispon\u00edvel no workbench de consulta e no workbench de consulta anal\u00edtica.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Vamos dar uma olhada em alguns dados e gr\u00e1ficos de amostra.<\/p>\n

    \n
  1. Calcule os tipos de documentos e sua contagem.<\/li>\n<\/ol>\n

    Aqui est\u00e1 a consulta sobre o conjunto de dados de amostra de viagem fornecido com o Couchbase. Clique na imagem para ver a anima\u00e7\u00e3o em GIF.<\/p>\n

    SELECT type,\r\n       COUNT(1) typecount\r\nFROM `travel-sample`\r\nGROUP BY type\r\nORDER BY typecount<\/pre>\n
    type\t   typecount\r\n\"airline\"       187\r\n\"hotel\"\t        917\r\n\"airport\"      1968\r\n\"landmark\"     4495\r\n\"route\"       24024\r\n<\/pre>\n
    Aqui est\u00e1 o gr\u00e1fico de pizza criado para os dados. Ele pode ser facilmente personalizado em termos de cores, exibi\u00e7\u00e3o de dados, v\u00e1rios r\u00f3tulos e legendas.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    Clique na imagem para ver a anima\u00e7\u00e3o GIF sobre como obter os resultados no Google Sheets para obter os gr\u00e1ficos em um segundo.\"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    2. Tarefa:  Encontrar as 10 principais cidades com o maior n\u00famero de hot\u00e9is.<\/p>\n
    SELECT country,\r\n       city,\r\n       COUNT(1) hotelcount\r\nFROM `travel-sample`\r\nWHERE type = 'hotel'\r\nGROUP BY country,\r\n         city\r\nORDER BY hotelcount DESC\r\nLIMIT 10<\/pre>\n
    Resultados:<\/p>\n
    city                country        hotelcount\r\n\"San Francisco\" \"United States\"      132\r\n\"London\"        \"United Kingdom\"      67\r\n\"Paris\"         \"France\"              64\r\n\"San Diego\"     \"United States\"       48\r\n\"Birmingham\"    \"United Kingdom\"      36\r\n\"Los Angeles\"   \"United States\"       35\r\n                \"United Kingdom\"      23\r\n\"Santa Monica\"  \"United States\"       14\r\n\"Malibu\"        \"United States\"       12\r\n\"Edinburgh\"     \"United Kingdom\"      10\r\n<\/pre>\n
    A \u00fanica personaliza\u00e7\u00e3o do histograma aqui \u00e9 adicionar os r\u00f3tulos de dados para mostrar o n\u00famero real de hot\u00e9is.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    2. Tarefa:  Encontrar as 5 principais cidades com o maior n\u00famero de hot\u00e9is com \"jardins\" na avalia\u00e7\u00e3o<\/p>\n
    SELECT city,\r\n       COUNT(1) hotelcount\r\nFROM `travel-sample`\r\nWHERE type = 'hotel'\r\n    AND ANY r IN reviews SATISFIES search(r.content, \"garden\") END\r\nGROUP BY city\r\nORDER BY hotelcount DESC\r\nLIMIT 5;<\/pre>\n
    city\t    hotelcount\r\n\"Paris\"\t       10\r\n\t        5\r\n\"San Francisco\"\t5\r\n\"San Diego\"\t4\r\n\"Edinburgh\"\t3\r\n<\/pre>\n
    Basta escolher o \"Doughnut piechart\" e adicionar os r\u00f3tulos.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    6. Os gr\u00e1ficos de bolhas exigem que voc\u00ea crie o valor percentual para cada linha. A fun\u00e7\u00e3o de janela RATIO_TO_REPORT()<\/a> ajudam voc\u00ea a fazer isso facilmente.  Quando voc\u00ea tiver sua consulta, crie uma bolha<\/p>\n
    SELECT country, city, \r\n       SUM(ARRAY_SUM(reviews[*].ratings[*].Location)) \/ COUNT(1) city_avglocation,\r\n       SUM(ARRAY_SUM(reviews[*].ratings[*].Service)) \/ COUNT(1) city_avgservice,\r\n       RATIO_TO_REPORT(COUNT(1)) OVER(partition by country) * 100 ratio_val,\r\n       (TO_STR(ROUND(RATIO_TO_REPORT(COUNT(1)) OVER(partition by country) * 100, 0)) || \"%\" ) AS ratio_percent \r\nFROM `travel-sample`\r\nWHERE type = 'hotel'\r\ngroup by country, city\r\norder by ratio_val desc, city_avgservice desc, city_avgvalue desc\r\nLIMIT 10<\/pre>\n
    city           city_avglocation    city_avgservice\tcountry\tratio_percent\tratio_val\r\n\"Paris\"           13.75\t15.421875\t\"France\"\t\"46%\"\t45.714285714285715\r\n\"San Francisco\"\t15.583333333333334\t16.71969696969697\t\"United States\"\t\"37%\"\t36.56509695290859\r\n\"London\"\t11.567164179104477\t15.746268656716419\t\"United Kingdom\"\t\"16%\"\t16.105769230769234\r\n\"San Diego\"\t15.583333333333334\t16.729166666666668\t\"United States\"\t\"13%\"\t13.29639889196676\r\n\"Los Angeles\"\t11.971428571428572\t12.628571428571428\t\"United States\"\t\"10%\"\t9.695290858725762\r\n\"Birmingham\"\t14.666666666666666\t18.083333333333332\t\"United Kingdom\"\t\"9%\"\t8.653846153846153\r\n\"Avignon\"\t10.375\t13.375\t\"France\"\t\"6%\"\t5.714285714285714\r\n\t16.91304347826087\t17.782608695652176\t\"United Kingdom\"\t\"6%\"\t5.528846153846153\r\n\"Chamonix-Mont-Blanc\"\t18\t29.142857142857142\t\"France\"\t\"5%\"\t5\r\n\"Nice\"\t11.571428571428571\t15\t\"France\"\t\"5%\"\t5\r\n<\/pre>\n
    \"\"<\/a>
    Gr\u00e1fico de bolhas mostrando a classifica\u00e7\u00e3o m\u00e9dia por local, etc. O tamanho da bolha mostra o n\u00famero de hot\u00e9is representados no respectivo pa\u00eds.<\/p><\/div>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    Este GIF animado mostra como criar esse gr\u00e1fico.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    7. Criar gr\u00e1ficos geogr\u00e1ficos \u00e9 muito f\u00e1cil no Google Charts, pois ele reconhece os pa\u00edses e as cidades. Voc\u00ea n\u00e3o precisa lidar com latlongs.<\/p>\n
    Select country, count(1) num_hotels\r\nfrom `travel-sample`\r\nwhere type = 'airline'<\/pre>\n
    country\t          num_hotels\r\n\"United States\"\t    127\r\n\"United Kingdom\"     39\r\n\"France\"\t     21\r\n<\/pre>\n
    Com os dados acima, basta colar em uma planilha do Google e criar um gr\u00e1fico geogr\u00e1fico.\u00a0
    \n\"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    8. Voc\u00ea tamb\u00e9m pode criar um gr\u00e1fico geogr\u00e1fico com marcadores (bolhas proporcionais), novamente, usando as fun\u00e7\u00f5es da janela RATIO_TO_REPORT().<\/p>\n
    SELECT country,\r\n       COUNT(1) AS num_hotels,\r\n       (TOSTR(ROUND(RATIO_TO_REPORT(COUNT(1)) OVER () * 100,0)) || \"%\") AS hotels_percent \r\nFROM `travel-sample`\r\nWHERE type = 'hotel'\r\nGROUP BY country;<\/pre>\n
    country           hotels_percent      num_hotels\r\n\"United Kingdom\"  \"45%\"                 416\r\n\"France\"          \"15%\"\t                140\r\n\"United States\"   \"39%\"                 361\r\n<\/pre>\n
    \"\"<\/a><\/p>\n
    Voc\u00ea tamb\u00e9m pode personalizar os gr\u00e1ficos de acordo com a regi\u00e3o, por exemplo, os Estados Unidos.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    Por fim, a consulta para gerar o primeiro gr\u00e1fico deste blog:<\/p>\n
    SELECT country, city,\r\n       SUM(ARRAY_SUM(reviews[*].ratings[*].Location)) \/ COUNT(1) city_avglocation,\r\n       SUM(ARRAY_SUM(reviews[*].ratings[*].Service)) \/ COUNT(1) city_avgservice,\r\n       SUM(ARRAY_SUM(reviews[*].ratings[*].Overall)) \/ COUNT(1) city_avgoverall,\r\n       SUM(ARRAY_SUM(reviews[*].ratings[*].Rooms)) \/ COUNT(1) city_avgrooms,\r\n       SUM(ARRAY_SUM(reviews[*].ratings[*].`Value`)) \/ COUNT(1) city_avgvalue\r\nFROM `travel-sample`\r\nWHERE type = 'hotel'\r\ngroup by country, city\r\norder by city_avgservice desc, city_avgvalue desc\r\nLIMIT 50<\/pre>\n
     <\/p>","protected":false},"excerpt":{"rendered":"
    Do whatever it takes to present the data to aid analysis and thinking.\u00a0 — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the […]<\/p>","protected":false},"author":55,"featured_media":8034,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[2294,1812],"tags":[1261],"ppma_author":[8929],"class_list":["post-7949","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-n1ql-query","tag-json"],"acf":[],"yoast_head":"\nSimple dataviz with N1QL and Google Sheets. - The Couchbase Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/pt\/simple-dataviz-with-n1ql-and-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simple dataviz with N1QL and Google Sheets.\" \/>\n<meta property=\"og:description\" content=\"Do whatever it takes to present the data to aid analysis and thinking.\u00a0 — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/simple-dataviz-with-n1ql-and-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-08T05:48:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:21:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1844\" \/>\n\t<meta property=\"og:image:height\" content=\"928\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Keshav Murthy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rkeshavmurthy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keshav Murthy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/\"},\"author\":{\"name\":\"Keshav Murthy\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\"},\"headline\":\"Simple dataviz with N1QL and Google Sheets.\",\"datePublished\":\"2020-01-08T05:48:55+00:00\",\"dateModified\":\"2025-06-14T00:21:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/\"},\"wordCount\":515,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png\",\"keywords\":[\"JSON\"],\"articleSection\":[\"Couchbase Analytics\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/\",\"name\":\"Simple dataviz with N1QL and Google Sheets. - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png\",\"datePublished\":\"2020-01-08T05:48:55+00:00\",\"dateModified\":\"2025-06-14T00:21:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png\",\"width\":1844,\"height\":928},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simple dataviz with N1QL and Google Sheets.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\",\"name\":\"Keshav Murthy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"caption\":\"Keshav Murthy\"},\"description\":\"Keshav Murthy is a Vice President at Couchbase R&D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design & development. He lead the SQL and NoSQL R&D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India, holds eleven US patents and has four US patents pending.\",\"sameAs\":[\"https:\/\/blog.planetnosql.com\/\",\"https:\/\/x.com\/rkeshavmurthy\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/pt\/author\/keshav-murthy\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Simple dataviz with N1QL and Google Sheets. - The Couchbase Blog","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:\/\/www.couchbase.com\/blog\/pt\/simple-dataviz-with-n1ql-and-google-sheets\/","og_locale":"pt_BR","og_type":"article","og_title":"Simple dataviz with N1QL and Google Sheets.","og_description":"Do whatever it takes to present the data to aid analysis and thinking.\u00a0 — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the […]","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/simple-dataviz-with-n1ql-and-google-sheets\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-01-08T05:48:55+00:00","article_modified_time":"2025-06-14T00:21:51+00:00","og_image":[{"width":1844,"height":928,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png","type":"image\/png"}],"author":"Keshav Murthy","twitter_card":"summary_large_image","twitter_creator":"@rkeshavmurthy","twitter_misc":{"Written by":"Keshav Murthy","Est. reading time":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/"},"author":{"name":"Keshav Murthy","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636"},"headline":"Simple dataviz with N1QL and Google Sheets.","datePublished":"2020-01-08T05:48:55+00:00","dateModified":"2025-06-14T00:21:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/"},"wordCount":515,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png","keywords":["JSON"],"articleSection":["Couchbase Analytics","SQL++ \/ N1QL Query"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/","url":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/","name":"Simple dataviz with N1QL and Google Sheets. - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png","datePublished":"2020-01-08T05:48:55+00:00","dateModified":"2025-06-14T00:21:51+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-05-at-7.21.07-PM.png","width":1844,"height":928},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Simple dataviz with N1QL and Google Sheets."}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"Blog do Couchbase","description":"Couchbase, o banco de dados NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"Blog do Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636","name":"Keshav Murthy","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4","url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","caption":"Keshav Murthy"},"description":"Keshav Murthy \u00e9 vice-presidente de P&D da Couchbase. Anteriormente, ele trabalhou na MapR, IBM, Informix e Sybase, com mais de 20 anos de experi\u00eancia em design e desenvolvimento de bancos de dados. Ele liderou a equipe de P&D de SQL e NoSQL na IBM Informix. Ele recebeu dois pr\u00eamios President's Club na Couchbase e dois Outstanding Technical Achievement Awards na IBM. Keshav \u00e9 bacharel em Ci\u00eancia da Computa\u00e7\u00e3o e Engenharia pela Universidade de Mysore, \u00cdndia, det\u00e9m onze patentes nos EUA e tem quatro patentes pendentes nos EUA.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/keshav-murthy\/"}]}},"authors":[{"term_id":8929,"user_id":55,"is_guest":0,"slug":"keshav-murthy","display_name":"Keshav Murthy","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","author_category":"","last_name":"Murthy","first_name":"Keshav","job_title":"","user_url":"https:\/\/blog.planetnosql.com\/","description":"Keshav Murthy \u00e9 vice-presidente de P&D da Couchbase. Anteriormente, ele trabalhou na MapR, IBM, Informix e Sybase, com mais de 20 anos de experi\u00eancia em design e desenvolvimento de bancos de dados. Ele liderou a equipe de P&D de SQL e NoSQL na IBM Informix. Recebeu dois pr\u00eamios President's Club na Couchbase e dois Outstanding Technical Achievement Awards na IBM. Keshav \u00e9 bacharel em Ci\u00eancia da Computa\u00e7\u00e3o e Engenharia pela Universidade de Mysore, \u00cdndia, det\u00e9m dez patentes nos EUA e tem tr\u00eas patentes pendentes nos EUA."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/7949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=7949"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/7949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/8034"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=7949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=7949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=7949"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=7949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}