Success Stories

Big Data, Data Warehouse and Business Intelligence Success Stories

Data WarehouseBelow are examples of big data, data warehouse and business intelligence projects we have undertaken for our clients. Caserta Concepts’ specialists judge their success on the success of our clients. Interested in hearing more? Contact us.

We Designed a New Enterprise Data Warehouse for a Global Leader in the Management Consulting Industry

This project, like the majority of our data warehousing work, started with our Business Analysts gathering and documenting user requirements. Our data warehouse specialists then architected, designed and built dimensional data models, with some 22 data marts. We used our source system analysis and data profiling results coupled with business rules and requirements to create logical source-to-target mappings and then built the physical extract, transform, load (ETL) jobs with associated metadata to load the newly designed enterprise data warehouse.

Our Experts Project Managed and Led a Data Mart Initiative for a Local News and Information Destination

Caserta Concepts’ specialists designed and developed a dimensional data model to support the integration of Click stream analysis for over 100 individual websites with enterprise data. For this project we used Microsoft SQL Server to implement the database and documented and metadata and client’s business requirements throughout the process. We used a combination of shell scripts and Informatica to parse, filter and combine W3C web logs from across hundreds of servers.  Web activity was combined with enterprise data to provide one-stop-shop data analytics.

Based on a Sybase, Business Objects and DataStage Environment, Caserta Concepts Provided Data Warehouse/ETL Solution for a National Department Store Chain

During this project, our specialists worked with a national retailer and provided them with a comprehensive review, recommendation and strategic roadmap, along with project management to help them extend the life of their existing data warehouse and ETL systems. The project largely entailed making tactical and strategic changes with regard to proven dimensional modelling techniques, database tuning and configuration, ETL best practices, and hardware and software selection.

We implemented a new data warehouse, business intelligence solution, data quality subsystem, and a master data management and ESB system as a foundation for a new technical ecosystem.

For a leading Medicaid / Medicare healthcare insurance provider, we designed and built a Data Warehouse and MDM system as an Enterprise Data Service. The data warehouse captures and presents – in near real-time – Claims, Sales, Enrollments, Agent Retention, Premiums, Commissions, and General Ledger / Profitability information.  The MDMs cleanse and publish Agent, Office, Member, Product, and Provider information.  The Business Intelligence layer provides corporate reporting, an ad-hoc interface and dashboarding. The EDS leverages the data assets of the DW and MDMs to provide bi-directional information exchange capabilities.

These are just a few of the many successful data warehousing and data analysis projects in which Caserta Concepts’ experts have played a central role.

Talk to us today about how we can help your business to gain better access to your data through big data, data warehouse and business intelligence solutions.