Unit 5 Designing and Managing BI system Anil

Unit 5 Designing and Managing BI system Anil Hulsure

Syllabi • Determining infrastructure requirements • Planning for scalability and availability • Managing and maintenance of BI system • Managing BI operations for business continuity

Determining infrastructure requirements 1. Infrastructure Requirements 2. Organizational Requirements

Business Intelligence Infrastructure

Infrastructure Requirements • • • Data Integration Information Warehouse Customer Intelligence Operational Intelligence BI application Portals

Organizational Requirements • • ETL Developer responsibility BI analyst responsibility Data administrator responsibility Managers responsibility

Planning for scalability and Availability • BI System Scalability • Scaling to everyone • Scaling for different kinds of data and data of any size • Scaling for different type of questions • Implementing BI Scalability

Managing and maintenance of BI 1. 2. 3. 4. 5. 6. 7. 8. Prioritization of project Business sponsorship Business needs Amount and Quality of available data User Aspects Industry specific Semi structure or un structure data Use of metadata

Managing BI operations 1. 2. 3. 4. 5. 6. 7. BI provide historical, current and predictive views of business operations. Common functions of business intelligence technologies are Reporting OLAP Data mining Business performance management Benchmarking Text mining predictive analytics

BI operations for business continuity 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. Software as a service Search functionality Dashboards Business activity monitoring Mobile access Enterprises information portals Strategic planning implication Business intelligence scenario Revenue Customer relationship management Sales and marketing Success factors of implementation

Pros and Cos of BI ?

Thank You