{"id":2497,"date":"2017-01-18T10:07:24","date_gmt":"2017-01-18T10:07:23","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2497"},"modified":"2025-10-09T07:26:22","modified_gmt":"2025-10-09T14:26:22","slug":"taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/","title":{"rendered":"An\u00e1lise de corrida de t\u00e1xi - An\u00e1lise nativa no Couchbase com gr\u00e1ficos do Cloud9"},"content":{"rendered":"<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;font-style: italic;vertical-align: baseline\">Esta \u00e9 uma postagem de convidado de Jay Gopalakrishnan. Jay \u00e9 o fundador da <\/span><a style=\"text-decoration: none\" href=\"https:\/\/www.cloud9charts.com\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;font-style: italic;text-decoration: underline;vertical-align: baseline\">Gr\u00e1ficos da Cloud9<\/span><\/a><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;font-style: italic;vertical-align: baseline\">A empresa oferece uma plataforma de an\u00e1lise criada para arquiteturas de dados modernas, com suporte nativo para Couchbase e N1QL. Siga-os no Twitter <\/span><a style=\"text-decoration: none\" href=\"https:\/\/twitter.com\/cloud9charts\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;font-style: italic;text-decoration: underline;vertical-align: baseline\">@cloud9charts<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Esta postagem usa o conjunto de dados de t\u00e1xis verdes de Nova York no Couchbase para demonstrar a an\u00e1lise nativa usando N1QL e Cloud9 Charts. <\/span><\/p>\n<h2 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 18pt;margin-bottom: 6pt\"><span style=\"font-size: 21.333333333333332px;font-family: Arial;color: #000000;background-color: transparent;font-weight: 400;vertical-align: baseline\">An\u00e1lise de NoSQL nativa<\/span><\/h2>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Tradicionalmente, a an\u00e1lise em bancos de dados NoSQL geralmente significa uma das seguintes op\u00e7\u00f5es:<\/span><\/p>\n<ol style=\"margin-top: 0pt;margin-bottom: 0pt\">\n<li dir=\"ltr\" style=\"list-style-type: lower-alpha;font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Colocar os dados em um formato relacional usando um driver ODBC que as arquiteturas tradicionais de BI possam entender. Isso geralmente requer um driver ODBC de terceiros, uma ferramenta de BI tradicional (geralmente baseada em desktop) e esquemas definidos antecipadamente. \u00a0<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"list-style-type: lower-alpha;font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Processos de ETL para carregar dados relevantes no banco de dados relacional para an\u00e1lise. Isso exige que os esquemas sejam definidos no armazenamento de dados baseado em NoSQL e SQL e nega a flexibilidade de esquema dos bancos de dados NoSQL, como o Couchbase. Tamb\u00e9m \u00e9 necess\u00e1rio um longo tempo de espera para que qualquer altera\u00e7\u00e3o na estrutura de dados seja propagada para o armazenamento subjacente. \u00a0\u00a0<\/span><\/p>\n<\/li>\n<\/ol>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">O Native NoSQL Analytics elimina a depend\u00eancia dos drivers ODBC e dos processos de ETL, permitindo que os usu\u00e1rios comerciais e t\u00e9cnicos aproveitem ao m\u00e1ximo o banco de dados subjacente para obter insights acion\u00e1veis imediatamente. <\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Em resumo, a integra\u00e7\u00e3o do Couchbase-Cloud9 Charts apresenta os seguintes recursos:<\/span><\/p>\n<ul style=\"margin-top: 0pt;margin-bottom: 0pt;margin-left: 40px\">\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Integra\u00e7\u00e3o totalmente nativa do N1QL sem drivers\/tradutores<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Gerador de consultas N1QL do tipo apontar e clicar<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Suporte a objetos aninhados e matrizes<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Uni\u00e3o entre o Couchbase e outras fontes baseadas em SQL\/NoSQL ou API REST<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Visualiza\u00e7\u00f5es instant\u00e2neas e pain\u00e9is incorpor\u00e1veis<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">An\u00e1lises e previs\u00f5es avan\u00e7adas <\/span><\/p>\n<\/li>\n<\/ul>\n<h2 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 18pt;margin-bottom: 6pt\"><span style=\"font-size: 21.333333333333332px;font-family: Arial;color: #000000;background-color: transparent;font-weight: 400;vertical-align: baseline\">Conjunto de dados<\/span><\/h2>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">O conjunto de dados consiste em 45 milh\u00f5es de viagens de t\u00e1xi ecol\u00f3gico, disponibilizado pela <\/span><a style=\"text-decoration: none\" href=\"https:\/\/www.nyc.gov\/tlc\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">Comiss\u00e3o de T\u00e1xis e Limusines de Nova York<\/span><\/a><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">. <\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Os t\u00e1xis verdes foram lan\u00e7ados em 2013 na cidade de Nova York, voltados para viagens de t\u00e1xi nos bairros mais afastados de Nova York, tradicionalmente mal atendidos pelos t\u00e1xis amarelos. <\/span><\/p>\n<div><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh6.googleusercontent.com\/ytFgkTvqQDYr6Su_bPX0tCvS8jzVGRR1Ex-FjmTd7oPRPfkfUlFhKZ6CBqSOfceXjNLxilbAtgR_rRt7rX34fEcWyuYmhU-y8ymCN5CMTxDMjA_d9E9hShrbVFNWPZnfNyPQur9-\" width=\"509\" height=\"262\" \/><\/span><\/div>\n<div><\/div>\n<div>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">A an\u00e1lise se concentra no seguinte: <\/span><\/p>\n<ul style=\"margin-top: 0pt;margin-bottom: 0pt;margin-left: 40px\">\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">An\u00e1lise geoespacial das \u00e1reas de coleta e entrega<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Dura\u00e7\u00e3o das viagens, por hora e por dia, em todos os bairros<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">An\u00e1lise de tarifas<\/span><\/p>\n<\/li>\n<li dir=\"ltr\" style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;background-color: transparent;vertical-align: baseline\">Previs\u00f5es de viagem<\/span><\/p>\n<\/li>\n<\/ul>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">O conjunto de dados brutos em formato CSV pode ser encontrado <\/span><a style=\"text-decoration: none\" href=\"https:\/\/s3.amazonaws.com\/c9demo\/green_tripdata_all.tgz\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">aqui<\/span><\/a><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"> (2 GB compactado, 15 GB descompactado).<\/span><\/p>\n<h2 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 18pt;margin-bottom: 6pt\"><span style=\"font-size: 21.333333333333332px;font-family: Arial;color: #000000;background-color: transparent;font-weight: 400;vertical-align: baseline\">Cluster do Couchbase<\/span><\/h2>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Um cluster Couchbase de 3 n\u00f3s foi provisionado por nossos amigos da Couchbase. <\/span><a style=\"text-decoration: none\" href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.5\/cli\/cbtransfer-tool.html\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">cbtransfertool<\/span><\/a><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"> foi usado para carregar os dados no couchbase a partir de arquivos CSV. <\/span><span style=\"color: #000000;font-family: Arial;font-size: 14.666666666666666px;line-height: 1.38;background-color: transparent\">Os dados brutos t\u00eam a seguinte apar\u00eancia (truncados para fins de brevidade): <\/span><\/p>\n<pre><code class=\"language-json\">{\r\n    \"greentaxi\": {\r\n     \"Dropoff_latitude\": \"40.824813842773438\",\r\n     \"Dropoff_longitude\": \"-73.902938842773438\",\r\n     \"Ehail_fee\": \"\",\r\n     \"Extra\": 0.5,\r\n     \"Fare_amount\": 10.5,\r\n     \"Lpep_dropoff_datetime\": \"2013-12-22 02:17:35\",\r\n     \r\n           \u2026..\r\n    \r\n      \"dropoff_city\": \"New York City-Bronx\",\r\n      \"dropoff_county\": \"Bronx\",\r\n          \"pickup_city\": \"New York City-Manhattan\",\r\n      \"pickup_county\": \"New York\u201d,\r\n       \r\n    }\r\n}<\/code><\/pre>\n<h2 dir=\"ltr\" style=\"margin-top: 18pt;margin-bottom: 6pt;line-height: 1.38;color: #333333;text-align: left\"><span style=\"font-size: 21.333333333333332px;font-family: Arial;color: #000000;background-color: transparent;font-weight: 400;vertical-align: baseline\">Considera\u00e7\u00f5es sobre \u00edndices e desempenho<\/span><\/h2>\n<ul dir=\"ltr\">\n<li style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><a href=\"https:\/\/www.couchbase.com\/blog\/pt\/faster-indexing-and-query-with-memory-optimized-global-secondary-indexes-gsi\/\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">\u00cdndices secund\u00e1rios otimizados para mem\u00f3ria<\/span><\/a><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"> foram adicionados para dropoff_city, pickup_city, dropoff_city, pickup_date e dropoff_date (al\u00e9m do \u00edndice prim\u00e1rio).<\/span><\/li>\n<li style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">A <\/span><a style=\"text-decoration: none\" href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/indexes\/covering-indexes.html\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">\u00edndice de cobertura<\/span><\/a><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"> \u00a0tamb\u00e9m foi usado em clusters lat\/long:<\/span><\/li>\n<\/ul>\n<pre><code class=\"language-sql\">CREATE INDEX pickup_ latlong_idx  ON cloud9(round(to_number(Pickup_latitude),3),\r\n                                            round(to_number(Pickup_longitude),3))\r\n<\/code><\/pre>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">As agrega\u00e7\u00f5es dos dados brutos para rastrear as viagens por hora\/dia\/coleta\/entrega foram criadas em outro bucket para permitir execu\u00e7\u00f5es r\u00e1pidas de consultas:<\/span><\/p>\n<pre><code class=\"language-sql\">INSERT INTO rides_agg (KEY UUID())  \r\nSELECT \r\n   count(*) as rides, \r\n   round(avg(Fare_amount),0) as fare,\r\n   round(avg(duration),0) as duration, \r\n   day,\r\n   hour,\r\n   pickup_region,\r\n   dropoff_region\r\n   FROM \r\n   (SELECT date_part_str(millis_to_zone_name(dropoff_ts, \"EST\"),\"day_of_week\") as day,\r\n           date_part_str(millis_to_zone_name(dropoff_ts, \"EST\"),\"hour\") as hour,\r\n           pickup_region,\r\n           dropoff_region,\r\n           Fare_amount,\r\n           date_diff_millis(dropoff_ts,pickup_ts,\"minute\") as duration\r\n    FROM greentaxi \r\n    WHERE date_diff_millis(dropoff_ts,pickup_ts,\"minute\") &lt; 150\r\n   ) AS tmp\r\nGROUP BY \r\n   day,\r\n   hour,\r\n   dropoff_region,\r\n   pickup_region\r\nORDER BY day,hour<\/code><\/pre>\n<h2 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 18pt;margin-bottom: 6pt\"><span style=\"font-size: 21.333333333333332px;font-family: Arial;color: #000000;background-color: transparent;font-weight: 400;vertical-align: baseline\">An\u00e1lise<\/span><\/h2>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">O painel completo da an\u00e1lise a seguir pode ser acessado <\/span><a style=\"text-decoration: none\" href=\"https:\/\/www.cloud9charts.com\/d\/unUynISN1XWDdGsHsCE93hFQisD2WYmsQr8ipNcuOeHV0ie\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">aqui<\/span><\/a><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">. \u00c9 assim que um painel\/relat\u00f3rio gerado em tempo real pode ser compartilhado com outras pessoas.<\/span><\/p>\n<h3 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 16pt;margin-bottom: 4pt\"><span style=\"font-size: 18.666666666666664px;font-family: Arial;color: #434343;background-color: transparent;font-weight: 400;vertical-align: baseline\">An\u00e1lise de coleta e entrega:<\/span><span style=\"font-size: 18.666666666666664px;font-family: Arial;color: #434343;background-color: transparent;font-weight: 400;vertical-align: baseline\">\u00a0\u00a0 \u00a0<\/span><\/h3>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">A consulta N1QL a seguir agrupa os locais geogr\u00e1ficos de retirada, a partir dos quais uma visualiza\u00e7\u00e3o geoespacial dos locais de retirada pode ser derivada instantaneamente usando o Cloud9 Charts: <\/span><\/p>\n<pre><code class=\"language-sql\">SELECT \r\n   round(to_number(Pickup_latitude),3) as latitude, \r\n   round(to_number(Pickup_longitude),3) as longitude, \r\n   count(*) as count \r\nFROM cloud9 \r\nGROUP BY round(to_number(Pickup_latitude),3),round(to_number(Pickup_longitude),3) \r\nORDER BY count DESC\r\n<\/code><\/pre>\n<p><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh3.googleusercontent.com\/f6jiFCtYqY2XDE7Ke5Vg6HStTumHtGiT4pbfg7evoX2DobeJkq7YY6UJeFJiuOCSXPZiJRCdUbocZY4pPQO8St1LWhEPIfeVR_zjj12zTk7CPxrRa5eAJCjCSAjd4uCN7CslGQYN\" width=\"624\" height=\"592\" \/><\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Est\u00e1 vendo a zona morta dentro da \u00e1rea de Manhattan no mapa acima? Aqui est\u00e1 o motivo: Os t\u00e1xis verdes s\u00f3 podem pegar passageiros no norte da East 96th St e da West 110 St. \u00a0<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Compare isso com as coletas do t\u00e1xi amarelo abaixo, onde a maioria das coletas est\u00e1 concentrada na \u00e1rea de Manhattan. <\/span><\/p>\n<p><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh4.googleusercontent.com\/vMOvuhnFWqaYynOvf6hc5bcKjg9nec7ky87bsd89fQzZYvLbWBJLJO8Ov_WQoIqg2bupoEGg1RqOITbgn2w35gTwquHG9DKdb9TccPF1vzmIMgztUfHzH3X8CE2CA4tMrxwVC4_5\" width=\"624\" height=\"428\" \/><\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Embora as zonas de embarque sejam restritas, n\u00e3o h\u00e1 limita\u00e7\u00f5es nas \u00e1reas de desembarque de passageiros para o servi\u00e7o de t\u00e1xi verde. O mapa de calor de desembarque tem a seguinte apar\u00eancia:<\/span><\/p>\n<div><\/div>\n<div><span style=\"font-size: 10.666666666666666px;font-family: Calibri;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh3.googleusercontent.com\/yH9-NnPOkvz3CyD3krggW4sUmvllf795PNoR-0vYMXL-3CAmz0eLsHltucz34isQEGluYiCz7_Qd5wEQ-01quH7naaygbPTrbbS5t4P71jJ3JEt9XYlSdW0bpAMmPCR3iVVBy5kI\" width=\"624\" height=\"597\" \/><\/span><\/div>\n<div>\n<h4 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Locais de entrega Consulta N1QL:<\/span><\/h4>\n<pre><code class=\"language-sql\">SELECT \r\n    round(to_number(Dropoff_latitude),3) as latitude, \r\n    round(to_number(Dropoff_longitude),3) as longitude, \r\n    count(*) as count    \r\nFROM cloud9 \r\nGROUP BY round(to_number(Dropoff_latitude),3),round(to_number(Dropoff_longitude),3) \r\nORDER BY count DESC;\r\n<\/code><\/pre>\n<h3 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 16pt;margin-bottom: 4pt\"><span style=\"font-size: 18.666666666666664px;font-family: Arial;color: #434343;background-color: transparent;font-weight: 400;vertical-align: baseline\">Tend\u00eancias e previs\u00f5es de viagens <\/span><\/h3>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Vamos dar uma olhada nas tend\u00eancias gerais de viagens mensais desde que o servi\u00e7o Green Cab foi lan\u00e7ado. <\/span><\/p>\n<pre><code class=\"language-sql\">SELECT count(*) AS rides, pickup_date_ts\r\nFORM green taxi\r\nGROUP BY pickup_date_ts\r\n<\/code><\/pre>\n<div><\/div>\n<div><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh3.googleusercontent.com\/vqyAlcOdrtNQRueEEckE7D7rYhfjTP59Omy8XIZb8mwUx-HkxB7MqW0k9b4VMdBymQRhPeEXuNAvX6mgaldrTASKI0XgQ59wh5OU0_JtgolCfzLZ495Qqut1MFkKdVPvKR4bO7SI\" width=\"624\" height=\"491\" \/><\/span><\/div>\n<div><\/div>\n<div>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">As tend\u00eancias mostram que o servi\u00e7o aumentou no final de 2013 e, a partir de 2014, a tend\u00eancia de viagens por m\u00eas se estabilizou. <\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Vamos aplicar modelos preditivos a ele para determinar o total de viagens nos pr\u00f3ximos meses. <\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Os modelos preditivos dispon\u00edveis no Cloud9 Charts testam os dados em rela\u00e7\u00e3o a eles para determinar o melhor ajuste. O modelo implica que se espera um ligeiro aumento nos pr\u00f3ximos meses. <\/span><\/p>\n<div><\/div>\n<div><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh4.googleusercontent.com\/0nP0uuuygJNkp3MbCYTghG5pqkGGwdhinJcFdubX0wI7SxAdGxWuN7jUoT7dg8_VFOxbmTfkYYpjwD8bBnDAfs66HKbfBNYcb_4Qf5f2oL0ZdqICj-X7BPDF7ek0TOnnWEcpskkM\" width=\"624\" height=\"361\" \/><\/span><\/div>\n<div><\/div>\n<h3><span style=\"font-size: 18.666666666666664px;font-family: Arial;color: #434343;background-color: transparent;font-weight: 400;vertical-align: baseline\">Compara\u00e7\u00f5es de bairros<\/span><\/h3>\n<div>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">As restri\u00e7\u00f5es de retirada representam um dilema interessante do ponto de vista do propriet\u00e1rio do t\u00e1xi. As entregas em \u00e1reas restritas implicam que o motorista deve voltar a uma regi\u00e3o de coleta para a pr\u00f3xima coleta. <\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Quais s\u00e3o as \u00e1reas mais produtivas para um motorista\/operador propriet\u00e1rio? Para responder a essa pergunta, vamos dar uma olhada em algumas an\u00e1lises de vizinhan\u00e7a. <\/span><\/p>\n<p><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">A seguir, um diagrama de acordes das rela\u00e7\u00f5es entre regi\u00f5es iniciais e regi\u00f5es finais. Por exemplo, h\u00e1 muito mais (43% a mais) viagens do Harlem \u2192 Hamilton Heights, em compara\u00e7\u00e3o com Hamilton Heights \u2192 Harlem. <\/span><\/p>\n<p><span style=\"font-size: 10.666666666666666px;font-family: Calibri;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh5.googleusercontent.com\/jI7m7zGrIru_AJ804ZqHiB-Hctx-LYy57CotzEhOBzMHI21ZUyr6G2lUe9OGdFrnhM42Q14sgua3Qf6hzCL5fcTxZ7DzZ0g-ujzvPOeEKLQvFLQR8QT6BgfxzkBJbCjtOGMYZPf8\" width=\"624\" height=\"463\" \/><\/span><\/p>\n<pre><code class=\"language-sql\">SELECT \r\n    pickup_region,\r\n    dropoff_region,\r\n    sum(rides) AS rides\r\nFROM rides_agg\r\nWHERE pickup_region !='' AND dropoff_region !=''\r\nGROUP BY pickup_region, dropoff_region\r\nORDER BY rides DESC<\/code><\/pre>\n<h3 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 16pt;margin-bottom: 4pt\"><span style=\"font-size: 18.666666666666664px;font-family: Arial;color: #434343;background-color: transparent;font-weight: 400;vertical-align: baseline\">An\u00e1lise de tarifas<\/span><\/h3>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Se a coleta for no Harlem e a devolu\u00e7\u00e3o for em Chelsea, uma \u00e1rea de coleta proibida. Durante as 17h \u00e0s 18h de uma quarta-feira, \u00e9 uma viagem de 35 minutos, conforme indicado pelo mapa de calor da grade abaixo, com tarifa m\u00e9dia de $28. Mas isso significa que o motorista precisa voltar a uma \u00e1rea de coleta para a pr\u00f3xima viagem. Do ponto de vista do motorista, n\u00e3o \u00e9 o ideal.<\/span><\/p>\n<div><\/div>\n<div><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh6.googleusercontent.com\/Ib8_FTHyi-aU6hiT_xYGA4205inRgyid3TuSeL-zCVIGP-3AFT_Tb9k2PpXgaVk4lbEm4jVAtij7SozZPqT3ZYbQgTVQ-jbZXp4V3sfwQ41UF1v0U3GYEdhC58b-sSDvbZKE8NIc\" width=\"624\" height=\"352\" \/><\/span><\/div>\n<div><\/div>\n<div><\/div>\n<div>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Compare isso com outro local de entrega, por exemplo, o bairro de Fort Green no Brooklyn (do Harlem). Essa \u00e9 uma viagem de $47 d\u00f3lares que leva em m\u00e9dia 57 minutos durante o hor\u00e1rio de pico e tamb\u00e9m oferece amplas oportunidades de coleta na \u00e1rea de Fort Green, conforme indicado pelo mapa de calor geogr\u00e1fico. <\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Para dar um passo adiante, em quais \u00e1reas uma operadora de t\u00e1xi deve implantar seus ativos? <\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">O gr\u00e1fico a seguir ajuda a responder a essa pergunta, fornecendo as tarifas m\u00e9dias mais altas em todos os locais para um determinado dia e hora do dia. <\/span><\/p>\n<h3 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 16pt;margin-bottom: 4pt\"><span style=\"font-size: 18.666666666666664px;font-family: Arial;color: #434343;background-color: transparent;font-weight: 400;vertical-align: baseline\">Melhores tarifas por localidades e por data\/hora<\/span><\/h3>\n<p><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\"><img loading=\"lazy\" decoding=\"async\" style=\"border-style: none\" src=\"https:\/\/lh3.googleusercontent.com\/0AYpJLuclaET1U6l3j_8nTuevMHQfbaTi4Gld_4deRipM_CBZF9ESyK5lWsN_Otot3xEH3X3xjPlHj5frnEqxJabF4GKuF8anjiGFOvfA94i_TnqUIaT_Bf2qar94YRDop6CsMM1\" width=\"624\" height=\"352\" \/><\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">Portanto, parece que \u00e0s ter\u00e7as-feiras, das 8 \u00e0s 9 horas da manh\u00e3, o bairro de Nkew Gardens produz a maior tarifa m\u00e9dia de coleta, enquanto no s\u00e1bado \u00e0 noite, \u00e0s 23 horas, a pole position vai para o bairro da Jamaica.<\/span><\/p>\n<h2 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 16pt;margin-bottom: 4pt\"><span style=\"font-size: 18.666666666666664px;font-family: Arial;color: #434343;background-color: transparent;font-weight: 400;vertical-align: baseline\">Resumo<\/span><\/h2>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;vertical-align: baseline\">J\u00e1 se foram os dias de processos de ETL demorados ou de transformar dados semiestruturados em formatos relacionais para fins de an\u00e1lise. Com o Cloud9 Charts, voc\u00ea pode aproveitar o N1QL nativamente para obter insights imediatos e acion\u00e1veis que podem ser compartilhados e incorporados em um instante. <\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #000000;background-color: transparent;font-style: italic;vertical-align: baseline\">Agradecimentos especiais a Prasad Varakur, Chin Hong e ao restante da equipe do Couchbase pelo suporte pr\u00e1tico na implanta\u00e7\u00e3o do Couchbase e na otimiza\u00e7\u00e3o de consultas.<\/span><\/p>\n<h2 dir=\"ltr\" style=\"line-height: 1.38;margin-top: 16pt;margin-bottom: 4pt\"><span style=\"font-size: 18.666666666666664px;font-family: Arial;color: #434343;background-color: transparent;font-weight: 400;vertical-align: baseline\">Recursos:<\/span><\/h2>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><a style=\"text-decoration: none\" href=\"https:\/\/cloud9charts.com\/couchbase\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">An\u00e1lise instant\u00e2nea no Couchbase<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><a style=\"text-decoration: none\" href=\"https:\/\/www.youtube.com\/watch?v=T2v__pDTTMw\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">Couchbase Connect, palestra ao vivo sobre o conjunto de dados de t\u00e1xi<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><a style=\"text-decoration: none\" href=\"https:\/\/www.cloud9charts.com\/docs\/couchbase.html\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">Documenta\u00e7\u00e3o dos gr\u00e1ficos do Couchbase-Cloud9<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><a style=\"text-decoration: none\" href=\"https:\/\/www.cloud9charts.com\/docs\/multi-datasource-joins.html\"><span style=\"font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;text-decoration: underline;vertical-align: baseline\">Uni\u00f5es de v\u00e1rias fontes de dados<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38;margin-top: 0pt;margin-bottom: 0pt\"><span style=\"text-decoration: underline;font-size: 14.666666666666666px;font-family: Arial;color: #1155cc;background-color: transparent;vertical-align: baseline\"><a style=\"text-decoration: none\" href=\"https:\/\/cloud9charts.com\/docs\/predictive-analytics.html\">An\u00e1lise preditiva<\/a><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<div><\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>This is a guest post by Jay Gopalakrishnan. Jay is the founder of Cloud9 Charts, an analytics platform built for modern data architectures, featuring native support for Couchbase and N1QL. Follow them on twitter @cloud9charts This post uses the NYC [&hellip;]<\/p>","protected":false},"author":81,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816,1812],"tags":[1834,1832,1831],"ppma_author":[9048],"class_list":["post-2497","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","category-n1ql-query","tag-charts","tag-cloud9charts","tag-native-analytics"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Native Analytics on Couchbase with Cloud9 Charts<\/title>\n<meta name=\"description\" content=\"Learn using Cloud9 Charts how you can leverage N1QL natively to derive immediate, actionable insights that can be shared and embedded in a jiffy.\" \/>\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\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Taxi Ride Analysis - Native Analytics on Couchbase with Cloud9 Charts\" \/>\n<meta property=\"og:description\" content=\"Learn using Cloud9 Charts how you can leverage N1QL natively to derive immediate, actionable insights that can be shared and embedded in a jiffy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-18T10:07:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-09T14:26:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lh6.googleusercontent.com\/ytFgkTvqQDYr6Su_bPX0tCvS8jzVGRR1Ex-FjmTd7oPRPfkfUlFhKZ6CBqSOfceXjNLxilbAtgR_rRt7rX34fEcWyuYmhU-y8ymCN5CMTxDMjA_d9E9hShrbVFNWPZnfNyPQur9-\" \/>\n<meta name=\"author\" content=\"Jay Gopalakrishnan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jay Gopalakrishnan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/\"},\"author\":{\"name\":\"Jay Gopalakrishnan\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/07fff93a5ea5f3c42de4425be5f1d95c\"},\"headline\":\"Taxi Ride Analysis &#8211; Native Analytics on Couchbase with Cloud9 Charts\",\"datePublished\":\"2017-01-18T10:07:23+00:00\",\"dateModified\":\"2025-10-09T14:26:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/\"},\"wordCount\":1015,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"keywords\":[\"charts\",\"cloud9charts\",\"native analytics\"],\"articleSection\":[\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/\",\"name\":\"Native Analytics on Couchbase with Cloud9 Charts\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2017-01-18T10:07:23+00:00\",\"dateModified\":\"2025-10-09T14:26:22+00:00\",\"description\":\"Learn using Cloud9 Charts how you can leverage N1QL natively to derive immediate, actionable insights that can be shared and embedded in a jiffy.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Taxi Ride Analysis &#8211; Native Analytics on Couchbase with Cloud9 Charts\"}]},{\"@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\/07fff93a5ea5f3c42de4425be5f1d95c\",\"name\":\"Jay Gopalakrishnan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8763f637bc834e4b4c53aa07c02b1195\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a52fb3d897cac4659cb7bc376619560b519528d73c5d81f488784c227c71f12b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a52fb3d897cac4659cb7bc376619560b519528d73c5d81f488784c227c71f12b?s=96&d=mm&r=g\",\"caption\":\"Jay Gopalakrishnan\"},\"description\":\"Jay is the founder &amp; CEO of Knowi, formerly known as Cloud9 Charts, an analytics platform built for modern data architectures, featuring native support for Couchbase and N1QL. Additionally, Jay Gopalakrishnan has had 3 past jobs including Product &amp; Engineering at Mowingo.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/pt\/author\/jay-gopalakrishnan\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Native Analytics on Couchbase with Cloud9 Charts","description":"Aprenda, usando o Cloud9 Charts, como aproveitar o N1QL nativamente para obter insights imediatos e acion\u00e1veis que podem ser compartilhados e incorporados em um instante.","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\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/","og_locale":"pt_BR","og_type":"article","og_title":"Taxi Ride Analysis - Native Analytics on Couchbase with Cloud9 Charts","og_description":"Learn using Cloud9 Charts how you can leverage N1QL natively to derive immediate, actionable insights that can be shared and embedded in a jiffy.","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/","og_site_name":"The Couchbase Blog","article_published_time":"2017-01-18T10:07:23+00:00","article_modified_time":"2025-10-09T14:26:22+00:00","og_image":[{"url":"https:\/\/lh6.googleusercontent.com\/ytFgkTvqQDYr6Su_bPX0tCvS8jzVGRR1Ex-FjmTd7oPRPfkfUlFhKZ6CBqSOfceXjNLxilbAtgR_rRt7rX34fEcWyuYmhU-y8ymCN5CMTxDMjA_d9E9hShrbVFNWPZnfNyPQur9-","type":"","width":"","height":""}],"author":"Jay Gopalakrishnan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jay Gopalakrishnan","Est. reading time":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/"},"author":{"name":"Jay Gopalakrishnan","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/07fff93a5ea5f3c42de4425be5f1d95c"},"headline":"Taxi Ride Analysis &#8211; Native Analytics on Couchbase with Cloud9 Charts","datePublished":"2017-01-18T10:07:23+00:00","dateModified":"2025-10-09T14:26:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/"},"wordCount":1015,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["charts","cloud9charts","native analytics"],"articleSection":["Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/","url":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/","name":"Native Analytics on Couchbase with Cloud9 Charts","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2017-01-18T10:07:23+00:00","dateModified":"2025-10-09T14:26:22+00:00","description":"Aprenda, usando o Cloud9 Charts, como aproveitar o N1QL nativamente para obter insights imediatos e acion\u00e1veis que podem ser compartilhados e incorporados em um instante.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/taxi-ride-analysis-native-analytics-on-couchbase-with-cloud9-charts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Taxi Ride Analysis &#8211; Native Analytics on Couchbase with Cloud9 Charts"}]},{"@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\/07fff93a5ea5f3c42de4425be5f1d95c","name":"Jay Gopalakrishnan","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/8763f637bc834e4b4c53aa07c02b1195","url":"https:\/\/secure.gravatar.com\/avatar\/a52fb3d897cac4659cb7bc376619560b519528d73c5d81f488784c227c71f12b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a52fb3d897cac4659cb7bc376619560b519528d73c5d81f488784c227c71f12b?s=96&d=mm&r=g","caption":"Jay Gopalakrishnan"},"description":"Jay \u00e9 o fundador e CEO da Knowi, anteriormente conhecida como Cloud9 Charts, uma plataforma de an\u00e1lise criada para arquiteturas de dados modernas, com suporte nativo para Couchbase e N1QL. Al\u00e9m disso, Jay Gopalakrishnan teve 3 empregos anteriores, incluindo Produto e Engenharia na Mowingo.","url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/jay-gopalakrishnan\/"}]}},"authors":[{"term_id":9048,"user_id":81,"is_guest":0,"slug":"jay-gopalakrishnan","display_name":"Jay Gopalakrishnan","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/a52fb3d897cac4659cb7bc376619560b519528d73c5d81f488784c227c71f12b?s=96&d=mm&r=g","author_category":"","last_name":"Gopalakrishnan","first_name":"Jay","job_title":"","user_url":"","description":"Jay \u00e9 o fundador e CEO da Knowi, anteriormente conhecida como Cloud9 Charts, uma plataforma de an\u00e1lise criada para arquiteturas de dados modernas, com suporte nativo para Couchbase e N1QL. Al\u00e9m disso, Jay Gopalakrishnan teve 3 empregos anteriores, incluindo Produto e Engenharia na Mowingo."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/2497","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\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=2497"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/2497\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=2497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=2497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=2497"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=2497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}