+44 (0)1926 623303

Technology

Integrate leading off-the-shelf technologies with bespoke applications to optimise your advantage.

Create an innovative, totally reliable and ultimately powerful bespoke information management and analytics solution aligned perfectly to the way your organisation works and thinks.

Analytics, dashboards and scorecards

IBM Cognos Analytics

With IBM Cognos seamlessly integrated into your information management and analytics solution you are assured you have the best, most flexible, secure and robust platform available. IBM Cognos is now AI-infused which helps find answers others cannot using AI and machine learning. The latest version allows you to ask questions about your data and receive intelligent responses with natural language-powered AI assistant.

The EBI team have been working with Cognos since 1995, embracing and implementing all the IBM developments over nearly two decades. Gaining unrivalled experience in maximising products for individuals, workgroups, departments, mid-size businesses and large enterprises. EBI will recommend and implement the perfect mix of IBM Cognos technologies to optimise your investment. These can be combined with bespoke applications where required, to deliver maximum advantage from your solution. IBM Cognos can be hosted locally or in the IBM Cloud.

Microsoft Power BI

Power BI is a business analytics service by Microsoft. Power BI provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

EBI can integrate Power BI into your Azure / Office 365 eco-system to provide a completely scalable automated data refresh cycle from source to report using the Azure platform as a service. Power BI contains over 90+ connectors for data in the cloud or on premises. EBI have used Power BI to embed stunning, interactive data visualizations in applications, websites, portals, SharePoint.

Power BI allows users to ask questions in natural language, and predictive visualizations appear as you type. The Quick Insights feature will trawl the dataset to uncover predictive patterns, associations, and trends.

Data integration

IBM InfoSphere Information Server DataStage 11.7

DataStage is a powerful and scalable ETL platform that uses high performance parallel processing to collect, transform and integrate high volumes of data, across a multitude of sources and targets, on demand. Its ease of use makes building, deploying, updating and managing any data integration solution simple.

11.7 now includes a web front end for maintaining job designs, the move to a microservices architecture paves the way in future to run as ETL-as-a-Service in the cloud. Other features include support for big data, including Hadoop, and the capability to prioritise tasks and optimise hardware use. DataStage, along with its InfoSphere siblings, also facilitates extended metadata management and enterprise connectivity.

EBI experts deploy, migrate and adapt IBM DataStage to optimise performance and business value. EBI have extensive experience in migrating to DataStage from the End of life DataManager ETL.

Microsoft SSIS / Data Factory

A variety of ETL data management tools are available to extract data from the source system, transform it to align with the way your business thinks and load it into the data platform.

MS SSIS is a powerful, reliable yet flexible tool which handles even the most unusual and complex transformation tasks. It also connects to any data source creating an array of possibilities to gain competitive edge.

EBI are leaders in configuring MS SSIS in the right way to deliver business needs. Clients also benefit from EBI's extensive expertise in creating bespoke modules to perform tasks which provide a unique advantage.

Azure Data Factory runs on the Azure platform to offer data integration and transformation at cloud scale. Data Factory can read local databases through the Azure secured VPN and integrates with PowerBI, Azure Machine Learning.

EBI can lift your existing SQL Server Integration Services (SSIS) packages to Azure, and let Data Factory manage your resources to help you increase productivity and lower your costs

Data science

IBM SPSS Modeller / IBM Watson Studio

SPSS Modeler / IBM Watson Studio is a leading visual data science and machine-learning solution. It helps enterprises accelerate time to value and achieve desired outcomes by speeding up operational tasks for data scientists. Combine, compare and manipulate multiple data feeds to discover new insights and even confidently predict the outcomes of future actions.

IBM SPSS Modeller / IBM Watson Studio have powerful yet simple to use visual predictive analytics software interfaces. The industry benchmark. Integrated into your solution it will learn constantly and provide ever more reliable statistics. IBM Watson Studio provides a web interface to the IBM Watson AI engine to provide a scalable hosted service. Alternatively, IBM SPSS can be used from the desktop to generate models and theories that can be directly incorporated into the ETL itself.

EBI's solutions ensure you have the right platform and perfectly formatted data to get the most from IBM SPSS Modeller / IBM Watson Studio. Totally trustworthy data and analysis which will enable well informed decisions and give you a competitive edge.

Azure Machine Learning

Azure Machine Learning Studio is a collaborative, drag-and-drop tool for building, testing, and deploying predictive analytics solutions on your data.

The model can execute R or Python Script for transforming the data into one of the different algorithms. Algorithms types include Decision Trees, Decision Forests, Clustering, Time series, Recommendation models, Anomaly detection.

Once trained and published the model can be integrated into the ETL pipeline to score data using Azure Data Factory. The platform also provides tools and APIs for both model training and model hosting.

