DGTICO. Good ideas
DGTICO. Good ideas
The DGTICO agency provides a wide range of services in the Digital sphere. We are engaged in software development, analytics, design, and implementation of corporate data warehouses.
Our Profile
Our Profile
The main direction of our work is the development of software for analyzing "raw" business data of clients. The result of our software work is systematized information that allows clients to make correct tactical and strategic business decisions.
The main direction of our work is the development of software for analyzing "raw" business data of clients. The result of our software work is systematized information that allows clients to make correct tactical and strategic business decisions.
Our team
Our team
DGTICO is a team of specialists with experience in analytics, marketing, and development. We have both seasoned business planning experts (some of whom entered this field a decade ago) and young, but very savvy guys, eager for new and interesting challenges.
DGTICO is a team of specialists with experience in analytics, marketing, and development. We have both seasoned business planning experts (some of whom entered this field a decade ago) and young, but very savvy guys, eager for new and interesting challenges.
Our mission
Our mission
In business data analysis, our team relies not only on personal experience, but also on the cutting-edge expertise of other specialists in the field. However, in one thing we have always relied only on ourselves: we independently developed software solutions for working with data.
In business data analysis, our team relies not only on personal experience, but also on the cutting-edge expertise of other specialists in the field. However, in one thing we have always relied only on ourselves: we independently developed software solutions for working with data.
Our developments are based on open-source technologies, so we do not experience difficulties due to the restriction on the use of software from well-known brands. We are well acquainted with the market and promptly provide services both in the field of business process analysis and in the development of high-quality software for the collection, accumulation, storage, and processing of business data.
Our developments are based on open-source technologies, so we do not experience difficulties due to the restriction on the use of software from well-known brands. We are well acquainted with the market and promptly provide services both in the field of business process analysis and in the development of high-quality software for the collection, accumulation, storage, and processing of business data.
Our services
Our services
I. Development and Implementation
of Corporate Data Warehouses
I. Development and Implementation
of Corporate Data Warehouses
Designing DWH architecture
Designing DWH architecture
Development of the concept, selection of the technology stack (Greenplum, ClickHouse, etc.), logical model.
From 200,000 ₽ *
(for 1 project)
Development of ETL/ELT processes
Creating connectors and scripts for collecting, transforming, and loading data.
From 350,000 ₽ *
(for 1 project)
Deployment and configuration of DWH
Deployment and configuration of DWH
Includes the installation and configuration of the database management system, performance optimization.
From 650,000 ₽ *
(for 1 project)
Разработка BI-отчетности
и дашбордов
Разработка BI-отчетности
и дашбордов
Creating interactive reports (Power BI, Tableau).
From 120,000 ₽ *
(for dashboard/module)
II. Development and Implementation
of ERP Systems
II. Development and Implementation
ERP Systems
Pre-project survey and technical specifications
Pre-project survey and technical specifications
Detailed analysis of business processes, development of technical specifications.
From 250,000 ₽ *
(for 1 project)
Development of a basic ERP module
Development of a basic ERP module
For example, a financial accounting or warehouse management module.
From 1,200,000 ₽ *
(for 1 module)
Development of the integration gateway
Development of the integration gateway
Ensuring the interaction of ERP with external systems (banks, EDO, CRM).
From 450,000 ₽ *
(per 1 gateway)
Implementation and configuration
of the ERP system
Implementation and Configuration
of ERP System
Installation, data migration, user training.
From 2,000,000 ₽ *
(for 1 project)
Our Profile
The main direction of our work is the development of software for analyzing "raw" business data of clients. The result of our software work is systematized information that allows clients to make correct tactical and strategic business decisions.
Our team
DGTICO is a team of specialists with experience in analytics, marketing, and development. We have both seasoned business planning experts (some of whom entered this field a decade ago) and young, but very savvy guys, eager for new and interesting challenges.
Our mission
In business data analysis, our team relies not only on personal experience, but also on the cutting-edge expertise of other specialists in the field. However, in one thing we have always relied only on ourselves: we independently developed software solutions for working with data.
Our developments are based on open-source technologies, so we do not experience difficulties due to the restriction on the use of software from well-known brands. We are well acquainted with the market and promptly provide services both in the field of business process analysis and in the development of high-quality software for the collection, accumulation, storage, and processing of business data.
Our services
I. Development and Implementation
of Corporate Data Warehouses
Designing DWH architecture
Development of the concept, selection of the technology stack (Greenplum, ClickHouse, etc.), logical model.
From 200,000 ₽*
(for 1 project)
Development of ETL/ELT processes
Creating connectors and scripts for collecting, transforming, and loading data.
From 350,000 ₽*
(for 1 project)
Deployment and configuration of DWH
Includes the installation and configuration of the database management system, performance optimization.
From 650,000 ₽*
(for 1 project)
Разработка BI-отчетности
и дашбордов
Creating interactive reports (Power BI, Tableau).
From 100,000 ₽*
(for 1 project)
II. Development and Implementation
ERP Systems
Pre-project survey and technical specifications
Detailed analysis of business processes, development of technical specifications.
From 250,000 ₽*
(for 1 project)
Development of a basic ERP module
For example, a financial accounting or warehouse management module.
From 1,200,000 ₽*
(for 1 project)
Development of the integration gateway
Ensuring the interaction of ERP with external systems (banks, EDO, CRM).
From 450,000 ₽*
(for 1 project)
Implementation and configuration
of the ERP system
Installation, data migration, user training.
From 2,000,000 ₽*
(for 1 project)
Data analysis
Data analysis
(taming chaos)
(taming chaos)
Just a few decades ago, what is commonly referred to as "business data" was painstakingly mined by narrow specialists manually keeping countless records of everything valuable to the business.
Nowadays, it is almost impossible to imagine such a thing: a plethora of digital tools are at the service of entrepreneurs, enabling all records to be kept in electronic form. And what opportunities has the almighty "Internet" opened up for businesses?
However, the dismal statistics of typewriters and dusty magazines never fail to surprise with their consistency: out of 10 businesses, only ONE still survives in the sea of computing technologies!
What's the matter?
What's the matter?
First of all, the new tools are available to all entrepreneurs, which means the accompanying business competition has not gone anywhere.
Secondly, having data at hand does not equal its effective application
What will dry statistics on the viewing of the advertisement you purchased on the site give you if you do not have data on the advertising publications of your competitors?
Nothing!
Will you decide to expand the range of products on the marketplace if you analyze the number of orders and warehouse inventory data by switching from one tab in the browser to another?
Highly unlikely!
Should you use data analytics tools to make accurate business decisions?
Absolutely!
Who will help you understand everything, select or create from scratch effective tools for working with data specifically for you?
DGTICO!
Data analysis
(taming chaos)
Just a few decades ago, what is commonly referred to as "business data" was painstakingly mined by narrow specialists manually keeping countless records of everything valuable to the business.
Nowadays, it is almost impossible to imagine such a thing: a plethora of digital tools are at the service of entrepreneurs, enabling all records to be kept in electronic form. And what opportunities has the almighty "Internet" opened up for businesses?
However, the dismal statistics of typewriters and dusty magazines never fail to surprise with their consistency: out of 10 businesses, only ONE still survives in the sea of computing technologies!
What's the matter?
First of all, the new tools are available to all entrepreneurs, which means the accompanying business competition has not gone anywhere.
Secondly, having data at hand does not equal its effective application
What will dry statistics on the viewing of the advertisement you purchased on the site give you if you do not have data on the advertising publications of your competitors?
Nothing!
Will you decide to expand the range of products on the marketplace if you analyze the number of orders and warehouse inventory data by switching from one tab in the browser to another?
Highly unlikely!
Should you use data analytics tools to make accurate business decisions?
Absolutely!
Who will help you understand everything, select or create from scratch effective tools for working with data specifically for you?
DGTICO!
Are you ready to start working together?
From data to Information!
From data to Information!
The DGTICO team has extensive experience in data analysis and developing optimal business solutions based on the results obtained. We can clearly identify existing problems in the business and determine their nature, build accurate forecasts, and offer the most effective courses of action.
Our team of technical specialists possesses skills both in processing your data and in developing customized software solutions for working with data.
The DGTICO team has extensive experience in data analysis and developing optimal business solutions based on the obtained results. We are capable of clearly identifying existing problems in the business and determining their nature, making accurate forecasts, and offering the most effective courses of action.
Our team of technical specialists possesses skills both in the processing of your data and in the development of customized software solutions for data handling.
Business data visualization
Business data visualization
Are you tired of working with spreadsheets? Do you not see the overall state of your business among the rows of faceless numbers? It's time to turn to DGTICO!
We will develop dashboards with key performance indicators (KPI) that are truly important for decision-making
We will implement visualization in your business processes and train end users
Regaining control of business processes
Regaining control of business processes
The structure of the business has become more complicated and it has become difficult for you to control internal processes? Are you increasingly relying on intuition in making management decisions? We are ready to help!
Our team of analysts, engineers, and developers will create for you a system for collecting, processing, and analyzing business data. Show the data who's boss!
From data to Information!
The DGTICO team has extensive experience in data analysis and developing optimal business solutions based on the results obtained. We are able to clearly identify existing problems in the business and determine their nature, build accurate forecasts, and suggest the most effective courses of action.
Our team of technical specialists possesses skills in both processing your data and developing customized software solutions for working with data.
Business data visualization
Are you tired of working with spreadsheets? Do you not see the overall state of your business among the rows of faceless numbers? It's time to turn to DGTICO!
We will develop dashboards with key performance indicators (KPI) that are truly important for decision-making
We will implement visualization in your business processes and train end users
Regaining control of business processes
The structure of the business has become more complicated and it has become difficult for you to control internal processes? Are you increasingly relying on intuition in making management decisions? We are ready to help!
Our team of analysts, engineers, and developers will create for you a system for collecting, processing, and analyzing business data. Show the data who's boss!
DWH development
DWH development
What is a "corporate data warehouse"?
What is a "corporate data warehouse"?
Corporate data warehouses, or DWH (Data Warehouse - literally a data warehouse, or repository), come to the rescue of the business, speeding up the cycle of data "digestion".
Work DWH can be represented as a pipeline, into which 'cluttered' and disparate data from various information systems are input, and 'beautiful' tables are output.
Data processing occurs in three stages: extraction, transformation, and loading (ETL). It is with the help of ETL that raw data is transformed into information suitable for business analysis.
Data providers
Data providers
Raw data
Raw data
Linked data
Linked data
Analytical data
Analytical data
Dashboards
Dashboards
Data Transformation
Data Transformation
Inside DWH, consolidation, cleansing of data, their preparation for presentation in the form of so-called data marts - analytical tables with a special structure takes place. These tables contain the indicators necessary for creating a "dashboard" - a panel displaying data in an understandable manner
1. Example data
at the entrance to DWH
(not suitable for analytics)
emp_id
emp_id
00001
00001
00002
00002
00003
00003
00004
00004
00005
00005
00006
00006
00007
00007
00008
00008
00009
00009
00010
00010
company_id
company_id
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
position_id
position_id
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
dep_id
dep_id
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
position_name
position_name
Business analyst
Business analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Normalized Table
(optimized for data storage)
Normalized Table
(optimized for data storage)
2. Example data
output from DWH
(suitable for analytics)
Country
Country
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
City
City
Moscow
Moscow
Moscow
Moscow
Moscow
Moscow
Moscow
Moscow
Saratov
Saratov
Saratov
Saratov
Voronezh
Voronezh
Voronezh
Voronezh
Rostov
Rostov
Rostov
Rostov
Salary
Salary
180,000
180,000
250,000
250,000
200,000
200,000
120,000
120,000
160,000
160,000
180,000
180,000
100,000
100,000
50,000
50,000
50,000
50,000
50,000
50,000
Market
Market
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
Position
Position
Business Analyst
Business Analyst
Sales Manager
Sales Manager
Technology
Technology
Recruiter
Recruiter
Business Analyst
Business Analyst
Sales Manager
Sales Manager
Technology
Technology
Manager
Manager
Manager
Manager
Manager
Manager
Denormalized table
(optimized for data analysis).
Denormalized table
(optimized for data analysis).
Data visualization
Data visualization
Processed and organized business data is suitable for analytics, and therefore for a visually appealing presentation in the form of charts and diagrams through specialized software
(examples of business data visualization in Apache Superset)
Development process
When developing a DWH, our team carries out a full range of activities: from analyzing general requirements to conducting training for the customer's personnel
Project Management
Requirements definition
Requirements analysis
Technical architecture
Data extraction and processing
Access to data
Database design and development
Testing
Performance testing
Documentation
Transition to operation
Training
Support
Project Management
Project works
Setting up and development
Commissioning
Development process
When developing a DWH, our team carries out a full range of activities: from analyzing general requirements to conducting training for the customer's personnel
Project Management
Requirements definition
Requirements analysis
Technical architecture
Data extraction and processing
Access to data
Database design and development
Testing
Performance testing
Documentation
Transition to operation
Training
Support
Project Management
Project works
Setting up and development
Commissioning
DWH development
What is a "corporate data warehouse"?
Corporate data warehouses, or DWH (Data Warehouse - literally a data warehouse, or repository), come to the rescue of the business, speeding up the cycle of data "digestion".
Work DWH can be represented as a pipeline, into which 'cluttered' and disparate data from various information systems are input, and 'beautiful' tables are output.
Data processing occurs in three stages: extraction, transformation, and loading (ETL). It is with the help of ETL that raw data is transformed into information suitable for business analysis.
Data providers
Raw data
Linked data
Analytical data
Dashboards
Data Transformation
Inside DWH, consolidation, cleansing of data, their preparation for presentation in the form of so-called data marts - analytical tables with a special structure takes place. These tables contain the indicators necessary for creating a "dashboard" - a panel displaying data in an understandable manner
1. Data example
on input to DWH
(not suitable for analytics)
emp_id
00001
00002
00003
00004
00005
00006
00007
00008
00009
00010
company_id
00001
00001
00001
00001
00001
00001
00001
00001
00001
00001
position_id
3
3
3
3
3
3
3
3
3
3
dep_id
2
2
2
2
2
2
2
2
2
2
position_name
Business analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Business Analyst
Normalized Table
(optimized for data storage)
2. Sample Data
from DWH
(suitable for analytics)
Country
RU
RU
RU
RU
RU
RU
RU
RU
RU
RU
City
Moscow
Moscow
Moscow
Moscow
Saratov
Saratov
Voronezh
Voronezh
Rostov
Rostov
Salary
180,000
250,000
200,000
120,000
160,000
180,000
100,000
50,000
50,000
50,000
Market
2
2
2
2
2
2
2
2
2
2
Position
Business Analyst
Sales Manager
Technology
Recruiter
Business Analyst
Sales Manager
Technology
Manager
Manager
Manager
Denormalized table
(optimized for data analysis).
Data visualization
Processed and organized business data is suitable for analytics, and therefore for a visually appealing presentation in the form of charts and diagrams through specialized software
(examples of business data visualization in Apache Superset)
Development process
When developing a DWH, our team carries out a full range of activities: from analyzing general requirements to conducting training for the customer's personnel
Project Management
Requirements definition
Requirements analysis
Technical architecture
Data extraction and processing
Access to data
Database design and development
Testing
Performance testing
Documentation
Transition to operation
Training
Support
Project Management
Project works
Setting up and development
Commissioning
Applied technologies
Applied technologies
ETL processes - the basis of DWH. They need to be planned, tracked, and restarted in case of failures. For this, you need a tool called "orchestrator".
In our projects, for these purposes, we use an efficient and powerful Open-Source tool Apache Airflow
At all stages of processing, all business data is stored in "databases". To manage this data, extract and ensure its integrity, a specialized tool is needed - a database management system (DBMS)
In our projects for these purposes, we use the Open-Source system - PostgreSQL
At all stages of processing, all business data is stored in "databases". To manage this data, extract and ensure its integrity, a specialized tool is needed - a database management system (DBMS)
In our projects for these purposes, we use the Open-Source system - PostgreSQL
If the task is to accumulate and analyze a huge amount of data, then they need to be brought into the appropriate form. For real-time analytical processing (OLAP) of large volumes of data, they need to be stored in the so-called "column-oriented DB"
In our projects for OLAP, we use the Open-Source system ClickHouse
If the task is to accumulate and analyze a huge amount of data, then they need to be brought into the appropriate form. For real-time analytical processing (OLAP) of large volumes of data, they need to be stored in the so-called "column-oriented DB"
In our projects for OLAP, we use the Open-Source system ClickHouse
Visualization is a very effective tool for conveying complex information to people united by a common goal, but having different competencies. A rising profit line will replace thousands of words
To visualize business data in our projects, we use Open-Source software Apache Superset
Applied technologies
ETL processes - the basis of DWH. They need to be planned, tracked, and restarted in case of failures. For this, you need a tool called "orchestrator".
In our projects, for these purposes, we use an efficient and powerful Open-Source tool Apache Airflow
At all stages of processing, all business data is stored in "databases". To manage this data, extract and ensure its integrity, a specialized tool is needed - a database management system (DBMS)
In our projects for these purposes, we use the Open-Source system - PostgreSQL
If the task is to accumulate and analyze a huge amount of data, then they need to be brought into the appropriate form. For real-time analytical processing (OLAP) of large volumes of data, they need to be stored in the so-called "column-oriented DB"
In our projects for OLAP, we use the Open-Source system ClickHouse
Visualization is a very effective tool for conveying complex information to people united by a common goal, but having different competencies. A rising profit line will replace thousands of words
To visualize business data in our projects, we use Open-Source software Apache Superset
Trust Us
Trust Us
Contact us and start collaborating!
Contact us and start collaborating!
We are ready to answer all your questions. All you need to do is write to us via email.
We are ready to answer all your questions. All you need to do is write to us via email.
+7 (995) 600-34-44
info@dgtico.com
LLC "DIGITIKO"
197198 St. Petersburg, Krasnogo Kursanta St., 31
INN 7814761374
Main OKVED: 62.01
Code of activities in the IT field according to the list approved by the Order of the Ministry of Digital Development of Russia dated 05/11/2023: 1.01
* General Terms of Cooperation
* General Terms of Cooperation
Hourly Rate (T&M): In cases where it is impossible to define a fixed scope of work, an hourly rate applies
from 4500 ₽ depending on the specialist's qualifications.
Discounts: When signing an annual support contract or ordering a comprehensive service (for example, DWH + ERP), a discount of up to 10% is offered.
Hourly rate (T&M): In cases where it is impossible to determine a fixed scope of work, an hourly rate is applied
from 4500 ₽ depending on the specialist's qualifications.
Discounts: When signing an annual contract for support or ordering a comprehensive service (for example, DWH + ERP), a discount of up to 10% is provided.
Contact us and start collaborating!
We are ready to answer all your questions. All you need to do is write to us via email.
+7 (995) 600-34-44
info@dgtico.com
LLC "DIGITIKO"
197198 St. Petersburg, Krasnogo Kursanta St., 31
INN 7814761374
Main OKVED: 62.01
Code of activities in the field of IT according to the list approved by the Order of the Ministry of Digital Development of Russia dated May 11, 2023: 1.01
* General Terms of Cooperation
Hourly Rate (T&M): In cases where it is impossible to define a fixed scope of work, an hourly rate applies
from 4500 ₽ depending on the specialist's qualifications.
Discounts: When signing an annual support contract or ordering a comprehensive service (for example, DWH + ERP), a discount of up to 10% is offered.