1.1 Database Planning
This project bases the database planning process on the needs of a beverage company. The company is known to manufacture, market, and distribute soft drink products internationally. Analysts prepare budget forecasts and compare performance to budget forecasts on a monthly basis. The measures that analysts track are profit, loss and inventory from the financial database. The company uses huge spreadsheet packages to prepare budget data and perform variance reporting. Because they plan and track a variety of products over several markets, deriving and analyzing data is tedious because it is done manually. Last month, they spent most of their time entering and rekeying data and preparing reports. They have determined
…show more content…
The month end processes like Actuals Open, Actuals Close, Forecast Open Part 1, Forecast Open Part 2 and Forecast Close help in analysis of data efficiently. This is implemented through Oracle Hyperion Essbase which provides the ability to deliver critical business information to the right people when they need it. With Essbase, the beverage company can quickly leverage and integrate data from multiple existing data sources and distribute filtered information to end-user communities in the format that best meets the users’ needs. Analysts can interact and intuitively explore data in real time and along familiar business dimensions, enabling them to perform speed-ofthought analytics.
1.2 Scope and Objectives
The Hyperion EPM implementation and an agile project management approach using the Oracle Unified Methodology (OUM) will help meet the following objectives:
• Better communication between implementation team, project management, and stakeholders. This implementation is managed using Agile methodology.
• Provide server sizing recommendations and specifications.
• Implement clustering for production failover.
• Provide recommendations for application archiving strategy.
• Design application to support P&L, Balance Sheet,
In the case of real-time analysis dashboards have become very popular over the past five years they provide a view of key metrics to allow management by exception. Where post transaction data is being analyzed, data warehousing provides the ideal methodology for enhanced forecasting from the data. This also allows the ability to look for improvements in the supply chain, operations, and marketing to adjust processes and refine a message for marketing as part of a continuous improvement program.
One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Company gathers data by using Web analytics and operational systems, we must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.
Implementation is the act of providing a practical means (step-by-step) for goal accomplishment. (GCU, 2011). Successful implementation plan elements include the analysis of the present situation of the organization so that determination of the changes to be done within the organization can be made without any obstacle in the flow of the organization (Damschtoder et al., 2009). The second and the important element of the successful implementation plan is verifying the key mission of the organization, so that the planned implementation can be adjusted and carried out effectively. (Damschtoder et al., 2009).There are five elements involved in the implementation plan, there elements include; stakeholders, work plan, resources and budget, quality control and
Kudler Foods uses shared databases as a means to increase efficiency and to reduce costs. The use of shared databases creates opportunities for the company to view, manage, and analyze information simultaneously thus providing Kudler with the historical data and forecasting options to consider expanding and increasing profits. Tracking technology, groupware, and workflow software allow Kudler the opportunity to track customer tracking purchase behavior patterns to assist in process refining.
Many business use the agile organizational methodology. As they require the ability to remain flexible, enduring ever-changing requirements. The agile organization develops more mission-critical, high-profile systems. Sharing responsibility within small teams (of 15 or less) is also a main principle of an agile organization. Never is a hierarchy design operational in the agile organization, as the group possess the ability to over ride decisions made by management. The agile type of organization displayed itself over time as an entrepreneurial type of organization providing the high-speed changing rather than the standardization of a bureaucratic organization (Johnson, Jackson, & Burrows, 2011).
if the data is unclear it will be diffcult for the user to make a decision [10][11]. On the other hand if there is an unusual rise in product sales, it may alert the product manager about the problem and help resolve before it gets out of hand [10]. In order to select the right metrics the following need to be considered [11].
Successfully migrated OLTP database software development / operations, EDW development / operations and Reporting projects from Waterfall to Scrum within 6-12 months which improved overall product delivery including defect management.
Thus, Agile came into play. This is a faster and smaller method over traditional. Stakeholders get together with small teams to look at cost, resources and expected time frames. This team figures out the computer verbiage, checks and balances, verification coding, iterations, number limits, scripts, all in the early stages of development.
In an organization, it is of utmost importance to have clear communication channels between the various departments that are functioning. In the absence of proper communication, there will be lack of clarity in thought and action. Once a project is taken up, managers across both the teams involved need to communicate adequately the strategies to be followed, the implementation and the possible issues that could arise in the future in order to ensure that the deliverables are met within the timelines.
Coca-Cola is a multi-national corporation that has its headquartered in Georgia, Atlanta. The company involves itself in the business of beverage production. Subsidiary plants are located all over the world i.e. Asia, Africa, Europe, Australia and South America. Since the company has many branches and deals with a whole lot of inventory, there is a need to act proactively and timely so that there are no delays in logistics. Projections of inventory, i.e. inventory forecasting, are often done in the operations and supply chain management so that overproduction and inefficiencies are avoided. Coca-Cola also uses historic data to find out the direction of future trends (Butler, 2015). The process is used by the company to determine near accurate allocation of budgets for future production periods (Jacobs, 2013). There is a need for Coca-Cola as a company to find out the events that affect the company production wise. The occurrences include expectations of sales, and whether they will cause an increase or a decrease in the share price of the company. Nonetheless, forecasting provides a necessary benchmark for Coca-Cola, which has a long-term perspective of operations.
Several adaptations to the traditional approaches like agile, interactive, phased, extreme, etc have been made but each will be expected to meet the requirements of the project objectives, timeline, resources, and deliveries of the stakeholders. Other industry standard certifications like ISO9000 and regulations like the Sarbanes-Oxley have also influenced methodologies and processes used by several organisations (Kerzner, 2003). Generally, managing projects should involved five major process which include the project initiation, planning, execution, monitoring and controlling, and then project closing. See Fig. 2 below.
Module Title: Project Engineering and Management Table of Contents 1.0 Introduction 2 2.0 Origin 3 3.0 Requirements 3 3.1 System requirements................................................................................................................. 3 3.2 Management requirements.................................................................. ....................................4 3.3 Resource requirements..............................................................................................................4 3.4 Products and services requirements..........................................................................................4 3.5 Analysis and improvement requirements.................................................................................. 5 4.0 Benefits of registration........................................................................................................................... 5 4.1 Organisation benefits................................................................................................................
The goal of the team Synergy is to help the client in the development of such Automated Model Compiler (AMC) tool. This tool should ultimately allow the users at Ford to be able to use it in their everyday activities.
Agile methodology. According to McRoberts (2016), companies are employing new scalable systems and technologies that allow them to connect seamlessly connectivity across people, processes and technology, as well as improving employee safety and energy savings, to replace legacy systems which lack the connectivity and intelligence for business efficiency
Data collection is necessary for every business to run, and companies use many internal and external data sources to collect data and then convert this data into information and using it for the company’s benefit.