How odonoso/proyecto_bi_usm works
Kent Foods is a business-intelligence project that turns operational sales and dispatch records into a dimensional warehouse for management analysis. Its documented workflow is source database → automated SSIS ETL → star-schema warehouse; the ETL prepares time and dimensions before loading sales-line facts. The README also defines sales, supplier, and delivery KPIs, and the tree contains an Analysis Services cube project. Source excerpts were unavailable, so relationships beyond those explicitly described in the README are omitted or marked unverified.
Main entry points: Package.dtsx SSIS ETL package · build_script.sql Warehouse schema · README.md Business KPIs · poblar_tiempo_script.sql Time generation
Components 16
Business users
- Business KPIs
README.md
ETL processing
- SSIS ETL package
etl/KentFoodETL/Package.dtsx - Time generation
database/scripts/poblar_tiempo_script.sql - Customer load
- Employee load
database/scripts/cargar_dim_empleado.sql - Product load
database/scripts/cargar_dim_producto.sql - Sales fact load
database/scripts/cargar_fact_detalle_venta.sql
Dimensional warehouse
- Warehouse schema
database/scripts/build_script.sql - Customer dimension
- Employee dimension
database/scripts/cargar_dim_empleado.sql - Product dimension
database/scripts/cargar_dim_producto.sql - Time dimension
database/scripts/poblar_tiempo_script.sql - Sales detail fact
database/scripts/cargar_fact_detalle_venta.sql
Analytics
- Multidimensional cube
olep/proyecto_sass/ProyectoMultidimensional1/ProyectoMultidimensional1/Kent Foods DW.cube
Other components
- Owner and management
- KentFoods OLTP
Connections 7
- KentFoods OLTP → SSIS ETL package: provides source
README.md - SSIS ETL package → Warehouse schema: loads warehouse
README.md - SSIS ETL package → Time generation: generates time
README.md - SSIS ETL package → Customer dimension: loads dimension
README.md - SSIS ETL package → Sales detail fact: loads last
README.md - Owner and management → Business KPIs: uses for decisions
README.md - Warehouse schema → Multidimensional cube: feeds analytics