This website uses cookies to ensure you have the best experience. Learn more

Datawarehouse Essay

548 words - 3 pages

DATA WAREHOUSING CASE STUDY
Correlating Data Across the Business
Client’s Problem:

Client’s Requirement:

∙ Data is not consolidated and its structure
not suitable to user requirements
∙ Reporting process is slow
∙ Essential business data can‘t be extracted
from the current computing structure
∙ Report distribution is handled manually





Reports to be generated automatically
Reports distribution via web interface
Simplified generation of new reports
Source data to be ingested from client‘s
MagnaQuest ERP system
Minimal demand on current systems

Solution:
Following detailed scrutiny of the requirements, OpenSys proposed and implemented a classic
three layer data warehouse (DWH), utilizing CloverETL as an ETL and data transformation tool.
Data Warehouse Facts:
∙ Based on Microsoft SQL Server 2005 with integrated Reporting Services
∙ Data extracted from MagnaQuest ERP system (based on Oracle 10g Enterprise Edition)
∙ Filled once a day ...view middle of the document...

Manually created
static reports weren’t sufficient for
major marketing decisions. This fact
resulted in reduced operational
activity and slowed down decision-making process. Moreover, the
company’s computing structure
proved incapable of handling even
regular reporting requirements, let
alone responding to the need for
detailed analysis.
Better business analysis together
with improved forecasting called for
a new business intelligence
platform.
Acquired
detailed
drill-down analysis was to be
distributed
automatically
to
appropriate employees.
After comprehensive scrutiny of
client’s systems and requirements,
OpenSys proposed to develop
software system and reporting tool,
which was later nicknamed DART
(Data Analysis and Reporting Tool).
This tool is featuring powerful
options to create detailed dynamic
or static reports with drill-down
capabilities
and
analytical
web-based interface, which allows
its users to
effortlessly reach
desired business information.

CloverETL Benefits:
∙ CloverETL allows visual development of complex data transformations (e.g. templates
for Slowly Changing Dimensions ) which shortens development time
∙ Self documented, easily understandable and maintainable data transformations allow
rapid accommodation of changes in business processes
∙ CloverETL implements workflow (job dependencies, scheduling) facilitating full
automation of data processing
∙ Enterprise monitoring tools (tracking volume of processed data, automatic
notification about processing events) help to reduce system downtimes
Business Benefits:
∙ Brings complex business overview
∙ Powerful platform for decision making process
∙ Simple and convenient access to aggregate business data
∙ Reports automatically distributed via various means (web interface, e-mail, etc.)
∙ Efficient targeting of marketing activities

The company now benefits from
powerful
data
warehousing
solution that is providing aggregate
data for reports delivered to users
automatically via e-mail. This
collection of data allows our client
to accomplish a more proactive
marketing effort. It is now possible
to explore in detail the impact of
new initiatives, product packages
and subscription plans.

Other Essays Like Datawarehouse

Living In A Cashless Society Essay

1637 words - 7 pages Money in a traditional sense no longer exists. Money is becoming much of a concept than a physical material, and most ordinary bitter have not see the reality of the switch. People today are using credit and debit cards on a regular basis and in everyday situations such as meal purchased at fast food, highway tolls, clothing, groceries, gas stations, etc. all of these means of systems could be regarded as a cashless society or world. The question

The French And Indian War: The "Real" First World War

1955 words - 8 pages The Seven Years War, or more commonly referred to as “The French and Indian War”, has been called the true First World War. In this book The French and Indian War: Deciding the Fate of North America, the author and historian Walter R. Borneman paints a detailed and elaborate picture that justifies the claim of it being the first true war of global proportions. If ever there truly was a climax to the never ending feud of the European powers

Is The Use Of Animals In Medical Research A Necessary Measure?

1513 words - 7 pages Throughout history, animals have been used in experiments to test product safety and obtain medical knowledge that benefits both humans and animals alike. Every year there are numerous medical breakthroughs, such as medications and surgical instruments, which are tested on animals to insure their safety before they are deemed acceptable for human use. Even though the results of the experiments saved millions of human lives, they are also

Education And The Evolving Job Market

2363 words - 10 pages The lives of students today are changing. They are preparing for lives and jobs that have never before existed. If teachers hope to have a significant and worthwhile impact on these quickly changing lives, they must change the way they think, prepare, and instruct our future generations. Children cannot afford to have teachers who remain stagnant in their methods and ideals. Students crave instructors that are willing to allow them to tap

Young And Relentless