EBI have used this technology with clients to enrich customer data trying to predict customer lifetime value insights. We have also used it to try and predict oil prices and also to simply forecast sales over time using R script.

Data storage

SQL Server / AzureSQL / Azure Data Warehouse

Storing your data warehouse and information management platform on a database management system with the most fully featured and high functionality technology means speed, availability, security and scalability. Avoiding the high overheads of similar systems whilst delivering all the capability you could require. EBI's consultants have been installing and maintaining SQL Server for clients since the first version launched.

Invisible to the business but always high performing and available. Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database. The Azure Data Warehouse is a fully managed cloud data warehouse for enterprises of any size that combines lightning-fast query performance with industry-leading data security. The Azure Data Warehouse solution provides massive query concurrency over a number of quickly scalable nodes.

EBI are data warehousing experts. Whether on cloud or on premise EBI ensure this fundamental building block of every BI solution is precisely optimised for business needs.

IBM DB2 Database / Warehouse

DB2 is a family of hybrid data management products designed to help you manage both structured and unstructured data on premises, private and public cloud environments.

DB2 Blu Acceleration can transform reporting and analytics speeds, simplify database management and reduce overall costs. Through compression, parallel vector processing and data skipping, the answer to a query is retrieved in the most efficient way.

EBI optimise speed in new business intelligence solution deployments and existing systems. EBI, a Silver IBM Business Partner, are already delivering impressive performance improvements with DB2 Warehouse.

DB2 Warehouse is a client-managed, private cloud data warehouse for Docker container supported infrastructures (formerly IBM dashDB Local).

IBM Integrated Analytics System

IBM Integrated Analytics System powered by Netezza (IAS) offers the high performance needed to analyse all of an organisation’s data.

PDA provides “load and go” simplicity, doesn’t need complex data modelling and is simple to use offering low TCO. With 200 preloaded analytic capabilities plus build your-own queries, the system offers the flexibility to leverage the Big Data opportunity. With 10X to 100X the performance of traditional custom systems (based on IBM customer reported results), IAS has the speed to provide near real time response to queries.

IBM IAS can complement and extend the existing Enterprise Data Warehouse leveraging existing investments and making it easier and less expensive to add “next generation” capabilities.

EBI are accredited, experienced IBM Integrated Analytics System experts.

IoT / cloud

Host your information management and analytics solution with a cloud provider such as Amazon, Microsoft or IBM and you have the fastest, most flexible, highly secure and cost effective platform. Access securely from anywhere, flex power and performance and leave the maintenance to the provider rather than stretching IT resource. With monthly payments and no capital outlay the cloud is revolutionising how businesses drive data solutions. With over 9 years experience in deploying cloud technology, EBI are experts in capitalising on all the extra benefits. Deploying failover systems globally for ultimate availability, increasing power when required (e.g. overnight ETL) and creating duplicate testing and development environments on demand.

IBM Cloud

IBM Cloud is a secure cloud-based Platform as a Service based on open technologies. It enables rapid development, deployment and management of innovative business applications.

IBM Cloud puts the cloud computing platform responsibility with IBM, reduces internal resource requirements, lowers costs, enables flexible processing capacity and speeds up time to value.

IBM Cloud offers a multitude of services based on IBM applications such as Cognos and Watson. These can be combined using various languages to produce a diverse range of mobile and web cloud-based applications. IBM Cloud sits on IBM’s proven and ever growing SoftLayer cloud infrastructure.

EBI deploy cloud solutions incorporating IBM Cloud technologies to precisely deliver enterprise BI solutions.

Microsoft Azure

Microsoft Azure is an ever-expanding set of cloud services to help your organisation meet your business challenges. It’s the freedom to build, manage and deploy applications on a massive, global network using your favourite tools and frameworks.

Microsoft Azure is a hybrid that can be joined to on premise networks to share existing security infrastructures / resources. Azure has been used by EBI to host a wide variety of solutions for clients using many of the IaaS / PaaS building bricks.

With no upfront cost, you only pay for what you use. Azure provides flexible purchasing and pricing options for all your cloud scenarios, such as the Azure Hybrid Benefit, and offers extensive tools to help manage your cloud spend.

Amazon Web Services

Amazon Web Services (AWS) was the first real provider of cloud computing. EBI recognised the power, flexibility and agility of the AWS cloud computing early on and still use it today to host and develop applications.

One of the key benefits of cloud computing is the opportunity to replace up-front capital infrastructure expenses with low variable costs that scale with your business.

Amazon Web Services provides a highly reliable, scalable, low-cost infrastructure platform in the cloud that powers hundreds of thousands of businesses in 190 countries around the world.

The AWS platform contains Redshift a Data Warehouse solution as well as many services to help our developers to build and host applications from Data Warehousing to Alexa integration.