Text this: Enhancing Smart Grids for Sustainable Energy Transition and Emission Reduction with Advanced Forecasting Techniques