Tech Skills

Data Analytics & Business Intelligence

Excel, SQL, Power BI, Tableau — turn raw data into business decisions

17,219
lessons
Skills in this topic
View full skill map →
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
All Reads (7,743) Articles (3283)Blog Posts (3520)Tutorials (399)Research Papers (42)News (499)
How to Convert Jupyter Notebook to PDF Without Installing Anything
Dev.to · Aaron He 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
How to Convert Jupyter Notebook to PDF Without Installing Anything
If you've ever tried to share a Jupyter Notebook as a PDF, you know the pain. The standard approach...
What Happened in Apache SeaTunnel? This March You Shouldn’t Miss
Dev.to · Apache SeaTunnel 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
What Happened in Apache SeaTunnel? This March You Shouldn’t Miss
Hey there! The March 2026 report is here. The Apache SeaTunnel community has been incredibly active....
ETL vs ELT: Which One Should You Use and Why?
Dev.to · John Wakaba 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
ETL vs ELT: Which One Should You Use and Why?
A Beginner's Guide to Data Pipeline Architecture If you have ever worked with data or heard...
Healthcare BPO Projects by Zoetic BPO Services: Enhancing Healthcare Data Accuracy
Dev.to · zoetic 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Healthcare BPO Projects by Zoetic BPO Services: Enhancing Healthcare Data Accuracy
Healthcare systems require precision, clarity, and well-organized information to function...
Fast-Track Your Career: Learn Data Science in 3 Months
Dev.to · Rinku Durge 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Fast-Track Your Career: Learn Data Science in 3 Months
In 2026, data science continues to be one of the most sought-after career paths. With businesses...
Veri BilimiDinamik Akış: Müşteri Hizmetleri Chatbot Tüm Detaylar.
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Veri BilimiDinamik Akış: Müşteri Hizmetleri Chatbot Tüm Detaylar.
Web Geliştirme Web teknolojilerinde güncel kalarak projelerinizi bir üst seviyeye...
How to Scrape YouTube Video Data with Python in 2026
Dev.to · agenthustler 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
How to Scrape YouTube Video Data with Python in 2026
YouTube is the world's second-largest search engine with over 2 billion monthly users. Whether you're...
PostgreSQL JSONB for Multi-Region Video Analytics
Dev.to · ahmet gedik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
PostgreSQL JSONB for Multi-Region Video Analytics
Using JSONB columns to store flexible analytics for a global video platform covering Nordic, Middle
Book Market Research with Goodreads Data: Finding Your Audience and Positioning Your Book
Dev.to · agenthustler 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Book Market Research with Goodreads Data: Finding Your Audience and Positioning Your Book
Why Scrape Goodreads? Goodreads is the world's largest book community — 150+ million...
The Data Pipeline Behind 6.3M Polymarket Prices: SQLite, Python, and 4-Minute Updates
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
The Data Pipeline Behind 6.3M Polymarket Prices: SQLite, Python, and 4-Minute Updates
I collect every price movement across 7,500+ Polymarket prediction markets. Every 4 minutes. That's...
Entity Resolution at Scale: Matching Products Across Amazon, Reddit, and RTINGS
Dev.to · Daniel Rozin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Entity Resolution at Scale: Matching Products Across Amazon, Reddit, and RTINGS
"AirPods Pro 2," "Apple AirPods Pro (2nd Generation)," "AirPods Pro USB-C" — same product, three...
5 Free APIs for Global Economic Data in 2026 (No API Key Needed)
Dev.to · Statistics of the World 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
5 Free APIs for Global Economic Data in 2026 (No API Key Needed)
If you're building anything that needs country-level economic data — a dashboard, a research tool, a...
Metí el historial completo de git de Linux en una base de datos — y lo que encontré me pareció arqueología
Dev.to · Juan Torchia 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Metí el historial completo de git de Linux en una base de datos — y lo que encontré me pareció arqueología
Qué pasa cuando dejás de tratar tu historial de commits como logs y empezás a tratarlo como datos. Lo hice con repos viejos míos. Lo que encontré fue incómodo,
AWS Lake Formation: Why Your Data Lake Permissions Are Probably a Mess (And How to Fix That)
Dev.to · Soumyadeep Basu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
AWS Lake Formation: Why Your Data Lake Permissions Are Probably a Mess (And How to Fix That)
Week 1 of a series on AWS Lake Formation — from fundamentals to real-world implementation If you've...
Building a Celebrity Wealth Simulator: The Intersection of Data Science and Pop Culture
Dev.to · Knownalytics 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Building a Celebrity Wealth Simulator: The Intersection of Data Science and Pop Culture
In the digital era, the way we consume celebrity news is shifting from static text to interactive,...
Bulut Tabanlı ETL (Extract, Transform, Load) Süreçleri
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Bulut Tabanlı ETL (Extract, Transform, Load) Süreçleri
Bulut Tabanlı ETL (Extract, Transform, Load) Süreçleri, veri yönetimi ve analitiği için kritik bir...
Wallet Attribution at Scale: ER on 13M Blockchain Records
Dev.to · benzsevern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Wallet Attribution at Scale: ER on 13M Blockchain Records
Running entity resolution across 10 public blockchain attribution datasets surfaces cross-jurisdictional sanctions and universal infrastructure patterns.
Advanced Data Engineering on Google Cloud
Dev.to · Shehzad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Advanced Data Engineering on Google Cloud
In today’s data-driven world organisations rely heavily on data to make strategic decisions, improve...
SQL WHERE Clause: The Complete Guide to Filtering Data
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
SQL WHERE Clause: The Complete Guide to Filtering Data
SQL WHERE Clause: The Complete Guide to Filtering Data Imagine you have a database with a...
PostgreSQL JSONB for Tracking European Video Trends
Dev.to · ahmet gedik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
PostgreSQL JSONB for Tracking European Video Trends
Using JSONB columns to store and query regional video analytics across European markets with Postgre
Scientists Have Known the Exact Mutation That Causes Huntington's Disease for 33 Years. Every Trial Still Learns in Isolation.
Dev.to · Rory | QIS PROTOCOL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Scientists Have Known the Exact Mutation That Causes Huntington's Disease for 33 Years. Every Trial Still Learns in Isolation.
In 1993, a consortium led by James Gusella and Nancy Wexler identified the gene that causes...
Future of Team Intelligence Dashboards Powered by WorkOS Data
Dev.to · David Davis 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Future of Team Intelligence Dashboards Powered by WorkOS Data
Modern teams are no longer limited by a lack of data. The real challenge today is turning that data...
Stream Processing vs Batch Processing: When to Use Each
Dev.to · Dylan Dumont 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Stream Processing vs Batch Processing: When to Use Each
Batch processing offers throughput and accuracy, while stream processing offers latency. Your...
ALS Has 30,000 American Patients and 150 Specialized Centers. None of Them Route Their Outcome Intelligence to Each Other.
Dev.to · Rory | QIS PROTOCOL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
ALS Has 30,000 American Patients and 150 Specialized Centers. None of Them Route Their Outcome Intelligence to Each Other.
Amyotrophic lateral sclerosis kills a median of 2 to 5 years after diagnosis. There is no cure. There...
How to Extract Data from Substack in 2026: Newsletter Posts, Subscriber Counts, and Author Stats
Dev.to · agenthustler 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
How to Extract Data from Substack in 2026: Newsletter Posts, Subscriber Counts, and Author Stats
Substack has become one of the most important platforms for independent journalism and newsletter...
Airflow vs Prefect vs Dagster: Picking the Right Orchestrator in 2026
Dev.to · DataStackX 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Airflow vs Prefect vs Dagster: Picking the Right Orchestrator in 2026
Your data pipeline orchestrator is the nervous system of your data platform. Every pipeline, every...
Your Customer Table Has Duplicates You Can't See With SQL How I Built a Cross-Platform Identity Resolution Layer for a Dark Kitchen Data Platform
Dev.to · SARAN TEJA MALLELA 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Your Customer Table Has Duplicates You Can't See With SQL How I Built a Cross-Platform Identity Resolution Layer for a Dark Kitchen Data Platform
I'm Saran Teja Mallela — a data engineer based in Houston, TX. I build batch and streaming pipelines...
Building a Talent Intelligence Pipeline with LinkedIn Job Data (2026)
Dev.to · agenthustler 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Building a Talent Intelligence Pipeline with LinkedIn Job Data (2026)
TL;DR: Extract LinkedIn job listings at scale without LinkedIn's $50,000/year enterprise API. Build...
116 Alzheimer's Drugs Failed Between 2002 and 2012. Every Trial Learned in Isolation.
Dev.to · Rory | QIS PROTOCOL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
116 Alzheimer's Drugs Failed Between 2002 and 2012. Every Trial Learned in Isolation.
Between 2002 and 2012, the pharmaceutical industry ran 99 Phase II and Phase III clinical trials for...
Visualizing Expected Stock Price Movement with Python and Volatility Cones
Dev.to · Ayrat Murtazin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Visualizing Expected Stock Price Movement with Python and Volatility Cones
Build a Monte Carlo simulation engine to project probabilistic price ranges using historical volatility.
Data Engineering Interview Prep (2026): What Actually Matters (SQL, Pipelines, System Design)
Dev.to · Hadil Ben Abdallah 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Data Engineering Interview Prep (2026): What Actually Matters (SQL, Pipelines, System Design)
Most candidates don’t fail data engineering interviews because of SQL or Python; they fail because...
How to Convert JSON to Excel — Python, Online Tool & No-Code Methods
Dev.to · Imad Uddin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
How to Convert JSON to Excel — Python, Online Tool & No-Code Methods
Got JSON data you need in a spreadsheet? Here's how to get there. Python with pandas...
How to Convert JSON to JSONL (JSON Lines) — With Code Examples & Free Tool
Dev.to · Imad Uddin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
How to Convert JSON to JSONL (JSON Lines) — With Code Examples & Free Tool
JSONL (JSON Lines) puts one JSON object per line — no wrapping array, no commas between records. It's...
How to Prevent P-Hacking in A/B Testing with Convert Experiences
Convert Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
How to Prevent P-Hacking in A/B Testing with Convert Experiences
In this article, we’re looking at where p-hacking creeps into experimentation (intentionally or accidentally). And show how to prevent it without slowing down y
VLOOKUP Doesn
Dev.to · GrimLabs 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
VLOOKUP Doesn
If you've ever tried to match two spreadsheets together, you know this pain. You've got a list of...
Advanced SQL Techniques for Data Analytics Every Data Analyst Should Know
Dev.to · Lawrence Murithi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Advanced SQL Techniques for Data Analytics Every Data Analyst Should Know
Introduction In today’s data-driven environment, organizations rely heavily on data to...
5 Open Source Data Visualization Libraries for Building Custom Dashboards
Dev.to · 137Foundry 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
5 Open Source Data Visualization Libraries for Building Custom Dashboards
When off-the-shelf dashboard platforms do not fit your product, you need a charting library that...
Why Custom Reporting Tools Outperform Generic BI Platforms for Growing Teams
Dev.to · 137Foundry 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Why Custom Reporting Tools Outperform Generic BI Platforms for Growing Teams
A 15-person startup signs up for a BI platform because the sales demo looked great. Six months later,...
I Built a Free Polymarket Analytics Dashboard — 6M+ Prices, 7,500 Markets, Updated Every 4 Minutes
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
I Built a Free Polymarket Analytics Dashboard — 6M+ Prices, 7,500 Markets, Updated Every 4 Minutes
Most Polymarket tools show you one market at a time. Price chart, yes/no, maybe a volume number....
Apache Data Lakehouse Weekly: April 3–9, 2026
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Apache Data Lakehouse Weekly: April 3–9, 2026
The open lakehouse community gathered in San Francisco this week for the biggest Iceberg Summit yet,...
GPA Calculator - Free Tools and Resources for College Students
Dev.to · gpacalcteam 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
GPA Calculator - Free Tools and Resources for College Students
Calculating your GPA should not be complicated. Here is a collection of tools and resources to help...
The Case for Market Efficiency in Modern Sports Analysis
Dev.to · jason 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
The Case for Market Efficiency in Modern Sports Analysis
Every major sports league now generates terabytes of tracking data per season. Player movement, ball...
Cross-Market Analysis: What the Data Actually Shows
Dev.to · jason 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Cross-Market Analysis: What the Data Actually Shows
Markets are information aggregation machines. When thousands of participants express their views...
How Rest Day Effects Separates Signal from Noise
Dev.to · jason 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
How Rest Day Effects Separates Signal from Noise
Professional sports analysis looks nothing like what you see on television. While pundits debate...
Breaking Down Asian Handicaps: A Data-Driven Perspective
Dev.to · jason 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Breaking Down Asian Handicaps: A Data-Driven Perspective
Markets are information aggregation machines. When thousands of participants express their views...
The Case for Asian Handicaps in Modern Sports Analysis
Dev.to · jason 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
The Case for Asian Handicaps in Modern Sports Analysis
Every major sports league now generates terabytes of tracking data per season. Player movement, ball...
The Case for Odds Comparison in Modern Sports Analysis
Dev.to · jason 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
The Case for Odds Comparison in Modern Sports Analysis
The sports analysis industry has undergone a quiet revolution over the past decade. What used to rely...
The Case for Scheduling Edges in Modern Sports Analysis
Dev.to · jason 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
The Case for Scheduling Edges in Modern Sports Analysis
Markets are information aggregation machines. When thousands of participants express their views...