| Summary: | 碩士 === 國立中央大學 === 土木工程學系 === 107 === With the importance of energy issues, how to make the occupants of a residential or commercial building more aware of their own electricity consumption and then change their behavior to save electricity has always been the top priority. Today, countries are gradually promoting the installation of smart meters. The literature also has a collection of publicly available power consumption data sets for selected countries. With reference to the national electricity data format, it is necessary to clarify and design the most suitable method for Taiwan, so as to meet the needs of various analysis in the future. Furthermore, this study uses the UK REFIT public data set, transforms the data format requirements for data warehousing analysis, uses Microsoft SQL Server’s data warehousing tools, designs the star schema as well as dimensions and fact tables, and finally presents data warehousing results in the form of trend analysis. In addition to understanding the people's electricity habits and designing energy-saving behaviors, the identified patterns can be extended and applied in the smart meter data sets from Taiwan, so as to plan dynamic energy-saving behaviors to achieve energy conservation.
|
|---|
