RADIANCE BLOG

Category: Stuff We Like

Tuft & Needle: Incredible Mattresses. Incredible research?

If you have ever received a proposal from Corona Insights regarding customer research, you may have seen this line:

“We believe that surveying customers shouldn’t lower customer satisfaction.”

We take the respondent’s experience into account, from the development of our approach through the implementation of the research (e.g., survey design, participant invites, etc.), even in our choice of incentives. We work with our clients on an overall communications plan and discuss with them whether we need to contact all customers or only a small subset, sparing the rest from another email and request. For some clients, we even program “alerts” to notify them of customers that need immediate follow-up.

As such, I’m always interested to see how other companies handle their interactions when it comes to requesting feedback. Is it a poorly thought out SurveyMonkey survey? Personalized phone call? Or something in between?

Recently, I was in the market for a new mattress and wanted to try one of newer entrants shaking up the mattress industry. I went with Tuft & Needle, and while I won’t bore you with details of the shopping experience or delivery, I found the post-purchase follow-up worth sharing (hopefully you’ll agree).

I received an email that appeared to come directly from one of the co-founders. It was a fairly stock email, but not with overdone marketing content or design, and it is easy enough to mask the email to make it appear to come from the founder. In it, it had one simple request:

“If you are interested in sharing, I would love to hear about your shopping experience. What are you looking for in a mattress and did you have trouble finding it?”

The request made clear that I could simply hit reply to answer. So I did.

I assumed that was it, or maybe I’d get another form response, but I actually got a real response. One that was clearly not stock (or at least not 100% stock – it made specific references to my response). It wasn’t the co-founder who had responded, but another employee, but still impressive in my opinion.

So, what did they do right? What can we take away from this?

  • Make a simple request
  • Make it easy to reply to
  • Include a personalized acknowledgement of the customer’s responses

Maybe you think this is something only a start-up would (or should) do, but what if more companies took the time to demonstrate such great service, whether in their research or their everyday customer service?


If you are traveling to watch the eclipse, be prepared

Solar Eclipse. The moon moving in front of the sun. Illustration

As a bit of a space geek (don’t even get me started on my love of SpaceX), I’ve been planning for this weekend for a long time.  I bought my eclipse sunglasses and started looking into lodging over a year ago, so you can imagine how excited I am for this event.

Unfortunately (or fortunately, depending on how you look at it), it seems I’m not the only one who will be traveling north to watch the total solar eclipse.  (Though you can see the sun 92% obscured in Denver, it won’t be anything like the experience of totality.)  This has CDOT issuing all sorts of warnings about traffic over the weekend.  I was curious about how much of a doomsday prediction these warnings were, so I conducted a quick Google Survey to find out.

Though these surveys aren’t near as robust or scientific as the surveys we at Corona do for our clients, they are a great way to get a quick feel for how the public feels about an issue.  In this case, I simply asked 125 Colorado residents if they were planning to travel north and, if so, where they planned to travel to.  The results?

Again, these are very rough numbers, but with 20% of those surveyed saying they are planning to travel to see the eclipse (out of 5.5 million Coloradans), that could mean that as many as 1.1 million Coloradans will be on the highway on Monday.  CDOT’s estimate of 600 thousand traveling to Wyoming doesn’t seem far off from the 550 million estimate this quick survey would indicate.

