The following are notes from my readthrough of Maths and Stats for Web Analytics and Conversion Optimization by Himanshu Sharma, in no particular order: ROI, ROI, ROI You need 4 sets of data to calculate ROI: (1) Cost data (2)… Continue Reading →
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… Continue Reading →
The below spreadsheet can be used to check key metrics before purchasing a property. All cells in orange are to be filled in with your own values. Everything else is calculated.
Terminal commands: Launch PostgreSQL terminal – psql Copy table from one db to another – pg_dump -t table_name copyfrom_db_name | psql copyto_db_name PSQL commands: List databases – \d List tables in current database – \dt List table structure – \d table_name List… Continue Reading →
A dashboard used to mean an array of physical instruments, arranged in front of an operator of some form of machine. The requirement for dashboards has evolved over time and they are now commonly used digitally by companies as a… Continue Reading →
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… Continue Reading →
I needed to transform a table with data somewhat summarised (see below), back into a database, or data rows. Thanks to the internet, I uncovered this little trick. Press ALT + D + P to bring up the PivotChart… Continue Reading →