This project is about building a Data Warehouse system for Pet Care services to support better management and analysis of services like consultation, grooming, adoption, boarding, and shopping. The system aims to solve problems such as unstructured medical records, inefficient scheduling, and lack of integrated data. Using a Bottom-Up approach, data from various services are collected, transformed, and stored in a centralized database using MySQL and Python. The design uses a Galaxy Schema for flexibility and efficient analysis across services. Data is visualized using HTML, Chart.js, and Argon Dashboard to create interactive dashboards. This helps Pet Care providers track service performance, customer behavior, and revenue trends more accurately, making decision-making easier and more data-driven.