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

The couses of increasing the crime in the UK (just in the UK) Essay

The couses of increasing the crime in the UK (just in the UK) - Essay Example It differs from simply citing poverty or racism as the cause of crime because it includes almost all social components including the family, social institutions such as school, the community, peer groups and home life. The concept of being "socially excluded" can also take into account economic and political exclusion, such as unemployment and immigration status, as well as lack of access to medical care, housing, policing and security. (Young, J, 'Crime and Social Exclusion'). The effect of social exclusion on crime is evident. Richard Garside (2008) reports in the Guardian that there were no homicides in 2007 in more prosperous areas of London, whereas other more impoverished areas accounted for 46 alone. The Londoners who are socially included are safer, whereas "those living in the capital's poorer neighbourhood's appear to be at much greater risk of homicide than those living in its leafier, richer suburbs." To look at the causes of crime this way makes it a social problem rather than an individual problem; in other words, it is viewed as a symptom of the society we live in rather than the situation of an isolated individual. But those who research crime in the U.K. differ in how they interpret the cause of social exclusion. Some assert that people are self-excluded; that is, the fault lies within themselves and their lack of motivation can be traced to their dependency on the welfare state. Under this scenario, even if there were jobs available, they wouldn't take them. Another theory is that the individual doesn't lose the motivation to work but doesn't have the capacity to look for work due to lack of positive role models. Then there's the third theory that may best explain the increase in crime: that economic decline over the last few decades has been so extreme and jarring that it thrust many in the category of social exclusion. It used to be that one could count on a lifetime employment with a good company and a sense of security. Now, due to downsizing, outsourcing and widespread unemployment, work is much more temporary and contractual. This adds a great deal of insecurity and creates a larger underclass of the stigmatized unemployed who are often paraded in the media as drug dealing criminals separate from those in the "leafier, richer suburbs". That dichotomy of exclusion/inclusion combined with media amplification led to one of the most famous and effective enunciation of crime policy by any politician, former Prime Minister Tony Blair's slogan, "Tough on crime, tough on the causes of crime." (King 2008, p. 137). It ushered in the Labour Party after a string of defeats. It emulated that of the United States with its emphasis on enforcement as opposed to rehabilitation. The implication was that the government would take a two-pronged attack on crime: enforcement and prevention. The framework of social exclusion, prevention and enforcement led the Home Office department of the government to pursue sweeping solutions to a myriad of interrelated causes. When examining the problem of youth and crime, risk factors and causes include a troubled home life, including absent parents and volatility; truancy and failing at school; mental illness; drug and alcohol abuse; poor housing and homelessness; and peer group pressure. Because the government sees the causes of crime as multi-dimensional and social in nature, the solution it comes up with is similarly expansive and social. The youthful offender is like