<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Alber Domínguez on Medium]]></title>
        <description><![CDATA[Stories by Alber Domínguez on Medium]]></description>
        <link>https://medium.com/@albermard?source=rss-79c52389be60------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*CdtGLg19tWeP8g4UjK3fUQ.jpeg</url>
            <title>Stories by Alber Domínguez on Medium</title>
            <link>https://medium.com/@albermard?source=rss-79c52389be60------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 10:53:04 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@albermard/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Introducción a Power BI desktop — Parte 1]]></title>
            <link>https://medium.com/@albermard/introducci%C3%B3n-a-power-bi-desktop-parte-1-39153806349c?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/39153806349c</guid>
            <category><![CDATA[dashboard-design]]></category>
            <category><![CDATA[spanish]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Wed, 13 Apr 2022 03:13:08 GMT</pubDate>
            <atom:updated>2022-04-13T03:17:31.398Z</atom:updated>
            <content:encoded><![CDATA[<h3>Introducción a Power BI desktop — Parte 1</h3><h4>Tu primer dashboard en Power BI</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Il1fpsenw5-FgA70Jii_vw.gif" /></figure><p>Power BI es una herramienta para crear gráficos y visuales atractivas a partir de tablas de datos. Dado que Power BI fue creado por Microsoft, puedes imaginar que ha sido desarrollado como una evolución del módulo de gráficos de Excel, pero enfocado en las demandas comerciales para análisis y ciencia de datos.</p><p>Las siglas BI (Business Intelligence) o Inteligencia de Negocios, nos indican que Power BI tiene un objetivo principal: facilitar la representación de datos para que los negocios puedan tomar decisiones basadas en datos.</p><h3>Power BI desktop vs Power BI service</h3><p>Para efectos de este tutorial, nos enfocaremos en Power BI desktop por los siguientes motivos:</p><ul><li>Power BI desktop está disponible de manera gratuita para usuarios de Windows 8 en adelante</li><li>El programa se puede utilizar sin necesidad de conexión a internet, lo que facilita el trabajo para lugares donde la conexión a internet es nula o limitada.</li><li>Es la herramienta ideal para aprender las funcionalidades principales.</li></ul><p>Ten en cuenta que en organizaciones con acceso a cloud, es probable que cuenten con Power BI service, lo que permite funcionalidades más avanzadas pero fáciles de comprender una vez que has trabajado con la aplicación de escritorio (desktop).</p><h3>Instalar Power BI desktop</h3><ul><li>En tu ordenador con Windows, abre la aplicación de Microsoft Store</li><li>Escribe en el buscador Power BI desktop</li><li>Click en descargar</li><li>Luego del tiempo de descarga e instalación, estaras listo para utilizar la aplicación.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yeTQ13Q-1CFjYuPv2VbkIQ.png" /></figure><h3>Cargar y transformar data</h3><p>Vamos a constuir un tablero (dashboard) a partir de una base de datos que representa una franquicia ficticias de areperas distribuidas por el mundo. Trabajaremos con un archivo de formato .xslx (Excel) que puedes <a href="https://github.com/nedraki/Introduccion_powerbi__spanish/blob/main/Esto-no-es-una-arepera.xlsx">descargar en el siguiente link</a>.</p><p>Al iniciar Power BI, podemos ver la ventana inicial, el primer paso es conectar la aplicación con los datos:</p><ul><li>Click en obtener datos (Get data)</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*zZxByiletHDkdT3bFwfTvQ.png" /><figcaption>Primer paso para leer los datos en Power BI</figcaption></figure><ul><li>Se abre la ventana para seleccionar el formato de los datos, para este ejercicio trabajaremos con un archivo Excel. <em>Nota que existe una amplia variedad de opciones para conectarse con distintos formatos y bases de datos que te pueden ser de utilidad en el futuro.</em></li><li>Selecciona el archivo <em>Esto_no_es_una_arepera.xlsx</em> previamente descargado.</li><li>Aseguráte de hacer check ✅ en la barra lateral izquierda para seleccional la hoja de Excel.</li><li>Click en cargar y transformar (Load and Transform)</li><li>Voilá, se abre una nueva ventana con los datos, listos para ser transformados.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9my_fT9nnwV47uJyYWXDmQ.gif" /><figcaption>Cargar y transforlar datos en Power BI</figcaption></figure><h3>Transformar datos</h3><h4>- Eliminar columnas</h4><p>Idealmente, los datos cargados a Power BI han sido pre-procesados y organizados, sin embargo este no es siempre el caso por lo que es importante dedicar atención a la transformación de los datos antes de construir el dashboard.</p><ul><li><em>Esto_no_es_una_arepera.xlsx </em>contiene algunos errores creados a propósito para ilustrar algunos de los errores comunes que pueden contener datos traídos desde Excel.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kQ6qaxyHzT6dpGBum1Fa8A.png" /><figcaption>Columnnas con valores nulos o carácteres especiales que no agregan valor a los datos</figcaption></figure><p>Dado que estos datos no agregan valor a nuestro reporte, procedemos a eliminar las colummnas Descuento, column0, Column10.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EosqKuM3WNfuR1fwoJMV8w.gif" /><figcaption>Eliminar columnas</figcaption></figure><p>En el panel derecho, tenemos el área de Query Settingsy puedes ver que enAPPLIED STEPS se indica una lista de operaciones que han sido aplicadas a los datos desde el momento en que hicimos clic en Get Data. Esta lista de pasos es particularmente importante ya que si en el futuro, actualizas los datos, cada una de las operaciones que progrmaste volveran a ser aplicadas.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/269/1*bXPBwZngnYtQUC2CS1249w.png" /><figcaption>Para tu referencia, puedes cambiar el nombre de los pasos aplicados. Así será más facil recordar las transformaciones aplicadas.</figcaption></figure><h4>- Filtrar Valores</h4><p>Dirígete a la primera linea de la tabla donde se indican los nombres de cada columna, nota que cada columna tiene un menú desplegable que te permite filtrar los valores a conveniencia.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FMSfEqJnt2qkZRe9Rrf88A.gif" /><figcaption>Power BI: Filtrar datos</figcaption></figure><p>Para este ejercicio, al revisar las columnas Cantidad y Producto observamos la presencia de valores nulos (null). Para evitar usar estos valores en el tablero, procedemos a filtrarlos al remover el checkmark ✔️.</p><p>Puedes ver que aparece una nueva oepración en la tabla de APPLIED STEPS .</p><p>Tambien podemos por ejemplo, filtrar los datos de la columna Fecha para mostrar sólo los datos correspondientes a un periodo específico.</p><h4>- Tipos de datos (Data Type)</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uaIHuqD6Nrh2XwtBMtVhtg.png" /><figcaption>Data Types</figcaption></figure><p>La aplicación reconoce automáticamente la columna Fecha como datos referentes al tiempo y lo indica visualmente con el ícono del calendario que precede al nombre de la columna. De manera similar, las otras columnas reciben un formato de datos <em>texto</em> en el caso de Producto o <em>número</em> para Cantidad. Observa que esto se indica con los íconos ABC y 123 que preceden al nombre de la columna.</p><p>Podemos cambiar los tipos de datos? Sí, de hecho observa que la columna PVP USD requiere transformación ya que los datos no están siendo reconocidos como números decimales. Este error suele ser común al trabajar con datos en un ordenar en Español ya que en Ingles los decimales se indican con punto y no con coma.</p><ul><li>Procedemos a cambiar el formato de los datos PVP USD a <em>número decimal</em></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LmzIDlKy22RFUlkMR8fSTQ.gif" /><figcaption>Cambiar formato de datos (Data type)</figcaption></figure><h4>- Agregar columnas</h4><p>El archivo contiene datos como la cantidad total de arepas vendidas, su costo y precio de venta al público. Estos datos pudieran ser facilmente procesados para obtener valores como total de ventas en USD (total_ventas = <em>Cantidad</em> x <em>PVP</em>) o total en costos ( total_costos = <em>Cantidad</em> x <em>Costo</em>).</p><p>Estos valores pueden ser calculados de una forma relativamente similar a la multiplicación de columnas en Excel.</p><ul><li>En el menú superior, click en Add Column (Agregar columna)</li><li>Click en Custom Column</li><li>Inserta las columnas de interés y la operación matemática a efectuar.</li></ul><p>A continuación, un ejemplo calculando el total de ventas. Puedes repetir el proceso para calcular el total de costos, o la diferencia entre ventas y costos para obtener la ganancia.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*F710ANC5AwgLZMPFrVnIEw.gif" /><figcaption>Agregar columnas en Power BI</figcaption></figure><p>De nuevo, nota que la lista en APPLIED STEPS continúa actualizandose, esta vez indicando que agregamos una nueva columna.</p><h4>- Cerrar y aplicar</h4><p>Una vez que finalizamos con todos los pasos necesarios para limpiar, filtrar y transformar los datos, sólo hay un paso extra que aplicar antes de comenzar a diseñar el dashboard.</p><ul><li>Close &amp; Apply (Cerrar y Aplicar)</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*t0kygbKcVzDX1q5iwrwafw.gif" /><figcaption>Close &amp; Apply</figcaption></figure><p>Se muestra ahora, el área donde podremos representar visualmente los datos y los datos disponibles estan en el panel Field ubicado a la derecha.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/399/1*pHDQpm8Oze947IEB-WW5sA.png" /><figcaption>Field</figcaption></figure><p>Ya estamos listos para construir un dashboard que nos cuente la historia de las areperas alrededor del mundo.</p><h3>Tu primer dashboard en Power BI</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*X_SQIJai_SmFdbKU2oN_pg.gif" /></figure><p>Para generar gráficos, tenemos el menú Visualizations con una variedad de gráficos que incluye mapas, gráficos de torta y de barra, tablas e indicadores. Al arrastrar y soltar el nombre de la columna de interes en el área de diseño, se empiezan a generar automáticamente visualizaciones que iremos ajustando a conveniencia.</p><p>Para hacer el tutorial más interesante, presentaré una serie de preguntas que iremos respondiendo gráficamente. Tienes total libertad de fijar tus preguntas, imagina que eres un detective y tu misión es interrogar a la base de datos.</p><ul><li>En qué país nuestra franquicia fictia vende más arepas?</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wR12CoInd06m8b4p94fnQQ.png" /></figure><p><em>Parece que la arepa llegó a Japón y está siendo exitosa.</em></p><h4>- Construir el <strong>gráfico de barras</strong>:</h4><ol><li>Ve al menú Visualizations y selecciona el icono correspondiente a una tabla de datos.</li><li>Arrastra el campo Ciudad-País a la zona de gráficos y suéltalo sobre el recuadro que representa la tabla</li><li>Arrastra el campo a la zona de gráficos y suéltalo sobre el recuadro que representa la tabla</li><li>Selecciona la tabla y cambia su formato a gráfico de barras en el menú Visualizations.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*E7halGkRqrg1csogcaxKNA.gif" /><figcaption>Insertar tabla y gráfico de barras</figcaption></figure><h4>Treemap</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/567/1*y3ln8M3SkfC9uBzenYX0qg.png" /><figcaption>Treemap para mostrar productos disponibles y cantidad vendida</figcaption></figure><ul><li>Qué productos están disponibles y en qué cantidades se están vendiendo?</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LPry8O0alNJNXaOgCcLZow.gif" /><figcaption>Insertar Treemap para representar productos y cantidad vendida</figcaption></figure><p>Los gráficos en PowerBI estan automáticamente conectados, de manera que al hacer click sobre un campo de interés, todo el tablero se adapta para resaltar los datos más relevantes. Veamos un ejemplo:</p><ul><li>En qué paises se vende la sushi-repa?</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9JZYw6DZnRofFLrldJiSBA.gif" /><figcaption>Al hacer click en un producto, automáticamente se resaltan otros gráficos asociados.</figcaption></figure><h4>Card (Tarjeta)</h4><ul><li>Indica el total de arepas vendidas alrededor del mundo</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*l1gF2gh_pYoxWhmop89kEg.gif" /></figure><ul><li>Indica cuántas “Reinas Pepiadas” se han vendido ?</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*a-746DWAcwxb3Vy_Xs_DXQ.gif" /><figcaption>Los gráficos permanecen conectados y resaltan los valores de interés.</figcaption></figure><h4>Slicer (Selector)</h4><ul><li>Cómo han cambiado las ventas a lo largo del tiempo ?</li></ul><p>Para responder a esta pregunta, aprovecharemos la opción Slicer ya que permite al usuario, buscar y seleccionar los datos de interés.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RCruzcBjCy_7roW29hnNzw.gif" /></figure><p>Analizando mes a mes, puedes notar que la exitosa sushi-arepa empezó a venderse en Abril de 2022 y sólo está disponible en Tokio.</p><ul><li>Puedo seleccionar los datos por país ?</li></ul><p>El Slicer también es útil para crear menus desplegables (dropdown), por ejemplo para seleccionar ciudades en particular.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BYXxb6Tf_8xglRY9xOHcGw.gif" /></figure><h4>Gráfico de barras apilado (100% Stacked Bar Chart)</h4><ul><li>Cómo se distribuye la venta de productos por ciudad ?</li></ul><p>Creemos un gráfico para visualizar rápidamente los productos que se venden por ciudad en términos porcentuales.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cQle3pvGdMZyCv5ZNeyCUA.gif" /></figure><p>Podemos observar que por ejemplo, más de 40% de las arepas vendidas en Méfico DF son de jamón y queso o que el 100% de las arepas vendidas en Paris se acompañan con mermelada.</p><h4>Mapas</h4><ul><li>Podemos visualizar en un mapa la ubicación de las areperas?</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*i6kNfRX9JFwcKKIfVFq20w.gif" /></figure><p>Se muestra ahora un mapa con burbujas de color azul ubicadas en cada ciudad. El mapa puede representar incluso mas información, por ejemplo puedes ajustar el tamano de las burbujas para que representen la cantidad de arepas vendidas, o agregar una leyenda de colores por ciudad o producto. También puedes usar el slicer, seleccionar una ciudad y observar cómo el mapa se actualiza.</p><p>Voilá! Hemos terminado el tutorial introductorio 👏, es momento de ir a disfrutar una arepa.</p><p>Exploramos algunas de las funciones principales para diseñar dashboards, pero por supuesto aún queda mucho que aprender y en futuros tutoriales trabajaremos con opciones más avanzadas.</p><p>La práctica hace al maestro.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*ofH03gwohwseZnOf" /><figcaption>Photo by <a href="https://unsplash.com/@leila_myphotography?utm_source=medium&amp;utm_medium=referral">Leila Issa</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=39153806349c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Compartir dashboard en Data Studio]]></title>
            <link>https://medium.com/@albermard/compartir-dashboard-en-data-studio-332d8c6890ff?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/332d8c6890ff</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[google-data-studio]]></category>
            <category><![CDATA[espanenglish]]></category>
            <category><![CDATA[datos]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Thu, 31 Mar 2022 10:22:36 GMT</pubDate>
            <atom:updated>2022-03-31T11:03:31.686Z</atom:updated>
            <content:encoded><![CDATA[<h3>Compartir dashboards creados Data Studio</h3><h4>Introducción a Google Data Studio — Parte 4</h4><p>Una vez finalizada la construcción de tu dashboard es momento de compartir tu trabajo con colegas, personas o instituciones interesadas en la información.</p><p>De qué formas puedo compartir la información?</p><ul><li>Una de las principales ventajas de trabajar con Data Studio es que puedes compartir el dashboard via URL, es decir, la información estará disponible on-line para usuarios que tengan acceso.</li><li>Los permisos de acceso se otorgan a otros usuarios con cuentas Gmail y se puede configurar para otorgar permisos de sólo lectura o de edición.</li><li>En caso de que desees que el tablero sea totalmente público, entonces puedes definir el acceso para cualquier usuario que tenga la URL.</li><li>Además, puedes exportar el tablero y guardarlo en un archivo pdf.</li></ul><h3><strong>Compartir tablero vía url y permisos de acceso</strong></h3><ul><li>Click en Compartir (Share)</li><li>Si deseas agregar colaboradores o usuarios, puedes agregar su dirección de gmail y el nivel de acceso que tendrá el usuario (Puede ver,Puede ver y editar).</li><li>En caso de que desees compartir via url , click en Gestionar Acceso (Manage access)</li><li>Distintas opciones son disponibles para gestionar el acceso vía link, entre ellas destacan:</li></ul><blockquote>Cualquier usuario de internet puede encontrarlo y verlo</blockquote><blockquote>Cualquier usuario de internet puede encontrarlo y editarlo</blockquote><blockquote>Cualquier persona con el enlace puede verlo</blockquote><blockquote>Cualquier persona con el enlace puede editarlo</blockquote><blockquote>Desactivado: solo pueden acceder usuarios específicos</blockquote><p><a href="https://datastudio.google.com/reporting/b695e325-98e6-473a-b6b8-21185febafec">En este link</a>, puedes encontrar un ejemplo de tablero para tu referencia. Está diseñado con los mismos datos de frecuencia de servicio de agua y sólo los usuarios con el link tienen permiso para ver pero no para editar, copiar ni compartir.</p><p>⚠️ ️️️<strong>Precaución</strong></p><ul><li>Ten cuidado al asignar permisos, sólo miembros del equipo a cargo de construir y mantener el dashboard deben tener permisos de edición.</li><li>Si los datos representados en el tablero son confidenciales, asegúrate que únicamente las personas con autorización tienen acceso al tablero.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dnGF5-XZO4GJudIwfwWCNw.gif" /></figure><h3><strong>Exportar reporte a formato pdf</strong></h3><p>En el caso de necesitar un documento con los gráficos presentados puedes exportar el informe a formato pdf, la desventaja de este método es que perdemos las herramientas interactivas.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/533/1*WOhGiKFI6pUOY5PSuf-iCw.jpeg" /></figure><p><strong><em>Felicitaciones, por completar el tutorial de Google Data Studio.</em></strong></p><p>Luego de seguir el tutorial, aprendiste a:</p><p>💻 <a href="https://medium.com/@albermard/introducci%C3%B3n-a-google-data-studio-parte-1-120c1b1ece70">Crear y conectar una fuente de datos a hojas de cálculo de Google</a></p><p>📊<a href="https://medium.com/@albermard/tu-primer-dashboard-44f10769e04"> Crear tu primer reporte en Data Studio</a></p><p>📈<a href="https://medium.com/@albermard/personalizaci%C3%B3n-de-dashboard-98aecc166054">Personalizar los gráficos en tu reporte</a></p><p>🌎<a href="https://medium.com/@albermard/compartir-dashboard-en-data-studio-332d8c6890ff">Compartir tu dashboard con el mundo</a></p><p>Ya estas listo para practicar y desarrollar tus proyectos. Curiosidad y práctica son tus mejores aliados para manejar cada vez mejor la herramienta.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fgiphy.com%2Fembed%2F3oEdv3jDLP7XcpL2Wk%2Ftwitter%2Fiframe&amp;display_name=Giphy&amp;url=https%3A%2F%2Fmedia.giphy.com%2Fmedia%2F3oEdv3jDLP7XcpL2Wk%2Fgiphy.gif&amp;image=https%3A%2F%2Fi.giphy.com%2Fmedia%2F3oEdv3jDLP7XcpL2Wk%2Fgiphy.gif&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=giphy" width="435" height="244" frameborder="0" scrolling="no"><a href="https://medium.com/media/e2c29a9f83b95a6c12a05c19009e73de/href">https://medium.com/media/e2c29a9f83b95a6c12a05c19009e73de/href</a></iframe><h3><strong>Links de interés</strong></h3><ul><li><a href="https://datastudio.google.com/u/0/reporting/0B5FF6JBKbNJxOWItcWo2SVVVeGc/page/DjD">Tutorial Oficial Google Data Studio</a></li><li><a href="https://datastudio.google.com/u/1/navigation/templates">Galería de plantillas</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=332d8c6890ff" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Personalización de dashboard en Data Studio]]></title>
            <link>https://medium.com/@albermard/personalizaci%C3%B3n-de-dashboard-98aecc166054?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/98aecc166054</guid>
            <category><![CDATA[google-data-studio]]></category>
            <category><![CDATA[espanenglish]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Thu, 31 Mar 2022 10:01:15 GMT</pubDate>
            <atom:updated>2022-03-31T10:51:15.301Z</atom:updated>
            <content:encoded><![CDATA[<h4>Introducción a Google Data Studio — Parte 3</h4><p>El principal objetivo de un dashboard es facilitar la representación de datos. Idealmente, buscamos crear gráficos atractivos y ricos en información. Diseñar un tablero, es un proceso intelectual pero también creativo en el que podemos tomar ventaja del uso de colores, fuentes y elementos interactivos.</p><h3><strong>Tema y diseño (Theme and Layout)</strong></h3><p>La opción rápida es seleccionar temas pre-diseñados por Data Studio. La aplicación nos permite elegir entre varias paletas de colores y modificar valores relacionados al encabezado, margen, alineación, etc.</p><ul><li>Explora los temas disponibles y elige uno de tu preferencia.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*doarTsBU4srW5qce5z2wwg.gif" /><figcaption>Temas</figcaption></figure><h3><strong>Estilo de gráficos</strong></h3><p>Dependiendo del gráfico, distintas variables pueden ser modificadas para cambiar el estilo a conveniencia. Entre las posibles opciones podemos destacar:</p><ul><li>Cambiar colores en que los datos se representan</li><li>Ajustar posición de títulos y leyendas</li><li>Cambiar fuentes</li><li>Agregar o remover texto (Títulos, nombre de ejes…)</li></ul><p>El estilo puede ser modificado de la siguiente forma:</p><ol><li>Click en el gráfico de interés</li><li>En la barra lateral derecha, seleccionar la pestaña STYLE</li><li>Modificar los valores a conveniencia.</li></ol><p>A continuación, presentamos un ejemplo para modificar el estilo de la Tarjeta de puntuación(Scorecard):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Q15qv9c8vO8dVOkSiz9vgQ.gif" /></figure><h3><strong>Modificar gráficos previamente creados</strong></h3><p>En algunos casos, luego de crear un gráfico puede que necesitemos mejorar su apariencia para representar los datos de una forma más amigable para el usuario. En general, al hacer click en el gráfico que se desea modificar, aparece la barra lateral derecha y con ella las distintas opciones para modificar Data, Style o tipo de gráfico.</p><p>Por ejemplo:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EW07Eb1RhvdvFmrK3sRLtg.gif" /><figcaption>Cambiar tipo de gráfico</figcaption></figure><blockquote>Tip: Cuando diseñes un tablero, siempre ten en mente al usuario y la forma en que va a interactuar con los datos. Imagina que la información va a ser presentada al CEO de una firma global que debe tomar decisiones en base a los valores presentados en el dashboard. Al CEO le gustaría, leer toda la información necesaria cada mañana mientras se toma un café.</blockquote><h3><strong>Ejemplo: Personalización de mapa</strong></h3><p>La visualización del mapa de Venezuela y los puntos representando distintas Parroquias es muy atractiva para el usuario. Podemos representar más información en el mismo gráfico ? Sí! Por ejemplo, podemos asignar un color distinto a cada estado del país.</p><ul><li>Click en el gráfico del mapa</li><li>En el panel derecho, pestaña Data dirígete a la opción Tooltip</li><li>Arrastra el campo Entidad Federal y suéltalo en el área Color Dimension</li><li>Luego de unos segundos, el mapa se actualiza asignando un color distinto a cada estado.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GcQp-sFlmQmrM_f6VZZeDA.gif" /></figure><p>En el mapa, también podemos modificar el tamaño de las burbujas según deseemos. Digamos que queremos enfatizar las Parroquias en dónde el servicio de agua tiene una frecuencia de Una vez Cada Quince Días, podemos asignar burbujas de mayor tamaño en las regiones más afectadas.</p><ul><li>Click en el gráfico del mapa</li><li>En el panel derecho, pestaña Data dirígete a la opción Tooltip</li><li>Arrastra el campo Una vez Cada Quince Días y suéltalo en el área Size</li><li>Luego de unos segundos, el mapa se actualiza con burbujas de diferentes dimensiones.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FAuvOfKek0HJz7oLwdGbrg.jpeg" /></figure><h3><strong>Agregar Texto e imágenes</strong></h3><p>También podemos personalizar el dashboard agregando imágenes almacenadas en nuestro ordenar o publicadas en un sitio web. La información puede ser complementada con texto para indicar un título por ejemplo.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SZ3V3_zSYBqo8b_SZD6rnA.gif" /><figcaption>Agregar imagen</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wF3FOP8Qt8X0mPOZ2D_jFQ.gif" /><figcaption>Agregar texto</figcaption></figure><p>Luego de agregar la información, siempre puedes modificar la posición de los distintos elementos para presentar el tablero según preferencias.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*K9oksGdXy2LK2sNlwuRPkg.jpeg" /></figure><h3><strong>Agregar página</strong></h3><p>El tablero puede constar de varias páginas, especialmente en casos donde el objetivo es crear reportes completos y detallados de la información.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4nwkStdFFrJy78BndVZ63Q.gif" /><figcaption>Agregar página</figcaption></figure><p><strong>Buen trabajo! Estás listo para el siguiente reto 😄</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=98aecc166054" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Tu primer dashboard en Google Data Studio]]></title>
            <link>https://medium.com/@albermard/tu-primer-dashboard-44f10769e04?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/44f10769e04</guid>
            <category><![CDATA[espanenglish]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[google-data-studio]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Thu, 31 Mar 2022 09:43:33 GMT</pubDate>
            <atom:updated>2022-03-31T11:00:13.719Z</atom:updated>
            <content:encoded><![CDATA[<h4>Introducción a Google Data Studio — Parte 2</h4><p>Luego de generar la fuente de datos y crear el informe, estamos listos para representar gráficamente los datos. La vista inicial del informe puede variar de tu configuración, pero en general podemos identificar las siguientes regiones:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Z9ZTfBURcBSnRW43sGJv6A.jpeg" /><figcaption>Regiones de interés para construir tableros en Google Data Studio</figcaption></figure><p>En este capítulo vamos a explorar las principales funciones para construir un dashboard en Data Studio y ejemplos de gráficos. Puedes seguir los ejemplos para familiarizarte con la herramienta. También tienes toda libertad de diseñar el tablero de la forma que te parezca más conveniente para contar la historia detrás de los datos.</p><h3><strong>Tu primer gráfico</strong></h3><p>Para facilitar el trabajo, la aplicación nos permite arrastrar y soltar (drag and drop) los campos de interés en el área de diseño. Por ejemplo, si arrastramos el campo Direccion cuyo formato fue definido previamente como Geo , Data Studio generará automáticamente un gráfico que se ajuste a representar los datos.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BSj6GUACICLZ7JUhbOqF7w.gif" /><figcaption>Arrastrar y soltar campos para generar visualizaciones</figcaption></figure><p>Luego puedes arrastrar el gráfico y ajustar las dimensiones según prefieras.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Er2gMWnwb4R4ync4r8C2rg.gif" /><figcaption>Ajustar dimensiones</figcaption></figure><p>Una de las ventajas de trabajar con datos de tipo Geo en Data Studio es que la herramienta ofrece integración directa con Google Maps. Por ejemplo, podemos visitar virtualmente el monumento a la Virgen de la Paz o el mar Caribe.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-ftHqAYSOgsw7gPvVoG4Tg.gif" /><figcaption>Conexión de datos con Google Maps</figcaption></figure><h3><strong>Tabla de datos</strong></h3><p>Una buena práctica antes de generar gráficos, es previsualizar en una tabla los datos de interés, esto nos permite asegurar que los campos y valores de interés son correctamente representados. Además en otras ocasiones también puede ser útil presentar los datos en tablas. El panel de herramientas Data ubicado a la derecha del tablero incluye distinto campos entre los que destacan Dimension y Metric. En gran parte de los casos, estos serán los campos fundamentales para generar una tabla o gráfico, dependiendo de la complejidad del gráfico, la aplicación indicará más opciones.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JBtUxjXwzI0YBS2afXLH_g.gif" /></figure><h3><strong>Gráficos (Charts)</strong></h3><p>Data Studio ofrece distintas opciones entre las cuales podemos elegir a conveniencia. Para visualizar las opciones, click en Add chart (Agregar Gráfico)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WyIsKVJW_wozLLV2gjnR8w.gif" /><figcaption>Agregar gráficos en Data Studio</figcaption></figure><h3><strong>Gráfico de barras</strong></h3><p>A continuación, vamos a construir un gráfico de barras. En este caso vamos a comparar la frecuencia de servicio de agua por estado del país y observar la relación de hogares que reciben el servicio de agua todos los días en comparando con el total de encuestados.</p><p>Campos a graficar:</p><ul><li>Dimension: Entidad Federal</li><li>Metrics: Total , Todos los días</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hjsoeQit05APIqjeyOR5iA.gif" /><figcaption>Gráfico de barras</figcaption></figure><h3><strong>Filtrar datos en gráficos</strong></h3><p>En algunas ocasiones, visualizar mucha información puede desviar la atención de nuestra audiencia. Por ejemplo, en el caso del gráfico de barras previamente creado, se muestran diez estados pero es difícil leer a simple vista cuáles. Aplicaremos un filtro al gráfico para presentar gráficamente sólo los tres estados con la mayor cantidad de hogares encuestados.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5l3noIZQY_GCm24wIZCp7w.gif" /><figcaption>Filtro para gráfico de barras</figcaption></figure><h3><strong>Controles</strong></h3><p>El dashboard empieza a tomar forma pero hasta ahora estamos representando toda la información en el mapa. En ocasiones, es más conveniente para los usuarios buscar y representar valores de interés. Por ejemplo, podemos comparar la frecuencia del servicio de agua en Mérida vs Nueva Esparta ?</p><p>En este caso, el uso de controles, brinda a los usuarios de nuestro tablero la capacidad de visualizar los valores de mayor interés.</p><p>Campos a utilizar para controles:</p><ul><li>Entidad Federal</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*auQisLrPyDcKr57LcyfoPw.gif" /></figure><h3><strong>Indicadores</strong></h3><p>Imagina que queremos un indicador para evaluar la calidad del servicio y decidimos visualizar la relación de hogares que recibe agua todos los días. Podemos representar esto con un gráfico similar al indicador del nivel de gasolina de un carro, lo que nos facilita visualizar rápidamente cuán lejos o cerca estamos del valor ideal.</p><p>Campos a utilizar para el indicador:</p><ul><li><strong><em>Tipo de gráfico</em>:</strong> Gauge (Indicador)</li><li><strong><em>Data Range Dimension</em></strong><em>:</em> Total</li><li><strong><em>Metric:</em></strong> Todos los días</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KyD_LWEL7OD3HAE-7fSG6A.gif" /></figure><p>Ahora, queremos agregar otro indicador pero esta vez para representar mala calidad en el servicio, utilizaremos de nuevo un indicador pero de color rojo para advertir visualmente la cantidad de hogares que reciben agua Una vez cada quince días</p><p>Campos a utilizar para el indicador:</p><ul><li><strong><em>Tipo de gráfico</em></strong>: Gauge (Indicador)</li><li><strong>Data Range Dimension:</strong> Total</li><li><strong><em>Metric:</em></strong> Una vez cada quince dias</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*17wmTgu1RP1TiYTFevet0g.gif" /></figure><h4>Personalización adicional de indicadores:</h4><p>El indicador puede ser complementado agregando rangos (range) y un valor objetivo (target). Puedes seleccionar el indicador de interés y luego definir en style (estilo) los rangos que desees fijar o el target de interés (para ello puedes habilitar la opción show target disponible en el menú style del indicador).</p><p>También podemos complementar los indicadores agregando una Tarjeta de puntuación(Scorecard), por ejemplo para representar el total de viviendas que forman parte de la muestra.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qzg88kF4TS97CdC6OhdMiA.gif" /><figcaption>Scorecard</figcaption></figure><h3><strong>Ejercicios adicionales:</strong></h3><ul><li><strong>Reto 1:</strong></li></ul><p>Modifica el gráfico de barras para mostrar la frecuencia de servicio de agua, total, todos los días y cada dos o tres días.</p><p>Elige un estado del país y utiliza el controlador para visualizar la información que corresponde sólo a ese estado. Por ejemplo, para Nueva Esparta, se puede observar que más de 9.000 hogares reciben el servicio de agua una vez cada quince días y que en la mayoría de los hogares la frecuencia del servicio es de cada dos o tres días.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cGfX8ziHySO-7obCwUYRiA.jpeg" /></figure><ul><li><strong>Reto 2:</strong></li></ul><p>Podemos brindar a los usuarios, la posibilidad de seleccionar Entidad Federal, Municipio , Parroquia. Para ello, sólo necesitas agregar controladores adicionales.</p><p>Intenta agregar dos controladores extra, la siguiente imagen muestra un ejemplo de cómo luce el tablero actualizado:</p><ul><li><strong><em>Tipo de controlador :</em></strong> Drop-down list</li><li><strong><em>Campos de control (Control Field):</em></strong> Municipio y Parroquia</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WXkoEGu0jPpZxe31ZMnStQ.jpeg" /></figure><p><strong>Felicitaciones!</strong></p><p>Has construido tu primer tablero en Google Data Studio</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fgiphy.com%2Fembed%2FfvT39aAmEvCJi3Bgsf%2Ftwitter%2Fiframe&amp;display_name=Giphy&amp;url=https%3A%2F%2Fmedia.giphy.com%2Fmedia%2FfvT39aAmEvCJi3Bgsf%2Fgiphy.gif&amp;image=https%3A%2F%2Fi.giphy.com%2Fmedia%2FfvT39aAmEvCJi3Bgsf%2Fgiphy.gif&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=giphy" width="435" height="435" frameborder="0" scrolling="no"><a href="https://medium.com/media/fc41bfcca4517eace0ce9c5f62e2ac98/href">https://medium.com/media/fc41bfcca4517eace0ce9c5f62e2ac98/href</a></iframe><p><strong>Estas listo para continuar con la tercera parte del tutorial:</strong></p><p><a href="https://medium.com/@albermard/personalizaci%C3%B3n-de-dashboard-98aecc166054">Personalización de dashboard en Data Studio</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=44f10769e04" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Introducción a Google Data Studio (Parte 1)]]></title>
            <link>https://medium.com/@albermard/introducci%C3%B3n-a-google-data-studio-parte-1-120c1b1ece70?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/120c1b1ece70</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[datos]]></category>
            <category><![CDATA[espanenglish]]></category>
            <category><![CDATA[google-data-studio]]></category>
            <category><![CDATA[dashboard-design]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Thu, 31 Mar 2022 09:13:54 GMT</pubDate>
            <atom:updated>2022-03-31T10:58:20.960Z</atom:updated>
            <content:encoded><![CDATA[<h3>Introducción a Google Data Studio — Parte 1</h3><h4>Tutorial para crear dashboards en Google Data Studio</h4><p>Google Data Studio es una herramienta para desarrollar informes visuales usando herramientas en línea y disponibles para usuarios con cuentas de Gmail.</p><p>Data Studio nos permite diseñar y compartir tableros (Dashboards), donde la data es presentada con gráficos que evocan la atención y facilitan la lectura de la información más relevante.</p><h3><strong>Tu primer tablero en Google Data Studio</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*e3SGdUVtB0bKWoUit0h19A.gif" /></figure><h3><strong>Fuentes de datos (Data Source)</strong></h3><p>Un factor fundamental para la construcción de tableros, es contar con datos organizados y almacenados electrónicamente.</p><p>Data Studio nos permite conectarnos con distintas fuentes de datos entre los que podemos destacar:</p><ul><li>Google sheets (Hojas de datos de Google) almacenadas en Google Drive</li><li>Bases de datos SQL (Structured Query Language)</li><li>Google Analytics, Google Ads, Google Surveys, Youtube Analytics</li></ul><h3><strong>Crear fuente de datos</strong></h3><h4><strong>Cargar datos a Google Drive:</strong></h4><p>Para fines de este ejercicio, nos vamos a enfocar en crear una fuente de datos a partir de información estructurada en Google Sheets o en una hoja de Excel. Trabajaremos con datos publicados por el INE (Instituto Nacional de Estadísticas) en 2011, con la intención de medir la frecuencia de acceso al agua en los hogares Venezolanos.</p><p>Pasos a seguir:</p><ul><li>Abrir Google Drive y crear una carpeta dedicada a tu proyecto en Google Data Studio. Ejemplo: Mi_primer_dashboard</li><li>Abrir la carpeta Mi_primer_dashboard y <a href="https://github.com/nedraki/Tutorial_Google_Data_studio_Spanish/blob/main/data/Frecuencia_Servicio_Agua.xlsx">cargar el archivo de excel </a><a href="https://github.com/nedraki/Tutorial_Google_Data_studio_Spanish/blob/main/data/Frecuencia_Servicio_Agua.xlsx">Frecuencia_Servicio_Agua.xlsx</a></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*zYTW4EI8DI8OV2_Oz_33oA.gif" /></figure><ul><li>Abrir el archivo de Excel usando hojas de cálculo de Google (Google Sheets)</li><li>Guardar el archivo pero ahora en el formato Google Sheets.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/592/1*p05Z0NhUskPb3E30Nit4Hw.jpeg" /></figure><h4><strong>Conectar datos con Google Data Studio</strong></h4><p>Luego de completar los pasos previos, podemos ir la <a href="https://datastudio.google.com/">página de Google Data Studio</a> y crear la fuente de datos. Trabajar con la data almacenada en Google Drive nos permite ciertas ventajas entre las que destacan:</p><ul><li>Los datos son almacenados online</li><li>Distintos usuarios con permisos a leer o modificar la data pueden tener acceso a la información</li><li>La fuente de datos, se puede actualizar automáticamente cada cierto tiempo</li><li>El dashboard creado a partir de la fuente de datos puede ser compartido y visualizado on-line</li><li>Facilidad de conexión con productos de Google.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3FwLZLMS3z6jl3KumRvu-Q.gif" /></figure><p>Buscamos el archivo Frecuencia_Servicio_Agua y lo seleccionamos.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/908/1*ml1CzlKZQRGPk-QOaqHFpw.jpeg" /></figure><p>Luego generamos la conexión y después de unos segundos, Data Studio muestra una vista previa de la estructura de la data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rGJdLMRdK-lfUGSraFuDiA.gif" /></figure><h3><strong>Editor de fuente de datos</strong></h3><p>Dediquemos un momento a explicar en detalle los valores mostrados justo después de conectar con la hoja de datos:</p><ul><li><strong>Field (Campos)</strong>: Representa cada uno de los campos encontrados. En este caso, existen un total de 11 dimensiones que representan cada columna en la hoja de datos.</li><li><strong>Type</strong>: Indica el formato en que los datos son interpretados, por ejemplo el campo Cada Dos o Tres Díases interpretado como tipo number o Países tipo Geo .</li><li><strong>Default Aggregation</strong>: Representa operaciones matemáticas aplicadas a los datos para facilitar su representación, por ejemplo sum puede representar la suma de todos los habitantes que reciben el servicio de agua en una ciudad en particular.</li><li><strong>Description</strong>: Permite explicar con mayor detalle los campos.</li></ul><p>Ahora, pasamos a editar algunos campos a conveniencia, brindando especial atención al formato Type en que la data es interpretada. Indicar el tipo correcto de data, facilita el trabajo al momento de construir el tablero.</p><ul><li>Modifica el formato de los datos y su descripción para obtener un resultado como el mostrado a continuación:</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CWmpDAH3UVMUDR6f1hR47g.jpeg" /></figure><ul><li><em>Cómo modificar el formato de los datos ?</em></li></ul><p><em>Puedes seleccionar el formato de los datos a conveniencia, </em><em>Currency , </em><em>Text, </em><em>number, </em><em>Geo (moneda, texto, número, geo, etc). Particularmente el formato </em><em>Geo, facilita la conexión con servicios de Google Maps</em>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QpSzc2Ex2-ZepKOjQfY2ig.gif" /></figure><h3><strong>Crear informe</strong></h3><p>Una vez que el formato de datos ha sido modificado, click en Create reportpara dar inicio al diseño del reporte.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/696/1*gbxbEVUr_RW4Oq4qoWkHug.jpeg" /></figure><p>Luego debemos autorizar a la aplicación a conectarse con los datos:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uxyMKGI2TLxRXyyS11aeCQ.jpeg" /></figure><p>Finalmente, actualiza el nombre del tablero a preferencia, por ejemplo “<em>Venezuela: Frecuencia Servicio Agua”</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*m7hLwuyl9QslMY4XnDXf6g.jpeg" /><figcaption>Cambiar nombre de dashboard</figcaption></figure><p><strong><em>Oficialmente, has completado los primeros pasos para crear un dashboard en Google Data Studio.</em></strong></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fgiphy.com%2Fembed%2Far4x1w44umngk%2Ftwitter%2Fiframe&amp;display_name=Giphy&amp;url=https%3A%2F%2Fmedia.giphy.com%2Fmedia%2Far4x1w44umngk%2Fgiphy.gif&amp;image=https%3A%2F%2Fi.giphy.com%2Fmedia%2Far4x1w44umngk%2Fgiphy.gif&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=giphy" width="435" height="217" frameborder="0" scrolling="no"><a href="https://medium.com/media/4e9b065fa585aecb43f1f19366b40395/href">https://medium.com/media/4e9b065fa585aecb43f1f19366b40395/href</a></iframe><p><strong><em>Estas listo para el siguiente reto ?</em></strong></p><p><a href="https://medium.com/@albermard/tu-primer-dashboard-44f10769e04">Tu primer dashboard en Google Data Studio</a></p><p><strong>Acerca de los datos: INE (Instituto Nacional de Estadística)</strong></p><ul><li><a href="http://www.ine.gov.ve/index.php?option=com_content&amp;view=category&amp;id=95&amp;Itemid=9">Datos demográficos acceso a servicios</a>: Frecuencia de acceso al servicio de agua. INE, 2011.</li><li>Los datos fueron pre-procesados para facilitar su uso en Google Data Studio, el archivo puede ser descargado <a href="https://github.com/nedraki/Tutorial_Google_Data_studio_Spanish/blob/main/data/Frecuencia_Servicio_Agua.xlsx">en el siguiente link</a>.</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=120c1b1ece70" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Money printing and economy]]></title>
            <link>https://medium.com/@albermard/understanding-inflation-11ef4b6a1542?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/11ef4b6a1542</guid>
            <category><![CDATA[usd]]></category>
            <category><![CDATA[venezuela]]></category>
            <category><![CDATA[ray-dalio]]></category>
            <category><![CDATA[economics]]></category>
            <category><![CDATA[inflation]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Thu, 10 Mar 2022 11:19:46 GMT</pubDate>
            <atom:updated>2022-03-13T08:06:07.853Z</atom:updated>
            <content:encoded><![CDATA[<h4>Why inflation happens and why is it important to know about it</h4><p>In a very straightforward approach, a pragmatical way of understanding the effects that inflation has in people’s lives is to look (or live) in a country facing it. I will present some experiences after living in Venezuela but also a description from experts in economics.</p><p>If you want the short description, inflation can be described as a tragic act of magic that vanishes your money and life effort.</p><h3>Living in a country with hyperinflation</h3><p>Venezuela is my home country but also the place where a cocktail of wrong economic and political policies created the worst episodes of <strong>hyperinflation </strong>we have seen in this young century. Inflation and economic indicators were so bad that at a certain moment the government did not bother in measuring the monthly inflation rates at all but estimations from the IMF reached the bold number of 1.000.000 % (yes, one million percent).</p><p>One million percent inflation is an incomprehensible number that will never reflect the real pain that caused in people&#39;s lives. Think of my grandparents who dedicated most of their adult life working and saving to provide shelter and education to the family, a middle-class family who made their absolute best within the opportunities they had. Worked, sent kids to school, bought land, built a house, paid their monthly social security contribution, the things that a functional society expects from its citizens.</p><p>Then the decade 2010–2020 arrives, it is their time to retire, to enjoy time with family, spoil the grandkids but with retirement, comes the inflation: 2%, 20%, 100%, 1.000.000%. Suddenly all the money they could have saved on a lifetime has vanished, the money is still there but now there’s nothing they could afford with it, the monthly pension that once could afford a decent standard of living, now it’s worthless, the prices never stopped increasing but the income was always the same.</p><p>The photographer Carlos Garcia Rawling made a<a href="https://widerimage.reuters.com/story/venezuelans-rush-to-shops-before-monetary-overhaul"> brilliant visual comparison</a> that may help you understand how hyperinflation looks like.</p><p>There is a cocktail of wrong economic policies that lead to this hyperinflation, but in a nutshell, we could enumerate:</p><ul><li>A Significant decrease in internal productivity. For example, the oil industry passed from producing 3.5 million barrels per day to roughly 0.5 million in 2020.</li><li>A sharp decrease in income denominated in foreign currency.</li><li>A sharp increase in debt denominated in foreign currency.</li><li>A central bank printing massive amounts of local currency. Inorganic money without guarantees to be traded for foreign currencies and not invested on increasing the internal productivity.</li></ul><p><a href="https://tradingeconomics.com/venezuela/crude-oil-production">Venezuela Crude Oil Production - February 2022 Data - 1973-2021 Historical</a></p><h3>Inflation, a definition from the experts</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*UO-gVcdNmFek0LVg" /><figcaption>Photo by <a href="https://unsplash.com/@moraisr?utm_source=medium&amp;utm_medium=referral">Rita Morais</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>These are deep waters, so the best way to navigate them is by reading and sharing the opinion of the experts. <a href="https://en.wikipedia.org/wiki/Ray_Dalio">Ray Dalio</a> in his book <em>The changing world order, </em>wrote:</p><blockquote>There is both a <strong>real economy</strong> <strong>and a financial economy. </strong>Though they are related they are different.</blockquote><blockquote>In the real economy, when the level of goods and services demanded is strong and rising and the capacity to produce those things demanded is strong and rising and the capacity to grow is limited, <strong>the real economy’s capacity to grow is limited and, if demand keeps rising faster than the capacity to produce, inflation rises.</strong></blockquote><blockquote><strong>In the financial economy, normally money and credit are created by central banks and flow into financial assets</strong>, which produces lending that finances people’s borrowing and spending. When the money and credit that central banks are creating no longer go into lending, that fuels increases in economic demand and instead go into other currencies and inflation-hedge assets, it fails to stimulate economic activity and instead causes the value of the currency to decline and the value of inflation-hedge assets to rise. At such times high inflation can occur because the supply of money and credit has increased relative to the demand for it, which we call<strong> monetary inflation</strong>.</blockquote><h3>Inflation in the United States</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*JCy1VqwmZYpX9uc3" /><figcaption>Photo by <a href="https://unsplash.com/@rrrob_?utm_source=medium&amp;utm_medium=referral">Rob</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>I presented the example of Venezuela and we could explore other recent inflationary events like Argentina but maybe you are from the United States and can not imagine the first economy in the world would make decisions on economic policy leading to inflation.</p><p>The United States also prints money, the same happens in the European Union and basically any central bank has the power to do so. You could judge by looking at the history, that printing money will likely create inflation. Despite the consequences, governments will still prefer to take this measure because in the short term is less painful for the citizens, a clear and recent example can be seen after the economic measures taken during and after the pandemic to stimulate the economy. Money printing is masked with the term <a href="https://www.investopedia.com/terms/q/quantitative-easing.asp#citation-20">“Quantitative easing”</a> and it does create inflation, especially when the newly created money is not invested in ways that can increase productivity.</p><p>Now, for the particular case of the U.S, the inflationary effects of printing money are not perceived totally inside the United States but around the world. The reason is <strong><em>the USD is a reserve currency</em></strong>, a significant quantity of countries in the world, save their money in U.S dollars, most of the U.S dollars in circulation, are actually outside the United States. In consequence, the increase in prices does not hit directly the United States but any USD holder across the world. <a href="https://tim.blog/2021/10/28/chris-dixon-naval-ravikant-transcript/">Naval Ravikant, explained this very well during an interview with Tim Ferris:</a></p><blockquote>The beauty of our model is that the entire world uses the US dollar as its stable currency as its ultimate stable coin. <strong>And so every time we print a dollar, 70 cents of that dilution, that inflation goes overseas, but that’s eventually going to go away.</strong> We can’t just keep printing our way out of problems. We actually have to create, we have to innovate. We have to improve productivity. And that means that the next generation of technological innovation has to be based here where they can pay their taxes, where they want to live and spend and eat and consume here. Naval Ravikant</blockquote><h3>How do you explain inflation to a five years old kid?</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*4E2L4N-ipugVNHVf" /><figcaption>Photo by <a href="https://unsplash.com/@ross_sokolovski?utm_source=medium&amp;utm_medium=referral">Ross Sokolovski</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Inflation is an act of magic where the money melts like ice cream on a summer day, if you don’t eat it fast, after a short period of time your ice cream will still be there but transformed into something else that won’t hold any value. There is a second act in the magic show, once you go back to buy another ice cream, the vendor will ask you to pay more money but with luck will give you the exact same quantity and flavor, although you should always expect less.</p><h3>A final note: Defense against the Dark Arts</h3><blockquote><strong>When central banks print a lot of money, buy stocks, gold and commodities. <em>Ray Dalio</em></strong></blockquote><ul><li>Distrust a government that hides official statistics related to inflation.</li><li>It’s better to keep your savings in a reserve currency rather than in a weak local currency.</li><li>If you benefit from receiving freshly printed money, look for ways to invest it into sources that increase productivity. The world needs more entrepreneurs.</li></ul><p>Keep learning and keep reading, in my opinion, the publications from Ray Dalio “The Changing World Order” and “How to navigate big debt crisis” are very strong sources of information compelling history and experience from top performers professionals in the field of economics.</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fxguam0TKMw8%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dxguam0TKMw8&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fxguam0TKMw8%2Fhqdefault.jpg&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/52f990c3392a4a4d6c780e43b9223c31/href">https://medium.com/media/52f990c3392a4a4d6c780e43b9223c31/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=11ef4b6a1542" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How someone used my Google cloud account for mining cryptocurrency]]></title>
            <link>https://medium.com/@albermard/how-someone-used-my-google-cloud-account-for-mining-cryptocurrency-64b8403d228c?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/64b8403d228c</guid>
            <category><![CDATA[google-cloud]]></category>
            <category><![CDATA[google-cloud-platform]]></category>
            <category><![CDATA[python-programming]]></category>
            <category><![CDATA[cybersecurity]]></category>
            <category><![CDATA[criptocurrency]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Mon, 07 Jun 2021 10:33:35 GMT</pubDate>
            <atom:updated>2021-06-07T10:33:35.584Z</atom:updated>
            <content:encoded><![CDATA[<p>I’m relatively new in the coding world and certainly a rookie on the use of cloud services, so I decided to get hands-on, practice, and learn to use Google Cloud. I could share a tutorial on <em>“How to do &lt;a cool task&gt; using Python and Google cloud”</em> but I think there’s a lot more you can learn from my silly mistakes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/783/1*rtz3A_zIZ17EX66Px18Pvg.png" /></figure><p>The story started after deciding that I needed to practice beyond the <a href="https://go.qwiklabs.com/qwiklabs-free">Qwiklabs challenges</a> designed to help you prepare for getting a G-cloud certification (the access is free in case you want to level up skills). I mostly learn on a project-oriented approach, so I signed up for $300 free credits and started working on a demo project for audio transcription using Google’s API for Speech recognition.</p><p>I wrote my cool code and the application was working quite well until I started receiving alerts and a surprising email:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/673/1*0is5Wf473hKKsZ4Y0uJ3Wg.png" /></figure><p>Cool Google, I do support blockchain technologies but I think you made a mistake, I’m just using your API for Speech recognition.<strong> </strong><em>By the way, I did not read the Terms of Service, do people really read them?</em></p><h3>Time to learn from the mistakes</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jiakZcPjHeAoQW9-" /><figcaption>Photo by <a href="https://unsplash.com/@craftedbygc?utm_source=medium&amp;utm_medium=referral">Green Chameleon</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Google was right, <strong>on the project, I could see two virtual machines for mining </strong><a href="https://www.getmonero.org/"><strong>Monero</strong></a><strong>, a cryptocurrency that can be mined using CPU</strong>. <strong>The API was intended to use AI for transcribing podcasts in French,</strong> <strong>but someone found my private keys on Github and use them for other purposes.</strong></p><p>If you are judging me for being so noob to push a private API key to a public Github repository, no need to scroll down, you probably know how to avoid these silly errors.</p><h4>Now, for the rookies :</h4><p>Among the first things I noticed when I connected to my account to verify the reason why my app was suspended, was a message in the dashboard indicating I reached the limit of CPUs usage. However, my app was not designed to run VM instances, rather my code was a disaster or someone else created them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YhCEnIjCVVUzB9T0C3nasA.png" /></figure><p>I wrote the code on Jupyter notebooks, which are really helpful in the first stages of developing a project, I was aware of the importance of the private keys and I made sure not to push the notebooks with sensitive information.</p><p><strong>So, what do you think went wrong?</strong></p><ol><li>I never push the .json file containing the API private keys but…</li><li>The API keys were not hidden in the PATH environment of my PC.</li><li>I pushed to a public repo</li><li>I did not realize an important thing: the content of ipynb.checkpoints</li><li>The .json file with the private keys was specifically named api-key.json</li></ol><p>Usually, checkpoints are helpful to save your progress while coding on notebooks but in this case, it played against me. I did not gitignore the folder containing the checkpoints and it turns out that Jupyter notebooks are saving checkpoints of the notebooks but also of the files read by. As a result, I pushed to a public repo the folder ipynb.checkpoints containing the holy file api-key-checkpoint.json.</p><blockquote>After reading this, you can understand I left the work fairly easy for anybody interested in dishonestly using my API keys. <strong>As a simple lesson, if you want to avoid making the same mistakes, don’t do the things I previously listed.</strong></blockquote><h3>A walk through what the stealer did with my credentials</h3><p>Let’s call the person who took my private API key “Stealer”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4jWKzalR8fI_M1TZ9Gh6pQ.png" /><figcaption>Virtual machines created by Stealer</figcaption></figure><ul><li><strong>Stealer created two virtual machines with the following specs:</strong></li></ul><ol><li>8 vCPUs, 30 GB memory, running Ubuntu and located on asia-south1-b</li><li>16 vCPUS, 60 GB memory, running Ubuntu and located on asia-south1-b</li></ol><ul><li><strong>Where is it the zone</strong><strong>asia-south1-b specifically, located?</strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WlQzQkBxgGB6mVaeWus-6Q.png" /><figcaption>Regions and zones, Google Cloud</figcaption></figure><p>As you can see, Stealer created the VM to operate on Google’s servers located in Mumbai (India), which could be an indicator that the core crypto mining activities are somewhere close to the city.</p><ul><li><strong>What script was run on the virtual machines (VMs)?</strong></li></ul><p>The great thing about Google: it knows everything. Additionally to the previous information, I was able to read the first script executed on the VMs. I’ll share some lines with valuable information to extract:</p><pre># A few lines of code later...<br>cd /tmp<br><strong>git clone </strong><a href="https://github.com/xmrig/xmrig"><strong>https://github.com/xmrig/xmrig</strong></a><strong> xmrig_tmp<br></strong>cd xmrig_tmp</pre><p><strong>Surprise, surprise. Stealer is cloning a repo for mining Monero.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*w9I50i2MZOjMzek1yBv5Ag.png" /></figure><p>In addition, it can be read on the code the use of VirtualAddrNetwork, a .sshconnection to a mining pool, and what seems to be Stealer’s Monero wallet address. I was looking forward to extracting more information by reading on the blockchain the information associated with the wallet, to know, for example, the transactions on that day and the balance of the account. This is possible with cryptocurrencies like Bitcoin or Ethereum by <a href="https://www.etherchain.org/txs">exploring the blockchain record</a>s, however, in the case of Monero, the cryptocurrency is designed for privacy on the funds you hold.</p><p>Stealer did a good move by selecting Monero as his cryptocurrency considering how dishonest could be his work, but still, I wanted to learn more details, for example, how much XMRs could be mined with the VMs created.</p><p><strong>A quick look to potential profit:</strong></p><p>Some websites provide estimations on average monthly income for mining, for an exact calculation we need the CPU’s hash rate, I ignore the performance that a VM can have on these mining algorithms but at least we can have a baseline with the available data:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bd9cmgbH0V3iOzrgqWLLKA.png" /><figcaption>Estimated monthly revenue mining Monero with top CPUs (June 2021)</figcaption></figure><p>As you can see, mining with a top CPU of 32 cores produces around USD 50 per month but the chance of running computer-intensive crypto-mining algorithms in Google Cloud is really low. Google actively tracks this kind of operation to protect their servers, after my credentials were compromised, in less than an hour my account was suspended, which means that Stealer was not able to mine a significant amount (probably less than one cent).</p><ul><li><strong>Some resources and good practices to protect your API keys:</strong></li></ul><p>For getting started, <a href="https://antony-s-smirnov.medium.com/">I believe this pos</a>t from <a href="https://medium.com/u/a60cd582fdec">Anton Smirnov</a> offers good tips for securely stored your API Keys, it’s nicely explained and easy to follow.</p><p>Another resource worths checking is <a href="https://www.gitguardian.com/">GitGuardian</a>, a tool designed to detect leaked API keys on GitHub repositories. I did not know about the tool and I haven’t used it yet, however, I received an email notification from them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/689/1*OQ9SNQjnqP51cl7JOLT0Uw.png" /><figcaption>Notification sent by GitGuardian after pushing a Google cloud key to Github</figcaption></figure><p>This means for me that GitGuardian is actively monitoring GitHub activity and they are acting as a sort of “White Hat Hacker” to help you protect the secrets of your coding projects.</p><ul><li>It took almost two hours from the moment I pushed to GitHub until the moment I received the alert from GitGuardian.</li><li>Google Cloud suspended the activity on my project three hours after I pushed the secret to Github.</li><li>If Stealer relies on a monitoring system similar to the one of GitGuardian, it means he had a window of one hour to steal the API keys and use them before Google suspended the project for misuse.</li></ul><h4>Final notes for Rookie and Stealer:</h4><p>Dear Rookie coder, I hope you can learn something from this experience, go and fail but fail well, it is a learning journey.</p><p>Dear Stealer, I believe you are talented and understand coding, go and use those skills not to scrap private APIs from a GitHub repo but to work for a tech company or maybe your own startup. You could make fare more than a few cents and it’s an honest job. Anyway, thanks for the lessons, I’m a more experienced coder now.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=64b8403d228c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[A brief history of 3D Printing]]></title>
            <link>https://medium.com/nedraki/a-brief-history-of-3d-printing-dd5e55f13c46?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/dd5e55f13c46</guid>
            <category><![CDATA[4th-industrial-revolution]]></category>
            <category><![CDATA[3d-printing]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Sun, 21 Jun 2020 22:13:28 GMT</pubDate>
            <atom:updated>2021-07-31T11:30:05.857Z</atom:updated>
            <content:encoded><![CDATA[<h3>A brief history of additive manufacturing</h3><p>Today millions of users enjoy the benefits of a 3D printer. But, how did this happened?</p><p>Additive manufacturing (AM) belongs to 4th industrial revolution’s technologies, it allows to obtain either products or prototypes from 3D digital models. With such an important development the AM has get to domestic environments, it means that more people can involve in the manufacturing of functional products or prototypes models with one process and getting great superficial finished. Because of this, worldwide, 3D printing platforms had been created to allow users download digital models ready to print, they also share their experiences printing and upload tutorials for amateurs with practices and solutions for common problems.</p><p>The AM, also known as 3D printing, does not contain only one technology, in fact, it represents a family of technologies that work under the same principle, the one of manufacturing complete products by the deposition of layers successively one on top of the other before, defining its geometry till the piece is completed following the 3D digital model design. There are some differences between the AM technologies, such as the materials that can be used and the time of processing. Currently there is 7 different categories for 3D printing technologies.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*S3WpMJ0Z2mHJHBN30rrEFA.jpeg" /><figcaption>Timeline</figcaption></figure><p>The AM start back at the 80’s, even tough some think that 3D printing ideas were present some time before. It was first known as rapid prototyping and further toke the name of additive manufacturing including now functional parts and not just prototypes. The first 3D printing technology developed was stereo-lithography (SLA), in this process thin layers of liquid polymeric resin are solidified using a UV laser, in 1986 Charles Hull creator of this technology, patented its invention and create the company 3D Systems, he saw the need of building a system that allows to obtain design prototypes without using expensive molds that increases the costs and take some time to build, so he found SLA, he also created the STL format, that is still used in AM processes.</p><p>Continuing in 1988, Carl Deckard patented the SLS method, here powder resin is used instead of liquid resin, but it is also solidified with laser. In 1989 Scott Crump, co-founder of Stratasys, he invented and patented the FDM technology, using thermoplastic materials in the form of filament to melt and deposit the layers one above the previous over a flat surface following a specific path to form the part. And just like that the tree main AM technologies were created.</p><p>In 1991 the manufacturing of products using lamination (LOM) was commercialized by Helisys, in this one, very thin sheets are cut and joined using a laser digitally guided. And in 1993, in the Massachusetts Institute of Technology was invented and patented the 3D printing injection (DSPC). An important progress happened in 1999 thanks to 3D printing, when in Wake Forest Institute for Regenerative Medicine implanted modified human organs with artificial implants 3D printed with synthetic covering made with the patient’s cells, in 2002 in this same institute was printed the first functional kidney.</p><p>The next challenge thought by Dr. Adrian Bowyer was to democratize 3D printing, that is why he created the RepRap project in 2004, and the main idea was to build a FDM 3D printer that could print their own components, so he expanded the access of this technology to many parts in the world, a red of 3D printing amateurs born in domestic levels because of this, and they connected on digital platforms to share their experiences using this technology.</p><p>In the fist decade of 2000 several companies around the world developed AM technologies that involve different types of materials, like metals, ceramics and compounds, they also improved the techniques for production, and even make parts with better properties than before. In 2001, Envisiotec in Germany, developed DLP technology, in which an entire layer can be form instantly using a digital light over a photo-polymer. After in 2006, Arcam developed Electron Beam Melting technology.</p><p>In 2009, the FDM patent expire, so the market got bigger to commercialized the technology at lower costs, and since 2010 3D domestic printers expanded considerately, and thanks to the arrive of Makerbot and the creation of Thingiverse, many domestic users were capable of download y upload files ready to print, this has made of <a href="http://www.thingiverse.com/">Thingiverse the world’s biggest online community for 3D printing currently.</a></p><blockquote>The AM still a field open to innovation and technological development for companies around the world and millions of users are enjoying the advantage of 3D printing. What do you think is coming next ?</blockquote><p>Article published and wrote originally by <a href="https://medium.com/u/6711a8961fc4">Astrid Hernández Castro</a><a href="https://www.nedraki.com/post/impresi%C3%B3n-3d-un-viaje-en-el-tiempo"> in nedraki.com (Spanish version)</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dd5e55f13c46" width="1" height="1" alt=""><hr><p><a href="https://medium.com/nedraki/a-brief-history-of-3d-printing-dd5e55f13c46">A brief history of 3D Printing</a> was originally published in <a href="https://medium.com/nedraki">Nedraki</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Chicago and its life lessons: A story of steel and 3D printing.]]></title>
            <link>https://medium.com/ylainetwork/chicago-and-its-life-lessons-a-story-of-steel-and-3d-printing-da5d4064b6e5?source=rss-79c52389be60------2</link>
            <guid isPermaLink="false">https://medium.com/p/da5d4064b6e5</guid>
            <category><![CDATA[entrepreneurship]]></category>
            <category><![CDATA[3d-printing]]></category>
            <category><![CDATA[ylai]]></category>
            <category><![CDATA[chicago]]></category>
            <category><![CDATA[ylai2017]]></category>
            <dc:creator><![CDATA[Alber Domínguez]]></dc:creator>
            <pubDate>Thu, 02 Aug 2018 00:12:44 GMT</pubDate>
            <atom:updated>2019-04-06T11:04:39.714Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/768/1*QryX6wwSyDY3oQSHe32wOQ.jpeg" /></figure><p>When I was a Kid, Michael Jordan played with the Chicago Bulls and the famous Jordans boots produced by Nike were a best seller around the world. My father became a successful businessman by marketing Jordans in Venezuela. Then the years went by until July 2017, when I received a congratulatory email saying, “…you were identified as one of the most talented and promising entrepreneurs”. The Young Leaders of the Americas Initiative was offering me the opportunity to foster my new project in the city that contributed to my father’s success: Chicago.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-wpn48mMc2ARigieBy9FaA.jpeg" /><figcaption>As the song said: “Sweet home, Chicago”</figcaption></figure><p>I of course took the opportunity, got on a plane, and flew to Atlanta, where I found myself surrounded by around 250 entrepreneurs from Latin America and the Caribbean who were selected to participate in the YLAI program. I like to call them “Outliers”, or talented people who decided to use their skills and ideas to build projects and create progress in their society. Atlanta was the city selected for the program’s opening, where we spent a few days working on our strategy to get the most of the weeks when we would be in the US working on our projects.</p><p>After the opening conference in Atlanta, I boarded another plane. This time I was headed to Chicago, a city with an important history in manufacturing and heavy industry. Just imagine Chicago’s industrial power and spirit of progress: after a <a href="http://www.americaslibrary.gov/jb/recon/jb_recon_chicago_1.html">great fire</a> destroyed most of the city in 1871, in 1885 they constructed the world’s first skyscraper made using a steel skeleton, in 1900 they reversed the flow of an entire river to avoid polluting the city’s freshwater source, and during World War II, the city alone produced more steel than the United Kingdom every year from 1939 to 1945. If you ever have the opportunity of visiting the city, take a few minutes, walk by one of their bridges on the river, and admire the wonderful structure made a century ago, its construction embracing the expression, “<em>Chicago has endurance and was built to last in time and memory as a city of greatness</em>”, an expression that my friend <a href="https://www.rolandkulla.com/">Roland Kulla knows how to capture very well on his paintings.</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UdE5Nz9eoR2IaqfaLctShQ.jpeg" /><figcaption><em>Chicago has endurance and was built to last in time and memory as a city of greatness.</em></figcaption></figure><p>Now imagine a young engineering student working on a project to produce raw materials for 3D printing using recycled plastic in a city with such a deep-rooted history in manufacturing. I was assigned to work with <a href="http://www.3degreescompany.com/">3Degrees, a consulting company</a> that works to support organizations and maximize their investments in <a href="https://www.weforum.org/agenda/2016/01/the-fourth-industrial-revolution-what-it-means-and-how-to-respond/">4th industrial revolution</a> manufacturing technologies such as 3D Printing. The company is lead by Mike, an engineer from MIT who became my mentor and friend during my YLAI fellowship. <a href="https://mhubchicago.com/">The workplace? Mhub Chicago</a>, an amazing makerspace focused on product development. While working there, I was surrounded by an ecosystem of innovators, world-class talent with access to all the tooling and machinery needed to make ideas come true.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*n7_mWm87SUwbNiIbDrWZiQ.jpeg" /></figure><p>Mike made sure I had the best experience during my stay in Chicago. He gave me a lot of independence, letting me choose the activities I preferred. He was always there to support me with advice regarding my project, and he invited me to really interesting events related to the manufacturing industry. Most importantly, however, he became a friend who believed in and supported my idea.</p><p>Mhub was everything I dreamed of and more than I could have ever imagined a few years ago when I was building competitive cars at a<a href="https://www.instagram.com/bajausb/?hl=en"> Baja SAE team garage in Venezuela</a>. To give you a better idea of how great my workplace was, just imagine a place where you have access to all the tools, machinery, and talent to prototype your own Ironman or Stormtrooper suit. Awesome, isn’t it?</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FI_GmI0zdtUY%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DI_GmI0zdtUY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FI_GmI0zdtUY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/ef03a4dfca33f22cb40ddb6bc2e94cc8/href">https://medium.com/media/ef03a4dfca33f22cb40ddb6bc2e94cc8/href</a></iframe><p>Working at Mhub was a dream come true, but my time in Chicago was limited and I had to make difficult but necessary choices. Despite my desire to use the machines in my workplace to build a project, I decided to look for mentoring in business and create a broader vision for the 3D printing industry. It may sound silly, but during my studies as an engineer in my country, I never had the opportunity to work with a 3D printer, and my only familiarity with them was through Google, YouTube, and a previous trip to Canada. Mhub was perfect for business mentoring because they have a <a href="https://mhubchicago.com/page/mentors">roster of professionals</a> from a variety of fields of expertise, including finance, marketing, corporate law, entrepreneurship, investment, and engineering, and all of them have brilliant professional careers. They dedicated at least one hour of their time with me in exchange for nothing more than improving my chances of success. I wasted no time, booked appointments with all the mentors I could, and attended as many networking and technology events possible. I was hungry for knowledge and foolish enough to surprise myself with even the smallest details. I was there to learn from the best, without fear of listening to new ideas, with a positive attitude and always moving forward.</p><p>I am thankful for and admire the ecosystem of innovation in the US, and I learned so much from it. I would like to share the simplest and most meaningful lessons I learned:</p><h3>Don’t underestimate yourself.</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*TToYne6Shrbv04Wz" /><figcaption>Photo by <a href="https://unsplash.com/@clarktibbs?utm_source=medium&amp;utm_medium=referral">Clark Tibbs</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>I was kind of afraid of working with an engineer from MIT. Initially, I thought that my idea was insignificant in the face of US progress, but as I began to tell my story and idea, people became interested and surprised. They admired my courage because <em>it is not just the idea, but the circumstances you are facing and the potential to create a positive change that makes a project a meaningful venture.</em></p><blockquote>“There is no passion to be found playing small, in settling for a life that is less than the one you are capable of living.” Nelson Mandela</blockquote><h3>Time and trust</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*joVPz0p9fTGJDXOi" /><figcaption>Photo by <a href="https://unsplash.com/@rawpixel?utm_source=medium&amp;utm_medium=referral">rawpixel</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Time is your most valuable asset. People in the US take time really seriously. You book an appointment, receive a notification in your Google Calendar, and when the time arrives, the meeting begins immediately. The conversation begins with formal greetings and then goes straight to the point:</p><p>-Nice to meet you, Alber. We have one hour. What would you like to discuss?<br>-We have 10 more minutes, how do you want to close the meeting?<br>-It has been a pleasure. Grab my card and email me if there’s anything else I can help you with.</p><p>I must confess that in the beginning, I thought it was ruthless and soulless. However, when I thought about it, I came to an important conclusion: Americans (people from the States) know very well how valuable their time is and they structure their meetings efficiently, with the goal of getting things done. If you arrive late, you are subtracting time from your own meeting.</p><p>In Latin America, things are different. We usually arrive late to every meeting, and when we finally show up, we start by talking about the family, the weather, how bad the political situation is, and so on. We care about being friends and being likable before doing business.</p><p>Dare I say that Americans are pragmatic and Latinos are poets? There is nothing wrong in being one way or another. Americans are focused on achieving objectives in the short term while we (Latinos) focus on building relationships in the long term. I confess that I’m struggling to manage my business meetings as Americans do, but it is not an easy task for a huge cultural reason: <em>Americans have strong institutions, with low indicators of corruption, so they can trust in doing business because the law is there to protect commercial operations</em>.<em> In the case of Latin America, weak institutions and corruption are the norm, so before doing business, citizens have to know their counterparts very well, and trust is built through social guarantees based on where you live, where you studied, the people that surround you, and so on.</em></p><h3>Do your best, always your best, especially when nobody is watching.</h3><p>By the time my last week in Chicago rolled around, most of my efforts were focused on finding equipment that could recycle plastic waste and produce the filament for 3D printing in Venezuela. I got a really good discount with a company, but I did not have enough money to buy the necessary machines. My project was at an early stage and was thought to be developed in one of the craziest economic scenarios in the world, so it was risky for investors. But suddenly, something magical happened. While I was summarizing with my mentor Mike the result of my weeks working at Mhub, I told him that from an economic perspective, my project was too risky and would probably become a failure, but that I decided I still wanted to try, as many people had confidence in me and told me going back and doing nothing was not an option. He then said this to me: “You already have your hands dirty. I saw you working during these weeks. I saw your enthusiasm and your mood, and I do believe you have the right attitude for making this project or another one successful. For this reason, I want to do something for you. I am going to get you the machine you need.” You guys have no idea how moved I felt. I have no words to describe the mix of happiness and hope I experienced at that moment.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*ammJ4_B90wBXxDniI-K52Q.jpeg" /><figcaption>A sculpture created using filament based on recycled plastic is seen in a 3D printer at Nedraki’s office at Simon Bolivar University in Caracas, Venezuela July 4, 2018. Reuters/Marco Bello</figcaption></figure><p>It’s been around nine months since that day. Now the idea of recycling plastic to produce raw material for 3D printing is a reality, and its name is <a href="https://www.instagram.com/nedraki/?hl=es-la">Nedraki</a>. The machine donated by my mentor made Nedraki become a startup by using technology as a means to build a sustainable future. Many people around the globe know about our work in Venezuela, thanks to a<a href="https://www.reuters.com/article/us-venezuela-plastic/venezuelan-engineers-turn-plastic-trash-into-car-parts-amid-crisis-idUSKBN1K81UH"> press release recently made by Reuters</a> that in a surprising turn of events has become a news story translated into several languages, even <a href="http://dantri.com.vn/kinh-doanh/trong-con-khung-hoang-venezuela-bien-rac-thanh-phu-tung-o-to-20180719133517775.htm">Vietnamese</a>. I have to say, I love it! I am a world citizen and this offers me the opportunity to share how we can work to solve worldwide challenges through local solutions. Now I feel a little scared and more responsible for creating progress, but the meaningful people who support me motivate me to keep up the good work.</p><blockquote>“And so the Fates are seldom wrong</blockquote><blockquote>No matter how they twist and wind</blockquote><blockquote>It is you and I who make our fates</blockquote><blockquote>We open up or close the gates</blockquote><blockquote>On the road ahead or the road behind” <a href="http://aphotoeditor.com/2010/12/31/the-road-ahead-or-the-road-behind/"><em>George Joseph Moriarty</em></a>.</blockquote><p>Albermar Dominguez. YLAI Fellow 2017. Venezuela</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=da5d4064b6e5" width="1" height="1" alt=""><hr><p><a href="https://medium.com/ylainetwork/chicago-and-its-life-lessons-a-story-of-steel-and-3d-printing-da5d4064b6e5">Chicago and its life lessons: A story of steel and 3D printing.</a> was originally published in <a href="https://medium.com/ylainetwork">Young Leaders of the Americas Initiative</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>