Competitors Database | CASE HISTORY
Client
International School of Design, Fashion, and Communication
Locations
Italy, Spain, South America
Objective
To create a database for gathering information on courses and events from competing entities, enabling a comprehensive comparison of their offerings with our client’s.
Technological Choice and Methodology
A sleek yet professional web application within a LAMP (Linux, Apache, MySQL, PHP) environment was developed, focusing on UX/UI design optimized for business internal use. The application’s responsive design ensures seamless operation whether accessed from a desktop in the office or via tablets remotely, especially useful during events.
Design and Implementation
The application was structured to differentiate between companies, courses, and events, each with its extensive set of fields. It included the capability to attach images and files within a dedicated library. For each category, list pages with filters and free search, as well as add and edit pages, were created. To facilitate user-friendly data entry, a “wizard” style input was implemented, guiding users through targeted questions to ensure all necessary information was captured. Each form was meticulously coded as a collection of sections and fields, incorporating complex fields for location input via Google Maps APIs and other advanced logic for calculations and value selection. File uploads to the media gallery were designed to bypass server and hosting limitations by segmenting data packets, ensuring smooth handling of files of any size. Automated email reminder mechanisms were established to prompt responsible users to verify and update their data after a specified period.
Integration Challenges
The solution was seamlessly integrated into daily operations by the marketing department, which spearheaded its development. This transition was marked by the efficient input of hundreds of records in a short time, without encountering any significant challenges.
Results
This system empowered our client to systematically and accurately compare their training course offerings against those of their competitors, yielding invaluable insights into their strengths and areas for improvement. It also enhanced the staff’s commitment to continuous information gathering and updating, particularly concerning competitor events.
Evolutions
Shortly after the initial launch, the client requested the addition of a statistical integration feature. A mechanism for the mass importation of annual data from the MIUR (Ministry of Education, University and Research) was developed, translated into specific dashboards, indices, statistics, and charts. These tools efficiently and effectively summarize the most relevant insights for analysts, providing a deeper understanding of market positioning and opportunities for strategic enhancement.
Conclusion
This case study exemplifies our dedication to delivering tailored, sophisticated solutions that not only meet but exceed our clients’ expectations, showcasing our ability to handle complex projects with precision, innovation, and strategic foresight. Our commitment to integrating advanced technology with user-friendly interfaces ensures that our clients remain at the forefront of their industries, equipped with the tools they need to secure a competitive edge.