15.2.Kimball vs Inmon. Ampliación de Conceptos Del Modelado Dimensional
Modelado con Power BI Problema vs Solución
Transcript of Modelado con Power BI Problema vs Solución
Modelado con Power BI Problema vs Solución
Ana María Bisbé YorkConsultora BIPartner Microsoft@sqlpass_eshttp://amby.net/[email protected]@ambynet
1
7 Noviembre 2016
2 |
http://amby.net/2016/03/14/serie-ms-office-excel-2016/
MS Excel 2016
•Mejoras en tabla dinámica
•Nuevos gráficos
•Hojas de pronóstico
•Nuevas funciones Excel y DAX
•Obtener y transformar vs Power Query
•Mejoras en Power Pivot
•Power View
•Mapas 3D vs Power Map
•Mejoras en colaboración
•Excel 2016 y PowerBI
•Excel 2016 para Office 365
http://amby.net/2015/03/04/serie-power-query-vs-power-pivot/
• Y no olvides … Antes de DAX, dispones de:
• la consulta con sus transformaciones
• y el inmenso potencial del lenguaje M
http://www.sqlbi.com/articles/rules-for-dax-code-formatting/
https://www.amazon.com/gp/product/1615470395/ref=as_li_tl?ie=UTF8&camp=1789&creative=390957&creativeASIN=1615470395&linkCode=as2&tag=powe022-20&linkId=QHM62FCPUOXVRTIJ
https://www.youtube.com/watch?v=clIjG9q3iTk
http://amby.net/2015/03/04/serie-power-query-vs-power-pivot/
http://radacad.com/tutorial-introduction-to-power-query
http://radacad.com/power-query-formula-language-m
http://radacad.com/power-query-library-of-functions-shared-keyword
http://radacad.com/how-to-get-list-of-all-functions-and-invoke-them-in-power-query
http://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group
https://blog.crossjoin.co.uk/2016/05/15/creating-m-functions-from-parameterised-queries-in-power-bi/
http://www.amazon.es/dp/073569835X/?tag=wwwsqlbicom0f-21
https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/
http://www.daxpatterns.com/
http://www.daxpatterns.com/usecases/
https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/
https://blog.crossjoin.co.uk/2015/12/15/power-bi-desktop-sort-by-column-and-dax-calculations-that-use-the-all-function/
https://projectbotticelli.com/knowledge/dax-calculated-columns-vs-measures-video-tutorial
https://projectbotticelli.com/knowledge/what-is-time-intelligence-video-tutorial
https://projectbotticelli.com/knowledge/how-calculate-hierarchies-dax-video-tutorial-data-analysis-expressions