Alexander ChangAnalyzing Online Hate Speech in 20202020 has truly been a rollercoaster ride of a year so far - a worldwide pandemic, economic downturn, racial unrest following the death of…Nov 25, 2020Nov 25, 2020
Alexander ChangSQL Advanced Cheatsheet — Window FunctionsWindow functions are similar to aggregate functions in that they compute aggregate values by performing calculations across a set of rows…Nov 3, 2020Nov 3, 2020
Alexander ChangSQL Advanced Cheatsheet — SubqueriesAs we begin trying to answer more in-depth questions about the data, our SQL queries will become more complex. In the beginner cheatsheet…Nov 2, 2020Nov 2, 2020
Alexander ChangSQL Intermediate Cheatsheet — JoinsAfter covering aggregation in the previous section, I will now go over one of the most important SQL concepts — joins. Often times, the…Nov 2, 2020Nov 2, 2020
Alexander ChangSQL Intermediate Cheatsheet — AggregationThe intermediate SQL tutorial will go over 2 main areas: aggregate functions (aggregate data using summary statistics) and joins (combine…Nov 2, 20201Nov 2, 20201
Alexander ChangSQL Beginner ConceptsSQL stands for Structured Query Language, which is one of the most important coding languages to learn especially for Data Scientists and…Nov 1, 2020Nov 1, 2020
Alexander ChanginAnalytics VidhyaMachine Learning Models CheatsheetUnderstanding how to utilize algorithms ranging from random forest to TextRank for different use casesJan 29, 2020Jan 29, 2020