• Home
    • About DBI
    • Award Winning Diver BI Software
    • Customer Commendations
    • The Team
    • DBI Privacy Policy
  • Articles
    • News
    • Accolades
    • Blog
  • Products
    • Diver | BI
      • Diver Workbench
      • Videos
      • Case Studies
    • Gap 360 Sales Analysis
      • Diver on demand in the Cloud
  • Applications
    • Property
      • Property Prices Ireland
    • Supply Chain
      • Retail
      • Wholesale
      • Distributor
      • Produce
      • Manufacturing
      • Autoparts
      • Transport
      • Beverage Alcohol Suppliers
      • Beverage Alcohol Distributors
      • DI Program Advisor
    • Diversity
      • Waste management
      • Telecom Brokerage
      • Colleges & Universities
      • Economic Trends
      • Maps
      • Travel & Tourism
      • Parking
      • Smart Meters
      • Carbon Emissions Management
    • Healthcare
      • Healthcare
      • Pharma Applications of Diver
      • DI Surgery Advisor
      • DI Physician Performance Advisor
    • Finance
      • Finance
      • DI GL Advisor
    • Mobile
      • DiveTab Mobile BI
  • Partners
    • Dimensional Insight
    • Diver BI Group
      • Envisage
      • Chartwell IT
      • Cloud-works Solutions Ltd
      • Data Management Business Insight
      • Manitex
      • Equiniti ICS
      • Pinnula
      • Formell
      • IBI
    • Zight – Partner for Transport
    • 24/7 Uptime
    • ID Technology (Brazil)
    • Infotool (Nordic Countries)
    • iXias Software – DI France
    • KDE Group (Israel)
  • Services
    • SaaS
    • Training
    • Support
    • Software Development
    • Consultancy
  • Contact

DBI Dynamic
Business
Informatics

Home Articles What’s Latin Got To Do With BI? More Than You Might Think.

What’s Latin Got To Do With BI? More Than You Might Think.

Wednesday 21st January 2015

Are you the kind of person that believes “quidquid Latine dictum sit altum videtur”? You might not know what it means – neither did I, but I had heard this term bandied about every now and again, and when I googled it (I never studied Latin at school), I had to agree – “whatever said in Latin, seems profound”. On the same Wikipedia page I scanned the lists of other Latin sayings. It struck me that part of the reason these terms seem so profound is probably because they are! Nearly all the Latin notable phrases had a ring of wisdom and truth. In fact, Wikipedia tells us that many of these sayings were translated from the more ancient Greek rhetoric, and so the wisdom was passed from one culture to another – and currently we are its modern beneficiaries. A lot of these aphorisms are equally as pertinent today as they were back in Roman times, including for those of us working in BI.

Not that the ancient Romans and Greeks were using computerised BI solutions, but their civilisations produced some of the greatest thinkers the world has ever known, with flashes of acute genius in problem solving abilities, (think Archimedes), and long traditions of philosophy and mathematics (everyone remembers Pythagoras, however good or bad they were at Maths). It’s hardly surprising that we still find their general life observations relevant – not only their discoveries of universal constants.

But maybe there are what I call “BI Constants” too. Three sayings in particular stood out as having a resonance for me, as mottos for our industry. “Ordo ab chao” – “order from chaos”, “ex professo” – “with due competence” (said of the person who perfectly knows his art or science) and “veritate duce progredi” – “advancing with truth leading”.

“Ordo ab chao” – we make the complex simple and incorporate your business rules.

When we start a BI project, as consultants we are often faced with multiple systems, feeding through so many different data sets into the clients’ current reporting. There are usually harassed and frustrated people within the organisation who have to analyse what the data is telling them by manually grabbing bits of data from one place, adding other bits to it piecemeal, then applying different business rules based on their roles. Think of a Sales Manager who is trying to apply different commissions to Sales Team members, according to rules based on date of sale, territory or customer type, for example.

We help them cut through the myriad of mismatched data sets by integrating the relevant sections together, using consistent algorithms, definitions and descriptions. We apply their business rules in an automatic, dynamic transformation phase. We provide mechanisms and security features that allow them to get at the data they need when they need it. They access it in a view that is personally tailored, via whatever interface and device suits them best, be they in the office or on the road.

The endless cycle of data heartache, week on week, month on month, year on year is broken. The complexity and chaos of multiple data sources is replaced by the simplicity and order of a BI solution.

“Ex professo” – we deliver industry and technology expertise.

