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).

Upcoming events (1)

Power Query in the Trenches: 3 Solutions to a Data Problem | Melissa de Korte

**Please note that we are starting much earlier than usual, due to the time difference with the Netherlands.

Excel & Power BI

Data often needs to be reshaped before it can be used for analysis. And just like there are usually three or more ways to do things in Excel, there are often multiple routes to convert ugly data sets into the required tabular format. It’s fascinating how many different approaches you can take! In this session, Melissa de Korte will explore three different solutions that can be used to unwind a messy data set using practical problem solving with Power Query and M.

Melissa is an all-round Power Platform enthusiast! She's on a mission to share what she's learned, in particular her passion for solving practical problems with Power Query and M.

Connect with and follow Melissa at:

TENTATIVE AGENDA (subject to change):

  • 11:45am Teams Meeting opens to attendees to begin joining
  • 12:00pm-12:05pm Welcome and meeting overview
  • 12:05pm-1:05 Feature Presentation
  • 1:05pm-1:10pm Meeting Wrap-up

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.

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 12: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.

Past events (83)

Using Power Query to write back to SQL Server | Cristian Angyal

Needs a location

Photos (167)