Data Science

Upcoming Presentation by Robert Walker

Thank you for taking time to read my blog.  If you want to discuss any of the topics I've blogged about or more I'll be at the ISWA World Congress 2017 in Baltimore, Maryland on September 26 to discuss and demonstrate how the data science and machine learning I do can help landfill operators optimize landfill gas production. 

You can read my abstract and learn more about he conference here.

Time-Series PivotCharts with Dynamic Date-Axis by Robert Walker

Using PivotCharts in Excel is a powerful analysis, automation, and visualization tool - however, they are lacking when it comes to Time-Series charts and require a bit of trickery to work as expected.  Here I describe some of those tricks and provide a working example of how to make dynamic time-series PivotCharts.

Read More

How to Quickly Create Time-Series PivotCharts by Robert Walker

Time-Series charts are a staple data visualization tool in many industries.  Creating easy to manipulate time-series charts has been done for a while online (i.e., Plotly.js, Tableau), many clients require their data to stay "local" - either Excel or a secured database - nothing online or 3rd party.  That's where Excel PivotCharts can fill the gap.  This tutorial will show you how to accurately present time-series data using a PivotChart.

Read More

Microsoft Professional Program Certificate in Data Science by Robert Walker

I'm happy to announce that I've completed the Microsoft Professional Program Certificate in Data Science!  After six-months of courses capped off by a challenging machine learning problem issued by Microsoft data scientists, I've learned a lot and am excited to use my new skills.  As proof of my accomplishment Microsoft has issued this official certificate!