Any great technology’s weakest link can be the skills of the people using it. A tool in the wrong hands can be dangerous. So we aim to pass on our knowledge and skills to develop our clients’ staff into becoming valuable in-house BI assets.

Our key experts have held management positions in the various industries we work with as consultants, as well as having enormous expertise in the latest BI techniques. This means that we can very quickly get a new BI project off the ground, having the understanding and experience to deliver workable applications within only a few days.

We help new clients solve their pain points initially during a proof of concept phase, then as true professors would do, we nurture our students and pass on as much knowledge as they are capable of taking in, so that they become as capable and imaginative as the technology encourages them to be. This shared expertise allows them to quickly get the best out of their BI investment and develop insights into further areas of the business.

 

Data Integrity

“Veritate duce progredi” – we deliver trustworthy data, to advance your business.

Data governance is really part of Master Data Management, which is only really achieved by a strong, empowered Data Manager or Steward, and a technological means of implementing their agreed designated standards and business process rules.

The best way of creating a Master Data set when there are competing systems with different definitions, is to appoint a human being who is responsible for deciding which version and process is the one that will be adopted and used throughout the company for reporting purposes. This is not a once–off task – it requires ongoing, careful monitoring and forceful implementation.

For instance, there may be many versions of a product file in a retail company – local branch versions, stock system, EPOS system and finance system, so it makes sense to decide on a Master Product file, for example, the one in the central EPOS system. As a business process it may also be agreed that a Product must be entered in to each of those databases with a particular departmental hierarchy.

In this case there are two elements that must be adhered to, but are each open to error. If someone creates a report using product descriptions from say, the stock file, this might not match the hierarchy of the EPOS file. Or if a new product is entered into the EPOS file with the wrong or blank department, then the Master Product file will no longer be accurate. So as long as a company takes on new products, managing the Master files is a task that will always be ongoing.

This is where the technology plays its part. Using a BI platform, one of the advantages is that you can automatically create matches between all the different systems by relating them to the central Master Product file (or Customer File, or Supplier File, etc). You don’t need to go to the massive expense and trouble of migrating all your systems into a new integrated ERP system that leaves little room for flexibility.

The ongoing monitoring by the Data Steward is made simple by the creation of exception reports – so if new products are entered without all the relevant categories, or with the wrong categories, these can immediately be picked up by the Data Steward and corrected in the Master file as well as the other databases.

By providing the BI tools, and helping clients to set up automated Master file and exception routines, together with a Data Steward we create an unshakeable data foundation that allows them to make business-critical decisions based on a single version of the truth.

Non adeo delirant, isti Romani!

Maybe you might want to find a few more aphorisms that relate to you – this is the list I found.

The Truth Stone, Rome.

The Truth Stone, Rome.

The Truth Stone, Rome

Blog post by Debbie Lonsdale, DBI. Email: dlonsdale@dbinform.com
Debbie Lonsdale
Debbie Lonsdale has been working with the Diver Solution as a BI Consultant at Dynamic Business Informatics since 2008. Her previous experience includes computer programming, analytical and technical roles, team management, account management, sales and marketing in a variety of market sectors, including the Travel Industry and Distribution.  She combines this experience as an all round ICT professional in the BI sector.

Debbie Lonsdale, DBI

Contact Debbie

Previous PostNext Post

Latest News from DBI

  • Top Logistics Trends for 2022
  • Take a Look at the DIUC22 Agenda
  • Klas 2022 – A Grades for Dimensional Insight
  • Dimensional Insight Partner Conference – Leiden 2022
  • We’re Hiring!

DBI Accolades

  • 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
  • 5 Takeaways from the 2020 Wisdom of Crowds Report

Dynamic Business Informatics Ltd

UK & Ireland Distributor of The Diver Solution, providing business consultancy services, products and applications derived from the Diver Solution.
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. Please see our Privacy Policy.

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

DBI Blog

5 Business Intelligence and Analytics Trends that Are Shaping 2022

With the worst days of the pandemic (knock on wood) behind us and lockdown orders lifted, the world has finally started to adjust to the “new normal.” Now that organizations have begun to reorient their strategies to reflect the novel circumstances, new trends have begun to emerge in the field of data analytics and business intelligence (BI).More

  • How Hospitals Can Use Data to Go Green
  • All The “Cool Kids” Are Investing In Wine
  • Top Cybersecurity Investments for Healthcare in 2022
  • New Charts in Property Prices Portal

More Blog Posts

Copyright © 2014–2022 DBI · 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