Challenges

1. Implementing data processing techniques and methodologies to calculate pivotal KPIs
2. Raw Data Warehouse (RDWH) used traditional on-premises infrastructure for its extensive data needs. It had a three-tier overloaded database system
3. A performance issue involved with creating an environment for application testing, as data cannot be easily or quickly copied from production to test
4. Costly hardware and software licensing
5. Interactive Dashboard redesign on QlikSense platform to provide intuitive insights for stakeholders

Goal

Create a platform to encourage self-service analytics and efficient data-driven decision processes

Results

1. Costs have been reduced by 30% annually
2. An improved user experience that refined data querying and exploration through a web Ul
3. Enabled data scientists and other programmers to leverage Snowflake’s scalable processing power to run AI/ML algorithms efficiently
4. Using Snowflake in the Cloud enables faster and easier recovery in case of a technology-related outage
5. Empowered users with self-service analytics, enabling them to explore and analyze data independently, uncover insights, and make data-driven decisions
6. System scales based on demand. This means reporting is no longer affected or delayed due to spikes in system demand

Business challenge

• Conduct code audit, review of QlikView applications UI
• Customize QlikView Applications
• Implement Best Practices.

SOLUTIONS HIGHLIGHTS

IBA Group has developed an Enterprise Data Warehouse, multidimensional data arrays (OLAP cubes) and step-wise data import from various sources: transactional database, Sharepoint, Web services, SAP. Our experts analyzed the company’s processes, set up ETL processes and data cleansing, developed and customized SQL. They also introduced an abnormal event alert system for the ETL-system, configured information collection with the least load on database sources.

For the data warehouse of internal projects, we developed new models and processes for preparing data for QlikView. An IBA Group specialist checks the application for compliance with multiple criteria: design in accordance with corporate styling and coding standards, inclusion of certain visualization objects and proper optimization.

Auditors receive engagements to review the code and UI of applications. The customer receives reports in a standard format, and the developers receive revision lists. After correction, the application is subject to audit again. To speed up the process, the central office delivers some of the applications for refinement to experts from IBA Group.

Result

The Customer is continuously optimizing and improving the quality of QlikView applications and corporate data.