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 · Jill Nandaha
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
ETL vs ELT: The Difference That Finally Clicked for Me
When I first came across ETL vs ELT, it honestly felt like one of those “same thing, different...

Dev.to · Mario Noioso
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
MongoDB EMEA Public Sector
This section explores how MongoDB is used in the public sector across EMEA, covering data platforms,...

Dev.to · vahid Saber
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
What dbt Tests Miss (and How to Catch It Automatically)
If you use dbt, you probably have some tests. A few not_null checks, maybe unique on your primary...

Dev.to · Karlis
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Practicing “Database Insights”: where to find real schemas?
We talk a lot about “data-driven decisions”, but that usually hides three separate layers: Data...

Dev.to · Ng'ang'a Njongo
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Building Your First Airflow DAG: Extracting Stock Data with Massive
When stepping into the world of data engineering, Apache Airflow is likely one of the first tools you...

Dev.to · Happy Endpoint
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
I Collected Data on 19,994 UAE Real Estate Agents. Here Is What It Looks Like.
The UAE real estate market gets covered endlessly in terms of property prices and transaction...

Dev.to · circobit
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Warum Datenanalysten Copy-Paste von Websites hassen
Letzte Woche habe ich 40 Minuten damit verbracht, eine Tabelle zu reparieren, die in 5 Minuten hätte...

Dev.to · LearnRepo
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
500 Blog Posts To Learn About Database
Let's learn about Database via these 500 free blog posts. They are ordered by HackerNoon...

Dev.to · Feng Zhang
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Top 50 SQL Interview Questions with Answers (2026)
SQL interviews are predictable in one useful way, the same patterns show up again and again. PracHub...

Dev.to · Om Prakash Tiwari
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
🚀 Project Pravah: Powering High-Volume Real-Time Dashboards at Scale
In modern organizations, data doesn’t just need to exist—it needs to flow. Decisions are no longer...

Dev.to · David Aronchick
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
From Pandas to Upstream Control: The Evolution PyData Needs Next
Last Friday at PyData Seattle 2025, I gave a talk called "Taming the Data Tsunami." Room full of data...

Dev.to · David Aronchick
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
While We're Measuring Developer Productivity, Won't Someone Think of the Data Engineers?
Nicole Forsgren just dropped a new book, and I absolutely CONSUMED it. It's called Frictionless:...

Dev.to · David Aronchick
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Multi-Everything: Why Your Data Strategy Is Harder Than Your Cloud Strategy
An Uber engineer gave a great talk at Kubecon I have wanted to write about: “...we end up having to...

Dev.to · Feng Zhang
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Intuit Data Scientist Interview Guide 2026
Intuit's Data Scientist interview is different from the classic "train a model and talk about ROC...

Dev.to · The Data Nerd
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
I tracked 4,200 startup GitHub orgs for six months — here's what actually predicts a fundraise
Six months of weekly snapshots, one Postgres table, and a backtest that surprised me. The infra notes nobody wrote down.

Dev.to · Nata
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Moving Data from MySQL to BigQuery (Without Turning It Into a Side Project)
You don’t notice the problem right away. Everything runs smoothly in MySQL… until a new report...

Dev.to · Dhairya Pandya
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
How I was introduced to SQL window function
I was called at my firm for having to create a analytics dashboard for a multiTenet CRM dashboard...

Dev.to · Byrone_Code
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
From Transactions to Insights: How OLTP and OLAP Work Together in Modern Data Pipelines
Introduction It's Black Friday. In the space of a single second, your e-commerce platform...

Dev.to · Charles Givre
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Data Science Techniques That Speed Up Incident Response
Clustering, timeline analysis, and NLP for incident response. Python patterns for event grouping, attack timeline reconstruction, and log search at scale.

Dev.to · Manish Podiyal
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
The Data Refinery: Why Apache Spark is the Engine Behind Real-World Big Data Use Cases
You've likely heard that "Data is the new oil". But raw oil is useless without a refinery. In the...

Dev.to · Damaa-C
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Data Warehousing & Modeling: From Foundation to AWS Cloud Implementation
In the current landscape of data engineering, the ability to transform raw, messy data into...

Dev.to · circobit
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Waarom Data-Analisten een Hekel Hebben aan Kopiëren en Plakken van Websites
Elke data-analist heeft het gedaan. Je vindt de perfecte dataset op een website, selecteert de tabel,...

Dev.to · Andrew Tan
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Why Your Data Team Can't Ship: The Organizational Bottleneck Nobody Talks About
The biggest blocker to data team productivity isn't technology—it's organizational friction. Here's...

Dev.to · Eduardo Motta de Moraes
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Scaling data systems: How we process millions of records with Python
Most people assume scaling data systems is just about performance. It's not. Processing millions of...

Dev.to · Yos Riady
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Complete Guide to Multichain Analytics: Web3 Data Intelligence (2026)
Master multichain analytics with the complete guide for for data-driven crypto and DeFi teams. Learn actionable data strategies, real-time insights, and privacy

