Implementing Business Intelligence in the Dynamic Beverages Sales and Distribution Environment

Author(s):  
Sami Akabawi ◽  
Heba Hodeeb

To compete successfully in today’s retail business arena, senior management are often demanding fast and responsive Information Systems that enable the company not only to manage its operations but to provide on-the-fly performance measurement through a variety of tools. Use of (ERP) systems have been slow in responding to these needs, despite the wealth of the internally generated business databases and reports as a consequence of functional integration. The specific nature and demands by those senior management staff require the congregation of many external data elements and use data mining techniques to provide fast discovery of performance slippages or changes in the business environment. Data Warehousing and Business Intelligence (BI) applications, evolved during the past few decades, have been implemented to respond to these needs. In this case write-up, we present how the ERP system was utilized as the backbone for use by BI tools and systems to provide Sales and Marketing units in a transnational company subsidiary in Egypt to actively respond to the demands for agile information services. The Egypt subsidiary is the HQ of the African region’s operations of several franchises and distributers of the company products, in addition to operating a beverage concentrate manufacturing plant in Egypt, which services the entire region’s beverage products needs.

Author(s):  
Sami Akabawi ◽  
Heba Hodeeb

To compete successfully in today’s retail business arena, senior management are often demanding fast and responsive Information Systems that enable the company not only to manage its operations but to provide on-the-fly performance measurement through a variety of tools. Use of (ERP) systems have been slow in responding to these needs, despite the wealth of the internally generated business databases and reports as a consequence of functional integration. The specific nature and demands by those senior management staff require the congregation of many external data elements and use data mining techniques to provide fast discovery of performance slippages or changes in the business environment. Data Warehousing and Business Intelligence (BI) applications, evolved during the past few decades, have been implemented to respond to these needs. In this case write-up, we present how the ERP system was utilized as the backbone for use by BI tools and systems to provide Sales and Marketing units in a transnational company subsidiary in Egypt to actively respond to the demands for agile information services. The Egypt subsidiary is the HQ of the African region’s operations of several franchises and distributers of the company products, in addition to operating a beverage concentrate manufacturing plant in Egypt, which services the entire region’s beverage products needs.


2012 ◽  
pp. 1064-1084
Author(s):  
Sami Akabawi ◽  
Heba Hodeeb

To compete successfully in today’s retail business arena, senior management are often demanding fast and responsive Information Systems that enable the company not only to manage its operations but to provide on-the-fly performance measurement through a variety of tools. Use of (ERP) systems have been slow in responding to these needs, despite the wealth of the internally generated business databases and reports as a consequence of functional integration. The specific nature and demands by those senior management staff require the congregation of many external data elements and use data mining techniques to provide fast discovery of performance slippages or changes in the business environment. Data Warehousing and Business Intelligence (BI) applications, evolved during the past few decades, have been implemented to respond to these needs. In this case write-up, we present how the ERP system was utilized as the backbone for use by BI tools and systems to provide Sales and Marketing units in a transnational company subsidiary in Egypt to actively respond to the demands for agile information services. The Egypt subsidiary is the HQ of the African region’s operations of several franchises and distributers of the company products, in addition to operating a beverage concentrate manufacturing plant in Egypt, which services the entire region’s beverage products needs.


Author(s):  
Julius Nyerere Odhiambo ◽  
Elyjoy Muthoni Micheni ◽  
Benard Muma

The quest for sustainable competitive advantage and the urge to adapt to a challenging business environment has made firms around the globe to adopt enterprise resource planning systems so as optimally leverage on the enterprise-wide resources and be more responsive to customer demands. Globally organizations seeking to enhance their competitiveness have utilized Enterprise Resource Planning (ERP) systems to enhance their operational efficiency. The ERP philosophy advocates for the incorporation of personnel, finance, manufacturing, distribution, sales, and marketing modules into a single integrated system and a central database, allowing an organization to efficiently and effectively utilize its resources. The planning and better management of organizational resources, improved business performance, and better integration of business operations can be facilitated by an ERP system to offer an avenue of excellence for a business. Despite the potential benefits an ERP system offers an organization, few studies have explored the ERP reliability in the context of competition driven business imperatives.


2010 ◽  
Vol 09 (02) ◽  
pp. 171-181 ◽  
Author(s):  
Ipek Deveci Kocakoç ◽  
Sabri Erdem

