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

Data Science Examples

Power BI Dashboard

Here is a dashboard I made in Power BI.

It includes –

  • 4 data displays
  • 2 slicers, and
  • 4 cards

Download a screenshot here.


Excel, VBA, Financial Analysis and Accounting

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 are three files:

  1. An Excel File I keep, filled with examples of Models, Pivot Charts and Tables, Vlookup and more. You can get it here.
  2. A Macro file I made with VBA that Adds and formats headers to as many worksheets as you have, sums the total of the last row in each worksheets, and pastes the worksheets in an empty worksheet at the end. You can download the zipped XLSM file and text file of the Visual Basic code here.
  3. Here is a Financial Analysis spreadsheet I made – it covers the basics of Financial Analysis and Accounting. You can find it here.

Be sure to enable Macros in the Excel file so that you can run the Macros.


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

I keep an Excel file of SQL queries here.

You can find a page of 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