{"id":61533,"date":"2026-07-14T11:45:22","date_gmt":"2026-07-14T09:45:22","guid":{"rendered":"https:\/\/cambraterrassa.org\/agenda\/analisis-y-gestion-de-datos-con-excel\/"},"modified":"2026-09-01T11:30:52","modified_gmt":"2026-09-01T09:30:52","slug":"analisis-y-gestion-de-datos-con-excel","status":"publish","type":"tribe_events","link":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/","title":{"rendered":"An\u00e1lisis y gesti\u00f3n de datos con excel"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
\n\t\t\t<\/path><\/svg>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Fecha9 al 27 de noviembre<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
\n\t\t\t<\/path><\/svg>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Horariode 9:30h a 13:30<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
\n\t\t\t<\/path><\/svg>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

LugarCambra de Comer\u00e7 de Terrassa<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Este curso ofrece una introducci\u00f3n pr\u00e1ctica en el an\u00e1lisis de datos con Excel y Power BI. Los participantes reforzar\u00e1n los conocimientos esenciales de Excel, aprender\u00e1n a preparar y transformar datos con Power Query, a crear modelos de datos y c\u00e1lculos con Power P\u00edvot y DAX, y a dise\u00f1ar cuadros de mando interactivos con Power BI. A lo largo de la formaci\u00f3n se trabajar\u00e1 el flujo completo de Business Intelligence, desde la extracci\u00f3n y transformaci\u00f3n de datos hasta su visualizaci\u00f3n y publicaci\u00f3n, proporcionando las competencias necesarias para convertir datos en informaci\u00f3n \u00fatil para la toma de decisiones <\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/section><\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Informaci\u00f3n del curso<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t\t
M\u00f2dul 0: Rep\u00e0s d\u2019Excel per a l\u2019An\u00e0lisi de Dades <\/div><\/span>\n\t\t\t\t\t\t\t\n\t\t\t<\/path><\/svg><\/span>\n\t\t\t<\/path><\/svg><\/span>\n\t\t<\/span>\n\n\t\t\t\t\t\t<\/summary>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

GESTI\u00d3N DE DATOS<\/p>

  • Formato de mesas y rangos<\/li>
  • Nombres definidos<\/li>
  • Validaci\u00f3n de datos<\/li>
  • Ordenaci\u00f3n y filtros avanzados<\/li><\/ul>

    FUNCIONES ESENCIALES PARA C\u00c0LCULS<\/p>

    • Matem\u00e1ticas y estad\u00edsticas: SUMA, PROMEDIO, MAX, MIN, CONTAR, CONTARA<\/li>
    • Condicionales: SI, SI.CONJUNTO, Y, O<\/li>
    • B\u00fasqueda y referencia: BUSCARV, BUSCARX<\/li>
    • Texto: IZQUIERDA, DERECHA, EXTRAE, CONCATENAR, TEXTO<\/li>
    • Fecha y hora: HOY, D\u00cdA, MES, A\u00d1O, DIASEM, NUM.DE.SEMANA<\/li><\/ul>

      MESAS Y MODELOS<\/p>

      • Creaci\u00f3n de mesas estructuradas<\/li>
      • Uso de mesas como fuente para Power P\u00edvot<\/li>
      • Introducci\u00f3n a las relaciones entre mesas<\/li><\/ul>

        GR\u00c1FICOS Y VISUALIZACI\u00d3N B\u00c1SICA<\/p>

        • Gr\u00e0fics de columnes, l\u00ednies i sectors<\/li>
        • Formato condicional para destacar datos<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/details>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t\t\t
          \n\t\t\t\t\t\t
          \n\t\t\t\t\n\t\t\t\t\t
          M\u00f3dulo 1: Fundamentos de la Inteligencia de Negocio con Excel y Power BI <\/div><\/span>\n\t\t\t\t\t\t\t\n\t\t\t<\/path><\/svg><\/span>\n\t\t\t<\/path><\/svg><\/span>\n\t\t<\/span>\n\n\t\t\t\t\t\t<\/summary>\n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t\t\t\t\t
          • Qu\u00e9 es la BI (Business Intelligence)?<\/li>
          • Diferencias y sinergias entre Excel y Power BI<\/li>
          • Flujo de trabajo t\u00edpico: Power Query \u2192 Power P\u00edvot \u2192 Power BI<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/details>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t\t\t\t
            \n\t\t\t\t\t\t
            \n\t\t\t\t\n\t\t\t\t\t
            M\u00f3dulo 2: Power Query \u2013 Extracci\u00f3n y Transformaci\u00f3n de Datos <\/div><\/span>\n\t\t\t\t\t\t\t\n\t\t\t<\/path><\/svg><\/span>\n\t\t\t<\/path><\/svg><\/span>\n\t\t<\/span>\n\n\t\t\t\t\t\t<\/summary>\n\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t
            • Introducci\u00f3n a Power Query y el editor de consultas<\/li>
            • Conexi\u00f3n a fuentes de datos (Excel, CSV, web, bases de datos, etc.)<\/li>
            • Transformaciones b\u00e1sicas: filtrar, ordenar, dividir columnas, tipos de datos<\/li>
            • Transformaciones avanzadas: columnas condicionales, columnas personalizadas, combinaci\u00f3n de mesas<\/li>
            • Automatizaci\u00f3n de procesos ETL (Extract, Transform, Load)<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/details>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
              \n\t\t\t\t
              \n\t\t\t\t\t\t\t
              \n\t\t\t\t\t\t
              \n\t\t\t\t\n\t\t\t\t\t
              M\u00f3dulo 3: Power P\u00edvot \u2013 Modelado y An\u00e1lisis de Datos <\/div><\/span>\n\t\t\t\t\t\t\t\n\t\t\t<\/path><\/svg><\/span>\n\t\t\t<\/path><\/svg><\/span>\n\t\t<\/span>\n\n\t\t\t\t\t\t<\/summary>\n\t\t\t\t
              \n\t\t\t\t
              \n\t\t\t\t
              \n\t\t\t\t\t\t\t\t\t
              • Creaci\u00f3n de modelos de datos<\/li>
              • Relaciones entre mesas<\/li>
              • Columnas calculadas vs. medidas<\/li>
              • Introducci\u00f3n en DAX (Fecha Analysis Expresiones)-Funciones b\u00e1sicas: SUM, AVERAGE, CALCULATE, FILTER, RELATED-Funciones de tiempos: DATESYTD, DATEADD, PREVIOSYEAR, DATESBETWEEN-Otras funciones: AJO, ALLSELECTED, FILTER<\/li>
              • KPIs y m\u00e9tricas personalizadas<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/details>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t\t\t\t
                \n\t\t\t\t\t\t
                \n\t\t\t\t\n\t\t\t\t\t
                M\u00f3dulo 4: Power BI \u2013 Visualizaci\u00f3n y Publicaci\u00f3n <\/div><\/span>\n\t\t\t\t\t\t\t\n\t\t\t<\/path><\/svg><\/span>\n\t\t\t<\/path><\/svg><\/span>\n\t\t<\/span>\n\n\t\t\t\t\t\t<\/summary>\n\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t
                \n\t\t\t\t\t\t\t\t\t
                • Introducci\u00f3n a Power BI Desktop<\/li>
                • Importaci\u00f3n de modelos desde Excel<\/li>
                • Creaci\u00f3n de visualizaciones interactivas<\/li>
                • Uso de filtros, afinadores y p\u00e1ginas<\/li>
                • Dise\u00f1o de dashboards<\/li>
                • Publicaci\u00f3n y compartici\u00f3n a Power BI Service<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/details>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t\t\t\t
                  \n\t\t\t
                  <\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
                  \n\t\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t
                  \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Talento\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

                  Fecha9 al 27 de noviembre Horariode 9:30h a 13:30 LugarCambra de Comer\u00e7 de Terrassa Este curso ofrece una introducci\u00f3n pr\u00e1ctica en el an\u00e1lisis de datos con Excel y Power BI. […]<\/p>\n","protected":false},"author":12,"featured_media":0,"template":"","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_tribe_events_status":"","_tribe_events_status_reason":"","_tribe_events_is_hybrid":"","_tribe_events_is_virtual":"","_tribe_events_virtual_video_source":"","_tribe_events_virtual_embed_video":"","_tribe_events_virtual_linked_button_text":"","_tribe_events_virtual_linked_button":"","_tribe_events_virtual_show_embed_at":"","_tribe_events_virtual_show_embed_to":[],"_tribe_events_virtual_show_on_event":"","_tribe_events_virtual_show_on_views":"","_tribe_events_virtual_url":"","footnotes":""},"tags":[197],"tribe_events_cat":[182],"class_list":["post-61533","tribe_events","type-tribe_events","status-publish","hentry","tag-curs-gratis-es-2","tribe_events_cat-curs-talento-45-es","cat_curs-talento-45-es"],"acf":[],"yoast_head":"An\u00e1lisis y gesti\u00f3n de datos cono excel<\/title>\n<meta name=\"description\" content=\"Apr\u00e8n a analitzar dades amb Excel i Power BI, des de Power Query i Power Pivot fins a la creaci\u00f3 de dashboards per a la presa de decisions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/tribe_events\/61533\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An\u00e1lisis y gesti\u00f3n de datos cono excel\" \/>\n<meta property=\"og:description\" content=\"Apr\u00e8n a analitzar dades amb Excel i Power BI, des de Power Query i Power Pivot fins a la creaci\u00f3 de dashboards per a la presa de decisions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Cambra de Terrassa\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-01T09:30:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cambraterrassa.org\/wp-content\/uploads\/2026\/07\/Anadir-un-subtitulo-24.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cambraterrassa.org\\\/es\\\/agenda\\\/analisis-y-gestion-de-datos-con-excel\\\/\",\"url\":\"https:\\\/\\\/cambraterrassa.org\\\/es\\\/agenda\\\/analisis-y-gestion-de-datos-con-excel\\\/\",\"name\":\"An\u00e1lisis y gesti\u00f3n de datos cono excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cambraterrassa.org\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cambraterrassa.org\\\/es\\\/agenda\\\/analisis-y-gestion-de-datos-con-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cambraterrassa.org\\\/es\\\/agenda\\\/analisis-y-gestion-de-datos-con-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cambraterrassa.org\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Anadir-un-subtitulo-24-1024x307.png\",\"datePublished\":\"2026-07-14T09:45:22+00:00\",\"dateModified\":\"2026-09-01T09:30:52+00:00\",\"description\":\"Apr\u00e8n a analitzar dades amb Excel i Power BI, des de Power Query i Power Pivot fins a la creaci\u00f3 de dashboards per a la presa de decisions.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cambraterrassa.org\\\/es\\\/agenda\\\/analisis-y-gestion-de-datos-con-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cambraterrassa.org\\\/es\\\/agenda\\\/analisis-y-gestion-de-datos-con-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/cambraterrassa.org\\\/es\\\/agenda\\\/analisis-y-gestion-de-datos-con-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cambraterrassa.org\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Anadir-un-subtitulo-24-1024x307.png\",\"contentUrl\":\"https:\\\/\\\/cambraterrassa.org\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Anadir-un-subtitulo-24-1024x307.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cambraterrassa.org\\\/es\\\/agenda\\\/analisis-y-gestion-de-datos-con-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inici\",\"item\":\"https:\\\/\\\/cambraterrassa.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Esdeveniments\",\"item\":\"https:\\\/\\\/cambraterrassa.org\\\/agenda\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"An\u00e1lisis y gesti\u00f3n de datos con excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cambraterrassa.org\\\/#website\",\"url\":\"https:\\\/\\\/cambraterrassa.org\\\/\",\"name\":\"Cambra de Terrassa\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cambraterrassa.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"}]}<\/script>","yoast_head_json":{"title":"An\u00e1lisis y gesti\u00f3n de datos cono excel","description":"Apr\u00e8n a analitzar dades amb Excel i Power BI, des de Power Query i Power Pivot fins a la creaci\u00f3 de dashboards per a la presa de decisions.","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:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/tribe_events\/61533\/","og_locale":"es_ES","og_type":"article","og_title":"An\u00e1lisis y gesti\u00f3n de datos cono excel","og_description":"Apr\u00e8n a analitzar dades amb Excel i Power BI, des de Power Query i Power Pivot fins a la creaci\u00f3 de dashboards per a la presa de decisions.","og_url":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/","og_site_name":"Cambra de Terrassa","article_modified_time":"2026-09-01T09:30:52+00:00","og_image":[{"width":2000,"height":600,"url":"https:\/\/cambraterrassa.org\/wp-content\/uploads\/2026\/07\/Anadir-un-subtitulo-24.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/","url":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/","name":"An\u00e1lisis y gesti\u00f3n de datos cono excel","isPartOf":{"@id":"https:\/\/cambraterrassa.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/#primaryimage"},"image":{"@id":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/cambraterrassa.org\/wp-content\/uploads\/2026\/07\/Anadir-un-subtitulo-24-1024x307.png","datePublished":"2026-07-14T09:45:22+00:00","dateModified":"2026-09-01T09:30:52+00:00","description":"Apr\u00e8n a analitzar dades amb Excel i Power BI, des de Power Query i Power Pivot fins a la creaci\u00f3 de dashboards per a la presa de decisions.","breadcrumb":{"@id":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/#primaryimage","url":"https:\/\/cambraterrassa.org\/wp-content\/uploads\/2026\/07\/Anadir-un-subtitulo-24-1024x307.png","contentUrl":"https:\/\/cambraterrassa.org\/wp-content\/uploads\/2026\/07\/Anadir-un-subtitulo-24-1024x307.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cambraterrassa.org\/es\/agenda\/analisis-y-gestion-de-datos-con-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inici","item":"https:\/\/cambraterrassa.org\/"},{"@type":"ListItem","position":2,"name":"Esdeveniments","item":"https:\/\/cambraterrassa.org\/agenda\/"},{"@type":"ListItem","position":3,"name":"An\u00e1lisis y gesti\u00f3n de datos con excel"}]},{"@type":"WebSite","@id":"https:\/\/cambraterrassa.org\/#website","url":"https:\/\/cambraterrassa.org\/","name":"Cambra de Terrassa","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cambraterrassa.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"}]}},"_links":{"self":[{"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/tribe_events\/61533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/users\/12"}],"version-history":[{"count":1,"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/tribe_events\/61533\/revisions"}],"predecessor-version":[{"id":61534,"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/tribe_events\/61533\/revisions\/61534"}],"wp:attachment":[{"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/media?parent=61533"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/tags?post=61533"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/cambraterrassa.org\/es\/wp-json\/wp\/v2\/tribe_events_cat?post=61533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}