Earthquakes are among the natural disasters that have serious effects in many regions of our country and directly affect the lives of individuals, families and societies. Minimizing the damages that may be caused by these disasters is possible by increasing the level of both individual and social awareness. In this context, the disaster awareness of citizens and local governments should be supported by the right guidance and training activities. This study was needed in order to better identify possible risks and to raise awareness on this issue. In the study, Power BI, a business intelligence and data analysis platform developed by Microsoft, was used for the analysis of earthquake data in Turkey. Using the open data source provided by Boğaziçi University Kandilli Observatory and Earthquake Research Institute (BDTIM), data on earthquakes that occurred across Turkey between 30.12.2022 and 30.12.2023 were collected. Data set; It was designed with a Structured Query Language (SQL) query to include earthquake number, province, location, latitude, longitude, magnitude, depth and date information and transferred to the Power BI platform. With this study, in which regions of Turkey earthquakes are more intense, how often large earthquakes occur, and the relationship between earthquake magnitude and depth were examined. The findings are an important resource especially for educators, psychological counselors and guidance specialists. Because shaping the guidance activities to be carried out before and after the disaster with a data-based understanding will contribute to making the society more resistant to disasters. In this context, awareness-raising activities prepared according to regional earthquake risks in school guidance services and community-based education programs can help create disaster awareness among students and families. At the same time, it is of great importance to use such analyzes in the preparation of post-disaster psychosocial support plans. The limitation of the study is revealed by analyzing only the data of the last year. Planning future studies to cover longer periods of time will both increase data reliability and ensure that training and guidance studies are placed on a more solid basis. As a result, this study can be considered as an important step to strengthen disaster education and guidance services, to raise awareness of individuals against disasters and to increase social resilience.