Database spreadsheet design and automation

Fermé
INÉRO, INC
Montreal, Quebec, Canada
President
(6)
6
Projet
Parcours académique
80 heures de travail au total
Apprenant.e
N'importe où
Niveau Intermédiaire

Portée du projet

Catégories
Analyse des données Modélisation des données Bases
Compétences
data collection supplier identification and selection data science innovation automation
Détails

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.





Livrables

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.

Mentorat
Compétences Connaissances et expertise

Partager des connaissances sur des compétences techniques spécifiques, des techniques, méthodologies requises pour le projet.

Outils et/ou ressources

Donner accès aux outils, logiciels et ressources nécessaires pour la réalisation du projet.

Réunions régulières

Enregistrements programmés pour discuter des progrès, relever les défis et fournir des commentaires.

Causes prises en charge

Les défis mondiaux auxquels ce projet s'attaque, en accord avec les objectifs de développement durable (ODD) des Nations unies. En savoir plus sur les 17 ODD ici.

Industry, innovation and infrastructure

À propos de l'Compagnie

Compagnie
Montreal, Quebec, Canada
0 - 1 employé.es
Airlines, aviation & aerospace, Technology
Représentation
Propriété des femmes

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.