XLK Business Proposition

Honelako gehiago

The 8 Functional Areas of Human Resources

July Alejandra Sierra Velandia‑k egina

no pain no gain

sloan frazarri‑k egina

SOFTWARE QUALITY METRICS

mkti 2012‑k egina

Bussionu 123456789 10

Putsissssss konnnnnnnnnn‑k egina

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