SCADA/HMI


Business intelligence unleashes data traped by ERP

March 2007 SCADA/HMI

Magic has been a source of obsession, fascination, misunderstanding, fear and hatred in the world since the dawn of humankind. From the time of the cave dweller through to the medieval ages and the stories of King Arthur's Merlin; the infamous witch burnings in Salem; the world of fantasy novels like Dungeons and Dragons; and the spectacular antics of David Copperfield and Harry Potter, magic has dazzled, baffled and terrified the world.

The world of business today is dealing with its own little 'magician', one that has baffled everyone for the last few years, and cost organisations great chunks of money in lost revenue or investment on additional solutions. The magician: enterprise resource planning (ERP) systems. The magic: data disappearing into the ether at a rate of knots.

The focus of ERP systems has essentially been about putting in place controls and processes that ensure transactional data is captured accurately, and implementing security and validation checking to ensure the integrity of the data.

Information (data) is the lifeblood of the organisation and ERP systems have been implemented over the past decade to gain control over the flood of data every organisation is faced with, and to provide a means of making that data a valuable asset to the business rather than a space and resource waster.

Having the right information available on a realtime basis enables decision-making that is current and relevant. However, despite the intentions behind the development of ERP systems, they did not live up to the promises made and organisations have been rapidly inputting data into these systems and struggling to get that data back out, or get it out in a format that is user-friendly for non-IT executives.

Now you see it, now you do not

ERP systems are optimised for data capturing, updating, altering and managing transactional information and does not necessarily support the kind of queries required for analytics, planning, modelling or forecasting purposes. What may seem a simple business question like: ‘who are my top 10 customers?’ is a complex question for an ERP system to resolve. Viewing data through ERP systems is parameter-driven, unwieldy and unintuitive.

Furthermore, ERP systems are not typically suited for 'what-if' scenario modelling, which is required for optimal decision-making in the organisation. While an organisation may be able to upload budgets into its ERP system the system does not render itself for performing collaborative budgeting and planning activities.

It is like a magician being able to make someone from the audience disappear and being unable to bring them back. Putting data into a system from which it cannot easily be accessed again can become very costly, with high levels of inefficiencies.

Not all is lost though. Business intelligence (BI) tools are invaluable and complementary to ERP systems as a key enabler to exposing valuable data assets.

Do you know how David Copperfield made the Statue of Liberty disappear a few years ago? He put the audience on a revolving platform! It seems almost too simple to be true. ERP does much the same thing: it moves data beyond the average business user's reach. Business intelligence tools are designed with the business user in mind and allow them to bring things back into view.

It enables business users to make any decisions based on easily accessible, up-to-date, single-version-of-the-truth data, without needing to consume scarce IT resources in trying to access that data. It unlocks the business's data assets and so unlocks the value inherent therein.

Analysts have defined business intelligence as a user-centred process of exploring data, data relationships and trends, thereby helping to improve overall decision-making. This involves an interactive process of accessing data and analysing it to draw conclusions, derive insights and communicate findings, with the purpose of effecting positive change in an organisation.

BI tools put in place to complement the ERP system move the focus from data back to the user. Balancing ERP systems with BI tools opens up a world of trending, forecasting, planning, reporting, modelling, and analysis for business executives. Implementing BI tools in a business performance management (BPM) framework implies that the technology solution is implemented while considering and addressing relevant metrics, methodologies and processes.

Using BI tools to obtain greater benefit from an ERP system, organisations can improve the effectiveness, efficiency and levels of productivity of its business users, and prevent the unnecessary use of costly and scarce technical skills on mundane tasks such as extracting data.

Instead of focusing excessive energy on getting information out, leaving limited time for strategic business activities, the organisation should be concentrating on generating value by adding a new tool to its little magician's bag of tricks.

Intellient is the local distributor of Hyperion software and solutions in southern Africa.

For more information contact Tanya Furniss, Intellient, +27 (0)11 607 8200, [email protected]





Share this article:
Share via emailShare via LinkedInPrint this page

Further reading:

Smart HMI with outstanding features
Vepac Electronics SCADA/HMI
The cMT X-Series from Vepac Electronics offers smart HMI, with a focus on software features for data integration, monitoring, and cloud connectivity.

Read more...
Display panel with brilliant screen and fast response
Vepac Electronics SCADA/HMI
The new HTLM5 WebPanel series from Vepac Electronics impresses with its brilliant display and very fast response during operation.

Read more...
Systems for mobile machines
ifm - South Africa SCADA/HMI
With the new compact ecomatDisplay with a screen diagonal of 11 cm, ifm electronic is setting new standards in the human-machine interface.

Read more...
VEICHI Industrial HMI VI20 series
Conical Technologies SCADA/HMI
The VEICHI industrial HMI VI20 series is a new generation of IOT human machine interfaces with an industrial ABS plastic shell and high reliability. The new model comes with a more practical down-cable approach and is better looking, resulting in a more satisfying interface.

Read more...
Visualisation and automation solutions for marine demonstration
Emerson Automation Solutions SCADA/HMI
Emerson now offers a free template configuration for marine applications, based on its Movicon.NExT HMI/scada system, and its PACSystems edge controllers, industrial panel PCs, and other control and networking products.

Read more...
Valio invests in cheese manufacturing
SCADA/HMI
Finnish food company, Valio is making a significant investment of over €60 million in the cheese production process at its Lapinlahti plant.

Read more...
New industrial control and communication range
RS South Africa SCADA/HMI
RS South Africa has announced RS PRO’s new Industrial Control and Communication range, adding 1250 new products across more than 18 technologies to RS PRO’s existing automation and control portfolio of over 41 000 products.

Read more...
HMI with maximum performance in the smallest of spaces
ifm - South Africa SCADA/HMI
Whenever clear communication, precision and performance in the smallest of spaces are required, the most compact member of ifm’s ecomatDisplay family is the perfect choice. The 11 cm HMI makes no compromises when it comes to human-machine interaction.

Read more...
Real-time data acquisition and reporting
Adroit Technologies SCADA/HMI
As the authorised distributor for Mitsubishi Electric’s Factory Automation, Adroit Technologies provides a range of factory automation products that include scada, PLCs, drives, HMIs and robots. Together, ...

Read more...
Upgrading your control system? Avoid these myths and misconceptions
Iritron SCADA/HMI
An upgraded control system has many benefits. However, the industry is plagued with control system upgrade myths and misconceptions. We explore the most common misconceptions and provide recommendations for mitigation.

Read more...