Power BI with Big Data Composite Models and

Power BI with Big Data Composite Models and Aggregations

Gaston Cruz – MVP Data Platform Data Analytics Architect Slalom, Seattle /gastoncruz @gastonfcruz gastoncruz@outlook. com PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp

Modelos Composite en Power BI • Factores de Performance • Arquitectura de un Modelo Ad. Hoc • Agrupaciones • Herramientas de 3 eros • Enterprise Data Analytics PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp

Modelos

Factores de Performance • Creacion de Tablas sumarizadas con filtros para entidades transaccionales • Descarta del Modelo Tablas No Utilizadas y Columnas • Documenta las relaciones de tu modelo asi como Medidas y Columnas Calculadas • Modifica Tablas que no sean utilizadas frecuentemente para que se carguen via DQ • Apaga el Auto date/time (Current file/Global) • Remueve bookmarks no utilizados y Mueve Medidas al Modelo o Datasets PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp

Power BI Architecture (Ad-Hoc Model) Conexion via Direct Composite Model Query a entidades Power BI Desktop Dashboard Power BI Desktop implementar Reports Report Tablas/Vistas nuestros Origenes Premium App Workspace PBIX Transaccionales e agregadas en Power BI Service with Premium Capacity Power BI Desktop Composite Model Source Data Systems Source Data Direct. Query Data Warehouse 2 Import Publish Import Direct. Query Dual 3 Dual de Datos utilizando Gateway modo Import en nuestra conexion • Transactional Views in para mejorar • Best Practice to build DW pre calculated columns 1 Data Sources Periodic Data Refresh On-Prem Gateway Periodic Data Refresh nuestra performance. 1 In the first level and to improve performance a View is created in DW with pre calculated columns 2 When reports and dashboards are viewed, Power BI queries its copy of the data stored within the dataset (an in-memory columnstore database) instead of going back to the original data source. This happens with Composite model using Direct Query to DW transactional table and Aggregated Table in Power BI with Import type of connection. Dimensional Tables are going to set via Dual connectivity (DQ with Transactional and Import with Aggregated Table) 3 Publish to PBI Premium Capacity for computing purposes PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp

Power BI - Arquitectura (Modelo Ad-Hoc) PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp

Power BI - Arquitectura (Modelo Ad-Hoc) – Best Practices PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp

Herramientas de la Comunidad Power BI Helper by RADACAD DAX Studio by SQLBI Verti. Paq Analyzer by SQLBI https: //www. sqlbi. com/tools/vertipaqanalyzer/ https: //radacad. com/power-bi-helper https: //www. sqlbi. com/tools/daxstudio/ • • • PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp

Enterprise Data Analytics Security Data modeling In-memory cache Azure Analysis Services Server Lifecycle management PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp Business logic & metrics

Gracias! Nos vemos en el proximo Power BI Bootcamp!!! @gastonfcruz PERÚ BI & ANALYTICS GROUP / Power BI Bootcamp