Data mart solution for professional services companies
Data mart solution for professional services companies ＿
- Hybrid cloud data services company
- >10000 employees
Business case ＿
- Centralize distributed data sources
- Speed up the reporting process at the company level
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
When addressing users with little or no expertise in BI, our team had to overcome the following challenges:
- Build a data mart solution that’s easy to understand and use by all users.
- Integrate structured and unstructured data from multiple different websites.
- Provide intuitive access to information.
- Provide valuable insights for business decisions in real-time.
- Development of an online platform in order 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.