Projects 

and

Use cases

 
Migrate to the cloud with  Azure AWS Google Cloud

Future-proof your data

We has brought various companies from no data competencies to databases and dashboards in the cloud, providing the opportunity to take advantage of Machine Learning to improve the business.

​

Typically, we work with the major cloud providers such as

  • Amazon Web Services AWS

  • Google Cloud Platform GCP

  • Microsoft Azure

​

We adapt the cloud solution which will be suit your requirements and future growth , furthermore we do not receive any commission for choosing the cloud platform provider, as it is important that our recommendations are based on problem solving.

 

Some of the benefits:

  • Scalable infrastructure

  • On demand capacity

  • Fast

  • Flexible

  • No capex investments

  • No depreciation

  • Cost effective

  • Supports most used technologies

  • Built-in tools for Machine Learning

  • Easy access to your data anywhere

  • High security requirements

  • GDPR compliant

 

There are different cost structures associated with choosing cloud providers  

​

AWS - here you pay for data storage and server capacity

GCP - here you pay primarily for data processing

​

In Google Cloud Platform we see great advantage in their BigQuery technology as we have had strong results, it is SQL related technology with a focus on the cloud and big data.

​

BI and  data visualization in the cloud

From Excel sheets to cloud based BI fast

For both a leading TMC and the largest OTA in Africa we have continuously solved business intelligence and data science related projects

​

When our client and their investor needed more transparency on data and financial performance they contacted our South African department

​

The challenge arose when their existing Oracle infrastructure could not cope with the daily operations and demanding data extracts concurrently, which was needed to run the business and inform stakeholders. 

​

We designed a new reporting database and chose Google Cloud as the provider which ensured high security, scalable infrastructure and a cost effective set up.

​

The result was data sets with millions of rows of data which was accessible 24/7 on any device they want. 

​

After consulting with the senior management we identified a report suite of more than 20 dashboards needed for various aspects of their business from operational to financial use cases 

​

We implemented cloud based data visualization in this case Tableau, to deliver the information throughout the organisation. This allows us to configure the access rights based on the role in the organization both internally and externally, ensuring the user only have access to the intended data.

​

We continue to deliver weekly written analysis to the management and the investors so they are always updated on the performance and any anomalies in their data. 

​

 
 
Data Visualization 

Find the right reporting tool for your need and budget

Let us prepare the most important dashboards for both internal and external reporting

 

In our data visualization, we primarily use Data Studio, PowerBI and Tableau, so we can find the right tool for you with a license price from DKK 0 per user.

​

From our experience, most companies are rarely ready for Self-service Business Intelligence, which is why it is important to have professional reporting tools and dashboards developed to gain the greatest possible acceptance from your employees.

 

The examples here have been changed to SMV Data's corporate identity, and data has been changed to a demo data set, but our dashboards are live and are of course adapted to our clients' logos and colors.

Machine Learning 

Improve your business with machine learning

​Machine Learning can be complex but in fact machine learning is very demanding in regards to data quality and size. We have a pragmatic approach to ML and would not advice our clients to go this route unless we certain you are ready. 

​

We have deployed with several projects in Machine Learning and predictive analytics. Below you can see some of the business problems we have experience with

​​

  • Scorecards for bad debt
    Developed a predictable model to provide an estimate of the probability of recovering 80% of a consumer's outstanding debt.

​

  • Bad Debt Pricing Model Developed a predictable model to provide an estimated value of a bad debt for debt collection companies or companies to bid for a reasonable selling price of their bad debt

​

  • Location and route algorithm 
    Developed a custom algorithm using telematics data and predicting a vehicle's home and workplaces. 
    Used to determine how far vehicles drive from origin to points of interest, cost reduction and risk

​

  • Prediction of car theft
    Developed a predictable model using telematics data to predict whether a vehicle has been stolen or not.
    Used in the center to prioritize contact and work

​

  • Churn predictions
    Developed a model to predict whether a customer will terminate his contract with a company in the near future
    Used to focus efforts on retaining customers at risk to end the relationship

​

  • Customer segmentation
    Analyzed customer and transaction data to create customer segments to identify additional sales and cross sales opportunities, as well as understand different customer segments.

​

  • Financial forecast
    Developed an economic forecasting system, used for budgets, enabling input from sales managers and senior executives along with external factors. Further included forecast models on outstanding balance, opening volume and sales as well as outstanding debt.

​

  • Recommendation System
    Developed an offline recommendation system that was used to send recommended products to customers via email to drive traffic to the e-store.

​

  • Customer Lifetime Value (CLV)customer lifetime
    Developed a model used to determine a long-term value for each customer.
    Applications Personalized Marketing and Customer Retention

​

  • Strategies Data Cleaning Prediction
    Model Developed a predictable model to predict the right brand and model and use output as input for reporting dashboards across the enterprise, as the source data contained too many errors to effectively report on.

​

  • Customer attractiveness
    valuation method of customers' transaction data to derive segments of customers that can indicate the valuable customer segment.

​​

Automating  back - office processes 
 
 

Reduce cost and errors while increasing efficiency 

Should your organization have a lot of accounting- or back-office related processes then business intelligence can be a starting point to automate and thereby reduce both labor costs and errors .

 

Our clients will often need help with automating the reconciliation of their sales from their systems and and supplier invoicing up to thousands of transactions daily. Once you have migrated to the cloud, it is easy to incorporate reconciliation of excel files with your internal system data.

 

We also have experience in consolidating monthly accounts across systems and file formats, this happens quite automatically and our client has reduced the time to financial consolidation by more than 50%.

 

We also use RPA (Robotic Process Automation) technology, especially Power Automate from Microsoft (Flow), or UI Path as the leading technology in the market. If process are based on UI inputs and across multiple platforms where no integration exists 

Specifically for the Online Travel sector

Data is one of the most important competitive advantages in online travel today 

Our clients in the travel industry has benefited from the experience we have from years in the online travel and hospitality industry 

​​

Below we have some core projects we have dealt with in the travel industry

​​

  • Improving data quality and database design in order to improve Adwords spending

  • Optimization of conversion rates

  • Optimization of payment methods in checkout

  • Optimization of OTA revenue, use of data to optimize fees and margin on route, airline and contract level

  • Optimization of additional products, such as travel insurance, bankruptcy insurance, hotel etc.

  • Look to Book optimization to reduce GDS scans

  • GDS search response analysis to optimize OIDs

  • BSP reporting

  • Dashboards for operations of OTA back office, call center, ticketing, refunds etc.

  • Automatic Amadeus reconciliation

  • Automatic BSP reconciliation

  • Automatic reconciliation of LCC low cost airlines billing

  • Dashboard tools for minimizing card fraud

  • Dashboards for corporate travel customers

  • Dashboards for internal reporting in TMC

  • Models for optimizing search results and product recommendation for both air and hotels

​

Some of the technologies we can support

Amadeus | Sabre | Travelport | Quicktrav | Procon | direct integrations

 

Below is a dashboard of automated Amadeus reconciliation on a PNR level 

A1 Recon.png