Introduction

-

Although I have always had an interest in data and analytics, Microsoft's recent moves to incorporate R into SQL Server, as well as Visual Studio's integration with Python, makes learning data analytics an easier option, as well as a likely necessity for my career.

It is not that I would not enjoy analysis on my own:

  • I was likely the only person really capable of writing SAS in my Statistics for the Social Sciences, and ran so many correlations for my study on education and fitness I was almost banned from the lab
  • While in B-school, around 2002, I looked to analyze and publish the relationship between Hofstede's cultural dimensions and OECD economic data
  • Eventually, I found significant negative relationships between income inequality on social welfare, years before it became widely popularized


Comments

Post a Comment

Popular posts from this blog

Cultural Dimensions and Coffee Consumption

-
Image
Photo by Viktoria Alipatova from Pexels Responding to a Treehugger article, Why Americans will never love tea as much as coffee , I initially wrote my personal preferences for tea and coffee , ending with, BTW, this has just given me an idea for comparing Hofstede's cultural dimensions and coffee and tea consumption. Afterward, I did some analysis in Excel, then ran the same processes in R using Visual Studio, then converted that to a Jupyter Notebook on Microsoft's Azure Notebooks . Although this analysis is limited to 45 countries that have Hofstede's Cultural Dimensions , as well as per capita consumption for both coffee and tea, it would seem that coffee consumption correlates with power distance, individuality, and masculinity. Tea had small correlations with the dimensions and sometimes in the same direction as coffee. A fuller analysis is available on Microsoft's Azure Notebook , but some quick findings: Higher power distance, lower coffee consumption...
Read more

Developers in New York City by Zip Code

-
Image
Photo by Lukas Kloeppel from Pexels In 2016, after reading a Dice Insight article, I downloaded data that had technology professional numbers by zip code, along with density. A recent NY Times article How Big Tech Is Turning New York Into a Silicon Valley Rival prompted me to resurrect the data, decorate it a bit with neighborhood names, and then import it into Google Maps , which was surprisingly easy. The original data is available in Excel .
Read more

VBA versus .NET

-
I was recently messaged by someone on LinkedIn, and since my response seemed full enough, I thought I'd share. Question I see that you also program in VBA but you have made the jump to .NET. Unfortunately, I have found C#/Excel coding to be quite slow and just wanted to hear about your experiences. Responses Slow? It depends on what you mean. Honest, I have had to make the pitch when building apps that it should be in .NET rather than VBA for speed. One particular app had a form that needed to fill about 20 dropdowns on load, so using async operations were essential. That same app, while executing one SQL statement in the foreground, also executed 2 background statements that filled panels. It wouldn't have performed well if done in VBA. If you mean that it takes longer, then yes, but that is a necessity for good code anyway. If you only need a local operation, non-threaded, that doesn't need to be used across the enterprise, VBA can make sense, but with .NET co...
Read more