TERM PAPER/SEMINAR 0n 21st CENTURY SUCCESS MANTRAS: BUSINESS INTELLIGENCE AND DATA WAREHOUSING
Submitted to
AMITY SCHOOL OF ENGINEERING AND TECHNOLOGY (ASET)
Guided by: Mrs. Darothi Sarkar Submitted by: AKSHAY DOGRA
Enroll No.A2345913057 Roll No.57 AMITY UNIVERSITY UTTAR PRADESH GAUTAM BUDDHA NAGAR CERTIFICATE
This is to certify that Mr. AKSHAY DOGRA student of B.Tech. in CSE(Evening) has carried out the work presented in the project of the Term paper entitle "BUSINESS INTELLIGENCE AND DATA WAREHOUSING" as a part of First year programme of Bachelor of Technology in CSE (Evening) from Amity University, Noida, Uttar Pradesh under my supervision.
Faculty Guide: Mrs. Darothi Sarkar Signature:
AMITY SCHOOL OF ENGINEERING AND TECHNOLOGY, AUUP
As we discuss the possibility of emerging into business intelligence software we must keep in mind the overall purpose of using any type of software is to reach strategic goals in order to increase market shares. I will discuss how business intelligence software will allow us to meet those strategic goals. We will establish what type of information and analysis capabilities will be available once this business intelligence software is implemented. We will discuss hardware and system software that will be required to run specific business intelligence software. Lastly, I will give a brief synopsis on three vendors (IBM, Microsoft Microsoft and Oracle) that are dominating the business information software
This report is an analysis of business intelligence systems currently available to our business. As an introduction, I will address in general terms why we need to purchase a business intelligence system and how it will aid our business. Then I will discuss several applications in detail, paying particular attention to the information and analysis capabilities of each, and the hardware and software required for each. Finally, I will conclude with a short evaluation of the products discussed and offer a recommendation as to the best application for our business. I will pay particular attention to IBM, Microsoft, SAP, and Oracle.
complicated. It is a major mutual concern for all business and IT sector companies to change the existing situation of "mass data, poor knowledge" and support better business decision-making and help enterprises increase profits and market share. Business intelligence technologies have emerged at such challenging times. Business today has compelled the enterprises to run different but coexisting information systems.
There are many different areas in information systems to study. Data management, data mining, data warehousing, information management, information security, information assurance, healthcare informatics and bioinformatics are just a small sample of some of the different areas of study that will be examined in this paper. Also included in this paper are answers to questions posed by the rubric for this assignment.
“Technology creates visibility across the business, and enterprise-wide operational practices are essential to optimal efficiency and effectiveness. The strategic implementation of business intelligence tools and analytics, along with cross-departmental alignment, can transform data into meaningful, useful information for critical analysis. Proactive and investigative BI reporting techniques can help recognize new business opportunities and provide firms with a competitive industry advantage.” - Scott Lundstrom, group vice president and general manager of IDC Financial, Government and Health Insights (Sungard, 2014a).
Data warehousing is a powerful business intelligence tool for maximizing the organization’s investment in the information technology. It is can be describe as a collection of decision support technologies, maid to allow executive, manager, and analyst, to make faster decisions.
Data warehousing is defined as the design and implementation of processes and tools to manage and deliver complete, timely, accurate, and understandable data for decision making. It includes all the activities that make it possible for an organization to create, manage, and maintain a data warehouse or data mart (Williams & Williams, 2007). Data warehousing majorly deals with managing the development, the implementation, and the operation of a data warehouse or data store. It includes metadata management, data acquisition, data archiving, data cleansing, storage management, data integration, data distribution, security management operational
Business Intelligence is the gathering and analysis of large amounts of information so as to gain insights that propagate strategic and tactical business decisions. Business Intelligence is the mix of the processes and technologies which change data into information. It includes a wide category of technologies, including data warehousing, multidimensional analysis or online analytical processing, data mining and visualization, as well as basic queries and multiple types of analytical tools for reporting. These technologies allow business stakeholders to collect, store, access, and do the analysis of data to improve the business decision-making capabilities.
Business Intelligence is needed to run the business while Business Analytics are needed to change the business. - Pat Roche, Vice President of Engineering, Noetix Products
The availability of new information management and supporting system like Data Warehousing, Business Intelligence, Analytics, and/or Big Data has produced a remarkable moment in the history of data analysis. Researching on this topic is very interesting for me. Thank Professor Kraft that gives me opportunity to explore more on these topics. Taking this opportunity, I would like to provide a brief summary of the book that discuss about the Profitable Data Warehousing, Business Intelligence and Analytics. The book published by Technics Publications in July 1, 2012. I also would like to thank David Haertzen who is an author of the book.
Business Intelligence is the broadest category and encompasses the other three terms here (at least as they’re used in a business IT context). BI is data-driven decision-making. It includes the generation, aggregation, analysis, and visualization of data to inform and facilitate business management and strategizing. All the other terms refer to some aspect of how information is gathered or crunched, while BI goes beyond the data to include what business leaders actually do with the insights they glean from it. BI therefore is not strictly technological; it involves the processes and procedures that support data collection, sharing, and reporting, all in the service of making better decisions. One of the trends in recent years has been away from systems that rely on IT staff to provide reports and graphs for decision-makers toward what’s called self-service BI—tools that allow business users to generate their own reports and visualizations to share with colleagues and help everyone choose what course to take.
Data warehousing is one of the hottest industry trends - for good reason. A well-defined and properly implemented data warehouse can be a valuable competitive tool. (Perkins).
Since higher education has blurred the lines with traditional businesses, it is important to have the tools to assist them with valuable data and information, in making decisions. Using of data and having the right data mining tools can insure the institute’s success, in many forms, such as, identifying market trends, precision marketing, new products, performance management, grants and funding management, student life cycle management and procurement to mention a few. To get a better grasp on these benefits it’s important to understand data warehouse, data mining and the associated benefits.
R.L Fielding (2008) reiterates that Business Intelligence is a thorough and holistic analysis of the company records, data, information, and software application for effective decision making. All decision making processes need an organized, readily-accessible, and human readable compilations of data. With the use of an effective tool the firm can easily figure out their own business processes, the behavior of their customers, and the economic trend of the industry. With these facts, the firm can arrive at a better strategy to achieve their specified goals with confidence.
The first use of the term “business intelligence” was found in Richard Millar Devens’ 1865 work, Cyclopaedia of Commercial and Business Anecdotes. He used it to describe the understanding banker Sir Henry Furnese had of political issues, instabilities, and the market before his competitors. It was not until 1958 that IBM computer scientist Hans Peter Luhn recognized the potential of business intelligence. Since then, Business Intelligence has continuously evolved from when it started as an automated system to disseminate information to the various sections of any industrial, scientific, or government organization (BetterBuys).