Interactive Client Database Integration

Closed
Main contact
Managing Director
(1)
4
Project
60 hours per learner
Learner
Canada
Intermediate level

Project scope

Categories
Data analysis Databases Data modelling Information technology Website development
Skills
airtable application programming interface (api) data migration data management workflow management
Details

Elgner Group Investments seeks to enhance its data management capabilities by transforming a static CSV client dataset into a dynamic, interactive Airtable database. The primary goal is to streamline data workflows, allowing for real-time updates and improved accessibility for end-users. By integrating the Airtable database into the company's website via the Airtable API, the project aims to provide a seamless user experience through an embedded interface. This transformation will enable the company to manage client data more efficiently, ensuring that information is always current and easily accessible. The project will involve tasks such as data migration, API integration, and interface embedding, all of which are crucial for achieving the desired outcome.

Deliverables

The project will deliver a fully functional Airtable database integrated into the Elgner Group Investments website. Key deliverables include:


- A transformed and migrated client dataset from CSV to Airtable.


- Successful integration of the Airtable database into the website using the Airtable API.


- An embedded interface that provides real-time updates and enhanced accessibility for end-users.


- Documentation detailing the integration process and user guidelines for maintaining the database.

Mentorship
Domain expertise and knowledge

Providing specialized knowledge in the project subject area, with industry context.

Skills, knowledge and expertise

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

Hands-on support

Direct involvement in project tasks, offering guidance, and demonstrating techniques.

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
Canada
11 - 50 employees
It & computing, Real estate, Technology, Telecommunications
Representation
Family-Owned Women-Owned

A privately held, self-funded investment group focused on small to medium sized fundamentally sound businesses that face operational, financial or business stress.