Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Guides
Adding and Removing List Elements with Python
Explore the versatile techniques of adding and removing elements in Python lists to enhance data manipulation and streamline your coding workflow.
Nathan Rosidi -
SQL PARTITION BY: Advanced Analytical Insights
SQL PARTITION BY makes SQL window functions – already a powerful analytical tool – even more suitable for advanced analytical insights from your data.Nathan Rosidi -
What Are the Steps to Cast INT in SQL for Type Conversion?
Cast INT in SQL is a must-know for anyone even remotely interested in data handling and analysis. This article will cover all the important cast INT topics.Nathan Rosidi -
How to Perform Python String Concatenation?
Learn essential Python string concatenation techniques, including the + operator, join() method, f-strings, and format() method.Nathan Rosidi -
Tools for the Data Scientists Working at Scale
Do data scientists need big data knowledge? Yes, they do! In this article, we’ll cover several big data tools that will help you when working at scale.Nathan Rosidi -
Business Analytics vs Business Intelligence
Business intelligence and business analytics; so similar yet so different. Here’s an article about their differences and how they complement each other.Nathan Rosidi -
How to Drop Duplicates in PySpark?
Learn how to ensure accurate analysis by identifying and removing duplicates in PySpark, using practical examples and best practices for handling large datasets.Nathan Rosidi -
Junior Data Analyst Skills and Career Path
Junior data analysts are the first stepping stone in your data analysis career. Learn everything about the skills you need and your (possible) career path.Nathan Rosidi -
How to Use SQL Wildcards for Flexible Data Queries
This article is all about uncertainty and using it to add flexibility to SQL queries. How do you do that? Start using one of the five SQL wildcards regularly.Nathan Rosidi -
What is Unsupervised Learning in Machine Learning?
Unsupervised learning helps machines find patterns in unlabelled data, useful for tasks like anomaly detection, market segmentation, and image recognition.Nathan Rosidi -
The Data Scientist's Guide to Impress at Work: A Playbook for Success
How do you stand out at work and shine a light on your project and team? This article gives you five crucial tips on impressing as a data scientist.Nathan Rosidi -
How Does SQL Date Formatting Work?
In this article, we explore the SQL date format. We’ll deal with how standard and custom date formatting work in four of the most popular SQL flavors.Nathan Rosidi -