Case Study: Data Warehouse Development & Maintenance (Automotive)
Mantra has successfully provided consulting and IT outsourcing services to many businesses and Fortune 500 corporations. Here is a list of vertical markets that represent Mantra's client base.
Client: Internet Automotive Sales and Marketing Company
Domain: Automotive / eMarketing
Challenges: With huge amount of information coming in from various sales channels customer needed a way to build intelligence from that information, empower sales force to accurately forecast and aggressively sell, provide detail analysis to end customers, provide online reporting functionality, dashboard metrics
Mantra’s Solution: Starting with domain knowledge and technical understanding Mantra came up with robust and scalable data warehouse architecture in a very short time, once approved by a customer Mantra team proceeded to development and created prototype before final model,
Value Addition:
- Data warehouse in operation for around 3 years
- Numerous features added since initial development
- Around USD 3 million of revenue generated through custom reports generated through DWH.
- Very low cost maintenance.
- Fully automated ETL and reporting provided.
Team Size: 3 Database Developer, 1 QA
Technology: SQL Server, SSRS Reporting Engine, Crystal Reports |
