How rodrigosilva1936/olist-retail-sales-analytics works
The repository appears to be an Olist retail data-warehouse ETL project: SSIS packages are organized around customer, geography, order, product, seller, and related datasets, alongside SQL for staging and warehouse dimensions. The likely outcome is prepared data for analytics, but the README and source excerpts are absent, so execution order, data movement, and package-to-SQL relationships cannot be verified. Components below reflect the tree only; no relationships are asserted.
Components 13
SSIS Loads
- Customers Load
ssis/OlistReatilETL/Load_Customers.dtsx - Customer Dimension Load
ssis/OlistReatilETL/Load_DimCustomer.dtsx - Geolocation Load
ssis/OlistReatilETL/Load_GeoLocation.dtsx - Order Items Load
ssis/OlistReatilETL/Load_OrderItems.dtsx - Order Payments Load
ssis/OlistReatilETL/Load_OrderPayments.dtsx - Order Reviews Load
ssis/OlistReatilETL/Load_OrderReviews.dtsx - Orders Load
ssis/OlistReatilETL/Load_Orders.dtsx - Category Translation Load
ssis/OlistReatilETL/Load_Product_Category_Translation.dtsx - Products Load
ssis/OlistReatilETL/Load_Products.dtsx - Sellers Load
ssis/OlistReatilETL/Load_Sellers.dtsx
Staging SQL
- Staging Schema
sql/staging/Create_staging.sql - Data Quality Checks
sql/staging/Data_quality_checks.sql
Warehouse SQL
- Warehouse Dimensions
sql/warehouse/create_dimensions.sql