Skip to main content

Invest in information: Selecting the ideal business intelligence & analytics system

21st January 2020

Submitted by:

Andrew Warmington

Mike Beason, EMEA distribution, director of automated data analytics supplier Anvizent, explores a series of factors to consider in order to make an informed decision when selecting an analytics system

The market is flooded with business intelligence and analytic systems, making the task of selecting the right one hard to navigate. While the right one will help businesses to use their data to drive competitive advantage, spending a company’s budget on the wrong business intelligence system can end up adversely impacting staff and production efficiency, ultimately harming the bottom line. Factors to be considered when investing in analytics include: savings on cost and time, flexibility and ease of use and, finally, looking to the future and exploring how artificial intelligence (AI) will shape business intelligence and analytics to provide the end user with predictive and prescriptive data.

Cutting down on costs

Systems that at first present themselves as low-cost often come with hidden fees. There is more to the cost than the initial software or per-user licence costs. Decision makers must consider the total cost of ownership (TCO), taking into consideration hardware, consulting, implementation, programming and ongoing maintenance, which many vendors do not disclose upfront.

Selecting a fully integrated end-to-end system, including software licensing, hardware, setup, initial implementation and maintenance, helps to avoid any hidden costs and ensure a lower TCO. By opting for a pre-built system, companies will save money by not having to employ a specialist or carry out extensive training to install the software and keep it running. This also eliminates any extra resourcing costs as it should only require configuration and not customisation, while still being flexible enough to grow with any business.

Spending time wisely

Time is a significant component to any business decision. An effective analytics system should be there to make the end users life easier and help save them time, allowing them to focus on other parts of their job role.

Businesses must consider what they want to achieve with their analytics system. More often than not, this will be a platform that offers systems straight out of the box, with the ability to extract data from all areas of a company, process and evaluate it, otherwise known as extract, transform, load (ETL).

Finding, cleansing and organising data can be a massive drain on resources, whereas selecting a system that can automate the ETL process will ensure faster reporting with fewer errors, and provide greater agility and business insight. Many of the products in the current market present themselves as end-to-end platforms when in reality they are visualisation and dashboarding tools.

Decision-makers must differentiate between the two as selecting a true end-to-end platform offers all the tools in one package and eliminates the complexity and risk that comes with integrating and managing multiple tools. This gives businesses access to their consolidated data immediately to start analysing performance using powerful, interactive dashboards.

Another way to save significant time is to opt for a system that offers real-time analytics. This allows users to create fully accurate strategies and business opportunities without any delays. This is vital for chemical manufacturers dealing with large quantity orders, who want to keep their competitive edge.

Ideally, accurate data should be displayed, in real-time, on screens in the office or at any remote location, with no impact on the operational systems it is drawing the data from. Vendors should be open to speaking about real-time connectivity and the impact on the source systems as well as the systems capabilities for storing expanding data sets quickly, easily and at no extra cost.

Finding flexibility

With so much to consider, decision-makers can often overlook one of the most vital considerations: how easy is the software to use? Bringing a platform into a business that is over-complicated, fragmented and requires coding, can end up becoming a hindrance rather than a help. This is especially true for SMEs with limited budgets.

A system that is easy to use and requires fewer IT resources will not only save money but ensure faster reporting times – allowing the workforce to focus on other business priorities, such as budget efficiencies.

The chosen system should already be pre-integrated with popular ERP, MRP, CRM, procurement, HR and payroll packages. It should be straightforward and quick to add-on custom extensions to the software when required, as well as the ability to incorporate other systems or flat data into its data set, providing a 360-degree view of the business.

Acquiring business data is not a straightforward process – it can be found in many elements of a company. From CRM and shopfloor systems to external systems or data on the internet, the more data a business can collect and process, the more successful its end strategy will be. This is why having a flexible, easy-to-use system is such a valuable asset.

Without bringing the data together, it becomes impossible to get a truly integrated and comprehensive view of the business. End-to-end systems have built-in automated ETL, enabling users to start applying analytics to their data almost immediately. Flexibility and ease of use should also apply to how end users access data.

Business is no longer conducted within four walls and the way that companies access data should be as simple as accessing any other information in the modern world. Sales teams often work remotely and their ability to access data could be the difference between winning or losing a sale. In order to gain full flexibility of a system, businesses should select one that is accessible at any time, location and from any device.

Self-service systems offer the end user an easy to navigate system. However, many that claim to be self-service only offer standardised reports. For a system to be truly self-service, it should offer users ad hoc dashboards and the ability to customise their own reports. Employees are more likely to incorporate an easy-to-use tool in their daily activities and businesses will begin to see the benefits.

If the tool is complicated and time-consuming to implement, it may only be accessible to one or two employees who are skilled in coding. This isolates the rest of the workforce and would make the tool harder to implement across the board.

Outlook

It is clear that AI will be at the core of business intelligence. We are already beginning to see now how data is changing from descriptive to predictive. It is no longer enough to draw on data to evaluate past behaviours and patterns. AI gathers insights from complex data sets and is able not only point to real time behaviours, but also to predict and recommend the next action, all with little to no work from the user. Businesses that select a system without AI capabilities will eventually find themselves playing catch-up with their competitors.

Contact:

Mike Beason

Anvizent

+44 7733 224342

[email protected]

www.anvizent.com

Feature article – Saltigo rides out the cycle

Market and sustainability trends are positive drivers for Saltigo, despite the agro downturn. Andrew Warmington met up with the new CEO at Chemspec Europe

