Summary: In this newsletter... |
- New Workshop: Using Microsoft Excel for Effective Capacity & Performance Management
- Special Event: A double seminar on Business Capacity Management and Outsourcing
- Forthcoming training courses including next month's Capacity Planning: Tools & Methods
- New White Paper: Automated Detection of Workload Profile Changes
- New Announcements and Presentations at UKCMG 21st Annual Conference
- Free Capacity and Performance Tool: Excel add-in for queuing modelling
Forthcoming Workshops |
Using Microsoft Excel for Effective Capacity & Performance Management
A one-day workshop, 13th June, 09:00-17:00
The Hatton, Hatton Garden, London, EC1N 8HN
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
Feedback from attendees of previous events can be found by following this link. This workshop will cost £450+VAT. For the first workshop only if you register on or before 12th May this will be subject to a £100+VAT discount or a voucher worth £200+VAT off any subsequent Capacitas course or workshop. This offer only applies to the event on the 13th June and cannot be used in conjunction with any other course or seminar discount offer. To register please email Excel for Capacity & Performance Workshop, or call 020 7841 7431. More details...
Forthcoming Seminars |
|
*** Special Offer: Reduced fee for booking the double seminar *** Book both of the following seminars (12th June, AM and PM) at the special reduced fee of £155+VAT, or if booked on or before the 12th May an early-bird fee of £125+VAT. To register please email Double Seminar Offer, or call 020 7841 7431. Feedback from previous attendees can be found on the web page here. |
|
Business Capacity Management Seminar A half-day seminar, 12th June, 09:30-12:30 Business Capacity Management is becoming a mandatory requirement as IT aligns with the business and ITIL Service Management is adopted. Capacitas has extensive experience of providing effective Business Capacity Management to its clients, via project engagements and outsourcing. This popular half-day seminar on Business Capacity Management covers:
This seminar costs £99+VAT and includes a question and answers panel session and a buffet lunch (12:30-13:30). If you register on or before 12th May this will be subject to a 33% discount. To register please email BCM Seminar, or call 020 7841 7431. More details... |
|
Capacity & Performance Management - The Key to Successful Outsourcing A half-day seminar, 12th June, 14:00-17:00 Capacitas will be presenting a half-day seminar on Outsourcing and Capacity Management. This seminar is designed to:
This seminar includes a question and answers panel session and costs £90+VAT, but if you register on or before 12th May this will be subject to a 33% discount. To register please email Outsourcing Seminar, or call 020 7841 7431. More details... |
|
Forthcoming Training Courses |
|
*** Special Offer *** Any bookings received for Capacitas training courses between 18th April and 12th May qualify for the Using Microsoft Excel for Effective Capacity & Performance Management workshop at a reduced fee of only £200+VAT, a saving of 56% (£250+VAT). Please note that this offer cannot be used in conjunction with any other discount offer. |
|
*** This month's featured course *** The Capacity Planning: Tools & Methods course is our foundation skills course designed to teach the capacity or performance analyst a wide range of techniques that can be used in their work including: forecasting; workload characterisation; regression analysis; threshold alerting; demand planning; and analytical and simulation modelling. This comprehensive course is aimed at the practitioner, is a prerequisite for the other technology specific Capacitas courses, and contains numerous 'consultant's tips' that can be applied rapidly within your organisation. Book now for the 16th-19th May. Group discounts available. |
London, UK, Training Centre:
| Capacity Planning: Tools & Methods | 16th–19th May |
| Capacity Planning Storage Area Networks (SANs) | 14th–16th June |
| Capacity Planning & Performance Tuning of Solaris/Linux | 20th–23rd June |
| Capacity Planning Windows 2000/2003 | 18th–20th October |
Please click on the above links to review the course descriptions or email us at Capacitas Training. More details...
|
Recently Published Material |
Automated Detection of Workload Profile Changes
Capacity planners typically want to understand the demand profile on a system over a period of time. For example, the daily demand profile of an online booking system would differ from that of an ATM. This analysis is called workload profiling. This article outlines a simple approach to automatically determine if a workload profile has changed over a period of time. The examples given in this article deal with daily workload profiles. The approach can be extended to include weekly and monthly profiles. More details...
Please see our Research section for a selection of white papers and presentations on various areas of performance assurance and capacity management. More details...
Forthcoming Conferences & Exhibitions |
UKCMG 21st Annual Conference, 26th-28th June 2006
UKCMG is celebrating its 21st Annual Conference in 2006 and as such has attracted a large number of overseas speakers and previous Chairmen. At the conference Capacitas will be announcing:
- New leading-edge seminars on topics affecting capacity & performance staff
- A new hands-on workshop to complement our existing course syllabus
- A new introductory masterclass
- A new course in our platform-layer syllabus
- ...and a surprise product!
All these will be announced at our vendor session (Monday 26th June, 13:25-13:55). Capacitas staff will be on hand to discuss our market-leading syllabus of training courses and programme of seminars. We will have a range of our course and seminar material available for you to review, please find us at stand 12 (see: UKCMG 2006 exhibiton layout).
In addition Capacitas staff will be presenting on the following topics at this event:
- A Ten-Step Plan to Effective Capacity Management
(Neil McMenemy & Andy Bolton) - Cost-Effective Capacity Modelling: A Real-Life Case Study
(Paul Seaton-Smith)
The presentation material will be available after the event on our website Research area. The UKCMG 21st Annual Conference is being held at the Chesford Grange hotel, near Warwick.
Free Capacity & Performance Tool |
Capacitas Microsoft Excel Add-In
Capacitas have released a Microsoft Excel Add-In to support capacity and performance modelling of ICT systems using Excel worksheet functions. Further details are available here.
|
Recent Customers of Capacitas |
Recent customers of Capacitas include: Royal Bank of Scotland, GlaxoSmithKline, Unilever and Yahoo!. For more details on what some of our customers have to say about us please have a look at our Testimonials page.
Capacitas Services |
If you are interested in learning more about our services please email Enquiries, or call +44 (0) 20 7841 7431.
About Us
Capacitas is a UK-based consulting, training services and outsourcing company focussed on ICT performance, capacity and cost.
Consulting
Capacitas offers consulting services, focussed on ICT performance, capacity and cost management, covering areas such as design assurance, modelling, planning and auditing.
Training
Capacitas offers world class training in Information and Communication Technology (ICT) Performance and Capacity Management.
For further details click on the image below to download a copy of our training brochure (890 KB).
Home | About | Privacy | Code of Professional Practice | Contact Us
Copyright © 2002-2006, Capacitas Limited. All rights reserved.