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 · JavaScript
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
How I Linked Commodity Price Signals to Listed Companies — and What the Data Found
I recently launched a rules-based macro stress monitor for African and LatAm economies on Apify. Continue reading on Medium »
Dev.to · SM
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Adding Commodity-to-Equity Linkage to a Macro Stress Monitor
I recently launched a rules-based macro stress monitor for African and LatAm economies on Apify. It...
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Derived Tables in SQL
When learning SQL, most people focus on SELECT statements, JOINs, GROUP BY, and Window Functions. However, one concept that frequently… Continue reading on Medi
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Best Tools to Scrape Shopee Data in Southeast Asia (2026)
Disclosure: I built the Shopee Multi-Region Scraper listed in this article. Continue reading on Medium »
Dev.to AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Census Bureau Bans Noise Infusion: What It Means for Your Data
Census Bureau Bans Noise Infusion: What It Means for Your Data Meta Description: Discover what noise infusion banned from statistical products published by Cens
Dev.to · Xia Yu
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
How I Built an eCPM Diagnosis Dashboard for Mobile Game Ad Revenue
Every small mobile game team eventually runs into the same question: Why did ad revenue change...
Dev.to · Raizan
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Airbyte vs n8n vs Temporal for API data pipelines
A practical guide covering airbyte vs n8n vs temporal for api data pipelines.
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Data Analytics with Gen AI — IDSA Janakpuri
Step into the future of analytics! At the Institute of Data Science and Analytics, Janakpuri, we bring you a cutting‑edge Data Analytics… Continue reading on Me
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Facebook Knows More Than You Think: The Data Empire Behind Years of Privacy Lawsuits — Joseph Sides
Facebook is not just a social media app. It is one of the largest data-gathering machines ever built. Every profile update, like, comment… Continue reading on M
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Facebook Knows More Than You Think: The Data Empire Behind Years of Privacy Lawsuits — Joseph Sides
Facebook is not just a social media app. It is one of the largest data-gathering machines ever built. Every profile update, like, comment… Continue reading on M
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Why Microsoft is Freezing the Internet in Glass: The Wild Reality of Project Silica
Hard drives are dying. Tapes are rotting. Meet the 10,000-year, indestructible, zero-energy glass coaster that is about to revolutionize… Continue reading on Me
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Show Me The Money: Which Film Genre Brings in the Big Bucks?
The difference between making money and making ALL the money Continue reading on The Ugly Monster »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Analysed 56,000 Rows of Terrorism Data — Here’s What I Found (and Built)
A beginner data scientist’s journey from a messy CSV to a live interactive dashboard Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Analysed 56,000 Rows of Terrorism Data — Here’s What I Found (and Built)
A beginner data scientist’s journey from a messy CSV to a live interactive dashboard Continue reading on Medium »
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Analysed 56,000 Rows of Terrorism Data — Here’s What I Found (and Built)
A beginner data scientist’s journey from a messy CSV to a live interactive dashboard Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Analysed 56,000 Rows of Terrorism Data — Here’s What I Found (and Built)
A beginner data scientist’s journey from a messy CSV to a live interactive dashboard Continue reading on Medium »
Medium · Deep Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Iceoutmap People over papers| Live Map
People Over Papers collect data on ICE sightings submitted by the public with the intention to inform the public and raise awareness. The… Continue reading on M
Medium · UX Design
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Iceoutmap People over papers| Live Map
People Over Papers collect data on ICE sightings submitted by the public with the intention to inform the public and raise awareness. The… Continue reading on M
Dev.to · Kanishga Subramani
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Day 17 of #100DaysOfClickHouse: Mastering Data Filtering for Faster ClickHouse Queries
When working with ClickHouse®, writing a query is usually straightforward. Writing an efficient...
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Learning Web Scraping Changed How I See the Internet
It started as a way to make money on Fiverr. It ended up rewiring my brain. Continue reading on Medium »
Dev.to · Gidado Mukhtar Balangoggo
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Microsoft Fabric Just Changed The Data Game
📊 Every day, billions of pieces of data are generated around the world. But raw data alone doesn't...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Hidden Cost of pandas.apply() (And the Habit That Replaces It)
Part 2 of the “Python Performance Secrets” series. .apply() feels vectorized. It isn't. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What a Brazil World Cup Documentary Taught Me About Statistics, Culture and Why Data Often…
Last night I was watching USA ’94: Brazil’s Return to Glory on Netflix. But somewhere between nostalgia and football, a different question… Continue reading on
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Show Proportions of Your Data with Pie Chart in Matplotlib with Python
This is a simple and short tutorial on generating pie charts with Python. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Excel Learning Journey — Day 07
Understanding Logical Functions in Excel Continue reading on Medium »
Dev.to · Manveer Chawla
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What is the best real-time analytics database in 2026? An engineering buyer's guide
Traditional databases just can't keep up with high concurrency and low latency at the same time. The...
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Apache Spark 101
Apache Spark (Hereafter referred to as ‘Spark’) is a data processing framework designed to process large-scale data using distributed… Continue reading on Mediu
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Making of a Data & Payments Polymath
Over the years, I’ve often been asked how I would describe my role. Continue reading on Medium »
Medium · NLP
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
How Spotify Solved Choice Overload in 2015 (And Why Analysts Are Still Using the Framework in 2026)
How Spotify Kept You Hooked: Inside the Data Science of Discover Weekly Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What If Nonprofits Had Credit Scores?
Inside the IRS Form 990 data that almost nobody reads — and the tool I built to score charity efficiency. Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What If Nonprofits Had Credit Scores?
Inside the IRS Form 990 data that almost nobody reads — and the tool I built to score charity efficiency. Continue reading on Medium »
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
5 Data Schema Design Mistakes That Quietly Create Future Bottlenecks
And how to fix them before your database becomes the reason everything feels slow Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Reality of IPOs: What I Learned Parsing 2,655 SEC Filings
The filing was 847 pages long. I found the revenue number on page 312, buried inside a footnote that referenced a table three sections… Continue reading on Medi
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Reality of IPOs: What I Learned Parsing 2,655 SEC Filings
The filing was 847 pages long. I found the revenue number on page 312, buried inside a footnote that referenced a table three sections… Continue reading on Medi
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Built an AI to Measure Football Miracles. The Greatest One Is Moroccan.
A century and a half of results, an Elo model, and 40,000 simulated tournaments — to answer a question every fan has shouted at a screen… Continue reading on Me
Dev.to · Andrew
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Vertica vs VoltDB (Volt Active Data): Key Differences, Use Cases & How to Choose in 2026
If you're building a modern data stack that requires either high-throughput transaction processing or...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Data Analytics (AI/ML) ROI 101: Why Investments in Data Analytics (AI/ML) Vanish into the ‘Black…
Overview of the Data Analytics (AI/ML) ROI 101 series of articles Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Self-Hosting Airflow at Home: Automating Stock Price Data Collection
I ran Airflow at home to pull live stock data. Here’s how I did it and what I learned. Continue reading on Analytics Vidhya »
Simon Willison's Blog
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Mapping SQLite result columns back to their source `table.column`
Research: Mapping SQLite result columns back to their source `table.column` It would be neat if arbitrary SQL queries in Datasette could be rendered with additi
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
PGx Testing: The Genetic Blind Spot in Modern Prescribing
Why pharmacogenomic testing may become one of the most underused tools in pain management, behavioral health, and primary care Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Reflections on Anthropic’s Self-Service Data Analytics Playbook
The bottleneck in self-service analytics is not the AI. Continue reading on Medium »
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
You Don’t Need a Modern Data Stack You Just Need a Good Server
For the last decade, if you asked a startup how to count their daily active users, the answer was a $15,000-a-month Rube Goldberg machine. Continue reading on T
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
You Don’t Need a Modern Data Stack You Just Need a Good Server
For the last decade, if you asked a startup how to count their daily active users, the answer was a $15,000-a-month Rube Goldberg machine. Continue reading on T
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
7 Funções de Excel que Descobri no Início da Minha Jornada em Análise de Dados
Recentemente comecei minha transição para a área de Análise de Dados e tenho dedicado parte do meu tempo a estudar ferramentas e conceitos… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
10 SQL Interview Problems That Tripped Me Up
The exact patterns that decide most data engineering SQL screens, with explanations that build real intuition. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
SQL Window Functions Explained: The Most Powerful SQL Feature Every Data Analyst Should Master
Real-World Window Function Examples Every Analyst Should Know Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Why the World Cup Favorite Almost Never Wins
The best team on paper has lost more World Cups than it’s won. Continue reading on AI & Analytics Diaries »
Medium · Startup
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Encore Launches Diamond Currency Intelligence Application : A New Era of Risk-Aware Trading for…
Risk analytics meets the diamond trade — built for importers, exporters, and traders across India Continue reading on Medium »
DeepCamp AI