PinnedJiayan YininTowards Data ScienceData Scientists Can’t Excel in Python Without Mastering These FunctionsIntroduction of Python’s core functions, use cases, scripts, and underlying mechanisms1d ago41d ago4
PinnedJiayan YininTowards Data ScienceThe Most Useful Advanced SQL Techniques to Succeed in the Tech IndustrySyntax, use cases and expert tips for mastering advanced SQLJul 317Jul 317
Jiayan YininTowards Data ScienceSQL User Defined Functions (UDFs)A tutorial on mastering SQL UDFs: categories, use cases, and difference from stored proceduresAug 22Aug 22
Jiayan YinPractical Exploratory Data Analysis (EDA) in Data Science ProjectsA Comprehensive Guide to Methodologies, Processes, Statistical Principles and Python Applications for EDAAug 17Aug 17
Jiayan YininTowards Data ScienceMust-Know Techniques for Handling Big Data in HiveHQL’s Unique Features— PARTITIONED BY, STORED AS, DISTRIBUTE BY / CLUSTER BY, LATERAL VIEW with EXPLODE and COLLECT_SETAug 14Aug 14
Jiayan YinMost Popular Data Visualisation Tools for Data AnalystsComparisons of Tableau, Power BI, Qlik, and LookerAug 71Aug 71