Creation of an analytical repository for a unified digital landscape of Itell - BI.Qube, based on Microsoft data technologies

Customer
Itella
Project manager on the customer side
Nikolai Galkin
IT Director
IT Provider
IT Pro
Year of project completion
2021
Project timeline
November, 2019 - May, 2021
Project scope
970 man hours
Goals

The main objectives of this project were:

- Cost optimization by Itella when introducing piecework wages for all warehouse personnel

- Transparency and completeness of data for the Client for each service rendered to him

- Implementation of appropriate accounting and cost analysis tools

- Consolidation of heterogeneous sources into a single data warehouse



The uniqueness of the project

The fundamental idea of the project was to create a solution architecture in the Itella ecosystem, where BI.Qube became the center of a unified digital landscape for working with data on work performed by personnel, warehouse and billing operations for logistics complexes.

Data from several heterogeneous accounting systems are consolidated in BI.Qube Meta-staging, enriched with data from MDS (users enter their own tariffs for types of work), and transferred to the storage. Based on these data, analytical and verification reports are built in the reporting system, which allow evaluating the efficiency of the warehouse complex, including in the context of a client or an individual employee, as well as identifying errors and fraud committed by employees in the process of work.



Used software

The analytical system is built on Microsoft data technologies and BI.Qube meta-components, which are proprietary developments of IT Pro.

To build reports, Microsoft SQL Server Reporting Services tools are used.

The following accounting systems acted as data sources for the storage:

1C:ZiUP

1C:ARM Report card

1С:WFM (workforce management)

WMS PSI

BOSS Control

Billing system (acts and accounts of Clients)

Directories and off-system master data (Microsoft Master Data Services)



Difficulty of implementation

The project is interesting and non-trivial in terms of tasks and technological solutions.

The development was initially carried out according to the Agilu methodology: the requirements were formed during the implementation process, each sprint was a complete solution, in accordance with the requirements agreed at that time.

The algorithms in the model are classic, but there are a lot of “ifs” when calculating the required indicators. The reports calculate a large number of combinations of different factors. It was not possible to foresee all the combinations that needed to be reflected in the calculations at the stage of the formation of the TOR. An additional requirement was the prompt reflection of changes in reports when changing directories on the MDS service, which went against the practice of building analytical repositories.



Project Description

The solution allows you to perform an ETL process in conjunction with operational activities. The total duration of the ETL process and cube processing does not exceed 60 minutes. When errors are detected, BI.Qube Meta-control automatically sends notifications to responsible employees.

The analytical system operates with large data arrays, from hundreds of thousands to a million warehouse operations are processed daily.

System functions:

  • operational analytics in the context of pre-defined criteria;

  • formation of regulated reports for labor calculations (for example, concerning the formation of an employee's pay slip indicating the work performed);

  • accounting (enrichment of data with tariffs, standards, hierarchies of types and subtypes of work - manual entry via the MDS interface);

  • reports (individually according to the requests of Itella clients).


The system calculates 15 reports based on Microsoft Reporting Services. In reports in different sections, the wage fund is considered: “Total by site”, “Total by client by site”, “Accruals per month”, “Accruals per day”, “Report on completed operations - volumetric indicators”, “Number of operations, for the required period of time, for the selected employee”, etc.

BI.Qube provides data immersion (drill down). Thanks to this, you can both analyze indicators at a detailed level, and combine them by various dimensions (by employees, operations, their groups, customers, clients, sites, etc.).

Access to information is provided in accordance with the management level of the user. In addition to hierarchies of roles and distribution of access to reports, the system maintains a hierarchy of objects of warehouse complexes.

Currently, the system is used by dozens of specialists from the financial and logistics departments.

The operation of the system had a positive effect on a set of characteristics:

  • Efficiency and economic benefit. The BI.Qube system made it possible to quickly receive analytical reports on a large list of indicators

  • Optimization and Efficiency. The ability to individually track the workload of each employee allows you to reduce downtime and more rationally distribute work responsibilities.

  • Improvement of interaction with contractors for services of warehouse operations. Calculation of payment for contractors' services has become more informative. The contractor sees and records the actual data on personnel costs online.

  • Transparency and Guarantee for clients. Through the digital transformation of accounting processes, all transactions leave a digital footprint. The client can get an exhaustive detail on each service rendered to him.



Project geography
CIS

On November 30, the professional IT community GlobalCIO hosted a large-scaled international conference "Global CIO Insights: Digital Transformation with AI". During the event, leading experts shared their practical experience in launching projects utilizing artificial intelligence (AI) and highlighted approaches that helped elevate their companies to new heights.

Voting for projects participating in the "Project of the Year" contest is open. The voting began on December 1st and will continue until January 15th inclusive. The winners will be announced on February 7th, 2024.

According to the statistics agency, the number of telecommunication and IT companies has increased 1.8 times in the last five years. At the beginning of 2023, there are more than 12 thousand ICT companies operating in the country. More than 100 thousand people are employed in the industry. At the end of 2022, the volume of ICT services grew by 125.5% and amounted to 22.9 trillion soums, of which 4.2 trillion soums were programming services provided by Uzbek companies and specialists. The total revenue of Uzbekistan's IT sector for the first quarter of 2023 reached 2.38 trillion soums - almost four times more than in the same period of 2022. Exports of digital services increased to $57.2 million. According to IT Park, net income amounted to more than 90% of revenue or 2.158 trillion soums.

According to the statistics agency, the number of telecommunication and IT companies has increased 1.8 times in the last five years. At the beginning of 2023, there are more than 12 thousand ICT companies operating in the country. More than 100 thousand people are employed in the industry. At the end of 2022, the volume of ICT services grew by 125.5% and amounted to 22.9 trillion soums, of which 4.2 trillion soums were programming services provided by Uzbek companies and specialists. The total revenue of Uzbekistan's IT sector for the first quarter of 2023 reached 2.38 trillion soums - almost four times more than in the same period of 2022. Exports of digital services increased to $57.2 million. According to IT Park, net income amounted to more than 90% of revenue or 2.158 trillion soums.

Read more

The IT strategy of a large number of companies includes the automation (digitization) of not only accounting processes but also production and logistics processes.

We use cookies for analytical purposes and to deliver you the best experience with our website. Continuing to the site, you agree to the Cookie Policy.