Every organisation needs a Data and Analytics strategy...

Having insight into your data helps you to...

Improve visibility and make accurate predictions

Get the right products or services to the right places or people

Offer customers exactly what they want, when they want it

Fix problems proactively before they start

Explore new business opportunities

Why Microsoft?

Why is a Microsoft solution the natural choice for data and analytics?

There are a lot of players in the data and analytics space but they all need to connect to a Microsoft technology at some point, as it is ubiquitous in almost every enterprise organisation, due to the breadth of services that Microsoft offer.

Only Microsoft can provide a complete platform of connected technologies whether that’s on-premises or in the cloud; infrastructure-, platform- or software-as-a-service. Microsoft’s advanced workloads cover a wide range of data capabilities, helping organisations to move from simply managing data to taking decisions and even taking automated action. Indeed, Gartner Inc.placed Microsoft with the most complete vision and a strong ability to execute as a leader in their magic quadrant for business intelligence and analytics platforms (February 2017). And that’s just one of many magic quadrants where Microsoft scores highly.

Whether it’s big data stores and information management, dashboards and visualisations, machine learning and analytics or perceptual intelligence, Microsoft can offer market leading analytics services, without having to connect to new systems or invest in a new supplier. Microsoft’s cloud offers are increasingly viable as a one-stop supplier for all business IT needs, and the company is funding revolutionary research into Artificial Intelligence and Machine Learning which will be made available to commercial customers as each breakthrough is made.

Why risual?

Why choose risual to devise your data strategy?

At risual we believe that to truly be a market-leading Microsoft partner, you must go beyond consulting or providing managed services based on a single arm of the Microsoft stack. This leads to partners naturally trying to fit square pegs into round holes to ensure they win business using technology they are comfortable with. risual data platform and analytics Consultants will always approach an engagement with the business requirements in mind under the guidance of a risual Architect. Our solutions are built using carefully chosen technologies from right across the Microsoft stack to ensure that the customer receives a solution that suits them, not us.

For data, we have the experience required across all technologies to deliver more than just some dashboards that connect to multiple sources. We can advise on how to restructure your infrastructure for faster reporting, build an application which brings data to life, or embed insights directly into an application solution. We have architects and cloud consultants on hand to advise on your data integrity, complimented by deeply technical data scientists to provide expertise on services such as Azure Stream Analytics, or integration with applications using R language as a basis. Only risual can offer this combination of high level strategy and the technical expertise to deliver the solution in house.

Our people are also some of the most securely vetted of all Microsoft partners; all staff are security cleared and we have passed multiple audits of ISO 20001 and ISO 9000. Our award-winning Managed Services team pride themselves on adhering to strict ITIL processes and we can ensure your new data solution has the first, second and third line support to ensure maximum uptime and uptake by staff.

Typically, our Data and Analytics specialists deliver solutions focusing on:

Data Platforms: Providing data storage and handling foundations on which to build strong analytical platforms

Business Intelligence: Creating a mechanism to build and provide traditional analytics services to create actionable insight

Data Science Services: Methodological exploration of data (e.g. mathematically or statistically) to provide foresight and analytics

Data-Driven Applications: Build the capabilities to develop applications which are data-driven rather than process-driven

Data Distribution: Creating a framework that shares data for collaboration and avoids creating silos

Case Study - apetito

Case Study - apetito

The Problem

As a leading provider of frozen meals to hospitals, care homes and local authorities, apetito know the value of good nutrition more than anyone. They’re committed to providing a wide range of delicious, appealing and nutritionally balanced meals therefore they must ensure their customers continue to receive the high quality they are used to. apetito found the legacy data base system they were using previously did not meet the requirements that were essential in maintaining or increasing the productivity and service levels of the business. Their specialist engineers are required to maintain manufacturing equipment, including keeping track of servicing schedules, remediational work and any maintenance problems. apetito’s previous database solution presented the following issues:

Poor storage of case management information.

Single user restrictions – causing continual system lock out to administrators.

Lack of capacity causing a slow and unresponsive user experience.

Overall these issues made it difficult for engineers to manage their work, leading to a slowing down in productivity but more significantly was having a major impact on the production of meals.

The Solution

Implementing this solution has enabled apetito to transform their strategy to maintain their manufacturing equipment. Mike Calverly, IT Service Delivery Manager at apetito stated “We are no longer having to pay our engineers overtime to stay and fix the system, they now have the application available there for when they need and want it, allowing them to input the information quickly”.   The solution risual provided to apetito is a bespoke web based application, providing real time data to all users which includes the following features and benefits:

