Oil is one of the most crucial commodity and energy resource that guarantee the evolution of the ... more Oil is one of the most crucial commodity and energy resource that guarantee the evolution of the economy and industry of a country. The price fluctuation of the oil would be the emerging factor to be concerned and discussed generally in political and economic circle in each and every country. In Sri Lanka also the problem would be same when it comes to oil industry and its influencing factors for price fluctuation. This paper provides a comprehensive implementation of data warehousing process for the petroleum industry data set. Based on the data collection, a broad data analysis has been conducted to discover patterns of oil prices and sales variation with respect to the political and economic impact factors of Sri Lanka. Through the analysis, it has proven that the influencing factors would affect to the oil prices and sales accordingly. Furthermore, this aims to present few predictions based on the analysis.
The Consumer Financial Protection Bureau was established in USA for enabling the USA consumers to... more The Consumer Financial Protection Bureau was established in USA for enabling the USA consumers to report customer support and complaint related information regarding their financial issues with the US government. The complaint data is freely available for analysis and tracking of how efficiently and effectively the financial institutes handle the complaints lodged against them. Each complaint consists of attributes that can uniquely describe and identify it. These features have been exploited for data mining, analysis and predictions. The data warehouse creation and data analysis was done using Microsoft SQL Server Technologies. The data mining techniques such as Microsoft Decision Tree, Microsoft Naïve Bayes, Microsoft Time Series and Microsoft Neural Network models were used in this study. Based on the results, it was observed that there is a correlation between the growth of complaints in certain financial domains with regards to changes in the economic, political and regulatory forces. Probability predictions also show, how each product can get a particular issue-related complaint, how a particular issue can get a timely response, how a particular issue can cause a consumer dispute and what type of issues are mostly lodged via a particular submission method, etc. This information can be used in prescriptive analysis to enhance financial consumer services and also improve the response quality of automated consumer support systems.
Data warehouse is used in many organization as a tool to gain competitive advantage over their co... more Data warehouse is used in many organization as a tool to gain competitive advantage over their competitors. However, in most data warehouse implementations, lot of assumptions are made. By making assumptions, outcome of data warehouse is little far from the truth. Also, these assumptions will veracity of data warehouse is questionable. To avoid veracity of data warehouse, fuzzy logic can be incorporated. In fuzzy logic, fuzzy membership function plays a huge role hence in case of fuzzy data warehouse, fuzzy membership plays a key role as well. In data warehouse, different types of fuzzy membership functions can be introduced. arbitrary, data driven, linguistic, derived, survey-based membership functions are introduced in this research paper for different cases in data warehouse.
Oil is one of the most crucial commodity and energy resource that guarantee the evolution of the ... more Oil is one of the most crucial commodity and energy resource that guarantee the evolution of the economy and industry of a country. The price fluctuation of the oil would be the emerging factor to be concerned and discussed generally in political and economic circle in each and every country. In Sri Lanka also the problem would be same when it comes to oil industry and its influencing factors for price fluctuation. This paper provides a comprehensive implementation of data warehousing process for the petroleum industry data set. Based on the data collection, a broad data analysis has been conducted to discover patterns of oil prices and sales variation with respect to the political and economic impact factors of Sri Lanka. Through the analysis, it has proven that the influencing factors would affect to the oil prices and sales accordingly. Furthermore, this aims to present few predictions based on the analysis.
The Consumer Financial Protection Bureau was established in USA for enabling the USA consumers to... more The Consumer Financial Protection Bureau was established in USA for enabling the USA consumers to report customer support and complaint related information regarding their financial issues with the US government. The complaint data is freely available for analysis and tracking of how efficiently and effectively the financial institutes handle the complaints lodged against them. Each complaint consists of attributes that can uniquely describe and identify it. These features have been exploited for data mining, analysis and predictions. The data warehouse creation and data analysis was done using Microsoft SQL Server Technologies. The data mining techniques such as Microsoft Decision Tree, Microsoft Naïve Bayes, Microsoft Time Series and Microsoft Neural Network models were used in this study. Based on the results, it was observed that there is a correlation between the growth of complaints in certain financial domains with regards to changes in the economic, political and regulatory forces. Probability predictions also show, how each product can get a particular issue-related complaint, how a particular issue can get a timely response, how a particular issue can cause a consumer dispute and what type of issues are mostly lodged via a particular submission method, etc. This information can be used in prescriptive analysis to enhance financial consumer services and also improve the response quality of automated consumer support systems.
Data warehouse is used in many organization as a tool to gain competitive advantage over their co... more Data warehouse is used in many organization as a tool to gain competitive advantage over their competitors. However, in most data warehouse implementations, lot of assumptions are made. By making assumptions, outcome of data warehouse is little far from the truth. Also, these assumptions will veracity of data warehouse is questionable. To avoid veracity of data warehouse, fuzzy logic can be incorporated. In fuzzy logic, fuzzy membership function plays a huge role hence in case of fuzzy data warehouse, fuzzy membership plays a key role as well. In data warehouse, different types of fuzzy membership functions can be introduced. arbitrary, data driven, linguistic, derived, survey-based membership functions are introduced in this research paper for different cases in data warehouse.
Uploads
Papers by Dinesh Asanka