Migrating a Real Estate Company information system to SQL Server

Common databases for the entire company facilitate communication between departments and managers.

Client: a real estate company.

Need: To homogenize different data handled by company's departments.

Previous situation: Most of the information was in a specific management program for real estate companies, but there were also several Access databases and many Excel spreadsheets managed by different departments. There was a lot of duplicated and apparently contradictory information.

Implementation: All data that was scattered throughout the organization was grouped in SQL Server with Integration Services. Once the data model and the DB were created, the company's processes had to be modified. Multidimensional tables were also created with Analisis Services in order to have a better control from the management of the company's progress. Finally, reports were generated to consult from computers or mobile phones with Microsoft Power BI reporting server.

 Cost: 500 days + licenses

No comments:

Post a Comment