Apparel-Mfg-Reporting

// apparel-mfg-reporting

Apparel Manufacturing and Sales Reporting

Business Need
Business Need

Challenges
Challenges

Stakeholders
Stakeholders

Approach
Approach

Results
Results

Business Need

  • Provide visibility of sales, distribution and manufacturing to management.
  • Integrate information from different sources for comprehensive reporting.
  • Allow for growth into new markets and products.

Objective

  • Data warehouse to integrate various data sources
  • Metrics for sales, manufacturing and distribution subject areas
  • Visualizations with reports and dashboards

Stakeholders

  • Leadership
  • Sales
  • Operations
  • Technology

Approach

  • Developed data warehouse and ETL for loading data from ERP, spreadsheets and 3rd party systems
  • Worked with business to identify key metrics and alerts
  • Developed reporting platform with subject area level security
  • Documented and trained support team

Result

  • Daily refreshed reports for senior and line managers
  • Configurable incorporation of new regions and products
  • Supported by internal team for future growth