Table of Contents
Findings…………………………………………………………… 2
Issues………………………………………………………………. 2
Opportunities………………………………………………….. 3
Recommendations………………………………………….. 3
Next Steps………………………………………………………. 3
Project Schedule…………………………………………….. 4
Database Design…………………………………………….. 4
Data Modeling & Data Marts…………………………. 4
Database Selection…………………………………………. 5
ETL Selection………………………………………………….. 5
Data Mining…………………………………………………… 6
Conclusions………….………………………………………… 8
References…………………………………………………….. 10
Findings:
ABC University has several departmental databases that perform specific functions for each department. Within these databases are several items that can be considered cross functional data among
…show more content…
The reason why this is the way to go is that relational databases are limited in the number of relationships that can be dug down and analyzed. Using a dimensional model will allow the use of multi-dimensional cubes to be able to pull 3 or more dimensions back into a pivot table. An example would be Sales by customer service rep by assigned sales territory. This provides a deeper detail of data than you would be able to get out of a relational database. For each department of the university, I propose a Data mart for each one. The reason why this is the case is so that every department can manipulate their own data as they see fit with their own resources because it is on a different server than another data mart typically. The look and feel of the Data Mart is up to that department and does not bother the other departments Data Marts. Individual data marts can also increase response time because there are not as many people hitting them all at one time. If a new department were to pop up, data mart creation is very easy to do. Each record will be unique based on the primary or composite keys of the table, and those keys could be surrogate keys such as using AutoNumber like in Microsoft Access. Depending on the analysis of the data, it may be determined that the ID numbers between student and teacher are unique and this can be the way to link items together throughout the database. The
The business that I want to open would be a franchise of a McDonald’s restaurant. McDonald’s is a fast-food restaurant that serves a variety of products, but is mostly known for its
The course text discusses AS/NZS 4360 approach, which consists of a 5-phase process to manage and control risk. According to the text the risk management process phases are establish context, identify, establish and treat risk while continuously communicating, monitoring and reviewing risk (Cooper, 2005). The premise of risk management is to uncover and understand as much as possible about risks as early in the project as possible. The more one knows about risks the easier it is to make decisions for correct responses. The alternative to risk management is crises management, which in many instances is more costly, and more time consuming. Clements & Gido define a project as “an endeavor to accomplish a specific objective through a unique set of interrelated tasks and the effective utilization of resource “(Gido 4). I had many opportunities to develop a Military Retirement Ceremony, so I decided to approach it as a project risk management plan. At the time I did not know it but we were using the project risk management approach discussed in the text to address the risk associated with the event. The Military Retirement Ceremony project planning began the same as most projects do by determining the objectives. The objectives are described in terms of deliverable, schedule and budget. The sponsor and the customer must agree upon the scope of any project. In this project I worked along side the sponsors.
This proposal will discuss all key aspects needed to ensure a seamless transition and implementation of an automated sales force CRM, or Customer Relationship
The organization that I chose is DeVry Inc. Specifically, I chose DeVry’s online student finance department because I am currently employed in this department. I started here as a Student Finance Consultant in July of 2012 and this is my first full time job after college. In my role, we assist student’s enrolling in courses and help plan how to fund their education. This job can be very satisfying yet frustrating at the same time. I feel that it is a great learning environment and overall, employee satisfaction is high. I feel that my
Spellman University had requested that I develop a database for their college. The purpose of the database will be to track the students and the courses. There also will be a place in the system to track the instructors teaching each course. There are many things to be considered in composing this database. This paper will outline the entities, attributes for each entity, the type of relationship, constraints, some business rules, and the conceptual and physical models.
VIZIO, Inc. was founded by William Wang in 2002 with the idea that everyone deserves to own the latest technology. Over the years, the company has grown from having three (3) employees at its inception in 2002 to having nearly 200 employees. VIZIO ‘s primary line of business is televisions (TV), and remains the first American
The goal is to add value to current clients as well as prospects. In addition, the company wants to get busy families and business owners to agree to set appointment in order to meet with a financial service professional. Lastly, the company wants people to utilize its Information Systems.
This project is written to explain the processes involved in implementing a business intelligence system. It continues to describe the technologies involved in a business intelligence system, as well as the purpose of the system and how it can help companies become a leader in the industry. Lastly, the report contains facts about industries that have implemented a business intelligence solution, how they use it, and the benefits they reap from the implementation. The report covers multiple industries, but focuses on Chevron oil company and analyzes its business intelligence solution.
A data model is a conceptual representation of the data structures that are required by a database [Mamčenko, J. (n.d.)]. The data structures gives the information about data objects, associations between data objects, and the rules which administer actions on the objects. A data model serves as a bridge between the concepts of the real world and how the data is physically organized in the actual database. Data modelling has been ongoing for many years but still businesses struggle to extract the value from their data and thus, create well designed, intuitive models [Data Modeling Best Practices. (n.d.).]. With businesses considering for innovative ways
I never understood NFL free agency. It seems as though, it is a way for an athlete to make as much money as they possibly can over the length of their career. It is a way for teams to sign players whose contracts have expired and are free to play for whomever they choose. These athletes are catered to, flown everywhere just for the possibility of them signing with their team. But, sometimes, teams have to cut players that have helped them win over the years. As a football fan, in most cases, I enjoy free agency because this is a great chance for my team to collect players to improve their roster and give them a better chance to win.
PUT: write the number in the calculator and put on a paper and put it in outbox
Decision Support Systems (DDS’s) can greatly enhance business processes in a number of ways by enabling consistent monitoring of Business Intelligence (BI) data from a number of sources. Foremost, these sources can include former Executive Decision Support (EDS) systems, Management Information Systems (MIS), including, transactional data captured via Transactional Processing Systems (TPS), and Online Transactional Processing (OLTP) systems. This academic paper will discuss Business Intelligence, (IT)-Business/ Alignment with the Business Strategy. Also, there will be an initiative to describe both objectives and levels of strategic planning, including, how each can be supported by (DDS). Initially, we begin by discussion of Business
Many large companies have been using business intelligence (BI) computer software for some years to help them gain competitive advantage. With the introduction of cheaper and more generalized products to the market place BI is now in the reach of smaller and medium sized companies.
Consolidate and integrate enterprise data by subject area in a relational store at the lowest level of
The first Starbucks store in Malaysia opened on 17 December 1998 at KL Plaza in Jalan Bukit Bintang, Kuala Lumpur. In just few short years, Starbucks has emerged as the dominant brand of specialty coffee in Malaysia offering regular coffee or decaffeinated beverage, fresh food like pastries, cakes and muffins. In Malaysia, Starbucks Coffee International and Berjaya Corporation Berhad jointly own Starbucks. The company operates Starbucks stores throughout Malaysia and is committed to offering the world’s finest coffee while enriching Malaysians’ lives one cup at a time. To date, the company has over 115 stores all over Malaysia.