Database Memorandum - 1219 Words

Database Memorandum I wanted to review the database tools we have at our disposal and explain what each is used for, when each is appropriate, and some improvements that we are pursuing to makes these tools easier to use and more powerful. For the sales organization there are three database options available to us; Hyperion ®, Access ®, and our most widely used tool, BusinessObjects by SAP. Hyperion: This database is least understood by the sales team because Hyperion ® is only used to gather financial data (Pinnacle Titan Technology Partners [Titan], n.d., p. 1). As a sales team we only use it once a year for creating our annual sales and operating budgets. The system is not easy for us to use, because of its layout and duplication of†¦show more content†¦Future sales initiatives and identification of nationwide hospital trends can provide tremendous industry intelligence that the company can support with new distribution and consulting service offerings. SAP BusinessObjects: BusinessObjects is the most widely used and powerful tool the sales team has at its disposable. This data warehouse provides us with significant volumes of information that can be used to support business decisions both internally and externally. We can answer customer questions in a short time span and document our service to them over the last five years. The service and pricing data is most widely called for and every representative has used their own queries to answer these questions. While the individual initiative to respond to these inquiries is positive, they are inconsistent because of the use of custom queries. We want to ensure that our data is reliable and accurate, so we are going to develop a group of standard queries for internal use by the sales team. Some report will be internally focused and include gross sales and margin data. Others will be externally focused and include customer specific data. Vendor sales volume, fill rates, and pricing credits are all contractual obligations we have to fulfill. With each person running their own reports there are inconsistencies that are being used against us as contract renewals are initiated. Monetary penalties can be invoked and damage to our reputation as a company canShow MoreRelatedBusiness Context : Alaworks Supports Reporting Requirements For Various Federal And State Laws And Regulations1568 Words   |  7 Pageschanges are fully implemented. For the first year, ADECA and Commerce have a Memorandum of Understanding to allow ADECA IT personnel to continue managing Alaworks and assist Commerce with a smooth transition into full ownersh ip. Alaworks is a database system used by approximately 300 individuals throughout the state. Alaworks is built on an Oracle stack consisting of Oracle Forms and Reports on the Oracle Database in a traditional client/server model. Alaworks is not exposed outside of the StateRead MoreData Warehouse Case Study4449 Words   |  18 PagesSpeciï ¬ cally, the CDR must support multiple missions, including research and education, in addition to administration and management. Users include not only analysts and administrators but clinicians, researchers, and students. KEYWORDS †¢ Data warehousing †¢ Database †¢ Academic medical center †¢ Clinical research †¢ Case study †¢ Evaluation Large organizations build data warehouses to â€Å"analyze what has occurred within the business across time† in order to obtain â€Å"a competitive edge in the marketplace.†1 Many healthcareRead MoreAnalysis Memorandum1532 Words   |  7 PagesRunning head: Analysis Memorandum Analysis Memorandum Steven Aran University of Phoenix EDTC 550 Information Technology Janet Luch (FAC) 11/21/2004 Introduction This is an analysis memorandum proposing the use of Microsoft Access databases within our Security Division’s infrastructure. Many security managers are relying heavily on the use of Microsoft Excel spreadsheets in order to keep track of their personnel, security violations, inspection programs and training. While spreadsheetsRead MoreRegional Booking Photo Comparison System And The Goal Of The Core System909 Words   |  4 Pagesfacial recognition technology to assist law enforcement agencies in generating investigative leads. Currently, the RBPCS stores approximately 620,000 mug shot photographs shared between the partnering jails. These mug photographs make up the database. The RBPCS database is made accessible to partnering agencies through advanced workstations that are connected to the core system through the Washington intergovernmental network. In 2015, the Positive ID+ software was purchased from Dynamic Imaging with UASIRead MoreAnalyzing Information Technolo gy Auditing Problems1495 Words   |  6 Pagesprovide further protection for its large database of client information, Shadow Hill instituted a tape backup procedure that automatically backs up the database every Sunday evening, avoiding interruption in the daily operations and procedures. All tapes are then labeled and carefully stored on shelves reserved for this purpose in the data processing department. The departmental operator’s manual has instructions on how to use these tapes to restore the database, should the need arise. A list of homeRead MoreFamily and Medical Leave: A Case Study731 Words   |  3 PagesSome history on the case, Francis started working with Elsevier in 1991. The role of his employment was that of a production assistant. After a while, he was rehired after a company restructuring in which his new position was that of an associate database publishing editor. The main problem of the case concerns his wifes condition, amytrophic lateral sclerosis. D ue to her condition he considered his potential rights under the Family Leave Act with a human resources representative from the companyRead MoreFDEME3L memo 2015928 Words   |  4 Pages2 2 2 1 2 2 2 1 1 1 2 2 2 3 1 5 4 3 2 1 2 5 Q 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 A 4 1 4 3 5 2 3 2 2 4 4 3 4 2 4 3 3 4 4 1 3 2 3 3 4 2 FDEME3L/201 ASSIGNMENT 02 FDEME3L ASSIGNMENT 02 MEMORANDUM 2015 NOTES: 1. This memorandum is only a guideline for the allocation of marks. Many answers may be possible in a particular question. Always judge whether the student’s answer is relevant, true and valid in the context of the question. 2. In any question theRead MoreElectronic Communication and the Negative Impact of Miscommunication1370 Words   |  6 Pagesand Office Pro June 2004) Prewriting 12.5% Brainstorming 25.0% Writing and organizing 25.0% Revising for style 25.0% Proofreading 12.5% Emails are less formal then letters or memorandums; and the authors of emails tend to abbreviate words and use slang to get his or her meaning across quickly. This may be acceptable for communication inside the company, but it will confuse external clients. John Patrick, President of AttitudeRead MoreAutomating Property Accountability1657 Words   |  7 PagesAccounting Service (DFAS). The tool could be either a sub-module of PBUSE or a stand-alone system. By tying into PBUSE, the property book officer would be able to assign a document number and track the status of the FLIPL without having to develop his own database. By connecting with DFAS, the command would be able to ensure that service members found to be financially liable are held financially liable before the FLIPL is forgotten by the command. Connecting Participants One of the biggest challengesRead MoreInternal Communication1502 Words   |  7 Pagesuser can use can load and edit files that they have created on any station, providing the station has the software required to use the files.  · You can use a network to send electronic mail or to access huge databases such as the World Wide Web or a database of all the products a company sells. The disadvantages of networking are:  · The cabling, interface cards, file servers etc. that are required to set up a network are expensive.  · If one computer, cable