Defining roles/priorities
by Rosie Low
1. Bespoke 'Applications'/Reports
1.1. Forecasting Tool
1.2. WSSI
1.3. FOS Tracker
1.4. Supplier Forecast Reports
1.5. Promotions
1.5.1. Agreed Volumes
1.5.2. Promo tracker (Wines)
1.6. Attribute Clustering
1.7. Back up stocks
1.8. Others.. JC/MH
1.9. Working Capital - Base Line Reports
1.10. Provisioning Reports
1.11. Morning report
2. Tools
2.1. Business Objects
2.2. SAS Foundation
2.2.1. Multiple data sources
2.3. Enterprise Guide
2.4. Access
2.5. Excel
2.5.1. Pivots/Funtions
2.5.2. Macros/Controls
2.5.3. Visual Basic for Applications
2.6. Windows Scheduler
3. Scheduling reports/projects
3.1. Saves time
3.2. Responsibility for maintaining/housekeeping?
3.3. Data security
4. Responsibilities/Accountabilities
4.1. Support for Demand Planners/Stock controllers
4.2. Training/sharing skills
4.3. Providing information for managers/leadership team
4.4. Investigating opportunities
4.5. Recommending opportunities - new ideas
4.5.1. Building on high level ideas
4.5.2. New ideas
4.5.3. Investigating how others in the industry work
4.6. Providing information/tools to enable efficiencies in the department
4.7. Reporting
4.8. Producing documentation / standard operating procedures
4.9. Forecasting Queries
4.10. Technical support on system/tools
4.11. Continuous Improvement
4.11.1. Practitioners?/Management
5. Who
5.1. Forecasting Analyst (DEV)
5.2. Forecasting Analyst (BAU)
5.3. Analyst, Supply Chain Ops
5.4. Business Analyst
5.5. Configuration and Planning Analyst
5.6. Capacity and Flow Analyst
6. Skills
6.1. Analytical
6.1.1. Analysis is the process of breaking a complex topic or substance into smaller parts in order to gain a better understanding of it.
6.2. Problem solving
6.3. Stakeholder management
6.4. Gathering requirements
6.5. Process mapping
6.6. Influencing
6.7. Clear communications of ideas and recommendations
6.8. Data extraction/manipulation
6.9. Programming
6.10. Data modelling
6.10.1. Forecasting
6.10.2. Statistics
6.11. Statistics
6.12. 'Tech support'
6.13. 'Data management'
7. Data Requests
7.1. Scheduled extracts
7.1.1. Sales/stock
7.1.2. Reserves
7.1.3. Live sales
7.1.4. OSA
7.1.5. EComm orders (imported)
7.2. Data security
8. Future
8.1. Business Intelligence
8.1.1. Dashboards
8.1.2. Data capture for data warehouse