Our Airflow Pipeline & Automated Data Extraction for a Smart Assistant

Our Airflow Pipeline & Automated Data Extraction for a Smart Assistant

Our Airflow Pipeline & Automated Data Extraction for a Smart Assistant

About the Client

Our customer is an energy technology startup based in Texas, USA. They created a device-independent smart assistant that runs on any browser and has been custom built just for upstream Oil and Gas. Any company can connect to limitless internal and public data sources, extract high-value insights, and allow for a natural conversation with the data. The smart assistant helps companies make brisk decisions, by organizing the collective knowledge within the company and making it accessible.

Siddhartha Gupta

Nesh CEO

Client goals

The company’s co-founder - Schlumberger and Shell alum got curious about data, analytics, and machine learning during the major downfall of oil prices in November 2014. It led him to ask questions about why it was happening and can it be predicted in a better way? He wanted to simplify complex industrial knowledge that was easy to access. He and his colleagues have a long-term goal to create an ecosystem of workflows around the smart assistant so that everyone in an organization can ask the tough questions and get back the answers without any delay.

" Better Software has been a technology partner of the energy tech startup under the staff augmentation model since September 2020. "

Building Airflow Pipelines and Automated Data Extraction

We developed an Airflow Pipeline to extract text from unstructured documents and upload it to an elastic search database and created an external API for users outside of the team network. The Airflow pipeline automated workflows and managed boring and redundant manual tasks

We built airflow pipelines for

Extracting data from uploaded and emailed document

Extracting data from uploaded and emailed document

Extracting data from uploaded and emailed document

Extracting data from uploaded and emailed document

We added a new feature where anyone from the organization can compare financial data on a quarterly basis or look into the yearly growth.

We did this by designing elastic search mapping and queries for refined results. Now anyone can ask questions like: What was NRG’s thirdquarter revenue growth percentage and they will get the reply at the same moment in a conversational way.

The more questions you ask the assistant - the smarter it gets. Another feature added by our team is to develop a process where the assistant nudges you with questions that you didn t think of asking. This can provide relevant insights and, hopefully, uncover new knowledge from the data.

The team also reinvented the backend data structure with dependency injection and storage abstraction. - increase in speed, reduced latency, restructured the backend using service based architecture.

We also redesigned Data Explorer for viewing different connected data sources in an improved manner. We improved table extraction logic for extracting tables from unstructured PDFs and documents on top of existing libraries ( Airflow )

Results – A Smarter, Faster, and More Efficient System

Response time has been reduced drastically and the UI/UX is better in the new version. With the new infrastructure development, the user is now able to ask questions based upon suggested, and typeahead questions. The user can also see financial information about his peers and compare them. And filter and sort responses on the basis of different tags.

Other Case Studies

kizuna-background

A platform to hire caregivers for elderly family members

"The items were delivered on top, and any issues that arose were quickly addressed."

kizuna-cofounder-picture

Tommy Kranwinkle

Co-Founder, Kizuna
kizuna-background

A platform to hire caregivers for elderly family members

"The items were delivered on top, and any issues that arose were quickly addressed."

kizuna-cofounder-picture

Tommy Kranwinkle

Co-Founder, Kizuna
kizuna-background

A platform to hire caregivers for elderly family members

"The items were delivered on top, and any issues that arose were quickly addressed."

kizuna-cofounder-picture

Tommy Kranwinkle

Co-Founder, Kizuna
client-background

a16z backed home mortgaging company

"The quality of work they deliver is very impressive and a step above their peers."

client-profile-picture

Jon Hsu

Co-Founder & CTO at Valon
client-background

a16z backed home mortgaging company

"The quality of work they deliver is very impressive and a step above their peers."

client-profile-picture

Jon Hsu

Co-Founder & CTO at Valon
client-background

a16z backed home mortgaging company

"The quality of work they deliver is very impressive and a step above their peers."

client-profile-picture

Jon Hsu

Co-Founder & CTO at Valon
client-background

Dental Office and Patient Management Software

“Better Software has been outstanding to work with. They have been reliable, the technical quality has been very high, and they are realistic about the promises they make which allows them to keep them. A much better experience than we've had with any other development firm.”

client-profile-picture

Matthew Hale

Founder at at Hale Law Enterprises, LLC
client-background

Dental Office and Patient Management Software

“Better Software has been outstanding to work with. They have been reliable, the technical quality has been very high, and they are realistic about the promises they make which allows them to keep them. A much better experience than we've had with any other development firm.”

client-profile-picture

Matthew Hale

Founder at at Hale Law Enterprises, LLC
client-background

Dental Office and Patient Management Software

“Better Software has been outstanding to work with. They have been reliable, the technical quality has been very high, and they are realistic about the promises they make which allows them to keep them. A much better experience than we've had with any other development firm.”

client-profile-picture

Matthew Hale

Founder at at Hale Law Enterprises, LLC
client-background

Techstar backed debt management platform

“Better Software built an exceptional 3 person development team for me. They work hard, communicate well and write high quality code. Highly recommend.”

client-profile-picture

Steve Strauch

CEO
client-background

Techstar backed debt management platform

“Better Software built an exceptional 3 person development team for me. They work hard, communicate well and write high quality code. Highly recommend.”

client-profile-picture

Steve Strauch

CEO
client-background

Techstar backed debt management platform

“Better Software built an exceptional 3 person development team for me. They work hard, communicate well and write high quality code. Highly recommend.”

client-profile-picture

Steve Strauch

CEO
client-background

Solar Sales Quotation Tool & Operations Platform

“The company has seen an increase in customers by five times, thanks to Better Software Consulting's platform. It also has sped up and standardized each operation of the business. Overall, they're a nimble-minded partner who understands complex requirements easily and delivers what the client needs.”

client-profile-picture

Joe

Sunny Energy CEO
client-background

Solar Sales Quotation Tool & Operations Platform

“The company has seen an increase in customers by five times, thanks to Better Software Consulting's platform. It also has sped up and standardized each operation of the business. Overall, they're a nimble-minded partner who understands complex requirements easily and delivers what the client needs.”

client-profile-picture

Joe

Sunny Energy CEO
client-background

Solar Sales Quotation Tool & Operations Platform

“The company has seen an increase in customers by five times, thanks to Better Software Consulting's platform. It also has sped up and standardized each operation of the business. Overall, they're a nimble-minded partner who understands complex requirements easily and delivers what the client needs.”

client-profile-picture

Joe

Sunny Energy CEO