Abstract background

The 32 most important products of a BI team

Weekly reports are no longer enough. A BI team can deliver 32 products and services in four groups: insight into the state of the organization, data quality and services, new opportunities with advanced analytics, and help for business partners, employees and managers.

Key takeaways

  • An intelligent, data-driven organization takes decisions on reliable data that is available to everyone at all times.
  • Seven products give insight: lists and reports, alerts, control queries, ad hoc queries, simple analyses, dashboards and visual data discovery.
  • Seven services keep data and platform in order, from analyses on request to incident management.
  • Ten products open up new opportunities, from data mining and text mining to forecasting and a 360-degree customer view.
  • Eight products and services help people directly: downloads, web services, big data storage, three kinds of training, automatic distribution and quality monitoring.

Weekly reports are no longer enough

An intelligent, data-driven organization is not taken by surprise. It is sensitive, smart, fast and agile. It takes decisions on the basis of reliable data, and that data is available to everyone at all times. In a world in which new competitors lurk every day, markets become saturated and digitalization offers new opportunities but also new challenges, weekly reports are no longer enough. The BI team can deliver many more products than you think. We have listed them: no fewer than 32.

Find the products and services with a BI roadmap

You work towards an intelligent, data-driven organization with a BI roadmap. An important part of it is determining which products and services your BI team has to deliver, given the priorities, goals and future situation of the organization. With those products and services the BI team helps your organization to:

  • gain insight into the core processes, so that it takes better decisions and the best actions;
  • keep data quality in order, because employees must have the most reliable information and genuine KPIs;
  • find new opportunities by pursuing data innovation and optimization, which makes the organization as a whole much more agile;
  • make business partners, employees and managers ever smarter by offering them the right tools.

The 32 products and services in four groups

An overview before the details.

Number

Examples

Insight into the organization

7 products

Reports, alerts, dashboards

Data quality and services

7 services

Analyses on request, data management

Opportunities and optimization

10 products

Data mining, forecasting, customer view

Help for people

8 products and services

Web services, training, distribution

Gain insight into the state of your organization

Knowing instead of thinking: that is the foundation of data-driven decisions. For example knowing how the competition is doing through a competitor analysis, or being aware of the most important parameters of the organization at any moment through a management dashboard. Organizations that take data-driven decisions have better margins and more satisfied customers and employees.

Seven products to gain insight

  1. Lists and reports: standard reports or lists, which users can also make ad hoc. Think of reports on lead times or a list of all courses followed by employees in a quarter.
  2. Alerts: generic alerts, for example when many people report sick on one day, or specific alerts about many calls to customer service within a short time.
  3. Control queries: frequent queries that check whether all database fields have been filled in correctly, such as “select all orders without a product” or “give me all customers without a postcode”.
  4. Ad hoc queries: request any information from the database, for example all customers in one city who bought a certain product in a specific week.
  5. Simple analyses: make analyses quickly with OLAP cubes or let end users do it themselves with self-service BI tools, for example drill-down analyses of revenue or market share.
  6. Dashboards: clear dashboards with KPIs that show managers and employees at a glance whether the organization is still on course, with gauges or traffic lights, simple charts and sometimes notifications.
  7. Visual data discovery: tools with which end users visualize their data themselves, another form of self-service BI. According to research cited by the author, visualized analyses are seen by almost 50 per cent more employees.

Keep your data quality in order

Organizations often fail to get a good and reliable picture of their customers, suppliers, products, employees and competitors. Polluted or incomplete data or a data warehouse of poor quality can be the reason. That is a pity, because these organizations miss crucial insights and opportunities. The Data Warehousing Institute (TDWI) once calculated that the costs of poor data quality amount to six hundred billion dollars a year in the United States alone.

Seven services a BI team can deliver

  1. Analyses on request: the BI team analyzes data for teams, employees and managers in search of answers or more insight.
  2. Information analysis: take stock of the important information users need to take smarter decisions.
  3. Moderating data discovery sessions: show managers and employees which techniques and possibilities exist to get value from data through interactive visualization.
  4. Data acquisition: buy and collect data from other internal or external sources to generate more and newer insights.
  5. Data management: improving data quality and maintaining master data and metadata.
  6. Authorization and information security: make sure that only authorized people see the available information.
  7. Incident management: when the data warehouse or part of the BI platform goes down, users must quickly be able to report and analyze again. That requires specific knowledge of the IT infrastructure, in the IT department or within the BI team.

Find new opportunities and optimize with advanced analytics

First know what is going on and how the game must be played; only then can an organization grow sustainably and quickly. Growth has priority for most CEOs, often even above cost efficiency. But growth is difficult in markets that are becoming ever more saturated through the internet and e-commerce. Companies have to make smart choices before they deploy their marketing budget. Advanced analytics, predictive big data analytics, can help: with the right algorithms, tools and techniques you not only look back at the state of your organization, you also make predictions.

