• A. D sawant
• Tuba Falak Khan
• Faizan Raza
• Humaira shaikh
• Aniket Prabhakar

In the dynamic healthcare landscape, this research explores the variations in medicine demand and supply across regions and seasons. It investigates factors influencing medicine pricing, availability, and the impact of quality and safety on customer satisfaction. The study also delves into the effects of marketing, competition, and regulations on market share and profitability. Amidst heightened healthcare competition, the proposal advocates for a robust Data Warehouse and Business Intelligence Dashboard, utilizing PostgreSQL for healthcare data. The focus is on monitoring sales performance and optimizing medicine delivery efficiency. Embracing Data Warehouse technology empowers companies with enhanced analytical capabilities, fostering successful navigation of the complex healthcare environment .Ultimately, this research aims to equip healthcare organizations to proactively adapt, thrive, and excel in the competitive healthcare sector, leveraging data-driven decision-making for innovation and success in patient care and outcomes.

Data warehouse, Business Intelligence, Kimball lifecycle, OLAP, Healthcare Sales , Analysis

"Implementation of Data Warehouse in Making Healthcare Dashboard Development Using PostgreSQL Database and Kimball Lifecycle Method", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.11, Issue 2, page no.d437-d444, February-2024, Available :http://www.jetir.org/papers/JETIR2402354.pdf

"Implementation of Data Warehouse in Making Healthcare Dashboard Development Using PostgreSQL Database and Kimball Lifecycle Method", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.11, Issue 2, page no. ppd437-d444, February-2024, Available at : http://www.jetir.org/papers/JETIR2402354.pdf