• Sydney Power BI Meetup - June 2019

    Microsoft Reactor

    In June we will have 2 speakers, Shaun Loke speaking on Power BI and SAP ERP and Sergei Dumnov speaking on Power BI and R. Agenda: 5:30pm: Registration and Networking 5:45pm: Power BI Updates 6:00pm: Power BI and SAP ERP by Shaun Loke 6:30pm: Power BI and R by Sergei Dumnov 7:00pm: Q&A and Networking Topic 1: Power BI and SAP ERP In this session, Shaun Loke will share the Broadspectrum journey of using Power BI to deliver reporting and analytics based on SAP ERP content. He will also share how this change is making meaningful impact to organisational through the use and interactions of Power BI and their current transformational project to drive self-service analytics using dataflows. He will also demonstrate the process of establishing a Power BI report with SAP content through the use SAP BW. Speaker: Shaun Loke is a Reporting & Analytics Manager within Broadspectrum over the last 7 years responsible for the groups reporting systems. Over the last 2 years, he has supported the business in growing the Power BI application to now support over 200 Pro license users, and 8,000+ end consumers both internal and external. Broadspectrum uses Premium Capacity and Enterprise gateway to facilitate their enterprise solution sourcing data from systems such as SAP, mSQL, Redshift & Salesforce. Topic 2: Power BI and R R is a programming language and free software environment for statistical computing and graphics supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians, data scientists and AI professionals for data analysis, model development and visualization. R can be easily integrated with Power BI to empower its analytical and visualization capabilities. Topics: I. R Installation II. Integrating Power BI & R a) Connecting R and Power BI b) Developing and Testing R code c) Plugging R code into Power BI III. Power Bi & R: Some Data Science Scenarios a) Retails Price Optimisation (today’ s demo) b) Text Analytics c) Portfolio Optimisation IV. Q & A Speaker: Sergei is a data science and business intelligence professional with many years' experience delivering end-to-end predictive analytics and BI solutions. He has architected business intelligence solutions enhanced with predictive analytics, statistical, and machine learning algorithms using R, developed mathematical models of business processes and implemented them using a number of software development tools and languages. Currently he works as a senior data science consultant for Theta Systems (Auckland, NZ). Meetup Sponsor: Agile Analytics is a boutique consulting firm and a Microsoft Gold Partner in Data Analytics. At Agile Analytics, we consult, design and deliver innovative data analytics solutions using state-of-the-art Microsoft cloud technologies including Power BI. http://www.agile-analytics.com.au Please register in the following website to avoid queues: https://microsoft-power-bi-meetup-sydney-june-2019.eventbrite.com.au