MongoDB is being used by manufacturing companies to turn their data into business intelligence, enabling them to become more efficient and productive organizations. The real challenge with analytics is ensuring reliable access to relevant data sets, which can be achieved through a combination of data tiering, federation, querying, and visualization. MongoDB provides various options for data tiering, including online archive, Atlas Data Lake, and federated databases, to help companies prepare their data for strategic and operational insights. The proposed methodology leverages MongoDB's different features and third-party integrations to create a single API access for BI/analytics, allowing users to save storage costs while maintaining query ability across hot and cold data. Additionally, MongoDB offers Data Federation endpoints that can be used to store results of querying federated databases instances back in MongoDB clusters or as files in S3 buckets, powering other real-time enterprise or end-user applications.