Tech Skills

Data Analytics & Business Intelligence

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

16,813
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,345) Articles (3018)Blog Posts (3422)Tutorials (370)Research Papers (39)News (496)
Why every CS2-to-CSGO rank converter gives you a different answer (and how I picked one)
Dev.to · graysonwerner100-commits 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why every CS2-to-CSGO rank converter gives you a different answer (and how I picked one)
I built a small tool called cs2rankconverter.com — punch in your CS2 Premier rating, get the...
Your Pipeline Is 26.4h Behind: Catching Climate Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your Pipeline Is 26.4h Behind: Catching Climate Sentiment Leads with Pulsebit
Your Pipeline Is 26.4h Behind: Catching Climate Sentiment Leads with Pulsebit We recently stumbled...
Data Analyst Interview Questions 2026: SQL, Business Cases, and Behavioral (What Actually Gets You Hired)
Dev.to · ManyOffer Career 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Analyst Interview Questions 2026: SQL, Business Cases, and Behavioral (What Actually Gets You Hired)
Most people preparing for data analyst interviews in 2026 treat them like SQL exams. That is the...
SQL Interview Questions for Data Engineering
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
SQL Interview Questions for Data Engineering
SQL interview questions for data engineering circle around the same four primitives in every loop,...
Why WHERE phone = NULL Returns Nothing in SQL
Dev.to · Dechive 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why WHERE phone = NULL Returns Nothing in SQL
If you are new to SQL, this query can look perfectly reasonable at first: SELECT name FROM...
# Python and Its Role in Data Analytics.
Dev.to · Kigen Tarus 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
# Python and Its Role in Data Analytics.
Introduction Python has become one of the most widely used programming languages in the...
Apache Airflow for Beginners: DAGs, Tasks, Operators, and Scheduling
Dev.to · Robert Njuguna 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Apache Airflow for Beginners: DAGs, Tasks, Operators, and Scheduling
When one needs to run a series of scripts in a specific order, say you first want to extract the...
Python and Its Role in Data Analytics
Dev.to · Joan Wambui 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python and Its Role in Data Analytics
Introduction Python is a programming language. But if you are hearing that for the first...
Managed Iceberg: Optimizing a Modern Lakehouse
Dev.to · Joni Sar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Managed Iceberg: Optimizing a Modern Lakehouse
A modern lakehouse looks simple from the outside. Data lands in object storage. Apache Iceberg...
"We Have DevOps, So Why Not DataOps?"
Dev.to · sezin öztekin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
"We Have DevOps, So Why Not DataOps?"
Lately, we’ve all noticed the explosion of DevOps job postings on platforms like LinkedIn. It’s...
How We Compressed 63.5 GB of Financial Tick Data to 5.5 GB
Dev.to · Parth Khare 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How We Compressed 63.5 GB of Financial Tick Data to 5.5 GB
At AlphaBots, we run an algorithmic trading platform that processes live market data across Indian...
You Connected the Dataset. You Expected Code. It Didn't Come.
Dev.to · Mr Chandravanshi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
You Connected the Dataset. You Expected Code. It Didn't Come.
The next box appeared on its own. A transformation node. A suggested join. Half the logic was already...
OLAP vs OLTP: What's the Difference and Why Does It Matter?
Dev.to · Robert Njuguna 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
OLAP vs OLTP: What's the Difference and Why Does It Matter?
If you've ever worked with databases, you've probably heard these two terms (OLAP and OLTP). But what...
# Python in data analytics: what it is, why it works, and how to start
Dev.to · Brian Muriithi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
# Python in data analytics: what it is, why it works, and how to start
Python started as a hobby project. Guido van Rossum spent Christmas break in 1989 writing an...
Python for Data Analytics: A Beginner’s Complete Guide
Dev.to · Audrine Marion 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Analytics: A Beginner’s Complete Guide
In today’s digital world, data has become one of the most valuable resources. Every time we shop...
Python and Its Role in Data Analytics: A Beginner-Friendly Guide Using Logistics Data
Dev.to · NelimaL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python and Its Role in Data Analytics: A Beginner-Friendly Guide Using Logistics Data
Introduction In today’s digital economy, organizations generate huge amounts of data every...
Python and how Python is used in the data analytics space.
Dev.to · Jesse Ngugi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python and how Python is used in the data analytics space.
Hey there! If you've ever looked at a massive spreadsheet and felt overwhelmed, or wondered how...
PYTHON AND HOW IT IS USED IN THE DATA ANALYTICS SPACE.
Dev.to · Emman Kibet 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
PYTHON AND HOW IT IS USED IN THE DATA ANALYTICS SPACE.
Python and Data Analytics: A Practical Guide for Beginners If you've ever wondered how companies...
Introduction to Python for Data Analytics
Dev.to · Ibrahim0695 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Introduction to Python for Data Analytics
Introduction Over the last decade, Python has transitioned from a general-purpose...
Introduction to Python
Dev.to · Enock Kiprotich 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Introduction to Python
Python for Data Analytics: From Beginner Basics to Real-World Data Projects A...
Mastering Power Query in Power BI: A Complete Data Transformation Guide
Dev.to · Bamgboye Simisola 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Mastering Power Query in Power BI: A Complete Data Transformation Guide
Power Query is the backbone of data preparation in Power BI. Before you can build stunning dashboards...
How I scraped 50k YouTube subtitles in 2 weeks for $7 (and the legal gray zones)
Dev.to · qcrao 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How I scraped 50k YouTube subtitles in 2 weeks for $7 (and the legal gray zones)
When I started building TubeVocab, I had a chicken-and-egg problem. I needed a corpus of YouTube...
Building a Unified Korean Entertainment Database from 10 APIs and Web Scrapers
Dev.to · Cara Jung 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building a Unified Korean Entertainment Database from 10 APIs and Web Scrapers
Korean entertainment has become a global phenomenon with shows such as Squid Game breaking records...
Data Engineer Skills Companies Want in 2026: 6,877-Posting Analysis
Dev.to · Gnana 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Engineer Skills Companies Want in 2026: 6,877-Posting Analysis
The Data Engineer Title Has Settled Into a Stack Where "Data Analyst" still hides three or...
Apache NiFi a quick guide
Dev.to · Manoj 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Apache NiFi a quick guide
A comprehensive reference covering concepts, architecture, components, ecosystem alternatives, and...
Fast, Efficient, and Confidently Delivered — But Wrong
Dev.to · John Dreic 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Fast, Efficient, and Confidently Delivered — But Wrong
Two analysts, two definitions of Revenue, both right, neither agreed. Here's an agent that queries the data directly and shows you the SQL.
Why I Index Only 32k Companies When Apollo Has 250M: A B2B Database Trade-off
Dev.to · Vivek Singh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why I Index Only 32k Companies When Apollo Has 250M: A B2B Database Trade-off
One of the questions I get from prospects evaluating findmemail.io against Apollo or ZoomInfo: "your...
Python used in Data Analytics
Dev.to · jayson kibet 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python used in Data Analytics
Introduction Python is simply a high-level programming language used in data analytics,web...
keep your snapshots simple
Dev.to · Philip Hern 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
keep your snapshots simple
snapshots are powerful but expensive. use them only when absolutely necessary, never stack them on top of each other, and let the rest of your warehouse stay de
Building a Real-Time Crypto Volatility Surface System
Dev.to · Sean Gordon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building a Real-Time Crypto Volatility Surface System
See the PoC/MVP here: https://dashboard.derivasys.com Over the past few months I’ve been building...
Database sekolah Indonesia
Dev.to · Eko Priyanto 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Database sekolah Indonesia
Database sekolah Indonesia dengan cara scrape dari api tidak resmi...
Data Modeling in Power BI: Joins, Relationships, and Schemas Explained
Dev.to · Cynthia Sophie Mwangi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Modeling in Power BI: Joins, Relationships, and Schemas Explained
Introduction Data Modeling, the beginning of making sense out of data. This is one of the...
Analyzing Steam Games 2025: Genres, Players and User Ratings
Dev.to · Daniel Sánchez Moares 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Analyzing Steam Games 2025: Genres, Players and User Ratings
As part of my Master in Data Science & AI at Evolve, I worked on a data analysis project using a...
What Is Benthorne Execution System?
Dev.to · Benthorne Execution System 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What Is Benthorne Execution System?
Benthorne Execution System is a conceptual framework used to describe how modern data-driven systems...
SQL for Python Developers — Everything You Actually Need to Know
Dev.to · Prashik besekar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
SQL for Python Developers — Everything You Actually Need to Know
You know Python. Now learn the one skill that makes you twice as valuable. Why Python...
How to Sync Data from Elasticsearch to Elasticsearch
Dev.to · 罗梦婷 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to Sync Data from Elasticsearch to Elasticsearch
This article describes how to migrate and sync data from Elasticsearch to Elasticsearch using BladePipe and the Elasticsearch incremental data capture plugin.
I Built a Python Dashboard to Monitor My Cement Plant in Real Time
Dev.to · Aminuddin M Khan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Built a Python Dashboard to Monitor My Cement Plant in Real Time
From the control room to the code editor — a 40-year veteran's guide to building industrial...
Data Analyst Skills Companies Want in 2026: 2,500-Posting Analysis
Dev.to · Gnana 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Analyst Skills Companies Want in 2026: 2,500-Posting Analysis
We analyzed 2,585 active Data Analyst postings to map the skills companies actually want in 2026....
RFM Segmentation for B2B SaaS: The 11-Segment Model That Changed Our Clients' Retention
Dev.to · Alex Boissonneault 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
RFM Segmentation for B2B SaaS: The 11-Segment Model That Changed Our Clients' Retention
Most B2B companies treat customer segmentation like a binary: you're either active or churned. That's...
Idempotency in Data Pipelines: How to Prevent Duplicate Records
Dev.to · 137Foundry 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Idempotency in Data Pipelines: How to Prevent Duplicate Records
A pipeline that runs twice should produce the same result as one that runs once. That property is...
How to Build a Dead Letter Queue System for Reliable Data Processing
Dev.to · 137Foundry 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to Build a Dead Letter Queue System for Reliable Data Processing
Every data processing system will eventually receive a record it cannot handle. A missing required...
7 Essential Capabilities Insight Teams Need in a Modern Market Research Platform
Dev.to · Anastecia Dunu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
7 Essential Capabilities Insight Teams Need in a Modern Market Research Platform
Discover the 7 must-have capabilities for a modern market research platform. From AI-powered analysis...
The Essential Guide to Data Reconciliation: Best Practices & Use Cases
Dev.to · Quinnox Consultancy Services 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Essential Guide to Data Reconciliation: Best Practices & Use Cases
As organizations accelerate digital transformation, data has become their most valuable strategic...
How to Handle Weekend Data Gaps in XAUUSD Backtesting Without Losing Your Mind
Dev.to · Emily 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to Handle Weekend Data Gaps in XAUUSD Backtesting Without Losing Your Mind
The bug that wasn’t a bug Confession time: I spent a whole week debugging a gold strategy...
Comprehensive ETL Testing Strategy for Reliable Analytics
Dev.to · beefed.ai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Comprehensive ETL Testing Strategy for Reliable Analytics
A step-by-step ETL testing strategy to validate data accuracy, completeness, and lineage across source, transform, and warehouse for trustworthy analy
Apache NiFi vs Airflow: Which Platform is Better for ETL and Automation?
Dev.to · Aarav Singh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Apache NiFi vs Airflow: Which Platform is Better for ETL and Automation?
Building ETL pipelines is no longer just about transferring data from one system to another. Modern...
DatAasee 0.9 Released
Dev.to · Christian Himpe 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
DatAasee 0.9 Released
DatAasee Tech Stack Canvas Setting: Many distributed data and metadata...
I Built a Personal Knowledge Graph. Apple Had Already Built One on My Laptop.
Dev.to · Nic Lydon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Built a Personal Knowledge Graph. Apple Had Already Built One on My Laptop.
I've been building a system called Nexus for the past few months. It's a personal data platform: 54...