StudentShare solutions
Got a tricky question? Receive an answer from students like you! Try us!

PowerPoint Presentation example - Data wharehousing case study assignment

Only on StudentShare
Masters
PowerPoint Presentation
Information Technology
Pages 10 (2510 words)
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…

Extract of sample

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
Not exactly what you need?

Related papers

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…
10 pages (2510 words)
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…
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)
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…
4 pages (1004 words)
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…
4 pages (1004 words)
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…
3 pages (753 words)
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…
9 pages (2259 words)