Featured projects » 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.
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
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 |
|