Tech Skills

Data Analytics & Business Intelligence

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

16,809
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,341) Articles (3015)Blog Posts (3422)Tutorials (369)Research Papers (39)News (496)
Cohort metrics and retention of TON wallets 2026
Dev.to · ton-adoption 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Cohort metrics and retention of TON wallets 2026
Why DAU/MAU mislead on TON and how to rebuild cohorts from on-chain data. Notcoin, DOGS, Hamster Kombat versus organic Wallet-in-Telegram inflow.
Tabula vs Camelot vs pdfplumber in 2026: Which Python Library Actually Wins?
Dev.to · Martin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Tabula vs Camelot vs pdfplumber in 2026: Which Python Library Actually Wins?
When you need to extract tables from PDFs in Python, three libraries dominate every Stack Overflow...
A Beginners guide to Real-time Data Streaming with Apache Kafka
Dev.to · GeraldM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
A Beginners guide to Real-time Data Streaming with Apache Kafka
Introduction Ever wondered how banks are able to detect and stop fraud in real-time? This...
Tracking Data Extract vs Data Views: Get Data Out of SFMC
Dev.to · SapotaCorp 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Tracking Data Extract vs Data Views: Get Data Out of SFMC
Client wants all tracking data in their data warehouse for analysts to slice. Exporting one CSV at a time from the UI isn't scalable. Tracking Data Extract and
Designing the SFMC Data Model Before You Create a Single DE
Dev.to · SapotaCorp 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Designing the SFMC Data Model Before You Create a Single DE
Most Salesforce Marketing Cloud projects end up with a Data Extension sprawl that can't be joined, segmented, or reported on. The fix is a 30-minute data model
SQL Query Activity in SFMC: Joins, Archives, and Segmentation
Dev.to · SapotaCorp 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
SQL Query Activity in SFMC: Joins, Archives, and Segmentation
SQL Query is the only Automation Studio Activity that can join multiple Data Extensions, aggregate data, or do anything a Filter Activity can't. Here are the th
Orchestration Patterns: Scheduling, Retries, and Observability
Dev.to · beefed.ai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Orchestration Patterns: Scheduling, Retries, and Observability
Design resilient, observable data workflows: cron vs event triggers, dependency management, retries, SLA monitoring, and scaling strategies for produc
Chai aur SQL — A Beginner's Journey into Databases
Dev.to · Abdul Rahman 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Chai aur SQL — A Beginner's Journey into Databases
SQL stands for Structured Query Language. It is the language we use to talk to relational databases...
Day 4: Creating Tables – Data Types, NULL, and DEFAULT Constraints
Dev.to · CodeWithDhanian 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Day 4: Creating Tables – Data Types, NULL, and DEFAULT Constraints
The Foundation of Every Relational Database: Why Table Creation Matters When you build any...
Trouble in Treasure Hunt Land
Dev.to · ruth mhlanga 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Trouble in Treasure Hunt Land
The Problem We Were Actually Solving The key challenge lay in managing the vast amount of...
Single-Node Data Engineering: DuckDB, DataFusion, Polars, and LakeSail
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Single-Node Data Engineering: DuckDB, DataFusion, Polars, and LakeSail
For the past decade, data engineering was synonymous with distributed clusters. If your dataset...
BrightData Web Unlocker ate 40% of our B2B enrichment budget for 12% lift
Dev.to · Elena Revicheva 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
BrightData Web Unlocker ate 40% of our B2B enrichment budget for 12% lift
Originally published on AIdeazz — cross-posted here with canonical link. $1.50 per 1000 requests...
Advanced Web Scraping with Power Query: Automating Data Extraction for SEO and Analytics
Dev.to · Dnyaneshwar Ware 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Advanced Web Scraping with Power Query: Automating Data Extraction for SEO and Analytics
A technical guide to building robust data extraction pipelines using Power Query to automate your SEO auditing and analytics dashboards.
I found a silent data bug that returned the wrong analytics
Dev.to · Miguel Esteves 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I found a silent data bug that returned the wrong analytics
I was working on a take-home assessment for a staffing platform API — a NestJS + Prisma + SQLite...
What 3.9M powerlifting records tell us about competition strategy — an EDA with Python
Dev.to · Rubén Gil 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What 3.9M powerlifting records tell us about competition strategy — an EDA with Python
What 3.9M powerlifting records tell us about competition strategy — an EDA with Python When I...
An In-Depth Overview of the Apache Iceberg 1.11.0 Release
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
An In-Depth Overview of the Apache Iceberg 1.11.0 Release
Apache Iceberg 1.11.0 was officially released on May 19, 2026, marking a major milestone in the...
How I Test My Data Skills Before Every Interview — 5 Self-Assessments That Showed Me What I Didn't Know
Dev.to · Deepanshu Garg 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How I Test My Data Skills Before Every Interview — 5 Self-Assessments That Showed Me What I Didn't Know
Six months ago I started a self-directed data science program. Every day I study something — SQL...
Treasure Hunt Engine Optimizations Are Not Configuration Tweaks
Dev.to · ruth mhlanga 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Treasure Hunt Engine Optimizations Are Not Configuration Tweaks
The Problem We Were Actually Solving The main goal was to provide real-time analytics...
Your New Domain's First Week of GA4 Is a Lie: 4 Days of Raw Data from a Launch
Dev.to · Ken Imoto 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your New Domain's First Week of GA4 Is a Lie: 4 Days of Raw Data from a Launch
Four days after registering a new domain, GA4 showed 65 page views and 34 users across 9 countries. Before celebrating, I beat the data with 5 signals. What sur
The Misguided Quest for Low-Latency Queries: A Cautionary Tale of Warehouse Cost Optimisation
Dev.to · ruth mhlanga 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Misguided Quest for Low-Latency Queries: A Cautionary Tale of Warehouse Cost Optimisation
The Problem We Were Actually Solving Our warehouse was serving millions of game events...
Designing an In-Game Inflation Tracking Algorithm for Web Utility Apps
Dev.to · Qumer Yas 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Designing an In-Game Inflation Tracking Algorithm for Web Utility Apps
In modern web development, scaling an application to track real-time transactional data presents...
Airflow vs n8n for API-driven data pipelines
Dev.to · Raizan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Airflow vs n8n for API-driven data pipelines
A practical guide covering airflow vs n8n for api-driven data pipelines.
Google Maps Scraper: Build Local Data Pipelines That Actually Run
Dev.to · BrowserAct 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Google Maps Scraper: Build Local Data Pipelines That Actually Run
You do not need another CSV export that works once and quietly dies three days later. A Google Maps...
The Best Data Engineering Interview Prep Tools in 2026: Complete Guide for Job Success
Dev.to · Ntech Global Solutions 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Best Data Engineering Interview Prep Tools in 2026: Complete Guide for Job Success
Data Engineering has become one of the most in-demand career paths in the tech industry. As...
MySQL Interview Questions & Answers: Top Patterns for Data Engineers
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
MySQL Interview Questions & Answers: Top Patterns for Data Engineers
mysql interview questions circle around six themes every loop tests: storage engines (InnoDB vs...
CREATE TABLE & ALTER TABLE in SQL: Schema Design for Data Engineers
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
CREATE TABLE & ALTER TABLE in SQL: Schema Design for Data Engineers
sql create table defines the shape of every relation in a database — columns and their types, primary...
SQL PIVOT and UNPIVOT: Reshape Rows ↔ Columns for Analytics
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
SQL PIVOT and UNPIVOT: Reshape Rows ↔ Columns for Analytics
sql pivot turns long-format rows into wide-format columns: one row per category becomes one column...
Real-Time Data Pipeline: Kafka to ClickHouse with Python
Dev.to · WDSEGA 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Real-Time Data Pipeline: Kafka to ClickHouse with Python
Build a production-grade real-time data pipeline using Python, Kafka, and ClickHouse. Features async...
Inventory Software Starts With Movement History
Dev.to · Pytagotech 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Inventory Software Starts With Movement History
The most common inventory question is simple: "How much stock do we have?" But the more important...
How to Generate Large-Scale Fake Data for Testing (Fast & Free Method)
Dev.to · Mayank 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to Generate Large-Scale Fake Data for Testing (Fast & Free Method)
When building applications, one of the biggest challenges is having realistic test data. Whether...
Semantic Layer Best Practices: 7 Mistakes to Avoid
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Semantic Layer Best Practices: 7 Mistakes to Avoid
Semantic layers don't fail because the technology is wrong. They fail because of design decisions...
How a Self-Documenting Semantic Layer Reduces Data Team Toil
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How a Self-Documenting Semantic Layer Reduces Data Team Toil
Every data team knows documentation is important. And almost every data team has a backlog of...
Choosing the Right Treasure Map to Avoid Data Decay in Veltrix
Dev.to · Lillian Dube 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Choosing the Right Treasure Map to Avoid Data Decay in Veltrix
The Problem We Were Actually Solving We thought we were solving the classic event-sourcing...
Migrating to Apache Iceberg: Strategies for Every Source System
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Migrating to Apache Iceberg: Strategies for Every Source System
This is Part 15, the final article of a 15-part Apache Iceberg Masterclass. Part 14 covered hands-on...
Hands-On with Apache Iceberg Using Dremio Cloud
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Hands-On with Apache Iceberg Using Dremio Cloud
This is Part 14 of a 15-part Apache Iceberg Masterclass. Part 13 covered streaming approaches. This...
Approaches to Streaming Data into Apache Iceberg Tables
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Approaches to Streaming Data into Apache Iceberg Tables
This is Part 13 of a 15-part Apache Iceberg Masterclass. Part 12 covered Python and MPP engines. This...
How Data Lake Table Storage Degrades Over Time
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Data Lake Table Storage Degrades Over Time
This is Part 9 of a 15-part Apache Iceberg Masterclass. Part 8 covered embedded catalogs. This...
Your backtest is lying to you: 6 ways future data leaks in
Dev.to · Matthieu David 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your backtest is lying to you: 6 ways future data leaks in
If you have ever built a strategy with a gorgeous equity curve that fell apart the moment you traded...
Cookieless web analytics: how it actually works under the hood
Dev.to · Zenovay 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Cookieless web analytics: how it actually works under the hood
"Cookieless analytics" gets thrown around as a marketing term. What does it actually mean technically? A complete breakdown of how visitor identification works
Data Product Team Structure: Centralized vs. Distributed
Dev.to · David Ohnstad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Product Team Structure: Centralized vs. Distributed
David Ohnstad debunks the myth that centralized data teams build better products. Discover why distributed ownership and federated models often outperform
SQL Date Functions: DATEDIFF, DATE_FORMAT, EXTRACT & Date Math
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
SQL Date Functions: DATEDIFF, DATE_FORMAT, EXTRACT & Date Math
sql date functions split into four families that every data engineering query eventually touches:...
GROUP BY and HAVING in SQL: Aggregation Patterns for Interviews
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
GROUP BY and HAVING in SQL: Aggregation Patterns for Interviews
GROUP BY in SQL collapses many detail rows into one row per distinct key combination, sql aggregate...
Getting code to work on a small test sample is easy, but watching a pipeline get OOM-killed in production is a rite of passage. Love the approach here, prioritizing a flat 0.41 MB memory contract over raw speed is how data pipelines should be built.
Dev.to · Abatan EniolaNimi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Getting code to work on a small test sample is easy, but watching a pipeline get OOM-killed in production is a rite of passage. Love the approach here, prioritizing a flat 0.41 MB memory contract over raw speed is how data pipelines should be built.
Validating 1 million rows in 0.41 MB of RAM (how I built a streaming data validator in...
Making Data Integration Easier with SeaTunnel Web
Dev.to · lefeng lefeng 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Making Data Integration Easier with SeaTunnel Web
Hi, I’m Bruce. Recently, I’ve been working on a project called SeaTunnel Web. The idea is simple:...
THUẬT TOÁN PHÂN LOẠI NGƯỜI DÙNG
Dev.to · Hoàng Mạnh Khiêm 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
THUẬT TOÁN PHÂN LOẠI NGƯỜI DÙNG
🎯 BÀI TOÁN Có: 2,666 users, mỗi user vào các pages khác nhau (DealHot, Mission,...
KPI Tracking with SQL: A Practical Starter Kit for SaaS Developers
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
KPI Tracking with SQL: A Practical Starter Kit for SaaS Developers
Learn how to track the most critical SaaS KPIs—MRR, churn, DAU/MAU stickiness, ARPU, and more—directly from your database using SQL, with real query examples an
The Default Config Trap: Why Most Data Pipelines Fail At 100 Requests Per Second
Dev.to · ruth mhlanga 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Default Config Trap: Why Most Data Pipelines Fail At 100 Requests Per Second
The Problem We Were Actually Solving Our team had built a data pipeline using Veltrix, a...
Building Data Infrastructure for 50K Queries per Second and Still Making Room for New Features
Dev.to · ruth mhlanga 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building Data Infrastructure for 50K Queries per Second and Still Making Room for New Features
The Problem We Were Actually Solving At this scale, our system would start to choke on any...