Database spreadsheet design and automation

Closed
INÉRO, INC
Montreal, Quebec, Canada
President
(6)
6
Project
Academic experience
80 hours of work total
Learner
Anywhere
Intermediate level

Project scope

Categories
Data analysis Data modelling Databases
Skills
data collection supplier identification and selection data science innovation automation
Details

INÉRO, INC is seeking to update its database for an innovative solution that improves how aerospace companies find suppliers.


The project involves :

  • Reviewing the existing spreadsheet and updating headers that match the information that needs to appear on the companies' profiles (e.g., employee count, factory locations)
  • Automating updates.


To automate the database, we will use an AI no-code solution that gathers information and updates the spreadsheet on its own. No-code solutions do not require deep coding knowledge.

Example of such tools are freckle.io and clay.


The students will work on a small sample of 50 records to test out automation.


The founder will be able to support students with questions.





Deliverables

Expected deliverables

1 - A short recorded video (on Canva, loom or phone) showing:

  • The spreadsheet before and after
  • The steps taken to automate the updates.


2 - The updated spreadsheet featuring:

  • headers reflecting our solution's profile entries
  • the 50 updated lines
  • **Formulas could be used as a last resort, if the automation didn't work.


Expected outcome

  • We are looking to achieve full automation of each 50 record using the company name and its state or province location.
  • We should be able to verify the addresses from two reliable sources to ensure accuracy.


A successful project will enable INÉRO to replicate the task on another sample of 50 records.

Mentorship
Skills, knowledge and expertise

Sharing knowledge in specific technical skills, techniques, methodologies required for the project.

Tools and/or resources

Providing access to necessary tools, software, and resources required for project completion.

Regular meetings

Scheduled check-ins to discuss progress, address challenges, and provide feedback.

Supported causes

The global challenges this project addresses, aligning with the United Nations Sustainable Development Goals (SDGs). Learn more about all 17 SDGs here.

Industry, innovation and infrastructure

About the company

Company
Montreal, Quebec, Canada
0 - 1 employees
Airlines, aviation & aerospace, Technology
Representation
Women-Owned

INÉRO, Inc. develops AI solutions for aerospace procurement.

INÉRO's Lydie Artemova is a laureate of REGM-sustainable enterprises (a specialized network that provides guidance to high-potential entrepreneurs).

Lydie was recently selected among
- 12 entrepreneurs to pitch at a Google event
- 25 entrepreneurs for a reception organized by Montreal's city hall.
- 2000 young leaders for the One Young World global conference.