Analysis of local demand trends and forecasting through weather correction and benefit to DSO transistion and microgridsAnalysis of local demand trends and forecasting through weather correction and benefit to DSO transition and microgrids