As a result of today's competitive business environment, companies have been trying to improve the utilization of funds effectively in their budgets for information technology investments. These companies retrieve more information with the same set of resources by means of business intelligence methods. According to Rubin (Chabrow, 2004) IT budgets are not simply declining or levelling off, rather, companies are shifting from a pure cost-cut mode to a model that emphasises agility and efficiency. Tremendous daily growth of the company data requires more funds and investment for establishing the technologies and infrastructure necessary for gathering fast and crucial information that supports the decision making process. This necessity gave birth to various business intelligence methods, which mainly aim to process mass amount of collected data from their existing application, and represent it in a way with which companies can apply to their daily competitive decisions. This application primarily concerns the implementation of business intelligence for a retail business company. The aim is to implement built-in business intelligence solutions of the Microsoft SQL Server that holds the commercial information of the company for the past three years. The customer company has already been using Microsoft products. The key items used for analyzing data are sales, momentary inventory and logistics information. The application can be grouped in five main areas: Building the data warehouse, constructing OLAP cubes, applying data mining algorithms on OLAP cubes, representing the results in reports with reporting services, and implementation.


Author(s):  
S. Maguire

The main aim of this chapter is to identify the important role of business intelligence in today’s global business environment and to reveal organizations’ understanding of business intelligence and how they plan to use it for gaining competitive advantage. Increases in business volatility and competitive pressures have led to organizations throughout the world facing unprecedented challenges to remain competitive and striving to achieve a position of competitive advantage. The importance of business intelligence (BI) to their continued success should not be underestimated. With BI, companies can quickly identify market opportunities and take advantage of them in a fast and effective manner. The aim of this chapter is to identify the important role of BI and to understand and describe its applications in areas such as corporate performance management, customer relationship management and supply chain management. The study was conducted in two companies that use BI in their daily operations. Data were collected through questionnaires, personal interviews, and observations. The study identified that external data sources are becoming increasingly important in the information equation as the external business environment can define an organization’s success or failure by their ability to effectively disseminate this plethora of potential intelligence.


2020 ◽  
Vol 3 (1) ◽  
Author(s):  
Sanny Ekawati ◽  
Nur Hidayah ◽  
Purwanto Purwanto

The purpose of the activity is to implement a competitive advantage strategy in the retail business and assistance in making product packaging in increasing retail business sales in the Old Tangerang market. PKM activity is an inspiration from the many retail stores that are not able to increase sales, which is due to competitive advantage strategies that have not been carried out optimally. Given the retail strategy in building a competitive advantage is very necessary for a retailer. The location of the traditional market was chosen because it still needs help from various parties. Including from educational institutions. For this activity partners were chosen because of limited competitive advantage and limited knowledge of the strategy of excellence. In addition, the limitations of partners to build excellence, in assessing internal and external factors in the business environment through SWOT, are indispensable to assist retailers in assessing business excellence. Furthermore, to improve product sales value, better product packaging is needed, this has not been done by partners. The method offered in this activity is the provision of knowledge of retail business excellence strategies, SWOT strategies and packaging design in the form of FGDs, socialization and training. While the assistance is done by making product packaging that is more environmentally friendly. Through this activity will help overcome the problems of partners in doing business better than competitors. Thus the hope can help partners in increasing sales.ABSTRAK:Tujuan kegiatan adalah mengimplementasikan strategi keunggulan bersaing usaha ritel dan pendampingan membuat pengemasan produk dalam meninggkatkan penjualan Usaha Ritel di pasar Lama Tangerang. Kegiatan PKM merupakan inspirasi dari banyaknya toko ritel yang tidak mampu meningkatkan penjulan, yang dikarenakan strategi keunggulan bersaing yang belum dilakukan secara optimal. Mengingat strategi eceran dalam membangun keunggulan bersaing sangatlah diperlukan bagi seorang pengecer. Dipilih lokasi pasar tradisional karena masih sangat membutuhkan bantuan dari berbagai pihak. Termasuk dari lembaga pendidikan. Untuk kegiatn ini mitra yang dipilih karena masih lemahnya keunggulan bersaing, lemahnya pengetahuan akan strategi keunggulan. Selain itu keterbatasan mitra membangun keunggulan, dalam menilai faktor internal dan eksternal di lingkungan usaha melalui SWOT, yang sangat diperlukan untuk membantu peritel dalam menilai keunggulan usaha. Selanjutnya untuk meningkatkan nilai jual produk diperlukan kemasan produk yang lebih baik, hal ini belum dilakukan mitra. Metode yang ditawarkan dalam kegiatan ini adalah pemberian pengetahuan akan strategi keunggulan usaha ritel, strategi SWOT dan desain kemasan dalam bentuk FGD, sosialisasi dan pelatihan. Sedangkan pendampingan dilakukan dengan membuat kemasan produk yang lebih ramah lingkungan. Melalui kegiatan ini akan membantu mengatasi persoalan mitra dalam melakukan usaha secara lebih baik dibandingkan pesaing. Dengan demikian harapannya dapat membantu mitra dalam meningkatkan penjualan


