How sqlalan/insightflow works
InsightFlow CTI turns manually maintained Excel customer data into standardized records, persisted commercial data, and dashboard/report insights. The main workflow is spreadsheet upload, validation, Python processing, persistence, and presentation; the repository also includes customer administration and authentication. The README documents the overall architecture, while sampled source supports several internal calls. Some frontend/API wiring and unsampled subsystems are represented only where documented.
Main entry points: api.js API client · index.js Web shell and routing · ImportacaoService.java Import orchestration · analise.py Statistical analysis
Components 22
Vue application
- Web shell and routing
frontend-vue/src/router/index.js - Spreadsheet upload
frontend-vue/src/views/UploadView.vue - Dashboard
frontend-vue/src/views/DashboardView.vue - Reports and export
frontend-vue/src/views/RelatoriosView.vue - API client
frontend-vue/src/services/api.js
Spring API
- Upload endpoint
backend-java/src/main/java/br/senai/ctiinsights/controller/UploadController.java - Spreadsheet validation
backend-java/src/main/java/br/senai/ctiinsights/service/PlanilhaService.java - Import orchestration
backend-java/src/main/java/br/senai/ctiinsights/service/ImportacaoService.java - Python process runner
backend-java/src/main/java/br/senai/ctiinsights/service/AnaliseService.java - Dashboard endpoints
backend-java/src/main/java/br/senai/ctiinsights/controller/DashboardController.java - Dashboard services
backend-java/src/main/java/br/senai/ctiinsights/service/DashboardService.java - Authentication
backend-java/src/main/java/br/senai/ctiinsights/service/AuthService.java - Customer administration
backend-java/src/main/java/br/senai/ctiinsights/controller/ClienteController.java - Customer rules
backend-java/src/main/java/br/senai/ctiinsights/service/ClienteService.java
Python analytics
- Data cleaning
analytics-python/limpeza.py - Statistical analysis
analytics-python/analise.py - Insight generation
analytics-python/insights.py - Chart generation
analytics-python/graficos.py
Commercial data
- Customer records
backend-java/src/main/java/br/senai/ctiinsights/domain/Cliente.java - Customer repository
backend-java/src/main/java/br/senai/ctiinsights/repository/ClienteRepository.java
Other components
- CTI user
- PostgreSQL database
Connections 24
- CTI user → Web shell and routing: uses
README.md - Web shell and routing → Spreadsheet upload: routes to
frontend-vue/src/router/index.js - Web shell and routing → Dashboard: routes to
frontend-vue/src/router/index.js - Web shell and routing → Reports and export: routes to
frontend-vue/src/router/index.js - Spreadsheet upload → API client: submits through
- Dashboard → API client: loads data through
- Reports and export → API client: loads data through
frontend-vue/src/views/RelatoriosView.vue - API client → Upload endpoint: calls API
- API client → Dashboard endpoints: calls API
- Upload endpoint → Import orchestration: delegates to
- Import orchestration → Spreadsheet validation: validates with
backend-java/src/main/java/br/senai/ctiinsights/service/ImportacaoService.java - Import orchestration → Python process runner: runs analysis
backend-java/src/main/java/br/senai/ctiinsights/service/ImportacaoService.java - Python process runner → Statistical analysis: executes script
backend-java/src/main/java/br/senai/ctiinsights/service/AnaliseService.java - Statistical analysis → Data cleaning: imports and uses
analytics-python/analise.py - Statistical analysis → Insight generation: imports and uses
analytics-python/analise.py - Statistical analysis → Chart generation: imports and uses
analytics-python/analise.py - Import orchestration → Customer repository: persists records
backend-java/src/main/java/br/senai/ctiinsights/service/ImportacaoService.java - Customer rules → Customer repository: reads and writes
backend-java/src/main/java/br/senai/ctiinsights/service/ClienteService.java - Customer administration → Customer rules: delegates to
backend-java/src/main/java/br/senai/ctiinsights/controller/ClienteController.java - Dashboard endpoints → Dashboard services: delegates to
backend-java/src/main/java/br/senai/ctiinsights/controller/DashboardController.java - Customer repository → Customer records: stores entities
backend-java/src/main/java/br/senai/ctiinsights/repository/ClienteRepository.java - Customer records → PostgreSQL database: persisted in
README.md - CTI user → Authentication: authenticates with
- Python process runner → PostgreSQL database: feeds persisted results
README.md