Dev.to · Venus-Kennedy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
SQL Subqueries vs CTEs
Ever written a query… And halfway through forgot what you were doing? You start simple: SELECT *...

Dev.to · Nevena
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Databricks Data Engineer Associate Exam: What Changed in 2025
Earning the Databricks Data Engineer Associate certification was a valuable milestone for DataArt's...

Dev.to · Lucy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
5 Reasons Your Databricks Implementation Is Underperforming (And How a Consultant Fixes It)
Your Databricks cluster is running. Jobs are completing. But the dashboards are slow, costs are...

Dev.to · Yos Riady
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Best Product Analytics Tools for DeFi Teams
Discover the best product analytics tools for DeFi teams to enhance user engagement and drive growth. Learn why the majority projects fail without effective pro

Dev.to · Luke
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Multi-Tenant Dashboards with ClickHouse: What Actually Works in Production
Customers expect analytics inside your product. Not in a separate BI tool. Inside your app, loading...

Dev.to · Edmund Eryuba
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Data Management Systems: Transactional to Analytical Architectures
Data is no longer treated as a byproduct of business operations and has become one of the most...

Dev.to · agenthustler
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
itch.io Game Data at Scale: Who Needs It and How to Extract It
itch.io has 500K+ indie games but no public bulk API. Here's who needs that data, what you can extract, and how to run our Apify actor to get it.

Dev.to · Karen Langat
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
OLAP vs OLTP: A Deep Dive into Database Processing Systems
In modern data-driven organizations, managing and analyzing data efficiently is critical. OLAP...

Dev.to · Vivek Kumar
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
SQL Date & Time Functions: A Practical Guide for Real-World Queries
Master the most useful SQL date and time functions — from extracting date parts to calculating differences and truncating timestamps — with practical examples y

Dev.to · peter muriya
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
OLAP vs OLTP: Understanding the Backbone of Modern Data Systems
In today’s data-driven world, organizations rely on efficient data systems to manage daily operations...

Dev.to · Vinicius Fagundes
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Medallion Architecture: Designing Bronze, Silver, and Gold Layers
Medallion Architecture: Designing Bronze, Silver, and Gold Layers Before you write a...

Dev.to · Gowtham Potureddi
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
COALESCE in SQL — First Non-NULL, LEFT JOIN Defaults, and Interview Patterns
COALESCE in SQL is the single most-asked NULL-handling primitive at every data-engineering interview...

Dev.to · Gowtham Potureddi
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Facebook Data Engineering Interview Questions & Prep Guide
Facebook data engineering interview questions are bilingual, product-analytics-flavored, and...

Dev.to · Gowtham Potureddi
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Square Data Engineering Interview Questions & Prep Guide
Square data engineering interview questions are SQL-heavy, fintech-flavored, and PostgreSQL-grounded....

Dev.to · Gowtham Potureddi
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Snowflake Data Engineering Interview Questions & Prep Guide
Snowflake data engineering interview questions split into two distinct loops that share a name. The...

Dev.to · Gowtham Potureddi
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Robinhood Data Engineering Interview Questions & Prep Guide
Robinhood data engineering interview questions are bilingual — SQL and Python in roughly equal...

Dev.to · ANKUSH CHOUDHARY JOHAL
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
How to Build Real-Time Analytics Dashboards with Apache Kafka 3.7 and Grafana 11 for Python 3.13 Apps
How to Build Real-Time Analytics Dashboards with Apache Kafka 3.7 and Grafana 11 for Python...

Dev.to · ROBERTO CARLOS HUAMAN RIVERA
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
📊 Beyond the Basics: Building and Deploying Interactive Python Dashboards (Streamlit, Dash, & Bokeh)
When we talk about Data Visualization and Dashboards, enterprise tools like Tableau or PowerBI often...

Dev.to · ANKUSH CHOUDHARY JOHAL
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
We Cut Our Analytics Costs by 35% Using PostHog 2.0 and Next.js 16
We Cut Our Analytics Costs by 35% Using PostHog 2.0 and Next.js 16 For years, our team...

Dev.to · Svitla Systems Inc.
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Becoming a Data Analyst: How I Left Medicine and Switched Careers
At Svitla Systems, most of our team consists of seasoned senior-level professionals, but we always...

Dev.to · Kashaf Abdullah
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
OLTP vs. OLAP: The Two Sides of the Data Coin
If you are involved in software development, data analysis, or IT, you have likely heard the...

Dev.to · soy
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace
DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace Today's...

Dev.to · Pulsebit News Sentiment API
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Your Pipeline Is 13.9h Behind: Catching Economy Sentiment Leads with Pulsebit
Your Pipeline Is 13.9h Behind: Catching Economy Sentiment Leads with Pulsebit We recently...
DeepCamp AI