Decision Support System Project Business Intelligence By: Bashar Ghaith Yousef Shraim Abedalrahman Saqqa Adel DabbasPage Break Introducing Business Intelligence …. BI focuses on the outside and should be seen as a company’s radar unit, scanning the external environment for opportunities and dangers. It’s not just another term for Market Research Good BI is broader in scope and more forward-looking than market research. What is Business Intelligence (BI)? A term which represents those systems that help companies understand what makes the wheels of the corporation turn and to help predict the future impact of current decisions. These systems place a key role in strategic planning process of the corporation. Systems that exemplify business intelligence include medical research, customer profiling, market basketanalysis,?customer?contact?analysis,?market?segmentation,?scoring,?product?profitability,and inventory movement Information is typically obtained about customer needs, customer decision making processes, the competition, conditions in the industry, and general economic, technological, and cultural trends. Business intelligence is carried out to gain sustainable competitive advantage, and is a valuable core competence in some?instances. Business Intelligence is a code-name for a range of technologies which unlock knowledge that is hidden in business data and?tell us how to use?it more effectively. The overall objectives of?BI are?to improve planning, productivity, service quality, and profitability by making informationand?data?more?comprehensible?and?using?business?knowledge?more?effectively. Business Intelligence helps us to?use business data for competitive advantage IT-enabled business decision making based on simple to complex data analysis processes Such as : Database development and administration , Data mining , Data queries and report writing , Data analytics and simulation, Benchmarking of business performance , Dashboards , Decision support systems . History … The first use of business intelligence was in 1865 by deveins about how the banker Henry making profit by receiving and acting upon information about his environment before his competitors What are the minimum requirement ? Business Intelligence initiatives are expensive endeavors. Disparate business data must be extracted and merged from online transaction processing (OLTP) systems, from batch systems and from external data sources. Business Intelligence decisions support initiatives also call for new technology, additional tasks to be performed, roles and responsibilities to be shifted, and analysis and decision-support applications to be delivered quickly while maintaining acceptable quality. Information consolidation Seamless business functionality Information integration Streamlined organizational business processes Information integrity Organization changes Corporate culture shifts Parallel development tracks Why Business Intelligence? Make more informed business decisions: Competitive and location analysis Customer behavior analysis Targeted marketing and sales strategies Business scenarios and forecasting Business service management Business planning and operation optimization Financial management and compliance Cases that Business Intelligence cannot working in ? Sixty percent of Business Intelligence projects end in abandonment or failure because of inadequate planning, missed tasks, missed deadlines, poor project management, undelivered business requirements, or poor quality of the deliverables. Technologies Supporting BI ? Database systems and database integration Data warehousing, data stores and data marts Enterprise resource planning systems Query and report writing technologies Data mining and analytics tools Decision support systems Customer relation management software Product lifecycle and supply chain management systems Moving the Control of BI into the Hands of the Users: BI 2.0 Leveraging new Web 2.0 technologies to: Enhance the presentation layer and data visualization , Provide information on-demand and greater customization ,Increase ability to create corporate and public data mash-ups , Allow interactive user-directed analysis and report writing BI careers cross over all industries: BI solution architects and integration specialists Business and BI analysts BI application developers and testers Data warehouse specialists Database analysts, developers and testers Database support specialists BI PORTALS : A?Business Intelligence portal? is the primary access interface for?Data Warehouse? and Business Intelligence applications. The BI portal is the user’s first impression of the DW/BI system. It is typically a browser application, from which the user has access to all the individual services of the DW/BI system, reports and other analytical functionality. The BI portal must be implemented in such a way that it is easy for the users of the DW/BI application to call on the functionality of the application The following is a list of desirable features for?web portals?in general and BI portals in particular: Usable User should easily find what they need in the BI tool. Content Rich The portal is not just a report printing tool, it should contain more functionality such as advice, help, support information and documentation. Clean The portal should be designed so it is easily understandable and not over-complex as to confuse the users Current The portal should be updated regularly. Interactive The portal should be implemented in a way that makes it easy for the user to use its functionality and encourage them to use the portal. Scalability and customization give the user the means to fit the portal to each user. Value Oriented It is important that the user has the feeling that the DW/BI application is a valuable resource that is worth working on. Business Intelligence (BI) Specialist: works with business users to obtain data requirements for new analytic applications, design conceptual and logical models for the data warehouse and/or data mart and communicate physical designs to the database group. The BI specialist also develops processes for capturing and maintaining metadata from all data warehousing components. Business Intelligence Developer: Business Intelligence Developer is responsible for designing and developing Business Intelligence solutions for the enterprise. The Developer works on-site at the corporate head quarters. Key functions include designing, developing, testing, debugging, and documenting extract, transform, load (ETL) data processes and data analysis reporting for enterprise-wide data warehouse implementations. Responsibilities include: working closely with business and technical teams to understand, document, design and code ETL processes; working closely with business teams to understand, document and design and code data analysis and reporting needs; translating source mapping documents and reporting requirements into dimensional data models; designing, developing, testing, optimizing and deploying server integration packages and stored procedures to perform all ETL related functions; develop data cubes, reports, data extracts, dashboards or scorecards based on business requirements. Organization that uses business intellegenece : Microsoft sisense domo pentaho prognoz References: www.cio.com ?Microsoft Data Warehouse Toolkit. Wiley Publishing. (2006) DMReview by Jonathan Wu, October 2000 en.wikipedia.org Imhoff, Claudia (4 April 2006).?”Three Trends in Business Intelligence Technology”. ?”Difference between Business Analytics and Business Intelligence”. businessanalytics.com. 2013-03-15. Retrieved?2014-06-15. ?Rud, Olivia (2009).?Business Intelligence Success Factors: Tools for Aligning Your Business in the Global Economy. Hoboken, N.J: Wiley & Sons.