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)
Foundational Concepts in Data Engineering
Dev.to · Samuel Wachira 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Foundational Concepts in Data Engineering
Data Engineering is the practice of designing and building systems for collecting, storing and...
How Polymarket Scaled Their Data Stack with Postgres + ClickHouse
Dev.to · NevoSayNevo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Polymarket Scaled Their Data Stack with Postgres + ClickHouse
Prediction markets move fast — and so does their data. As Polymarket grew to billions in monthly...
Mobile App Analytics for React Native — What to Track, What to Ignore
Dev.to · Russel Dsouza 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Mobile App Analytics for React Native — What to Track, What to Ignore
A no-fluff guide to instrumenting a React Native or Expo app from day one. AARRR metrics, the activation event trick, the one chart that matters, and a day-one
We built an alert triage system. Then we watched analysts ignore it.
Dev.to · Stuart Watkins 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
We built an alert triage system. Then we watched analysts ignore it.
TL;DR: 95% of AML alerts are noise. We spent years assuming better detection models would fix that....
Treasure Hunt Engine: When Veltrix Defaults Buried 800k Documents in a Hot Partition
Dev.to · Lillian Dube 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Treasure Hunt Engine: When Veltrix Defaults Buried 800k Documents in a Hot Partition
The Problem We Were Actually Solving We needed a backfill pipeline that could re-index 60...
Your Pipeline Is 19.4h Behind: Catching World Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your Pipeline Is 19.4h Behind: Catching World Sentiment Leads with Pulsebit
Your Pipeline Is 19.4h Behind: Catching World Sentiment Leads with Pulsebit We recently...
Your Pipeline Is 20.0h Behind: Catching Music Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your Pipeline Is 20.0h Behind: Catching Music Sentiment Leads with Pulsebit
Your pipeline is 20.0h behind: catching music sentiment leads with Pulsebit We just...
AI database answers need receipts, not just confidence
Dev.to · Mads Hansen 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
AI database answers need receipts, not just confidence
An AI answer about business data should not be a dead end. If someone asks: “Where did that number...
How we test color palettes before they ship in scientific figures
Dev.to · FigCanvas 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How we test color palettes before they ship in scientific figures
The journals don't reject papers because the palette is wrong. They just give you another revision...
A SEC filing research prompt pack for source-aware stock research
Dev.to · Gandalf the Gato 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
A SEC filing research prompt pack for source-aware stock research
Who this is for Use this when you want to understand a company from primary sources...
Copy Job CDC with SQL estate is now GA in Microsoft Fabric
Dev.to · Shai Karmani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Copy Job CDC with SQL estate is now GA in Microsoft Fabric
Microsoft Fabric Copy Job CDC with SQL estate is now generally available. Here is what BI and data engineering teams can actually do with it.
I Analyzed 500+ Manus AI Tasks to Find the Optimal Credit Strategy (Data Inside)
Dev.to · Rafael Silva 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Analyzed 500+ Manus AI Tasks to Find the Optimal Credit Strategy (Data Inside)
The Experiment Over the past 6 months, I've been tracking every single Manus AI task I...
Your Pipeline Is 23.8h Behind: Catching Inflation Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your Pipeline Is 23.8h Behind: Catching Inflation Sentiment Leads with Pulsebit
Your pipeline is 23.8 hours behind: catching inflation sentiment leads with Pulsebit We...
Scale Wars #4 — Airbnb: Data Mesh and the Death of the Central Data Team
Dev.to · Mehmet TURAÇ 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Scale Wars #4 — Airbnb: Data Mesh and the Death of the Central Data Team
When every report requires a 2-week ticket to the data team, the data team IS the bottleneck. How Airbnb decentralized data ownership.
I built a search engine for 3 million Polish businesses — here's what I learned
Dev.to · Paweł Sobkowiak 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I built a search engine for 3 million Polish businesses — here's what I learned
Poland has over 3 million registered businesses spread across two separate public registries — KRS...
10 Avro Schema Mistakes Even Experienced Developer Do
Dev.to · Divyanshu Deepam 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
10 Avro Schema Mistakes Even Experienced Developer Do
Avro schemas widely used with messaging systems like Apache Kafka to serialize messages into a...
Your Pipeline Is 29.0h Behind: Catching Music Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your Pipeline Is 29.0h Behind: Catching Music Sentiment Leads with Pulsebit
Your pipeline just missed a significant anomaly: a 24h momentum spike of +0.706 in music sentiment....
Building a free Polymarket screener: how I turned 13,963 markets into a single scannable page
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building a free Polymarket screener: how I turned 13,963 markets into a single scannable page
Polymarket has thousands of markets. Their UI is built for depth on a single market — bet slip,...
Microsoft Azure Data Engineering Course | Corporate Training
Dev.to · kalyan visualpath 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Microsoft Azure Data Engineering Course | Corporate Training
Best Resources to Learn Azure Data Engineering Online Introduction Many companies collect huge...
5 Real-World Data Science Projects Every Aspiring Data Scientist Should Build in 2026
Dev.to · Ntech Global Solutions 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
5 Real-World Data Science Projects Every Aspiring Data Scientist Should Build in 2026
The demand for skilled data scientists continues to grow rapidly across industries like healthcare,...
A Practical Guide To Entity Resolution in Python (No Database, No Machine Learning)
Dev.to · Prithwish Nath 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
A Practical Guide To Entity Resolution in Python (No Database, No Machine Learning)
TL;DR: Learn a very simple way to normalize, dedupe, and fuzzy-match records that refer to the same...
Analyzing 1,000 Engineering Problems Through GitHub Data
Dev.to · Pavanipriya Sajja 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Analyzing 1,000 Engineering Problems Through GitHub Data
In my previous article, I wrote about the GitHub mining process in user research and explained how it...
AI in Data Analytics
Dev.to · Seenivasan A 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
AI in Data Analytics
Why AI is Used in Data Analytics AI is used because it saves time and reduces manual work. Data...
Migrating off Google Analytics: Umami vs Plausible vs Fathom
Dev.to · Alan West 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Migrating off Google Analytics: Umami vs Plausible vs Fathom
A practical comparison of Umami, Plausible, and Fathom for teams migrating off Google Analytics, with code examples and self-hosting notes.
Training Data Provenance: The Manifest Diff That Explains the Hash
Dev.to · AI x Crypto Systems 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Training Data Provenance: The Manifest Diff That Explains the Hash
A postmortem-style DEV article about an AI training dataset whose hash was correct while its source, rights, transform, and reviewer history were missing.
How to know if you actually need mobile proxies (without buying any)
Dev.to · atheris-ee 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to know if you actually need mobile proxies (without buying any)
Every scraping project I start, the same question comes up: do I actually need mobile proxies for...
I Thought “Data Analyst” Was the Whole Game… Then I Entered the Data Avengers Office 👀
Dev.to · Yukti Sahu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Thought “Data Analyst” Was the Whole Game… Then I Entered the Data Avengers Office 👀
🏢 I Landed an Internship at a Futuristic Tech Company — And Met the Entire Data...
What's new in Data Preprocessor 1.5.x — R codegen, Robust Scaler, and a deadlock post-mortem
Dev.to · Godwill Christopher 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What's new in Data Preprocessor 1.5.x — R codegen, Robust Scaler, and a deadlock post-mortem
It's been a few months since I last wrote about Data Preprocessor, the IntelliJ plugin I built to...
Python and Its Role in Data Analytics
Dev.to · Barbara Morara 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python and Its Role in Data Analytics
Introduction Technology has affected the way that both people and organizations make their...
Quantitative Trading System: Batch Fetch Historical Market Data via API & Backtest Data Cleaning
Dev.to · San Si wu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Quantitative Trading System: Batch Fetch Historical Market Data via API & Backtest Data Cleaning
Anyone involved in quantitative trading knows that the core of a backtesting system is not how fancy...
# Mitigating Market Inefficiency in eSports: A Stochastic Approach to EA Sports FC25 Modeling
Dev.to · Bettrails Data Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
# Mitigating Market Inefficiency in eSports: A Stochastic Approach to EA Sports FC25 Modeling
### By Bettrails Data Lab *Technical Classification: Data Science / Predictive Modeling / Sports...
# How I Built a Retail Demand Forecasting App with Python and Streamlit
Dev.to · Okparaji Wisdom 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
# How I Built a Retail Demand Forecasting App with Python and Streamlit
By Okparaji Wisdom | Data Scientist | Nigeria Retailers in Nigeria lose millions of naira every...
How to Design & Ensure Scalability of Data-Intensive Applications
Dev.to · Syed Bakhtawar Fahim 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to Design & Ensure Scalability of Data-Intensive Applications
𝐅𝐚𝐜𝐭𝐨𝐫𝐬 𝐟𝐨𝐫 𝐒𝐞𝐥𝐞𝐜𝐭𝐢𝐧𝐠 𝐚𝐧𝐝 𝐃𝐞𝐬𝐢𝐠𝐧𝐢𝐧𝐠 𝐃𝐚𝐭𝐚 𝐒𝐭𝐨𝐫𝐞𝐬: Primary Considerations for designing a Data Store or...
The Inseparable Relationship Between Data Centers and Magnets: Why Rare-Earth Magnets Are the Hidden Backbone of Modern Storage
Dev.to · kazutaka kobayashi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Inseparable Relationship Between Data Centers and Magnets: Why Rare-Earth Magnets Are the Hidden Backbone of Modern Storage
Data centers are the beating heart of our digital world—powering AI, cloud computing, streaming, and...
How to Use EXPLAIN ANALYZE in PostgreSQL: A Visual Guide
Dev.to · LeoJ 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to Use EXPLAIN ANALYZE in PostgreSQL: A Visual Guide
A single slow query can cascade through your entire application. It holds connections, stalls other...
Micro Supply Chain: Anatomy of the Data Flow Mechanism
Dev.to · Mustafa ERBAY 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Micro Supply Chain: Anatomy of the Data Flow Mechanism
Micro Supply Chain: Anatomy of the Data Flow Mechanism A delay in shipment reports from a...
Building a Daily Data Pipeline That Survives Market Holidays
Dev.to · Stock Expert AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building a Daily Data Pipeline That Survives Market Holidays
So, I had to build this data pipeline that grabs financial market data. Daily. Sounds simple,...
Getting Data from Multiple Sources in Power BI: A Practical Guide to Modern Data Integration
Dev.to · Opeloyeru Hikmah 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Getting Data from Multiple Sources in Power BI: A Practical Guide to Modern Data Integration
Introduction The foundation of every successful Power BI report is reliable data...
How I Built a Live SQL Workshop Where Students Can't Break Anything
Dev.to · Mohamed Hedi Ben Jemaa 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How I Built a Live SQL Workshop Where Students Can't Break Anything
Picture this. It's a Tuesday evening. Half the students are in the room. The other half are little...
Geospatial Intelligence Services for Latin America
Dev.to · Thale Jacobs 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Geospatial Intelligence Services for Latin America
Building Geospatial Intelligence Services for Latin America Most geospatial tooling is...
Why Data Relationships Matter Before Enterprise Transformation
Dev.to · Deniz Ceylan Kurt, MIET 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why Data Relationships Matter Before Enterprise Transformation
Enterprise modernization often fails not because of technology choices, but because of weak data...
How I caught Polymarket front-running a Trump headline by 7 hours, using only a public order-book API
Dev.to · Samuel EF. Tinnerholm 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How I caught Polymarket front-running a Trump headline by 7 hours, using only a public order-book API
TL;DR — On May 23, 2026, Donald Trump posted on Truth Social at 21:50 UTC that a US–Iran ceasefire...
Your marketplace users are uploading their home address in every photo. You're storing all of it.
Dev.to · Jacob Corne 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your marketplace users are uploading their home address in every photo. You're storing all of it.
Every photo taken on a smartphone has EXIF metadata baked in. GPS coordinates, device serial number,...
From Python to Production Pipeline :A Practical guide to Apache Airflow
Dev.to · Varun Joshi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
From Python to Production Pipeline :A Practical guide to Apache Airflow
You have been using python and you have written scripts that pull data, clean it and load it...
5 Streamlit Dashboards I Built to Practice Data Science (Templates Included)
Dev.to · Deepanshu Garg 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
5 Streamlit Dashboards I Built to Practice Data Science (Templates Included)
During my self-taught data science journey, I kept hitting the same wall: I'd learn a concept in a...
TON DeFi metrics: TVL, volume, active users (2026)
Dev.to · ton-adoption 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
TON DeFi metrics: TVL, volume, active users (2026)
How to read TON's TVL correctly, STON.fi and DeDust volumes, the rise of liquid staking and stablecoin market cap. Concrete numbers with DefiLlama references.
TON vs BTC and ETH: a historical correlation analysis
Dev.to · ton-adoption 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
TON vs BTC and ETH: a historical correlation analysis
How TON has moved relative to BTC and ETH from 2021 to 2026. Coefficients, decorrelation cycles, the Telegram dependency and the role of airdrops in shifting.
How to read DeFiLlama for TON: an analyst's guide 2026
Dev.to · ton-adoption 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to read DeFiLlama for TON: an analyst's guide 2026
Reading the TON section on DeFiLlama: protocol TVL, methodology pitfalls, fake liquidity, jetton wrappers, staking double-counting and where DeFiLlama systemati