Inside Atento: Strategies for a Corporate Data Warehouse
summary
Global contact‑center firm standardizes 16-country data into a corporate warehouse on Azure, using SQL Server 2012, SSIS, SharePoint and multi‑dimensional SSAS cubes; ~20–30 ETL packages and per‑country staging schemas feed a single OLAP model. A one‑month POC and agile sprints deliver reports in production weeks, cutting monthly consolidation from 30 days to 5 days, while master‑data alignment takes months; currency conversion to euros, validation calendar and automated cube loads make the solution operational.
AI-written summary · about
chapters (25)
- 0:00Atento introduction
- 1:29Atento global presence
- 3:59Isolated data challenges
- 7:12Manual consolidation inefficiencies
- 10:12Unified data strategy
- 12:20Single project limitations
- 13:25User engagement and quick wins
- 14:08Proof of concept
- 15:17Corporate team training
- 16:18Global definitions standard
- 17:21Minimizing manual operations
- 21:21Ongoing user training
- 22:05Agile system development
- 23:06Collaboration and data sharing
- 25:14Master data management
- 27:03Data warehouse architecture
- 30:37Scalable warehouse design
- 33:29Time consistency and loads
- 38:19ETL automation challenges
- 41:27Adding new countries/sources
- 45:02Data flow to warehouse
- 47:11Flat files and SAP extraction
- 49:04Centralizing SAP and CRM
- 50:09Azure deployment
- 52:35Summary and benefits
related talks
27mHow To Develop & Operate An Agile Cloud Datawarehouse In A Rapidly Changing Multi-ERP Environment
01h 20mData Governance in Large Enterprises
57mOptimize “All Data” with a Modern Data Warehouse Solution
11mBreaking Data Silos: Enterprise Data Management
30mSelf-service data warehousing
44mAgile Data Warehousing/Business Intelligence: Addressing the Hard Problems
36mMigrating Our Data Warehouse to the Cloud
01h 05mWorkflows of Highly Functional App & Data Engineering Teams