Data wharehousing case study assignment PowerPoint Presentation

Data wharehousing case study assignment - PowerPoint Presentation Example Facts table present real data stored while dimension tables describes each row in a fact table. Any data mart must present business changing trends and the user requirements in an organization. The database for MEGA SAVE was analyzed using OLAP Statistics and Reporting. The main advantage of data mart is that it can be used to analyze both small and large data of an organization because data marts are response to real business needs. This are some of the key guidelines that the designers of the database should base in coming up with the data mart. Charts and reports are used to describe the data set. Table 1.0 The above table shows group customer against group product from the sales. Table 1.2 From the schema the main aim of the developers of the schema is to evaluate the sales according to different groups of the buyers. The group products and the customer group ID are illustrated in the table above. For instance, customer group ID 1 is for Young Rich Women while 2 for Young Poor Wo men. The total sales for each product is given in the columns. Graph 1.0 The graph above shows the sales of group products sold overall in all counties. Fresh meat, soft drink and dairy were the least sold items while the highest sales was fruit vegetable followed by beer. The schema designed was to outline the group sales that has the highest score. The graph below shows the sales grouped by the product. The group customers are also categorized in the graph this graph is aimed at identifying the favorite precuts customers buy frequently. By different type of buyers. Decision makers can use this information in determining the type of product to be focused a given group of the consumers. Graph 2.0 Graph 3.0 The graph above shows sales of group product over the county. The decision makers may want to know which county has the highest sales and which product is the best sales. West Yorkshire has the largest sales above 1200 sales for fruit vegetables while east Yorkshire has the least sales below 800 sales for fruits vegetables. The decision maker may want to identify the sales in each county based on the scores. For instance, which store is in which county and how is it performing? The table below shows these data. Table 1.3 The company’s main trend or patterns are to the target population on the market and the kind of products it is selling to these regions. After looking at the design principles about data mart, there should be a single access point to the data mart hence the information from all the stores should be accessed at a given point. The schema omitted the most important question about the sales in each region. From a business perspective, the two main questions that emerge are: What is the specific business application of the data being loaded to the data mart from the operating system files. Therefore loading legacy data during the loading of the data mart should be done. The first law in data mart designing is the law of loading complexity in this case having multiple sources where data will be extracted from is a complexity. Some sources may not be loaded or the administrator may present information to the users in the format that they did not expect, hence to users data will not be available. Feedback mechanism should be design early in the designing stage of the data mart. I used bar graphs in representing my information because the values in the database are of frequency

BLACKBERRY Essay Example | Topics and Well Written Essays - 500 words

