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