Data management system for Real Estate investment management company
Portfolio description is not provided
About
Our client provides professional services in real estate and investment management. Included in the Fortune 500 list.
Purpose: collection of real estate and organizations data from various sources (own data, Land Registry, Valuation Office Agency etc.) for further analysis and visualization.
Goal: Using information about the value of property for sale/rent, build a price heat map. Add detailed filters to provide an ability of an effective search. Search for properties with a price below the market for future investment/rental. Display of professional specification of organizations (shops, restaurants, car services, banks, etc.) to find the best location for the new business. Using data from mobile operators on the movement of tourists/citizens to determine the most visited places and display them on the map.
Technologies: Azure Data Factory, U-SQL and SSIS are used for import and data processing purposes providing an ability to handle constantly growing volume of data. Large amount of data is coming in csv and txt formats.
Created solution to handle data management using REST-APIs, Azure Blobs. Manual changes to the data are done through the web interface. The Google services and the commercial version of Address Doctor were used to standardize the addresses and restore them from the UPRN and UARN codes.
Google’s service was also used to get coordinates. Employees were involved to manually enter data through the web interface on the perimeter of buildings (polygons) to make images more detailed and realistic.
Scalability: Solution allows to gather the data in different countries and add more countries as per business needs. On the first stage all the data is coming into the Data Lake to be utilized in the search system without any country limitations.
Results: current solution let the Company
Increase the efficiency of best investment objects search process Increase the quality of property selection service provided to clients Open additional stream of income by charging third-party companies for display and advertising of their real estate objects.
- Not providedSize in euros
- Not providedPrice
- Not providedDuration in month
- Not providedTeam size
Tech Information
Skills
Services
Industries
Markets
Forrards Portfolios
Company Description
We are professionals in database administration and custom database development. We cover all aspects of database services such as:
Database administration
Bespoke database development
Reporting solutions
Business Intelligence
Data-driven applications
Database GUI development
Big data
Architecture
Implementation and maintenance
Data testing and quality assurance
Our customers represent a vast range of companies: from small and medium-sized businesses to world-famous giants that work in various business fields. We have successfully run database projects from start to finish in the following areas:
Finance
Telecommunications
Healthcare
Tourism
Retail
Manufacturing
Education
Government
Forrards provides clients who require business-critical data solutions with top quality data consulting and database-managed services. By using flexible development methodologies, we successfully adapt to the requirements changing over time and other customer`s requests. During the database development process, we help to find bottlenecks in the business processes and optimize them, and this results in additional benefits for our customers.
We're not a typical consulting and outsourcing company which lacks flexibility and looks to get as many clients as possible. Our priorities are providing quality services and building strong, long-term relationships with our clients. We`re always ready to go that extra mile and be engaged in business!
Company Information
- ForrardsCompany Name
- 70Number of Employees
- Russian, EnglishSpoken Languages
- http://forrards.comWebsite
- [email protected]Email
- 2008Year Founded
- United Arab Emirates, United KingdomHeadquarters
