CONNECT:
jonathan AT jonmaas DOT com +1-310-500-5841

Data Science Examples

Excel and VBA

I really like Excel – there are many Data Analytics programs out there, but you would be surprised at how far you can get with Excel.

Here’s a Macro I made with both the Record Macro and VBA function. Basically this Macro: 

  1. Adds and formats headers to as many worksheets as you have
  2. Sums the total of the last row in each worksheet
  3. Pastes all those worksheets in an empty worksheet at the end.

Download the zipped Microsoft XLSM file and a text file of the Visual Basic code here. Be sure to enable Macros in the Excel file so that you can run the Macro.


Tableau

Here is a report I did with Tableau.

I analyzed a big dataset with Tableau, and came to some conclusions.

Download the report here.


Data Visualization

Here’s a blog post I made for a Startup. You can download the PDF of the blog post here.


SQL

You can find a few of my favorite SQL queries here.

Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Youtube
Consent to display content from Youtube
Vimeo
Consent to display content from Vimeo
Google Maps
Consent to display content from Google