Index

• Index 📎
• Problem
• Solution
• Requirements
• Sprint Backlog
• Product Backlog
• Schedule
• Team
• Utilized Technologies

Problem

In an increasingly competitive market, understanding the nuances of customer desires becomes crucial to success. Online reviews, in this context, take the form of a treasure trove of insights, revealing consumers' satisfaction, expectations and, at times, frustrations. Given this scenario, this semester's challenge is the development of an innovative application that, using artificial intelligence, performs an in-depth analysis of these comments, classifying them as positive, neutral and negative. By integrating this data into the database, it will be possible to extract valuable insights that will drive strategic decision-making and improve the customer experience.

Solution

Our proposal is HexAnalytics, a platform that will automatically analyze comments, classifying them as positive, neutral and negative. The results of this analysis will be integrated into the database and the platform will present relevant graphical dashboards for valuable insights into customer data and feelings.

Requirements

Functional

• RF-01: Geolocated Sentiment Visualization
• RF-02: Authentication and Session Management
• RF-03: Multisource Integration of Reviews
• RF-04: Advanced Sentiment Analysis
• RF-05: Data Storage and Management
• RF-06: Data Visualization and Reporting

Non-Functional

• RNF-01: Compliance and Security
• RNF-02: Interoperability and Integration
• RNF-03: Performance and Scalability

It was decided that the project would be divided into 4 deliveries, throughout the sprints it will be updated and modified as the deliveries progress.

Product Backlog 📍

Rank	Priority	User Story	Estimate	Sprint
1	Alto	RF-06: As a system administrator, I want a platform with dashboards to visualize the data that my institution has and understand the general opinion in different regions, thereby obtaining insights that will help my managers in making decisions and improving the customer experience.	1	1
2	Alto	RF-01: As a system administrator, I want to explore sentiment data on a map to identify areas with high or low concentration of sentiment.	1	1
3	Alto	RF-05 / RNF-02 / RNF-03: As an administrator, I want a database structure to store sentiment data and location information in an efficient and scalable way.	1	1
4	Alto	RF-06: As a system administrator, I want to visualize sentiment data in different formats such as line, bar, or pie charts to get a more complete view of its distribution.	1	2
5	Alto	RF-06: As a system administrator, I want to filter sentiment data by time period to analyze trends over time.	1	2
6	Alto	RF-04: As an administrator, I want customer comments to be classified into positive, neutral and negative automatically to facilitate analysis.	1	2
7	Alto	RF-04: As a user, I want to view the sentiment analysis results in the visualization dashboard to get a deeper understanding of the sentiments expressed in the data.	1	2
8	Médio	RF-02 / RNF-01: As an administrator, I want other personnel who need to operate the system to register and access the system using login and password to ensure that unauthorized access does not occur and thus guarantee the security of data and users.	1	2
9	Médio	RF-06: As a system operator, I want to have access to all the data to analyze and get insights that helped my managers in decision making.	1	2
10	Médio	RF-02 / RNF-01: As a system operator, I want to view my registration account information to keep it up to date.	1	2
11	Médio	RF-04: As a developer, I try to keep the version of the machine learning (ML) model always up to date, in order to provide my client with the best possible analysis experience.	1	3
12	Médio	RF-02 / RNF-01: As a system operator, I want to view my profile information, such as name, email and registration date, to have quick access to my data.	1	3
13	Médio	RF-02: As an administrator, I want to view information for all users on the system to manage accounts and access.	1	3
14	Médio	RF-02 / RNF-01: As a system operator, I want to delete my account and data from the system if I no longer wish to use the service.	1	3
15	Médio	RF-06: As an administrator, I want to generate custom reports with user and sentiment data to analyze user behavior and identify trends that will be used to gain insights.	1	3
16	Médio	RF-04: As a developer, I try to keep the version of the machine learning (ML) model updated in order to provide my client with the best possible analysis experience, this being the last one for final delivery.	1	4
17	Médio	RF-02: As a user of the system, I want to register my phone number and receive a security code via SMS, so that I can have an additional layer of security and thus have another way to verify my identity when accessing my account.	1	4
18	Médio	RF-06: As a system developer, I want to have copies of data to ensure recovery of improperly deleted data and that changes to system user information meet LGPD requirements.	1	4
19	Baixo	RNF-02: As a user, I want to have access to a button that allows me to select a CSV file on my computer so I can import data into the application and insert it into the database and finally carry out the analysis.	1	4
20	Médio	RF-06: As a manager, I want to receive alerts about changes in customer sentiment patterns towards products, so I can anticipate and make the necessary adjustments to improve our customers' experience.	1	4

Sprint Backlog:

Schedule 🗓

Sprints	Date	README
Kick-Off	11/03 to 24/03	N/A
Sprint 1	25/03 to 14/04	View
Sprint 2	15/04 to 05/05	View
Sprint 3	06/05 to 26/05	View
Sprint 4	27/05 to 16/06	View

Team 👩‍💻

GitHub	Name	Position	LinkedIn
	Gilberto Santos	Scrum Master
	Valdiney Nascimento	Product Owner
	Michel Rubens	Developer
	Patrick Souza	Developer
	Helen Alevato	Developer
	Ludmila Chagas	Developer
	Abraão Vasconcelos	Developer
	Augusto Santos	Developer

Utilized Technologies 📉

Back	Front	Database	Others

HexTech - Technology Solutions

Development repository for FATEC Prof. Jessen Vidal 6th semester
Imagem | Esri Official Distributor [Link]