Category Archives for "Metrics and Measures"

Top 25 Best Tips on Excel Dashboards

Charts , Dashboards , Excel , Metrics and Measures , Tips , Top Best Tips

This is a collection of tips that will help you create powerful Excel dashboards. This ranked list started by collecting the top Excel dashboard tips from multiple search engine pages. After aggregated the tips I ranked them for usefulness based on 30 years of experience developing Excel dashboards and strategic performance projects. 1. Talk to Users. Build […]

Continue reading

Correlation does not Imply Causation when Calculating Trend Lines

Analysis , Charts , Dashboards , Excel , Formulas , Metrics and Measures

So, just because you got a high R-squared on a trend does not mean you can do predictions with your trend line. It just means that the data trends in the same direction. You can get yourself, and your business, in trouble if you use a trend line for forecast and there is no causation […]

Continue reading

What is a Good R-Squared Value or Is the Fit Good for a Trend Line?

Analysis , Charts , Dashboards , Excel , Metrics and Measures

You’ve probably heard the rule of thumb that if R-squared is .7 or better then the trend line has a good fit to data and in general the higher R-squared is the better it is. However, there are several different types of correlation coefficients and each is appropriate under different conditions. A good approachable article […]

Continue reading

Troubleshooting Your Data Selection for Excel Charts, Databases, Tables, and Lists

Excel , Metrics and Measures , Tips

A lot of the work you and I do in Excel involves lists, tables, or large chunks of data. Learning how to get around these massive areas and learning how to see if you’ve got everything selected is an important skill. You want to avoid that worrisome doubt that there’s an error somewhere… It’s been […]

Continue reading

Exporting Data for Import into Microsoft Excel

Excel , Metrics and Measures , Tips

You can’t always link Excel worksheets, Pivot Tables and PowerPivots directly to a database. Sometimes you have to go back to the old days of text files to get the data you need for your Excel charts and dashboards. Most Excel users will at some point use data that is exported from another computer program. […]

Continue reading

Troubleshooting Text Files Imported into Excel

Excel , Metrics and Measures , Tips

Importing data into Excel can be extremely easy or it can be so frustrating you have to leave your desk and walk around outside while muttering to yourself as your colleagues worry about your mental health. To keep your sanity, check out these tips. Dates that won’t reformat Make sure the date format used in […]

Continue reading

Creating an Actual vs Target Chart in Excel using Floating Markers

Analysis , Charts , Dashboards , Excel , Metrics and Measures

Almost everyone in business has heard the maxim, “What you measure is what gets managed.” We know that measuring is important, but measuring is only the start. If you are going to improve what you are measuring you need targets. And before you start changing you need to know how far off the target you […]

Continue reading

Create Excel Charts and Dashboards with Color Alerts for Actual and Target Values

Analysis , Charts , Dashboards , Excel , Metrics and Measures

Your Excel charts should alert you with color differences between actual and target values. Here’s a quick way to create an Excel chart that shows the color coded difference. In this example the Delta, or difference, is a column containing the calculation, Delta = Actual – Target The chart is created from the month labels […]

Continue reading

Telling the Story Behind Your Data – Awesome Videos with Hans Rosling

Charts , Communication Skills , Dashboards , Excel , Metrics and Measures , Presentation Skills

If you want to make an impact, you have to put a gripping story behind your data. You can have earth shattering data, incredible statistical analysis, and even beautiful charts and visuals, but if you can’t put a gripping story behind it your audience won’t remember and won’t act. If you want to see how […]

Continue reading

Finding the Right Metrics for Your Excel Dashboard

Analysis , Excel , Metrics and Measures

I’ve noticed that dashboards often get started when a manager says something like, “We have to get a handle on these numbers. Let’s make an Excel dashboard so we can all see the trends and changes.” The question that follows is, “Should we track the same metrics?” To which someone else asks, “Well what metrics […]

Continue reading