2021 ◽  
Author(s):  
Naveen Kunnathuvalappil Hariharan

As organizations' desire for data grows, so does their search for data sources that are both usable and reliable.Businesses can obtain and collect big data in a variety of locations, both inside and outside their own walls.This study aims to investigate the various data sources for business intelligence. For business intelligence,there are three types of data: internal data, external data, and personal data. Internal data is mostly kept indatabases, which serve as the backbone of an enterprise information system and are known as transactionalsystems or operational systems. This information, however, is not always sufficient. If the company wants toanswer market and industry questions or better understand future customers, the analytics team may need to look beyond the company's own data sources. Organizations must have access to a variety of data sources in order to answer the key questions that guide their initiatives. Internal sources, external public sources, andcollaboration with a big data expert could all be beneficial. Companies who are able to extract relevant datafrom their mountain of data acquire new perspectives on their business, allowing them to become morecompetitive


2021 ◽  
Author(s):  
◽  
Ria van den Berg

<p>Business Intelligence has become a powerful business tool that describes the business environment, the organisation, its situation in terms of markets, customers, competitors and its financial situation. The objective of BI is to increase the overall performance of the organisation through an informed decision making process. This research study objective is to identify the organisational factors that will increase the likeliness of BI adoption by small-to-medium enterprises (SME’s) in New Zealand. Existing research studies however, focus predominantly on the challenges and benefits of BI technologies adoption. Importantly this study do not define BI as purely a technology but defines it as methods, processes and technology that work together to gain intelligent insight from business information. The organisational factors identified that formed the hypotheses of the research model included data management, organisation culture and organisation motivation. These factors were identified through factor analysis that included technology adoption models and existing research studies specifically related to SME BI and technology adoption. The outcome of the research has identified that only organisation motivation in the context of competitiveness and perception of BI’s value and benefits can significantly influence the likeliness of BI adoption. New Zealand SME’s form the backbone of the country’s economy and also operate in extreme competitive niche markets. The adoption of BI practice and the use of information as a strategic resource will enable SME’s to be more innovative and competitive.</p>


2021 ◽  
Vol 11 (1) ◽  
pp. 1-13
Author(s):  
Ritu Srivastava ◽  
Yogesh Yadav

Learning outcomes To enable the students to appreciate the importance of the retail business environment and identification of opportunities set in the context of an emerging market. To make students understand how a value proposition (product) is crafted in a retail organisation. To introduce the technique of developing a service blueprint for designing the retail consumption experience. To induce students to analyse on what criteria should retail business models be evaluated. To introduce the students to the concept of omnichannel retail strategy. Case overview/synopsis The case is about a value-retail chain We Mart India facing the sudden lockdown situation in April 2020 because of the Covid-19 pandemic hitting India. Shailesh Mehta, the Chief Operating Officer of We Mart is wondering what he should do post the lockdown to bring back the retail chain to its pre-Covid fast-paced growth of 25% YOY in June 2019. We Mart focussed on physical stores as a part of its strategy with an emphasis on the in-store experience. The company catered to the aspirations in fashion for the youth through a series of fashion apparel and accessories in Tiers 2 and 3 cities. The company had grown successfully in two decades and had expansion plans for 2020, which now seemed hazy because of this unpredicted biological disruption impacting businesses. Mehta’s worries were intensified by the change in the consumer trend that was witnessing a shift from offline to online. He wondered about how to incorporate this change and also realign the corporate growth plans in amidst of a challenging situation. To add to his woes were thoughts about established competitors online already apart from the existing offline ones. Research methods: This case is based on primary and secondary data gathered through interviews and publicly available secondary sources. The name of the company and protagonist have been disguised. Complexity academic level The case is suitable for post-graduate (masters in buisness administration) level courses on retail management. The length of the case enables the participants to even read in the class. Supplementary materials Teaching Notes are available for educators only. Subject code CSS 8: Marketing


Sign in / Sign up

Export Citation Format

Share Document