• No 37: Marco Russo: My Power BI report is slow: what should I do?

    Meetup Agenda • 5:45pm - Arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Greg Nash • 6:15pm - Presentation • 7:15pm - Wrap up My Power BI report is slow: what should I do? You created a wonderful Power BI report, but when you open it you wait too much time. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance? This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Power BI Performance Analyzer 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. About Marco A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips. When he is not working, you can find Marco fine tuning his expertise of Neapolitan pizza or test driving electric cars. Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.

  • No. 36: Environmental Intelligence: How We Use Power BI to Bring Data to Life

    Meetup Agenda • 5:45pm - Arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Luke Hayler/Greg Nash • 6:15pm - Presentation - Alice Drummond and Christian Borovac • 7:15pm - Wrap up Session: Environmental Intelligence: How We Use Power BI to Bring Data to Life The environmental industry is literally drowning in data! Join Alice and Christian from their new company DiscoverEI, where they show how they combine Power BI and motion graphics to bring environmental data to life. This will be an interactive session packed full of Power BI tips and tricks, where we showcase story telling techniques using case studies from the environmental industry. We will share clever DAX patterns and tricks to make your reports more dynamic. We share techniques on how to get the most out of your bookmarks, Q&A and report page tooltips to create intuitive dashboards for a seamless user experience. For the AFL fans in the room, we will also show our AFL Power BI dashboard, to discover new insights into the history of our national game. DiscoverEI At DiscoverEI combine data analytics, computer animations and environmental modelling to transform mountains of data into practical, useful, decision-guiding insights. Alice Drummond and Christian Borovac started DiscoverEI in April 2019, and are using Power BI to help our environmental managers and water authorities secure a more sustainable environment for tomorrow. Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.

    3
  • No. 35 - Chandoo - Cats & Power BI

    Servian Office

    Meetup Agenda • 5:45pm - Arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Greg Nash • 6:15pm - Presentation • 7:15pm - Wrap up Random Cat in Power BI Come and join for all things cats & Power BI. In this fun presentation, we will explore Power Query web connections, Power BI visuals and Power Pivot to create, you guessed it right ... a random cat. So don't pawse, RSVP now, cause this is going to be purrfect. About Chandoo Hello there, my name is Chandoo. My mission in life is to make yo awesome in Excel, Power BI and data analysis. I do this by running my website - Chandoo.org where I share regular tips, tutorials and videos on all things data. I am hopping across the ditch (I live in NZ) to Australia this June to run a few Advanced Excel & Power BI Masterclasses (More info at https://plumsolutions.com.au/chandoo ). Come and say hello and meet my cats, the digital ones. Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.

    5
  • No. 34 - Phil Seamark - Wacky DAX

    Servian Office

    Meetup Agenda • 5:45pm - Arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Luke Hayler • 6:15pm - Presentation • 7:15pm - Wrap up Session: Wacky DAX Did you know the DAX language is far more capable than merely running a SUM over a column, or counting rows in a table? DAX sits on top of one of the fastest databases around, and this session explores some unusual and creative scenarios that you previously would have thought as not possible using just DAX and Power BI. The session aims to reset your understanding of what is possible in DAX by walking through some interesting advanced code highlights from a recent series of games built using DAX (Blackjack, Tic Tac Toe, Hangman, Minesweeper and more). Each game explores different boundaries using DAX and attempts to try and find just where those lines are. Warning: This session will inspire you to add creative and exciting techniques to your own DAX based data models. Linked In : www.linkedin.com/in/seamark Twitter : @PhilSeamark Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.

  • No. 33 - Shaun Loke - Power BI and SAP ERP

    Servian Office

    Meetup Agenda • 5:45pm - Arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Luke Hayler/Greg Nash • 6:15pm - Presentation - Shaun Loke • 7:15pm - Wrap up Session: Power BI and SAP ERP In this session, I will share the Broadspectrum journey of using Power BI to deliver reporting and analytics based on SAP ERP content. I will also share how this change is making meaningful impact to organisational through the use and interactions of Power BI and our current transformational project to drive self-service analytics using dataflows. I 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. Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.

    2
  • No. 32 - Manohar Punna - Bridging the gap between SSRS and Power BI

    Meetup Agenda • 5:45pm - Arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Luke Hayler • 6:15pm - Presentation - Manohar Punna • 7:15pm - Wrap up Session: Bridging the gap between SSRS and Power BI Traditionally, SSRS is used for paginated reports which gives flexibility like drill through reports, subscriptions and print formatting. With Power BI the reports are now more interactive and dynamic. There are still few gaps between these two platforms which are built to purpose. This gap is getting smaller as features are ported between these two platforms. In this session I will be going through various features which are bridging these gaps and point out the differences. These are significant and can affect your decision in choosing the right platform which will fit your needs. Speaker: Manohar Punna is a Data Platform MVP and Vice President of DataPlatformGeeks by passion and a Data Platform Consultant by profession. He is a speaker at various SQL Server Day events and user groups, SQL Saturday events, PASS Summit, SQLBits and SSGAS / DPS conferences. He helps organisations realise the potential of their data by building robust BI and Data Platform systems on on-premises, cloud and hybrid environments. He strongly believes in giving back to the community and is a student for life. Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.

    4
  • Power BI Melbourne - Christmas Drinks!

    Sirius Tech

    Join us for the Power BI User Group Christmas Party! We've decided to have a little get together to celebrate on the rooftop of the new Sirius technology offices in Flinders Lane. Drinks and nibbles provided. Thanks to sponsors: Sirius Technology, Servian and Dear Watson Consulting

    6
  • No. 31 - Warren Dean - Built Your Own Social Media Dashboard

    Meetup Agenda • 5:45pm - Arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Luke Hayler • 6:15pm - Presentation - Warren Dean • 7:15pm - Wrap up Session: Built your own social Media Dashboard There are many paid applications that can collate your various social media accounts into a dashboard. Some are expensive whereas some are not flexible but why not create your own with some Power BI magic and the use of inbuilt API's and a few data dumps. The advantage is this application is completely tailored to your own needs. More details https://www.linkedin.com/pulse/design-your-own-social-media-analytics-dashboard-free-warren-dean/ Speaker: Warren heads the data analytics function at the City of Casey. He has over 10 years’ experience in analytics previously working at the Department of Education and Training and the Department of Justice and Regulation. Warren has a passion for using data to teach and empower by using analytics and simple visualisations to enable data-driven results. His role involves educated, upskilling and encouraging staff to leverage the value of data so that the council can provide effective services to the community. Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.

  • No. 30 - Greg Nash - Managing the App and Workspace landscape in Power BI.

    Welcome to Power BI Melbourne! This month we are pleased to welcome Greg Nash back to the stage. Greg will take us through managing the App and Workspace landscape in Power BI. Meetup Agenda • 5:45pm - arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Luke Hayler • 6:15pm - Presentation - Greg Nash - Managing the App and Workspace landscape in Power BI. • 7:15pm - wrap up Our Speaker - Greg Nash Greg Nash is an independent Power BI and Microsoft Azure Consultant with Dear Watson Consulting http://www.dearwatson.net.au with almost 20 years’ experience in providing various ICT solutions to a broad range of clients. (https://www.linkedin.com/in/gregnash78/). In this session, Greg will share some of the content from his session on Apps and Workspace from the Power BI world tour as well as some additional management tips using Power Shell Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.

    5
  • No. 29 - Michael Berry - Key takeaways from the Power BI World Tour

    Welcome to Power BI Melbourne! This month we are pleased to welcome Michael Berry back to the stage. Michael has been to the recent Power BI World Tour event that started off in Melbourne a few weeks ago. His talk will be about some of his key takeaways from the event. Meetup Agenda • 5:45pm - arrive, meet & greet, drinks • 6:10pm - Welcome & intro - Luke Hayler • 6:15pm - Presentation - Michael Berry - Key takeaways from the Power BI World Tour • 7:15pm - wrap up Our Speaker - Michael Berry Michael is a Business Intelligence specialist with Icon Integration. He has several years of experience in Data Analysis and BI, with his primary focus over the last 3 years being Power BI. He is looking forward to sharing some of his learnings with the group. You can connect with him on LinkedIn (https://www.linkedin.com/in/1michaelberry/). In this session, Michael will be sharing some of the takeaways from the Power BI World tour 2018 and doing a brief recap on the following sessions: • 1. Learnings from General Address • 2. Power BI API For Beginners • 3. Power Query and M Beyond Limits • 4. Power BI Performance Tips and Techniques • 5. Advanced DAX Our Sponsor - Servian Pty Ltd (http://www.servian.com/) A big thank you goes out to our sponsor, Servian, for their support of this Meetup; providing the venue as well as drinks for attendees. Servian is regarded as one of Australia’s most trusted data consultancies and IT advisors. Major organisations have come to rely on our thought leadership on Data Integration, Analytics, Data Warehousing, Application Development as well as the value we provide in support and maintenance. Servian has a proven track record in delivering tailored programs, technological processes and specialist advice that boost business capabilities, operational performance, internal processes, customer service, stakeholder communication and much more. Servian is always on the lookout for talented individuals. If you think you'd be a fit for Servian, get in touch. Sirius Technology (https://www.siriuspeople.com.au/) A big thank also to our co-sponsor, Sirius Technology, for their ongoing support of our Meetup and providing us with food for each event. Sirius Technology recruit across all Technology Disciplines from Development (Front and back-end), Testing, Network and Security, Project Services (PM's, BA's, Project Coordinators) & Data - across all technology stacks. Donna Bowen (https://www.linkedin.com/in/donna-bowen-b2a80179) will be on hand to answer any questions about the industry and recruits specifically within the Business Intelligence and Data space. Anything from Data Scientists, Data Analysts, Business Intelligence Consultants, ETL Developers, Database Administrators etc. across all technology stacks.