BI system helps them to get fresh insights to develop unique business strategies. The data analyst is a statistician who always needs to drill deep down into data. Four types of BI usersįollowing given are the four key players who are used Business Intelligence System: It also gives department personnel access to a richer data source. The use of BI tools frees information technology staff from the task of generating analytical reports for the departments. It helps branch manager to determine who are the most profitable customers and which customers they should work on. It also collects statistics on market share and data from customer surveys from each hotel to decides its competitive position in various markets.īy analyzing these trends year by year, month by month and day by day helps management to offer discounts on room rentals.Ī bank gives branch managers access to BI applications. It helps to find aggregate revenue generated per room. In OLTP system dealing with customer demographic data bases data that could be fed would beĬorrespondingly in the OLAP system query that could be executed would be can customer profile changes support support higher product priceĪ hotel owner uses BI analytical applications to gather statistical information regarding average occupancy and room rate. In an advertising database of OLTP system query that could be executedĬorrespondigly, in BI system query that could be executed would be how many new clients added due to change in radio budget In an Online Transaction Processing ( OLTP) system information that could be fed into product database could beĬorrespondingly, in a Business Intelligence system query that would beexecuted for the product subject area could be did the addition of new product line or change in product price increase revenues Examples of Business Intelligence System used in Practice
Step 3) Using BI system the user can ask quires, request ad-hoc reports or conduct any other analysis. The table can be linked, and data cubes are formed. Step 2) The data is cleaned and transformed into the data warehouse. The data could be spread across multiple systems heterogeneous systems. Step 1) Raw Data from corporate databases is extracted. How Business Intelligence systems are implemented? BI systems can be used not just by enterprises but SME (Small and Medium Enterprises).BI helps on data visualization that enhances the data quality and thereby the quality of decision making.With BI systems organizations can identify market trends and spot business problems that need to be addressed.Identify and set benchmarks for varied processes.Measurement: creating KPI (Key Performance Indicators) based on historic data.Examples of Business Intelligence System used in Practice.How Business Intelligence systems are implemented?.BI supports fact-based decision making using historical data rather than assumptions and gut feeling.īI tools perform data analysis and create reports, summaries, dashboards, maps, graphs, and charts to provide users with detailed intelligence about the nature of the business.
It is a suite of software and services to transform data into actionable intelligence and knowledge.īI has a direct impact on organization’s strategic, tactical and operational business decisions. BI(Business Intelligence) is a set of processes, architectures, and technologies that convert raw data into meaningful information that drives profitable business actions.