Keith Yap

Things I've Learnt

Page 2 of 2

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… Continue Reading →

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. Caesar in C – Encrypts a user defined phrase using the caesar cypher method, and using a key… Continue Reading →

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. The requirement for dashboards has evolved over time and they are now commonly used digitally by companies as a… Continue Reading →

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… Continue Reading →

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.   Thanks to the internet, I uncovered this little trick. Press ALT + D + P to bring up the PivotChart… Continue Reading →

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. Notes: this calculator has been tailored to the Australian market (eg. rent is expressed in weeks) there… Continue Reading →

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. This… Continue Reading →

Text Analysis using Excel

Word Counts Word Clouds Sentence Counts Sentiment Analysis Topic Modelling Combining it all together Below is a summary of my explorations using excel for text analysis. The example used in this article focuses on customer feedback for a hypothetical bank’s… Continue Reading →

Newer posts »

© 2020 Keith Yap — Powered by WordPress

Theme by Anders NorenUp ↑