Nt1330 Unit 3 Data Analytics
explanatory Essay
738 words
Data Analytics has significantly grown in less than two years, this quick growth has caused the company to evaluate the IT environment and its ability to support the growth and secure the data of the company. The CEO is expecting the company to grow 60% over the next two years; with the success of the company it has been determined that a change to the current IT environment and infrastructure must occur to better support the employees and the customer base. The project will bring several changes to the company; it will first expand the current physical IT environment. It will provide the ability to increase the storage capacity of the current storage requirement and expected growth of data, while establishing a new data warehouse and business analytics applications and user interfaces. The project will also improve security by establishing security policies and it will leverage newer cloud based technology to provide a highly redundant, flexible and scalable IT environment while also allowing the ability to establish a low cost disaster recovery site. To …show more content…
In this essay, the author
- Explains that data analytics has significantly grown in less than two years, which has caused the company to evaluate the it environment and its ability to support the growth and secure the data.
- Explains that the project will bring several changes to the company. it will expand the physical it environment, increase the storage capacity, establish a new data warehouse, and improve security.
- Explains that to prevent project scope, all project tasks will be validated and approved through a change control board. once approved, the project manager will update the plan and assign the necessary resources to complete the task.
- Describes the goals of the project, including expanding the company's office space to three floors, establishing a new data warehouse and user interface, and implementing cloud technologies.
- Explains that the project has several project deliverables, each of which will have an allocated section that will provide a detailed breakdown of the required information.
- Explains that the first project deliverable is the project plan inception document, which provides background information about the company, the type of business, skills, roles, and responsibilities of staff.
- Explains that the second project deliverable is the business requirements document, which provides an overview of the project. it will identify the identified constraints and assumptions of infrastructure expansion and data warehouse build and design.
- Explains that the next project deliverable is a robust, modernized database and data warehouse design. the company collects large amounts of website data and uses this data to analyze it for its customers.
- Explains the third deliverable, which focuses on the implementation of a business analytics application, an interface, and recommendation to leverage cloud technologies.
It will identify the identified constraints and assumptions of the infrastructure expansion and data warehouse build and design. As with any project it will identify the risks. The Scope of the project will be documented in the business requirements document and all other projects that are associated with this project will be documented. The next project deliverable is a robust, modernized database and data warehouse design. The company collects large amounts of website data and uses this data to analyze it for the company’s customers. This document will provide an overview of the new data warehouse along with the type of database design that has been selected for the data warehouse. Included in the appendix of this document is a graphical depiction of the logical design of the
Related
- explanatory
- analytical
- Case Study Of The Hoosier Burger Systemexplanatory essayThe development team has begin to have meetings with both Bob and Thelma Mellankamp. They have expressed that they need to go ahead with an upgrade of their information system. To conduct the planning necessary several step must be taken. These are to include the identification of the issue; the scope of the project as a whole; the feasibility of the project; and the development of a project scope statement in order to identify expectations, deliverables, and benefits of conducting this project.
In this essay, the author
- Explains that the development team has begun to have meetings with bob and thelma mellankamp. they have expressed their need to go ahead with an upgrade of their information system.
- Explains that the mellankamps need to improve their inventory control, customer ordering, and management reporting systems. the new system will focus on information management.
- Explains that the scope of the project is to replace the current information system dealing with inventory control, customer ordering, and management reporting used in the daily operation of hoosier.
- Explains the importance of a project scope statement for bob and thelma's business.
- Explains that bob and thelma have expressed that they need to upgrade the information system. the project needs to be developed through several steps, including the identification of the issue, scope, feasibility, and project scope statement.
- Explains the economics, operations, technical aspects, scheduling, legal and contractual issues, and the ever evasive politics of doing business.
- Explains that increasing patronage and sales has outstripped the company's information system resulting in mismanaged inventory and an ever increase lag time in service.
1155 wordsRead More - Big Data Importanceexplanatory essayBig Data has gained massive importance in IT and Business today. A report recently published state that use of big data by a retailer could increase its operating margin by more than 60 percent and it also states that US health care sector could make more than $300 billion profit with the use of big data. There are many other sectors that could profit largely by proper analysis and usage of big data.
In this essay, the author
- Explains that big data has gained massive importance in it and business today. a report recently published states that use of data by a retailer could increase its operating margin by more than 60 percent.
- Explains that big data promises better margins, more revenue, and improvised operations, but it also brings new challenges to the it infrastructure, which is "extreme data management".
- Explains that file transfers require scheduling for data to be moved to a central database or data warehouse. the frequency of the queries varies from business to business.
- Explains that an enterprise data warehouse could be used to manage big data and extreme workloads, but it is more efficient to preprocess the data before storing it in the warehouse.
- Argues that the most efficient way of handling big data and supporting extreme processing will be to deploy optimized hardware and software solutions for pre-processing different types of big-data workloads.
- Explains that business transaction processing systems have supported extreme transaction workloads even since the beginning of data processing. with the advent of new business, organizations have employed custom and optimized transaction processors to handle application workload.
- Explains the trend towards analytical processing reaching the performance limitation of generalized systems. optimized systems to meet the challenges of extreme workloads are required by organizations.
- Explains that business agility is an important factor in supporting analytical processing in today's fast-paced business environment. real-time action is required in fraud detection applications.
672 wordsRead More - Project Management Life Cycle Descriptionexplanatory essayTo complete the task at hand. the project team will utilize the project management life cycle to ensure the projects forward movement. This cycle promotes an organized manner in which to keep the project within the time scope, budget scopes, and facilitates fluid processes to harness risks and make appropriate decisions based on research, analysis, and proper process usage. This cycle includes five phases: initiating the project, planning the project, executing the plan, monitoring and controlling aspects of the project, and closing the project. In the following outline, a more in-depth background of how these processes will assist and promote the success of the team and specific tasks and budgeting constraints. A thorough description of how the project will be initiated will be discussed, along with a project plan for moving the data center with budget and time constraints considered.
In this essay, the author
- Explains the project management life cycle, which promotes an organized manner to keep projects within the time scope, budget scopes, and facilitates fluid processes to harness risks.
- Explains that an inclusive plan is developed that incorporates the five process areas as well as the nine knowledge areas.
- Explains that initiating the project is the start of a project to build an successful end.
- Explains that the newly hired project manager (pm) for fiction corporation is comprised of ten project management professional (pmp)-certified project managers who have successfully accomplished projects that include wiring closets, data center moves, wireless, network upgrades, and enterprise resource planning deployments.
- Explains that the data center supports remote retail locations, an off-site 100-seat call center, and three remote warehousing operations. primary data processing hardware includes 2 large uninterrupted power supply (ups), 4 rs/6000 aix application servers, 10 virtual servers and 20 personal computer servers.
- Describes the requirements for creating a charter. the charter will include the output of project title and date of authorization, project manager’s name and contact information, summary schedule with start and end dates, description of objectives, success criteria, planned approach, roles and responsibilities matrix.
- Explains that the objective is to move fiction corporations data center in 30 days with previous requirements listed above and success being no interruptions in service throughout the process.
- Explains that the planning phase is crucial to exhibiting a successful project but is viewed negatively due to the difficulty in creating.
- Explains bruce cardos, a principal consultant at datalink, who has extensive experience in relocating data centers.
- Explains that the best approach is to modularize the process and capitalize on personnel strengths and weaknesses to gain best research analysis, preventative risks, communication, and team work.
- Describes the five essential keys to success when relocating a data center.
- Introduces project management: _processes, tools, & techniques. pittsburg technology council. retrieved december 12, 2013.
1287 wordsRead More - Oracle E-Business Suite Case Studyexplanatory essayOracle E-Business Suite is a bundling of several oracle based applications released in February of 2007. The goal is to integrate the global business applications involved with doing online business. And as a result, enables organizations to reduce costs, make better decisions, and increase performance. This is made possible by Oracle’s core relational database management system. No matter if the organization is large, small or medium size, it will be able to help customers manage complexities and solve business related issues. Some of the benefits of Oracle’s E-Business Suite include: lower total cost of ownership compared to IBM POWER7+ by 4 times, easily supporting up to 2,000 concurrent users for higher workloads or further
In this essay, the author
- Explains that oracle e-business suite is a bundling of several oracle based applications released in february of 2007. the goal is to integrate the global business applications involved with doing online business.
- Explains that oracle is one of the largest retailers in the world of office supply products with 900 stores and 500 more in europe and the middle east.
- Explains that crm is a system for managing company's activities or interactions with current and future customers.
- Explains the criteria for choosing a crm system are the features, support services, and the price.
- Explains the ultimate goal of implementing a crm system is to provide solutions for the customers based on their needs. technology will keep the customer up to date on things like inventory and tracking information.
- Explains oracle's customer relational management application provides a single global basis of information to ensure all sales channels are aimed towards corporate objectives. the standard-based architecture improves quality of the data and allows different divisions to draw from the same source of data.
- Explains the goal of service management, which is to optimize service-intensive activities. these activities involve third parties, larger inventories, and tighter integration.
- Explains the benefits of establishing a service management system, such as integrating the service and supply chain.
772 wordsRead More - Goliath's Jerky Snacks: Case Studyexplanatory essayIn order to answer parts a through d for question #1 and to avoid the over usage of the phrase ‘this company’, I will create a fictitious company called Goliath’s Jerky Snacks. Goliath’s Jerky Snacks is a small-sized company which sales a variety of jerky snack products. They have been seeing a lot of growth in the past two years and as a result, the CEO and owner, David Hannigan, would like to have a data warehouse developed for his company.
In this essay, the author
- Explains that if goliath's jerky snacks wishes to have its employee sales data incorporated into the data warehouse, it is important that they have those sales records available.
- Describes whether the data is tracked in a certain system or systems within the company, or is it recorded by hand, using spreadsheets, etc.
- Asks what tools should be used to help with the retrieval and inspection of data from goliath’s jerky snacks.
- Asks if employees at goliath’s jerky snacks need to be trained on using the data warehouse?
- Describes how joe hires csuf students to help him with a business intelligence system to keep an eye on the overall state of the library.
- Recommends using the e-r approach to model the operations of your local community library.
- Explains that a library patron can check out 0 to many books, and many other items.
- Explains that only 1 librarian can issue 0 to many other items at a time.
- Explains how to describe to joe the benefits of a business intelligence system and his skeleton staff at the library.
- Explains goliath's jerky snacks is a small-sized company which sells jerky snack products.
- Explains that goliath's jerky snacks needs to develop a data warehouse to sift through all of its data.
- Asks whether the data needs to be cleaned and if so, how much? are there errors, such as duplicate records, repetitive data, or old entries?
- Asks how goliath's jerky snacks' current business expressions and meanings should be systematized to avoid confusion.
- Explains that the ceo of goliath's jerky snacks, david hannigan, is interested in having a data warehouse developed for his company.
- Explains that 0 to many books can be issued by 1 and only 1 librarian at a time.
- Explains that 0 to many other items can be checked out by 1 and only 1 library patron at a time.
- Explains how joe's business intelligence system could be integrated into a state-wide library system and maintained for all the material in the state.
2314 wordsRead More - Database design processexplanatory essayBefore a design effort can proceed full speed ahead, the designer must first take time to understand the business. Understanding the business involves understanding the entities, data, and rules within an organization, and then converting these attributes of the business into a business model. Then, the designer must have a solid comprehension of the proposed database model. Finally, the designer will convert the business model into a database model, using a design methodology, whether automated or a manual process.
In this essay, the author
- Explains that database systems has a practical, hands-on approach that makes it uniquely suited to providing. database design is more art than science.
- Explains that the level of structural integrity and data integrity is in direct proportion to how thoroughly the design process is followed.
- Explains that before a design effort can proceed full speed ahead, the designer must first take time to understand the business.
- Opines that the last step is to create the application, not the first. this is backwards, inefficient, and costs time and money.
- Explains the importance of using relationships between tables to properly organize data, which is called normalization.
- Cites elmasri, ramez, and navathe, shamkant b., fundamentals of database systems, second edition, addison-wesley publishing company, 1994.
894 wordsRead More - Nt1310 Unit 3 Data Analysis Paperanalytical essayQ3. Analyze and collect the information provided by the surveys is one of the most important steps to determine and analyze how satisfied our client is. That is why determining what type of error can be found in the response of the respondents is vital for the company.
In this essay, the author
- Explains that analyzing and collecting the information provided by surveys is one of the most important steps to determine and analyze how satisfied our client is.
- Analyzes that the range used for many questions is perhaps not appropriate for the respondent. for example, in the question about the salary received, the chosen ranges are too wide.
- Explains that a worker can earn 37 thousand per year, but it's in the range of people who set salaries between 36 and 55 thousand. the way to handle this is being more precise as what is required by the consumer or customer.
322 wordsRead More - The Data Warehouseexplanatory essayThe term Data Warehouse was first coined by Bill Inmon, who has been commonly recognized as the “father of data warehousing” and is the lead proponent of the normalized or sometimes referred to as the top-down, approach to Data Warehouse design (Reed, M.)(Data Warehouse). In this Data Warehouse model all organizational data is collected from the source systems at the lowest level of detail, known as “Atomic” data, and storied in the Data Warehouse. This data is then grouped into subsets of the original transactional systems by subject to model specific business processes known as a data mart (for instance, a marketing data mart could contain all the data from across the organization related to the marketing department). This design allows for a great deal of consistency across business processes because all organizational information is loaded into the Data Warehouse at once and all data is link by common dimensions (the data that give transactions their context, such as customers (dimension) to purchases (transactions) or employee (dimension) to sales (transactions)). But, because the scope of this design encompasses all organizational data, which requires the need to model, develop, and deploy the solution as a whole, it results in a significant i...
In this essay, the author
- Explains that a data warehouse is an information-centric system of decision support technologies used to consolidate business data from disparate sources for use in reporting and analysis.
- Explains bill inmon's top-down approach to data warehouse design, which allows for a great deal of consistency across business processes. ralph kimball touts the dimensional approach.
- Explains kimball's approach of building business process specific data marts that collect the transactional components of the original data and link them to well defined dimensions.
- Explains how the data warehouse acts as the main repository for all business critical data. the data is extracted, transformed, and loaded into an integration layer consisting of a staging area or operational data store.
- Explains the five main components of a data warehouse: operational systems, etl, integration layer, enterprise data store, and data mart.
- Explains that operational systems represent all siloed sources of information related to the organization. they can consist of internal oltp systems such as customer relationship management (crm), supply chain management, or sales and marketing management systems.
- Explains that etl, or extract, transform, and load, performs three distinct functions. it extracts data from one or more source systems, transforms the data through cleaning, reformatting, standardization, aggregation or some other custom process necessary to meet the business needs.
- Explains that the integration layer is a temporary staging area for data extracted from source systems in preparation of further processing and servers many functions.
- Explains that the enterprise data store is the central authoritative repository for the organizations cleaned, vetted, and integrated data. the data vault contains the "single version of the truth" as it pertains to the organization.
- Explains that the data mart is a sub-set of the information in the data warehouse summarized for easy consumption by decision makers.
- Explains the typical operation cycle of a data warehouse, which starts at the internal operational systems and external sources, primed with countless bits of valuable business data.
- Explains that a data warehouse is an overall approach of building and managing decision support systems for both everyday tactical decision making and long-term business-wide strategizing.
1913 wordsRead More - An Overview Of Data Warehouse System In A Datawarehouse Systemexplanatory essayWe are covering Data warehouse development, Benefits of data warehouse and expectations from different user under this memo.
In this essay, the author
- Explains that data warehouse is used in different states. fabilous fashion grows day by day and has a large number of outlets. it provides stable, intergrated and well-organized data.
- Explains ponniah, p 2001, data warehousing fundamentals: a comprehensive guide for it professionals.
- Explains how to display the registration, cost, and status of all cars in descending order.
- Explains how to display the car registration, current mileage and purchase date for all cars in ascending order.
- Explains how to display the booking number, date rent started, period of rental and the expected end date of each rental.
- Explains how to display full details for all car models where the car group name is ‘a3’ or ‘b3‘ and the number of miles between services is either 12000 or 15000 miles.
- Explains that ladies business is known as fabilous fashion because it has many retail outlets in nws,vic,qld with varieties of stock having large inventory activities. data warehouse system is able to manage the all operational activities of the big enterprise.
- Explains how to display all the cars registration, miles to date and status for all cars that have not had a service but are available for hire.
- Explains how to display full details for any car that costs more than $100,000.00 or belongs to group a4 and has a registration whose second digit is 9. both conditions must be explicitly queried.
- Explains how to display the registration and miles traveled since last services and status for all the cars which have traveled more than 1500 miles since lasted service.
815 wordsRead More - Data Warehousinganalytical essayA Data Warehouse is a separate database that is specifically designed for aiding the decision making process. This new database can carry out this function by being subject-oriented, integrated, time-variant, and non-updateable. (Menninger, 1994) These four concepts are vitally important for a data warehouse to supply the decision making information that it is tasked to provide. In the example of the manufacturing company bidding or quoting on a contract, the Subjects would be Customers, Suppliers, Employees, and Parts. All the information found in the Data Warehouse would be oriented around these key subjects. The data, as mentioned earlier, would also be collected from many different sources and integrated together to form one set of valid information. The third element that would be important, centers on the element of t...
In this essay, the author
- Analyzes inmon, william h., "dawn of a new age: why everyone is building data warehouses." database programming & design dec. 1992: 76+.
- Explains menninger, dave, and the data warehouse. data based advisor nov. 1994: 126+. computer database.
- Opines that 'schema wars' miss warehousing basics.' computing canada 20 apr. 1998: 34.
- Describes the reasons for a data warehouse. a recent survey shows how some companies handle informational processing.
- Explains that data warehouses are subject-oriented, integrated, time-variable, and non-updateable.
910 wordsRead More