ipl-logo

Data Warehouse Design Vs Data Warehouse Design

807 Words4 Pages

Introduction There are many different approaches to a data warehouse’s design and its development. Two approaches that stand out amongst the rest are the Top-Down approach versus the Bottom-Up approach, both of which come with their own advantages and disadvantages. Data Warehouse vs Data Mart Data Warehouse • Enterprise wide. • Amalgamation of all data marts. • Data is gathered from the staging area. • Makes queries on the presentation resource. • Provides a structure of the corporate view of the data. • Follows the Entity Relational model. Data Mart • Focuses on individual departments. • Follows a singular business process. • Makes use of a STAR join that focuses on the facts and dimensions of the data. • It provides the relevant technology …show more content…

Ralph Kimball has taken the stance that a data warehouse is a collection of conformed data marts, where the key aspect is the conforming of the dimensions among the individual data marts. The data marts are created first (rather than the data warehouse) to provide analytical and reporting capabilities for a business subject based on the dimensional model of the data. A data mart houses the lowest level of granularity data as well as the summaries that are needed for the analysis of the data. By making use of Joins nor Unions, the data marts are conformed across their individual dimensions. (Ponniah, …show more content…

Table 2 - Advantages and Disadvantages of the Bottom-Down Approach (Ponniah, 2010) Comparative Table between Bill Inmon and Ralph Kimball Characteristic Ralph Kimball Bill Inmon Business decision support Tactical Strategic Data integration Focuses on individual business requirements Tackles the project from an enterprise-wide perspective Overall structure of the data Makes use of Key Performance Indicators (KPI), scorecards as well as business performance measures Makes use of data that cannot have metrics applied as it meets multiple different information needs The persistence of data from source systems The source systems are relatively stable The source systems are dynamic and have a high rate of change Team skill set Smaller team containing generalists Bigger team containing specialists Time constraints There is a pressing need for the first data warehouse Less pressure to create the first warehouse and is based off the business’ needs. Cost to company to build Relatively low costs to get the project going Relatively high costs to get the project going. Table 3 - Table adapted from (ZenTut,

Show More
Related

Example Of A DBQ Essay

515 Words | 3 Pages

For anyone who does not know, a DBQ is a document based question. The questions that they can ask on a DBQ can range from the pre-columbian indians to the current day, so you have to be able to decipher documents because there is no way you 're going to remember all that history. Why do we use documents in an essay? Let 's send it to the thought bubble… (Anything {} should have a picture to identify it) Documents give a {bigger} grasp of people in the time period.

Read More

Compare And Contrast Jackson Dbq

982 Words | 4 Pages

Jackson was a democratic republican who was voted into office in 1828. During the election against john quincy adams , he appealed to the people through the common man. Because he was born in North Carolina , he presented many ideas that would benefit the common man. He also used the spoil system in order to gain supporters. The spoil system enabled people to get a position in government as long as they voted for him.

Read More

Industrialization Dbq Research Paper

1393 Words | 6 Pages

By the early 1800’s the industrial revolution had began in the United States. But it did not really start until after the civil war in   . When people began to move to cities to work in industries involving mines and factories instead of staying in the rural areas. The three major factors that permitted the united states to industrialize during the late 19th century which are an orotund source of natural resources and raw materials. Some of these were coal, oil, timber, water, ETC.

Read More

Compare And Contrast Ms-Drg Vs Drg System

677 Words | 3 Pages

The MS-DRG System Verses the DRG System. Each year more and more people enroll and remain on Medicare. Since technology as well as cures and therapies for diseases have advanced in the last decade the number of people on Medicare increases each year as people are living longer today than a few years ago. That being said today I would like to talk about DRGs and MS-DRGs then compare the two.

Read More

Dbq Research Paper

887 Words | 4 Pages

After separating from Britain the founding fathers formed the Articles of Confederation. The Articles of Confederation and its ideas ended up being a disaster in the founders picture of a functioning government. With no right to tax citizens the national and state governments they could not raise money. This caused serious civil unrest an led to the drafting of the constitution in 1781. The constitution brought about many important changes, with the most influential on politics being checks and balances.

Read More

Pros And Cons Dbq

506 Words | 3 Pages

The ERA failed from a number of different reasons. Those fighting for the ERA partially took the wrong approach. Many tactics hurt the campaign rather than helping it. The ERA did not get many of the supporters needed to pass the Amendment. A vast majority of women enjoyed their roles as housewife and mother.

Read More

Big Business Dbq

939 Words | 4 Pages

Thesis : After the Civil War, America was in a post-war boom. During the 1870-1890, big business moguls, such as Rockefeller and Carnegie, create huge corporations which not only affected the economy, but also affected the political realm of America. While many may assume that during the rise of these big business helped to change the economy and politics,  the real focus was on the responses formed by society, such as labor unions, increase public outcry, and political opposition groups that helped to change society. A: Economically, big business flourished during the late 1800s.

Read More

Antislavery Convention Dbq Analysis

670 Words | 3 Pages

The antislavery convention of American Women in New York City in May 1837 was one of several conventions that were held, addressing the concept of abolition. During this time period, there were several groups of men and women who were interested in getting rid of the institution of slavery, driven by different motives. Document 5, of Chapter 6, contains several of the resolutions established by the women attending the convention regarding the ideas of slavery as a moral wrong, and that people were obligated to perform their duty in helping others achieve their freedom. The women attending the convention, including Angelina Grimké, Sarah Grimké, Mary Cox, Lydia Child, Martha Storrs and many others, were allowed to participate in this convention

Read More

P3 Unit 22

1185 Words | 5 Pages

Unit 22: Market Research The definition of market research: - The definition of market research is: Think of advertising research wherein a selected market is recognized and its size and different characteristics are measured. Used also as an opportunity time period for advertising research. Purpose of market research: -

Read More

Slavery In The Chocolate Industry Essay

1687 Words | 7 Pages

So, manufactures can use this information to select their

Read More

Case Analysis: Business Intelligence At CKE Restaurants

792 Words | 4 Pages

There are many benefits that the BIS can bring to an organization such as boost productivity, sales and market intelligence, the setting of more accurate and realistic goals, positive return on investments, gain insights into consumer behaviors, operational visibility and identification of key trends (Holley, A. 2015). Recommendations for developing and using the BIS described in this case, include the use of an effective BIS that incorporates different factors or circumstances in the internal and external environment of the organization such as sales, costs, weather, items or services offered by the company, and trends. Another reason to implement BIS is to reduce voluminous amounts of irrelevant data, poor data quality, and user resistance that affect the effectiveness of

Read More

Tesco: The Importance Of Information And Knowledge In Business

1955 Words | 8 Pages

This data well help in making the information abut the sales according to that records the company well decide the production of the product and see how much marketing is needed for sealing the product in the

Read More

Pan Europa Case Study

1078 Words | 5 Pages

To begin with, the company must channelize its investment in those projects that will assist the growth in the revenue figures and net income. It is also important for the company not take any additional debt and accept projects within their capital budget as the banks have already signaled red warning for unsustainable debt-equity position of the company. Analyzing the past performance of the company, we found that

Read More

Lululemon: Management Information System

764 Words | 4 Pages

ADMS 2511. Management Information System Section Q Raqib Ibrahim Prof. M.Zia ul Haq 215251754 Case Assignment 1 Question A i) Data items: Example of Data in Lululemon case is sales over $1 billion. Data item is a set of description which gives information but does not convey a meaning. ii) Information: As stated above the sales resulted in over $1 billion but actually the 10 percent of those sales were from the Internet store.

Read More

Value Chain Analysis Of IBM

1674 Words | 7 Pages

Its clients are individual users, specialised businesses, and institutions such as government, science, defence, spatial and educational organisations. To meet and respond to its customers needs, IBM creates, develops and manufactures many of the world 's most advanced technologies, ranging from computer systems and software to networking systems, storage devices and microelectronics. 3) Internal and External Analysis A) Porter’s Value Chain Analysis: This model describes the activities that take place in a business and relates them to an analysis of the competitive strength of the business. Value Chain Analysis is one way of identifying which activities are best undertaken by a business and which are best provided by others ("outsourced").

Read More

More about Data Warehouse Design Vs Data Warehouse Design

Related Topics

Open Document