DEVELOPMENT AND IMPLEMENTATION OF A CONCEPTUAL INFORMATION SYSTEM “BUSINESS INTELLIGENCE” MODEL OF A PHARMACEUTICAL COMPANY'S “SAIDAL” COMMERCIAL SERVICE
Journal Title: Современные информационные технологии и ИТ-образование - Year 2018, Vol 14, Issue 2
Abstract
The Dynamic nature of modern business operations, the constant growth and the complexity of the data flows companies to turn to the most advanced data processing means, one of these tools is the Business Intelligence (BI) tool: offering a range of methods, tools and technologies for efficient management decision support. Through the example of the Algerian pharmaceutical company Saidal this article dwells on the development and implementation process of the conceptual model of a so called “light” BI system that covers few business units, has a relatively low value in terms of implementation time and material resources, and requires no advanced implementation tools. With consideration of specific features of its subject, the study identifies potential system users and business processes to be modeled. Data warehouse as a fundamental system element was implemented on the basis of the incremental hybrid method, allowing to consider both needs of users and available data sources, the latter are formed by relational tables and ER diagrams. The warehouse is designed with the use of multidimensional modeling tools based on a star schema. Two OLAP cubes were designed, and the process for data import in the data warehouse was formalized. Application of ER diagrams developed with the use of UML language enabled subdividing the system into modules corresponding to potential end-users, and creating user-friendly interfaces for each of them that provide for monitoring, analysis and evaluation of business results of the company commercial service, as well as for strategic planning. Efficiency factors were determined by GIMSI method proposed by A.Fernandez. Respecting the implementation of the obtained solution, the study defines technical means for its realization that are adequate to the resources available to the company.
Authors and Affiliations
Lyes Mekid
Keywords
Related Articles
- EP ID EP522142
- DOI 10.25559/SITITO.14.201802.446-461
- Views 114
- Downloads 0
THE EFFECTIVENESS OF LOCAL SEARCH METHODS IN THE PROBLEM OF FINDING THE MINIMUM ENERGY OF A 2-D CRYSTAL
The work is devoted to solving the problem of finding the energy minimum of the aggregate of atoms of a fragment of a planar crystal lattice. A mathematical statement of the problem is given. For its solution, two classe...
JINR CLOUD SERVICE FOR SCIENTIFIC AND ENGINEERING COMPUTATIONS
Pretty often small research scientific groups do not have access to powerful enough computational resources required for their research work to be productive. Global computational infrastructures used by large scientific...
PROPAEDEUTICS OF PARALLEL COMPUTING IN SCHOOL INFORMATICS: THE COMPUTER GAME «FIREFIGHTING VEHICLES»
The article contains the methodological materials for inclusion of the topic “Parallel Computing” in the school informatics. The computer games “Tank crew”, “Swarm of robots”, “Firefighting vehicles” are considered. The...
COMPARISON OF VARIANTS OF MULTITHREADING REALIZATION OF METHOD OF BRANCHES AND BORDERS FOR MULTI-CORE SYSTEMS
Recently, the main way to improve the performance of computing devices has become an increase in the number of processing cores in the processors, wherefore systems with shared memory have become widespread. Therefore, t...
CLOUD SERVICES FOR NATURAL LANGUAGE PROCESSING
The paper presents the results of experiments conducted with the aim of a comparative analysis of the performance of the existing cloud services for natural language processing in Russian. The article provides an overvie...