The New-Caledonian government manages an Open Data platform that hosts and promotes all the Open Data of New-Caledonia on data.gouv.nc. As the underlying solution relies on OpenDataSoft, it makes interacting with all the data possible. In this session, Adrien will delve into all these metadata datasets to explore his country from a purely data-centric and graph perspective at a substantial scale.
Slides: https://drive.google.com/file/d/1fZJnKgnK3HU-uJiADFPwr_64cB6ExDIy/view?usp=sharing
Blog: https://dev.to/adriens/discover-a-country-un-sdgs-concerns-w-open-metadata-on-neo4j-13df
#neo4j #graphdatabase #nodes2023 #opendata
00:00 : Intro about New-Caledonia
01:08 : How do countries are connected to the world (and United Nations)
01:27 : Benchmarking countries Open Data maturity w/ the "Global Data Barometer" tool
02:17 : Introducing our data journey
02:52 : Ideating w/ AI : create a storytelling plan with AI crowd (Langchain SmartLLMChain & OpenAI gpt-4)
05:02 : Discovering storytelling keypoint 1/5 : Map Country's Open Data to UN SDGs
05:35 : 2/5 Identifying relationships
06:07 : 3/5 predictive analysis
06:16 : 4/5 Gap Analysis
06:30 : 5/5 Storytelling with Data
06:52 : Get smart title and subtitle for the experience
07:18 : About UN SDGs
07:36 : The data pillars we used to connect country data to UN SDGs
07:59 : About data.gouv.nc (Open Data portal from New-Caledonia)
08:22 : UN SDGs Open Data Portal
08:36 : About Pacific Data Hub from The Pacific Community (SPC)
08:58 : Project workflow, schedule and stack
09:52 : Connecting datasets to UN SDGs
10:18 : Building and putting the data together on Kaggle/DuckDb
10:30 : Discovering the schema of our knowledge graph
11:26 : About SDG goal hierarchy and "foundational goals"
11:51 : Introducing RAG (Retrieval AUgmented Generation) w/ LangChain
15:19 : RAG with LLama_Index
17:29 : SDGs interactive discovery : storytelling on Neo4J Aura DB/Bloom
20:27 : Explore Gender Equity in 3D with Kineviz GraphXR
22:22 : Dataviz with Gephisto
22:38 : Kudos to the biggest Open Data Publishers
22:59 : About the stack
23:39 : Data art and contemplation (Gephi with Runway experiment) cf https://youtu.be/Acp_TcGW-9g
25:49 : Conclusion