Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ Современные информац...arrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
versions View all 1 versions
addClaim

This Research product is the result of merged Research products in OpenAIRE.

You have already added 0 works in your ORCID record related to the merged Research product.

Разработка и имплементация концептуальной модели информационной системы Business Intelligence на уровне коммерческой службы фармацевтической компании «Saidal»

Development and implementation of a conceptual information system “Business Intelligence” model of a pharmaceutical company's “Saidal” commercial service
Authors: Mekid, L.;

Разработка и имплементация концептуальной модели информационной системы Business Intelligence на уровне коммерческой службы фармацевтической компании «Saidal»

Abstract

Динамичный характер современной бизнес-деятельности, постоянный рост и усложнение информационных потоков вынуждают компании обращаться к наиболее совершенным средствам работы с информацией, одним из таких средств являются инструменты Business Intelligence (BI), предоставляющие набор методов, инструментов и технологий для эффективной поддержки принятия управленческих решений. В статье рассматривается процесс разработки и имплементации концептуальной модели так называемой «легкой» системы BI, охватывающей небольшое число бизнес-единиц, имеющей относительно невысокую стоимость с точки зрения времени реализации и материальных ресурсов и не требующей продвинутых инструментов реализации, на примере коммерческой службы алжирской фармацевтической компании Saidal. С учетом специфики субъекта исследования идентифицированы потенциальные пользователи системы и бизнес-процессы для моделирования. В качестве основы реализации хранилища данных как базового элемента системы был использован инкрементальный гибридный метод, позволивший учесть как потребности пользователей, так и имеющиеся источники данных при использовании в качестве последних реляционных таблиц и ER-диаграмм. Построение хранилища реализовано с помощью инструментов многомерного моделирования на базе схемы звезды. Сконструированы два OLAP-куба, формализован процесс загрузки данных в хранилище. Использование диаграмм ER, созданных с помощью языка UML, позволило разбить систему на модули, соответствующие потенциальным пользователям системы, и создать удобные и интуитивно понятные интерфейсы для каждого из них, предоставляющие возможность мониторинга, анализа и оценки результатов бизнес-деятельности коммерческой службы компании, а также стратегического планирования. При определении показателей эффективности был использован предложенный А. Фернандесом метод GIMSI. В части имплементации полученного решения определены технические средства его реализации, адекватные имеющимся в компании ресурсам. 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.

Related Organizations
Keywords

OLAP, dashboards, Информационная система, data warehouse, хранилище данных, поддержка принятия решений, Information system, Business Intelligence, многомерное моделирование, multidimensional modeling, информационные панели

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average
gold