{"title":"Data Preparation for Self-Service BI of Human Resources Analysis in Banking Industry","authors":"Navaphat Bhichesthapong, Mananya Jongkolpatlr, Tanapond Praikasate, Natsuda Kaothanthong","doi":"10.1109/ICESIT-ICICTES.2018.8442065","DOIUrl":"https://doi.org/10.1109/ICESIT-ICICTES.2018.8442065","url":null,"abstract":"The scope of Business Intelligence (BI) has been extended from strategic questions to operational tasks. In this way, the requests for updating the data in reports are generated. Consequently, BI specialists, who are responsible for preparing the data, become insufficient. A Self-Service BI has been introduced to allow non-specialists to derive the information from the large amounts of data without involving BI specialists. In this work, the data preparation for self-service BI for producing human resources reports of a bank is presented. A number of views is created based on the mapped attributes in the data warehouse and the requirements. Then, a data cube is constructed from the SQL command of the views. The configuration of dimensions and measures in BI software allows non-specialists to perform reporting and analytics from a variety of viewpoints. The outcome of the data preparation for BI software allows the non-specialists to produce time-critical reports without involving the BI specialists.","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":"57 1","pages":"1-6"},"PeriodicalIF":0.0,"publicationDate":"2018-05-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"81489905","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
单片机与嵌入式系统应用Pub Date : 2018-05-01DOI: 10.1109/ICESIT-ICICTES.2018.8442058
Parkpoom Tragulnuch, Thitiporn Chanvimaluang, T. Kasetkasem, Salisa Ingprasert, T. Isshiki
{"title":"High Voltage Transmission Tower Detection and Tracking in Aerial Video Sequence using Object-Based Image Classification","authors":"Parkpoom Tragulnuch, Thitiporn Chanvimaluang, T. Kasetkasem, Salisa Ingprasert, T. Isshiki","doi":"10.1109/ICESIT-ICICTES.2018.8442058","DOIUrl":"https://doi.org/10.1109/ICESIT-ICICTES.2018.8442058","url":null,"abstract":"The Aerial Surveillance is an effective method to inspect overhead power transmission line in complicated geographical terrains. However, the practical automatic method is still needed to improve the inspection efficiency. The Canny-Edge detector and Hough transformation are used to extract the power transmission tower straight-line feature. Then, we use object-based image classification to classify the straight-line. The experiments from a set of real-world video sequence have shown the excellent performance of our approach in term of the receiver operating characteristic curve.","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":"55 1","pages":"1-4"},"PeriodicalIF":0.0,"publicationDate":"2018-05-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"75897911","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
单片机与嵌入式系统应用Pub Date : 2018-05-01DOI: 10.1109/ICESIT-ICICTES.2018.8442063
Ukrish Vanichrujee, T. Horanont, W. Pattara-Atikom, T. Theeramunkong, T. Shinozaki
{"title":"Taxi Demand Prediction using Ensemble Model Based on RNNs and XGBOOST","authors":"Ukrish Vanichrujee, T. Horanont, W. Pattara-Atikom, T. Theeramunkong, T. Shinozaki","doi":"10.1109/ICESIT-ICICTES.2018.8442063","DOIUrl":"https://doi.org/10.1109/ICESIT-ICICTES.2018.8442063","url":null,"abstract":"Taxis play an important role in urban transportation. Understanding the taxi demand in the future gives an opportunity to organize the taxi fleet better. It also reduces the waiting time of passengers and cruising time of taxi drivers. Even, there are some works proposed to predict the demand of taxi but there are few studies that consider the function of areas such as hospital area, department store area, residential area, and tourist attraction. One predictive model may not fit with all types of area. We use a point of interest (POI) to match taxi demand with a place to study the taxi demand in the area with a different function. In this paper, we investigate the best predictive models that can forecast demand of taxi hourly with 7 types of area function. The models that were selected for the experiment are long short term memory (LSTM), gated recurrent unit (GRU) and extreme gradient boosting (XGBOOST). Then, we proposed the ensemble model that can forecast the taxi demand well with all types of area function using the information from those machine learning models. We build the models based on a real-world dataset generated by over 5,000 taxis in Bangkok, Thailand for 4 months. The result shows that the proposed ensemble model can outperform other models in overall.","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":"1 1","pages":"1-6"},"PeriodicalIF":0.0,"publicationDate":"2018-05-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"82497156","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
单片机与嵌入式系统应用Pub Date : 2018-05-01DOI: 10.1109/ICESIT-ICICTES.2018.8442066
Ruengwit Khwanrit, S. Kittipiyakul, Jasada Kudtonagngam, H. Fujita
{"title":"Accuracy Comparison of Present Low-cost Current Sensors for Building Energy Monitoring","authors":"Ruengwit Khwanrit, S. Kittipiyakul, Jasada Kudtonagngam, H. Fujita","doi":"10.1109/ICESIT-ICICTES.2018.8442066","DOIUrl":"https://doi.org/10.1109/ICESIT-ICICTES.2018.8442066","url":null,"abstract":"Reducing energy consumption in building is an important motivation for building energy monitoring and management system. In this work we focus on AC current measurement for small to large appliances such as air conditioners. Today's market has many low-cost AC current sensors that use different technologies and come with different usage convenience. This paper aims to compare AC current measurement accuracy for four low-cost current sensors in nowadays market. They are ACS712, WCS1800, SCT013, and PZEM004T. We also discuss about their price and difficulty of installation. We use ESP32 wifi-microcontroller to process measurements. We perform the test using AC loads in small steps from zero up to 20 A. Our results show that PZEM004T gives the best performance among these sensors. However, ACS712 is the best value current sensor because of its low price and performance, although it is more difficult on installation.","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":"41 1","pages":"1-6"},"PeriodicalIF":0.0,"publicationDate":"2018-05-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"81587773","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Defective Parts Reduction in Automotive Wire Assembly Industry by LEAN theory: A Case study","authors":"Nantika Chaikanha, Donreudee Phuhuadon, Lalita Dechawong, Sirirat Phurabat","doi":"10.1109/ICESIT-ICICTES.2018.8442055","DOIUrl":"https://doi.org/10.1109/ICESIT-ICICTES.2018.8442055","url":null,"abstract":"This research purposed to study the method to reduce defective parts or parts that are detected an error for automotive wire assembly of the factory case study. The objective is to reduce the defective parts or the terminal problems. Starting from studying, surveying, data collecting of details and problems, it was found that the terminal problem arose from the fact that it is hanged with the glove resulting in bending and damage until it is unable to be used. Consequently, the authors must search for the solution of the terminal problem with LEAN theory in order to achieve the objective. The tools in this research included Why Why analysis, Affinity Diagram, and Pareto charts to realize the cause of problem why the terminal hanged with the glove because the glove of wire assembly staffs currently has tiny gaps on the palm which is the reason of the hook. The solution is to change the glove for operation and after the replacement, the mean of the terminal problem from 13.80 pieces per month decreases to 0% as expected.","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":"79 1","pages":"1-5"},"PeriodicalIF":0.0,"publicationDate":"2018-05-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"88581571","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
单片机与嵌入式系统应用Pub Date : 2018-01-01DOI: 10.1007/978-3-319-55306-1_3
T. Kono, T. Saito, T. Yamauchi
{"title":"Overview of Embedded Flash Memory Technology","authors":"T. Kono, T. Saito, T. Yamauchi","doi":"10.1007/978-3-319-55306-1_3","DOIUrl":"https://doi.org/10.1007/978-3-319-55306-1_3","url":null,"abstract":"","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":"21 1","pages":"29-74"},"PeriodicalIF":0.0,"publicationDate":"2018-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"87670868","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
单片机与嵌入式系统应用Pub Date : 2018-01-01DOI: 10.1007/978-3-319-55306-1_4
A. Conte, F. Disegni, F. L. Rosa, A. Maurelli
{"title":"Floating-Gate 1Tr-NOR eFlash Memory","authors":"A. Conte, F. Disegni, F. L. Rosa, A. Maurelli","doi":"10.1007/978-3-319-55306-1_4","DOIUrl":"https://doi.org/10.1007/978-3-319-55306-1_4","url":null,"abstract":"","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":"53 1","pages":"75-129"},"PeriodicalIF":0.0,"publicationDate":"2018-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"74849900","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
单片机与嵌入式系统应用Pub Date : 2018-01-01DOI: 10.1007/978-3-319-55306-1_5
N. Do, H. Tran, A. Kotov, V. Tiwari
{"title":"Split-Gate Floating Poly SuperFlash® Memory Technology, Design, and Reliability","authors":"N. Do, H. Tran, A. Kotov, V. Tiwari","doi":"10.1007/978-3-319-55306-1_5","DOIUrl":"https://doi.org/10.1007/978-3-319-55306-1_5","url":null,"abstract":"","PeriodicalId":57136,"journal":{"name":"单片机与嵌入式系统应用","volume":"32 1","pages":"131-178"},"PeriodicalIF":0.0,"publicationDate":"2018-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"79796649","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}