Sometimes, we are not really interested in the specific row or column of data. Rather, we are interested in the summation or count of a column of data. This is where “Aggregation Functions” like SUM and COUNT in SQL are used. “SUM” Function Firstly, we have the SUM Function, which allows us to return the … Continue reading SQL Tutorial 3 : Aggregation Functions
Blog
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
“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
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