Savers was founded in 1954 on principles such as giving back and providing opportunities. Over time, these core values have led to business practices that have forged alliances with over 200 nonprofit organizations (Suppliers), with 300 retail store fronts in four countries. Savers believes that the altruistic nature of these values are a positive aspect of their brand promotion, i.e. – shopping at Savers not only provides a unique shopping experience at an economical price point; Customers feel better because they know their money helps many community support programs. Further, Savers is marketing the notion of reuse, and its positive impact on the global community.
While Savers business model is somewhat unique, Savers is the similar to many Retail operations in that they need to report KPIs across multiple business domain areas, e.g. Finance, Supply, Sales, etc., and they are investing heavily into brand promoting marketing activities including SEO.
Over time, iTrellis consultants have provided the following services to both on the "IT side" e.g. ETL, Warehousing support, and the "Business side" e.g. Dashboards, Reports, and data analysis.
ETL and Data Warehousing: Integration with IT systems, both customer and 3rd-party Commercial Off The Shelf (COTS) Software, e.g. Cognos, establishing data connection points and ETL operations for data migration to centralized Enterprise Data Warehouse. with front end tools, e.g. PowerBI, have optimized queries.
Data Analysis: worked with business and IT teams to understand the business requirements for actionable information, and then analyzing relevant corporate datastores for insights which can be expressed via data visualization, e.g. Power BI, and other more traditional data warehousing tools, e.g. Snowflake Star Schema and Microsoft SSAS, and SSIS.
Refactoring: Consolidation of disparate reports into centralized reporting tools/patterns.
Security: Implemented row level security in DBMS in order to ensure policy and access controls.
Data Marts: Facilitated discussions between business lines and IT to establish data marts for both cyclical reporting as well as what if analysis "sandboxes". Created data for Trouble Ticketing, Finance, Retail, Logistics, and "Supply Chain" (donation based) tracking metrics.
BI Best Practices; Facilitation, Training, and Mentoring: establishing best practices for tool use, team role boundaries, and responsibilities.
BI Strategic Planning and Communications: Helped to improve BI work intake through the creation of a BI "ScrumBan" work planning and tracking process, in conjunction with a BI Product Backlog, and recommendations for Change Management program.