It is crucial for any retail business to understand and keep a track of overall health and effectiveness of its business. This enhances the operational efficiency, enables retailers to make informed decisions and adapt of the dynamic retail landscape. 

The primary objective of this project is to conduct an in-depth analysis of the transaction history of a retail store. The aim is to judiciously allocate performance bonuses to both employees and stores, leveraging key metrics such as sales performance relative to the number of customers served, products sold, and total cart value. This analysis will be executed utilizing MS SQL Server for robust and comprehensive data evaluation.