246254940-49303079-DW-ETL-Concepts-pdf.pdf - Business Intelligence Data Warehousing ETL Concepts Business Intelligence Business Intelligence How

246254940-49303079-DW-ETL-Concepts-pdf.pdf - Business...

This preview shows page 1 - 13 out of 87 pages.

Business Intelligence, Data Warehousing & ETL Concepts
Image of page 1
Business Intelligence
Image of page 2
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?
Image of page 3
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
Image of page 4
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.
Image of page 5
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.
Image of page 6
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.
Image of page 7
8 Business Intelligence Components TRANSFORM LOAD EXTRACT OLAP DATA MINING Data Warehouse Operational Data
Image of page 8
9 Business Intelligence Architecture
Image of page 9
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
Image of page 10
Data Warehousing
Image of page 11
12 What is a Data Warehouse?
Image of page 12
Image of page 13

You've reached the end of your free preview.

Want to read all 87 pages?

  • One '14

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture