Karina | Python | Excel | Stats | DataScience | DataAnalytics
Data analytics/science educator; active, high‑engagement posts on pandas/Python and big‑data‑adjacent workflows for analytics.
Free AI Certifications From Top Tech Leaders
AI certifications that actually hold weight Free (or nearly free): Google AI Essentials - AI fundamentals and prompt engineering, taught by Google. IBM AI Fundamentals - verifiable Credly badge you can add to LinkedIn. DeepLearning.AI Short Courses - built by Andrew Ng. 1-2 hours each. Prompt engineering, LLMs, agentic AI. Anthropic Academy - 13 free courses directly from Anthropic. Claude fundamentals through agentic systems.
Eight Underrated Data and Career Books You Must Read
I have read a lot of books on data, statistics, and career development. These 8 do not appear on most recommended lists — and they should. TECHNICAL 1. Head First SQL — Lynn Beighley More visual and beginner-friendly than most SQL books. Uses...
12 Free Sites to Master SQL Practice
12 free websites to practise SQL sqlbolt[dot]com sqlzoo[dot]net sql-practice[dot]com selectstarsql[dot]com datalemur[dot]com/sql-tutorial sql-easy[dot]com w3schools.com/sql hackerrank.com/domains/sql leetcode.com/problemset/database thoughtspot[dot]com/sql-tutorial pgexercises[dot]com dbfiddle[dot]uk
Master the 5 Key Stats Behind Every A/B Test
These 5 concepts come up constantly in real analysis — A/B tests, business experiments, reporting to stakeholders who ask exactly that question. Confidence intervals — the range your true value likely falls in Hypothesis testing — the framework for testing whether a...
Master Python by Playing These Fun Games
You can learn Python by playing games: 1. Codédex — cododex[dot]io 2. CodinGame — codingame[dot]com 3. Codewars — codewars[dot]com 4. Exercism — exercism[dot]org 5. Battlesnake — play.battlesnake.com 6. CheckiO — py.checkio.org 7. Advent of Code — adventofcode.com 8. Making Games with Python & Pygame —...
Learn SQL Through Games, Not Dry Tutorials
You can learn SQL by playing a game. I am not joking. Most people quit SQL tutorials because dry exercises on fake datasets feel pointless. These free games give you a reason to write queries. A murder to solve. An island to...
Use Pandas Query() for Cleaner, Chainable DataFrame Filters
Python tip You've been filtering DataFrames like this. df[(df['region'] == 'UAE') & (df['revenue'] > 10000)] There's a cleaner way. df.query("region == 'UAE' and revenue > 10000") Same result. No brackets. No repeated df. Reads like a sentence. Where it really pays off is inside a chain. Use...
Prefer UNION ALL for Speed; Use UNION only for Deduplication
UNION VS UNION ALL in SQL UNION deduplicates every row after combining the results. That means sorting, comparing, discarding. On large tables that's a real performance cost -- and most of the time, you don't even need it. UNION ALL stacks the...
Business Queries Demand More than Basic SQL Skills
There is a gap between knowing SQL and knowing enough SQL to answer the questions a business actually asks. "Show me each customer's rank within their segment." "Give me a running total of revenue by month." "Flag anyone earning above their...
Data Cleaning Is Core Analysis, Not Just Prep
I’ve never worked with a clean dataset. Every real project = messy data. And it always comes down to 4 things: • Missing values • Duplicates • Data types & formatting • Outliers Cleaning isn’t a “prep step”. It is the analysis.
Plans Are Starting Points; Embrace Pivots for Growth
38 🎂 At 20 I had a plan for my life. It bore almost no resemblance to what actually happened. Here is what I know at 38 that I didn’t know at 20. The plan is useful for getting started, but it...
Validate Data Loads Instantly with SQL EXCEPT
SQL tip You ran a load job overnight. How do you know every record made it? Most people recount rows and hope the numbers match. There's a cleaner way. SELECT order_id FROM staging.orders EXCEPT SELECT order_id FROM production.orders; If this returns nothing, every order transferred successfully. If...
Smooth Daily Revenue with a 7‑Day Rolling Average
SQL tip Daily revenue is noisy. One bad Monday skews the whole picture. A 7-day moving average smooths it out. ROWS BETWEEN 6 PRECEDING AND CURRENT ROW tells SQL to look at today plus the 6 days before it. The result is a rolling...
Window Functions Rank without Collapsing Rows
SQL tip GROUP BY collapses your rows. Sometimes you need the ranking without losing the detail. That's what window functions do. PARTITION BY region restarts the ranking for each region. ORDER BY total_spend DESC puts the highest spender at rank 1. Every row stays intact....
Combine Multiple Aggregates in One Query Using CASE
SQL tip You're running three separate queries to get this. SELECT SUM(amount) FROM orders WHERE user_type = 'premium'; SELECT COUNT(*) FROM orders WHERE is_first_order = TRUE; SELECT SUM(amount) FROM orders; You can get all three in one. This pattern works across Oracle, SQL Server, PostgreSQL, BigQuery...