BLACKBERRY - Essay Example BlackBerry Company has a vision of continuously providing wireless solutions sufficient to satisfy the needs of the global mobile communications market. The company has a mission of improving information access through the realization of innovative ideas. BlackBerry Company has several strategic objectives. The company aims to ensure the durability of its products. This entails production of commodities, which can withstand the wear and tear of constant usage. Attaining long battery life for its mobile phone products also forms part of its strategic objectives. BlackBerry Company also has a goal of achieving profitability from its operations as soon as 2016. The company aims to retain its respectable market position and recognition. In this regard, BlackBerry Company aims to guarantee the efficiency of its products, especially for the sake of its high-end clientele. BlackBerry Company has a strategic objective to provide quality products at affordable, competitive prices. Its pricing strategy has been set up in a manner that ensures retention of high quality customers. BlackBerry is a telecommunication company based in Waterloo since its foundation in 1984 (Kao, R. et al., 2011). This company was founded by Mike Lazard’s and Douglas Fregin, and operates as Research in Motion in the formal circles, although it is better known as BlackBerry (BlackBerry, 2014). The entity was well known for its production of pagers, functioning as a leading producer of high-end communication devices for more than two decades The BlackBerry was the first pager that could execute a dual way mode of communication. Since 1999, BlackBerry thrived on its introduction of durable smartphones to suit the intense Internet demand. The company operates under the brand symbol â€Å"BB† and â€Å"BBRY† under the Toronto stock exchange and NASDAQ respectively (Afuah &

Healthcare Delivery Essay Example | Topics and Well Written Essays - 750 words

Healthcare Delivery - Essay Example In most situations, nurses take the big role of consoling patients as they patiently wait for the doctor. This issue can arguably said to be contributed by the fact that doctors are not well paid thus, they go abroad to seek for greener pastures where they can get good salary (Lundy and Janes 121). In addition, it is also evident that due to low remuneration form in the public sector, many doctors opt to operate private clinics where they have potential of earning good money. As a result, public hospitals record shortage of doctors. On the other hand, it is evident that due to shortage of doctors in public hospitals, the few available doctors are overwork as a result of attending to many patients without enough rest. When this happens, studies have documented that employees who overwork tend to offer poor quality services to their clients. In this regard, it is evident that the doctors would not be in a position to offer quality care to the patients due to exhaustion. In another dime nsion, current studies have also shown that motivation is a crucial element required for employees to produce quality work. Nevertheless, when employees are not motivated, they end not giving top results. In light of this, the bottom line is that since the few available doctors in the public hospitals receive low salaries and few incentives to motivate them, they feel not motivated to devote all their professionalism when attending to patients (Lundy and Janes 121). In addition, although some of the few available doctors in public hospitals may be seen in the office, most of them just appear there for a few hours and leave for their other assignments which include attending to their patients on their private clinics of other businesses that would help in supplementing the deficit they feel exists as a result of low salary by the government. The latter is that many patients will spend many hours queuing as they wait to see the doctor only to be turned down when the doctor walks away. Some doctors keep on changing or postponing patients’ appointments due to their busy schedule. The end result of all these deliberations is the provision of low quality services in the healthcare delivery. The other important issue of concern is the high cost of medical. Medical processes including diagnosis, testing, emergency care, specialist, admission costs and prescriptions have been a challenge to many people in the United States. For instance, some tests are considered costly to middle class and poor people in the United States. A specialised test that requires special machinery and chemicals may be expensive for ordinary people. In addition, some diseases require specialist to attend. The problem is when such specialists are few in the public hospitals (Lundy and Janes 122). In fact, most of the specialist operates private clinics. Therefore, the cost of seeing and getting help from them becomes high for ordinary people. It is also evident that staying in hospital fo r a long time translates to more money required to settle the hospital bills. This would be a problem to people who are not enrolled to any of the healthcare programs subsidized by the government. On the same note, even after being dispatched from the hospital, some people may not be able to take care of themselves due to high cost of after care services and other prescriptions required for recovery. In this regard, they are bound to look for cheap alternatives that do not lender good and quality services. Conclusion It

A partnership agreement Essay Example | Topics and Well Written Essays - 2500 words

A partnership agreement - Essay Example While such procedure will be effective in prevention of future conflicts, it has been found that conflicts are inevitable due to changes in laws and circumstances. It is also impossible to document every aspect of the partnership and as such, the document needs to be flexible enough to allow the inclusion of changing needs and circumstances of the partnership. Partnership agreements may need to be modified in the instance of divorce settlements, which may lead to the family members of a partner receiving shares, bankruptcy, death, retirement, disability, translocation of a partner, a partner intending to sell after getting a nice offer, debts taken out on the partnership. All of these reasons make strong the argument for the partnership agreement to be made flexible.Divorce Settlements  At the time of getting into marriage, many partners overlook many of the provisions of a partnership agreement. In most instances, it is assumed that divorce or separation will not occur.. However, it has to be acknowledged that divorce and separation are an inevitable occurrence of modern life. It is thus important that since the marital circumstances of the partners may change in the future the partnership agreement be flexible enough to allow the inclusion for the changing circumstances. It s estimated that about a million of the businesses in the US are co owned by wife and husbands in a partnership. That being said it is inevitable that conflicts will arise in instances of divorce or separation of the couple.... All of these reasons make strong the argument for the partnership agreement to be made flexible. Divorce Settlements At the time of getting into marriage, many partners overlook many of the provisions of a partnership agreement. In most instances, it is assumed that divorce or separation will not occur.. However, it has to be acknowledged that divorce and separation are an inevitable occurrence of modern life. It is thus important that since the marital circumstances of the partners may change in the future the partnership agreement be flexible enough to allow the inclusion for the changing circumstances. It s estimated that about a million of the businesses in the US are co owned by wife and husbands in a partnership. That being said it is inevitable that conflicts will arise in instances of divorce or separation of the couple. To add on to that many of the people who enter into business partnerships with other people other than their spouses are usually married. The resources broug ht into the business may thus be considered to belong to the family. Upon divorce, the couple may be required by law to divide the shares in the business in the interests of justice. A partnership agreement that does not take into account such things as divorce may thus need to be amended in order to accommodate the new dispensation. This is best exemplified in Estate of Cohen v. Booth Computers in which Cohen was suing her husband over shares held jointly by both of them. The judge ruled that Cohen was entitled to a share in the company by virtue of marriage since there was no express provision in the partnership agreement that was against such as scenario (Mahler, 2011). Bankruptcy Bankruptcy is the inability of a person to pay

Information system project management Lab Report

Information system project management - Lab Report Example After a long time of learning and implementing various project management methodologies, controls together with measurements, the success level of IT projects has been deemed not to be any better than the old moments when one computer could take up a whole room. In order for IT to contribute to the bottom line of every company, the executive teams have to make sure that the project remains aligned to business strategy. In case of multiple projects constituting large scale programs, there would be need to embrace flexibility with greater focus on the larger business picture. In software projects, it is possible to witness scenes such as members failing to complete whatever is expected of them and other members failing to be flexible. This has the potential of making things to fall out of hand. Another scene would be a person valued for his or her expert input failing to see the wider perspective, thereby missing out steps and tasks that other people would expect or a team member becoming frustrated because he disagrees with the approach that another team member uses. Dr Meredith Belbin studied team-work for several years and he made the observation that individuals inside teams have the tendency to assume varied roles. His definition of team roles is "He defined a team role as "a tendency to behave, contribute and interrelate with others in a particular way" and named nine of such team roles that determine the success level of a team. Teams risk becoming unbalanced in the event that all team members bear a lot of similarity in behavior. In case the team members have same weaknesses, the entire team might end up being weak. Supposing the team members have a similar level of strength, the spirit of competition is likely to arise and this will suppress cooperation in execution of the team-assigned tasks and responsibilities. Bearing this in mind, you could use the model with your team so as to help in making sure that the important team

Franchising Inquiry Submission Assignment Example | Topics and Well Written Essays - 2250 words

Franchising Inquiry Submission - Assignment Example But the group wanted to focus on food either establishing their own restaurant or acquiring a franchise of a reputable restaurant or fast food brand. The group has decided to acquire a franchise of The Greasy Spoon, which is a well-known restaurant serving fried food. The Company was established in 2001 and has approximately 30 stores in Australia. All The Greasy Spoon stores are not Company owned and are available mostly in shopping malls. The stores are mostly located in Brisbane and Perth but the founders of The Greasy Spoon are planning to expand in New Zealand. The franchisee would propose setting up a Greasy Spoon franchise in Sydney. As for the location, the Queen Victoria Building appears to be an ideal place for the store. The five individuals comprising the group will also be in-charge of managing the store. The outright franchise fee for the store is $60,000 and the estimated start-up cost for the new franchise is $500,000. The owners of the franchise charge 15% royalty fees without marketing levy. Based on the 2008 Franchising Survey conducted by the Griffith University, food and accommodation services rank as second as the most preferred franchise in Australia. In terms of units, the aforementioned industry ranks as number one in number of units franchised. Overall, the franchising industry has improved by 15.4% as compared to the figures in the previous years. Business format franchises in 2007 amassed a total of $61 billion (Frazer, Weaven and Wright, 2009). The Ministry of Small Business and Economic Development seeks for some clarification regarding existing laws governing franchises. In Australia, there is no private group that oversees the welfare of franchisees and also ensures that clauses in franchise agreements are adhered to. But there have been rumors circulating that some franchisees are starting to gather to discuss the possibility of establishing a group catered to franchisees. There is no substantial literature

LITERATURE Essay Example | Topics and Well Written Essays - 1250 words

LITERATURE - Essay Example Marduk is our next hero from Enuma Elish: The Babylonian Creation Epic. Marduk was born in Apsu, the region of fresh water beneath the surface of the earth. Ea, one of the gods created him and Damkina, his lover bore him. He suckled the teats of goddesses; he was powerful from the start. When Anu, his father’s begetter beheld him, he rejoiced. He made his grandson so perfect that his godhead was doubled. For were his eyes, four were his ears. When his lips moved, fire blazed forth. His four ears were enormous and likewise, they eyes. They perceived everything. Highest among the gods, his form was outstanding. His limbs were very long, his height outstanding. Our third hero is Jesus – God made man in The God of Job. In a mysterious manner, he is believed to b e whole god and whole man. His mother, the Blessed Virgin Mary, conceived him through the power of the Holy Spirit of God the Father Almighty. All this happened to fulfill what the Lord had said through the prophet: â€Å"The Virgin shall be with child and give birth through a son and they shall call him Emmanuel†, a name which means â€Å"God is with us† We can see by now that our three heroes of the Creation are all gods. But where as Jesus (Emanuel) is described as being kind and compassionate to his people, Marduk took advantage of his own, and the men of Uruk became anxious. The dramatic action and dialogue of the Babylonian Creation Epic can be compared to epic writing from the Epic of Gilgamesh and the Homeric epics, which treat human conflicts against a background of divine violence. The introduction of Enkidu into the epic of Gilgamesh was for the purpose of taming Gilgamesh, who, conscious of his own power, was taking advantage of the people of Uruk. The valiant Enkidu, a human counterpart of Gilgamesh himself, served as some kind of a check-and –balance so that,