Informatica Economica Vol. 18 No. 3/2014

Issue Topic: Business Analytics

Issue Editor: Anca ANDREESCU, PhD


Predicting Customers Churn in a Relational Database
This paper explores how two main classical classification models work and generate predictions through a commercial solution of relational database management system (Microsoft SQL Server 2012). The aim of the paper is to accurately predict churn among a set of customers defined by various discrete and continuous variables, derived from three main data sources: the commercial transactions history; the users’ behavior or events happening on their computers; the specific identity information provided by the customers themselves. On a theoretical side, the paper presents the main concepts and ideas underlying the Decision Tree and Naďve Bayes classifiers and exemplifies some of them with actual hand-made calculations of the data being modeled by the software. On an analytical and practical side, the paper analyzes the graphs and tables generated by the classifying models and also reveal the main data insights. In the end, the classifiers’ accuracy is evaluated based on the test data method. The most accurate one is chosen for generating predictions on the customers’ data where the values of the response variable are not known.
Keywords: Data Mining, Predictive Analytics, Classification, Decision Tree, Naďve Bayes, Churn Analysis, Microsoft SQL Server

Characteristics of In-Memory Business Intelligence
Mihaela-Laura IVAN 17
Business Intelligence (BI) is an important key in the initiatives of many organizations. BI has developed over the years and the most businesses need to take it to the next level of maturity and improvement can be enabled by SAP HANA. In this paper I presented the evolution of Business Intelligence industry, what others capabilities enterprises still seek and how Business Warehouse on SAP Hana enable these needs. Also, the paper highlights that In-memory Business Intelligence is powerful than data warehouse and Online Analytical Processing projects.
Keywords: Business Intelligence, Data Warehouse, Optimization, SAP HANA, In-Memory

Toward Agile BI By Using In-Memory Analytics
Mihaela MUNTEAN 26
This paper explores one of the newer technologies related to the field of Business Intelligence: in-memory technology. The new class of in-memory BI tools turns a BI solution into an agile BI solution. Also, the paper focuses on the main data models used by in-memory BI technologies and tries to answer following questions: Which are the main characteristics of an agile data model? And, which is the best data model that can be used for enabling an agile BI solution?
Keywords: In-Memory Analytics, “Associative” Data Model, Interactive Visualization, Asso-ciative Search, In-Memory Technology

Business Intelligence Solutions for Wind Power Plants Operation
Simona-Vasilica OPREA, Adela BÂRA 41
The European Union energy strategies imply significant changes in the power systems. These should contribute to sustainable development and protection of the environment by enabling the EU to achieve its targets set in the third package of legislative proposals for electricity and gas markets. Renewable energy sources (RES) in Romania have been encouraged since 2007 and this lead to a large volume of projects. It took several years to have the first MW installed in wind power plants (WPP). Nowadays, the installed wind power in Romania is about 2642 MW, most of them (about 85%) being concentrated in the south-eastern part of the country. Based on recorded data during four years in Romania, a couple of analyses have been performed. They contribute to a better integration of wind energy into power systems. This paper will describe how business intelligence solutions are applied on data regarding wind power plants operation and main conclusions that could be drawn.
Keywords: Business Intelligence, Wind Power Plants Operation, Data Integration, Aver-age/Maximum Output

Development of Spatial Database for Regional Development in Romania
Geographical Information Systems are used in solving many regional development related problems, around the world. Starting from some national programs to famous international ones, such as INSPIRE program, each such initiative uses geospatial data as well in the process of building regional development strategies. This paper presents the main technical components of a geographical information system, meaning the spatial database, the web mapping server and the APIs used to embed the maps into web applications. The development steps for a pre-alpha version of a web GIS application dedicated to the regional development in Romania are also shown. The software tools which were integrated in order to develop the online application were Oracle Spatial, where geospatial data was stored, GeoServer, an open source web mapping server used to generate the map out of the data from Oracle Spatial’s tables and ASP.NET as a web framework for building the website.
Keywords: Regional Development, GIS, Spatial Database, Web Mapping Server

