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

%3CLINGO-SUB%20id%3D%22lingo-sub-2932223%22%20slang%3D%22en-US%22%3Ewhat%20is%20the%20best%20way%20to%20analyse%20this%20type%20of%20data%20%3Fpower%20Query%20Dash%20board%20or%20pivots%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2932223%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CP%3E%26nbsp%3BI%20m%20a%20bit%20stuck%20which%20way%20to%20go%20or%20which%20course%20to%20choose%20to%20resolve%20the%20following%20issue.%3C%2FP%3E%3CP%3EI%20have%20a%20table%20of%201500%2Bevents%20in%2030%2Btopics%3CBR%20%2F%3EThe%20events%20took%20place%20all%20around%20the%20globe%20in%20the%20past%203years.%3CBR%20%2F%3EEvents%20were%20lasting%201-5%20days.%20Locations%20were%20fixed.%3CBR%20%2F%3EThis%20system%20is%20not%20sustainable.%3C%2FP%3E%3CP%3ESo%20I%20m%20asked%20to%20analyse%20the%20past%203years%20and%20make%20suggestion%20in%20order%3CBR%20%2F%3Eto%20cluster%20up%20to%205%20-6%20topics%20per%20event%2C%26nbsp%3B%20in%20order%20to%20consolidate%20expenses%2C%20create%20more%20hype%20etc.%20Locations%20are%20not%20fixed%20but%20continents%20will%20be%20and%20dates%20can%20fluctuate%20a%20bit.%3C%2FP%3E%3CP%3ESo%20for%20example%20if%20you%20had%20a%20European%26nbsp%3B%20topic%20A%20in%20Warsaw%20in%20Mid%20May%20and%20in%20Vienna%26nbsp%3B%20European%26nbsp%3B%20Topic%20B%20.%20Why%20do%20not%20consolidate%20topic%20A%20and%20B%20in%20one%20city%20in%20Europe%20around%20the%20same%20dates%3C%2FP%3E%3CP%3EIf%20I%20had%20to%20analyse%2010events%20I%20could%20them%20by%20hand%20of%20course%20and%20prepare%20a%20nice%20presentation.%3CBR%20%2F%3EBut%20with%201500%2Bevents%20this%20is%20impossible.%3CBR%20%2F%3EPower%20Query%26nbsp%3B%20Dash%20Boards%20or%20multiple%20pivot%20tables%2C%20what%20is%20your%20advise%20to%20analyse%20and%20present%3F%3CBR%20%2F%3EI%20am%20adding%20a%20very%20small%20sample%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2932223%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

 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

 
0 Replies