Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time Processes transactions fast for applicationExampleRetail POS systemWeb SiteOnline Transaction Processing has two key benefits: Simplicity efficiencyOLAP Online Analytical ProcessingUsed for reporting May form base of data warehouse or BI toolsNot used for transaction processing. The 5 Stages of Business IntelligenceOLTP Online Transaction processingTypically not your reporting database. The 5 Stages of Business Intelligence1.The Data: defining which data will be loaded into the system and analyzed.Where all information is storedTechnology dependentMSSQL, MYSQL, Oracle, Red Brick, DB2Often an OLAP type data sourceMany rows of often summarized dataUtilize database queries to retrieve data from the source. The Five Stages of BIBI involves five stages of taking raw data and presenting it as relevant, actionable insight to users.
WHAT ARE BUSINESS INTELLIGENCE APPLICATIONS FULL
They have full privileges to explore and analyze the data with the BI applications available to them.Business Intelligence Usersīusiness Intelligence 101Garbage in Garbage OutTransform data in to actionable insight. In addition to the privileges of a casual user, functional users have the ability to develop their own ad hoc queries and perform OLAP analysis.Super UsersSuper users have a strong understanding of both the business and technology to access and analyze transactional data. In addition to the privileges of a viewer, casual users have the ability to refresh report information and the ability to enter desired information parameters for the purposes of performing high-level research and analysis.Functional UsersFunctional users need to perform detailed research and analysis, which requires access to transactional data. Users have the ability to view static information online and/or print to a local printer.Casual UsersCasual users require the next level of detail from the information that is provided to viewers. Questions BI is Designed to AnswerOperational Which vendors are best at delivering on time and on budget?– How many additional personnel do we need to add per store during the holidays?Which order processing processes are most inefficient? Financial What is the fully loaded cost of new products? What is the expected annual profit/loss based on current marketing and sales forecasts? How are forecasts trending against the annual plan?What are the current trends in cash flow, accounts payable and accounts receivable and how do they compare with plan?Overall business performance What are the most important risk factors impacting the company’s ability to meet annual profit goals? Should we expand internationally and, if so, which geographic areas should we first target?ĨBusiness Intelligence VisionImproving organizations by providing business insights to all employees leading to better, faster, more relevant decisionsAdvanced AnalyticsSelf Service ReportingEnd-User AnalysisBusiness Performance ManagementOperational Applications Embedded AnalyticsĤ Types of UsersExecutives : Information is summarized and has been defined for them. Questions BI is Designed to AnswerA BI solution, with the right data and features, should be able to take operational data and enable users to answer specific questions such as: Sales and marketingWhich customers should I target? What has caused the change in my pipeline? Which are my most profitable campaigns per region?Did store sales spike when we advertised in the local paper or launched an email campaign?What is the most profitable source of sales leads and how has that changed over time? What do I want to happen?PastPresentFutureDataERP3PtySCMBlack booksCRM Techniques include: multidimensional analysesmathematical projection modeling ad-hoc queries 'canned' reportingDashboardsBusiness Intelligence 101ĥQuestions BI is Designed to AnswerWhat happened?
The act of using historical data to gain new information. What is Business IntelligenceMaking useful, actionable insight from stored data.Allows effective business decisions to be made. BI is an enterprise-wide platform that supports reporting, analysis and decision making.BI leads to: fact-based decision making“single version of the truth”Business Intelligence 101 What is Business IntelligenceBusiness Intelligence (BI) is about getting the right information, to the right decision makers, at the right time. Business Intelligence 101Randy ArchambaultManager Business Intelligence and ReportingPalm Beach Tan