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- Excel Quick Tips - Not a Formula in Sight! | Lee BeckerLink visible for attendees
SESSION TRACK:
ExcelSESSION OUTLINE:
Grow you essential Excel skills with Lee Becker! This session is intended to help the average Excel business user by focusing on practical tricks and tips that that Lee has collected over the years and personally found useful. (She has chosen to leave out formulas in this session to make it accessible to the widest range of users.) These tips are simple ways to increase productivity, even for people who have been using Excel for a long time.SPEAKER PROFILE:
Lee Becker loves working with data, using Excel and solving a puzzle. She hates waste and loves efficiency. A lot of what she has learned has stemmed from helping friends and colleagues with their problems, and coming up with practical, user friendly solutions.Connect with and follow Lee online at:
- LinkedIn: linkedin.com/in/lee-becker-lovedata
TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time):
- 12:45pm Teams Meeting opens to attendees to begin joining
- 1:00pm-1:05pm Welcome and Meeting Overview
- 1:05pm-1:45pm Feature Presentation
- 1:45pm-1:55pm Questions, Discussion, and 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 12:45pm on the day of the event. The link will be visible only if you RSVP beforehand.Once the event gets underway at 1:00pm, 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.
- Manage Change in Power BI Reports & Semantic Models with Git | Scott StaufferLink visible for attendees
**NOTE: This meeting we are partnering with the new Vancouver Microsoft Data Platform Professionals Meetup. VMDPP will provide an in-person experience, and VanPUG will host the on-line Teams Meeting and YouTube recording.
The Vancouver Microsoft Data Platform Professionals Meetup will be meeting in person at the Microsoft Gastown Office in Vancouver, BC.
This is a great opportunity for members of our communities living in the Vancouver area to connect in person.If you’d like to attend in person, please register here at VanPUG, so that you’ll have access to the recording, but also register at the Vancouver Microsoft Data Platform Professionals Meetup page, so that you are admitted into the venue.
SESSION TRACK:
Power BISESSION OUTLINE:
We'll start things off with Joseph Yeates showing us What's New in Power BI. Then, we're excited to welcome Scott Stauffer back as our featured presenter.Many Power BI developers have experienced the frustration of learning that a report that they've developed is no longer working. Upon investigation, they learn that other people have made enhancements to this report and somewhere along the timeline, things have fallen off the rails.
Today's reality is that Power BI does little to help you compare changes across versions, or indicate "who made what change, when?" The .pbix file format makes it difficult to see the code stored in the file for the various report components, conversely making it difficult to track changes across versions or a Power BI Report.
But don't be discouraged - all is not lost! Microsoft MVP alum, Scott Stauffer will show us that a solution exists using Git and the .pbip file format. We can leverage Git, a free, open-source version control system, to provide the ability to track changes over time. Git then leverages the file and folder structure of the .pbip (Power BI Project) file format to make identifying differences easier.
SPEAKER PROFILE:
Scott Stauffer has spend the better part of the last 25 years moving data around, mostly with the help of Microsoft SQL Server, and now Microsoft Fabric and Azure. Scott's "passion work" is supporting the Microsoft Data Community, and being a volunteer puppy trainer for the BC & Alberta Guide Dogs. Scott's a former Microsoft Data Platform MVP, SQLSaturday organizer, and user group leader.Connect with Scott online at:
TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time):
- 9:45am Teams Meeting opens to attendees to begin joining
- 10:00am-10:05am Welcome and meeting overview
- 10:05am-10:20am What's New in Power BI
- 10:20am-11:20am Feature Presentation
- 11:20am-11:25am Meeting Wrap-up
REGESTRATION
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 9:45am on the day of the event. The link will be visible only if you RSVP beforehand.Once the event gets underway at 10: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).
