XLK Business Proposition

More like this

COCA-COLA PRODUCTION

by jesus cuello

COMPARATIVE/SUPERLATIVE

by Hilda Alonzo

What Occupations Align With Who I Am?

by Cameron Chong

PQM201B

by Mark Philbrick

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