You will get Data Warehouse design for a solid waste management company
Project details
Description: This project designs and implements a PostgreSQL-based data warehouse for a waste management company operating a fleet of trucks to
enable data-driven decision-making. It includes creating reports on waste generation, optimizing truck routes, and tracking performance metrics. Key tasks
involve designing a star schema, populating the warehouse, optimizing queries with materialized views and indexing, writing aggregation queries, and
developing an interactive dashboard using Cognos Analytics for visualization.
Tools Used: Python, SQL, PostgreSQL, IBM DB2, Cognos Analytics, Python Libraries (CSV, Pandas)
enable data-driven decision-making. It includes creating reports on waste generation, optimizing truck routes, and tracking performance metrics. Key tasks
involve designing a star schema, populating the warehouse, optimizing queries with materialized views and indexing, writing aggregation queries, and
developing an interactive dashboard using Cognos Analytics for visualization.
Tools Used: Python, SQL, PostgreSQL, IBM DB2, Cognos Analytics, Python Libraries (CSV, Pandas)
Database Type
MySQL, MS SQL, PostgreSQLWhat's included
| Service Tiers |
Starter
$100
|
Standard
$120
|
Advanced
$130
|
|---|---|---|---|
| Delivery Time | 10 days | 8 days | 12 days |
Number of Revisions | 4 | 0 | 0 |
Schema Diagram | - | - | |
Permissions Setup | - | - | |
Import/Export Data | - | - | |
Admin Panel Setup | - | - |
About Mohamed
Data Engineer
6th of October City, Egypt - 3:42 am local time
Technology Stack:
• Languages: Python, SQL, Bash, NoSQL
• Data Tools: Apache Spark, Kafka, Airflow, Pandas, NumPy
• Databases: PostgreSQL, MySQL, MongoDB, Cassandra
• Big Data: Hadoop, HDFS, Hive
• DevOps: Docker, Git, crontab
• Cloud: BigQuery, Google Cloud Storage, Google Cloud Datastream
Steps for completing your project
After purchasing the project, send requirements so Mohamed can start the project.
Delivery time starts when Mohamed receives requirements from you.
Mohamed works on your project following the steps below.
Revisions may occur after the delivery date.
requirement gathering
Requirement gathering is the process of understanding and documenting what stakeholders need from a system, project, or product. It's the first and one of the most critical phases in any project lifecycle, especially in software development.