A key challenge with the growing volume of measured data in the energy sector is the preparation of the data for analysis. This challenge comes from data being stored in multiple locations, in multiple formats, and with multiple sampling rates. This demonstration considers the collection of time-series data sets from multiple sources including Excel files, SQL databases, and data historians. Techniques for preprocessing the data sets are shown, including synchronizing the data sets to a common time reference, assessing data quality, and dealing with bad data. It is then shown how subsets of the data can be extracted to simplify further analysis.
Hey.. How to import the SQL database into the matlab?
Undefined function 'fetch' for input arguments of type 'struct'.
Error in importPMUdata (line 14)
curs = fetch(curs);
Error in working_with_time_series_data (line 36)
Where did the error occur? I can help you fix it.
There are lots of interesting commands to copy. It provides good examples of how to handle and analyze time series.
Hi Matthew, yes curve fitting toolbox is required. I apologise for not including it in the list.
Curve fitting toolbox required!
Added copyright information