1737 words - 7 pages There are numerous influences that can be responsible of teenager’s behaviors and attitude as they develop. One factor that is important to these behaviors is parental figures being over involved or uninvolved in their children’s lives. Many of these effects include illegal substance abuse, rising sexual activity, underage alcohol consumption, and tobacco use. Studies show parental participation plays a key role in the characteristics developed

The Natural Law Theory

1231 words - 5 pages Obeying by the natural law theory is the only true and moral way to live life; especially a life lived in God’s image. God’s presence is a guiding factor to obtaining a moral and virtuous life, which can only be obtained by following the natural law theory. God created a set of laws as a supreme guide for humans to live life, like any law these laws were created to ensure wellbeing for everyone. The laws he created are the civil law, the natural

Resolved: Presidential Signing Statements Threaten To Undermine The Rule Of Law And The Separation Of Powers

1811 words - 8 pages The subject of signing statements has created much debate among the houses of Congress, government officials, and the public alike. These signing statements fall under the categories of constitutional and legislative history signing statements. Constitutional signing statements are those in which the president deems certain provisions of the legislation as unconstitutional, therefore they should not be enforced (Bradley & Posner, 2006

Oppressive Systems Of Government In Egypt And Animal Farm

1529 words - 7 pages As in Egypt, Orwell demonstrates through his allegorical novel “Animal Farm” that leaders are able to establish and maintain power over a people, and in turn create an oppressive and corrupt government system. Orwell shows the significant difference in the education and levels of knowledge in the animals, and how the government takes advantage of this difference. The split between the levels of intelligence is portrayed in the first chapter when

The Pathway To Psychosis

1415 words - 6 pages “How all occasions do inform against me” is a line from act IIII, scene IIII of William Shakespeare’s Hamlet. This line, spoken by Hamlet, expresses his emotional state as he is currently overwhelmed by the death of his father, the king of Denmark, and the situation surrounding it. After Hamlet learns of his father’s death he finds out that his mother has married Claudius, Hamlet’s uncle. On top of all of that, Hamlet soon after

Rated “M” For “More Censorship Not Needed”

1241 words - 5 pages Since the moment video games became a commercial success there have been people who have pushed for unfair amounts of censorship to be placed upon the content of the games and its availability to children. These groups push for increased regulations on content but there is already an appointed group to handle this issue, the ESRB. Even though there has been an increase in mature content in the video game industry, increased censorship is not

Four Components Of A Legally Astute Social Media Marketing Manager

1914 words - 8 pages With the advances in technology constantly changing companies have to find better ways to market their products to consumers. The explosion of Facebook has given companies a way to market products to consumers. Examine how a legally astute manager can use social media to his advantage. Review different forms of dispute resolution and determine which one works the best. What is the best course of action, the government can use to

Related Papers

Introduction To Is Essay

2349 words - 10 pages . * External Databases Semua database di luar organisasi yang dapat digunakan oleh banyak perusahaan. * Hypermedia Databases – Database yang memiliki halaman media interkoneksi * Data Warehouse Database yang berisi data dari beberapa system operasional yang terintegrasi dan terstruktur sehingga dapat digunakan untuk mendukung analisa dan proses pengambilan keputusan dalam bisnis. * Data Mart Bagian dari datawarehouse dan berada

The Separation Of Capital Ownership And Control

1577 words - 7 pages The argument of whether the separation of capital ownership and control is an efficient form of organization has constantly been a controversial issue. The criticism whether the controllers’ act is in the best interest of the owners’ wills never end as long as hired managers operate management. As the number of public companies has been increasing over the course of this century, meanwhile the American style of contact based corporation has

The Versatility And Flexibility Of Oled's

1014 words - 5 pages In April 1, 2002, organic light emitting diodes gain rise in the scientific community with their published, more practical form at Ames Laboratory. “Scientists at the U.S. Department of Energy's Ames Laboratory, in collaboration with scientists at the University of Michigan, Ann Arbor, have developed and demonstrated a novel, fluorescence-based chemical sensor that is more compact, versatile and less expensive than existing technology of its

Comparing The Moral Virtues Of Antony And Julian The Apostate

1103 words - 5 pages Roman emperor Julian the Apostate and Christian leader Antony both exhibited many qualities of character during their existence. Both of them led very distinctive lives although shared several ethical values. Book 25 of “The Later Roman Empire” and the book “Early Christian Lives” show concrete evidence of this. In the following essay, I will argue how both leaders’ lives were devoted to their religious beliefs and their mutual cardinal virtues