Background

One of the business units of the customer’s company was previously a stand-alone company, so they used non-standard software to create reports. Employees of this business unit had to use MS Excel to bring their reports to a standard form.

Business Challenge

Automate the generation of standard reports adopted in all business units of the company.

Solution

To automate report generation, we developed SSDM (Security Systems Data Mart) — an integrated data warehouse. This warehouse contains data from their custom systems previously used by this business unit, as well as standard data from the systems of other business units of the company. This data contains information on payments, services and accounting. Automatic reports are generated in Cognos.

The developed system has a complex business logic that is constantly changing and evolving. In the course of the project, there was a migration from one contract management system to another, which has a different data model. Then the system was migrated to interact with clients to another service. These changes were considered in the operation of the data warehouse and the integration was completed successfully.

Result

Most of operations that employees used to do in MS Excel are now performed automatically in SSDM. We configured automatic reporting in Cognos. Also, the developed data warehouse is used by other business units of the company as a data source for reports.

Previously, it took most of the month to generate reports, but with the introduction of the new solution, this time has been reduced to 2-3 days.

Business challenge

Automate the collection and analysis of information on the performance of a network of self-service machines.

Solution

IBA Group has developed a BI system with modules for monitoring, analytics, prompt alerts, forecasting and optimization. Using the solution, employees generate interactive analytic reports without engagement of IT specialists. IBA Group expanded the Enterprise Data Warehouse, which now also stores information about the status of the network of self-service machines. They implemented procedures for data export from banking systems, data cleaning and uploading to data warehouse. The system is accessible from personal computers and mobile devices.

Result

The bank improved the speed and quality of cash collection and equipment repairs. The solution allows the bank to predict operation of the network of self-service machines and quickly generate reports.

Business challenge

Automate the collection and analysis of information on the performance of a network of self-service machines based on the data from OpenWay Way4 payment system, integrated with the Enterprise Data Warehouse of the bank.

Solution

IBA Group has developed a BI system with modules for monitoring, analytics, prompt alerts, forecasting and optimization. Using the solution, employees generate interactive analytic reports without engagement of IT specialists. IBA Group expanded the Enterprise Data Warehouse, which now also stores information about the status of the network of self-service machines. They implemented procedures for data export from banking systems, data cleaning and uploading to data warehouse. The system is accessible from personal computers and mobile devices.

Result

The bank improved the speed and quality of cash collection and equipment repairs. The solution allows the bank to predict operation of the network of self-service machines and quickly generate reports.

Business challenge

Improve the quality of customer analytics and services. Collect additional information from public sources: social media and forums.

Solution

The solution collects data from various external sources. Using semantic and cluster models, it identifies objects of interest. It complements existing dictionaries with business terms, calculates a satisfaction rating based on sentiments in comments and reviews, and visualizes sentiment data. Visualization is based on Qlik Sense, however any BI system can be used.

Result

The solution is applicable to any enterprises and organizations that provide services or sell products to a wide segment of the population, which can be discussed on forums, edicated websites and social media.

Business challenge

The company set an objective to assess the efficiency of budget spending on the advertising of manufactured drugs, and to build an optimal advertising strategy.

Solution

IBA Group experts together with methodologists from the consulting company analyzed the costs of advertising in the media, on TV and radio, outdoor advertising and online promotional campaigns. Five-year data were used to take into account the impact of economic factors and seasonal fluctuation. Specialists created an interpretive forecast model with a seasonal component and identified key parameters that influence brand loyalty.

The results of the study showed that outdoor advertising is greatly overestimated and its efficiency needs to be evaluated more carefully. In addition, advertising a single product in a product line may increase sales of all products in a line – the so-called “halo effect,” when brand visibility due to the main product is extended to cover the entire line.

Result

Marketers obtained new tools: a dashboard for comparative analysis of the sales level and advertising efficiency in various channels, and a calculator for the optimal allocation of budgets for the forecast period. They were used to identify budget limits, above which there’s no point to invest in promotion, because the efficiency of advertising campaigns decreases sharply and does not lead to expected sales.

Financiers and budget owners use accurate data to plan investments in each advertising channel for various estimated levels of advertising budgets.