what is the best way to analyse this type of data power Query Dash board or pivots

[stratis63]

I m a bit stuck which way to go or which course to choose to resolve the following issue.

I have a table of 1500+events in 30+topics
The events took place all around the globe in the past 3years.
Events were lasting 1-5 days. Locations were fixed.
This system is not sustainable.

So I m asked to analyse the past 3years and make suggestion in order
to cluster up to 5 -6 topics per event, in order to consolidate expenses, create more hype etc. Locations are not fixed but continents will be and dates can fluctuate a bit.

So for example if you had a European topic A in Warsaw in Mid May and in Vienna European Topic B . Why do not consolidate topic A and B in one city in Europe around the same dates

If I had to analyse 10events I could them by hand of course and prepare a nice presentation.
But with 1500+events this is impossible.
Power Query Dash Boards or multiple pivot tables, what is your advise to analyse and present?
I am adding a very small sample

 

[Fluff]

Duplicate to: Filter strategic question

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.