Download
data warehousing n.
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehousing PowerPoint Presentation
Download Presentation
Data Warehousing

Data Warehousing

361 Vues Download Presentation
Télécharger la présentation

Data Warehousing

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Virtual University of Pakistan Data Warehousing Lecture-38 Case Study: Agri-Data Warehouse Ahsan Abdullah Assoc. Prof. & Head Center for Agro-Informatics Research www.nu.edu.pk/cairindex.asp FAST National University of Computers & Emerging Sciences, Islamabad DWH-Ahsan Abdullah

  2. Graphics Step-5: Surprise case Sucking pests Ball Worm Complex SBW: Spotted Ball Worm ABW: Army Ball Worm PBW: Pink Ball Worm If pest population is low, predator population will also be low, because there will be less “food” for predators to live on i.e. pests. DWH-Ahsan Abdullah

  3. Step-6: Data Acquisition & Cleansing Hand filled pest scouting sheet Graphics Typed pest scouting sheet DWH-Ahsan Abdullah

  4. Step-6: Issues DWH-Ahsan Abdullah

  5. Step-6: Why the issues? DWH-Ahsan Abdullah

  6. Step-7: Transform, Transport & Populate DWH-Ahsan Abdullah

  7. Motivation For Transformation Graphics DWH-Ahsan Abdullah

  8. Step-7: Resolving the issue Graphics DWH-Ahsan Abdullah

  9. Step-8: Middleware Connectivity DWH-Ahsan Abdullah

  10. Step-9-11: Prototyping, Querying & Reporting SELECT Date_of_Visit, AVG(Predators), …………………………AVG(Dose1+Dose2+Dose3+Dose4) FROM Scouting_Data WHERE Date_of_Visit < #12/31/2001# and predators > 0 GROUP BY Date_of_Visit; Graphics DWH-Ahsan Abdullah

  11. Step-12: Deployment & System Management DWH-Ahsan Abdullah

  12. Agri-DSS usage: Data Validation DWH-Ahsan Abdullah

  13. Agri-DSS usage: Data Validation Graph ALL goes to graphics DWH-Ahsan Abdullah

  14. Agri-DSS usage: FAO report DWH-Ahsan Abdullah

  15. Graph Graphics Why negative correlation between yield and pesticides? Using pesticides to increase yield. DWH-Ahsan Abdullah

  16. Agri-DSS usage: Spray Dates DWH-Ahsan Abdullah

  17. Agri-DSS usage: Spray Dates Graph DWH-Ahsan Abdullah

  18. Agri-DSS usage: Explaining Findings DWH-Ahsan Abdullah

  19. Agri-DSS usage: Sowing Dates Graphics DWH-Ahsan Abdullah

  20. Conclusions & Lessons • ETL is a big issue. • Each farmer is repeatedly visited • There is a skewness in the scouting data. • Decision-making goes all the way “down” to the extension level. All goes to graphics DWH-Ahsan Abdullah