Identified core data sources.
Single Source of truth creation
Client was in the business of running & managing theaters. They had developed multiple systems – across different platforms consisting of internal proprietary software, ready-to-use products. There was no uniformity in data sets as individual excel files were used for data collation.
Created detailed data dictionary.
Linked databases using relevant keys to create data mart.
Verified with generally accepted numbers trends