1 / 13

Business Inteligence and Datawarehousing

Business Inteligence and Datawarehousing. Presentation for study visit to NL. Agenda. Defintions Bi Framework Agis BI & Datawarehouse organisation Datamodelling Dataflow and quantity Tooling Demo Tip. Definitions. Business Intellingence (from data to Knowledge):

byron
Download Presentation

Business Inteligence and Datawarehousing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Inteligence andDatawarehousing Presentation for study visit to NL

  2. Agenda • Defintions • Bi Framework • Agis BI & Datawarehouse organisation • Datamodelling • Dataflow and quantity • Tooling • Demo • Tip Business Intelligence and Datawarehousing

  3. Definitions • Business Intellingence (from data to Knowledge): A category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. Datawarehousing : Bill Inmon: "a subject oriented, integrated, time variant, nonvolatile collection of data in support of management's decision-making process" Business Intelligence and Datawarehousing

  4. Business Intelligence and Datawarehousing

  5. Agis BI & Datawarehouse organization • Users (Business Intelligence) • Normal End users (business users/departmental level) • Power users (specialized en central –R&D organization) • 1e line support (central in the organization) • 2e line support (central in the organization) • (Change) Management en BAU (Datawarehousing) • Central in the organization (functional en technical together) Business Intelligence and Datawarehousing

  6. Datamodelling Source DATAWAREHOUSE Store Datamart End user layer reports Datamart Business Objects Copy transformation Business Intelligence and Datawarehousing

  7. Dataflow en quantity (usage) 4,7 Miljard records 400 named users 15 datamart Average 60 users a day Business Intelligence and Datawarehousing

  8. Used Tooling • Oracle (database) • ETL ( loading datawarehouse) • Business Objects ( making of reports for endusers) • Full client an Web version • SAS (making of reports an analysis for power users) • Noad (versions) Business Intelligence and Datawarehousing

  9. Business Intelligence and Datawarehousing

  10. Example : Huisartsenmonitor (pharmacy monitor)Monitoring amount of MD-prescriptions per period ) Business Intelligence and Datawarehousing

  11. Example : Costs expected Business Intelligence and Datawarehousing

  12. DEMO • Customers by region (including new) • Customers by age, sexe and • Other questions • ……… Business Intelligence and Datawarehousing

  13. TIP : Think BIG start Small • You get quick results • Satisfied end-users • you don't have to start again Business Intelligence and Datawarehousing

More Related