A BI SYSTEM: HOW IS IT IMPLEMENTED?

How long does it take to develop one? What is the process like? What are the stages of a BI system implementation?

First of all, you should understand that the beautiful visualizations account for 20% of the volume of work. This is the top of the iceberg.

Let’s get an understanding of the process of turning Excel tables into comprehensible and nice-looking dashboards containing the data on your business or subdivision.

STAGE 1
'DESIGNING THE BI ARCHITECTURE'

  1. Exploring the data existing in your IT systems
  2. Making a list of the indicators and dashboards 
  3. Sketching the main dashboards and IT structure
  4. Preparing the plan for the BI system implementation project and the cost estimate.
    The Executive portal was among the first to create a good article on this subject.

Time frame: 4 weeks

STAGE 2
'IMPORTING THE DATA FROM IT SYSTEMS'

  1. Setting up your systems 
  2. Creating the storage structure in BI 
  3. Developing the modules for data import to BI for your data sources 
  4. Importing data from different sources
  5. Formalizing the existing accounting policy in the form of algorithms 
  6. Setting up automatic data updates
  7. Configuring a productive server for the analytics system 
  8. Preparing reconciliation dashboards 
  9. Performing data reconciliation together with your staff 
  10. Making the necessary adjustments of the data synchronization modules.

Read more about 1C integration: 1С INTEGRATION AND POWER BI

Read more about the Power BI advantages: 1C VS. BI: 5 DIFFERENCES

Time frame: 1-2 months

STAGE 3
'VISUALIZATION AND DASHBOARDS'

  1. Discussing the detailed logic of indicator and metric calculation 
  2. Implementing the specified calculation algorithms 
  3. Designing the visualizations
  4. Implementing the dashboard layout: the 20% that you can see 
  5. Configuring the dashboards’ interactive elements 
  6. Doing the checks, demonstrating it all to the client, making the adjustments 
  7. Teaching the client’s personnel to use the dashboards to derive economic benefits.

Time frame: 1-2 months

STAGE 4
'MAINTENANCE AND ANY OTHER WISHED YOU HAVE AFTER THE BI SYSTEM IS IMPLEMENTED'

  1. Editing the colors and the visual elements 
  2. Adding filters and popup instructions
  3. Setting up extra accesses
  4. Answering the questions that arise in the process of working.

Support packages starting at 10 hours per months.

BUT THE MAIN POINT OF THE ANALYTICS IS
PROFIT GROWTH

Our dashboards give you a chance to control the revenue, cost price, margin, gross profiе and 47 other indicators on a daily basis. No need to wait for a monthly report.

Consistent control results in  profit growth and business expansion.

GET COMPANY MANAGEMENT DASHBOARD

Cobit Solutions

More articles and cases

CASE: WHY YOU CAN’T RELY ON GROSS INCOME AS AN INDICATOR

22 Jan 2022

CASE: WHY YOU CAN’T RELY ON GROSS INCOME AS AN INDICATOR

A company’s profit isn’t proportionate to its income. Is this obvious? Not necessarily so. Let me share a story from my experience with a cu ...

Read More
A BI SYSTEM ≠ IT: WHY IS IT SO?

22 Jan 2022

A BI SYSTEM ≠ IT: WHY IS IT SO?

The development of interactive dashboards is sometimes viewed as a purely IT product. This is a misconception. When developing a BI system f ...

Read More
Case. Find a BI solution for a Fashion Retail company

09 Mar 2022

Case. Find a BI solution for a Fashion Retail company

The purpose of implementing Power BI in retail: Fix the malfunctions in the current analytics software. Refine the existing add-on that ext ...

Read More

KEY FIGURES OF THE COMPANY

457

dashboards we created in 2021

78

years of experience in IT among employees

10

person of employees in the company

215K

USD saved by our client within a month after BI project
start