Business Intelligence

Business Requirements

We start with a set of interviews with the management team, that lasts no longer than a day or two. We focus on outlining the requirements of each department and linking it to the top-level strategy of the business. During this discovery phase, our team builds the foundation for the KPI library, the Security requirements and Data management. We touch up on the points that drive the business growth, we discuss the management their KPI wish-list and we identify the gaps between what is required by the business leaders and the current technology capabilities of the company.


Our team holds strong expertise in building Data extraction and transformation mechanisms that transport data from various systems into the Data Warehouse. We often work with community editions of Talend and Pentaho to deliver a cost-efficient alternative to the data transformation process.

We have a proven experience with blending the data from most popular social platforms and tracking APIs. But merging and combining all of your data sources, we enable your team to understand the acquisition pipeline, build better attribution models and have a 360 degree view of the enterprise. All of the data is stored in your Data Warehouse allowing you on-demand access whenever you desire.

Data Warehouse

Whether you prefer Oracle, Amazon Redshift, Postgres or MySQL, we have the experience and the competencies to design for you the Data Warehouse that reflects your unique requirements. We often recommend adopting a technology that is complimentary to the current technology stack of the company.

When building the Data Warehouse, we not only address your data requirements, but we also maintain documentation and manuals so your team can continue working with it even if our services are not longer required.

QA and Validation

Our primary mission is to build a resilient BI system that delivers accurate and consistent data all the time. We also understand that factors outside of the business control can impact data accuracy. That is why our systems are designed from the start to notify you of significant deviations from normality.

Most Bi expert will say that it is all about

  • Data Integrity
  • Data Timeliness
  • Data Availability

But there is more to the story. Check out our capabilities on Anomaly Detection for the full story.

Reporting and Data Analysis

Reporting must go beyond simple data delivery. It must focus on Actionable Insight, because few people enjoy making sense out of an overwhelming multitude of reports.

That is why we ask the question WHY? and continue asking it until we get to the very core of the data, giving us an unprecedented understanding of the factors that influence business outcomes.

Our analysts can design reports that offer Drill Down capabilities along the critical paths of business processes, thus allowing your team to get to the bottom of things. We are masters at Tableau, but we have worked with most of the data visualisation tools.

Data Science

Some of our clients like to do more with their data than simply understand their business drivers. They also want to predict and forecast the impact of the decisions on future business results.

Key2Market team has 3 dedicated statisticians whose favorite pastime on weekends is building forecasting models from our customer’s data. Our people are passionate about what they do and we take tremendous pride in the accuracy of the models we build.

  • Customer Segmentation
  • Revenue Forecasting
  • Correlation Analysis
  • Multinomial Regression, Factorial Analysis, Outlier Detection, Statistical Sampling

Data Governance

This particular aspect of our engagement focuses on areas such as:

  • Capacity Management – what to do when the capacity of the BI system needs to be increased to accommodate business growth
  • Configuration Management – how to address the required changes in the design of the Business Intelligence system
  • Change Management – the appropriate steps to be taken when an adjustment needs to be made. For example, what to do and who to notify when a formula for a major KPI needs to be changed?
  • Master Data Management – creating a common point of reference for the enterprise, that unites its diverse data sources

The above comprises just a portion of our offering on Data Governance. Talk to us to find out more.

Security and Stability

Business Intelligence systems are designed with multiple users in line. Some of them prefer to access the Data Warehouse directly via SQL while others interact with it through the Data Visualisation tools.

We build our solutions with every user in mind ensuring that it stays operational regardless of the amount of user that are accessing it.

Security is our primary concern and we design access parameters that fit your enterprise ensuring that groups of users do not have access to data that is not intended for them. We create central repository for credentials as well as audit logs to ensure that users interaction with the BI system can be audited at any time.

Disaster Recovery

As part of any successful Business Intelligence implementation, we must always be prepared for the worst. Part of our strategy focuses on ensuring that you Business Intelligence system can be recovered in case of a crash or adverse situations.

Enabling database backups and restore is only part of the solution. We also focus on building a database-wide roll-back process that allows you to undo the latest changes applied by the Business Intelligence system and roll the Data Warehouse back to the previous state. This is important in the situations when you want to unde the latest ETL/ELT run.