Datamart solution for professional services companies
Hybrid cloud data services company
> 10000 employees
- Centralize distributed data sources
- Speed up the reporting process at company level
- IT Services
- Professional services
- Office automation
- Custom software development
- Managed services
Project type ＿
- ETL backend
- Customer support
- SQL Server
- SQL Server Analysis Services
- SQL Server Integration Services
- Reporting Services
- NetApp SnapManager for Microsoft
- SQL Server
- Power BI
- Continuous Integration
We have developed a system of multiple ETL processes for data aggregation from multiple sources, while building a set of Microsoft SSAS cubes to be consumed by various clients like Tableau and Excel.
When addressing users with little or no expertise in BI, we were required to:
- Build a solution that’s easy to understand and use.
- Integrate structured and unstructured data from multiple different websites.
- Provide intuitive access to information.
- Provide valuable insights for business decisions in real time.
We met client’s high expectations with a series of cross-technology solutions:
- Development of an online platform to centralize the system’s analysis and reporting features.
- Development of custom and configurable web crawlers to grab structured and unstructured data from different websites.
- Integration of 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 visualization and analysis tool.
- Implementing a notification mechanism and an automatic newsletter generation and publishing.
- Maintenance and support.