BUSINESS INTELLIGENCE IN RETAIL INDUSTRY ABSTRACT Business Intelligence (BI) tools are extensively adopted by many companies to operate as efficiently as possible. The report investigates a BI adoption in a retail chain. . The analyzed data and reported actionable information help the stakeholders take right decisions in their business. Finally, the presented research identifies innumerous benefits including decision-making to be the most vital by the retail chain managers. Contents DESCRIPTION OF ANALYTICS IN THE RETAIL DOMAIN 2 SYSTEM REQUIREMENTS FOR SAP BO 2 DATA USED IN KNOWLEDGE DISCOVERY 2 DATA SOURCES USED 2 IMPLEMENTATION AND METHODOLOGY USED 2 CONCLUSION -THE REPORTED EFFECTIVENESS OF THE SYSTEM 2 REFERENCES 2 …show more content…
DATA SOURCES USED The following data sources were used by the retailer for their Data Warehouse (DW). 1) Internal ERP system. 2) POS (detail data from individual stores) 3) Shop guard system 4) Planning data gathered during discussions about implementing the BI project. 5) Manual CSV files. Some of the data were acquired through third party applications used in the company. Integration has following layers • Web Application Layer • Database Server Layer • Data Services Service Layer Ad-hoc ETL processes were created to populate the DW. Reporting The various reports which were the most critical part of this implementation included reports for the various functional areas like: 1) Sales. 2) Shopping cart. 3) Customer Turnover. SAP BO objects – OLAP cubes “Each functional area was represented by an OLAP cube and defined reports. OLAP cubes are basic data sources for defined reports. The structure of every OLAP cube in SAP BO tools is defined by “universe.” The BO universe is a business representation of a company´s data that helps end users access data autonomously using common business terms; it also isolates business users from the technical details of the databases where source data are stored. Reports were made in relation to OLAP cubes. Granularity and periodicity were defined for each report by managers of the project team. The creation of a data
The retail industry has seen an increase in revenue as a result of their use of data analytics. The department store, Macy’s, implemented the use and
Business Intelligence (BI) is the consolidation and analysis of internal data and / or external data for the purpose of effective decision-making. At the core of all BI initiatives is a data warehouse to hold the data and analytics software. The data warehouse stores data from operational systems in the organization and restructures it to enable queries and models to extract decision support reports.
As we discuss the possibility of emerging into business intelligence software we must keep in mind the overall purpose of using any type of software is to reach strategic goals in order to increase market shares. I will discuss how business intelligence software will allow us to meet those strategic goals. We will establish what type of information and analysis capabilities will be available once this business intelligence software is implemented. We will discuss hardware and system software that will be required to run specific business intelligence software. Lastly, I will give a brief synopsis on three vendors (IBM, Microsoft Microsoft and Oracle) that are dominating the business information software industry today.
Twila Day left the meeting excited, but also a little nervous. Her Technology and Applications Group had just been given approval by the Director’s Council of SYSCO to proceed with a company- wide deployment of business intelligence (BI) software. The effort was intended to help SYSCO, the largest food distributor in North America, make better use of the information generated by its operations and serve its customers better. The Director’s Council, a group of senior managers with substantial power and influence, had been impressed enough by the results of a
Companies are adopting business intelligence system within their organizations because by using the system reports they can gain the advantages of understanding their internal strength and weaknesses to face external competitors and challenges to increase profits and reduce cost on their everyday operations and processes.
Walmart is the biggest retailer in the world and handles more than one million customer transactions every hour and generates more than 2.5 petabytes of data storage (Venkatraman & Brooks, 2012). To put this into perspective, this data is equivalent to 167 times the number of books in America’s Library of Congress (Venkatraman & Brooks, 2012). So how can Wal-Mart use this massive amount of data and what useful information can this data provide? This paper will provide a brief overview of the importance of Business Intelligence (BI) and how the largest retailer in world, Walmart, is using it.
Organizations began to perceive the abundance of data inside ERP frameworks. The test lies in perceiving the methods for mining, as ERP frameworks was not initially intended to give constant reports to the clients, the whole framework couldn 't encourage the choice bolster capacity. Inside ERP, the BI is the methodology of utilizing nitty gritty client conduct data to best oversee connections for most extreme consumer loyalty, devotion, maintenance and benefit. In this way, a key segment of this BI methodology is an information administration base that empowers organizations to
How much will organizations spend on business intelligence (BI) in 2016? According to Gartner, organizations are projected to spend almost $16.9 billion in 2016. That is an increase of 5.2% over 2015 sales . Business Intelligence plays a big role in today’s business, it now used in every part of the organization from supply chain to human resources (www.gartner.com). This paper will compare two business intelligence software tools. First, I will define business intelligence (BI). Then, I will examine the features of each of the BI tools. Next, I will discuss the pros and cons of each software. This paper will focus on the capabilities and costs for each BI software. Lastly, this paper will indicates which choice was made and an explanation of that choice.
The report focuses on data mining approach to predict human wine taste preferences. A large data set is considered with white and red wine samples (“Vinho Verde” wine from Portugal). The inputs include objective tests (e.g. PH values) and the output is based on sensory data (median of at least 3 evaluations made by wine experts). Each expert graded the wine quality between 0 (very bad) and 10 (very excellent). Due to privacy and logistic issues, only physicochemical (inputs) and sensory (the output) variables are available (e.g. there is no data about grape types, wine brand, wine selling price, etc.).
The report focuses on data mining approach to predict human wine taste preferences. A large data set is considered with white and red wine samples (“Vinho Verde” wine from Portugal). The inputs include objective tests (e.g. PH values) and the output is based on sensory data (median of at least 3 evaluations made by wine experts). Each expert graded the wine quality between 0 (very bad) and 10 (very excellent). Due to privacy and logistic issues, only physicochemical (inputs) and sensory (the output) variables are available (e.g. there is no data about grape types, wine brand, wine selling price, etc.).
The strength of OBR Plus lies in the analytics tool that features executive dashboards to determine key
The amount of data available to suppliers has increased over the last several years. Business intelligence is a becoming a larger influence on the profitability of organizations and is affecting their supply chain management. Until recently, there has been little clarity into the relationship between business intelligence, analytics and supply chain management, but with the shift in information technology, organizations can now collect and organize information more clearly.
This is a kind of predictive analytics which helps to give idea about most critical factors affecting the growth. Business intelligence is proved to be beneficial in decision making. We analyze all data like orders, inventory, accounts, and point of sale transactions and also of customers.
Business intelligence solutions are very significant to an enterprise performance and capabilities at all levels. They help the business to be more efficient, identify new business opportunities and spot areas of cost savings. Timely access to relevant information has been a hindrance to many business successes. The management is always necessitated to base its decision on the full range of information available but the business always has a huge amount of data (IBM, 2014). Due to the current escalating competition that is eroding the business loyal customers, they are required to install
This report focuses on the various advantages associated with the adoption and implementation of data warehousing and data mining technologies at Di Stefano cafe. Specifically, the adoption of data mining and data warehousing technologies at Di Stefano cafe implies that the managers need extra training on the effective use of the technologies; the cafe will utilize the consumer information to discover knowledge regarding consumption and spending patterns, the consumer data will be utilized in accordance with the stipulated guidelines to ensure data integrity, availability, confidentiality and privacy, and that the use of the technologies will give Di Stefano cafe a competitive advantage in terms of value co-creation and differentiated products. However, in order to effectively leverage on the benefits associated with the data mining and data warehousing technologies, Di Stefano cafe needs to train employees and managers on the new system, develop policies and implement security protocols that will ensure and promote