Posts
-
SQL and Python
Notes on using data from Python (like a list of values) with SQL databases and tables (also in Python).
-
Remote login to Heroku
-
Ranking in SQL
-
Exluding SQL results with Left Outer Join
-
Multiple trended fallouts in a single graph in Adobe Workspace
-
Cohort analysis: Adobe Analytics vs Tableau
-
Reading Notes - Maths and Stats for Web Analytics and Conversion Optimization
The following are notes from my readthrough of Maths and Stats for Web Analytics and Conversion Optimization by Himanshu Sharma, in no particular order:
-
Data visualisation with Python and Plotly - The Perth real estate market
Python is well known for its data science and analysis capabilities with packages such as Numpy, Matplotlib and Pandas. Each of these packages also offer a variety of graphing and visualisation tools, the majority of which is already very well documented.
-
House Purchase Calculator - WA
The below spreadsheet can be used to check key metrics before purchasing a property.
-
Remote connection to Raspberry Pi
Easy SSH when your computer and your PI are on the same network (wifi)
-
PostgreSQL Beginner's Cheat Sheet
Terminal commands:
-
Web Apps
- Twitter sentiments - Looks up the 50 most recent tweets from any twitter user, classifies the sentiment of those tweets and outputs the result as a pie chart
- KS50 Finance - A simulated stock market portfolio tool, useful for learning the sharemarket with fake money, but real prices
- Mashup - Overlays Google News articles over a searchable Google Map of Australia
-
Command line apps
The following are apps I’ve developed that currently only run from the command line. Many thanks to the excellent CS50 course for guidance with these.
-
3 often forgotten rules of reporting dashboard design
A dashboard used to mean an array of physical instruments, arranged in front of an operator of some form of machine.
-
A Book Summary - Tuesdays with Morrie
A young man reconnects with his old university mentor after more than 15 years. Unfortunately, his mentor, Morrie, is slowly dying of a fatal, degenerative disease. Rather than lapsing into self pity however, Morrie chooses to spend what time he has left coming to terms with his mortality. Shared in this memoir is his take on life from the unique perspective of one close to death.
-
Creating data rows from a summary table - Reverse Pivot
I needed to transform a table with data somewhat summarised (see below), back into a database, or data rows.
-
Rent vs Buy Calculator
A simple calculator to determine if you are financially better off to rent or buy a property. Feedback welcomed in the comments below.
-
Select multiple items from a list in Excel
For the rare occasion when you need to select multiple items from a list in Excel, the below VBA code will do the trick, complete with a nice selector panel. See the screen capture below for it in action.
-
Text Analysis using Excel
subscribe via RSS