A Project Portfolio Tool for Forecasting Small Projects Profitability

The case company in this study is a large industrial engineering company whose business is largely based on delivering a wide-range of engineering projects. The aim of this study is to create and develop a fairly simple Excel-based tool for the sales department. The tool’s main function is to estimate and visualize the profitability of various small projects. The study also aims to find out other possible and more long-term solutions for tackling the problem in the future. The study is highly constructive and descriptive as it focuses on the development task and in the creation of a new operating model. The developed tool focuses on estimating the profitability of the small orders of the selected project portfolio currently on the bidding-phase (prospects) and will help the case company in the monthly reporting of sales figures. The tool will analyse the profitability of a certain project by calculating its fixed and variable costs, then further the gross margin and operating profit. The bidding phase of small project is a phase that has not been covered fully by the existing tools within the case company. The project portfolio tool can be taken into use immediately within the case company and it will provide fairly accurate estimate of the profitability figures of the recently sold small projects.

Heat Demand Forecasting Models’ Development: Use of Data Mining Tools in SQL Server Analysis Services

This thesis introduces heat demand forecasting models which are generated by using data mining algorithms. The forecast spans one full day and this forecast can be used in regulating heat consumption of buildings. For training the data mining models, two years of heat consumption data from a case building and weather measurement data from Finnish Meteorological Institute are used. The thesis utilizes Microsoft SQL Server Analysis Services data mining tools in generating the data mining models and CRISP-DM process framework to implement the research. Results show that the built models can predict heat demand at best with mean average percentage errors of 3.8% for 24-h profile and 5.9% for full day. A deployment model for integrating the generated data mining models into an existing building energy management system is also discussed.

Forecasting with social media – Using Facebook likes to predict the results of the 2015 Finnish Parliamentary elections

Already one-third of the human population uses social media on a daily basis. The biggest social networking site Facebook has over billion monthly users. As a result, social media services are now recording unprecedented amount of data on human behavior. The phenomenon has certainly caught the attention of scholars, businesses and governments alike. Organizations around the globe are trying to explore new ways to benefit from the massive databases. One emerging field of research is the use of social media in forecasting. The goal is to use data gathered from online services to predict offline phenomena. Predicting the results of elections is a prominent example of forecasting with social media, but regardless of the numerous attempts, no reliable technique has been established. The objective of the research is to analyze how accurately the results of parliament elections can be forecasted using social media. The research examines whether Facebook “likes” can be effectively used for predicting the outcome of the Finnish parliament elections that took place in April 2015. First a tool for gathering data from Facebook was created. Then the data was used to create an electoral forecast. Finally, the forecast was compared with the official results of the elections. The data used in the research was gathered from the Facebook walls of all the candidates that were running for the parliament elections and had a valid Facebook page. The final sample represents 1131 candidates and over 750000 Facebook “likes”. The results indicate that creating a forecast solely based on Facebook “likes” is not accurate. The forecast model predicted very dramatic changes to the Finnish political landscape while the official results of the elections were rather moderate. However, a clear statistical relationship between “likes” and votes was discovered. In conclusion, it is apparent that citizens and other key actors of the society are using social media in an increasing rate. However, the volume of the data does not directly increase the quality of the forecast. In addition, the study faced several other limitations that should be addressed in future research. Nonetheless, discovering the positive correlation between “likes” and votes is valuable information that can be used in future studies. Finally, it is evident that Facebook “likes” are not accurate enough and a meaningful forecast would require additional parameters.