Five predictive analytics products

  1. Data mining: search automatically for patterns and relationships in data sets. Apply data mining to the purchasing behaviour of customers, for example, to discover which products they regularly combine and what the decisive factors are.
  2. Text mining and social analytics: extract hidden information from e-mails, reviews or documents, or scan public social media channels for opinions of buyers or users. Useful for product development.
  3. Speech analytics: automatically analyze stored conversations or recordings of meetings to determine sentiment or recognize patterns in the course of conversations.
  4. Image processing: search image files for information and patterns, for example to find the dents in a car.
  5. Personalized text or HTML: on the basis of advanced analytics you compose personalized content that you present in the customer portal or on the supplier website.

Growth is possible not only by looking for new markets, but also by making better use of existing markets. For example through analyses of a customer, so that the sales employee is sure to offer the right product. Or raise profit through better planning of resources or more precise allocation of budgets.

Five more products for new opportunities and optimization

  1. A 360-degree customer view: give everyone in the organization an integrated picture of your customers by showing information from different sources clearly together.
  2. Performance management and KPIs: optimize and simplify the steering of your organization with performance management.
  3. What-if, forecasting and scenario planning: make calculations to work out scenarios and predict demand for the coming days, weeks or months.
  4. Planning and budgeting: through smart insights you make better use of your existing resources.
  5. Monitoring: with surveys and research the organization keeps its finger on the pulse and collects new data.

Give the right help to business partners, employees and managers

If data is the foundation of decisions, it is important that business partners and employees can reach that data at any moment, not only in fine reports or analyses. A BI team can easily retrieve information from several databases at once, something an employee could spend days on. A BI team also understands data and analyses, including large quantities of data, and can facilitate their storage and access.

Three products with which a BI team helps employees

  1. Downloads and interfaces: offer files that employees request frequently as a download on the intranet, such as a list of the customers with the highest revenue or a file of the devices returned last week.
  2. Web services: let business partners or internal systems request data from the data warehouse.
  3. Big data storage: big data analyses make different demands on storage systems, for example in a data lake.

Three kinds of training a BI team can offer

Employees and managers are also helped with more knowledge. Increasing knowledge within the organization is an essential part of an intelligent, data-driven organization.

  1. Tool training: let users get acquainted with the BI tools the organization has in house and make sure they learn to use them.
  2. Training in data-driven decisions: teach employees to work in a data-driven way, to read data and to take decisions on the basis of data.
  3. Training in data analysis: teach users to analyze data in the right way by handing them tools and methods.

Two more services to support the organization

  1. Automatic distribution of information: distribute daily, weekly or monthly reports, analyses and dashboards to users in an automated and personalized way.
  2. Monitoring and managing the quality of data: by monitoring and managing data quality, the organization always has the right information.

How Diamond Decisions chooses from these 32

No organization needs all 32 at once. Which products and services come first follows from the decisions you want to improve. That is why we start with business modeling and only then determine what the analytics and data platform has to deliver, and which training the decision makers need.

Conclusion

An intelligent, data-driven organization cannot do without the products and services of the BI team. They are the foundation on which employees and managers take crucial decisions. With these 32 variants a BI team can support the organization optimally and in a customer-oriented way. How many of them does your BI team already deliver?

Talk to the author

Daan van BeekDaan van Beek
Diamond Decisions

Discuss your question with Daan

Tell us which decision needs to improve. In a no-obligation conversation we show you where your data delivers the most.

Schedule an introduction →

Step 3 of our approach

Diamond Data Analytics

A data warehouse that starts with your most important decisions and is ready for conversational AI: a working prototype within 24 hours.

Explore Data Analytics →

Frequently asked questions

01

What does a BI team deliver?

Far more than reports. A BI team can deliver 32 products and services: seven for insight (such as dashboards and alerts), seven services for data and platform, ten for new opportunities (such as data mining and forecasting) and eight to help people (such as web services and training).

02

What is the difference between a BI product and a BI service?

A product is something the user works with, such as a report, a dashboard or a model. A service is work the BI team does for the organization, such as analyses on request, data management, security, incident management or training.

03

How do you determine which BI products your organization needs?

With a BI roadmap: start from the priorities and goals of the organization, determine which decisions need better information and choose the products and services that support them. Not every organization needs all 32.

04

Which BI products should a mid-sized company start with?

With the basics: reliable reports, a dashboard with a handful of KPIs, control queries for data quality and a short training in reading and using the figures. Advanced analytics comes later, when a concrete decision calls for it.

Further reading

About the author

Daan van Beek

Daan van Beek

Daan co-founded Diamond Decisions and leads its further growth. He helps organisations translate strategy into day-to-day practice through a human-centred approach to data-driven working, and learns something new in every sector he works in.

About Diamond Decisions

Diamond Decisions helps organizations become better by enabling better decisions. We don’t start with data, dashboards or AI, but with the decision that needs to improve, and work back from there to KPIs, data and technology. We do that in four steps: inspiration and alignment, business modeling, analytics and data platform and data-driven decision makers. That way BI and AI don’t remain an IT project, but deliver value every day.

Schrijf je in voor de Masterclass