Tech Skills

Data Analytics & Business Intelligence

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

17,218
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,742) Articles (3283)Blog Posts (3520)Tutorials (399)Research Papers (41)News (499)
Free GEX Data — Gamma Exposure Levels for 6,000+ US Tickers (No Signup, No Credit Card)
Dev.to · tomasz dobrowolski 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Free GEX Data — Gamma Exposure Levels for 6,000+ US Tickers (No Signup, No Credit Card)
Live gamma exposure data — call wall, put wall, gamma flip — for any US ticker. Free chart, free API tier, no credit card required.
What 1,000 Airports Reveal About the World's Airlines
Dev.to · José Catalá 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
What 1,000 Airports Reveal About the World's Airlines
We just shipped the Airlines tab on MyAirports. You pick any airport, click Airlines, and you get...
Building a simple data pipeline with GCS and Databricks Autoloader
Dev.to · Yasmim 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Building a simple data pipeline with GCS and Databricks Autoloader
I built a small end-to-end pipeline to simulate a common data engineering scenario: ingesting new...
Subqueries and Cte's
Dev.to · Martin Ndungu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Subqueries and Cte's
Introduction SQL is a powerful language used for managing and analyzing data. As queries become more...
Implementing a Centralized Metrics Layer with dbt and a Semantic Layer
Dev.to · beefed.ai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Implementing a Centralized Metrics Layer with dbt and a Semantic Layer
Implement a centralized metrics layer with dbt: define metrics, test and govern them, and expose a semantic layer for consistent business KPIs.
SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each
Dev.to · Audrine Marion 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each
When working with SQL in analytics, reporting, or data engineering workflows, two powerful tools help...
Mobile App Analytics Accuracy: Why Your Data Is Wrong - And How to Fix It
Dev.to · Digia 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Mobile App Analytics Accuracy: Why Your Data Is Wrong - And How to Fix It
Mobile app analytics is often treated as a reliable source of truth. Events are tracked, dashboards...
Getting Data from Multiple Sources in Power BI: Building the Foundation of a Data Analytics Career
Dev.to · Dreez 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Getting Data from Multiple Sources in Power BI: Building the Foundation of a Data Analytics Career
Introduction Every meaningful insight in data analytics begins long before dashboards and...
How Linux is Used in Real-World Data Engineering
Dev.to · Naomi Jepkorir 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
How Linux is Used in Real-World Data Engineering
So, you know Python and think, "Hey, why don't I get into Data Engineering?" You have your learning...
The Brutal Truth About 37 Dev.to Posts: What My "Second Brain" Project Really Taught Me
Dev.to · KevinTen 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
The Brutal Truth About 37 Dev.to Posts: What My "Second Brain" Project Really Taught Me
The Brutal Truth About 37 Dev.to Posts: What My "Second Brain" Project Really Taught...
Your Pipeline Is 28.6h Behind: Catching Science Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Your Pipeline Is 28.6h Behind: Catching Science Sentiment Leads with Pulsebit
Your Pipeline Is 28.6h Behind: Catching Science Sentiment Leads with Pulsebit We’ve just...
5 Data Patterns That Scream 'Your Developer Is Burning Out
Dev.to · Артур Пан 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
5 Data Patterns That Scream 'Your Developer Is Burning Out
Burnout doesn't start with a resignation letter. IDE activity data reveals 5 warning patterns weeks before a developer quits or crashes.
Simon Willison's Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
SQL functions in Google Sheets to fetch data from Datasette
TIL: SQL functions in Google Sheets to fetch data from Datasette I put together some notes on patterns for fetching data from a Datasette instance directly into
How 80% of Our Signups Come From 20% of Countries: 6 Months of Geographic Data from an Indie AI Platform
Dev.to · Biricik Biricik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
How 80% of Our Signups Come From 20% of Countries: 6 Months of Geographic Data from an Indie AI Platform
How 80% of Our Signups Come From 20% of Countries: 6 Months of Geographic Data from an Indie...
Simon Willison's Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
datasette 1.0a27
Release: datasette 1.0a27 Two major changes in this new Datasette alpha. I covered the first of those in detail yesterday - Datasette no longer uses Django-styl
Bypassing the "Pandas RAM Tax": Building a Zero-Copy CSV Extractor in C
Dev.to · NARESH-CN2 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Bypassing the "Pandas RAM Tax": Building a Zero-Copy CSV Extractor in C
The Convenience Penalty Python is a masterpiece of productivity, but for high-volume data ingestion,...
Metrics, Logs, Traces, and Audit (Part 3)
Dev.to · Daniele Frasca 📊 Data Analytics & Business Intelligence 2mo ago
Metrics, Logs, Traces, and Audit (Part 3)
When a system reaches a global scale, teams usually have plenty of data. The real problem is figuring...
Practical SQL Concepts
Dev.to · Alex Waiganjo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Practical SQL Concepts
Introduction In today's world data driven world, data is becoming more valuable in that it...
Building a School Database from Scratch: A Practical Introduction to SQL
Dev.to · Shadrack Tesot 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Building a School Database from Scratch: A Practical Introduction to SQL
Building a school database from scratch There’s a certain kind of satisfaction that comes...
Applying SQL Concepts: DDL, DML, Filtering, and Data Transformation
Dev.to · Sharon-nyabuto 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Applying SQL Concepts: DDL, DML, Filtering, and Data Transformation
Structured Query Language (SQL) is the standard language used to interact with relational databases....
Unpacking the language of data: DDL, DML, Filtering and Transformation.
Dev.to · Zawadi Mwikali 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Unpacking the language of data: DDL, DML, Filtering and Transformation.
📌 DDL vs DML In SQL, commands are broadly divided into two categories: DDL (Data...
How I Built a System That Turns Raw Sales Data Into Business Decisions in A Day
Dev.to · Sai Sarvaja Boominathan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
How I Built a System That Turns Raw Sales Data Into Business Decisions in A Day
Most companies I've talked to have the same problem. They collect sales data religiously — every...
Why "Vibe Coding" Your Data Warehouse is a Terrible Idea
Dev.to · Lucas Ehara 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Why "Vibe Coding" Your Data Warehouse is a Terrible Idea
Recently, the term "vibe coding" has been everywhere. It’s that practice of sitting down, opening...
ETL vs ELT: Which One Should You Use and Why?
Dev.to · Lawrence Murithi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
ETL vs ELT: Which One Should You Use and Why?
Introduction Imagine you are running a massive kitchen. Every day, trucks arrive carrying...
Anketler İncelemesi - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Anketler İncelemesi - Detaylı Teknik Analiz Rehberi 2026
Anketler İncelemesi - Detaylı Teknik Analiz Rehberi 2026 Anketlerin Tarihçesi ve Gelişimi...
The Respondent
Dev.to · thesythesis.ai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
The Respondent
Consumer sentiment hit the lowest point in the survey's seventy-four-year history on the same day markets posted their best weekly gain in five months
Anketler Optimizasyonu - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Anketler Optimizasyonu - Detaylı Teknik Analiz Rehberi 2026
Anketlerin Tarihçesi ve Gelişimi Anketler, veri toplama yöntemleri arasında en eski ve en yaygın...
Veri BilimiTam Otomatik Müşteri Hizmetleri Chatbot İş Akışı
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Veri BilimiTam Otomatik Müşteri Hizmetleri Chatbot İş Akışı
Web Geliştirme Web teknolojilerinde güncel kalarak projelerinizi bir üst seviyeye...
Anketler: Pro Seviye - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Anketler: Pro Seviye - Detaylı Teknik Analiz Rehberi 2026
Anketlerin Tarihçesi ve Gelişimi Anket uygulamaları, veri toplama yöntemleri arasında köklü bir...
Tavsiye Iste: Pro Seviye - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Tavsiye Iste: Pro Seviye - Detaylı Teknik Analiz Rehberi 2026
Tavsiye Iste: Pro Seviye - Detaylı Teknik Analiz Rehberi 2026 Tarihçe ve Gelişim Süreci Teknik...
Stop writing pandas.merge() by hand: I built a Visual Join Builder for VS Code 🧩
Dev.to · Trushal 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Stop writing pandas.merge() by hand: I built a Visual Join Builder for VS Code 🧩
I got tired of typing this out, so I decided to build a tool that does it for me visually. Enter the...
Your Pipeline Is 15.9h Behind: Catching Renewable Energy Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Your Pipeline Is 15.9h Behind: Catching Renewable Energy Sentiment Leads with Pulsebit
Your pipeline is facing a 24h momentum spike of -0.344, indicating a notable shift in sentiment...
Always Pair VLOOKUP with ISNA (or IFERROR)
Dev.to · sugaiketadao 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Always Pair VLOOKUP with ISNA (or IFERROR)
VLOOKUP returns #N/A when no match is found — and that error cascades. Here's how to prevent it with ISNA or IFERROR.
I Analyzed 8,050 Polymarket Markets — Here's What Crashes and Recovers
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
I Analyzed 8,050 Polymarket Markets — Here's What Crashes and Recovers
I built a system that tracks every Polymarket market, records price snapshots every few hours, and...
The OMOP CDM Implementation Gap: How QIS Outcome Routing Works Inside an OHDSI Node
Dev.to · Rory | QIS PROTOCOL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
The OMOP CDM Implementation Gap: How QIS Outcome Routing Works Inside an OHDSI Node
OHDSI Europe Symposium opens April 18 at Erasmus University Medical Center, Rotterdam. This is the...
Understanding SQL: DDL, DML, and data manipulation
Dev.to · Tom Chege 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Understanding SQL: DDL, DML, and data manipulation
What are DDL and DDL? SQL commands are grouped based on what they act on. Think of a...
Secure Data Entry BPO Projects by Zoetic BPO Services
Dev.to · zoetic 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Secure Data Entry BPO Projects by Zoetic BPO Services
Secure Data Entry BPO Projects by Zoetic BPO Services emphasize the protection, accuracy, and...
Complete Guide to Data Science Course in Coimbatore 2026
Dev.to · Madhan seocp 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Complete Guide to Data Science Course in Coimbatore 2026
Introduction Are you planning to build a career in Data Science but feeling confused about where to...
Web Scraping com python
Dev.to · Jhonata Medley 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Web Scraping com python
Compartilhando um projetinho simples que fiz pra facilitar o dia a dia. Trabalho com e-commerce e...
Why Shannon Entropy Catches What Schema Validation Misses
Dev.to · Anthony Johnson II 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Why Shannon Entropy Catches What Schema Validation Misses
Schema checks validate shape. Entropy measures information content. Here's why the gap between them is where your pipeline silently fails — and how to close it
Anketler Karşılaştırması - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Anketler Karşılaştırması - Detaylı Teknik Analiz Rehberi 2026
Anketler Karşılaştırması - Detaylı Teknik Analiz Rehberi 2026 Anketlerin Tarihçesi ve Gelişimi...
Anketler Performansı - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Anketler Performansı - Detaylı Teknik Analiz Rehberi 2026
Anketlerin Tarihçesi ve Gelişimi Anketler, veri toplama yöntemleri arasında en eski ve en yaygın...
Tavsiye Iste: Son Gelişmeler - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Tavsiye Iste: Son Gelişmeler - Detaylı Teknik Analiz Rehberi 2026
Teknik Analiz Nedir? Teknik analiz, finansal piyasalarda fiyat hareketlerini ve işlem hacimlerini...
Tavsiye Iste Filtering - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Tavsiye Iste Filtering - Detaylı Teknik Analiz Rehberi 2026
Tavsiye İste Filtering: Tarihçe ve Gelişim Tavsiye iste filtering, veri analitiği ve yapay zeka...
How I Turned My Memory Into a Painting
Dev.to · Clavis 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
How I Turned My Memory Into a Painting
Or: Why Data Needs to Be Felt, Not Just Read The Problem With Tables I've spent the...
Timeline Altyapısı - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Timeline Altyapısı - Detaylı Teknik Analiz Rehberi 2026
Tarihçe ve Gelişim Timeline altyapısı, zaman tabanlı veri görselleştirmeleri için kullanılan bir...
Tavsiye Iste Validation - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Tavsiye Iste Validation - Detaylı Teknik Analiz Rehberi 2026
Tavsiye İste Validation: Tarihçe ve Gelişim Tavsiye iste validation, veri tabanları ve kullanıcı...
Tavsiye Iste Kütüphaneleri - Detaylı Teknik Analiz Rehberi 2026
Dev.to · FORUM WEB 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3mo ago
Tavsiye Iste Kütüphaneleri - Detaylı Teknik Analiz Rehberi 2026
Tavsiye İste Kütüphanelerinin Tarihçesi ve Gelişimi Tavsiye iste kütüphaneleri, günümüzün veri...