R for Product Management


Photo by Štefan Štefančík on Unsplash
Since my previous blog post I have made some progress on being able to replace most of what I currently use Excel for with R scripts. I have also launchjed a project to collect together some useful recipes for other Product Managers on GitHub called "R for Product Management"

So far I have samples that cover the following data sources:
  1. Google Analytics - to my previous learning have added analysis of browsers used by site visitors and an example Shniy app for data exploration.
  2. InfluxDB - Working with time series data generated by the product, the two examples here are API response times and feature usage. This includes an example of manipulating time series data to set missing values to 0 for plotting.
  3. UptimeRobot - Simple example of taking error data and using a pivot table to explore the data, after some cleaning and filtering. This kind of workflow can be useful with large data sets.

One thing that I really wanted to get working was Elasticsearch, to get an example analysis of components and logging output, including relative error rates. Sadly the only wrappers available at the moment stop just before the version of Elasticsearch we use. Elasticsearch is also the first NoSQL system I have used, so it takes a bit of getting your head around how everything hangs together. Already having example visualisations in Kibana was helpful in working it out though.

Another thing on my to do list is getting standard pirate metrics out of Google Analytics and then format into a nice report. The R Markdown components come with a range of templates that you can use, for example based on the Bulma framework, or you can create your own with your own branding.

This exercise has been really helpful in getting disparate sources of information into a standard reporting framework. Previously I would have tackled this by building some kind of "data warehouse", but actually as long as I can query well enough to get a format that can then be manipulated into a report then it feels like an extra step. Especially where you don't need to drill down further in the report. If something needs more investigation I'll likely go to the source anyway. 

I hope that someone out there finds some value in my R scripts. Please feel free to fork and send my pull requests with any improvements! I am also always happy to talk to data-driven members of the Product Management community who might be interested in using R.

Further reading


Comments

Post a Comment

Popular posts from this blog

CONFERENCE: TTI Summer Forum 2017 – Getting to Grips with GDPR

Image
T his week I was at the Travel Technology Initiative's Summer Forum . The subject was the new EU (and UK!) data protection laws. These are due to come into force in May 2018. It's a large topic where the individual member state's laws and guidance are evolving. There were three main points that I picked up from the presentations. First from Dai Davis , GDPR expert at Percy Crow Davis & Co. His lively presentation talked about how a large part of the change is in how rights communicated. Before this was by "fairness" through registration of usage with a central body. The shift is to transparency by informing individuals directly. This means that the consumer mindset could then shift to match how legislation is framed. For example, with the repetition of many companies holding personally identifiable information now having to inform what they are collecting and how they are processing it. Currently, awareness isn't high and the compensation not high eno...
Read more

On HBX and online education

Image
I have written this blog post as a reflection on what has occupied me a lot in the past 3 months. After finishing my Post graduate Certificate in Technol ogy Manage ment with the O pen U niversity I was looking at what to do next in continuing my education - being a life long learner! I was looking at different online plat forms for interesting courses.  I was looking at sites like Coursera and  Future Learn , when I came across a new extension to Harvard Business School and a course they run called HBX CORe. This one paragraph pitch they provide sums it up pretty well: HBX CORe (Credential of Readiness) is a 120-150 hour certificate program on the fundamentals of business from Harvard Business School. CORe is comprised of three courses - Business Analytics, Economics for Managers, and Financial Accounting – developed by leading Harvard Business School faculty and delivered in an active learning environment based on the HBS signature case-based learning mod...
Read more

Getting email up and running for side projects

Image
This is  part of a series  about my side project  Bashfully , which aims to give graduates and other new entrants to careers a seasoned professional level way of expressing themselves through the super power of story telling. Following the core principles of being discoverable, personalised and guiding in approach. Photo by Songeunyoung on Unsplash Rectifying my previous mistake - not building community by using email engagement - has proved to be a learning experience! Since our investment is minimal (and we have no real users yet!) the tools that we use all come with some constraint/trade-off. This next bit explain this is going to be slightly technical ... With Heroku it has surfaced as putting in CNAME records in the root of the domain. With register.ly this then stops us adding any other root records, for example mail servers. Cloudfare has a service that will flatten CNAME records for you into A records so everything plays fits together. So a switch ...
Read more