Steam Data Warehouse

Repository for the Data Warehouse project for SEDS

📄 The data source for the database is obtained from Sources

📊 Analysis/Statistics of the database: Reports📋

🖨️ Import scripts: Imports

📜 Seminar: Seminar

Project Structure 📐

• DWbaza: Data Warehouse model.
• ReportTemplates: Report files for Pentaho Report Designer
• Reports: PDF reports generated by Pentaho Report Designer
• SQLImports: Contains SQL scripts for importing data into the database.
• SRCbaza: Source Database model.
• Scripts: Miscellaneous scripts for extracting data.
• Transformations: Transformation files for data - Pentaho Data Integration.
• Bus Matrica.xlsx: Excel file containing the Business Matrix.
• DWbaza.dmd: Data Model Diagram for the Data Warehouse database.
• SRCbaza.dmd: Data Model Diagram for the Source database.
• Source.txt: Text file providing additional information about the data source.

Feel free to explore and contribute to the project! If you have any suggestions or improvements, please open an issue or submit a pull request.