Submitted by:

Andrew Warmington

UPL to split out specialities

Indian agrochemicals giant UPL has announced plans to transfer its speciality chemicals business, including agrochemical active ingredient (AI) manufacturing to its wholly owned subsidiary UPL Spec

Submitted by:

Andrew Warmington

Nippon Shokubai opens Indonesian plant

Japan’s Nippon Shokubai has officially opened a 100,000 tonnes/year acrylic acid (AA) plant that was built at a cost of about $200 million at Cilegon, Banten, Indonesia.

Submitted by:

Andrew Warmington

CABB to invest at Finnish agro site

The CABB Group has said that it will invest over €50 million by 2025 to expand facilities at its agrochemical manufacturing site in Kokkola, Finland.

Submitted by:

Andrew Warmington

AI for SAPs

Together with Algo Artis, Japan’s Nippon Shokubai has developed an algorithm-based means for the production planning of superabsorbent polymers (SAPs) based on acrylic acid, and has started operati

Submitted by:

Andrew Warmington

adcs

Three invest further into ADCs

Three CDMOs have separately announced expansions in their antibody-drug conjugate (ADC) manufacturing capabilities and capacity on opposite sides of the Atlantic.

Submitted by:

Andrew Warmington

Cambrex exits drug product

CDMO Cambrex has sold its Drug Product business unit to Noramco. Terms were not disclosed.

Submitted by:

Andrew Warmington

Siegfried breaks ground on R&D centre

Siegfried has broke ground for its new global R&D centre for drug substances at its site in Evionnaz, Switzerland.

Submitted by:

Andrew Warmington

Drug product centre opens

Following two years of construction work, CDMO Siegfried has officially opened its new development centre for drug products at its sites in Barberà del Vallès and El Masnou near Barcelona.

Submitted by:

Andrew Warmington

Evonik realigns Health Care

In order to “maximise customer centricity and market focus” and continue an ongoing transition into “a system solutions partner for the pharmaceutical and biotech industries”, Evonik has divided it

Submitted by:

Andrew Warmington

First waste-based biosurfactants

Belgian start-up AmphiStar has launched what it claims are the first fully upcycled biobased surfactants under the trade names AmphiCare and AmphiClean.

Submitted by:

Andrew Warmington

Aether to supply Seqens

Indian firm Aether Industries has entered into a manufacturing agreement with Chemoxy International, a UK-based subsidiary of Seqens.

Submitted by:

Andrew Warmington

New model for biocatalysts

BASF, the Austrian Research Centre of Industrial Biotechnology (ACIB) and the University of Graz in Austria have co-developed a computer-assisted regression model to improve enzyme performance and

Submitted by:

Andrew Warmington

CBE JU funds 31 more projects

The Circular Bio-based Europe Joint Undertaking (CBE JU), a €2 billion partnership between the EU and the Bio-based Industries Consortium (BIC) that funds projects advancing competitive circular bi

Submitted by:

Andrew Warmington

Investment in Tanasote plant

Octowood, a part of the Sweden’s Rundvirke Industrier Group, has invested in a new treatment plant using Arxada’s wood preservative, Tanasote.

Submitted by:

Andrew Warmington

Rhamnolipid milestone reached

Evonik has manufactured the first product from its industrial-scale biosurfactants facility at Slovenská Lupca in Slovakia.

Submitted by:

Andrew Warmington

Sudarshan to buy Heubach

India’s Sudarshan Chemical Industries (SCIL) has entered into a definitive agreement to acquire the Heubach Group in a move that it said would “create a global pigment company, combining SCIL’s ope

Submitted by:

Andrew Warmington

Lanxess to continue pigment production

Lanxess has reversed a decision to sell the chromium oxide pigments business at the Krefeld-Uerdingen site in Germany, preserving 50 jobs there.

Submitted by:

Andrew Warmington

Alliance in natural fragrances

Sensegen, a US-based specialist in biotech-enabled fragrances, notably a new class of natural musk raw materials, has announced a strategic collaboration with Japan’s Takasago, a large player in th

Submitted by:

Andrew Warmington

Croda breaks ground in China

Croda International has broken ground for a low-carbon, multi-purpose production facility on a greenfield site in Guangzhou. This triples its manufacturing capacity for fragrances and establis

Submitted by:

Andrew Warmington

CCT collaboration for Givaudan

Flavours and fragrances giant Givaudan has agreed a research collaboration for the development of sustainable fragrance ingredients from renewable carbon, with US-based LanzaTech, which describes i

Submitted by:

Andrew Warmington

Kao boosts jasmine fragrance

Japan's Kao Corporation is to double capacity for the synthetic fragrance methyl dihydrojasmonate (MDJ) at its site in Olesa, Spain, by adding a second production facility.

Submitted by:

Andrew Warmington

Merck KGaA “in a strong strategic position”

At its latest Capital Markets Day, Merck KGaA said that it is “in a strong strategic position” to profit from medium-term growth opportunities in all three of its business sectors after a transitio

Submitted by:

Andrew Warmington

Suez joins Global Impact Coalition

Suez, which describes itself as “a global leader in circular solutions for water and waste”, has joined the Global Impact Coalition (GIC).

Submitted by:

Andrew Warmington

Chemours opens battery lab

Chemours has opened Chemours Battery Innovation Centre (CBIC) at the Chemours Discovery Hub in Newark, Delaware.

Submitted by:

Andrew Warmington