Enterprise BI solution / Fortune 500 Co.
Enterprise BI solution ＿
- Multiple business-related KPIs: bookings, revenues forecast, billable percent of hours worked by engineers, costs, margins
- Top partners
- Support cases
- Dashboards and graphical / tabular reports.
- Hybrid cloud data services company
- >10000 employees
Business case ＿
- Provide customized insights based on big data
- Display KPIs
- Employ graphical presentations
Project type ＿
- BI reporting
- Customer support
- SQL Server
- SQL Server Analysis Services
- SQL Server Clone Database
- NetApp SnapManager for Microsoft SQL Server
- Continuous Integration
- Provide the most relevant business insights to the decision makers.
- Aggregate different data formats from wide range of heterogeneous systems (SAP, ORACLE BI, WebServices, CSV, Excel, Sharepoint).
- Keep the data fresh for all geographic regions, across a world-wide enterprise.
From technical perspective, we worked on:
- Keeping the data available for query while importing it.
- Securing sensitive data.
- Jobs running 24 / 7.
- Continually snapshot big amount of data, within short timeframes.
- Highly efficient cloning / database publishing mechanism setup for uninterrupted access to consistent data, while the ETL jobs are running.
- Configuring security mechanism to mask sensitive data depending on user access rights.
- Development of customized Web portal for instant access to dashboards and reports with slice and dice mechanism.
- High availability and scalability using clusters and load balancing.