Conceptual design, implementation and introduction of a Trade Intelligence system for government agencies. Integration of trading data from various structured and unstructured sources and construction of an advanced analysis and reporting system.
We were asked to build a solution easy to understand and use for people with no previous experience in BI world and integrate structured and unstructured data from many different Websites, while providing an intuitive access to information and valuable information for business decisions in time.
Development of an online platform to centralize the system’s analysis and reporting feature. Development of custom and configurable web crawlers to grab structured and unstructured data from different websites. Integrating data received by email and RSS feeds. Development of a series of ETL processes to build a data warehouse.
Development of Microsoft SSAS cubes. Providing a comprehensive set of reports for DeltaMaster visualisation and analysis tool. Implementing a notification mechanism and an automatic newsletter generation and publishing, plus maintenance and support.
- Microsoft SQL Server
- Microsoft SQL Server Analysis Services
- Microsoft SQL Server Integration Services, Reporting Services
- DeltaMaster, Excel
- Microsoft Sharepoint
- C#, .Net Framework, Entity Framework, ASP.NET MVC