As local energy markets and distributed energy resources (DERs) become integral to the power system, a deeper understanding of market dynamics is necessary to ensure efficient operation. This thesis aims to build upon previous research by conducting a more detailed analysis of available datasets from flexibility markets, focusing on pricing, participant behaviour, and product characteristics. The objective is to uncover stronger correlations, identify patterns, and draw solid conclusions from the data. This study will explore new datasets as they become available, expanding the scope of analysis to include additional market areas and technologies. By comparing datasets across different market conditions and services, the thesis will provide a clearer picture of how DERs interact with local markets, identify inefficiencies, and propose improvements to the design of market mechanisms, preparing the groundwork for future predictive modelling efforts.