• Home
  • Diver BI Group
    • Diver | BI
    • Customer Commendations
    • Videos
    • Case Studies
    • Documents and Brochures
    • Diver BI Group Privacy Policy
  • Articles
    • News
    • Accolades
    • Blog
    • Ask Anthony
  • The Team
    • Key Experts
    • Members
      • Dynamic Business Informatics
      • Envisage
      • Chartwell IT
      • Cloud-Works Solutions Ltd
      • Data Management Business Insight
      • Manitex
      • Equiniti ICS
      • Pharma IT
      • Pinnula
      • Formell
      • IBI
    • Partners
      • Dimensional Insight US
      • Dimensional Insight EU
      • Dimensional Insight Asia
      • DI Panama
      • ID Technology (Brazil)
      • Infotool (Nordic Countries)
      • BIMAXIS – DI France
      • Vision IT
      • KDE Group (Israel)
      • Zight -Partner for Transport
      • 24/7 Uptime
  • Applications
    • Property
      • Property Prices Portal
    • Supply Chain
      • Retail
      • Distributor
      • Wholesale
      • Manufacturing
      • Produce
      • Beverage Alcohol Suppliers
      • Beverage Alcohol Distributors
      • Autoparts
      • Transport
      • Public Transport
      • DI Program Advisor
    • Healthcare
      • Healthcare
      • DI Surgery Advisor
      • DI Physician Performance Advisor
      • Pharma BI Applications of Diver
    • Finance
      • Finance
      • DI GL Advisor
    • Mobile & SaaS
      • Diver BI SaaS
      • SaaS for Sales Gap Analysis
      • BI designed for Tablet
      • DiveTab – Mobile BI
    • Diversity
      • Travel & Tourism
      • Colleges & Universities
      • Waste Management
      • Parking
      • Telecom Brokerage
      • Economic Trends
      • Maps
      • Smart Meters
      • Carbon Emissions Management
  • Workbench
  • Contact
    • Free Consultation with One of Our Experts
    • Add a New Revenue Stream as a Partner

DiverBIGroup

Business Intelligence Experts

Diver BI Group Blog Blog No 6. The 3 Integrated Steps of Business Intelligence. Step 2: Assembly

Blog No 6. The 3 Integrated Steps of Business Intelligence. Step 2: Assembly

3rd April 2014

When you deploy a business intelligence (BI) solution, in order to gain the most meaningful insights, it’s important that you consider some key aspects prior to implementation. In our previous blog post, we outlined the 3 integrated steps that you should undertake when you are deploying.

To quickly recap, they are:

  • Collection: What data sources need to be joined?
  • Assembly: What are the business rules defining how the data fits together?
  • Delivery: Who should access information and how?

We have discussed the important aspects of data collection in a previous post. Now let’s talk about our second step: data assembly.

3-steps-of-business-intelligence-deployment-collection-assembly-delivery-225x300

After you have determined what data is needed, where it is located, and what the parameters are to collect the data, it’s time to assemble it. The first step is to determine the business rules that govern your data. These are the rules that your organization uses to operate, as well as to measure and achieve its goals.

Business rules vary from industry to industry and from organization to organization. They can range from quite simple to very complex. However, no matter how “difficult” they are, it is important to figure them out to ensure that you are measuring the right data in the right way.

Here’s an example of a simple business rule:

Revenue is counted in a specific fiscal quarter based on the date of the transaction.

Here’s an example of how a simple business rule can actually be quite complex:

Revenue is counted in a specific fiscal quarter only if it is shipped (not just booked). The date range for each quarter is set by the finance department and sometimes it does not fall on the exact calendar dates defining the first and last day of the quarter because of holidays, weekends, and other factors.  Dates are measured by the time zone where your corporate headquarters is located (not branch offices).

Let’s imagine your business wants to have all of its goaling (KPIs, quotas, etc.) in your SAP ERP system. In the past, your company stored performance goals in spreadsheets, and then measured progress against those goals by running reports from SAP. It was a manual process to pull the reports each time and enter data into the spreadsheets for comparison.

You may not have realized it, but when you ran reports out of SAP you were manually applying business rules (selecting the proper date range for the report, or running reports for deliveries rather than bookings, etc.). But if you made even a small mistake with your manual application of the business rules then it could cause big problems including FCC violations and incorrect employee compensation. This is one of the many problems with using spreadsheets as your BI solution.

