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

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...

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...

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...

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,...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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

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...

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...

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...

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...

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...

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...

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.

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...

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....

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...

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...

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...

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...

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...

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...

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

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...

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...

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...
DeepCamp AI