Nowadays consolidated data insights is an essential competitive advantage for companies. As Delta embarked on an ambitious growth strategy to establish itself as Italy's premier pharmacy network, consolidated data insights became essential to effectively scale operations across 300 locations without compromising quality of care or service. However, in the current common scenario data collection remained siloed within separate Microsoft Business Central instances, hindering strategic planning efforts. To overcome these constraints, Delta has decided to enlist PwC consultants to modernize its reporting infrastructure. The project lasted 6 months and it has been divided into different phases. The first part of the project consisted of an initial assessment.