• Sydney Power BI Meetup - May 2019

    Microsoft Reactor

    In May we will have 2 presenters speaking on Power BI Integration with Power Apps and Financial Modelling with Power BI. Agenda: 5:30pm: Registration and Networking 5:50pm: Power BI Updates - Matt Allington & Iman Eftekkhari 6:10pm: Power BI Integration with Power Apps - Marylyn Pandit 6:40pm: Design financial reporting models with Power BI - Tom Sun 7:15pm: Q&A and Networking Topic 1: Power BI Integration with Power Apps Both Power BI and Power Apps work effectively on their own. Power Apps is becoming the latest trending tool for organizations to be able to build apps/workflows that are tailored to their needs. Many users are wanting to write back to the database from their reporting platform. Organizations have been using trial and error attempts using SSRS parameters which just aren’t best practices. PBI also only offers static commentary. One such workflow is the dynamic commentary that give the user the flexibility to write back to the database from a Power BI platform, when both Power BI and Power apps integrate with each other. You will get to know the following.  Introduction to Power Apps  Commonalities between Power Apps and Power BI  How can Power BI Integration benefit users in real life?  Why should Power Apps talk to Power BI?  What is Power BI Integration?  Architecture overview with PBI Integration Demo  Filtering Power Apps from Power BI Marylyn is currently working as the Data Analytics Consultant for Wardy IT Solutions. She has been working in Data Analytics/ BI for more than 8 years now. She has worked on various Data Analytics technologies such as Power BI, SSRS, Tableau, etc as well as latest Microsoft technologies. She is a Microsoft Certified Technology Specialist. She is passionate about data analytics. She is an active participant in the community events such as PUG , Microsoft ignite etc. Topic 2: Design financial reporting models with Power BI Tom is a consultant as Agile Analytics and has worked in BI world for the past 7 years, mainly focus on Microsoft technologies. In addition, he is a qualified CPA and I spend lots of time doing financial reporting with Power BI, such as profit and loss statement and balance sheet. 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: https://sydney-power-bi-user-group-pug-meetup-may-2019.eventbrite.com.au

    1
  • Sydney Power BI Meetup - Apr 2019

    Microsoft Reactor

    In April we will have Peter Myers speaking on Power BI modelling with a specific focus on relationships. Agenda: 5:30pm: Registration and Networking 5:50pm: Power BI Updates 6:00pm: Everything You Always Wanted to Know About Relationships* (*But Were Afraid to Ask) by Peter Myers 7:00pm: Q&A and Networking Topic: Everything You Always Wanted to Know About Relationships* (*But Were Afraid to Ask) This is a presentation about Power BI modeling with a specific focus on relationships. In short, relationships are essential to delivering intuitive, accurate and optimal models. Interestingly, relationship design can be considered part science and part art. You will learn what relationships do and how they can be configured for Import, DirectQuery and Composite models . The introduction to relationships is reasonably straight forward. Theory and demos will progress beyond the basics to explain how to achieve sophisticated model designs that include role playing dimensions, many-to-many relationships (two techniques), ambiguous relationships, and disconnected tables. All DAX functions that leverage or modify model relationships will also be covered. Peter Myers is a consultant, trainer and presenter from Melbourne. He has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services. He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007. 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://power-bi-meetup-sydney-april-2019.eventbrite.com.au

    2
  • Sydney Power BI Meetup - Mar 2019

    Microsoft Reactor

    In March we will have two guest speakers. Agenda: 5:30pm: Registration and Networking 5:50pm: Power BI Updates 6:00pm: Bookmarks feature in Power BI by Peter Horniak 6:30pm: Power BI real-time dashboards with Azure Stream Analytics by Neha Kumari (Microsoft) 7:00pm: Q&A and Networking Topic 1) Bookmarks feature in Power BI The Bookmarks feature lets you save the state of visuals and filters in a report, so you can share analyses and tell a story through your data. The Buttons feature adds interactivity to your reports You can combine Bookmarks & Buttons to achieve great results: - Reduce visual clutter for your users - Enable additional filtering options - Improve access to features such as Q&A and page navigation - And a few surprises! Peter volunteered with Waterwatch to do chemical monitoring. On the side he visualised their 24-year dataset. He will show you the bookmark basics, and then dive into the advanced features from the report. Topic 2) Power BI real-time dashboards with Azure Stream Analytics Azure Stream Analytics enables you to take advantage of one of the leading business intelligence tools, Microsoft Power BI. In this Demo packed session, you learn how create business intelligence tools by using Power BI as an output for your Azure Stream Analytics jobs. You also learn how to create and use a real-time dashboard. Neha is a Data & AI technical specialist at Microsoft with her focus towards business intelligence and AI adoption. She comes from Analytics background with core skills around SQL server, Reporting and analytics. She also has experience across all the solution areas in Data Platform and Artificial Intelligence. 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: https://power-bi-meetup-sydney-march-2019.eventbrite.com.au

    6
  • Sydney Power BI Meetup - Jan/Feb 2018

    Microsoft Reactor

    Happy New Year Power BI Pros. We have decided to hold a single meetup for Jan and Feb on 30th Jan 2019. As usual, Matt Allignton and Iman Eftekhari will share anything new and interesting in Power BI. Please RSVP using our Eventbrite registration page: https://power-bi-meetup-sydney-jan-2019.eventbrite.com.au 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

  • Sydney Power BI Meetup - Dec 2018

    Microsoft Reactor

    December session of Sydney Power BI User Group meetup will be a networking event to celebrate upcoming holidays together as a Power BI Community. Matt Allignton and Iman Eftekhari will share Power BI most recent updates. Please RSVP using our Eventbrite registration page: https://sydney-power-bi-meetup-december-2018.eventbrite.com.au 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

    2
  • Sydney Power BI Meetup - Nov 2018

    Microsoft Reactor

    In November we will have two guests speakers who will give the presentation on 'Custom Functions and Recursion in M' and share Power BI success story at Caltex. Agenda: 5:30pm: Registration and Networking 5:50pm: Power BI Updates 6:00 Custom Functions and Recursion in M by Daniil Maslyuk 6:30pm: Power BI Success Story at Caltex by Andrew Olennik 7:00pm: Q&A and Networking Topic 1) Custom Functions and Recursion in M While you can solve many problems in Power Query just by clicking the user interface buttons, in some cases you need to go a step further and write your own code by using the M language. This session introduces you to custom functions and recursion in M. Topic 2) Power BI Success Story at Caltex Everyone has their own Power BI journey. This talk covers the experience of Andrew Olennik, IT Business Analyst at Caltex Australia, in rolling out Power BI within the Customer Service department of Caltex, going from zero adoption in January to having over 60 reports in use by December, and Power BI becoming an essential tool across the entire department. Through the presentation Andrew will share how their journey progressed, some of the lessons learnt, and tips for those embarking on their own journey. Whilst everyone has their own journey, we all start at zero. 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: https://sydney-power-bi-meetup-nov-2018.eventbrite.com.au

    2
  • Sydney Microsoft Power BI User Group (PUG) Meetup - October 2018

    Please register in here: https://microsoft-power-bi-meetup-sydney-oct-2018.eventbrite.com.au In October we will have a guest speaker from Microsoft and 2 presentations one for data analysts, one for data wranglers! Agenda: 5:30pm: registration and networking 5:50pm: Latest updates from Microsoft Ignite 6:00pm to 7:30pm: presentations (Matt Allington and Iman Eftekhari) 7:30pm: Q&A, networking Latest updates from Microsoft Ignite: in this session Mohamed Kabiruddin (Cloud Solution Architect from Microsoft) will share the latest news and exciting announcements in the Microsoft analytics space. Topic 1) 5 tips for better Visual Analytics The process of data analysis doesn’t stop by finding insights that are valuable to a business. There is no value if those insights don’t turn into actions. The best tool in the analyst’s toolbox is always convincing data visualisation that will illustrate the insight clearly to drive actions. In this session we will look at 5 quick tips to better analyse and visualise data in Power BI. Topic 2) Learning M Using the UI At the September Meetup, Matt showed some hacking tricks using the Power Query UI - there was quite some interest by those that saw it. This follow up session will dive deeper into the hacking concept. The UI is excellent and it lets you do almost everything you can imagine just by clicking on the menu options. Yet under the hood of Power Query is a very powerful functional language called “M”. You can learn a lot about how the language works by using the UI to teach you. In this session Matt introduces the basics of the M language and demonstrates concepts on how to learn more as you write you queries. Venue Sponsor: Gilbert + Tobin is a leading independent corporate law firm and a key player in the Australian legal market. From our Sydney, Melbourne and Perth offices, we provide innovative, relevant and commercial legal solutions to major corporate and government clients across Australia and internationally, particularly in the Asia-Pacific region. GTLAW.COM.AU 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

    5
  • Sydney Power BI User Group (PUG) Meetup - September 2018

    IMPORTANT: Please RSVP and register in here: https://power-bi-meetup-sydney-sep-2018.eventbrite.com.au In September we will have 2 exciting presentations from Program Manager on the Power BI team at Microsoft, and a local expert Martin Kratky. Agenda: 5:30pm: registration and networking 5:50pm: Power BI updates, tips and news (Matt Allington and Iman Eftekhari) 6pm to 7:30pm: presentations 7:30pm: Q&A, networking Topic 1: Enterprise Performance Management with Power BI Principles of effective information design: best visuals for specific business requirements and common mistakes to avoid Best practice for building financial models in Power BI Tips & tricks to build professional finance reports Variance and other typical calculations required for business users How to effectively display KPI’s and variances Best practice for building planning models in Power BI Options for managing data entry, planning with: PowerApps, Microsoft Flow and Acterys Topic 2: Power BI embedded and security from the product team Sergei Gundorov The presenter, Sergei Gundorov, currently works as a Program Manager on the Power BI team at Microsoft. He has Master’s Degree in Business Administration. Sergei published numerous articles over the course of the last 27 years through multiple channels on various subjects that range from accounting and economics to in depth technical articles on MSDN (Microsoft Developer Network). Sergei’s most recent contribution was to the Security Whitepaper for Power BI published in July of 2018. He presented his most valuable technological advancements to worldwide developer audiences at TechEd, TechReady, Difinity and Office/SharePoint Developer conferences. He participated and contributed to numerous webcasts that focused on various technologies that he is considered to be an expert on. He is an inventor and filed several patent applications. Sergei runs popular technical “XLGeek’s Space” blog where his work is praised very highly by the readers and his apps users. Sponsors: 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. http://www.agile-analytics.com.au Managility specializes in supporting our clients with the implementation of business intelligence and financial planning & analytics processes. From our offices in North America, Asia Pacific, Europe and India we provide end to end solutions that involve data integration and data warehouse automation, financial analytics & planning as well as artificial intelligence. Acterys enables business users to generate professional data models in the cloud or on premise with a click on a variety of accounting platforms and implement agile planning processes in the quickest possible time.: https://www.acterys.com/ Terms and conditions: * Limited complimentary tickets are available, please only register if you can make it. ** Kindly note this is a corporate event and as a result, we will only be able to accept registrations from a work email address. Requests for registrations from personal email domains such as Gmail may be declined at the organisers’ discretion.*** By attending this event you agree to receive promotional content from the sponsors and organisers.

  • Marco Russo: What Do I Do When My Power BI Report is Slow?

    IMPORTANT: Please register here: https://sydney-power-bi-user-group-august-2018.eventbrite.com.au Special Prize Draw ------------ For this week only, there will be a door prize to win 1 of 2 free tickets to attend the PUG World Tour in Sydney 28-29 Aug. You must register via Event Brite above and be at the meetup during the draw to win. One registration only per person. Details ------------ In August we will have the renowned Marco Russo sharing with us what to do when reports are slow using Power BI. Agenda: —————— 5:30pm: registration and networking 5:45pm: News & Power BI updates (Iman Eftekhari & Matt Allington) 6pm to 7:15pm: presentations (Marco Russo) 7:15pm to 7:30pm: Q&A, networking Topic: Marco Russo: What Do I Do When My Power BI Report is Slow? You created a wonderful Power BI report, but when you open it you have to wait for too long. Changing a slicer selection is also slow. * Where should you start analysing the problem? * What can you do to optimise performance? This session will guide you in analysing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response. At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue. 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. www.agile-analytics.com.au Terms and conditions: * Limited complimentary tickets are available, please only register if you can make it. ** Kindly note this is a corporate event and as a result, we will only be able to accept registrations from a work email address. Requests for registrations from personal email domains such as Gmail may be declined at the organisers' discretion. *** By attending this event you agree to receive promotional content from the sponsors and organisers.

    12
  • Power BI User Group (PUG) - July Meetup - Case Study and Adoption Framework

    IMPORTANT: please register in here: https://sydney-power-bi-meetup-july-2018.eventbrite.com.au In July we will have 2 speakers that will share with us a case study and adoption framework from their experiences using Power BI. Agenda: —————— 5:30pm: registration and networking 5:45pm: Power BI updates and tips (Matt Allington) 6pm to 7:15pm: presentations 7:15pm to 7:30pm: Q&A, networking Topic 1: Case Study of a Power BI implementation How Clade helped travel management company TravelEdge prepare for massive growth by updating and streamlining its reporting processes. After 12 months of rapid growth in every division of the business TravelEdge was on target to double its size in the next three years. However, antiquated internal reporting capabilities were proving to be a major obstacle. A major overhaul was needed to provide the leadership team with the information they needed for growth on this scale. Each department, from HR, Marketing, Sales, Operations, and Finance, had defined their requirements and 73 reports were in scope of the first phase. Microsoft PowerBI was used to deliver the required reports and dashboards within a 3 months’ timeframe. Topic 2: Power BI Adoption Framework (This is a short version of Iman's presentation at SQL Saturday 2018) Power BI has become the new Excel for many business users and its ease of use has made it viral within businesses of all shapes and sizes. Many Business Users started using Power BI with minimum / no IT collaboration that started causing concerns especially within larger organisations regarding security, governance, change management, etc. With the risk of facing another spreadsheet hell in a different form, organisations have become increasingly aware of the need to put a governance and control process in place. In this presentation Iman will use his extensive experience in implementing and rolling out Power BI for many organisations to share some tips from his adoption framework for mid to large size organisations. Sponsors: 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. www.agile-analytics.com.au CLADE Solutions is a leading Microsoft consultancy – and we pride ourselves on getting the best results for our clients by doing things in a different way. We get to know your business – not just where it is now but how far it can go in the future. We develop apps to help you reach your true potential by delivering exceptional customer experiences. We search out simple solutions to the most complex challenges and, as a trusted Microsoft Dynamics 365 partner, we have the most powerful tools at our disposal. We then roll up our sleeves and get on with the job till it’s done. http://www.clade.com.au Terms and conditions: * Limited complimentary tickets are available, please only register if you can make it. ** Kindly note this is a corporate event and as a result, we will only be able to accept registrations from a work email address. Requests for registrations from personal email domains such as gmail may be declined at the organisers discretion. *** By attending this event you agree to receive promotional content from the sponsors and organisers.

    4