/// Key performance indicators (KPIs) are at the very core of each analytics solution. It is very common to have a high number of variations of KPIs required to be implemented in such a tool, e.g. variations based on time (current year, previous year, YTD etc.). Further, KPIs are often interlinked and build on each other in KPI trees. The DRY-principle (don’t-repeat-yourself) is a method to make sure this big number of defined KPIs in a solution is properly managed and organized. Specifically, calculation logics are only ever defined in one place. Variations of KPIs and dependable KPIs always reference back to this original definition and nothing is ever repeated.

/// Managing and optimizing data quality is a process of continuous improvement and in many cases strongly driven by an organization's culture. Adequate quality of relevant data is crucial for data-driven decision making processes. A business intelligence (BI) solution can make quality issues transparent and help to monitor and track the improvement over time. A BI-tool should however not be used to fix problems for various reasons. This article gives an overview and advice on dealing with data quality.

/// The first sprint in a BI & analytics project is foundational for both the analytics solution as well as how the project is organized going forward. Structuring and managing a BI project in sprints is not mandatory, but can help to organize work in an effective way. In this article I summarize based on my experience how a first sprint could look like in order to have the best possible start in your BI & analytics journey.

/// Choosing the right BI & Analytics software tool is an important decision for any organization embarking on the journey to become (more) data-driven. This article summarizes the 5 most important criteria to consider in the tool selection process.

/// In this article, 5 important risks to manage in a BI-project are summarized. These risks are about project scope & planning, people, organization and finally the evergreen data quality management. They can be successfully handled with diligence and the right tools.

/// Key performance indicators are the core of each BI solution and should therefore be defined clearly. A simple template to list KPI definitions can be a valuable and central tool in the agile BI project for the entire team including the customer.