English (United States)

GURU. Good ideas

GURU. Good ideas

GURU. Good ideas

The Guru agency provides a wide range of services in the Digital field. We are engaged in analytics, design and implementation of corporate data warehouses, as well as general Internet marketing.

The Guru agency provides a wide range of services in the Digital field. We are engaged in analytics, design and implementation of corporate data warehouses, as well as general Internet marketing.

The Guru agency provides a wide range of services in the Digital field. We are engaged in analytics, design and implementation of corporate data warehouses, as well as general Internet marketing.

Our Profile

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.

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

Our team

Digital Guru 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.

Digital Guru 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.

Digital Guru 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

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.

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 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

Our services

Development and implementation of corporate data warehouses

Development and implementation of corporate data warehouses

Development and implementation of corporate data warehouses

Our team will develop for you DWH - a powerful hardware and software complex, allowing to collect business data from all significant sources (websites, production warehouses, accounting, etc.), transform them and effectively utilize them for informational and managerial activities

Learn more

Technical support

Technical support

We provide customers with technical support services for open-source platform-based software:

  • products developed/implemented by us;

  • third-party software manufacturers.

We provide customers with technical support services for open-source platform-based software:

  • products developed/deployed by us;

  • third-party software manufacturers.

We provide customers with technical support services for open source platform-based software:

  • products developed/deployed by us;

  • third-party software manufacturers.

Learn more

Web analytics

Web analytics

Current analysis of websites for technical errors and miscalculations in content; monitoring the functioning of your websites dynamically; analysis of your competitors' websites; developing conclusions with clear guidance for action

Learn more

Comprehensive SMM solutions

Comprehensive SMM solutions

Deep analytics of your web resources on 17 points;

  • study of potential customer behavior and adaptation of sites for specific tasks;

  • development of branded pages in social networks;

  • setting up traffic channels

Learn more

Data analysis

Data analysis

Data analysis

(taming chaos)

(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?

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!

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!

Highly unlikely!

Should you use data analytics tools to make accurate business decisions?

Absolutely!

Absolutely!

Who will help you understand everything, select or create from scratch effective tools for working with data specifically for you?

 DIGITAL GURU!

 DIGITAL GURU!

Are you ready to start working together?

Are you ready to start working together?

Are you ready to start working together?

From data to Information!

From data to Information!

From data to Information!

The Digital Guru team has extensive experience in data analysis and developing optimal business solutions based on the obtained results. We are able to clearly identify existing business problems, determine their nature, make accurate forecasts, and offer the most effective guidance for action


Our team of technical specialists possesses skills in both data processing and developing personalized software solutions for working with data

Dealing with Internet sales issues

Dealing with Internet sales issues

Dealing with Internet sales issues

Are you sure your online business is built 'from and to', but sales are not coming? It's time to turn to Digital Guru!

Our team will conduct 'reanimation' of your web resources:

  • We will identify the reasons for the lack of interest in your websites from clients (content, UI/UX solutions, SEO optimization)

  • We will carry out a full range of technical work, as well as help with the development and implementation of SMM strategy

Regaining control of business processes

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!

DWH development

DWH development

DWH development

What is a "corporate data warehouse"?

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

Data providers

Raw data

Raw data

Raw data

Linked data

Linked data

Linked data

Analytical data

Analytical data

Analytical data

Dashboards

Dashboards

Dashboards

Data Transformation

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)

1. Data example
on input to DWH
(not suitable for analytics)

emp_id

emp_id

emp_id

00001

00001

00001

00002

00002

00002

00003

00003

00003

00004

00004

00004

00005

00005

00005

00006

00006

00006

00007

00007

00007

00008

00008

00008

00009

00009

00009

00010

00010

00010

company_id

company_id

company_id

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

00001

position_id

position_id

position_id

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

3

dep_id

dep_id

dep_id

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

position_name

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

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)

2. Example data
output from DWH
(suitable for analytics)

Country

Country

Country

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

RU

City

City

City

Moscow

Moscow

Moscow

Moscow

Moscow

Moscow

Moscow

Moscow

Moscow

Moscow

Moscow

Moscow

Saratov

Saratov

Saratov

Saratov

Saratov

Saratov

Voronezh

Voronezh

Voronezh

Voronezh

Voronezh

Voronezh

Rostov

Rostov

Rostov

Rostov

Rostov

Rostov

Salary

Salary

Salary

180,000

180,000

180,000

250,000

250,000

250,000

200,000

200,000

200,000

120,000

120,000

120,000

160,000

160,000

160,000

180,000

180,000

180,000

100,000

100,000

100,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

50,000

Market

Market

Market

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

Position

Position

Position

Business Analyst

Business Analyst

Business Analyst

Sales Manager

Sales Manager

Sales Manager

Technology

Technology

Technology

Recruiter

Recruiter

Recruiter

Business Analyst

Business Analyst

Business Analyst

Sales Manager

Sales Manager

Sales Manager

Technology

Technology

Technology

Manager

Manager

Manager

Manager

Manager

Manager

Manager

Manager

Manager

Denormalized table

(optimized for data analysis).

Denormalized table

(optimized for data analysis).

Data visualization

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)

(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

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

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

Trust Us

Trust Us

Contact us and start cooperation!

Contact us and start cooperation!

Contact us and start cooperation!

We are ready to answer all your questions. All you need is to fill out this small form

We are ready to answer all your questions. All you need is to fill out this small form

We are ready to answer all your questions. All you need is to fill out this small form

+7 (995) 600-34-44
[email protected]

+7 (995) 600-34-44
[email protected]

OOO 'DIGITAL GURU'
197198 St. Petersburg, Krasnogo Kursanta Street, bldg. 31
Taxpayer Identification Number (INN) 7814761374

DIGITAL GURU LLS
197198 St. Petersburg, Krasnogo Kursanta Street, bldg. 31
Taxpayer Identification Number (INN) 7814761374