{"id":351,"date":"2024-12-01T14:23:06","date_gmt":"2024-12-01T14:23:06","guid":{"rendered":"https:\/\/lookercourses.com\/?p=351"},"modified":"2025-10-09T19:27:10","modified_gmt":"2025-10-09T19:27:10","slug":"el-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-looker-studio","status":"publish","type":"post","link":"https:\/\/lookercourses.com\/es\/el-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-looker-studio\/","title":{"rendered":"El gr\u00e1fico de dispersi\u00f3n en Looker Studio: c\u00f3mo analizar la relaci\u00f3n entre 2 variables"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">El gr\u00e1fico de dispersi\u00f3n es ideal para analizar la relaci\u00f3n entre 2 variables. En este post nos adentraremos en c\u00f3mo configurar esta visualizaci\u00f3n y qu\u00e9 opciones tiene.<\/h3>\n\n\n\n<p>Recuerda que si necesitas refrescarte la memoria sobre <a href=\"\/como-anadir-fuentes-de-datos-en-looker-studio\">c\u00f3mo a\u00f1adir visualizaciones a tu informe de Looker Studio<\/a>, puedes hacerlo en el post sobre ello.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ejemplo<\/h2>\n\n\n\n<p>En este ejemplo vamos a trabajar con el <a href=\"\/acceso-a-datasets-para-practicar-en-looker-studio\" data-type=\"post\" data-id=\"85\">dataset de Spotify<\/a>. Vamos a analizar cu\u00e1l es la relaci\u00f3n entre el n\u00famero de veces que una canci\u00f3n se ha reproducido y en cu\u00e1ntas playlists de Spotify se ha a\u00f1adido. Lo que vamos a ver es si podemos confirmar que cuantas m\u00e1s veces una canci\u00f3n es reproducida, m\u00e1s aumenta el n\u00famero de playlists de Spotify en las que se guarda.<\/p>\n\n\n\n<p>\n  Para crear el gr\u00e1fico tienes que usar el nombre de la canci\u00f3n como dimensi\u00f3n (<em>track_name<\/em>), las reproducciones (<em>streams<\/em>) como m\u00e9trica del eje X y el n\u00famero de playlists de Spotify <em>(in_Spotify_playlists<\/em>) como m\u00e9trica del eje Y.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"1044\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-2.png\" alt=\"\" class=\"wp-image-353\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-2.png 474w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-2-136x300.png 136w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-2-465x1024.png 465w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n\n\n\n<p>Como resultado tendremos este gr\u00e1fico de dispersi\u00f3n que muestra la relaci\u00f3n entre las veces que una canci\u00f3n se ha reproducido y las que se ha a\u00f1adido a una playlist de Spotify.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"446\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-3.png\" alt=\"\" class=\"wp-image-354\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-3.png 827w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-3-300x162.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-3-768x414.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/figure>\n\n\n\n<p>\n  Como el gr\u00e1fico indica, s\u00ed que hay una relaci\u00f3n entre las 2 m\u00e9tricas. Parece que en general cuantas m\u00e1s reproducciones tiene, m\u00e1s aumenta el n\u00famero de playlists de Spotify en las que est\u00e1. En estad\u00edstica esto lo llamamos correlaci\u00f3n y podemos decir que las variables est\u00e1n altamente correlacionadas.\n<\/p>\n\n\n\n<p>Las correlaciones y los gr\u00e1ficos de dispersi\u00f3n son temas en los que se puede profundizar bastante, pero para no desviarnos del objetivo de este post, simplemente te voy a dejar este <a href=\"https:\/\/www.rankia.cl\/blog\/mejores-opiniones-chile\/4090045-como-interpretar-para-que-sirve-coeficiente-correlacion\" target=\"_blank\" rel=\"noreferrer noopener\">enlace<\/a> en el que puedes aprender m\u00e1s sobre el tema, si te interesa.<\/p>\n\n\n\n<p>\n  Veamos otro ejemplo en el que la correlaci\u00f3n es baja. Vamos a cambiar la m\u00e9trica del eje de la Y por <em>in_Deezer_playlists<\/em>.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"1044\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-4.png\" alt=\"\" class=\"wp-image-355\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-4.png 474w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-4-136x300.png 136w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-4-465x1024.png 465w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n\n\n\n<p>Ahora nuestro gr\u00e1fico de dispersi\u00f3n muestra la relaci\u00f3n entre las veces que una canci\u00f3n se ha reproducido y las que se ha a\u00f1adido a una playlist de Deezer.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"826\" height=\"447\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-5.png\" alt=\"\" class=\"wp-image-356\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-5.png 826w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-5-300x162.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-5-768x416.png 768w\" sizes=\"auto, (max-width: 826px) 100vw, 826px\" \/><\/figure>\n\n\n\n<p>Como ves en este caso, la l\u00ednea de tendencia es mucho m\u00e1s aplanada que en el anterior, lo que indica una menor correlaci\u00f3n. \u00bfQuieres saber c\u00f3mo pintar la l\u00ednea de tendencia? <\/p>\n\n\n\n<p>\n  Ve\u00e1moslo en el siguiente punto.\n<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a id=\"post-351-_6lqamelp28xy\"><\/a>Opciones de personalizaci\u00f3n espec\u00edficas del gr\u00e1fico<\/h2>\n\n\n\n<p>Dentro de <em>Estilo<\/em> puedes a\u00f1adir una l\u00ednea de tendencia, elegir el tipo (linear, exponencial o logar\u00edtmica) y el formato. Ver\u00e1s el nombre <em>L\u00ednea de tendencia<\/em> y debajo un desplegable en el que puedes elegir el tipo.<\/p>\n\n\n\n<p>\n  Existen 2 tipos de gr\u00e1ficos de dispersi\u00f3n. Uno al que Looker Studio llama gr\u00e1fico de dispersi\u00f3n y representa los datos con puntos, y otro llamado gr\u00e1fico de burbujas que los representa, como su nombre indica, con burbujas.\n<\/p>\n\n\n\n<p>\n  Dentro de <em>Estilo<\/em> puedes cambiar el color de los puntos burbujas: Debajo de <em>N\u00famero de burbujas<\/em> ver\u00e1s<em> Color del cuadro<\/em>. Si abres el desplegable y eliges una de las dimensiones que has utilizado, los distintos valores de esta tendr\u00e1n un color determinado. Este puede ser en base al orden de las burbujas o al valor de las dimensiones.\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"594\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-6.png\" alt=\"\" class=\"wp-image-357\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-6.png 474w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-6-239x300.png 239w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n\n\n\n<p>Al hacer los cambios dentro de <em>Estilo<\/em>, ahora tenemos un gr\u00e1fico de burbujas donde la dimensi\u00f3n <em>track_name<\/em> determina el color.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"826\" height=\"462\" src=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-7.png\" alt=\"\" class=\"wp-image-358\" srcset=\"https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-7.png 826w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-7-300x168.png 300w, https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/word-image-351-7-768x430.png 768w\" sizes=\"auto, (max-width: 826px) 100vw, 826px\" \/><\/figure>\n\n\n\n<p>El gr\u00e1fico de dispersi\u00f3n es, sin duda, uno de mis preferidos. \u00bfA ti qu\u00e9 te parece?, \u00bfte gusta o crees que es generalmente dif\u00edcil de leer?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>El gr\u00e1fico de dispersi\u00f3n es ideal para analizar la relaci\u00f3n entre 2 variables. En este post nos adentraremos en c\u00f3mo [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1341,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[9],"tags":[4],"class_list":["post-351","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-graficos","tag-es"],"uagb_featured_image_src":{"full":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-Looker-Studio-1.jpg",700,400,false],"thumbnail":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-Looker-Studio-1-150x150.jpg",150,150,true],"medium":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-Looker-Studio-1-300x171.jpg",300,171,true],"medium_large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-Looker-Studio-1.jpg",700,400,false],"large":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-Looker-Studio-1.jpg",700,400,false],"1536x1536":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-Looker-Studio-1.jpg",700,400,false],"2048x2048":["https:\/\/lookercourses.com\/es\/wp-content\/uploads\/2024\/10\/El-grafico-de-dispersion-o-como-analizar-la-relacion-entre-2-variables-en-Looker-Studio-1.jpg",700,400,false]},"uagb_author_info":{"display_name":"barbmk","author_link":"https:\/\/lookercourses.com\/es\/author\/barbmk\/"},"uagb_comment_info":0,"uagb_excerpt":"El gr\u00e1fico de dispersi\u00f3n es ideal para analizar la relaci\u00f3n entre 2 variables. En este post nos adentraremos en c\u00f3mo [&hellip;]","_links":{"self":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/comments?post=351"}],"version-history":[{"count":2,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/351\/revisions"}],"predecessor-version":[{"id":1997,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/posts\/351\/revisions\/1997"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media\/1341"}],"wp:attachment":[{"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookercourses.com\/es\/wp-json\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}