Automated Data Collection for Better Insights
Developed a solution that automatically collects, cleans, and structures market data directly into Excel models.
Key deliverables
Proof-of-concept
Technical proof-of-concept and initial data scraping with development and testing of the technical solution for automated data collection
Automated Pipeline
Automated pipeline for data collection, cleaning, and formatting with complete data flow that automatically processes and structures market data
Excel Integration
Integration with existing Excel solutions via Power Query with seamless integration with the client's existing Excel models and workflow
Installation & Operation
Simple installation and maintenance-free operation with delivery of a robust solution requiring minimal technical maintenance
Project goal
Insula's analysis department spent large amounts of time on manual downloading and processing of market data – a bottleneck that limited both insight and capacity. The goal was to automate this work so the team could focus on analysis rather than data collection. A team from Yobr developed a customized data grabber that automatically collects, formats, and writes data directly into the client's existing Excel models – without the user needing to do anything manually.
Work process
The team started by mapping which data sources were used, how they were processed, and how much time it took. Then a modular system was developed that could collect data from multiple sources (including the Directorate of Fisheries and Barentswatch), format them correctly, and connect to existing spreadsheets. The solution was adapted to internal needs and delivered with minimal need for technical effort from the client.
Startup and testing phase
Week 1–2
Mapping of needs, data sources, and technical feasibility.
Development and integration
Week 3–5
Building solution, data flow, and integration with Excel models.
Installation and completion
Week 6
Testing, final adjustments, and delivery.
Startup and testing phase
Development and integration
Installation and completion
Week 1–2
Week 3–5
Week 6
Mapping of needs, data sources, and technical feasibility.
Building solution, data flow, and integration with Excel models.
Testing, final adjustments, and delivery.
Results and deliverables
The solution frees up several hours of manual work each week, ensures access to updated and structured data, and makes it easier for Insula to analyze market development. The solution is in daily use and requires no technical maintenance.
See how easy it is—create a draft in minutes.