Tech Skills

Data Analytics & Business Intelligence

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

16,833
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,362) Articles (3027)Blog Posts (3428)Tutorials (372)Research Papers (39)News (496)
Five GitHub signals that kept predicting seed rounds three weeks early
Dev.to · The Data Nerd 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Five GitHub signals that kept predicting seed rounds three weeks early
Six months tracking 4,200 startup orgs. Each signal alone is noise. Two together is a phone call.
I Built a Real-Time Crypto Analytics Pipeline for $0.01/Month — Here's the Full Architecture
Dev.to · Ryan Giggs 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
I Built a Real-Time Crypto Analytics Pipeline for $0.01/Month — Here's the Full Architecture
How I combined Apache Flink, Redpanda, Airflow, dbt Cloud, and Grafana to track Bitcoin, Ethereum,...
Where to Start in Data Science: Free Courses from IBM, Google, and Universities
Dev.to · Nevena 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Where to Start in Data Science: Free Courses from IBM, Google, and Universities
Curious about Data Science or considering a career in the field? DataArt curated a list of free...
Three Ways to Fly: Building Route Options Ranked by Time, CO2 , and Reliability
Dev.to · José Catalá 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Three Ways to Fly: Building Route Options Ranked by Time, CO2 , and Reliability
Three Ways to Fly: Building Route Options Ranked by Time, CO₂, and Reliability Tags:...
What Makes Apache Hudi a Game-Changer for Data Engineering
Dev.to · Raghav Sharma 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
What Makes Apache Hudi a Game-Changer for Data Engineering
Introduction Data engineering has evolved rapidly over the past few years. Organizations...
KMDS with New Features
Dev.to · Rajiv Sambasivan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
KMDS with New Features
A little while ago I developed a python package meant for small data science teams to communicate the...
Explore Your Time Series Data
Dev.to · Rajiv Sambasivan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Explore Your Time Series Data
Do you have business data that you collect at an hourly or greater cadence - for example, site...
Stop Paying the Abstraction Tax : How I Built a C-Engine 12x Faster than Pandas
Dev.to · NARESH-CN2 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Stop Paying the Abstraction Tax : How I Built a C-Engine 12x Faster than Pandas
Python is the king of data science, but it charges a heavy price for convenience. When you use...
From Chaos to Clarity: How SQL Transforms Raw Data into Powerful Stories
Dev.to · Collins Njeru 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
From Chaos to Clarity: How SQL Transforms Raw Data into Powerful Stories
By Collins Njeru I still remember the first time I ran a query that actually meant something. Not...
SQL GROUP BY & HAVING: The Beginner's Guide to Summarizing Data Like a Pro
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
SQL GROUP BY & HAVING: The Beginner's Guide to Summarizing Data Like a Pro
Learn how SQL GROUP BY and HAVING clauses work together to group, aggregate, and filter your data — with real-world examples and common mistakes to avoid.
How to Test Private Database Access from AWS Glue Before Running ETL Jobs
Dev.to · David💻 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
How to Test Private Database Access from AWS Glue Before Running ETL Jobs
When building ETL workloads in AWS, one of the first problems we usually face is not the...
Statistical Visualizations With Seaborn
Dev.to · Akhilesh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Statistical Visualizations With Seaborn
You spent the last post fighting with Matplotlib. Setting figure sizes. Adjusting label positions....
Unlearning's Paradox: Privacy That Can't Scale
Dev.to · Arfadillah Damaera Agus 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Unlearning's Paradox: Privacy That Can't Scale
The Unlearning Trap Federated unlearning—the ability to permanently remove a user's data...
DSA, step by step
Dev.to · Sreya Satheesh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
DSA, step by step
👉 http://decoded-app.vercel.app/ I built this as a small way to make DSA feel less like memorizing...
Reading the Receipts: How Smarter Privacy Accounting Could Unlock More from Sensitive Data
Dev.to · Bongho Tae 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Reading the Receipts: How Smarter Privacy Accounting Could Unlock More from Sensitive Data
The Problem Hiding Inside Every Medical Study Picture a coalition of hospitals that wants...
Data Engineers Don't Need DSA. So Why Do Interviews Still Test It?
Dev.to · DataDriven 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Data Engineers Don't Need DSA. So Why Do Interviews Still Test It?
LeetCode screens are driving senior DE talent away. Here's what the viral DSA debate exposes about who really benefits from broken hiring loops.
Your Data Doppelgänger is Already Here.
Dev.to · Gilder Miller 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Your Data Doppelgänger is Already Here.
You're sitting in a café, talking to a friend about maybe, just maybe, taking up gardening. You...
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs
Dev.to · Gabriel Anhaia 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs
Five questions about your write shape, read pattern, and ops headcount that resolve the database choice before the first migration.
Shortcut & Mirroring
Dev.to · Sankalp 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Shortcut & Mirroring
Shortcut: Point to original source of data, only virtual connection. Data is not stored physically in...
Airbnb Data Engineering Interview Questions & Prep
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Airbnb Data Engineering Interview Questions & Prep
Airbnb data engineering interview questions lean on SQL for marketplace-style analytics...
Your First Plot: Matplotlib Without the Pain
Dev.to · Akhilesh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Your First Plot: Matplotlib Without the Pain
Numbers in a table tell you something. A chart tells you the same thing in a second. You can stare...
How to Scrape Instagram Data: Complete Guide for 2026
Dev.to · AlterLab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
How to Scrape Instagram Data: Complete Guide for 2026
Disclaimer: This guide covers extracting publicly accessible data. Always review a site's robots.txt...
PREWHERE optimization with ReplacingMergeTree and FINAL in Clickhouse
Dev.to · gaurang101197 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
PREWHERE optimization with ReplacingMergeTree and FINAL in Clickhouse
In this blog, we will learn about how to reduce I/O and improve query performance using PREWHERE in...
Uber Data Engineering Interview Questions & Prep
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Uber Data Engineering Interview Questions & Prep
Uber Data Engineering Interview Questions & Prep Guide Uber data engineering interview...
Making Compression a Habit with zstd
Dev.to · Wayne 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Making Compression a Habit with zstd
A practical guide to using zstd compression for data processing, log management, and cost-effective file storage in Python and Linux.
SQL Subqueries vs CTEs: A Complete Guide for Data Analysts published
Dev.to · RaggedGent-io 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
SQL Subqueries vs CTEs: A Complete Guide for Data Analysts published
SQL Subqueries vs CTEs: A Complete Guide for Data Analysts If you've been writing SQL for...
Connecting Power BI to PostgreSQL Database
Dev.to · Mburu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Connecting Power BI to PostgreSQL Database
Introduction If you're getting into data science, data analytics or business intelligence,...
Find A VP Data Science
Dev.to · Willis Reed Fan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Find A VP Data Science
When it comes to finding a VP of Data Science, the stakes are high and the options can be...
Top 5 Data Engineering Tools for 2026: Why Python and SQL remain Kings
Dev.to · ahmeddeelhassan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Top 5 Data Engineering Tools for 2026: Why Python and SQL remain Kings
In the rapidly evolving landscape of 2026, where AI and LLMOps dominate the headlines, the foundation...
Mixpanel vs Amplitude 2026: What to Choose?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Mixpanel vs Amplitude 2026: What to Choose?
Mixpanel vs Amplitude 2026: compare tracking models, funnels, retention, governance, and ecosystem fit (Hotjar, Fullstory, PostHog) with a practical snippe
Mixpanel vs Amplitude 2026: Which Analytics Wins?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Mixpanel vs Amplitude 2026: Which Analytics Wins?
Mixpanel vs Amplitude 2026: practical differences in instrumentation, governance, and workflows. Includes an event-tracking example and a 2026 decision fra
Building a Resilient NDVI Pipeline with Redis Streams (Event-Driven Architecture)
Dev.to · Rahim Ranxx 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Building a Resilient NDVI Pipeline with Redis Streams (Event-Driven Architecture)
A practical breakdown of moving an NDVI processing pipeline from a synchronous design to an...
SQL Subqueries vs CTEs: What I Reach For When Writing Compliance and Reconciliation Queries
Dev.to · Kahuthu Muriuki 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
SQL Subqueries vs CTEs: What I Reach For When Writing Compliance and Reconciliation Queries
When I started writing SQL against transaction data in fintech and securities brokerage environments,...
Combining Datasets: Merge, Join, Concat
Dev.to · Akhilesh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Combining Datasets: Merge, Join, Concat
Your orders table has 50,000 rows. Your customers table has 8,000 rows. Your products table has 300...
Grouping Data to Find Patterns
Dev.to · Akhilesh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Grouping Data to Find Patterns
You have 10,000 rows of sales data. You do not care about 10,000 rows. You care about one question....
Top 20 Meta Analytics Interview Questions (2026)
Dev.to · Feng Zhang 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Top 20 Meta Analytics Interview Questions (2026)
Meta Analytics interviews usually focus on product judgment, experiment design, metric definition,...
Top 20 Capital One Analytics Interview Questions (2026)
Dev.to · Feng Zhang 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Top 20 Capital One Analytics Interview Questions (2026)
Capital One Analytics interviews are heavy on business cases, product thinking, experimentation, and...
Delta Lakes: ACID Transactions, Time Travel & Delta Tables
Dev.to · Vinicius Fagundes 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Delta Lakes: ACID Transactions, Time Travel & Delta Tables
Delta Lake for Dummies: ACID Transactions, Time Travel & Delta Tables If there's one...
Filtering Rows and Selecting Columns (The Right Way)
Dev.to · Akhilesh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Filtering Rows and Selecting Columns (The Right Way)
You know df["column"] selects a column. You know df.head() shows the top rows. But in real...
Is a Data Science Bootcamp Worth It in 2026?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Is a Data Science Bootcamp Worth It in 2026?
Is a data science bootcamp worth it in 2026? Learn when it pays off, when to avoid it, how to judge ROI, and a baseline-first modeling example.
Is a Data Science Bootcamp Worth It in 2026?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Is a Data Science Bootcamp Worth It in 2026?
Is a data science bootcamp worth it in 2026? Learn how to evaluate ROI, required skills, portfolio signals, and when self-study beats bootcamps.
Is a Data Science Bootcamp Worth It in 2026?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Is a Data Science Bootcamp Worth It in 2026?
Is a data science bootcamp worth it? Use this ROI-based framework, red flags, a curriculum checklist, and a Python example to decide in 2026.
Is a Data Science Bootcamp Worth It in 2026?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Is a Data Science Bootcamp Worth It in 2026?
Is a data science bootcamp worth it? A practical framework for ROI, curriculum signals, who should join, plus a quick Python skills test.
Your Pipeline Is 25.3h Behind: Catching Business Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Your Pipeline Is 25.3h Behind: Catching Business Sentiment Leads with Pulsebit
Your pipeline just missed a critical insight: a 24h momentum spike of -0.587 in business sentiment....
Is a Data Science Bootcamp Worth It in 2026?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Is a Data Science Bootcamp Worth It in 2026?
Is a data science bootcamp worth it in 2026? A practical, ROI-based guide comparing bootcamps vs MOOCs and self-study—with a mini-project test.
Is a Data Science Bootcamp Worth It in 2026?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Is a Data Science Bootcamp Worth It in 2026?
Is a data science bootcamp worth it in 2026? A clear decision framework, trade-offs vs self-paced learning, and a quick project test to validate readiness.
Is a Data Science Bootcamp Worth It in 2026?
Dev.to · Juan Diego Isaza A. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
Is a Data Science Bootcamp Worth It in 2026?
Is a data science bootcamp worth it? A practical, opinionated guide to ROI, red flags, alternatives, and a quick project test to decide.
DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression
Dev.to · soy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2mo ago
DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression
DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression ...