{"id":100,"date":"2026-06-05T18:05:44","date_gmt":"2026-06-05T18:05:44","guid":{"rendered":"https:\/\/nobleprensa.com\/?p=100"},"modified":"2026-06-30T17:35:34","modified_gmt":"2026-06-30T17:35:34","slug":"explorando-el-gasto-de-las-fuerzas-armadas","status":"publish","type":"post","link":"https:\/\/nobleprensa.com\/en\/explorando-el-gasto-de-las-fuerzas-armadas\/","title":{"rendered":"Explorando el gasto de las Fuerzas Armadas"},"content":{"rendered":"<p class=\"ext-animate--on wp-block-paragraph\">Hello! For a project in my Data Analyst course <a href=\"https:\/\/www.coderhouse.com\/\" type=\"link\" id=\"https:\/\/www.coderhouse.com\/\">Coder House<\/a> I wanted to study the direct purchases of the Chilean Army. For this project, I wanted to apply a research perspective to public spending by analyzing purchase orders through direct dealing by the Chilean Armed Forces, covering the year 2024. My objective was to immerse myself in this large volume of records to structure them and discover what stories the numbers tell us about the acquisitions of the different defense institutions.<\/p>\n\n\n\n<p class=\"ext-animate--on wp-block-paragraph\">Working entirely in Excel, I was responsible for cleaning and merging the databases to then build pivot tables and an interactive dashboard. In this way, the project demonstrates how data analysis can be a key tool for bringing clarity to topics of public interest, transforming raw tables into a transparent and accessible narrative.<\/p>\n\n\n\n<p class=\"ext-animate--on wp-block-paragraph\">Download the Excel file below:<\/p>\n\n\n\n<div class=\"wp-block-file ext-animate--on\"><a id=\"wp-block-file--media-aebd7ae3-5915-4822-ad04-18345d390035\" href=\"https:\/\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/ProyectoFinal_AlejandroVegas.xlsx.xlsx\">FinalProject_AlejandroVegas.xlsx<\/a><a href=\"https:\/\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/ProyectoFinal_AlejandroVegas.xlsx.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-aebd7ae3-5915-4822-ad04-18345d390035\">Download<\/a><\/div>\n\n\n\n<p class=\"ext-animate--on wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Review my project for my Coder House Data Analyst course, about the Chilean Army's public spending in 2024. Using Excel, I cleaned and cross-referenced direct purchase data, creating pivot tables and an interactive dashboard.<\/p>","protected":false},"author":1,"featured_media":101,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"wpai_generated_summary":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[18],"tags":[19],"class_list":["post-100","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Explorando el gasto de las Fuerzas Armadas - NoblePrensa<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nobleprensa.com\/en\/explorando-el-gasto-de-las-fuerzas-armadas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Explorando el gasto de las Fuerzas Armadas - NoblePrensa\" \/>\n<meta property=\"og:description\" content=\"Revisa mi proyecto para mi curso de Data Analyst de Coder House, sobre gasto p\u00fablico del Ej\u00e9rcito de Chile en 2024. A trav\u00e9s de Excel, limpi\u00e9 y cruc\u00e9 datos de compras directas, creando tablas din\u00e1micas y un dashboard interactivo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nobleprensa.com\/en\/explorando-el-gasto-de-las-fuerzas-armadas\/\" \/>\n<meta property=\"og:site_name\" content=\"NoblePrensa\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-05T18:05:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-30T17:35:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-1024x559.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"559\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alejandro Vegas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alejandro Vegas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/\"},\"author\":{\"name\":\"Alejandro Vegas\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#\\\/schema\\\/person\\\/69c4a1279ec6d860ca0a34fa57439d32\"},\"headline\":\"Explorando el gasto de las Fuerzas Armadas\",\"datePublished\":\"2026-06-05T18:05:44+00:00\",\"dateModified\":\"2026-06-30T17:35:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/\"},\"wordCount\":164,\"publisher\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/nobleprensa.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1\",\"keywords\":[\"Excel\"],\"articleSection\":[\"Data\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/\",\"url\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/\",\"name\":\"Explorando el gasto de las Fuerzas Armadas - NoblePrensa\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/nobleprensa.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1\",\"datePublished\":\"2026-06-05T18:05:44+00:00\",\"dateModified\":\"2026-06-30T17:35:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/nobleprensa.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/nobleprensa.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1\",\"width\":2560,\"height\":1396},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/explorando-el-gasto-de-las-fuerzas-armadas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/nobleprensa.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Explorando el gasto de las Fuerzas Armadas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#website\",\"url\":\"https:\\\/\\\/nobleprensa.com\\\/\",\"name\":\"NoblePrensa\",\"description\":\"Un blog personal\",\"publisher\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nobleprensa.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#organization\",\"name\":\"NoblePrensa\",\"url\":\"https:\\\/\\\/nobleprensa.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/nobleprensa.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cropped-Logo_NoblePrensa-1.png?fit=512%2C512&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/nobleprensa.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cropped-Logo_NoblePrensa-1.png?fit=512%2C512&ssl=1\",\"width\":512,\"height\":512,\"caption\":\"NoblePrensa\"},\"image\":{\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/nobleprensa.com\\\/#\\\/schema\\\/person\\\/69c4a1279ec6d860ca0a34fa57439d32\",\"name\":\"Alejandro Vegas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/43a2e74530d59e336783fc151a19b5f48ee68369d6b6580e8748f5175be9a331?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/43a2e74530d59e336783fc151a19b5f48ee68369d6b6580e8748f5175be9a331?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/43a2e74530d59e336783fc151a19b5f48ee68369d6b6580e8748f5175be9a331?s=96&d=mm&r=g\",\"caption\":\"Alejandro Vegas\"},\"sameAs\":[\"https:\\\/\\\/nobleprensa.com\",\"www.linkedin.com\\\/in\\\/alejandrovegasperkins\"],\"url\":\"https:\\\/\\\/nobleprensa.com\\\/en\\\/author\\\/noble_ale\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Explorando el gasto de las Fuerzas Armadas - NoblePrensa","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nobleprensa.com\/en\/explorando-el-gasto-de-las-fuerzas-armadas\/","og_locale":"en_US","og_type":"article","og_title":"Explorando el gasto de las Fuerzas Armadas - NoblePrensa","og_description":"Revisa mi proyecto para mi curso de Data Analyst de Coder House, sobre gasto p\u00fablico del Ej\u00e9rcito de Chile en 2024. A trav\u00e9s de Excel, limpi\u00e9 y cruc\u00e9 datos de compras directas, creando tablas din\u00e1micas y un dashboard interactivo.","og_url":"https:\/\/nobleprensa.com\/en\/explorando-el-gasto-de-las-fuerzas-armadas\/","og_site_name":"NoblePrensa","article_published_time":"2026-06-05T18:05:44+00:00","article_modified_time":"2026-06-30T17:35:34+00:00","og_image":[{"width":1024,"height":559,"url":"https:\/\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-1024x559.png","type":"image\/png"}],"author":"Alejandro Vegas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alejandro Vegas","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/#article","isPartOf":{"@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/"},"author":{"name":"Alejandro Vegas","@id":"https:\/\/nobleprensa.com\/#\/schema\/person\/69c4a1279ec6d860ca0a34fa57439d32"},"headline":"Explorando el gasto de las Fuerzas Armadas","datePublished":"2026-06-05T18:05:44+00:00","dateModified":"2026-06-30T17:35:34+00:00","mainEntityOfPage":{"@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/"},"wordCount":164,"publisher":{"@id":"https:\/\/nobleprensa.com\/#organization"},"image":{"@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1","keywords":["Excel"],"articleSection":["Data"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/","url":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/","name":"Explorando el gasto de las Fuerzas Armadas - NoblePrensa","isPartOf":{"@id":"https:\/\/nobleprensa.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/#primaryimage"},"image":{"@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1","datePublished":"2026-06-05T18:05:44+00:00","dateModified":"2026-06-30T17:35:34+00:00","breadcrumb":{"@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/#primaryimage","url":"https:\/\/i0.wp.com\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1","contentUrl":"https:\/\/i0.wp.com\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1","width":2560,"height":1396},{"@type":"BreadcrumbList","@id":"https:\/\/nobleprensa.com\/explorando-el-gasto-de-las-fuerzas-armadas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/nobleprensa.com\/"},{"@type":"ListItem","position":2,"name":"Explorando el gasto de las Fuerzas Armadas"}]},{"@type":"WebSite","@id":"https:\/\/nobleprensa.com\/#website","url":"https:\/\/nobleprensa.com\/","name":"Noble Press","description":"A personal blog","publisher":{"@id":"https:\/\/nobleprensa.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nobleprensa.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/nobleprensa.com\/#organization","name":"Noble Press","url":"https:\/\/nobleprensa.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/nobleprensa.com\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/cropped-Logo_NoblePrensa-1.png?fit=512%2C512&ssl=1","contentUrl":"https:\/\/i0.wp.com\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/cropped-Logo_NoblePrensa-1.png?fit=512%2C512&ssl=1","width":512,"height":512,"caption":"NoblePrensa"},"image":{"@id":"https:\/\/nobleprensa.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/nobleprensa.com\/#\/schema\/person\/69c4a1279ec6d860ca0a34fa57439d32","name":"Alejandro Vegas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/43a2e74530d59e336783fc151a19b5f48ee68369d6b6580e8748f5175be9a331?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/43a2e74530d59e336783fc151a19b5f48ee68369d6b6580e8748f5175be9a331?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/43a2e74530d59e336783fc151a19b5f48ee68369d6b6580e8748f5175be9a331?s=96&d=mm&r=g","caption":"Alejandro Vegas"},"sameAs":["https:\/\/nobleprensa.com","www.linkedin.com\/in\/alejandrovegasperkins"],"url":"https:\/\/nobleprensa.com\/en\/author\/noble_ale\/"}]}},"jetpack_publicize_connections":[],"jetpack-related-posts":[],"jetpack_shortlink":"https:\/\/wp.me\/pdnCCv-1C","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/nobleprensa.com\/wp-content\/uploads\/2026\/06\/Explorando-el-gasto-de-las-Fuerzas-Armadas-Portada-scaled.png?fit=2560%2C1396&ssl=1","_links":{"self":[{"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/posts\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/comments?post=100"}],"version-history":[{"count":2,"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":105,"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/posts\/100\/revisions\/105"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/media\/101"}],"wp:attachment":[{"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/categories?post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nobleprensa.com\/en\/wp-json\/wp\/v2\/tags?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}