1 / 18

IS Consulting Process ( IS 6005 )

IS Consulting Process ( IS 6005 ). Masters in Business Information System s 26 th Feb 2010. Fergal Carton Bu siness Information Systems. Last week. Cubes are logical configurations, technically there may be one RDBMS Soft information Very important soft information is not for recording

uta
Download Presentation

IS Consulting Process ( IS 6005 )

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. IS Consulting Process(IS 6005) Masters in Business Information Systems 26th Feb 2010 Fergal Carton Business Information Systems

  2. Last week • Cubes are logical configurations, technically there may be one RDBMS • Soft information • Very important soft information is not for recording • For consultants, it is the off the record comments that are often the most revealing • Data integrity problems can occur within one ERP system • Multiple occurrences of the same customer within one ERP system • Different levels of granularity for recording product weights • A framework for transition of data to decisions • Transformation of raw data to management information involves different layers of technology (ERP, BI, DW, Excel) • ETL and data quality problems • Transformation from different source currencies to one reporting currency • Real time information requirement • Managers always want real time information., but it’s not always necessary • For UCC, come up with requirements for real time information

  3. This week • Life cycle of DW and refresh rates • Real time information requirement • Response times

  4. Data Quality Problems Orphaned transactions: some transactions may be missing important parts such as an order without a customer. Multipurpose fields: some databases may combine data into one field such as different components of an address. Conflicting data: some data sources may have conflicting data such as different customer addresses. Different update times: some data sources may perform updates at different intervals.

  5. Life cycle of the DW Warehouse Database First time load Operational Databases Refresh Refresh Purge or Archive Refresh

  6. Real time information Up to date On-line Actual data Live feed Decisions made on what basis?

  7. Real time requirement? Historical sales or accounting data, not real-time Sales as quarter end approaches Inventory levels for MRP Exchange rates, when is Visa rate calculated? Real-time processing: card transactions down

  8. Real time requirement UCC?

  9. Real time requirement UCC? • De-registering students? • BIS dependent of central services • Monthly is good enough in terms of swipe access • Transferring to another course, keeping grant • Tutor hours getting into payroll? • Hours have to be entered by a certain deadline • KPI’s

  10. Problems with static information • Delay contacting a student • Email • Telephone • Fire and safety (for headcount) • Queues of students at peak times • Parking spaces available • Occupancy of rooms • Out of date photos

  11. Date driven data at UCC Alumni records Registration Teaching support Student card Services Students Exam results Library Fees Payroll Timetable

  12. Response times Response times are a function of : response time, Infrastructure elements, Database sizing Transaction processing Interfaces Reporting Other processing demands Peak times …

  13. Example Revenue reports from EMC Data warehouse Report can grow to >1million lines at quarter end Should not be run on ERP server Poorly designed?

  14. Manager’s view Volume has been increasing at a huge pace compared to … like, you go talk to Jonathan, … my answer to it will be, get used to it, it’s not going to go away, I don’t care what you do, it’s not my problem, I want the reports, you deal with the volume of records, it’s not going to go away, you deal with it.

  15. Refreshing databases Timing Criticality of information Volume of data Response time Real-time requirement Level of aggregation / granularity

  16. Refresh Optimization

  17. Determining the Refresh Frequency Maximize net refresh benefit Value of data timeliness Cost of refresh Satisfy data warehouse and source system constraints

More Related