So what to do?  Here are my recommendations:

  • Go anyway! Seriously, this won’t happen within easy driving distance of Colorado for another 30 years, and everyone I’ve heard speak about the experience says it’s completely surreal and unlike anything else you will experience.
  • Plan for safety. If you have somehow been living under a rock and missed all of the safety warnings about needing eclipse glasses, here’s another one.  Don’t look at the sun (except during totality if you travel north) without using eclipse glasses.    If you don’t already have them, you can try finding them at local libraries or hardware stores.  And if you can’t find them, check out community events where you could borrow from someone.  The process of the eclipse will take a total of almost 3 hours, so it shouldn’t be a problem to trade glasses here and there.  And if you still can’t make that work, there’s always a pinhole camera.
  • Plan for a good location. Many small towns in the path of totality are hosting events to watch the eclipse.  That’s a much better option than planning to just stop at the side of the road somewhere.
  • Plan for the worst-case traffic scenario. Though my hope is that everyone will be spread out enough that traffic won’t be as bad as CDOT fears, it’s a possibility that they’re entirely correct.  Get gas early so that you don’t have to wait at overcrowded gas stations.  Plan a variety of routes to get to and from your destination.  Take food and water in the car so that you don’t have to swarm the handful of restaurants in the area that aren’t equipped to handle this kind of volume.
  • Have fun! Try and relax, take your time when traveling, and enjoy the experience for what it is. Even if it takes way longer than you expect to get home on Monday, this may be the only time in your life that you get to experience something like this.

I’ll be out of the office on Monday, and I hope that many of you will be as well.  Enjoy the experience, and cross your fingers for clear skies!


Researching things that go boom

OK, so there may not be a lot of actual research going on in this post, but we at Corona have a wide variety of interests and sometimes like to show those off too!  One such interest is that I have been shooting professional fireworks shows for over 20 years.  I got my start in helping out my dad back when I was in high school (and when the regulations for the minimum age for helping on a show were more…loosely enforced).  Since then, it’s been a summer hobby of mine for years.

Though everyone knows what fireworks are like when they explode, I have found over the years that very few people have any idea what it takes to put on a good show!  Even for a relatively small show (I was in charge of the show in Lafayette, Colorado for 5 years), it takes a crew of at least 5-6 people an entire day to get ready for the big event.  Here’s a quick overview of the steps involved!

  1. Place and secure the mortars. Nearly all aerial fireworks are shot out of mortars (tubes), so the first step is to distribute large racks of mortars and secure them using braces, sand bags, or even burying them.  Professional fireworks are really powerful, and failing to properly secure the mortars to ensure safe operation can lead to disastrous results.
  2. Distribute and load the fireworks. This is possibly the easiest part of the process to understand, but it is also one of the most dangerous steps.  Crew members distribute the shells according to the plan and carefully drop them into their assigned mortar.  While every precaution is taken to ensure that devices are safe during this process, it’s not unheard of for a shell to ignite while being dropped into a mortar, so it’s important to keep body parts away from the top of a mortar!
  3. Wire everything up. Though it is possible to ignite a professional firework device by hand, a vast majority of shows are set off electronically.  That doesn’t necessarily mean computerized, but it means that an electric match is inserted into the fuse of the firework so that it can be lit from a safe distance.  (If you’ve ever fired off a model rocket, it’s the same concept.)  Once the e-matches are inserted, each is wired to a “rail” with a designated ID number so that we can set off that shell exactly when we want to.
  4. Connect the firing board and test everything out. I often describe the function of a firing board as being like a big kids’ version of the game of Operation.  There is a stylus with a metal tip and a wire coming off of it, and when you touch the stylus to a terminal, it completes the circuit, igniting the e-match and sending the shell airborne.  Before we do that, however, we always test everything out to make sure that our wiring is in good shape to shoot the show.
  5. If everything goes well, everything will be loaded, wired, and tested with plenty of time to spare (since weather or other issues sometimes cause delays).  Most of the time, though, there is time to sit, relax, and enjoy a nice, summer evening.
  6. Shoot the show! This part is just as fun for the crew as it is for the audience.  All of our hard work in the hot sun pays off for 20-30 minutes as we get to satisfy our inner pyromaniacs and blow up a ton of stuff in a short time!  It’s always a blast (pun intended).
  7. Clean it up and go home! You’d be surprised at how much work goes into cleaning up after a fireworks show.  Not only do we have to haul all of the equipment back into a truck that same night, we also have to safely inspect the shoot site to ensure that no fireworks are left in mortars and that there aren’t any “dud” shells that came down in the area.  It’s not the most glamorous part of the show and usually takes at least 2-3 hours, so the crew usually doesn’t leave until well after midnight.

