StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Data Warehouse, Data Mart and Business Intelligence - Essay Example

Comments (0) Cite this document
Summary
This discussion explores the differences between data warehouses and databases, data warehouse technologies, and the relationship between data warehousing and business Intelligence…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER91.6% of users find it useful
Data Warehouse, Data Mart and Business Intelligence
Read TextPreview

Extract of sample "Data Warehouse, Data Mart and Business Intelligence"

Download file to see previous pages Data Warehouses, Data Marts and Databases
A data warehouse refers to a data storage location used to secure, archive, and analyze data. It comprises of many integrated databases in an organization. Data stored in a data warehouse must be easily accessible to facilitate the daily operations of an organization. There are several types of data ware houses. There are offline operational data warehouses where data is copied from real time data networks and stored offline. Offline data warehouses store integrated data that is frequently updated and can be easily accessed. Real-time data warehouses are updated whenever new data comes in, for example in point of sale systems. Integrated data warehouses can be accessed by other systems (Jensen, Pedersen, and Thomsen, 2010).
Data marts refer to smaller data warehouses covering a specific department or subject. They differ from data warehouses in that they are less complex, and are easier to develop and maintain. Data warehouses also focus on many subject areas and collect their data from various sources while data marts deal with one subject and collect data from few sources. There are dependent and independent data marts. Dependent data marts source their data from a functional central data warehouse while independent data marts get data from external sources. A data mart can be a small division of a data warehouse (Jensen, Pedersen, and Thomsen, 2010)....
Databases contain records of data that can be easily accessed. While databases are designed to record and store data, data warehouses are designed to respond to critical business queries. All data warehouses are databases but few databases can be considered to be data warehouses. Databases are usually online transaction processing systems for recording transactions while data warehouses are online analytical processing systems for querying and analyzing data (Jensen, Pedersen, and Thomsen, 2010). Data Warehouse Architectures and Tools Data warehouses are developed using several steps including data collection, data cleansing, data aggregation, and analysis and presentation. Data collection involves identifying the suitable data for the warehouse and where it can be sourced from. In data cleansing and transformation, the collected data is restructured to make it usable for reporting, querying, and analysis. Data aggregation and analysis involves the use of query tools to transfer data from the central data warehouse and processing it to produce the required results. Presentation involves giving end results to the users in form of text, charts or tables (Barry, 2003). There are various data warehouse architectures varying from one organization to another depending on their data. These architectures include independent data marts, hub-and-spoke, federated, centralized data warehouse and data mart bus architecture that has linked dimensional data marts. Independent data marts architecture involves developing autonomous marts with different data definitions, measures and dimensions. Data bus mart with linked dimensional data marts architecture is designed to meet the needs of a specific business process. It involves the development of one ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Data Warehouse, Data Mart and Business Intelligence Essay”, n.d.)
Retrieved from https://studentshare.org/information-technology/1445136-data-warehouse-data-mart-and-business-intelligence
(Data Warehouse, Data Mart and Business Intelligence Essay)
https://studentshare.org/information-technology/1445136-data-warehouse-data-mart-and-business-intelligence.
“Data Warehouse, Data Mart and Business Intelligence Essay”, n.d. https://studentshare.org/information-technology/1445136-data-warehouse-data-mart-and-business-intelligence.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Data Warehouse, Data Mart and Business Intelligence

Wal-Mart and Unionization

First of all, I will discuss how big Wal-Mart’s business is and how it dominates the US’s and global economy. The Wal-Marts massive and great size, makes it wields barely credible power and economic king. It has driven lesser retailers out of commerce; forced companies to be well-organized, commonly leading these suppliers to move industrial jobs overseas and changed the method that yet large and established productions do business. Wal-Mart has existence or death decisions over all the customer supplies industries that survive in the US, for the basis that it is the number-one supplier-retailer of the majority of customer goods, not still toys, clothes, shoes but home applications, electronic goods, sporting products,...
7 Pages(1750 words)Case Study

Internal and External Environmental Analysis for the Bakery Business

Liberalization of foreign investment and technology policy of the government is supportive of establishing industrial units in the country.

Threat: The UK food regulatory authority is planning to enforce the EC Regulations relating to food labeling. The labeling requirements under the new regulations will affect the food industry as the suppliers will be legally obliged to disclose the GM content of foods to the caterers. Thus business firms in the bakery industry also will be effected through the exclusion of flexible manner of labeling arrangements in the case of flour confectionery involving GM Soya or maize. (Genetically modified and novel foods (labeling) (England) regulations, 2000).

Trend: The new subs...
6 Pages(1500 words)Case Study

Evandale's Business Plan

