Client & Scope
Client:
Business Intelligence Service Provider, UK Client is a leading Business
Intelligence service provider serving organizations in different industries, offering scalable cloud computing platforms that use the most advance and market leading Business Intelligence and data management too
Scope:
- Data Acquisition from multiple sources Design & Build EDW
- Data Processing / Transformation Building Analytics for User Consumption
Business Value & Benefits
- A common source of data for Different Retail clients having a similar business.
- Developing solution on AWS platform leading to a reduction in the cost of maintaining on-premise infrastructures.
- Leveraging Cloud-based scalable services for an on-demand service-oriented model.
Solution & Technology
- Building DW/BI solutions using Jaspersoft, Talend ETL and Redshift on AWS. Configuring various AWS components and provisioning the environment for BI reporting.
- Building/enhancing/maintaining domains, retrieving data using domains and Freehand SQL methods.
- Designed complex, pixel-perfect and interactive dashboards using Jasper server.
- Designed Ad Hoc and complex reports using Jaspersoft Server and report studio. Used Jaspersoft functionalities like Drill Down, Drill through, sub reports and Master-Detail linkage, etc.