Hong Lu, a data scientist at Microsoft, talked about how to use SQL Server R Services to do electricity demand forecasting. The SQL Server R Services available in SQL Server 2016 brings new opportunities to perform in-database advanced analytics. The Energy Demand Forecasting Template with SQL Server R Services demonstrates how to use SQL Server R Services to build an end-to-end, on-prem solution for electricity demand forecasting. The template includes a real time data simulator, feature engineering, model retraining, forecasting and visualization. A Windows PowerShell script is provided to automatically deploy the entire template on the user’s SQL Server.
Reference links:

Source link