THE RIGHT SOLUTIONS FOR THE RIGHT PROBLEMS

Get the most out of your data

Business Intelligence

Roadmap Business Intelligence

What makes a successfull Business Intelligence plan?

OKR’s

How do Objectives and Key results work? What goal do you pursue as organisation?
Are the objectives we set measureable and realistic?

BI Workshop or Training

We like to help you get better at Self-Service BI threw training in SQL, POWER BI, SSRS,SSIS or Excel

Freestanding Applications

Do you only want one freestanding application instead of the whole BI route?

Skewed knowledge

We see that many workers within organisations learn excel or SQL themselves and come a long way like that.
Lots of times the organisations still get into trouble and only then there will be a BI expert. This could be prevented if there was one from the start.

Second Opinion

Did your company try to set up a datawarehouse, but it doesnt work quite yet? Then we advice you to contact us to make an appointment.

To us, a business intelligence (BI) process contains the following steps:

  1. Determine the current maturity of the business intelligence of your organisation, according the Business Intelligence Maturity Model of Gartner
  2. Determine the goals of the whole organisation (from management to frontline employees)
  3. Define OKRs that fit the chosen organisational goals
  4. Implementation
  5. Evaluation

OKRs are Objectives and Key Results. In the next paragraph you will learn more about this.

Many managers are drowning in the amount of reports and KPIs available. Most times, a manager cannot answer questions like: ‘What would you change when a certain KPI decreases with 5%’. Financial departments spend a lot of time on these reports, but they don’t have enough time for actual analysis of these figures. Moreover, we have seen that many reports are barely or not at all used. This is a waste of time and money. OKRs are a way to focus on what is really important within your business. It lowers the pressure to report everything and it brings focus into your reporting. That is why we believe in OKRs and we are in good company: renowned companies like Intel, Google, Linkedin and Twitter use it as well.


gartner business intelligence maturity model

How do OKRs work?

Each team defines their own OKRs which are based on a clear mission statement. We recommend a maximum of 3 in order to keep focused. OKRs are dynamic, which means that it is possible to change and adapt them. An OKR consists of:

An objective: a qualitatively defined goal for your team to get enthusiastic about. Teams formulate these goals in their own words and in a way that it is possible to reach these goals within a few months. Objectives should not be dependent on other teams within the organisation.

A key result: a measurable (quantitative) value , that shows whether the objective is reached. This can be a revenue target or a customer appreciation score. The key result should be challenging. They can be adjusted monthly. The companies mentioned above are satisfied when they have reached 2 out of 3 OKRs.

Customized dashboards

To implement OKRs efficiently, you need a custom made dashboard for every team. This dashboard displays information related to the 3 OKRs.

The visualisation of the OKRs means that teams are really working with the OKRs. They feel responsible to reach their goals. Moreover, the plan and control cycle are easier with these dashboards.

I need more reports

To perform your daily work you sometimes need more than the information presented in the OKR dashboards. We think this information belongs to the ‘operational intelligence’. Things like profit- and loss accounts, accounts payables, etc. These kind of dasboards belong and should be available within your operational systems (and not in the OKR dasboards).

BI Workshop

A business intelligence workshop is a convenient way to get to work hands-on with a small group of people. You can think of the following possible subjects:

  • Selection of the right BI supplier
  • Collect requirements of different end users
  • Discuss technical challenges with your BI team
  • Train your end users to build reports themselves (self service BI)
  • Improve communication between end users and your BI team

Do you recognize one of these issues in your company, or do you have any other issue? Please do not hesitate to contact us so we can plan a workshop.

BI Training

We are glad to see that it is increasingly common that some customers have trained themselves in Excel and SQL. With these self-learned skills, they manage well enough, but there are also risks involved:

Skewed knowledge

In a company some techniques are often used, while others are not used at all. Excel is typically a tool in which many options are available, but specific knowledge is needed to work optimally with it.

There is more than one solution

If you fly via Tokyo, it is still possible to end up in Rome. Of course this is not efficient. In BI we encounter cases in which solutions seems be working well, until the system suddenly slows down or changes have to be made. When an expert is called in in time, a lot of the issues can be dealt with beforehand.

If you recognise your company in the above mentioned risks, we invite you to contact us so we can solve them with a training. A training is possible in the following subjects:

  • SQL training: learning to write working and efficient SQL statements
  • Power BI training: Power BI for managers or Power BI for report builders
  • Reporting Services training: create and maintain reports with SQL Server Reporting Services (SSRS)
  • Integration Services training: create and maintain data integration packages with SQL Server Integration Services (SSIS)
  • Analysis Services training: create and maintain cubes with SQL Server Analysis Services (SSAS)
  • Excel training: data analysis in Excel (also possible with Analysis Services cubes)
  • From Excel to BI: we can help you with the transfer from experienced Excel user to BI specialist

Some trainings are part of the standard implementation of BI solutions, but they can be booked separately as well. We believe that one-on-one or small groups are giving the best results. For (bigger) classroom trainings we work together with Sorsebridge BI-opleidingen.

Standalone applications

Our ControlTool

This application executes daily some preprogrammed checks and reports the deviations to the responsible employee(s). This person then is also responsible for dealing with the issue.

Disco Process Mining

Process mining is a way to extract data from the logging of your applications and view them as a process. In this way you will rapidly see whether strange sequences of states appear in your loggings. Process mining works well as a periodical analysis. Based on the information from process mining you can create checks in a Control Tool.

Microsoft SQL Server Data Quality Services (DQS)

This is a feature of the Microsoft SQL Server platform and its functionality is comparable to the ControlTool. To obtain the feature you will need a relatively expensive licence of Enterprise edition. Because many companies do not need this licence, they choose ControlTool.

Microsoft SQL Server Master Data Services (MDS)

This is a different feature of Microsoft SQL Server. It can manage masterdata like products and customers for you. This feature is for example convenient for combining customer data stored in different applications. Every application can ‘ask’ MDS whether the customer already exists. If so, the application receives the customer id, if not it will create a new customer record (and id). Problems with double customer records or inconsistent information about customers belongs to the past.

Second Opinion

Did your company make the first steps towards business intelligence? Did you try to build a datawarehouse, but are there still issues? Some departments find too many mistakes in the data, while others ask too many ad hoc questions which overburdens the business intelligence employee(s). In other words, the implementation is not successful (yet). In this case it is advised to contact us and let us help. With years of experience in business intelligence, we know what factors help you succeed and how to make a difference. Because of our experience we can advise you how to finish your implementation

Interested?
Request a free demo!

We will reach out to you within one day!

Request Demo

Contact

Interested in one of our products or our company? Fill in the following form or send us an email info@dynamicinfo.nl. We will reach out to you within one day!

Dynamic Info

Building ’Koningshof’
Schipluidenlaan 4
1062 HE Amsterdam

Tel. +31 (0) 203 032 470
Fax. +31 (0) 848 388 100
E-mail. info@dynamicinfo.nl

Chamber of Commerce: 65061284
VAT-number: NL855965265B01