Fireworks shows are a lot of fun for both the audience and the crew, but it is definitely a ton of work that requires a special type of worker to enjoy.  (Spoiler alert: fireworks crews aren’t paid like kings.)  I hope that this inside look will help you to appreciate all of the work that went into making your 4th of July holiday memorable!


Ugh, Millennials

Is anyone else tired of talking about millennials? Millennials have seemingly been on everyone’s mind, with many worrying over their spending habits, charitable giving, large debt, voting behaviors, and other things. Why do we care so much about this generation? Don’t they already have a problem with entitlement and being all about “me me me”; we probably shouldn’t feed into that, right?

Pictured: Gregory (myself) the Millennial
Fun fact: depending on where you draw the line, 70% of Corona staff are classified as millennials.

As annoying as it might be, there are some very good reasons to focus on the millennial generation. The baby boomer generation is now on the decline and currently there are 11 million more millennials. It is estimated that millennials will comprise over a third of adult Americans by 2020,  up to 75% of the American workforce by 2025, and currently account for over one trillion dollars in consumer spending in the U.S. Despite this, millennials have less money to spend and are encumbered with greater debt. Perhaps unsurprisingly, the conclusion is that millennials are important because they are the new money – they are very quickly becoming the largest group of consumers and are therefore greatly impacting all businesses and organizations.

The millennials, as a generation, share some commonly seen characteristics:

… and the facts don’t end there. If you haven’t already, I highly encourage you to pour over some of the linked materials to familiarize yourself with this impactful generation. If they haven’t yet, millennials will be disrupting your organization sometime in the near future, and it’s inescapable that we all need to adapt.


State of Our Cities and Towns – 2017

For many years, Corona has partnered with the Colorado Municipal League to conduct the research that is the foundation of their annual State of Our Cities and Towns report. CML produced the following short video, specifically for municipal officials, about the importance of investing in quality of life:

Learn more, view the full report, and watch additional videos on the State of Our Cities website.


Nonprofit Data Heads

Here at Corona, we gather, analyze, and interpret data for all types of nonprofits.  While some of our nonprofit clients are a little data shy, many are data-heads like us!  Indeed, several nonprofits (many of which we have worked for or partnered with) have developed amazing websites full of easy to access datasets.

Here are 4 of my favorite nonprofit data sources…check them out!!

The Data Initiative at the Piton Foundation

Not only do they sponsor Mile High Data Day, but the Piton Foundation produces a variety of user friendly data interfaces.  I really like the creative ways they allow website visitors to explore data–not just static pie and bar charts. Instead, their interface is dynamic and extremely customizable. While their community facts tool pulls most (but not all) of its data from the US Census, this tool is very easy and fun to use.  Further, they have already defined and labeled neighborhoods across the Denver Metro area, making it easy for users to compare geographies without trying to aggregate census tract or block group numbers. This is an invaluable feature for data users who don’t have access to GIS. I also appreciate the option to display margin of error on bar charts when its available.

Highlights:

  • Easy to use from novice to expert data user
  • Data available by labeled neighborhood
  • 7-County Denver Metro focus

Explore

OpenColorado

With over 1,500 datasets, OpenColorado is a treasure trove of raw data.  While this site doesn’t have a fancy user interface, it does provide access to data in many different file types, making it a great website for the intermediate to advanced data user with access to software such as GIS, AutoCAD, or Google Earth.  Most data on OpenColorado is from Front Range cities (e.g., Arvada, Boulder, Denver, Westminster) and counties (e.g., Boulder, Denver, Clear Creek), but unfortunately it is far from a comprehensive list, so you’d need to look elsewhere if your searching for information from Arapahoe County, for example.

There are over 200 datasets specific to the City and County of Denver.  I opened a few that caught my eye, including the City’s “Checkbook” dataset that shows every payment made from the City (by City department) to payees by year.  I give kudos to Denver and OpenColorado for facilitating this type of fiscal transparency.  I also downloaded a dataset (CSV) of all Denver Police pedestrian and vehicle stops for the past four years, which included the outcome of each stop along with the address, latitude and longitude.  For a GIS user, this is especially helpful if you want to search for patterns of police activity compared to other social and geographic factors.  Even without access to spatial software, this dataset is useful because it includes neighborhood labels.  I created a quick pivot table in Excel to see the top ten neighborhoods for cars being towed (so don’t park your car illegally in these neighborhoods).

