What we’re about
We are a group of Power BI and Modern Excel enthusiasts. This group is dedicated to running monthly meetings to share techniques and inspire incredible data analytics and dashboards using Power BI and the Modern Excel tools (Power Pivot and Power Query).
View recordings of past meet-ups on YouTube: https://www.youtube.com/playlist?list=PLIRJFbuwYskLKHIWt9OBV
Interested in Presenting?
Do you have a topic you’d like to share with the group? We are always looking for people to speak at upcoming meet-ups, and love to hear about the projects you are working on! If you are interested, fill out our online form: https://xlguru.ca/speakatvanpug
Upcoming events (2)
See all- Lambda Dynamic Array Formulas for Statistical Control Plots | Jon PeltierLink visible for attendees
SESSION TRACK:
ExcelSESSION OUTLINE:
Conventional Excel techniques for generating Statistical Process Control (SPC) charts required more helper columns than chart source data columns. With the advent of Dynamic Array formulas, intermediate calculations need not clutter up a worksheet. Microsoft MVP Jon Peltier will show us how conventional SPC formulas can be converted to simple Dynamic Arrays, and how these can be further combined into a single Lambda formula to make dynamic charts as follow-up data is added.SPEAKER PROFILE:
Jon Peltier is a master of leveraging the power of Excel to produce and simplify complex solutions in engineering, finance, and marketing. His background includes Statistics, Total Quality, and Six Sigma, and he knows more about Excel charts than practically anyone. Jon has been a full time Excel developer since 2004, and has received Microsoft’s Most Valuable Professional award for Excel every year since 2001.Connect with and follow Jon online at:
- Website: https://peltiertech.com
- Twitter: https://twitter.com/PeltierTech
TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time):
- 8:45am Teams Meeting opens to attendees to begin joining
- 9:00am-9:05am Welcome and meeting overview
- 9:05am-10:05am Feature Presentation
- 10:05am-10:10am Meeting Wrap-up
REGISTRATION:
This meet-up will be hosted on Microsoft Teams, and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the Teams Meeting link.JOINING THE EVENT:
Attendees can join the Teams Meeting starting at 8:45am on the day of the event. The link will be visible only if you RSVP beforehand.Once the event gets underway at 9:00am, we ask that attendees make sure they are on MUTE, so background noise and distractions are minimized.
During the presentation, attendees can type questions and comments into the chat area, which will be monitored by the event hosts. There will be time for Q&A at the end, where attendees can un-mute their mic and even share their video to ask questions.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
A link to the recording will be posted here on the event page and on the Excelguru social media channels once it is available (usually a day or 2 after the event).
- Getting Started with Python | Sue BayesLink visible for attendees
SESSION TRACK:
Power BISESSION OUTLINE:
This month, we'll learn how to get started with using Python with Microsoft MVP, Sue Bayes. In this introductory session, you'll gain practical experience with Python. Attendees will learn various methods to ingest data, including uploading files directly. You’ll also discover how to use Python commands to make modifications to your data, such as cleaning, transforming, and preparing it for analysis. Finally, we’ll cover efficient ways to save and export your data, ensuring that your work is ready for further use.Whether you’re a complete beginner or looking for a structured introduction, this session provides the nuts and bolts of getting started with Python — empowering you to confidently take the next steps in your data journey.
SPEAKER PROFILE:
Sue Bayes is a Microsoft MVP (Data Platform), and Microsoft Certified as a Fabric Data Engineer Associate, Fabric Analytics Engineer Associate, Azure Enterprise Data Analyst Associate, and Power BI Data Analyst Associate. For over 7 years now, she has been successfully working as an independent Power BI developer and data analyst within the public and private sector. Her reporting solutions range from project management and planning, to financial reporting, specific service sector reporting, bespoke data cleansing, and sentiment analysis. Before starting her own business, she had 15 years of experience lecturing in Business and Computing.Sue is passionate about data in general and how we can harness information to grow business. She has knowledge of R, SQL and C# but her main love is Python, M and DAX. When not in front of the screen, she loves to run, walk her dog, and be outside.
Connect with Sue online at:
- Website: databayes.co.uk
- LinkedIn: linkedin.com/in/suebayes
TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time):
- 8:45am Teams Meeting opens to attendees to begin joining
- 9:00am-9:05am Welcome and meeting overview
- 9:05am-9:20am What's New in Power BI (tentative)
- 9:20am-10:20am Feature Presentation
- 10:20am-10:25am Meeting Wrap-up
REGISTRATION:
This meet-up will be hosted on Microsoft Teams, and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the Teams Meeting link.JOINING THE EVENT:
Attendees can join the Teams Meeting starting at 8:45am on the day of the event. The link will be visible only if you RSVP beforehand.Once the event gets underway at 9:00am, we ask that attendees make sure they are on MUTE, so background noise and distractions are minimized.
During the presentation, attendees can type questions and comments into the chat area, which will be monitored by the event hosts. There will be time for Q&A at the end, where attendees can un-mute their mic and even share their video to ask questions.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
A link to the recording will be posted here on the event page and on the Excelguru social media channels once it is available (usually a day or 2 after the event).
