Business Intelligence architecture

Photo ir. Rick Van der Linden
Author: ir. Rick Van der Linden
Senior BI Architect

As a manager, project manager or BI consultant, you naturally want to work on a solid Business Intelligence architecture. You know it has advantages in terms of scalability, speed, data quality and flexibility. But you also hear stories that many data warehouse projects fail. They end up not delivering the desired results. But you also read the success stories. In our view, a BI architecture should perfectly match the desired analyses and cross-sections to be made, the BI maturity and data literacy of the employees.

Relevant BI architecture issues

A solid Business Intelligence architecture provides many advantages when it comes to scalability, speed, data quality, and flexibility. But there are a lot of stories about data warehouse projects failing and not delivering the desired results. How should you approach this issue, and what are the relevant questions?

  • Which architecture does an intelligent organization use, and how can you learn from that?
  • BI architecture consists of layers. When and why do you need which components? What’s the added value?
  • How to deal with Big Data and unstructured data. How do these different forms of data fit within your business intelligence architecture?
  • How do the various Business Analytics tools and data integration tools fit within the architecture?
  • Who should you involve when setting up BI architecture?

If you have one or more of these questions, Passionned Group’s BI consultants can help answer all your architecture-related questions and make forward progress towards becoming a more intelligent organization, from implementation to interim management.

The different components of BI architecture

A solid business intelligence architecture consists of different layers and components. These components should run in sync with the processes of the intelligent organization:

  1. Registering data in internal systems, databases, or with sensors.
  2. Collecting data, cleansing it, combining it, and aggregating it in a data warehouse or a data lake.
  3. Analyzing using Business Intelligence tools and analytical models.
  4. Distribution of insights, reports, dashboards, and analyses using portals and mobile BI.
  5. Reaction by the organization’s directors: the decision-making process.

Business Intelligence Architecture

Metadata supports and guides the overall BI process, so that the transition from one step in the process to the next takes place seamlessly.

The advantages of a Business Intelligence architecture

✓ Cohesion between the various components for a better overview.
✓ High scalability in terms of data volume and user growth.
✓ Flexible reporting and analyzing, using BI to its full potential.
✓ Easier to manage thanks to its clear structure: satisfied users.
✓ Higher data quality and guaranteed response times.

Business Intelligence Training

“A” is the most important letter

The letter “A” in the word “architecture” is the most important one. It stands for acceptance by the users and stakeholders that have to work with it. These are the BI developers, BI consultants, data scientists, data analysts, and end users. The smileys in the right side of the diagram represent satisfied users. That’s what a Business Intelligence architecture should stand for. Unfortunately, in practice, it doesn’t always work out that way.

Structure follows function

Like a house containing different rooms that each have their own purpose, each component of BI architecture has its own purpose. When the goal is unclear or unknown, it’s pointless to design or build an architecture. When you don’t know what queries the architecture is designed to answer, you can’t design the architecture to answer them, after all. This is one of the most common hurdles. That’s why it’s important to clarify which KPIs, insights, and analytical models you want to work with first, and which functions your BI tools should perform.

The business intelligence architecture and maturity

You shouldn’t put the cart before the horse, as they say. Unfortunately, this still happens on a large scale: many organizations set up a very mature and complex BI architecture, while the maturity of the business intelligence and its users is very low. This can only spell doom and financial disaster. Our experience tells us that a business intelligence architecture should be in lock-step with the maturity of an organization’s business intelligence, for the following reasons:

  • You’re much more likely to be successful using business intelligence.
  • No wasted money and considerably less risk.
  • In case of success you have to consider revising your BI architecture every now and then.

Customer testimonial

I’m especially impressed by three aspects of Passionned Group:

  • Demonstrable expertise based on several published books
  • Thought leadership on the topic of Intelligent Organizations
  • A clear focus on expertise

Roeland de Graaff
manager at Vestia

Don’t buy into a data warehouse prematurely

Just because BI consultants and BI architects are convinced of the value of BI doesn’t mean that your users are too, or that they have the skills to extract value from data. So don’t get sold on a data warehouse or data vault prematurely. It’s self-evident that a mature BI organization like Albert Heijn, which was voted smartest organization in the Netherlands, needs a huge and mature data warehouse, and that’s fully justified. They make a lot of money from it and it increases their customer satisfaction. If you pull the plug from their data warehouse, Albert Heijn would effectively drop down dead next week.

Principles that dictate BI architecture

The goal of BI architecture isn’t just to divide everything clearly. Equally important is establishing principles that developers, data suppliers, and users should keep to. This is important in order to prevent discussions and differences of opinion about the exact design of the data warehouse or a dashboard. If you notice these discussions in your own BI team, it may be time to sit down and hash it out.

A good number of basic principles