Highlights:

  • Tons of raw data
  • Various file types, including shapefiles and geodatabases that are compatible with GIS, and KML files that are compatible with GoogleEarth
  • Search for data by geography, tags, or custom search words

Kids Count from the Colorado Children’s Campaign

Kids Count is a well-respected data resource for all things kids.  Each year, the Colorado Children’s Campaign (disclaimer, they are also our neighbor, working just two floors below us) produces the Kids Count in Colorado report, which communicates important child well-being indicators and indices statewide and by county when available.  The neat thing about Kids Count is that it’s also a national program, so you can compare how indicators in a specific county compare to the state and nation. In addition to the full report available as a PDF, you can also interact with a state map and point and click to access a summary of indicators by county.  Mostly, their data is not available in raw form, but their report does explain how they calculated their estimates and provides tons of contextual information that makes their key findings much more insightful.

Highlights:

  • Compare county data to state and national trends
  • Reports include easy to understand analysis and interpretation of data
  • Learn about trends overtime and across demographic groups

Outdoor Foundation

If you’re looking for information about outdoor recreation of any type in any state, there is probably an Outdoor Foundation report that has the data you’re seeking.  Based in Boulder, Colorado, the Outdoor Foundation’s most common reports communicate studies of participation rates by activity type, both at a top level and also by selected activity types such as camping, fishing, and paddle sports (haven’t yet heard of stand-up paddle boarding?  It’s one of the fastest growing in terms of participation).  The top-line reports show trends over the past ten years, while the more detailed Participation Reports break out participation, and other factors such as barriers to participation, by various demographics.  Multiple other special reports, focusing on topics such as youth and technology, round out what’s available from this site.

The participation and special reports are helpful, but I’m most impressed with the Recreation Economy reports, which are available nationwide and within each state.  These reports estimate the economic contribution of outdoor recreation, including jobs supported, tax revenue, and retail sales.  For example, the outdoor recreation economy supported about 107,000 jobs in Colorado in 2013.  Unfortunately, the raw data is not available for further analysis, but the summary results are still interesting and helpful.

Explore:


Art meets architecture in Denver this weekend

Looking for something fun to do this weekend in-between rides on the new A Line to DIA? Check out the arts and cultural activities during Doors Open Denver. Art meets architecture through pop-ups ranging from a nomadic art gallery to poetry, drama, and music performances among the 11 offerings. My favorite? Graffiti art. If you’ve been secretly wanting to learn the art of graffiti painting – and you’re 55 or older – then we’ve got the creative outlet for you. Bust through stereotypes as you create graffiti art inspired by two of Denver’s architectural gems.

  • April 23rd, 1-3 pm – Saturday’s pop-up will be hosted by Clyfford Still Museum on their front lawn. Clyfford Still Museum will give 4 – 20 minute architectural tours each day at 11:00, 11:30, 2:00 and 2:30.
  • April 24th, 1-3 pm – Sunday’s pop-up will be hosted by the new Rodolfo “Corky” Gonzales Library and include 3 tours led by architect Joseph Moltabano of Studiotrope, a Denver-based architecture and design agency. DPL staff will share how the library’s design informs their work. Since Sunday is Día del Niño the artist will be prepared to host a multi-generational event at the library.VSA Colorado/Access Gallery

Thanks to our collaborative partners: VSA Colorado/Access Gallery, studiotrope design, Denver Public Library, Studiotrope Designand Clyfford Still Museum. I’d like to give a special shout out to Damon McLeese of Access Gallery; Joseph Montalbano  of DPLstudiotrope; Ed Kiang, Viviana Casillas and Diane Lapierre of DPL; and Sonia Rae of Clyfford Still Museum.

Please join me in thanking the Bonfils-Clyfford Still Museum Stanton Foundation for funding this engaging spotlight on art and architecture.

