Have you ever taken a survey at the doctor or for a job interview and wondered what exactly that data was used for? There is a long-standing series of methodologies, many coming from psychology, on how to reliably measure “latent” traits, such as depression or loyalty, from self-report survey data.  ...

Next week is my first installment of live training offered through O’Reilly Media’s online platform. I’m so excited to partner with this outstanding organization to deliver workshops on business analytics. My first two courses will offer a unique perspective on SQL and R. For each, I will ...

As a blogger and curriculum developer, I am often writing about R from a text editor instead of RStudio. I feared that working outside RStudio meant saying goodbye to fantastic hotkeys it provides. Isn’t there a way, I wondered, to set up a keyboard shortcut on my computer so ...

Very happy to share that my DataCamp course “Survey and Measure Development in R” is now available. Check it out here — the first chapter is free. From the course description: How can we measure something like “brand loyalty?” It’s an obvious measure of interest to marketers, but we can’...

I have had a long history with Excel TV and, like Excel TV (and Excel itself) the channel has changed over the years. Gone are their regular live-streaming interviews with leading Excel authorities. Excel TV’s main product is now online courses. These are pre-recorded classes taught by the same ...

A recent project of mine has been setting up a Twitter bot on innovation quotes. I enjoy this project because in addition to curating a great set of content and growing an audience around it, I have also learned a lot about coding. From web scraping to regular expressions to ...

This post serves as a follow-up on a previous post about scheduled collection of Weather.gov’s XML feed in R, which itself was a follow-up to retrieving real-time data from Weather.gov in Excel. Reflecting on the best way to accomplishing this automation, I noticed something back on Weather....

One of my most popular posts is on retrieving real-time weather into Excel. A common question here is how to get recorded weather updates; that is, keep a log of the weather updates for a specific place. For that I will write an R script to parse weather.gov’s ...

I am a regular attendee at the Greater Cleveland R Users Meetup and participated in the September 2018 Lightning Talks, in which a series of speakers gave ~8min presentations on talk running the gamut of R. My presentation came from the social science research world: statistical mediation. In my graduate program ...