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- DAX Counterculture | Greg DecklerLink visible for attendees
SESSION TRACK:
Power BISESSION OUTLINE:
Joseph Yeates will start things off by showing us some of the latest updates and features in Power BI. The we have Power BI and DAX expert, Greg Deckler, as our featured presenter, who will help us rethink how we use DAX. Every technology, over time, develops a certain amount of “conventional wisdom” or “best practices”. However, this culture or group think does not always apply in all cases or is even necessarily correct. This session will cover the following topics:- CALCULATE
- Time Intelligence Functions
- Looping
- DAX Index
- EARLIER
- Columns vs. Measures
- VALUES
- Optimizing your DAX
SPEAKER PROFILE:
Greg Deckler is a prolific writer and respected authority in the field of business intelligence, particularly known for his expertise in Microsoft Power BI and DAX. With over 30 years of experience in technology consulting, Greg currently serves as Vice President at a global technology consulting services firm.Greg’s literary contributions include several influential books aimed at both beginners and advanced users of Power BI, including Learn Power BI 1st, 2nd and 3rd editions, DAX Cookbook, Power BI Cookbook 2nd and 3rd editions, Mastering Power BI 2nd edition, and The Definitive Guide to Power Query (M).
Greg is also an active Power BI community member, having authored more than 7,500 solutions on the Power BI community forums and nearly 200 entries to the community’s Quick Measure Gallery. In addition, Greg often blogs, has founded Power BI user groups, presents at various conferences, and is a seven-time Microsoft MVP for Data Platform.
Beyond writing and community involvement, Greg also runs the YouTube channels Microsoft Hates Greg and DAX For Humans. In addition, Greg is the author of numerous external tools for Power BI including Microsoft Hates Greg’s Quick Measures (MSHGQM).
Connect with and follow Greg online at:
- LinkedIn: https://www.linkedin.com/in/gregdeckler/
- Website: http://www.gregdeckler.com/
- Twitter: https://x.com/GregDeckler
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:15am What's New in Power BI
- 9:20am-10:20am Feature Presentation
- 10:20m-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.
- How to Compete with AI - And Win! | Aditya Kumar DarakLink visible for attendees
SESSION TRACK:
ExcelSESSION OUTLINE:
In this session, Microsoft MVP, Power Query enthusiast, and Financial Analyst, Aditya Kumar Darak, will share about his journey with AI. He will explore how we can shift from seeing AI as an adversary to treating it as a team member. AI is here to stay, and it's like a new team member about whom we don't know much.Aditya will discuss the hurdles he faced in understanding AI and the skills he developed to treat AI as a co-worker. He'll tell us about what sparked his AI obsession, why he started learning AI, how he has embraced AI in his work, and the challenges he encounter as a person from the world of Finance.
Aditya will also share why he remains on this AI path, why feels that AI is his own choice, and what is his overall AI-finance vision. Finally, he'll discuss which skills he will need moving forward, and what types of AI projects excite him.
SPEAKER PROFILE:
Aditya Kumar Darak currently works as a Financial Analyst at Profectus Learning and Talent Solutions Pvt. Ltd. He is mostly focused on transforming financial processes using AI and preparing financial models for investment banking or financial institutions completely with dynamic arrays. He is currently a Microsoft MVP in Excel. Other than talking about AI and Power Query, Aditya loves gaming, reading, and creating content related to financial analytics, Power Query and AI.Connect with and follow Aditya online at:
- LinkedIn: https://www.linkedin.com/in/aditya-darak/
- Git Hub: https://github.com/Hermione-Granger-1176/
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.