For more information visit this Doors Open Denver link. 


Your Baby Is Increasingly Special and Unique, Apparently

It seems like when I’m in the mall and hear parents talking to their kids, I hear unusual names more and more often.  I’ve been developing a theory that parents are enjoying creativity more and valuing tradition less when that birth certificate rolls around, so in keeping with Corona Insights tradition, I thought I’d explore it a little more with some data analysis.  Off I went to the Social Security Administration website to put together a database of names.

I took a look at the most popular baby names in 2014, and compared them with those of 2004, 1994, 1984, and so on, all the way back to 1884.  Are unusual names more common in 2014?  It was straightforward to analyze, even if it meant sifting through a lot of data.

First, I looked at the 30 most popular names in each decade, and compared them to the total number of babies born.  If there’s a trend toward giving babies more unusual names, then we would expect a smaller concentration of babies with the most common names.

And wow, is that true, particularly for girls.  Let’s examine female names first.

If we look at the 30 most common female baby names, they constituted 41 percent of baby girl names in 1884.  There was some variation over the next 70 years but not much, ranging from 36 to 43 percent.  In 1954, the figure still stood at 40 percent for the girls destined to duck under their desks in the Cold War.  (As an important methodological note, recognize that these aren’t the same 30 names that were most common in 1884 – I adjusted the top 30 in each decade to reflect the most popular names of each particular decade.  This holds true throughout the analysis – I’m not tracking the popularity of a specific set of names, but rather I’m examining the likelihood of parents following popular trends in naming.)

But then something happened.  By 1964, the figure had declined to 32 percent.  It stayed roughly at that level until 1994, when it dropped further to 24 percent.  And since then, it had declined dramatically to 18 percent in 2004 and 16 percent in 2014.  The most common female names in 2014 are not very widespread.

If the most common names are less widely used, the next question is what other names are being used?  Are parents merely spreading their wings a little to other relatively well-recognized names, or are they pushing the boundaries of names?  To test this, I broadened my analysis and looked at the 100 most common female names.  In 1884, the most common 100 names covered 70 percent of girls born that year.  Moving forward in time, we see a very similar pattern that we saw for the top 30.  The figure declined slightly through 1954 (65%), and then those hippies from the 60s started becoming parents.  The figure dropped 58% by 1964, 51% by 1974, and continues to decline.  In 2014, the top 100 female names covered only 31 percent of births.

So how much dispersion do we actually have here?  Let’s look at the top 500 female names in each decade.  Most of us probably couldn’t even come up with 500 different names, so surely they’re covering almost the entire female population, right?

Well, that certainly used to be the case.  In 1884, the top 500 names covered 90 percent of the female baby population, and sure enough, it follows the same pattern as my earlier analyses.  The figure floated between 87 and 89 percent up until 1954, with remarkable consistency.  After all, who can’t find a favorite name among the top 500?

A lot of modern people, apparently.  The figure dropped to 85 percent in 1964, 75 percent in 1974, and currently stands at 58 percent.  Think about that for a moment.  42 percent of girls today have a name that does not fall into the top 500 most common names of her decade.

How does such a phenomenon happen?  One might speculate that this is due to a trend for adopting spelling variants.  Evelyn, for example, has branched into both Evelyn and Evelynn.  While I suspect that this is a significant factor, though, it appears to not be the main factor.  Instead, what we see among our top 500 names for 2014 is that many names appear to be newly created, or at least exceedingly rare in past decades because they’ve never appeared on a top-500 list until now.  Names like Brynlee and Cataleya and Myla and Phoenix have replaced more standard names.

Another theory that I can’t confirm at this point is that perhaps the United States has more diverse immigration these days, which could be producing a greater diversity of baby names.

Now let’s take a look at male names.

The first thing we see is that male names have historically been compressed relative to female names.  Looking across all of the decades since 1884, there are 1,286 male names that have placed in the top 500 in popularity, while there are 1,601 female names.  So are male names still more concentrated among fewer options?  We’ll repeat the analysis we just did for female names.

