{"id":348,"date":"2023-11-07T19:00:00","date_gmt":"2023-11-07T19:00:00","guid":{"rendered":"https:\/\/datacrazyworld.com\/?p=348"},"modified":"2023-11-07T18:46:10","modified_gmt":"2023-11-07T18:46:10","slug":"power-bi-days-mallorca-septiembre-2023","status":"publish","type":"post","link":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/","title":{"rendered":"Power BI Days Mallorca &#8211; Septiembre 2023"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Siempre me encuentro indecisa sobre si participar o no en los eventos relacionados con Power BI, ya que a\u00fan estoy empezando y me queda mucho por aprender. Pero desde el inicio, mi querida compa\u00f1era de charla <strong>Ana M\u00aa Bisb\u00e9<\/strong>, me insisti\u00f3 en que mi experiencia en el mundo SQL Server podr\u00eda ayudar mucho y a mucha gente, asi que me lanc\u00e9 a la piscina.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El tema escogido fue \u00ab<strong>Conecta con Power Query a SQL de forma eficiente<\/strong>\u00bb y hacerla junto con Ana M\u00aa fue un acierto ya que ella es toda una experta en PowerQuery y yo pod\u00eda aportar mucho en la parte relativa al SQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Empezamos la charla dando un repaso al Power Query y al plegado de consultas. El concepto de <em>Plegado de consultas<\/em> o <em>Query Folding<\/em>, para mi era a\u00fan algo abstracto hasta que de la mano de Ana M\u00aa, preparamos esta charla. Un peque\u00f1o resumen:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u00bfCu\u00e1ndo hay que tenerlo en cuenta?<\/strong> Cuando el origen es una base de datos relacional y en los casos de: Listas de SharePoint, Fuente OData, Active Directory o Microsoft Exchange<\/li>\n\n\n\n<li><strong>\u00bfQu\u00e9 es?<\/strong> Es cuando el origen se encarga de evaluar y procesar la consulta<\/li>\n\n\n\n<li><strong>\u00bfPor qu\u00e9 es importante? <\/strong>Porque es m\u00e1s optimo. <\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Ana se encarg\u00f3 de explicar toda la parte del Power Query y poner ejemplos donde se romp\u00eda el plegado de consultas y yo me encargu\u00e9 de explicar las diferentes formas de optimizar y esquivar esa rotura del plegado del consultas. Algunas de las cosas que pudimos ver:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Hay que evitar cogerse \u00abtodo\u00bb , solo lo que se necesite<\/strong>: para ello vimos algunos ejemplos de c\u00f3mo afectar\u00eda en el motor hacer un <em>SELECT *<\/em> en vez de coger solo las columnas que necesitas, o poner un <em>WHERE <\/em>con un filtro concreto. <\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"612\" height=\"639\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/11\/image-1.png\" alt=\"\" class=\"wp-image-351\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/11\/image-1.png 612w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/11\/image-1-287x300.png 287w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><figcaption class=\"wp-element-caption\">En esta imagen, podemos ver los tiempos de hacer la <em>SELECT <\/em>con * vs una columna concreta. Cuando la tabla es peque\u00f1a, el tiempo no se nota mucho: 576 ms vs 244 ms, pero cuando la tabla es m\u00e1s grande, ya hablamos de otros tiempos (525.269 ms frente a 285.978 ms).<br><br>Algo similar nos encontramos si usamos la cl\u00e1usula <em>WHERE <\/em>para filtrar y quedarnos solo con los registros que cumplen determinada condici\u00f3n. En el caso de la tabla peque\u00f1a, pasamos de 244 ms a 85 ms. Si hablamos de la tabla grande, entonces pasamos de 285.978 ms a 24.530 ms.<\/figcaption><\/figure>\n<\/div><\/div>\n<\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Si hay alg\u00fan paso que provoca la rotura del plegado de consultas, lo mejor es retrasarlo al m\u00e1ximo<\/strong>: es decir, hacer todo lo que puedas antes, ya que todo eso lo procesar\u00e1 el origen y desde el paso que rompe el plegado, ser\u00e1 ya el Power Bi el encargado de procesarlo.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"252\" height=\"271\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/11\/image-2.png\" alt=\"\" class=\"wp-image-352\"\/><figcaption class=\"wp-element-caption\">Poco \u00f3ptimo<\/figcaption><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"251\" height=\"272\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/11\/image-3.png\" alt=\"\" class=\"wp-image-353\"\/><figcaption class=\"wp-element-caption\">M\u00e1s \u00f3ptimo<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La query que se construye autom\u00e1ticamente (izquierda) es m\u00e1s \u00abcompleja\u00bb que la que har\u00eda un desarrollador (derecha). Esto ayuda a quienes no saben SQL. Los que saben SQL, tendr\u00e1n ventaja.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-code\"><code>USE AdventureWorksDW2022\nGO\n\nSET STATISTICS TIME, IO ON\n\nselect &#91;_].&#91;ProductKey] as &#91;IdProducto],\n    &#91;_].&#91;EnglishProductName] as &#91;EnglishProductName],\n    &#91;_].&#91;t0_0] as &#91;StandardCost],\n    &#91;_].&#91;ProductLine] as &#91;ProductLine],\n    &#91;_].&#91;t1_0] as &#91;DealerPrice],\n    &#91;_].&#91;Class] as &#91;Class],\n    &#91;_].&#91;ModelName] as &#91;ModelName],\n    &#91;_].&#91;EnglishDescription] as &#91;EnglishDescription],\n    &#91;_].&#91;SpanishProductSubcategoryName] as &#91;DimProductSubcategory.SpanishProductSubcategoryName],\n    left(&#91;_].&#91;t0_02], 3) as &#91;DimProductSubcategory.DimProductCategory.SpanishProductCategoryName]\nfrom \n(\n    select &#91;_].&#91;ProductKey] as &#91;ProductKey],\n        &#91;_].&#91;EnglishProductName] as &#91;EnglishProductName],\n        &#91;_].&#91;StandardCost] as &#91;StandardCost],\n        &#91;_].&#91;ProductLine] as &#91;ProductLine],\n        &#91;_].&#91;DealerPrice] as &#91;DealerPrice],\n        &#91;_].&#91;Class] as &#91;Class],\n        &#91;_].&#91;ModelName] as &#91;ModelName],\n        &#91;_].&#91;EnglishDescription] as &#91;EnglishDescription],\n        &#91;_].&#91;SpanishProductSubcategoryName] as &#91;SpanishProductSubcategoryName],\n        &#91;_].&#91;SpanishProductCategoryName] as &#91;SpanishProductCategoryName],\n        ceiling(&#91;_].&#91;StandardCost]) as &#91;t0_0],\n        ceiling(&#91;_].&#91;DealerPrice]) as &#91;t1_0],\n        upper(&#91;_].&#91;SpanishProductCategoryName]) as &#91;t0_02]\n    from \n    (\n        select &#91;$Outer].&#91;ProductKey],\n            &#91;$Outer].&#91;EnglishProductName],\n            &#91;$Outer].&#91;StandardCost],\n            &#91;$Outer].&#91;ProductLine],\n            &#91;$Outer].&#91;DealerPrice],\n            &#91;$Outer].&#91;Class],\n            &#91;$Outer].&#91;ModelName],\n            &#91;$Outer].&#91;EnglishDescription],\n            &#91;$Outer].&#91;SpanishProductSubcategoryName],\n            &#91;$Inner].&#91;SpanishProductCategoryName]\n        from \n        (\n            select &#91;$Outer].&#91;ProductKey] as &#91;ProductKey],\n                &#91;$Outer].&#91;ProductSubcategoryKey2] as &#91;ProductSubcategoryKey2],\n                &#91;$Outer].&#91;EnglishProductName] as &#91;EnglishProductName],\n                &#91;$Outer].&#91;StandardCost] as &#91;StandardCost],\n                &#91;$Outer].&#91;ProductLine] as &#91;ProductLine],\n                &#91;$Outer].&#91;DealerPrice] as &#91;DealerPrice],\n                &#91;$Outer].&#91;Class] as &#91;Class],\n                &#91;$Outer].&#91;ModelName] as &#91;ModelName],\n                &#91;$Outer].&#91;EnglishDescription] as &#91;EnglishDescription],\n                &#91;$Inner].&#91;SpanishProductSubcategoryName] as &#91;SpanishProductSubcategoryName],\n                &#91;$Inner].&#91;ProductCategoryKey] as &#91;ProductCategoryKey2]\n            from \n            (\n                select &#91;_].&#91;ProductKey] as &#91;ProductKey],\n                    &#91;_].&#91;ProductSubcategoryKey] as &#91;ProductSubcategoryKey2],\n                    &#91;_].&#91;EnglishProductName] as &#91;EnglishProductName],\n                    &#91;_].&#91;StandardCost] as &#91;StandardCost],\n                    &#91;_].&#91;ProductLine] as &#91;ProductLine],\n                    &#91;_].&#91;DealerPrice] as &#91;DealerPrice],\n                    &#91;_].&#91;Class] as &#91;Class],\n                    &#91;_].&#91;ModelName] as &#91;ModelName],\n                    &#91;_].&#91;EnglishDescription] as &#91;EnglishDescription]\n                from \n                (\n                    select &#91;ProductKey],\n                        &#91;ProductSubcategoryKey],\n                        &#91;EnglishProductName],\n                        &#91;StandardCost],\n                        &#91;ProductLine],\n                        &#91;DealerPrice],\n                        &#91;Class],\n                        &#91;ModelName],\n                        &#91;EnglishDescription]\n                    from &#91;dbo].&#91;DimProduct] as &#91;$Table]\n                ) as &#91;_]\n                where (&#91;_].&#91;Class] &lt;> 'L' or &#91;_].&#91;Class] is null) or &#91;_].&#91;Class] is null\n            ) as &#91;$Outer]\n            left outer join &#91;dbo].&#91;DimProductSubcategory] as &#91;$Inner] on (&#91;$Outer].&#91;ProductSubcategoryKey2] = &#91;$Inner].&#91;ProductSubcategoryKey])\n        ) as &#91;$Outer]\n        left outer join &#91;dbo].&#91;DimProductCategory] as &#91;$Inner] on (&#91;$Outer].&#91;ProductCategoryKey2] = &#91;$Inner].&#91;ProductCategoryKey])\n    ) as &#91;_]\n) as &#91;_]\n<\/code><\/pre>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-code\"><code>USE AdventureWorksDW2022\r\nGO\n\r\nSET STATISTICS TIME, IO ON\r\n\r\nSELECT\r\n\tp.&#91;ProductKey] as &#91;IdProducto],\r\n    p.&#91;EnglishProductName],\r\n    ceiling(p.&#91;StandardCost]) as &#91;StandardCost],\r\n    p.&#91;ProductLine],\r\n    ceiling(p.&#91;DealerPrice]) as &#91;DealerPrice],\r\n    p.&#91;Class],\r\n    p.&#91;ModelName],\r\n    p.&#91;EnglishDescription],\r\n\ts.&#91;SpanishProductSubcategoryName],\r\n\tleft(upper(c.&#91;SpanishProductCategoryName]),3) as &#91;SpanishProductCategoryName]\r\nFROM &#91;dbo].&#91;DimProduct] p\r\n\tleft outer join &#91;dbo].&#91;DimProductSubcategory] s on (p.&#91;ProductSubcategoryKey] = s.&#91;ProductSubcategoryKey])\r\n\tleft outer join &#91;dbo].&#91;DimProductCategory] as c on (s.&#91;ProductCategoryKey] = c.&#91;ProductCategoryKey])\r\nwhere (p.&#91;Class] &lt;> 'L' or p.&#91;Class] is null) <\/code><\/pre>\n<\/div>\n<\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Lleva la transformaci\u00f3n que rompe el plegado al origen<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Con una <em>Vista<\/em>, que luego incluyes como origen del mismo modo que si fuera una tabla<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Usa <em>NativeQuery<\/em>, incluyendo el flag <em>EnableFolding = True<\/em>. En este caso se puede poner directamente la SELECT de SQL o incluso una ejecuci\u00f3n de un Procedimiento Almacenado, pero si optas por esta opci\u00f3n, recuerda que s\u00f3lo se tratar\u00e1 el primer result set que devuelva.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Cualquier transformaci\u00f3n se puede hacer en SQL<\/strong>: vimos algunos ejemplos, incluidos el pivotado de consultas con nombre de columnas din\u00e1mico.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\"><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Os dejo <a href=\"https:\/\/github.com\/DataCrazyWorld\/DataCrazyWorld\/tree\/main\/Eventos\/Power%20Bi%20Days%20Mallorca%20_%20202309\" target=\"_blank\" rel=\"noopener\" title=\"\">aqu\u00ed<\/a> el enlace a mi GitHub donde podr\u00e9is encontrar:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La presentaci\u00f3n de la charla<\/li>\n\n\n\n<li>El archivo PBIX con los ejemplos<\/li>\n\n\n\n<li>Queries SQL de Demo con varios ejemplos<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Tambi\u00e9n os quiero dejar varios enlaces importantes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Documentaci\u00f3n de Microsoft relacionada: <a href=\"https:\/\/learn.microsoft.com\/es-es\/power-bi\/guidance\/power-query-folding\" target=\"_blank\" rel=\"noopener\" title=\"\">https:\/\/learn.microsoft.com\/es-es\/power-bi\/guidance\/power-query-folding<\/a><\/li>\n\n\n\n<li>Web de mi compa\u00f1era de charla  Ana M\u00aa Bisb\u00e9: <a href=\"https:\/\/amby.net\" target=\"_blank\" rel=\"noopener\" title=\"\">https:\/\/amby.net<\/a><\/li>\n\n\n\n<li>Link a los libros de mi compa\u00f1era Ana M\u00aa, que explican todo esto y m\u00e1s, por si quer\u00e9is comprarlos: <a href=\"https:\/\/www.amazon.es\/Libros-Ana-Mar\u00eda-Bisb\u00e9-York\/s?rh=n%3A599364031%2Cp_27%3AAna+Mar\u00eda+Bisb\u00e9+York\" target=\"_blank\" rel=\"noopener\" title=\"\">https:\/\/www.amazon.es\/Libros-Ana-Mar\u00eda-Bisb\u00e9-York\/s?rh=n%3A599364031%2Cp_27%3AAna+Mar\u00eda+Bisb\u00e9+York<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Conoce mi primera ponencia en el Power BI Days de Mallorca con una compa\u00f1era de lujo. \u00a1Una experiencia maravillosa!<\/p>\n","protected":false},"author":2,"featured_media":359,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7,23,8],"tags":[17,24],"class_list":["post-348","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-eventos","category-power-bi","category-sqlserver","tag-eventos","tag-powerbi"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Conoce mi primera ponencia en el Power BI Days de Mallorca con una compa\u00f1era de lujo. \u00a1Una experiencia maravillosa!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Cristina Tarabini-Castellani Ciordia\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@DataCrazyWorld\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Power BI Days Mallorca \u2013 Septiembre 2023 - Data Crazy World\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Conoce mi primera ponencia en el Power BI Days de Mallorca con una compa\u00f1era de lujo. \u00a1Una experiencia maravillosa!\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@DataCrazyWorld\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2022\/12\/Color_Small.png\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Cristina Tarabini-Castellani Ciordia\" \/>\n\t\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura estimado\" \/>\n\t\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#blogposting\",\"name\":\"Power BI Days Mallorca \\u2013 Septiembre 2023 - Data Crazy World\",\"headline\":\"Power BI Days Mallorca &#8211; Septiembre 2023\",\"author\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Conecta-con-PowerQuery-a-SQL-de-forma-eficiente_Power-BI-Days-PMI-23.png\",\"width\":542,\"height\":486},\"datePublished\":\"2023-11-07T19:00:00+00:00\",\"dateModified\":\"2023-11-07T18:46:10+00:00\",\"inLanguage\":\"es-ES\",\"commentCount\":2,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#webpage\"},\"articleSection\":\"Eventos, Power BI, SQL Server, eventos, powerbi\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com#listItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/datacrazyworld.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/eventos\\\/#listItem\",\"name\":\"Eventos\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/eventos\\\/#listItem\",\"position\":2,\"name\":\"Eventos\",\"item\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/eventos\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#listItem\",\"name\":\"Power BI Days Mallorca &#8211; Septiembre 2023\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com#listItem\",\"name\":\"Inicio\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#listItem\",\"position\":3,\"name\":\"Power BI Days Mallorca &#8211; Septiembre 2023\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/eventos\\\/#listItem\",\"name\":\"Eventos\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\",\"name\":\"Cristina Tarabini-Castellani Ciordia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Cristina Tarabini-Castellani Ciordia\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/DataCrazyWorld\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/cristina-tarabini-castellani\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/\",\"name\":\"Cristina Tarabini-Castellani Ciordia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Cristina Tarabini-Castellani Ciordia\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/DataCrazyWorld\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/cristina-tarabini-castellani\\\/\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#webpage\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/\",\"name\":\"Power BI Days Mallorca \\u2013 Septiembre 2023 - Data Crazy World\",\"description\":\"Conoce mi primera ponencia en el Power BI Days de Mallorca con una compa\\u00f1era de lujo. \\u00a1Una experiencia maravillosa!\",\"inLanguage\":\"es-ES\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Conecta-con-PowerQuery-a-SQL-de-forma-eficiente_Power-BI-Days-PMI-23.png\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#mainImage\",\"width\":542,\"height\":486},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2023\\\/11\\\/07\\\/power-bi-days-mallorca-septiembre-2023\\\/#mainImage\"},\"datePublished\":\"2023-11-07T19:00:00+00:00\",\"dateModified\":\"2023-11-07T18:46:10+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#website\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/\",\"name\":\"DataCrazyWorld\",\"description\":\"SQL Server, PowerShell, Power BI, Power Platform,... Los datos, ese mundo tan interesante, variado, divertido y ... \\u00a1Loco!\",\"inLanguage\":\"es-ES\",\"publisher\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Power BI Days Mallorca \u2013 Septiembre 2023 - Data Crazy World","description":"Conoce mi primera ponencia en el Power BI Days de Mallorca con una compa\u00f1era de lujo. \u00a1Una experiencia maravillosa!","canonical_url":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#blogposting","name":"Power BI Days Mallorca \u2013 Septiembre 2023 - Data Crazy World","headline":"Power BI Days Mallorca &#8211; Septiembre 2023","author":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"publisher":{"@id":"https:\/\/datacrazyworld.com\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/11\/Conecta-con-PowerQuery-a-SQL-de-forma-eficiente_Power-BI-Days-PMI-23.png","width":542,"height":486},"datePublished":"2023-11-07T19:00:00+00:00","dateModified":"2023-11-07T18:46:10+00:00","inLanguage":"es-ES","commentCount":2,"mainEntityOfPage":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#webpage"},"isPartOf":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#webpage"},"articleSection":"Eventos, Power BI, SQL Server, eventos, powerbi"},{"@type":"BreadcrumbList","@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com#listItem","position":1,"name":"Inicio","item":"https:\/\/datacrazyworld.com","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/eventos\/#listItem","name":"Eventos"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/eventos\/#listItem","position":2,"name":"Eventos","item":"https:\/\/datacrazyworld.com\/index.php\/category\/eventos\/","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#listItem","name":"Power BI Days Mallorca &#8211; Septiembre 2023"},"previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com#listItem","name":"Inicio"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#listItem","position":3,"name":"Power BI Days Mallorca &#8211; Septiembre 2023","previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/eventos\/#listItem","name":"Eventos"}}]},{"@type":"Person","@id":"https:\/\/datacrazyworld.com\/#person","name":"Cristina Tarabini-Castellani Ciordia","image":{"@type":"ImageObject","@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g","width":96,"height":96,"caption":"Cristina Tarabini-Castellani Ciordia"},"sameAs":["https:\/\/twitter.com\/DataCrazyWorld","https:\/\/www.linkedin.com\/in\/cristina-tarabini-castellani\/"]},{"@type":"Person","@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author","url":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/","name":"Cristina Tarabini-Castellani Ciordia","image":{"@type":"ImageObject","@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g","width":96,"height":96,"caption":"Cristina Tarabini-Castellani Ciordia"},"sameAs":["https:\/\/twitter.com\/DataCrazyWorld","https:\/\/www.linkedin.com\/in\/cristina-tarabini-castellani\/"]},{"@type":"WebPage","@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#webpage","url":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/","name":"Power BI Days Mallorca \u2013 Septiembre 2023 - Data Crazy World","description":"Conoce mi primera ponencia en el Power BI Days de Mallorca con una compa\u00f1era de lujo. \u00a1Una experiencia maravillosa!","inLanguage":"es-ES","isPartOf":{"@id":"https:\/\/datacrazyworld.com\/#website"},"breadcrumb":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#breadcrumblist"},"author":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"creator":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2023\/11\/Conecta-con-PowerQuery-a-SQL-de-forma-eficiente_Power-BI-Days-PMI-23.png","@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#mainImage","width":542,"height":486},"primaryImageOfPage":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/#mainImage"},"datePublished":"2023-11-07T19:00:00+00:00","dateModified":"2023-11-07T18:46:10+00:00"},{"@type":"WebSite","@id":"https:\/\/datacrazyworld.com\/#website","url":"https:\/\/datacrazyworld.com\/","name":"DataCrazyWorld","description":"SQL Server, PowerShell, Power BI, Power Platform,... Los datos, ese mundo tan interesante, variado, divertido y ... \u00a1Loco!","inLanguage":"es-ES","publisher":{"@id":"https:\/\/datacrazyworld.com\/#person"}}]},"twitter:card":"summary_large_image","twitter:site":"@DataCrazyWorld","twitter:title":"Power BI Days Mallorca \u2013 Septiembre 2023 - Data Crazy World","twitter:description":"Conoce mi primera ponencia en el Power BI Days de Mallorca con una compa\u00f1era de lujo. \u00a1Una experiencia maravillosa!","twitter:creator":"@DataCrazyWorld","twitter:image":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2022\/12\/Color_Small.png","twitter:label1":"Escrito por","twitter:data1":"Cristina Tarabini-Castellani Ciordia","twitter:label2":"Tiempo de lectura estimado","twitter:data2":"5 minutos"},"aioseo_meta_data":{"post_id":"348","title":null,"description":null,"keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-11-06 19:43:51","updated":"2025-06-04 03:39:31","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\" title=\"Inicio\">Inicio<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\/index.php\/category\/eventos\/\" title=\"Eventos\">Eventos<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPower BI Days Mallorca \u2013 Septiembre 2023\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Inicio","link":"https:\/\/datacrazyworld.com"},{"label":"Eventos","link":"https:\/\/datacrazyworld.com\/index.php\/category\/eventos\/"},{"label":"Power BI Days Mallorca &#8211; Septiembre 2023","link":"https:\/\/datacrazyworld.com\/index.php\/2023\/11\/07\/power-bi-days-mallorca-septiembre-2023\/"}],"_links":{"self":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/comments?post=348"}],"version-history":[{"count":7,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/348\/revisions"}],"predecessor-version":[{"id":360,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/348\/revisions\/360"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/media\/359"}],"wp:attachment":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/media?parent=348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/categories?post=348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/tags?post=348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}