A multi-user maintenance management system for any number of assets within an organisation.

Multiple users are able to record, track and manage maintenance tasks performed on assets that require maintenance.

Ad-hoc work orders can be created on the day and are recorded instantly.

Work orders can be planned up to a year in advance.

The system can also generate multiple work orders based on a user-defined frequency, be that years, months, days, minutes or even seconds.

Designed with cloud in mind with minimal effort and changes required

Case Notes - Operational Intelligence

Case Notes - Operational Intelligence

risual worked alongside a large Fire and Rescue Service who were struggling with an aging fragmented system, which provided intelligence to their fire fighters when they are responding to an incident. The Fire Service had the requirement to modernise and replace the existing system which was locked into their appliances with one that would be mobile and could be taken anywhere. The Operational Intelligence application is a Windows UWP tablet based app, which allows fire fighters to view operation intelligence at the touch of a button. Using a powerful mapping system, any locations with available intelligence are displayed to the user around their current location. They can then view this information as well as viewing any specific associated documents like floor plans and any standard operating procedures that may be needed. The information is all managed through an Azure based website which their commanding officers and OI specialists have access to. Data can be entered and managed directly through the website as well as using the tablet to make edits to OI or create new OI through onsite inspections which are then placed into an approval system. Firefighters will now be able to view this information when responding to an incident. This both protects the fire fighters from potential hazards and dangers and protects the Fire Service from a legality standpoint. The system was designed by a risual enterprise architect and the design, build and documentation were produced by development team who worked on creating a Windows UWP application. Testing was performed by our qualified QA testers.

We use knowledge gained from years of device deployment – at varying scales – to develop a transformational approach focused on delivering a user-centric work style. We see End User Computing as empowering all users in an organisation with an IT environment that works intuitively and seamlessly across any device. To do this, we focus on removing the ‘one size fits all’ approach to users, which helps us to deliver better ways of working with what suits the entire organisation.

Understanding how the applicable technology options could be delivered to the different groups of users within an organisation is key. We build in the ability to cope with technology and business change, while ensuring stability and business continuity. This allows us to quickly identify benefits for the organisation and the individual, whilst maintaining or enhancing security in an increasingly agile world.

Case Notes – Business reporting and intelligence

Case Notes – Business Reporting and Intelligence

risual worked with a large insurance company, who outlined their challenges with business reporting and intelligence within a number of business units. The areas for immediate concern were:

  • The simplified presentation of business intelligence, currently delivered on mobile devices as PDF files.
  • Overhead on the performance team to regularly answer ad hoc analysis requests in a reactive fashion.
  • Moving to a model that provides reports and analysis to the business aligning with Aviva’s corporate governance.
  • Simplified management and presentation of all UK Life’s data (excluding financial data that is separately managed).

This project aimed to address some of these concerns by deploying mobile dashboards (to iPhone, iPad, Android or Windows devices) as a proof of concept allowing business users to evaluate the functionality and potential value of mobile reporting. Users will be required install the Microsoft Power BI1 app from the public app store and will be provided with credentials to sign in to access the mobile reports.

What was achieved:

  • Selected Complaints and Alps data as focus for reporting
  • Set up a Virtual Machine in Azure and installed and configured Mobile Reports
  • Designed and built five reports:
    • Alps Pipeline
    • Alps Policy Single Auto Decision
    • Complaints Dashboard
    • Complaints Pipeline
    • Complaints Root Cause Analysis
  • Made the above available in the Power BI mobile app for review and feedback from business users


Was Clippy the precursor to desktop assistants? One things for sure, digital assistants have got a lot smarter...

If someone crashes whilst relying on Tesla’s autopilot, should the police be charging the driver or thanking them?

risual's Akin project is at the forefront of the analytics revolution. get ready for the fourth industrial revolution.

It seems inevitable that AI will eventually be able to perfectly capture the emotions of art...

Businesses can learn from Batman; his greatest tool is one that money can't buy and that’s intelligence and insight...


Machine learning and data analytics can be a game-changer when it comes to combatting fraud in LRG...

Transformation in the retail industry has been steadily building over the past twenty years due to the vast amount of information available to them...

Banks are struggling to undergo digital transformation due to the potential risks involved...

Big Data is the ‘Silver Bullet’ which can help the UK economy deliver efficient and predictable Public Services...


Contact us