Tech Skills
Data Analytics & Business Intelligence
Excel, SQL, Power BI, Tableau — turn raw data into business decisions
Skills in this topic
7 skills — Sign in to track your progress
Data Literacy
beginner
Write SELECT queries with JOIN and GROUP BY
Excel & Spreadsheets
beginner
Build a dynamic dashboard with pivot tables and slicers
SQL Analytics
intermediate
Write window functions (ROW_NUMBER, LAG, LEAD)
BI Tools
intermediate
Build an interactive dashboard from a SQL source
Python for Data
intermediate
Clean and transform a messy dataset with pandas
Data Storytelling
intermediate
Build a stakeholder dashboard with a narrative structure
ML for Analytics
advanced
Build a churn prediction model
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1h ago
"Python data types" — Understand Their Real-World Purpose
"What data type should I use and why?" Continue reading on Medium »
Dev.to · Muhammad Bin Nazeer
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3h ago
Building a Football Data Pipeline: Lessons from Lampard somewhere in the middle of Mourinho and Ancelotti
Building a Football Data Pipeline: Lessons from Lampard somewhere in the middle of Mourinho...
Dev.to · Muhammad Bin Nazeer
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3h ago
I Scraped 100 Formula 1 Matches — Here Is What I Found: Slow start makes me want to stay Norris extends McLaren deal to
I Scraped 100 Formula 1 Matches — Here Is What I Found: Slow start makes me want to stay...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
5h ago
Illuminating the Invisible: Dark Data, Missingness, and the Architecture of Coherent Understanding
Expanding David J. Hand’s Dark Data Through the Stathine–Coexon Framework Continue reading on Predict »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
5h ago
What Texas Actually Buys: A Data Read of the Statewide Contract Catalog
Who wins Texas state contracts? The Comptroller’s TxSmartBuy program runs the statewide (SPD) contract catalog — the master list of… Continue reading on Medium
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
7h ago
How to Build a Cohort Retention Matrix in R and Python
A build-along companion to the concept piece. Point R or Python at a raw transaction log and produce the same retention grid, cohort by… Continue reading on Med
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
7h ago
How to Build a Cohort Retention Matrix in R and Python
A build-along companion to the concept piece. Point R or Python at a raw transaction log and produce the same retention grid, cohort by… Continue reading on Med
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
7h ago
The Table That Never Refreshes — And Never Tells You: A Dynamic Tables Deep Dive
The Cortex governance series that ran here ended with a promise: step back from AI specifically and point at something bigger — the… Continue reading on Medium
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8h ago
Building a Fixed-Income Intelligence System: What Changed at BondStats This Week
Most financial platforms do not suffer from a lack of information. They suffer from too much of it. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8h ago
The Category That Wasn’t: How a Dropdown Menu Became a Fraud Vector
Open the groceries tab on your favorite shopping app. You expect rice, cooking oil, snacks. You do not expect a washing machine. Somewhere… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8h ago
Autocorrelation: The Statistic Hiding Inside Every Mean-Reversion Trade
Every price chart looks like it has a personality. Some stocks seem to trend up. Others seem to snap back — a sharp move one day gets… Continue reading on Mediu
Dev.to · Makori Nyachaki
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8h ago
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning
Getting Started with Excel for Data Analytics: From Basics to Data Cleaning ...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
9h ago
Mastering SQL Subqueries & CTEs: Writing Smarter Queries Like a Real Data Analyst
Most people begin learning SQL by focusing on simple queries. They learn: Continue reading on Medium »
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
9h ago
Mastering SQL Subqueries & CTEs: Writing Smarter Queries Like a Real Data Analyst
Most people begin learning SQL by focusing on simple queries. They learn: Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
11h ago
From Power BI Developer to Fabric Engineer
Part 1 — Subscription, License & Your First Workspace Continue reading on Code & Insight »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
12h ago
I Found 7 Python Libraries While Solving Real Problems
The best discoveries rarely come from “top libraries” lists Continue reading on Python in Plain English »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
14h ago
My Internship Journey with Oasis Infobyte: Building Practical Data Analytics and Data Science…
My internship journey with Oasis Infobyte has been a valuable opportunity to strengthen my practical skills through hands-on projects and… Continue reading on M
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
15h ago
Missing Values ??
Whenever missing values come up, the first instinct of most naive data scientists is: “Hey, let’s just average out the values, or fill in… Continue reading on M
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
16h ago
Database Key Hierarchy Breakdown: The Essential Guide to Super, Candidate, Primary, and Alternate…
Whether you are designing your first database schema or preparing for a system design interview, understanding database keys is a… Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
16h ago
I Verified 15 Popular Forex Indicators With Claude. All Lost Money. Here’s the Data.
Six months, 50,000+ configs, 15 indicators. None profitable standalone. But one reframe turned losing configs into +0.14R portfolios. Continue reading on Medium
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
16h ago
The Day I Realized Duplicate Records Can Change Everything
When I first started learning Databricks, I thought duplicate records were just a small data issue. Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
21h ago
Data Engineering Course in Pondicherry
Data Engineering Course in Pondicherry | Training & Career Guide Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
21h ago
Why Function-Based / Expression Indexes More Powerful Than You Think (And How to Master Them)
Master expression indexes to accelerate computed predicates, improve query performance, and optimize complex lookups Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
21h ago
Why Function-Based / Expression Indexes More Powerful Than You Think (And How to Master Them)
Master expression indexes to accelerate computed predicates, improve query performance, and optimize complex lookups Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
21h ago
dbt Macros : One File Instead of Eleven
SQL that writes itself, before the warehouse ever sees it Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
22h ago
How to Build a Free DeFi TVL Dataset (No API Key Required)
Most DeFi analysis dies at the first step. Someone wants a table of every protocol with its TVL, category and chain, discovers that the… Continue reading on Med
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
22h ago
How to Build a Free DeFi TVL Dataset (No API Key Required)
Most DeFi analysis dies at the first step. Someone wants a table of every protocol with its TVL, category and chain, discovers that the… Continue reading on Med
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Your Dashboard Is Not the Analysis
I’ve seen this happen quite often. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
CSV Files Aren’t Broken: They’re Just Misunderstood
Discover why CSV files appear broken and learn how delimiters, encoding, commas, line breaks, and formatting can cause common CSV errors. Continue reading on Me
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
CSV Files Aren’t Broken: They’re Just Misunderstood
Discover why CSV files appear broken and learn how delimiters, encoding, commas, line breaks, and formatting can cause common CSV errors. Continue reading on Me
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
PwC Data Analyst Interview Experience: SQL, Python and Guesstimate Questions
I recently went through a Data Analyst interview process at PwC for a role . Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Who gets to author your governance?
When trust and transparency is the outcome of the governance ! Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
We’re Evaporating Water in the Driest Desert on Earth To Build The Future
Pump it from beneath a salt flat and it becomes lithium. Put it under your car and it becomes progress. Continue reading on Southern Winds »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Stop Watching Python Tutorials. Automate These 7 Boring Analytics Chores Instead.
There’s a dangerous trap lurking in the data world, and it’s called Tutorial Hell. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
A Fairer Champions League Draw — Without Losing the Magic
An offline experiment points to a practical guardrail: keep enough fair schedules alive after every ball. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Data Science Didn't Make Us Smarter—It Made Us Stop Trusting Our Intuition
Why relying on algorithms for basic human decisions has left us more anxious, indecisive, and disconnected from our own judgment Continue reading on Medium »
The Register
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
German-Japanese researchers invent electricity-free tech that could cool datacenters
How come that super-smart AI of yours didn't figure this out, frontier labs?
Forbes Innovation
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
AI Is Turning Data Governance Into A Competitive Advantage
For that governance to be effective, it needs to be grounded in a complete understanding of your network infrastructure.
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
SQL is Dead (And NoSQL Still Lost): The New World Order of Data
It’s 2012. You’re sitting in the back row of a crowded tech meetup, eating lukewarm pizza. A developer on stage is passionately explaining… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Data Cleaning with R
dplyr: The Marie Kondo Method for Messy Data Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
The Data Problem at the Center of Biomedical Informatics: Structured, Unstructured, and Everything…
Every one of my three tools stores data cleanly, in well-normalized tables, exactly as a computer science degree teaches you to build a… Continue reading on Med
ArXiv cs.AI
📊 Data Analytics & Business Intelligence
📄 Paper
⚡ AI Lesson
2d ago
Selection Bias Correction in Retail Intelligence
arXiv:2608.26156v1 Announce Type: new Abstract: Retail intelligence often relies on monitoring popular, high-velocity products, potentially biasing economic ind
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2d ago
Decoding Workforce Dynamics: An In-Depth HR Analytics & EDA Case Study
By Olaomo Favour Fiyinfoluwa Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2d ago
Kestra vs dbt: Which Data Tool Should You Choose
Explore Kestra vs dbt, including their key differences, use cases, pricing and how they compare with Airflow, Prefect, Dagster and… Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2d ago
How to Build a Clean Earthquake Dataset from the USGS Catalog (No API Key Required)
Most public datasets that people actually want are either paywalled, stale, or wrapped in a signup flow. Seismic data is a happy exception… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2d ago
How to Build an Hourly Air-Quality Time Series (Without an API Key)
Almost every air-quality project starts the same way: someone wants a chart of PM2.5 over the last few months for a handful of cities… Continue reading on Mediu
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2d ago
SELECT * FROM tbl LIMIT 1; — The Query We All Use
I am sure most of us have written this query many times: Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2d ago
The Day I Stopped Ignoring Null Values in Databricks
When I first started learning PySpark, I paid most of my attention to the rows that contained data. Continue reading on Medium »
DeepCamp AI