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:
5

Phase 1 – Data extraction:

5

Phase 2 – Data analysis and modeling:

5

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.

Ready for
a Solution?

To get started, we just need to connect.

    Share this case study

    Other Case Studies