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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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