• Menu
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Before Header

Contact us +45 31 31 72 67
  • LinkedIn

Vlk IT Consulting ApS

Header Right

  • Expertise
  • Why us
  • Consultants
  • News
  • Contact us

Mobile Menu

  • Expertise
  • Why us
  • Consultants
  • News
  • Contact us

Let’s meet for coffee!

Give us a call to setup an informal meeting about your Company’s requirements and needs.

  • LinkedIn

How to tap into the potential of your unstructured data

You are here: Home / Uncategorized / How to tap into the potential of your unstructured data

January 30, 2020 //  by admin

Recently we were approached with a rather unusual request well outside of the BI tasks we traditionally take on. The customer was asking for a solution that would allow them to tap into and structure image-formatted invoice data that could further be used for various analysis and cost optimization.

So far, the customer had been outsourcing this task to external partners who would manually type in all the relevant fields to excel. As you can imagine, this is a trivial and expensive (time-consuming) task that is very error prone, and furthermore would delay the analytical results greatly.

A preliminary search quickly showed a bunch of OCR tools available in the market. Especially for financial controlling, a lot of solutions were focused on facilitating the process of posting aggregated financial transactions to various chart of accounts. However, finding a tool that could convert a bulk number of invoices to a classical database format, was hard to find.

The task itself aligns quite well with the future trend that data practitioners will have to adapt to one way or another. Namely, that the sheer volume of unstructured data has exploded greatly in recent years and will be an even more important asset in the years to come. Big companies have partaken the challenge of harvesting value from this data, but it seems like a lot of companies are lacking behind on the inhouse capabilities and skillset in releasing the power of their unstructured data. Some companies have started to subscribe to third party solutions that can possibly help them leapfrogging their most time consuming processes and getting a technological edge, but few have found a spot for tame and let the unstructured data into their way of working with BI.

Spending a few weeks on a draft solution, that could take several invoices in image format and convert them to a structured database format, was definitely an eye opener. Not only did it show how seamlessly the SQL suite can be interlinked with third party OCR scraping tools allowing you to tap into the unclaimed territory of image data; it also showed how misleading the interpretations of raw data could end up in your chart of accounts. Giving you false conclusions on your expenditures, simply because information was lost in the aggregation- or classification process.

Have you already started the journey in getting structure in your unstructured data, or could this be a topic for the year to come? Please do not hesitate in starting a dialog and get inspiration from our field observations and experience on this matter.

Category: Uncategorized

You May Also Be Interested In:

How to tap into the potential of your unstructured data

Data: From enemy to friend

Starting a new business

Only Hire a Law Firm That Specializes In The Practice Area You Need

A fast changing system landscape

Previous Post: « Data: From enemy to friend

Primary Sidebar

Let’s meet for coffee!

Give us a call to setup an informal meeting about your Company’s requirements and needs.

RECENT POSTS

How to tap into the potential of your unstructured data

Recently we were approached with a rather unusual request well …

Data: From enemy to friend

In the modern business world, data has become an imperative …

Starting a new business

In august 2017 I took the leap into unchartered territory as I …

Footer

Contact Us

Contact us to setup an informal meeting about your company’s requirement and needs.
Learn How →

Head office
VLK IT Consulting ApS
Bøgelunden 20
9560 Hadsund
Email: bill@vlkit.com
CVR: 38795120

Ballerup office
The Energy Hub
Lautruphøj 5-7
2750 Ballerup

Privacy policy

 

 

  • LinkedIn

2019 © VLK IT Consulting - All Rights Reserved