Featured projects » Analytics for a Lending Company
Analytics for a Lending Company
The Client needed a Web-based executive reporting solution, integrating data stored in multiple databases. The reports were to be refreshed on an hourly basis and were to include drill-down and click-through capabilities. In addition, an automated forecasting solution was to be developed.
Our Solution
-
Extensive business process and data analysis
-
Design of the operational data stores
-
Automation of the extract, transform, load process
-
Data integrity analysis, design and deployment of exception reports
-
Data dimension analysis and design
-
Design and development of multidimensional cubes
-
Design and development of executive reports
-
Predictive modeling
Deliverables
-
Automated ETL process (SQL Server, SSIS)
-
Multidimensional OLAP cubes (SSAS)
-
Advanced Web-based executive reporting solution(SSRS)
-
Scoring and predictive models (Excel VBA)
| Business Problem & Questions |
|