Evandale’s mission would have a strong impact on the company’s later brand development.
When a company determines its mission and its vision, it needed to determine its objectives to accomplish that vision. I did not see the objectives—where the company was heading through in the presentation. A clear objective would have enabled me, as an audience to also picture where the company would want to go and would serve as the benchmark for me to assess the later strategic choices the company would state in the presentation.
According to the slides, the potential demand for caviar and the sturgeon products are “100x” bigger than the current supply. I would have wanted to see a reliable source for...
7 Pages(1750 words)Case Study

The National Drug Intelligence Center

...The National Drug Intelligence Center One of the most common crime in the United s nowadays is of drug trafficking. This lucrative business has become a trend in the American society and is increasingly becoming a threat for the state. Just before this crime could become a national issue the government of United States realized its potential and formed several intelligence agencies which would look after the drug traffickers. The National Drug Intelligence Center is the formation of government of United States in this regard. It was formed in 1993 and is operating till date. The NDIC has proved quite successful in achieving its tasks and has proved as an asset to the United States. This essay would further describe the agency in detail...
8 Pages(2000 words)Essay

The Management, Leadership and Teamwork Competencies Required by a Small Business Owner

On the other hand organizational leadership is defined as the ability based on the specific skill of an individual to lead his/her subordinates in a manner that pre-planned organizational goals could be achieved within the defined time-frame.

According to Burns (1978) and Bass (1985), transformational leadership has a set of category constructs such as values, morals, farsightedness, long term goals, principles, acute awareness about the dividing line between causes and symptoms, mission statements, strategic perspectives, and human resources. Similarly, they identify a set of category constructs in the transactional leadership also. For instance concentration on the task at hand, short term goals and tactics, confusion co...
6 Pages(1500 words)Coursework

Intelligence and the War on Drugs

When the Ronald Reagan Administration initiated its famous War on Drugs program in the 1980s with the catchy slogan “Just Say No”, the focus of the program was not exclusively Mexico. At that time, different pockets of Latin America posed threats of varying degrees, including Columbia and Brazil. But due to its proximity to the United States, and the increase in demand for cocaine and marijuana, Mexico has emerged as the greatest threat in recent decades. Compounding the problem of drug trafficking is the internal political chaos in Mexico. The Mexican governments of past and present have tried various methods and tactics for bringing the drug cartels under control but to no avail. It is a reflection of the governments...
7 Pages(1750 words)Assignment

Evaluation of Performance of a Bank Using Published Accounting Data

...Table of Content Introduction: 2 Background 3 Thesis ment 4 Main Body 4 Conclusion 6 Limitations 7 Recommendations 7 Bibliography 8 Evaluation of Performance of a Bank Using Published Accounting Data Introduction: Banks are the global industrial powerhouses1 and they have introduced very complex and risky products and services. During its operation, every bank is exposed to credit risk, liquidity problems, interest risk, market risk, operational and management risk.2 The collapse of banking industry severely influences the world financial system, which means that it is very important to evaluate the performance of the banks. There are different parameters based on which performance of a bank can be evaluated such as financial management...
7 Pages(1750 words)Case Study

Business Plan Real Estate Agency

re representing our company as their business consultants and our responsibilities are limited to the knowledge of the client’s business and information provided by the client.
The company Of-Fit has been operating as office supplies and equipment supplier since 1998. Their corporate office is in Aberdeen and it has excellent industry relations. The company is a sole proprietorship and its owner is Mr. Andrew Schwatz who has been working in the industry for more than 20 years. The company current staff is 8 and its revenues are £115,690 and £156,178 in 2008. The company aims to expand its operations in other business areas and regions of the UK.
The detailed business plan developed for this report incor...
12 Pages(3000 words)Business Plan

Business Sustainability and Society: Coca-Cola Company

...Running Head: Business Sustainability & Society Business Sustainability & Society [Institute’s Business Sustainability & Society Introduction Since centuries, ethics has been a crucial and significant component of the human societies that contributed enormously in the creation of norms and values through religious influences, as well as through contribution of intellectuals and philosophers in the society. Unfortunately, nowadays, it is an observation that individuals, organizations, and even nations have commenced to overlook the phenomenon of ethics in their practices, specifically in the business sector that has become the major stakeholder confronting criticisms related to ethical practices. Critics (Crane, pp. 23-29, 2007) argue...
10 Pages(2500 words)Case Study

International Business: World Economic Forum and Davos 2010

While each force of globalization is important, the technological revolution has impacted the business models, value creation and differentiation (Spelman, 2010). The cloud computing technologies that have made the popular social networking applications possible are now being applied to development, healthcare, and society. Today mobile telephones are more like powerful computers that take care of many of the societal challenges facing both developed and developing countries (Evans, 2010). In Chile, new software enables weather information to farmers who can now make informed decisions on when and how to sow or harvest the crops. However, the fear or ignorance of cloud computing technology could harm the chances of the SMEs becomi...
7 Pages(1750 words)Coursework
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Data Warehouse, Data Mart and Business Intelligence for FREE!

Contact Us