Data wharehousing case study assignment - PowerPoint Presentation Example

Only on StudentShare

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. ...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

Related Essays

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
Get a custom paper written
by a pro 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