1 / 20

Data Warehousing

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. Graphics.

Ava
Download Presentation

Data Warehousing

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. 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

More Related