BI Basics

This chapter will provide basic information about general terms, concepts and architectures. It is very important to understand the difference between certain topics in order to understand the next blog entries. The chapter will be focused on actual architectures and the components within. I will always add further definitions of terms if I think they are not self-explaining.

Part 08: KPI catalogue

What are measures, dimensions and KPIs? In Business Intelligence environments, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made. Simple examples are revenue in a currency or amount of orders. In this context, dimensions are possible ways to split the measures in business areas. Typical examples are […]

Part 01: Definitions, Concepts, Architectures

I started this blog to write about my daily, weekly or monthly impressions of my actual job. But what I have learned in the last years was that the basics of business intelligence are not in everyones mind. A lot of guys and girls are confused if you talk about Business Intelligence (BI), data warehousing (DWH) […]

PART 02: Business Intelligence Strategy

I started this blog to write about my daily, weekly or monthly impressions of my actual job. But what I have learned in the last days and weeks was that the basics of business intelligence are not in everyones mind. A lot of guys and girls are confused if you talk about Business Intelligence (BI), […]

Part 03: Core Element Business

„Business Intelligence business focuses on all clear usage scenarios within the companies departments which promise the profit of a competitive advantage“ That means that Business Intelligence is not only an Financial department- or IT-driven topic in companies. Most of the time these two departments are responsible for the start of BI, but they can affect […]

Part 07: Information visualization

Next step after understanding the business needs is that the information representation is easy and intuitive to understand and to monitor the goals. There are certain gurus out there who developed specific concepts in order to visualize data in a correct way. To famous guys are Stephen Few and Rolf Hichert. First is known in […]

Part 04: Core element technology

„Business Intelligence Technology includes software, hardware and middleware as well as instructions for the usage of it.“ This means that the element technology focuses on business intelligence software and hardware and gives a clear statement which technology and how it is used in the company. Furthermore, there has to be a tool strategy, a construction […]

Part 05: Core element organization

„Business Intelligence Organization includes all kind of schedules, processes and regulations for people who are part of the business intelligence initiative“ The outcome of the BI Organization is in general a Business Intelligence Competence Center, a BI Governance and rules of agility. Business Intelligence Competence Center as the institution for data As BI becomes increasingly […]

Part 06: Business: Information Needs

 Information Needs of the Business have to be focused Therefore, it is really, really important to analyze the information needs based on the business processes. Questions like “which goal do you want to achive” as well as “which process to you want to analyze” should be asked at the beginning. Next, it is necessary to […]

Part 09: Business Intelligence Architectures

For some people, between Business Intelligence (BI) and Data Warehousing (DWH) is huge difference and for others they are quite the same. In my humble opinion it depends on the educational background and the experience of each person. For me, it is important to bring a defintion before talking in depth about the characteristics of […]

Part 10: Application classes

The chapters 2 to 6 presented Business Intelligence architecture scenarios. You could see the different layers, when they are used when not. What was always the last layer in these scenarios, was the application layer. This layer is the access point for end user or business users in order to access the data and generating […]

Part 11: Devices

The „last mile“ of business intelligence describes the access of users to business intelligence (BI) content. The general goal should be to improve the accessibility of BI content, so that the satisfaction rises. In the last years Mobile Business Intelligence (Mobile BI) got a so called “hot topic” and “trend” for BI. It describes the […]