Blog

SQL Tutorial 2 : Additional criterias with the use of OR/IN/AND Functions

In reality, the dataset that we want to obtain often requires the application of much more criterias and filters than just 1. Building on what we explored in Topic 1, we will use new functions such as the “AND/OR/IN” functions to build on our “SELECT FROM WHERE” framework. “OR” Function Referring to the same ”world_data” … Continue reading SQL Tutorial 2 : Additional criterias with the use of OR/IN/AND Functions

SQL Tutorial 1 : “SELECT FROM WHERE” Framework

“SELECT FROM WHERE”  The key framework governing SQL are these 3 keywords : “SELECT”, “FROM”,  “WHERE”. Firstly, for SELECT, we are choosing which columns in the database that we want to extract data from. Secondly, for FROM, we are choosing which table in the database to extract data from. This is crucial because a database … Continue reading SQL Tutorial 1 : “SELECT FROM WHERE” Framework

NUS BACT collaboration with American Express

Published on January 2, 2019 Background During the semester, Brenda and I had the privileged opportunity to collaborate with American Express (AMEX) to create a Tableau dashboard. The main focus of this collaboration was to present their profits and losses in a comprehensive, insightful and interactive manner using Tableau. Knowing the Credit Card Business Prior … Continue reading NUS BACT collaboration with American Express