Getting the data assembled appropriately according to all the business rules is critically important. Once you do that, you can look forward to accurate and insightful analysis (which we will cover more in the next blog post regarding delivery). You can easily and accurately compare performance over different time periods, different personnel, different customers, and different products, leading to smarter planning and more accurate forecasting. And along the way you will probably identify process inefficiencies that can be cleaned up. It’s important to have an idea of what you eventually want to compare while you are setting up your assembly routines because it will undoubtedly affect your collection and assembly strategy.

Typically, assembly is not performed once, but rather, it is a regular recurring activity. Once the hard work of business rule definition is finalized, the ongoing collection and assembly routines are automated. A final concern is to understand the frequency of change in your data. Do you want to look at data from yesterday? Or three years ago? Or one hour ago? This question will help you schedule the collection and assembly routines for optimal business usefulness balanced with resource planning for IT systems and networking infrastructure.

Dimensional Insight and Data Assembly

The Extraction, Transformation and Loading (ETL) tool within The Diver Solution (Diver)extracts data from any source system, aggregates and merges it, and applies business rules to create a highly indexed data structure. With our cross-indexing technology, Diver transforms your data stream into a multi-dimensional data Model that is optimized for query, analysis and reporting. Because our Models integrate data from multiple sources, you can compare, for example, data from transactional systems with information in your data warehouse, legacy system, spreadsheets or flat files.

Learn more about how Diver handles data assembly:
The Diver Solution Technical Overview.

Bernard Seban

Bernard Seban is vice president of channel sales at Dimensional Insight. He is responsible for evaluating and recruiting new ISVs, marketing/channel partners, and VARs. Prior to managing Dimensional Insight’s channel sales, Bernard supervised the company’s technical support group and provided the sales organization with pre-sales technical assistance.

Tags: Assembly, BI implementation, Collection, data assembly, Delivery

Articles

  • News
  • Accolades
  • Blog
  • Ask Anthony
  • Diver | BI
  • Customer Commendations
  • Videos
  • Case Studies
  • Documents and Brochures
  • Diver BI Group Privacy Policy

Dynamic Business Informatics Ltd

Distributors of The Diver Solution & Diver Platform, providing business consultancy services, products and applications derived from the Diver Solution & Diver Platform.
14 Mellifont Avenue
Dun Laoghaire
Co. Dublin

+353 1 2302022

10 Kenyon Street
Nenagh
Co Tipperary

+353 67 43309

Contact Us

We would love to hear from you! Please submit your query and we will get in touch with you shortly.

Email addresses are never sold, rented, or shared. See our Privacy Policy.

  • This field is for validation purposes and should be left unchanged.

Accolades

  • Dimensional Insight Named an Overall Leader by Dresner Advisory Services in 2022 Industry Excellence Awards
  • Dresner Wisdom of Crowds 2022 – Best in Class Results
  • Klas 2022 – A Grades for Dimensional Insight
  • Dimensional Insight Earns Top Marks in 2021 Wisdom of Crowds Business Intelligence Market Study
  • Best in Klas 2021

Copyright © 2023 Diver BI Group · Privacy Policy · website by cubecolour

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.


What Are Cookies?


As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or 'break' certain elements of the sites functionality.


For more general information on cookies, please read "What Are Cookies".


How We Use Cookies


We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.


Disabling Cookies


You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies.


The Cookies We Set




  • Account related cookies


    If you create an account with us then we will use cookies for the management of the signup process and general administration. These cookies will usually be deleted when you log out however in some cases they may remain afterwards to remember your site preferences when logged out.




  • Login related cookies


    We use cookies when you are logged in so that we can remember this fact. This prevents you from having to log in every single time you visit a new page. These cookies are typically removed or cleared when you log out to ensure that you can only access restricted features and areas when logged in.




  • Forms related cookies


    When you submit data to through a form such as those found on contact pages or comment forms cookies may be set to remember your user details for future correspondence.




  • Site preferences cookies


    In order to provide you with a great experience on this site we provide the functionality to set your preferences for how this site runs when you use it. In order to remember your preferences we need to set cookies so that this information can be called whenever you interact with a page is affected by your preferences.




Third Party Cookies


In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.




  • This site uses Google Analytics which is one of the most widespread and trusted analytics solution on the web for helping us to understand how you use the site and ways that we can improve your experience. These cookies may track things such as how long you spend on the site and the pages that you visit so we can continue to produce engaging content.


    For more information on Google Analytics cookies, see the official Google Analytics page.




More Information


Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren't sure whether you need or not it's usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.


However if you are still looking for more information then you can contact us through our contact page

Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT