XLK Business Proposition
Overview of the main activities of XLK
Speed
XLReporting
(5s Improvement)
Advanced
Helpdesk
Simplify
Prioritize
- KPIs
- other indicators
Distinguish KPIs
from less important
indicators
Discuss and
agree priorities
Clarify importance
at different levels
Basic Training
(not offered)
XLTraining
(Customized)
Study
Analyze
current
reporting
Challenges
Bottlenecks
Timing
Deadlines
(Output)
Data
Availability
(Input)
Data Sources
Data
Quality
System
Capabilities
Contributors
Workload
Capabilities
Recipients
Real Needs
Wants
Reports
Layout
Content
Show
(Visualize)
Improve
meaning of
reports and
charts for
- trends
- variances
- structures
- etc.
Link to standard
reports
Standardize
formats
Improve/change
existing
Introduce new
Streamline
(Automate)
Minimize manual
- processes
- calculations
- reports
Minimize mistakes
with manual steps
Automate standard
charts
Implement dynamic
links and formulas
Create streamlined
standard reports
Identify manual
reporting steps
People
Capabilities
& Needs
Advanced Training
(Power Users)
OTJ coaching based on
concrete reporting projects
Advanced formulas
(array formulas, 3-dimensional formulas,...)
Depending on needs,
e.g.
Dynamic labeling
Intermediate Training
(Frequent Users)
Charting Do's
and Don'ts
Useful formulas
Pivot Tables
Data modeling
principles
Quality
Standardize
Harmonize
- definitions
- calculations
Derive standard
calculations based on
availability of data
Discuss and
agree definitions
Clarify understanding
at different levels
XLK.
Consulting