Why Data warehouse & Business Intelligence at Universidad Simon Bolivar ?

Palabras clave: Almacén de datos, inteligencia de negocios, análisis, preguntas, decisiones, presentación de informes. Resumen Los almacenes de datos se supone que proporcionan almacenamiento, funcionalidad y capacidad de repuesta a las consultas y análisis más eficiente que las bases de datos transaccionales. También el almacén de datos se construiye para mejorar el rendimiento de acceso a los datos.


I.
INTRODUCTION Data warehousing also is a main component in companies seeking a merger.Data integration, or Data Information Integration, basically provides a unified form of data visible to everyone on one database.The data in this newly united warehouse once came from two different databases, and can now be accessed through the same data mart.This is usually used when two companies must merge their databases, for an all around view of how both companies will work together, saving both time and money.By using business intelligence applications the business can make better more structured decisions based on solid facts.While not all data warehouses require business intelligence solutions, many do.It is in the company's or business's interest, to invest in both data warehousing, and business intelligence solutions.

A. Definition
A data warehouse is a central repository for all or significant parts of the data that an enterprise's various business systems collect.The term was coined by W. H. Inmon.IBM sometimes uses the term "information warehouse.
A warehouse is a subject-oriented, integrated, timevariant and non-volatile collection of data in support of management's decision making process as first defined by Bill Inmon in Building the data warehouse 4 th edition Wiley 1990.
So what do these fancy terms mean in the above definition: Subject-oriented Data that gives information about a particular subject or topic or entity e.g.Customer, Supplier, Location.
• Integrated-Data that is gathered from a variety of sources and merged into a consistent whole.Now more than ever, the decisions we make at the University need to be rooted in data.The costs of many of the resources needed to sustain the University are escalating.State appropriations are unlikely to rebound significantly.We must look for ways to continue to advance the excellence of the University at lower cost.Meeting this challenge requires us to innovate and develop strategies to improve efficiency and productivity.

A. Goals of the BI Initiative at Universidad Simon Bolivar
BI has the potential to revolutionize the way business is done at Universidad Simon Bolivar by: • Transforming data into information that empowers decision-makers at all levels.• Deploying state-of-the art tools to access and manipulate data.Encouraging a fact-based, data-driven approach to decision making.• Orienting behaviors and processes toward the University's strategic goals.Business Intelligence will allow us to: • Integrate information horizontally across applications, campuses, and external partners • Report information consistently through all levels, from executive to operational • Provide role-specific information for key decision making.Benchmark against other institutions and organizations.Host a shared, common source for institutional data • Technology, Empowering People, includes two specific action statements for improving access to and use of administrative data for decision-making activities throughout the University: • Business Intelligence, when properly implemented and used, delivers many benefits.
Some of the key advantages include: • Alignment of an organization around its strategic goals.Articulate strategy, set measurable objectives, monitors performance against those objectives, and then makes informed decisions that support the desired outcome.All departments and schools have ad-hoc questions to be answered through data analysis.For example, the School of Nursing sometimes needs to combine student data, administration data, research data, and practice plan data in order to provide the needed The concept of BI is complex, new to many and is constantly evolving as BI becomes more pervasive in Higher Ed.We are planning a variety of educational opportunities to those involved in this initiative from both technical and functional areas.
Demonstrate the value of Business Intelligence Simon Bolivar Universidad and develop the infrastructure and expertise upon which to base future projects.

Student Enrollment Management
Simon Bolivar continually faces new challenges in enrollment management as we strive to: Offer the right courses at the right time to maximize enrollment, and insure that students are able to enroll in the classes they need to satisfy their degree requirements in a reasonable timeframe.
Enhancing the ability to accomplish this will have a positive impact on retention, graduation rates, student satisfaction, tuition revenue, recruitment and more.
Simon Bolivar Universidad currently do not have the enterprise-wide information and reporting tools needed to sustain improvement in this vital arena.
The primary objective of this project is to provide academic units with integrated information and a variety of powerful tools which will empower enrollment managers and enable them to make the sound, expedient decisions needed to optimize enrollment management.
Information is being downloaded in multiple areas, logic may not be consistent across areas and significant time is spent reconciling reports.
The primary deliverables of this project would include a centrally located single source for information based on consensus logic as well as a set of tools and reports that can be used by all campuses and departments to analyze, present and distribute the admissions information needed to support operations, external reporting, decision making and executive reporting.

Student Retention
The importance of Student Retention must be very important at Simon Bolivar Universidad student satisfaction, alumni giving, tuition revenue, course management, national rankings, etc.The offices of the focus of this project is to provide a set of BI tools to set on top of this data set that would make the information accessible to a broader range of users and also improve the consistency of analysis.The end user will greatly benefit by having a sophisticated analysis tool, an interactive dashboard, drill downs into various populations, and devising comparison groups and consistent research approaches.

III. CONCLUSION
At present there is very little or no information, whether any University in Colombia has implemented such project.However, such projects have been taken up abroad (Berkley University of California USA, National University of Singapore etc.).If completed it can be one of its type in the country.
[3] Data Modeling Made simple, a pratical guide for business and IT profesionnals second edition, Steve Hoberman, Technics Publications

Fig. 1 .
Fig. 1.Data warehouse Business Intelligence architecture II.WHY BUSINESS INTELLIGENCE AT SIMON BOLIVAR?

warehouse & Business Intelligence at Universidad Simon Bolivar?
The BI initiative can help by providing decision makers at all levels of the University with relevant, accurate, and consistent data as well as the tools and Investig.innov.ing.Vol. 1 N o 1 pp.45-49.Enero-Junio, 2013Why Data