{"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\/es\/simple-dataviz-with-n1ql-and-google-sheets\/","title":{"rendered":"Simple dataviz con N1QL y Google Sheets."},"content":{"rendered":"

Haz lo que sea necesario para presentar los datos y facilitar el an\u00e1lisis y la reflexi\u00f3n. - Edward Tufte<\/p><\/blockquote>\n

\u00bfC\u00f3mo se crean gr\u00e1ficos de este tipo si no se dispone de una herramienta de visualizaci\u00f3n de datos?<\/p>\n

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

Puede ejecutar consultas para manejar los datos y obtener los resultados. A menudo se desea presentar los datos visualmente en gr\u00e1ficos circulares, gr\u00e1ficos de burbujas, histogramas y gr\u00e1ficos de l\u00edneas. Si tienes Tableau, Cognos, etc., es m\u00e1s f\u00e1cil visualizarlos. Si no, tendr\u00e1s que copiar los resultados en google sheets o excel. Cortar y pegar los resultados a google sheets es dif\u00edcil, debido a problemas de formato, encabezado de filas, etc. Sin embargo, Couchbase Query Workbench lo hace f\u00e1cil. Junto a los resultados de la consulta, tenemos un copia<\/strong> que copia el resultado en un formato tabular que puede pegar en hojas de c\u00e1lculo como Google Sheets, Excel, etc. Esta funci\u00f3n est\u00e1 disponible tanto en el banco de trabajo de consultas como en el banco de trabajo de consultas anal\u00edticas.<\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Veamos algunos datos y gr\u00e1ficos de ejemplo.<\/p>\n

    \n
  1. Calcular los tipos de documentos y su recuento.<\/li>\n<\/ol>\n

    Esta es la consulta sobre el conjunto de datos travel-sample suministrado con Couchbase. Haz clic en la imagen para ver la animaci\u00f3n 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
    Este es el gr\u00e1fico de sectores creado para los datos. Puede personalizarse f\u00e1cilmente en cuanto a colores, visualizaci\u00f3n de datos, etiquetas y leyendas.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    Haz clic en la imagen para ver la animaci\u00f3n GIF sobre c\u00f3mo llevar los resultados a google sheets para obtener los gr\u00e1ficos en un segundo.\"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    2. Tarea:  Encontrar las 10 ciudades con mayor n\u00famero de hoteles.<\/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
    La \u00fanica personalizaci\u00f3n del histograma consiste en a\u00f1adir las etiquetas de datos para mostrar el n\u00famero real de hoteles.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    2. Tarea:  Encontrar las 5 ciudades con mayor n\u00famero de hoteles con \"jardines\" en la rese\u00f1a.<\/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 con elegir el \"gr\u00e1fico de rosquillas\" y a\u00f1adir las etiquetas.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    6. Los gr\u00e1ficos de burbujas requieren que cree el valor porcentual de cada fila. La funci\u00f3n de ventana RATIO_TO_REPORT()<\/a> te ayudar\u00e1n a hacerlo f\u00e1cilmente.  Una vez que tengas tu consulta, crear una burbuja<\/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 burbujas que muestra la valoraci\u00f3n media por ubicaci\u00f3n, etc. El tama\u00f1o de la burbuja muestra el %ge de hoteles representados dentro del pa\u00eds respectivo.<\/p><\/div>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    Este GIF animado muestra c\u00f3mo crear este gr\u00e1fico.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    7. La creaci\u00f3n de gr\u00e1ficos geogr\u00e1ficos es bastante f\u00e1cil en google charts, ya que reconoce los pa\u00edses y las ciudades. No es necesario tratar con 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
    Con los datos anteriores, basta con pegarlos en una hoja de Google y crear un gr\u00e1fico geogr\u00e1fico.\u00a0
    \n\"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    8. Tambi\u00e9n puede crear un geo gr\u00e1fico con marcadores (burbujas proporcionales), de nuevo, utilizando las funciones de ventana 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
    Tambi\u00e9n puede personalizar los gr\u00e1ficos seg\u00fan la regi\u00f3n, por ejemplo, Estados Unidos.<\/p>\n
    \"\"<\/a><\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n
    Por \u00faltimo, la consulta para generar el primer gr\u00e1fico de este 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\/es\/simple-dataviz-with-n1ql-and-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\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\/es\/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\":\"es\",\"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\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\":\"es\",\"@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\/es\/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\/es\/simple-dataviz-with-n1ql-and-google-sheets\/","og_locale":"es_MX","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\/es\/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":"es","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":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/simple-dataviz-with-n1ql-and-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"es","@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":"El blog de Couchbase","description":"Couchbase, la base de datos 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":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@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":"es","@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 es Vicepresidente de Couchbase R&D. Anteriormente, estuvo en MapR, IBM, Informix, Sybase, con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o y desarrollo de bases de datos. Dirigi\u00f3 el equipo de I+D de SQL y NoSQL en IBM Informix. Ha recibido dos premios President's Club en Couchbase y dos premios Outstanding Technical Achievement en IBM. Keshav es licenciado en Inform\u00e1tica e Ingenier\u00eda por la Universidad de Mysore (India), es titular de once patentes estadounidenses y tiene cuatro pendientes.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/es\/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 es Vicepresidente de Couchbase R&D. Anteriormente, estuvo en MapR, IBM, Informix, Sybase, con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o y desarrollo de bases de datos. Dirigi\u00f3 el equipo de I+D de SQL y NoSQL en IBM Informix. Ha recibido dos premios President's Club en Couchbase y dos premios Outstanding Technical Achievement en IBM. Keshav es licenciado en Inform\u00e1tica e Ingenier\u00eda por la Universidad de Mysore (India), es titular de diez patentes estadounidenses y tiene tres pendientes."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/7949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=7949"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/7949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/8034"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=7949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=7949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=7949"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=7949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}