`

Compete366 provides expert Azure advice to Hanse with SaaS infrastructure

Hanse is a start-up business that has built a software and analytics platform to query International Trade Flows (Import and Exports). This case study explains how Compete366 provided expert Azure advice to help Hanse to build a robust SaaS infrastructure to launch its business.


Download a PDF version of the case study

Business Background

Hanse is a start-up business that has built a software and analytics platform to query International Trade Flows (Import and Exports). The platform is aimed at organisations importing and exporting physical products, and is ideally suited to the SME market worldwide, with an initial focus on the UK market.

Coming from the same stable as High Digital a small software devt. business formed 2018, the Hanse project stems from work completed by Dr. Ousmène Jacques Mandeng on with both the IMF and the U.N. Economic Commission for Latin America. The aim is to analyse international trade flows at a detailed level in order to help businesses to identify relationships between countries and trade.

Ousmène has worked on international trade for many years and developed the programme Trade CAN for analysing international trade for the U.N. Economic Commission for Latin America (ECLAC) during the 1990s. The data underlying Hanse is from the United National Comtrade database and updated continuously.

Hanse has received some funding from The Sustainable Innovation Fund from Innovate UK,  The UK’s Innovation Agency, which has allowed them to launch a beta version which delivers monthly data, visualisation and queries.

The platform will be delivered using a subscription model paid either monthly or annually, and it is anticipated that there could be around 2000 end users, made up mostly of SMEs.

The Business Challenge

The Hanse team, managing the project with Innovate UK, needed to achieve a good overview of the likely forecasts and costs of the business, and hold this information in one place.  This would make It easier to demonstrate what they are working on, and to manage it.

The objectives of the initial phase of the project are to:

  • Deliver a SaaS product to end customers
  • Provide individual Logins to portal
  • End customers should be able to query data specific to them and view Reports/Dashboards
  • Download data/ reports as needed

The Project Solution

After doing some initial research, the team at Hanse was put in touch with Microsoft Gold Partner, Compete366, who helped and advised throughout the process to build an MS Azure based solution that would allow Hanse to retrieve the required data from Comtrade, using source APIs.  The data load frequency is monthly, and the infrastructure needed to be able to handle a huge anticipated data volume of around 1.5 Billion rows.

As Oliver Mackereth – Project Director explains “We were looking for a partner who could review our design, propose a suitable platform and advise and guide on best practices, and architectural recommendations.  When we realised that Compete366 could licence all of the Azure platforms we needed, at the same cost as purchasing direct from Microsoft, but with the additional support we needed, it was a no-brainer!”

Technical Solution Details

  1.  Azure platform hosting SaaS product
  2. Azure Platform IaaS with Azure Virtual Machines,  SQL Virtual machines,  Virtual Network & Disks
  3. Application VM (Azure Linux OS):   customer portal  with embedded reports and dashboards built in MS PowerBI
  4. Database VM (Windows OS):  SQL Server Instance

Expert Azure Advice from Compete366

Compete366 helped with designing the correct Azure infrastructure, advising on how to utilise the licences, guiding on technical requirements, and hand holding through the process of setting everything up.

As Alam Shukla – Data and Technology Lead explains “Compete366 gave us lots of essential support with the Azure platform.  They explained what we could do, and most importantly advised on when to apply which elements.  This timing advice helped us to get the sequencing right and save costs. The independent opinion that the Compete366 Azure experts provide on everything is so valuable.  Our team members are very close to the process – and having this external objective view of the process helped us a lot.”

Alam continues “Without the advice and support from Compete366 we could have spent a lot more and over-engineered our infrastructure at the development stage.  With their advice we have avoided spending on elements that we didn’t need.  And working with funding from Innovate UK, we need to be accountable for every pound spent.”

Next Steps

As the Hanse team were already familiar with MS SQL, they decided to use MS Power BI to provide the embedded Reports and Dashboards in the Hanse platform.  This will be an easy next step to add PowerBI as an embedded instance within the Microsoft infrastructure that is already in place.

With an initial launch in July 2021, targeting the UK SME market, the aim is then to leverage from there into other markets worldwide.  As Oliver Mackereth – Project Director explains “Scalability of our platform is key to our business, to allow us to build an infrastructure that will grow flexibly as our customer base grows – and the Microsoft IaaS platform is perfect for this.”

“Working with Compete366 has been like extending our own team – they are extremely and easy to work with.  Right from the outset, it was clear what was on offer – everything was presented to us in a straightforward and uncomplicated way.  They also provided just the right level of challenge to our developers and saved us time and money by suggesting better ways to implement our infrastructure.”

If you’d like to find out how our Azure Experts can help you set up your IT infrastructure in the most effective way then do get in touch. We’ll be pleased to help.

 

f Back to Case studies

Interested in finding out more?

Contact Us FAQs