StudentShare solutions
Triangle menu

Data wharehousing case study assignment - PowerPoint Presentation Example

Nobody downloaded yet

Extract of sample
Data wharehousing case study assignment

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 Women. 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 ...Show more

Summary

OLAP is an abbreviation for ‘On-Line Analytical Processing’. This is where data is analyzed and shared online in a high performance where the results of any analysis should take less than 30 seconds. The schema and the mart implemented by the designers should have the basic dimensions of data in an organization…
Author : simeon10
Data wharehousing case study assignment essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the powerpoint presentation on your topic
"Data wharehousing case study assignment"
with a personal 20% discount.
Grab the best paper

Check these samples - they also fit your topic

MGT506 - Strategic Leadership, Mod 3 Case
The words of John Quincy Adams, or JQA, show that not only did he fully comprehend, but that he exemplified the essence of a servant leader. Servant leadership is more than a buzzword; it actually conveys one of the noblest and most profound constructs of leadership.
8 pages (2000 words) PowerPoint Presentation
The Curious Case Of Benjamin Button (Historical)
The timeline of the story is during the period where civil war has just ended and the social and elites favored the Confederacy. Being a member in the Confederacy is given to someone who has gained popularity, affiliations, financial status
1 pages (250 words) PowerPoint Presentation
Gorporate Governanace Advisor for case
Corporate governance helps in lowering the costs of capital, improves performance, gives better access to external finance, higher affirms valuation and share
2 pages (500 words) PowerPoint Presentation
Case study presentation
mployees should be given a clear understanding of tasks that they need to carry out to bring out the desired behaviour of performing the routine tasks (Briscoe, Schuler & Claus, 2008, p.75-78). In Speke Furnishings, on the other hand, the employees should be rewarded to
1 pages (250 words) PowerPoint Presentation
ANALYSIS OF QUANTITATIVE RESEARCH STUDY REPORT
It was found out that women who were over seventy years old had increased vascular complications, and they also had renal failure. Furthermore, they went through percutaneous intervention and had a venous cover. The study design used in conducting the research was the
2 pages (500 words) PowerPoint Presentation
Case study on public adminstration
An important consideration was to ensure that the organization had sufficient funding and that the funds were utilized appropriately and with transparency. Since Healy had many people working under her and she was also answerable to the
2 pages (500 words) PowerPoint Presentation
Historical Case Study
turned out to be a bright student who was talented in music and had just enrolled, in college, to take Psychiatry when he was diagnosed with Schizophrenia, which led him to be put in an institution after a period of two years during which he extremely suffered (Tom Blaise
4 pages (1000 words) PowerPoint Presentation
An aspect of small business management and development through case study based on a presentation. Entrepreneurship and small firms
An example of this is the need to have a systematic business creation model to follow (Lutgen-Sandvik, 2010). Though the models may come in different forms and structures, it
6 pages (1500 words) PowerPoint Presentation
Integrated Case Assessment
The company’s prospects for the present and the future are the basis of revision of the strategies. Then the company should adopt various strategies in order to achieve the predetermined objectives. Strategies are critical and the sense
3 pages (750 words) PowerPoint Presentation
The Data Scientists
With data an improvement is eminent in the production industry, to undertake various processes and also to help bringing about new ones
1 pages (250 words) PowerPoint Presentation
Hire a pro to write
a paper under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Click to create a comment