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


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

Related Essays

Data wharehousing
This is a concept of OLAP mainly used when it’s being related to data mining. This is possible through pre-aggregation, an aspect of relational databases in that they not only facilitate the creation of tables, but also can manipulate them together with the data they contain. Pre-aggregation in connection with OLAP basically explains how factual information, in this sense data that has been collected can be used to come up with probability estimations used for distribution (Kozielski & Wrembel, 2009). Data mining is a concept that has been confused with OLAP for a while. These two terms,...
10 pages (2510 words) Essay
Study Design and Data Collection Strategies
The software and hardware will be used to amalgamate the data that will be drawn from land cover maps, and topographic contour maps. It is assumed that, the database will be effective for integrating data generated internally, and which includes plans for habitat restoration and locations of the habitats. DATA REQUIREMENTS Description Enough of the required data is needed for the development of accurate and comprehensive database of a conservatory. The software to be used will be appropriate for reading topographic contour maps. They will be developed in a way that will make distinguishing of...
4 pages (1004 words) Research Paper
Data Communications – Bluetooth
Historically, “The word "Bluetooth" is taken from the 10th century Danish King Harald Bluetooth.” The exploratory work on Bluetooth technology was initiated by mobile phone company Ericsson in 1994. ...
4 pages (1004 words) Essay
Data Communication assignment - 4G
It all started with 1st generation mobile communications that were focused on analogue means of communication, this was followed by 2nd generation which resulted in a total shift of medium from analogue to digital(Palanivelu & Nakkeeran 2009). Ever since the introduction of digital sources of communication there has been no looking back, and the current standings are at 3rd, 4th generation and beyond. Furtherance and change being natural phenomena, mobile communications have seen a revolution in the manner in which they are operate today. State of the art technology exists in the field of...
4 pages (1004 words) Essay
Data Mining Assignment
The more the business understands why some of its customers are loyal and how it can continue to retain and attract customers from different segments, the more the business will be able to come up with compelling offers and messages that are relevant. Predictive analytics results in an analytical framework which helps in the prediction of product preferences and customer buying habits required in the discovery of meaningful relationships and patterns in the customer data so as to accomplish better market targets and drive customer loyalty and value (Turkey, 1997). Association discovery can be...
4 pages (1004 words) Assignment
Case Study Stage 2
At first, e-commerce can simply minimise the cost of gym activities that are conducted in traditional manner such as automation of business transactions. Online transactions and registration processes can basically minimise human efforts for performing such business activities effectively and also minimising the time required for completing the activities by the organisational members and the employees. E-commerce in UMUC Healthy Fitness Centre can also minimise the transaction expenses by making the marketplace more effective. On the other hand, UMUC Healthy Fitness Centre can also reach more...
3 pages (753 words) Case Study
Data mining Assignment
Generally there are incidences of fraud that have not yet been detected (Borzykowski, 2012 p. 34). With increased cases of fraud, it is a high time for effective measures to be applied to combat these crimes for once and for all. All the merchants, banking systems and the card owners should enroll on application of effective measures. With the application of data mining, one is capable of determining the hot spots which are the target for these crimes. Due to increased technology in businesses, application of computer science Information Technology would help solve this phenomenon...
9 pages (2259 words) Essay
Got a tricky question? Receive an answer from students like you! Try us!