If we look at the 30 most common male baby names, they constituted 56 percent of baby boy names in 1884.  Per our earlier observation, this is much more concentrated than the 41 percent that we saw for females.  Similar to female trends, though, the proportion was relatively stable for decades afterwards, still standing at 54 percent in 1954.

The proportion began dropping in the 1960s, but was more stable than female names.  By 1964, the figure had declined gracefully to 51 percent, then 46 and 45 percent in the 1970s and 1980s.  The major decentralization for boys began in earnest in 1994, when the figure dropped to 35 percent, then 25 percent in 2004 and 20 percent in 2014, which isn’t notably higher than the female figure at this point.

An interesting difference by gender occurs when we examine the top 100 male names.  Whereas the distribution of female names was only minor through the 1950s, the distribution of male names actually decreased during that era.  In other words, the 100 most common names became slightly more concentrated for boys from 1884 to 1954.  Names became more dispersed through the 1920s, but the trend then reversed.  The proportion of boys with top-100 names dropped from 74 percent to 69 percent between 1884 and 1924, then rose back to 76 percent by 1954.  Perhaps during hard times of depression and war, parents get more conservative when naming boys.  Or maybe mothers working on World War II assembly lines became enamored with mass production.

However, from 1954 on, male names paralleled the diffusion of female names, dropping steadily to only 42 percent today.  This is still more concentrated than the 31 percent figure for females, but is far lower today than at any time in the past 130 years.

Finally, we look at the top 500 male names.  Have males had the same dispersal as females?

Contrary to other findings, male names were actually slightly more dispersed among the top 500 than female names in 1884.  The 500 most popular male baby names constituted 89 percent of births, compared to 90 percent for females.  But this discrepancy didn’t last long.  While the top 500 female names dispersed slightly from 1884 through 1954, male names actually converged, reaching a high point of 94 percent in 1954.  So while parents were practicing more creativity in female names over this period, they were becoming less daring with male names, choosing more often to follow popular trends.

However, creativity took hold soon thereafter.  Male convergence dropped slightly to 93 percent by 1964, then dropped steadily to a figure of 71 percent in 2014.  So again, parents are increasingly choosing uncommon names for their babies in modern times, though to a much greater extend with boys than with girls.  As with the girls, these boys’ names appear to be a combination of new spellings and also new names that have never before shown up in the top 500, names such as Daxton and Finnegan and Kasen.

This is all well and interesting, but what does it mean?

I’m first interested in the differences for women versus men?  Why do parents feel greater freedom to give a female child an uncommon name?  Do they feel a greater need to make a female child stand out from the crowd, and if so, why?  Are males better situated to succeed with a more traditional name, or do more men simply get named after their fathers or other family members?  Is the difference sexism in a very indirect form, or is there some logical reason?  I’m at a loss to come up with a logical reason that doesn’t reflect different attitudes toward girl babies than boy babies, but I’d love to hear your theories.

While the level of standardization differs between males and females, though, the patterns are moving in the same direction, and doing so strongly.  Why are babies – both boys and girls – increasingly likely to be given uncommon names?  One can surmise that it describes a society where individualism is being sought out more and more.  It may also point toward a lesser desire or obligation to pass down family names and a lesser emphasis on tradition.  So are we increasingly a nation of creative individualists or are we increasingly lost and rootless?  Or both?


DIY Tools: Network Graphing

Analyzing Corona’s internal data for our annual retreat is one of my great joys in life.  (It’s true – I know, I’m a strange one.)  For the last few years I’ve included an analysis of teamwork at Corona.  Our project teams form organically around interests, strengths, and capacity, so over the course of a year most of us have worked with everyone else at the firm on a project or two, and because of positions and other specializations some pairs work together more than others.  Visualizing this teamwork network is useful for thinking about efficiencies that may have developed around certain partnerships, and thinking about cross-training needs, and so on.  The reason I’m describing this is that I’ve tried out a few software tools in the course of this analysis that others might find useful for their data analysis (teamwork or otherwise).

