Datamart solution for professional services companies
Client ＿
- Hybrid cloud data services company
- >10000 employees
- USA
Business case ＿
- Centralize distributed data sources
- Speed up the reporting process at company level
Industry ＿
- IT Services
- Professional services
- Office automation
Services ＿
- Custom software development
- Managed services
Project type ＿
- Operations
- ETL backend
- Customer support
Technology ＿
- SQL Server
- SQL Server Analysis Services
- SQL Server Integration Services
- Reporting Services
- NetApp SnapManager for Microsoft
- SQL Server
- ETL
- Tableau
- Power BI
- Excel
- Splunk
- Pentaho
- Java
- Groovy
- Junit
- Jetty
- Tomcat
- Jenkins
- Maven
- Continuous Integration
Description ＿
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.
Challenges ＿
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.
Solutions ＿
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.
29 years in business | 2700 software projects | 760 clients | 24 countries