Home > Case Studies > Data Processing and Visualization of Weather Data for Business
Home > Case Studies > Data Processing and Visualization of Weather Data for Business
Data Processing and Visualization of Weather Data for Business
Build a real-time weather information processing and visualization software
Duration: 28 months
Industry: Aviation
Data Processing and Visualization of Weather Data for Business
Build a real-time weather information processing and visualization software
Duration: 28 months
Industry: Aviation
Overview
The client is a leading provider of weather forecasting service for business aviation operators.
The project requirements included the processing of weather-related data from both government and private sources, building of weather data models, and development of a web-based application to visualize location-based weather data on Google Maps.
The Solution
Perituza assembled a development team with experience in processing high-volume data with Microsoft SQL Server database technology and GIS (Geographical Information Systems). The project was conducted in three phases:
Phase 1 – Data extraction:
Phase 2 – Data analysis and modeling:
Phase 3 – Development of a web application featuring data visualization:
Phase 1
- 5Perituza built SSIS packages to download data files from various sources via HTTP and FTP
- 5Decoded and extracted data elements and stored them in the Microsoft SQL Server database
- 5Scheduled SSIS packages to run on various time intervals
Phase 2
- 5Utilized SQL Server spatial queries to build various data models
- 5Worked with the client’s weather data specialists to validate the data models
Phase 3
- 5Built a web portal to visualize various weather forecast information such as wind direction, wind temperature, precipitation, and humidity.
- 5Overlaid weather-related data on Google Maps for location-based visualization
The team consisted of
- 5A lead database developer specialized in Microsoft SQL database and SSIS
- 5A GIS consultant with experience in Python and SQL spatial queries
- 5Two (2) full-time web developers specialized in ASP.NET MVC and C#
- 5A UI developer specialized in HTML, CSS, and JavaScript
- 5Two (2) full-time SQL developers
Technologies used
- 5ASP.NET MVC
- 5SSIS
- 5JQuery
- 5FoxPro
- 5C#
- 5DEGRIB
- 5Amazon Web Services (AWS)
- 5Google Maps APIs
- 5Web Api
- 5MS SQL Server
Project management and communication
tools used
- 5JIRA
- 5Confluence
- 5 Hipchat
- 5Bitbucket
- 5Skype
- 5 GoToMeeting
- 5 Direct dial phone
- 5Email
- 5JIRA
- 5Confluence
- 5 Hipchat
- 5Bitbucket
- 5Skype
- 5GoToMeeting
- 5Direct dial phone
- 5Email
The Result
The project was implemented successfully and the software is now used by the client’s global customers in planning flights across the world. The system processes approximately 2.5 million data records every six (6) hours.
Other Case Studies
Mobile App Development to Share Videos and Search Athletes
My Crop is a mobile app solution which connects young athletes with college coaches, and fans. The athletes add their performance video highlights from YouTube and Instagram.
Development of Mobile App and a POS system
The client is a technology company who provides a Point of Sale (POS) software platform for coffee shops and a mobile app for customers.