Workshops
Capacitas have launched workshop events, as a method of providing hands-on training in Capacity Management techniques.Using Microsoft Excel for Effective Capacity & Performance Management
Capacity and performance practitioners traditionally used SAS to undertake analysis and reporting. However, Microsoft Excel is widely available but its capabilities are surprisingly underused, especially its ability to analyse and report on capacity and performance data. This seminar gives practical advice on how to undertake a multitude of tasks using Excel. The workshop is platform independent, using various sources of data in demonstrations, and focuses on providing a value-for-money approach to capacity and performance analytical tools. Topics covered include:
- Pivot tables: manipulating data quickly and effectively; dealing with gaps in data; summarising; creating interval records from event records
- Filtering: custom filters
- Batch modelling: look-up tables; Gantt charts
- Surface plots: combining 24 hour profiles with monthly growth
- Forecasting functions: FORECAST; GROWTH; linear regression with trend-lines, SLOPE and INTERCEPT functions and the Data Analysis wizard
- Creating GIFs: saving charts separately from the workbook; creating HTML
- Automation: creating Visual Basic modules through keyboard macros
- Charts: dealing with too much data; general tips