For demonstration purposes, I’ve put together a simple example dataset with counts of shared projects.  In reality, I prefer to use other metrics like hours worked on shared projects because our projects are not all of equal size, and I might have worked with someone on one big project where we spent 500 hours each on it, and meanwhile I worked on 5 different small projects with another person where we logged 200 hours total.

But to keep it simple here, I start with a fairly straightforward dataset.  I have three columns: the first two are the names of pairs of team members (e.g., Beth – Kate, though I’m using letters here to protect our identities), and the third column has the number of projects that pair has worked on together in the last year.  To illustrate:

My dataset contains all possible staff pairs.  We have 10 people on staff, so there are 45 pairs.  I want to draw a network graph where each person is a vertex (or node), and the edge (or line) between them is thicker or thinner as a function of either the count of shared projects or the hours on shared projects.

This year I used Google Fusion Tables to create the network graph.  This is a free web application from Google.  I start by creating a fusion table and importing my data from a google spreadsheet.  (You can also import an Excel file from your computer or start with a blank fusion table and enter your data there.)  The new file opens with two tabs at the top – one called Rows that looks just like the spreadsheet I imported and the other called Cards that looks like a bunch of notecards each containing the info in one row of data.  To create the chart, I click the plus button to the right of those tabs and select “Add chart”.   In the new tab I select the network graph icon in the lower left, and then ask to show the link between “Name 1” and “Name 2” and weight by “Count of Shared Projects”.  It looks like this:

There are a few things I don’t love about this tool.  First, it doesn’t seem to be able to show recursive links (from me back to me, for example).  We have a number of projects that are staffed by a single person, and being able to add a weighted line indicating how many projects I worked on by myself would be helpful.  As it is, those projects aren’t included in the graph (I tried including rows in the dataset where Name 1 and Name 2 are the same, but to no avail).  As a result, the bubble sizes (indicating total project counts) for senior staff tend to be smaller on average, because more senior people have more projects where they work alone, and those projects aren’t represented.  Also, the tool doesn’t have options for 2D visualizations, so if you need a static image you are stuck with something like the above which is quite messy.

However, the interactive version is quite fun as you can click and drag the nodes to spin the 3D network around and highlight the connections to a particular person.

Another tool option that I’ve used in the past (and that is able to show recursive links and 2D networks) is an Excel template called NodeXL.  You can download the template from their website – you’ll need to install it (which requires a restart of your computer) – and then to use it just open your Windows start menu and type NodeXL. Instructions here.  I had some difficulties using it with Office 2016, but in Office 2013 it worked quite well.

If you try these out, share your examples with us!

 


Dieting with Data

I don’t know about you, but one of my favorite things about the holidays is all of the great food that we get to eat. In just a month-and-a-half, we get to enjoy a beautiful Thanksgiving Turkey, succulent Holiday ham, and our favorite hors d’oeuvres on New Year’s Eve. It’s during these wonderful days I find myself overindulging in these rich, delicious foods.

With the new year comes new resolutions, and mine this year once again include losing weight (but this time I mean it.) It’s also a great time to make resolutions for your career or business, such as aiming to be more decisive or to better understand your customers. When the first step towards achieving those resolutions involves gathering data, just like when dieting it’s important that you don’t overindulge.

Recent trends have continued towards gathering as much data as you can and using it to make data-driven decisions. As I’m sure you know, here at Corona we love data; everything we do is driven by data. However, having too much data can often-times be crippling. You might have more than you know what to do with, or you could simply not know how to properly analyze it. It’s also possible that, even if all of that data is analyzed, you could be faced with a paralyzing number of options and decisions to be made.

So how can you ensure you collect a healthy amount of the right data? Similar to dieting, it’s important to always start with a clearly defined goal. Once your goals are well-defined, they inform the rest of the process: What questions should be answered? How is the data gathered – is there previously collected data that can be used, or should new data be gathered from survey(s), focus groups, or something else? What analyses need to be done to accurately answer the questions? Finally, the goals will let you know if you’re in over your head and need help.

Hopefully we can all stick to our resolutions, because when you look back a year from now you’ll only be thankful you did.