PinnedJiayan YininTowards Data ScienceData Scientists Can’t Excel in Python Without Mastering These FunctionsIntroduction of Python’s core functions, use cases, scripts, and underlying mechanismsAug 319Aug 319
PinnedJiayan YininTowards Data ScienceSQL User Defined Functions (UDFs)A tutorial on mastering SQL UDFs: categories, use cases, and difference from stored proceduresAug 22Aug 22
PinnedJiayan YininTowards Data ScienceThe Most Useful Advanced SQL Techniques to Succeed in the Tech IndustrySyntax, use cases and expert tips for mastering advanced SQLJul 318Jul 318
Jiayan YinStatistical Knowledge Every Data Scientist Should KnowBridging the theoretical foundations with practical applications in data science1d ago1d ago
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