PowerBI con MS Dynamics AX

Sesión demostrativa de uso de Power BI en Microsoft Dynamics AX 2012 R3

1. Usando PowerBI para ver la data de Microsoft Dynamics AX 29 de Abril 2015 (12 pm GMT -5) Juan M Rafael Resumen: Veremos temas como PowerView PowerQuery , PowerMap aplicados con data empresarial. Está por comenzar: Próximos Eventos Moderador: Kenneth Ureña SQLCLR .NET en el core de SQL Server 6 de Mayo Enrique Cátala Preguntando a Sql Server con DMV 13 de Mayo Ahias Portillo BIML para automatizar patrones de ETL 20 de Mayo Miguel Egea

2. Power BI for your Microsoft Dynamics AX Implementation Juan Rafael Technology Consultant AX/CRM – ARBENTIA Peru [email protected] @ jlc_rve http://Limaitpro.sqlpass.org

3. Power BI

4. Microsoft Power BI for Office 365 Collaborate in Office 365 Insights in Excel Analyze Visualize Share Find Q & A Mobile Discover Search, access, and transform public and internal data sources with Power Query Share data views and workbooks refreshable from on-premises and cloud based data sources, with Power BI Sites Easy data modeling and lightning fast in-memory analytics with Power Pivot Bold new interactive data visualizations with Power View and Power Map Ask questions and get immediate answers with natural language query Mobile access through HTML5 and touch optimized apps for Windows 8, RT and iOS tablets Scalable | Manageable | Trusted

5. User Tools PowerQuery PowerView PowerMap PowerPivot Microsoft Dynamics AX and PowerBI On Premise OData Services Data Management Gateway Other Data sources PowerBI Admin PowerView PowerQ&A Data Catalogue Excel Data Model

6. Microsoft Dynamics AX and Power BI Transforming your data Creating Visualizations Publishing your reports Exploring your Data Extracting data via OData

7. Microsoft Dynamics AX and Power BI Transforming your data Creating Visualizations Publishing your reports Exploring your Data Extracting data via OData

8. PowerQuery

9. Start with the right query. OData URLs are case sensitive for data refresh, the URL in the query needs to match the Query Service. Keep security in mind – are you exposing sensitive data to the wrong parts of your organisation? Transform your data to make it easy for people to understand and explore. Save common Queries to your data catalogue for use across your organisation. Tips for PowerQuery

10. Microsoft Dynamics AX and Power BI Transforming your data Creating Visualizations Publishing your reports Exploring your Data Extracting data via OData

11. PowerView

12. Keep your Visualizations simple Size your visualizations with your end users devices in mind. Leverage Hierarchies in your charts to present clear information which users can drill into Be careful not to put fields with a high number of values on charts – PowerView will limit the data Tips for PowerView

13. Microsoft Dynamics AX and Power BI Transforming your data Creating Visualizations Publishing your reports Exploring your Data Extracting data via OData

14. Microsoft Dynamics AX and Power BI Transforming your data Creating Visualizations Publishing your reports Exploring your Data Extracting data via OData

15. PowerBI and Q&A

16. Invest time in PowerQuery to only publish quality, transformed and end user friendly data. Optimize your data for Q&A. Learn from end user usage of Q&A as to what is being asked and what optimization is needed. Plan your SharePoint security to ensure your data is secure. Tips for PowerBI and Q&A

17. What’s next for PowerBI

18. See all your data in a single pane of glass Live dashboards and interactive reports Monitor live dashboards for the data that matters most Ask questions of your data through natural language query Drill through to underlying reports to explore and discover new insight Pin new visualizations and KPIs to monitor performance Dashboards

19. Visualize your data in new ways New Power BI Visualizations Funnel Combo Chart Gauge Tree Map Fill Map

20. Connect live to on-premises data Live Connectivity to SQL Server Analysis Services Analysis Services on-premises Live dashboards and exploration Live Connectivity Faster time to insight with a hybrid BI solution Manage and secure data on-premises with SQL Server Analysis Services Optimized query performance for interactive exploration

21. Stay connected from any device Native apps for iPad, iPhone , and Windows devices Receive alerts to important changes in your data Share and collaborate with colleagues and take immediate action

22. PowerBI.com

23. PowerBI Resources Walkthrough: Creating a PowerPivot Data Mash-up http://technet.microsoft.com/EN-US/library/dn198214.aspx PowerBI Team Blog blogs.msdn.com/b/powerbi/ PowerQ&A Cloud Modelling Here on Microsoft.com

24. Questions?

25. 25

26. 26 Oportunidades de Voluntariado PASS no pudiera existir sin personas apasionadas y dedicadas de todas partes del mundo que dan de su tiempo como voluntarios. Se un voluntario ahora!! Para identificar oportunidades locales visita volunteer.sqlpass.org Recuerda actualizar tu perfil en las secciones de “ MyVolunteering ” y MyPASS para mas detalles .

27. Sigan Participando! Obtén tu membresía gratuita en sqlpass.org Linked In: http://www.sqlpass.org/linkedin Facebook: http://www.sqlpass.org/facebook Twitter: @SQLPASS PASS: http://www.sqlpass.org

28. SQLCLR .NET en el core de SQL Server 6 de Mayo (12 pm GMT -5) Enrique Cátala Resúmen : Es posible utilizar .NET para programar funciones, procedimientos almacenados... en SQL Server pero... ¿es una buena idea hacerlo? SQLCLR es un recurso interesante para cualquier desarrollador de base de datos que nos permite sacar partido ante ciertas situaciones que el propio lenguaje T-SQL no nos permite. En esta sesión veremos pros y contras de utilizar .NET para programar nuestros objetos de BBDD desde un punto de vista funcional y de rendimiento. La idea es responder a la eterna pregunta: ¿Cuándo es bueno usar SQLCLR? Próximo Evento

29. © 2015 Microsoft Corporation. All rights reserved. Microsoft, Windows and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.