The Problem
Our client, Lincoln, needed a system that would help the company process data files for bulk analysis. Previously, Lincoln employees were processing Excel data sheets manually, but as the business expanded, the company could no longer handle the massive influx of files that needed to be processed. As a result, the company sought to develop a new system that would ensure the tedious process could be completed accurately and efficiently.
Our Solution
In order to enhance Lincoln’s operations, we decided to automate the company’s systems, writing a unique algorithm to analyze and clean up the data so the files could be imported into a database. The robotic process automation system we built streamlines the entire procedure and provides the ability to sort and filter the data into a more easily processed format. With this successful system, Lincoln can now effortlessly process the thousands of data files the company receives each month.
What We Did
Power BI Dashboard
For this project, we included a database that enables users to import files that can be processed with a Power BI dashboard. This way, users can easily create reports with Power BI to display the data visually.
Automatic Sorting
The system is also built to automatically run as soon as a file is dropped into a certain folder or emailed in, allowing files to be quickly sorted based on errors or warning flags. This function has significantly helped to reduce employee workloads while increasing the company’s throughput, customer count, and revenue.
Machine Learning
Because not all the files Lincoln receives are in the same format, we implemented machine learning to process the information into a database so it could be viewed and sorted in order to find specific data. This also ensures that the data can be correctly mapped out.
See What Our Clients Think About Our Services
Check our what one of our top clients has to say about Idea Maker.
PlaneFax
Aviation Marketplace Platform
The team was very responsive and easy to work with. They are professional, talented, and experienced team. They were able to meet all our requirements.
Idea Maker is distinguished for their personalized collaboration and white glove services. The team is dependable and reliable, sticking to the project's plan, offering feedback, and pushing back on the right things.
The way they understand the requirements we present to them is fairly solid. Both in terms of bringing their own interpretation in nailing the requirements and their design sense. By the time we launched, I had gotten significantly more value from our collaboration than what we had discussed in the original specs.
This is a boutique development firm where the Founder is directly involved with the project and the primary contact. This is unlike many development firms where you are simply handed off to developers that are not stakeholders. This is an important distinction that results in much better project accountability.
I have never had a site like this built before. I felt that Idea Maker and Tom had built numerous sites like this, and they were pros.
Idea Maker's portfolio is what drew us in. Their design style was in alignment with what we were after. We had initial consultations with 3 companies that we had narrowed it down to. Once we had our initial meeting with Tom at Idea Maker we knew we had the right choice to make. Their communication style works well for us.
Their customer service is excellent — they’re incredibly accessible and available, which I appreciate. Furthermore, they have enough experience and bandwidth to fulfill all my needs. They’re one of the best vendors I’ve worked with.
Let's Talk About Your Project!
Tom Kwon
CEO
If you’re interested in discussing how we can collaborate to meet your goals and overcome challenges – whether on the technical side or the business side – I’m just a message away. Let’s dive into a conversation!
Some of Our Awards and Recognitions
