{"id":64,"date":"2011-08-08T10:33:20","date_gmt":"2011-08-08T09:33:20","guid":{"rendered":"http:\/\/blogs.encamina.com\/mascrm\/?p=64"},"modified":"2013-03-04T12:11:52","modified_gmt":"2013-03-04T11:11:52","slug":"tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence","status":"publish","type":"post","link":"https:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/","title":{"rendered":"Tablas din\u00e1micas de Microsoft Office Excel con PowerPivot sobre Microsoft Dynamics CRM en un proyecto de Business Intelligence"},"content":{"rendered":"

Microsoft PowerPivot para Excel 2010<\/a> aporta a las tablas e informes din\u00e1micos de Microsoft Office Excel <\/a>una mayor capacidad para visualizar y filtrar los datos.<\/p>\n

Este art\u00edculo describe la utilizaci\u00f3n de ambas tecnolog\u00edas, en combinaci\u00f3n con\u00a0Microsoft Dynamics CRM<\/a>, en un proyecto real de Business Intelligence<\/a> sobre CRM.<\/p>\n\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n
\n
Informe con Microsoft PowerPivot<\/address>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Los informes realizados con la tecnolog\u00eda de Microsoft PowerPivot para Excel 2010, se han realizado en el contexto de un proyecto para dar soporte, con Microsoft Dynamics CRM<\/a>, al proceso de solicitud de informaci\u00f3n sobre los productos ofrecidos por un Centro de Formaci\u00f3n Universitaria<\/strong>.<\/p>\n\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n
\n
Detalle de una solicitud de informaci\u00f3n<\/address>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n
\n
Listado de solicitudes de informaci\u00f3n (clientes potenciales)<\/address>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Sobre la personalizaci\u00f3n realizada en la entidad \u2018Clientes potencial\u2019, se ha creado diferentes consultas sobre la base de datos de CRM para obtener, convenientemente traducidos, los datos necesarios para la informaci\u00f3n requerida:<\/p>\n

\u2022 Canal y estado de las solicitudes.
\n\u2022 Productos de inter\u00e9s.
\n\u2022 Situaci\u00f3n laboral, estudios previos, relaci\u00f3n anterior con el centro de los solicitantes.
\n\u2022 Centro, poblaci\u00f3n y provincia de procedencia de los solicitantes.
\n\u2022 Fecha y usuario de creaci\u00f3n de la solicitudes.<\/p>\n\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n
\n
Detalle del cubo para analizar las solicitudes de formaci\u00f3n<\/address>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

A partir de dichas consultas se ha creado un proyecto de Business Intelligence que, una vez implementado en un servidor Microsoft Analysis Server<\/a>, es el origen de datos de PowerPivot.<\/p>\n\n\n\n\n
\"\"<\/a><\/td>\n<\/tr>\n
\n
Datos en PowerPivot<\/address>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

A su vez, PowerPivot es el origen de datos de los informes de tablas din\u00e1micas de Excel.<\/p>\n

\"\"<\/a><\/div>\n
\"\"<\/a><\/div>\n
\"\"<\/a><\/div>\n
\"\"<\/a><\/div>\n

El resultado es una ‘simple’ hoja de c\u00e1lculo, que los usuarios pueden modificar a su antojo para profundizar hasta d\u00f3nde deseen en el an\u00e1lisis de los datos que proporciona el proceso de solicitud de informaci\u00f3n al que este proceso da soporte.<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft PowerPivot para Excel 2010 aporta a las tablas e informes din\u00e1micos de Microsoft Office Excel una mayor capacidad para visualizar y filtrar los datos. Este art\u00edculo describe la utilizaci\u00f3n de ambas tecnolog\u00edas, en combinaci\u00f3n con\u00a0Microsoft Dynamics CRM, en un … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[92,6,91,87,38,55,78],"tags":[11,44,99],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry","category-architecture","category-automatizacion","category-consultancy","category-desing","category-integration","category-powerpivot","category-xrm","tag-business-intelligence","tag-microsoft-analysis-server","tag-powerpivot"],"yoast_head":"\nTablas din\u00e1micas de Microsoft Office Excel con PowerPivot sobre Microsoft Dynamics CRM en un proyecto de Business Intelligence - M\u00e1s CRM<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Juan Ribes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/\"},\"author\":{\"name\":\"Juan Ribes\",\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#\\\/schema\\\/person\\\/148a37e227c5716102c71c3ab092d73b\"},\"headline\":\"Tablas din\u00e1micas de Microsoft Office Excel con PowerPivot sobre Microsoft Dynamics CRM en un proyecto de Business Intelligence\",\"datePublished\":\"2011-08-08T09:33:20+00:00\",\"dateModified\":\"2013-03-04T11:11:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/\"},\"wordCount\":319,\"image\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/4.bp.blogspot.com\\\/-WOwWiRj38TM\\\/Tj-u8Tm2bvI\\\/AAAAAAAAAWU\\\/l_07y7ZK6RI\\\/s400\\\/Excel.png\",\"keywords\":[\"Business Intelligence\",\"Microsoft Analysis Server\",\"PowerPivot\"],\"articleSection\":[\"Arquitectura\",\"Automatizaci\u00f3n\",\"Consultor\u00eda\",\"Dise\u00f1o\",\"Integraci\u00f3n\",\"PowerPivot\",\"XRM\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/\",\"url\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/\",\"name\":\"Tablas din\u00e1micas de Microsoft Office Excel con PowerPivot sobre Microsoft Dynamics CRM en un proyecto de Business Intelligence - M\u00e1s CRM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/4.bp.blogspot.com\\\/-WOwWiRj38TM\\\/Tj-u8Tm2bvI\\\/AAAAAAAAAWU\\\/l_07y7ZK6RI\\\/s400\\\/Excel.png\",\"datePublished\":\"2011-08-08T09:33:20+00:00\",\"dateModified\":\"2013-03-04T11:11:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#\\\/schema\\\/person\\\/148a37e227c5716102c71c3ab092d73b\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"http:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/2011\\\/08\\\/08\\\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\\\/#primaryimage\",\"url\":\"http:\\\/\\\/4.bp.blogspot.com\\\/-WOwWiRj38TM\\\/Tj-u8Tm2bvI\\\/AAAAAAAAAWU\\\/l_07y7ZK6RI\\\/s400\\\/Excel.png\",\"contentUrl\":\"http:\\\/\\\/4.bp.blogspot.com\\\/-WOwWiRj38TM\\\/Tj-u8Tm2bvI\\\/AAAAAAAAAWU\\\/l_07y7ZK6RI\\\/s400\\\/Excel.png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#website\",\"url\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/\",\"name\":\"M\u00e1s CRM\",\"description\":\"Reflexiones y apuntes sobre arquitectura, consultor\u00eda y gesti\u00f3n proyectos CRM\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/#\\\/schema\\\/person\\\/148a37e227c5716102c71c3ab092d73b\",\"name\":\"Juan Ribes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g\",\"caption\":\"Juan Ribes\"},\"description\":\"Director de Servicios CRM en ENCAMINA. Responsable de la implantaci\u00f3n los proyectos CRM en ENCAMINA desde 2005, principalmente con Microsoft Dynamics.\",\"sameAs\":[\"http:\\\/\\\/www.encamina.com\",\"http:\\\/\\\/www.facebook.com\\\/juan.ribes.andres\",\"http:\\\/\\\/es.linkedin.com\\\/in\\\/juanribes\",\"http:\\\/\\\/pinterest.com\\\/jribes\",\"https:\\\/\\\/x.com\\\/jribes\"],\"url\":\"https:\\\/\\\/blogs.encamina.com\\\/mascrm\\\/author\\\/jribes\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tablas din\u00e1micas de Microsoft Office Excel con PowerPivot sobre Microsoft Dynamics CRM en un proyecto de Business Intelligence - M\u00e1s CRM","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":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/","twitter_misc":{"Escrito por":"Juan Ribes","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/#article","isPartOf":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/"},"author":{"name":"Juan Ribes","@id":"https:\/\/blogs.encamina.com\/mascrm\/#\/schema\/person\/148a37e227c5716102c71c3ab092d73b"},"headline":"Tablas din\u00e1micas de Microsoft Office Excel con PowerPivot sobre Microsoft Dynamics CRM en un proyecto de Business Intelligence","datePublished":"2011-08-08T09:33:20+00:00","dateModified":"2013-03-04T11:11:52+00:00","mainEntityOfPage":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/"},"wordCount":319,"image":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/#primaryimage"},"thumbnailUrl":"http:\/\/4.bp.blogspot.com\/-WOwWiRj38TM\/Tj-u8Tm2bvI\/AAAAAAAAAWU\/l_07y7ZK6RI\/s400\/Excel.png","keywords":["Business Intelligence","Microsoft Analysis Server","PowerPivot"],"articleSection":["Arquitectura","Automatizaci\u00f3n","Consultor\u00eda","Dise\u00f1o","Integraci\u00f3n","PowerPivot","XRM"],"inLanguage":"es"},{"@type":"WebPage","@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/","url":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/","name":"Tablas din\u00e1micas de Microsoft Office Excel con PowerPivot sobre Microsoft Dynamics CRM en un proyecto de Business Intelligence - M\u00e1s CRM","isPartOf":{"@id":"https:\/\/blogs.encamina.com\/mascrm\/#website"},"primaryImageOfPage":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/#primaryimage"},"image":{"@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/#primaryimage"},"thumbnailUrl":"http:\/\/4.bp.blogspot.com\/-WOwWiRj38TM\/Tj-u8Tm2bvI\/AAAAAAAAAWU\/l_07y7ZK6RI\/s400\/Excel.png","datePublished":"2011-08-08T09:33:20+00:00","dateModified":"2013-03-04T11:11:52+00:00","author":{"@id":"https:\/\/blogs.encamina.com\/mascrm\/#\/schema\/person\/148a37e227c5716102c71c3ab092d73b"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"http:\/\/blogs.encamina.com\/mascrm\/2011\/08\/08\/tablas-dinamicas-de-microsoft-office-excel-con-powerpivot-sobre-microsoft-dynamics-crm-en-un-proyecto-de-business-intelligence\/#primaryimage","url":"http:\/\/4.bp.blogspot.com\/-WOwWiRj38TM\/Tj-u8Tm2bvI\/AAAAAAAAAWU\/l_07y7ZK6RI\/s400\/Excel.png","contentUrl":"http:\/\/4.bp.blogspot.com\/-WOwWiRj38TM\/Tj-u8Tm2bvI\/AAAAAAAAAWU\/l_07y7ZK6RI\/s400\/Excel.png"},{"@type":"WebSite","@id":"https:\/\/blogs.encamina.com\/mascrm\/#website","url":"https:\/\/blogs.encamina.com\/mascrm\/","name":"M\u00e1s CRM","description":"Reflexiones y apuntes sobre arquitectura, consultor\u00eda y gesti\u00f3n proyectos CRM","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.encamina.com\/mascrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/blogs.encamina.com\/mascrm\/#\/schema\/person\/148a37e227c5716102c71c3ab092d73b","name":"Juan Ribes","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d43370c2273027d37a63b0d141459be75ca20f6053939080ddfa08e8a668c69d?s=96&d=mm&r=g","caption":"Juan Ribes"},"description":"Director de Servicios CRM en ENCAMINA. Responsable de la implantaci\u00f3n los proyectos CRM en ENCAMINA desde 2005, principalmente con Microsoft Dynamics.","sameAs":["http:\/\/www.encamina.com","http:\/\/www.facebook.com\/juan.ribes.andres","http:\/\/es.linkedin.com\/in\/juanribes","http:\/\/pinterest.com\/jribes","https:\/\/x.com\/jribes"],"url":"https:\/\/blogs.encamina.com\/mascrm\/author\/jribes\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":0,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.encamina.com\/mascrm\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}