The client is premium school chain who have multiple branches across the United States. The client uses multiple source systems to manage the school financial, children and lead generation data. The main aim of this engagement was to consolidate the data from heterogeneous data sources into a single data store and also provide advanced analytical dashboards which would help the senior management in taking key business decisions.