Datawarehousing The Viable Solution To Modern Business Strategies

Trinity Journal of Management, IT & Media (TJMITM)
Year: 2013 (Jan-Dec), Volume: (4), Issue. (1)
First page: (37) Last page: (42)
Online ISSN: A/F
Print ISSN: 2320-6470
doi: 

Datawarehousing The Viable Solution To Modern Business Strategies
Charanpreet Kaur1 and Shalu Tandon2*

1 Asstt Professor, Trinity institute of Professional Studies
2ShaluTandon, Asstt Professor, Trinity institute of Professional Studies
Corresponding author email id: shalutandon1979@gmail.com

Received:
13 -04-2013

Accepted:
12-06-2013

Online Published:
11-07-2013

How to cite the Article

This image has an empty alt attribute; its file name is images.png
View on Google Scholar

ABSTRACT

Managing a business has never been easy. Trying  economic conditions make it even harder. The challenge is  to do more with less and to make better decisions for the  growth of the modern business. Having immediate access  to current, actionable information can make a huge  difference. “Business Intelligence therefore refers to a  set of tools and techniques that enable a company to  transform its business data into timely and accurate  information for the decisional process, to be made  available to the right persons in the most suitable  form.” Business Intelligence systems help the users make  the right decisions based on the available data. Over the last few years the pressure has been growing to  manage, integrate, analyse and act on increasing amounts  of information from all kinds of data sources. Business  Intelligence is not a new idea. The largest and best managed organizations in the world have been making  use of it for more than a decade. Along the way, the  giants that pioneered BI made an important discovery  –the path to true business intelligence passes through  a Data Warehouse. With these modern Data Warehouse  Architectures flexibility and responsiveness is greatly  improved while minimising the total cost of ownership.  “A data warehouse is a subject-oriented, integrated,  time variant and non-volatile collection of data in  support of management decision making process.” A data warehouse is a relational database that is designed  for query and analysis rather than for transaction  processing. Modern Businesses today are not only  demanding analysis of data from its own operational  systems but also the ability to consume, filter and analyse  data from a broad range of external data sources.  Business intelligence systems provide the ability to answer  these critical questions by turning the massive amount of  data from operational systems into a format that is current,  actionable, and easy to understand.

KEYWORDS

Data Warehousing, Business Intelligence, Operational  Databases, OLTP, OLAP