Business Intelligence, Data Warehousing & ETL Concepts
3 Business Intelligence How intelligent can you make your business processes? What insight can you gain into your business? How integrated can your business processes be? How much more interactive can your business be with customers, partners, employees and managers?
4 What is Business Intelligence (BI)? Business Intelligence is a generalized term applied to a broad category of applications and technologies for gathering, storing, analyzing and providing access to data to help enterprise users make better business decisions Business Intelligence applications include the activities of decision support systems, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining An alternative way of describing BI is: the technology required to turn raw data into information to support decision-making within corporations and business processes
5 Why BI? BI technologies help bring decision-makers the data in a form they can quickly digest and apply to their decision making. BI turns data into information for managers and executives and in general, people making decisions in a company. Companies want to use technology tactically to make their operations more effective and more efficient - Business intelligence can be the catalyst for that efficiency and effectiveness.
6 Benefits The benefits of a well-planned BI implementation are going to be closely tied to the business objectives driving the project. Identify trends and anomalies in business operations more quickly, allowing for more accurate and timelier decisions. Deliver actionable insight and information to the right place with less effort . Identify and operate based on a single version of the truth, allowing all analysis to be completed on a core foundation with confidence.
7 Business Intelligence Platform Requirements Data Warehouse Databases OLAP Data Mining Interfaces Build and Manage Capabilities The business intelligence platform should provide good integration across these technologies. It should be a coherent platform, not a set of diverse and heterogeneous technologies.
8 Business Intelligence Components TRANSFORM LOAD EXTRACT OLAP DATA MINING Data Warehouse Operational Data
9 Business Intelligence Architecture
10 Business Intelligence Technologies Data Sources Paper, Files, Information Providers, Database Systems, OLTP Data Warehouses / Data Marts Data Exploration OLAP, DSS, EIS, Querying and Reporting Data Mining Information discovery Data Presentation Visualization Techniques Decision Making Increasing potential to support business decisions End User Business Analyst Data Analyst DB Admin
12 What is a Data Warehouse?
You've reached the end of your free preview.
Want to read all 87 pages?
- One '14