PinnedJiayan YininTowards Data ScienceThe Most Useful Advanced SQL Techniques to Succeed in the Tech IndustrySyntax, use cases and expert tips for mastering advanced SQLJul 319Jul 319
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 3111Aug 3111
PinnedJiayan YininTowards Data ScienceHow to Handle Imbalanced Datasets in Machine Learning ProjectsTechniques to handle imbalanced datasets, examples, and Python snippetsOct 32Oct 32
PinnedJiayan YininTowards Data ScienceA Powerful Feature for Boosting Python Code Efficiency and Streamlining Complex WorkflowsAll you need to know about Python loopsSep 151Sep 151
Jiayan YinThe Future of Data Scientists: AI’s Impact on JobsWhy data science is evolving, not disappearingSep 23Sep 23
Jiayan YinStatistical Knowledge Every Data Scientist Should KnowBridging the theoretical foundations with practical applications in data scienceSep 7Sep 7
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