The architecture of a Business Intelligence system is guided by a good number of basic principles that specifically apply to Business Intelligence systems. A basic umbrella principle here is the well-known phenomenon of ‘structure follows function’: the indicators that are derived from either the business processes or the strategy as well as additional management information largely determine the architectural structure of the Business Intelligence system. In other words: the content of the system determines its architecture and structure.

The principles govern the BI architecture

The basic principles reign over the Business Intelligence system’s architecture. When we conscientiously apply these principles, we are provided with a clear, easily comprehensible architecture and with a Business Intelligence system that is scalable and easy to maintain.

The 7 basic principles of a proper Business Intelligence architecture

The basic principles relate to the following aspects:

  1. 7 principles for Business Intelligence architectureSymmetry: the architecture reflects the business processes. This principle helps in creating an overall picture of the business processes and a single source of the truth. It also ensures that the Business Intelligence system seamlessly attunes with both the information needs and the challenges of the business operations.
  2. Granularity: data are submitted as detailed as possible and display the exact same granularity as the data in the source system(s). This principle increases the testability and verifiability of data and information in reports. It also allows for detailed reports because no information is lost. Information will be lost if concentrated rather than detailed data are submitted (at a higher level).
  3. Synchronisation: the refresh rate of data in both the data warehouse and reports should coincide with the regularity and frequency of events in the relevant business processes. This prevents the organization from missing out on important events.
  4. Maintainability and scalability: the calculations, the intelligence and the logic behind KPI’s, measured values and dimensions are preferably recorded in one and the same place – thus also on one single platform. This greatly improves maintainability and scalability.
  5. Hiding complexity for end users: end users should be able to directly select indicators and dimensions for use in reports or interactive analysis. This makes quick and easy reporting possible and it protects the organization from a situation in which each employee needs to (or can) assemble his own indicators.
  6. Flexibility: when we fill the Business Intelligence system, we usually include relevant surrounding and adjacent data from the source systems so that users can create as many meaningful combinations of indicators and dimensions as possible. This increases both the power and possibilities of the analysis function within the organization.
  7. Not depending on tools: an architect constructing a building needs to take into account which materials are available. Nonetheless, an architecture should where possible be separate (independent) from the tools used – or to be used (e.g. ETL and Business Intelligence tools).

Applying the principles is now possible

The current state of technology in the fields of data warehouses, Business Intelligence tools, architecture, metadata, databases, portals and so on, enables us to actually apply the above-mentioned principles. Reviewing and applying basic principles in advance provides more clarity in managing and implementing the project so that the ones who design and develop the Business Intelligence system can work much more independently.

Simply refer to the principles

After all, the basic principles guide the architecture, which frees designers from having to consult other project members or users with each (small) extension. For example: if users want to supply data on an aggregated level, we can simply refer them to the basic principles – the granularity principle in this specific case – and deliver the data at the lowest level of detail in consultation with the users.

Key contributors of a sustainable BI system

Finally, the above-mentioned basic principles may prevent the organization from compromising on aspects of Business Intelligence that have a major impact on the organization’s performance. The 7 basic principles are key contributors to a sustainable and lasting Business Intelligence system.

Get started on a solid business intelligence architecture

Our Business Intelligence architects and BI advisors are eager to help you. With their knowledge, experience, and awareness of the latest BI trends, they will help you build out a solid business intelligence architecture. Contact us for more information or an appointment.

About Passionned Group

Logo of Passionned Group, expert in BI architecturePassionned Group is a leading analyst and consultancy firm specialized in Business Analytics and Business Intelligence. Our passionate advisors assist many organizations, large and small, in selecting the best Business Analytics Software and applications. Every two years we organize the election of the smartest company in the Netherlands.

contact us

Our BI architects

Photo Rick Van der Linden - Senior BI Architectir. RICK VAN DER LINDENSenior BI Architect
Photo Daan van Beek - Author of Data Science for Decision Makers & Data Professionals'DAAN VAN BEEK MScAuthor of Data Science for Decision Makers & Data Professionals'
Photo Dick Pouw - Chief Information OfficerDICK POUW MBAChief Information Officer

You May Also Like

Featured image Business Intelligence
Business Intelligence
Featured image Data warehousing
Data warehousing
Featured image The pros and cons of a Data Vault
The pros and cons of a Data Vault

A selection of our customers

Become a customer with us now

Do you also want to become a customer of ours? We are happy to help you with data-driven working or other things that will make you smarter.

Photo Rick Van der Linden - Senior BI Architectir. RICK VAN DER LINDENSenior BI Architect

Contact me directly

Fact sheet

___
customers
___
training courses
___
people trained
4.7
stars customer satisfaction
___
consultants & teachers
3
offices
19
years of experience