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…4 min read·Nov 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…4 min read·Nov 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…4 min read·Nov 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…4 min read·Nov 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…4 min read·Nov 2, 2020--1--1
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…4 min read·Nov 1, 2020----
Alexander ChanginAnalytics VidhyaMachine Learning Models CheatsheetUnderstanding how to utilize algorithms ranging from random forest to TextRank for different use cases15 min read·Jan 29, 2020----