Cyber-Spatial Academic Networking for Energy (Oil, Natural Gas, Electricity) Development in Nigeria
Richard INGWE 66
Philosophers of society/sociology recently espoused the concept of a new society and its new paradigm distinguished from the old that was based on industry and the energy forms that drove them since the industrial revolution. The new society which is driven by information and communications technologies (ICTs) has created the network society whereby cyber-spatial (internet-based) platforms operate in leveraging previous and conventional interaction among researchers concerned with single subjects and/or multi-disciplinary research projects, exchanges of ideas, opinions, concerns/worries, viewpoints, project management, among other issues in the nexus of developing and applying academic knowledge. While most of those that are popularly used are of the universal (non-specific nationality or global) character, fairly country-specific (i.e. restricted membership or nation-focused) cyber-spatial platforms present opportunities for enhancing or optimizing the profit of academic interaction and exchanges that concentrate on challenges that are limited to one country but promote greater understanding among those academics involved compared to the rather universal cyber-spatial platforms. Here, we conceive and hypothetically theorize a cyber-spatial platform for enhancing interaction among Nigerian scholars and academics concerned with energy which has been driving industry. Examined in this article are: contexts of scholarship in Nigeria (tertiary educational institutions, research and knowledge needs for sustainable development; the network society as a suitable framework for theoretically framing the cyber-spatial platform; an exemplary multi-disciplinary approach for multi-disciplinary petroleum oil, natural gas and energy concentrating on (or drawing from) the social sciences; management of the program; discussion and conclusion. The implications of this article for policy is that while the National Universities’ Commission and the Federal Ministry of Education, TETFUND, (Tertiary Education Trust Fund), and related public agencies are responsible for funding and managing the proposed program, it is also the responsibility of individual tertiary educational institutions (TEIs) to demonstrate that the program presents opportunities for lifting it and its peers above the current miserable scenario whereby they all do not count in the list of the world’s 500 leading universities.
Keywords: Cyber-Spatial/Internet, Platforms, Leveraging, Interaction, Researchers, Subjects/Multi-Disciplinary, Research, Program/Projects

Models for Measuring E-Learning Success in Universities: A Literature Review
Iuliana DOROBAT 77
It is obvious that in the Internet era the higher education institutions (HEIs) must innovate the services they offer by integrating ICT (Information and Communication Technology) in the learning process. According to the theoreticians and practitioners insights in the matter, the e-learning systems offer many advantages and compensate the weaknesses of the traditional learning methods. In consequence, it emerged the need for developing a model that measures the success of the e-learning systems. This paper presents results of the research conducted in order to develop a comprehensive model for measuring e-learning system success in universi-ties.
Keywords: E-Learning, Blended Learning, E-Learning Systems, E-Learning Systems Success, Measuring E-Learning System Success

Assisted Learning Systems in e-Education
Gabriel ZAMFIR 91
Human society, analyzed as a learning environment, presumes different languages in order to know, to understand or to develop it. This statement results as a default application of the cog-nitive domain in the educational scientific research, and it highlights a key feature: each essen-tial discovery was available for the entire language compatible society. E-Society is constructed as an application of E-Science in social services, and it is going to reveal a learning system for each application of the information technology developed for a compatible society. This article is proposed as a conceptual one focused on scientific research and the interrelationship be-tween the building blocks of research, defined as an engine for any designed learning system applied in the cognitive domain. In this approach, educational research become a learning sys-tem in e-Education. The purpose of this analysis is to configure the teacher assisted learning system and to expose its main principles which could be integrated in standard assisted instruc-tion applications, available in e-Classroom, supporting the design of specific didactic activities.
Keywords: Research Methodologies, Educational Research, E-Science, E-Education Infra-structure, E-Classroom

Algorithms for Analyzing and Forecasting in a Pharmaceutical Company
Lucelia DEDU 103
This paper presents some of the utilities of using SAS code for analyze and forecast, in a pharmaceutical company. First, data must be cleaned, in order to obtain representative results. Once this stage done, the input can be evaluated and models can be created in SAS, to extract the most valuable information from the initial data. To sustain management decisions, SAS code allows creating different types of reports and has the capability to recode the initial variables into new ones, but keeping the most part of the information contained, through the technique called “principal components analysis”. Another advantage of SAS code is its capability of classifying the initial variables into compact class. Based on scorecards and WOE (Weight of Evidence), notions used in banking analyses, it has been created a model which evaluates the suppliers of the company and ranks them, in order to find out what contracts must be continued and which contracts must be closed.
Keywords: Reports, Principal Components Analysis, Clusters, Scorecard, Weight of Evidence

Publishing Guide for Authors 113

INFOREC Association 115