Мы используем файлы cookie для быстрой и удобной работы сайта. Выберите, какие файлы cookie вы разрешаете нам использовать. Подробнее в Политике конфиденциальности.
Обсудить проект
Отправьте запрос, и наши специалисты свяжутся с вами в течение 1 часа
Нажимая кнопку «Отправить», Вы даете однозначное согласие на обработку своих персональных данных в объеме и с целями, определенными Политикой в отношении обработки персональных данных.
Development of an analytical platform for data collection
and reporting
and reporting
DEVELOPMENT OF CORPORATE DATA WAREHOUSING AND DATA LAKES
15
5
the speed of management decision-making has increased
from 1-2 days to
by
reduced labor costs
for collecting reports
for collecting reports
min
times
production
Customer
Mining and metallurgical holding company: 53 enterprises, 72,000 employees
CHALLENGES/FEATURES
inaccurate reporting by the holding company; key performance indicators were calculated differently at different enterprises
the holding's enterprises and departments work with data autonomously
disparate IT systems, some of which are outdated
reports are collected manually
low speed of information collection for making management decisions
financial losses and employee demotivation
Collecting data from autonomous IT systems to generate regulatory reporting for the holding company
Task
solution
Technical solution
1. Conducted an analysis of current IT systems - from data collection and storage to data processing and analysis
2. Integrated 20 IT systems:
3. Automated data loading from various heterogeneous sources and developed our own framework
1C: ZUP 8
FriendWork
production relational and non-relational DBMS
streaming data from telemetry sensors
manual data entry systems (Totum, etc.) and Excel
4. Ensured data quality management, accuracy, and relevance at all stages of information transfer, and developed our own framework
5. Developed 150 reports—dashboards, screen forms by blocks:
staff
finance
ore production
Get a consultation
Project under NDA
An example of a dashboard for finished product output in Power BI
6. Implemented data processing algorithms: data extraction, transformation, enrichment, and data mart creation for 300 source tables:
organizational structure of the enterprise
NSI
steel production at the holding's enterprises
employees, etc.
Result
Business values
An analytical platform for generating management reports
with a single point of truth (Single Source of Truth)
with a single point of truth (Single Source of Truth)
all users and systems have access to a single data source
The speed of making management decisions increased from 1-2 days to 15 minutes
Saving resources
reduced labor costs for reporting collection by 5 times
Import independence of software
Greenplum
information is reliable, relevant and consistent
Production efficiency
minimized financial risks by improving the quality and speed of making management and operational decisions based on the information collected
Reduced payroll costs by 3 times through automation of routine data collection tasks
S3 Minio
Apache Airflow
Python-based framework + Airflow
By clicking the "Submit" button, you expressly consent to the processing of your personal data to the extent and for the purposes defined in the Personal Data Processing Policy.
Development of software
and Big Data solutions
and Big Data solutions
Send a request and our specialists will contact you within 1 hour.
Choose a convenient method of communication
You can attach three files up to 3 MB each. Formats: doc, docx, pdf, ppt, pptx
Сообщение об успешной отправке!