Not all organizations are the same when it comes to data. There are many factors that determine the what/when/how data is collected, analyzed, and presented. However, I think after working with a number of companies over the years, that they fall into four basic levels. For a variety of reasons it can be difficult to move from one level to another.
There are a number of ways in ggplot to express your data. The first are the geometric objects:
- geom_bar(): Bar charts
- geom_point(): Points – great for scatter plots
- geom_line(): Line charts
- geom_boxplot(): A box & whiskers plot
- geom_smooth(): Smoothed means with CI
- geom_histogram(): Histogram
- geom_density(): Smoothed density plot
- geom_qq(): A quantile-quantile plot
- geom_errorbar(): Error bars
All of these geoms (and more) are highly customizable. But first we must set up the data. Continue reading
Excel is great for spreadsheet use. I can remember taking accounting in college, when I was not aware of Excel (before I had a computer – I know, it was a long time ago). We used sheets of paper that we had to adjust manually (erasers were invaluable). Some of the figures were adjusted so many times, that the paper would wear thin. Years later, on discovering Excel, I reflected how much more effective and efficient completing my accounting class exercises would have been if I had only known of its existence. Today, Excel is used for far more than accounting. It is used for data storage, data analysis, reporting, graphing, and a bunch of other stuff that it really is not well suited for. Continue reading
KPIs are the metrics that matter most to your business objectives. These are numbers that, when they change, you stand up and take notice. Most often, KPIs are a combination of more than one metric. For example, ROI is a combination of revenue & cost metrics. Revenue by itself can be considered a KPI, but it would be better if it was measured against something else, like this year’s revenue compared to last year’s revenue or actual revenue compared to goal revenue. Continue reading
With this post I am going to briefly walk through some things about data you many not have thought about. I think that this might give you a different and useful perspective on the nature of data. I’ll start first with the various types of data and data elements. Then I’ll get into some data issues and finish up with data classification and standardization.
Types of Data Generally, data falls into one of three types: