|
© 2007 KnowWare
International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224
Jay Arthur
888-468-1537
303-756-9144
Email Us
We help people think!
|
|
Measurement Dashboards
Learn how to use Microsoft Excel to create measurement dashboards and
scorecards customized to your needs.
You might want to create a measurement dashboard that consists of a balanced
scorecard, key performance indicators, visual scorecards, or control charts
and histograms:
Balanced Scorecard
To show the relationship among your key performance indicators.
Key Performance Indicators
To show the current status of your performance.
Color Coded Scorecards
To visually report the status of your metrics.
Control Charts and Histograms
For better analysis of process performance.
Measurement Dashboards and Leadership Scorecards
Jay has just taken everything he knows about creating these management
tools and put them into an e-book that you can download right now.
It contains step-by-step instructions for:
- Choosing the right measurement, because what gets measured,
gets done. Choosing the wrong measures can set your unit on a course
for disaster.
- Setting up your data for optimal ease of entry
- Creating your charts with Excel's Chart Wizard
- Organizing your charts into a dashboard
- Creating visual scorecards using Excel's formatting features.
- Advanced analysis of your line-item data with Excel's Pivot
Table function. He also shows you how to analyze text-oriented comment
fields using the COUNTIF function. This section alone will save you
tons of time.
- Adding control charts and histograms to your dashboard using
the QI Macros Control Chart Templates. Simple line and bar graphs aren't
enough to adequately analyze your performance. You need control charts
and histograms that show you whether the process is stable and capable
or out of control so that you can take immediate corrective action.
Best of all, it's so easy to paste your data into the control chart
templates and let Excel automatically update your charts.
This e-book is available in PDF format for immediate download. It will
save you hours and even days every month of time-consuming charting.
Investment: $97
It's not available in print, only downloadable e-book format. Get your
copy now.
Measurement Dashboard and Leadership Scorecards $97
© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home
| Lean Six Sigma
| QI Macros
| KnowWare
| Site Map
|
|
