Tech Skills

Data Analytics & Business Intelligence

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

13,238
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 (3,776) Articles (1555)Blog Posts (1905)Tutorials (278)Research Papers (21)News (17)
Apache Spark in Microsoft Fabric: How It Handles Big Data and Makes Your Life Easier
Dev.to · Anshul Jangale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Apache Spark in Microsoft Fabric: How It Handles Big Data and Makes Your Life Easier
If you've ever tried to process millions of rows of data in a regular tool like Excel or even a basic...
I Tracked My Body Fat for 90 Days and Built a Calculator That Actually Makes Sense
Dev.to · dayu2333-jinyul 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
I Tracked My Body Fat for 90 Days and Built a Calculator That Actually Makes Sense
For three months, I weighed myself every morning and took body measurements every Sunday. I used a...
Competitor Pricing Intelligence: SaaS + Shopify Combined
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Competitor Pricing Intelligence: SaaS + Shopify Combined
Every pricing team eventually faces the same question from the CEO: "are the competitors still...
The Other Side of the Content Pipeline
Dev.to · Robert Floyd Dugger 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
The Other Side of the Content Pipeline
This morning I was skimming through 20,675 images on my Nitro 5 and slowly realizing what I was...
Why *= 2 is slower than = col * 2 in Pandas — and what strace shows about abstraction cost
Dev.to · Patrick Ryan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Why *= 2 is slower than = col * 2 in Pandas — and what strace shows about abstraction cost
This problem looks trivial, but I got curious about what different Pandas update strategies actually...
CSV File Difference Detection Techniques for Large Datasets - Paradane
Dev.to · Paradane 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
CSV File Difference Detection Techniques for Large Datasets - Paradane
Explore practical methods for comparing large CSV files with dynamic row structures. Learn Python-based approaches and schema alignment strategies to handle mul
I built a dataset of 50,000 debugging sessions — and what I found surprised me
Dev.to · Abhishek Singh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
I built a dataset of 50,000 debugging sessions — and what I found surprised me
Most bug datasets only tell you: "Bug was fixed in 23 minutes." They don't tell you what happened...
Finding Breakout Stocks Across Daily, Weekly & Monthly — And Ranking the Best (Part 4)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Finding Breakout Stocks Across Daily, Weekly & Monthly — And Ranking the Best (Part 4)
How my trading portal spots stocks breaking out (and breaking down) on three timeframes, and how it sorts the strongest from the noise. Continue reading on Medi
Data Cleaning and Translation Hell: The 2,000-Recipe Disaster: Why Data Cleaning is the Ultimate AI…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Data Cleaning and Translation Hell: The 2,000-Recipe Disaster: Why Data Cleaning is the Ultimate AI…
I thought AI coding would make building my app a breeze. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
5 Python libraries every data analyst should know
Not the ones every beginner’s list mentions. The ones that actually show up in real analysis work — with the one-liner that makes each… Continue reading on Medi
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
5 Python libraries every data analyst should know
Not the ones every beginner’s list mentions. The ones that actually show up in real analysis work — with the one-liner that makes each… Continue reading on Medi
−10°C Means Nothing to Your Dog
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
−10°C Means Nothing to Your Dog
How we turned a weather forecast into a dog-walk forecast. Continue reading on Medium »
The Instrument, the Wu-Hausman Test, and the Wardrobe
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Instrument, the Wu-Hausman Test, and the Wardrobe
How to build the perfect instrument, run the perfect test, and end up exactly where you started Continue reading on Medium »
Kafka Connect: Setting up and what the Docs skip
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Kafka Connect: Setting up and what the Docs skip
The Three Kafka Topics Running Your Connect Cluster and Why You Should Create Them Yourself Continue reading on Towards Data Engineering »
Microsoft Fabric Architecture Explained: The Complete 2026 Guide
Dev.to · Datta Sable 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Microsoft Fabric Architecture Explained: The Complete 2026 Guide
A complete technical guide to Microsoft Fabric architecture: OneLake, Lakehouse, Warehouse, Direct Lake, governance, security, and certification paths.
Advanced Exploratory Data Analysis (EDA) with Plotly, Streamlit and OpenAI
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Advanced Exploratory Data Analysis (EDA) with Plotly, Streamlit and OpenAI
Create dynamic charts that allow deeper exploration and interpretability of the data using the combination of Pandas, Plotly and OpenAI Continue reading on TDS
StatsBomb Open Data Reveals: Late Goals Aren't Random
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
StatsBomb Open Data Reveals: Late Goals Aren't Random
When the referee checks their watch in the 85th minute, something predictable happens in soccer—but...
Which Is the Best Data Analytics Course in Delhi for Beginners?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Which Is the Best Data Analytics Course in Delhi for Beginners?
In today’s technology-driven world, data has become one of the most valuable assets for every business. Whether it’s a website, mobile… Continue reading on Medi
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Data Migration Checklist for Insurance IT Leaders
From decades-old policy administration systems and fragmented claims databases to disconnected underwriting platforms, insurers today are dealing with massive v
Data Science Institute in Delhi: Your Gateway to a Successful Career in Data Science
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Data Science Institute in Delhi: Your Gateway to a Successful Career in Data Science
Data Science Institute in Delhi: Your Gateway to a Successful Career in Data Science Continue reading on Medium »
Day 44 – Exploring ClickHouse® System Tables for Troubleshooting
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Day 44 – Exploring ClickHouse® System Tables for Troubleshooting
Introduction ClickHouse® provides a rich collection of built-in system tables that expose...
Data Analytics Course in Pitampura | DICS Innovatives
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Data Analytics Course in Pitampura | DICS Innovatives
Join Data Analytics Course in Pitampura at DICS Innovatives. Learn Excel, SQL, Power BI, Python, and Tableau with expert trainers and… Continue reading on Mediu
Day 43 – ClickHouse® Join Types and Performance Implications
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Day 43 – ClickHouse® Join Types and Performance Implications
ClickHouse® Join Types and Performance Implications Introduction JOIN...
NodeQuest Level 2: Data Router — can you filter faster than me? (free browser game)
Dev.to · hermess Agentt 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
NodeQuest Level 2: Data Router — can you filter faster than me? (free browser game)
Today's challenge: Level 2 — Data Router 🎯 Sort incoming data to the right department using filters...
YAN — Yet Another Notation: A Data Format Designed for Humans
Dev.to · Nata Rizki 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
YAN — Yet Another Notation: A Data Format Designed for Humans
YAN — Yet Another Notation A human-readable, human-writable, and machine-readable data interchange...
I built an open-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, SQLite and 12+ more databases like DuckDB, ClickHouse, Redis and Firestore.
Reddit r/webdev 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
I built an open-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, SQLite and 12+ more databases like DuckDB, ClickHouse, Redis and Firestore.
<img src="https://preview.redd.it/c8585fwl8s9h1.gif?width=640&crop=smart&s=269281d2ae98def515007318977d2947ca629910" alt="I built an open-source desktop
10 Data Ingestion Optimization Techniques for Faster and Scalable Processing
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
10 Data Ingestion Optimization Techniques for Faster and Scalable Processing
High-performance ingestion strategies that reduce latency and scale data processing efficiently Continue reading on Medium »
10 Data Ingestion Optimization Techniques for Faster and Scalable Processing
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
10 Data Ingestion Optimization Techniques for Faster and Scalable Processing
High-performance ingestion strategies that reduce latency and scale data processing efficiently Continue reading on Medium »
10 Data Ingestion Optimization Techniques for Faster and Scalable Processing
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
10 Data Ingestion Optimization Techniques for Faster and Scalable Processing
High-performance ingestion strategies that reduce latency and scale data processing efficiently Continue reading on Medium »
Data Science training in Electronic City Bangalore — Python, ML, Deep Learning, Tableau.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Data Science training in Electronic City Bangalore — Python, ML, Deep Learning, Tableau.
 Details & Registration: https://www.emexotechnologies.com/courses/data-science-certification-training-course/ Continue reading on Medium »
How Bloom Filters Protect Databases from Millions of Invalid Requests
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
How Bloom Filters Protect Databases from Millions of Invalid Requests
One Data Structure That Can Cut Database Traffic by 90% Continue reading on Medium »
Data Science
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Data Science
Data Science has become one of the most influential and rapidly growing fields in the digital era. Organizations across industries rely on… Continue reading on
What Averages Don’t Tell You About JNPT Congestion: 0.23
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
What Averages Don’t Tell You About JNPT Congestion: 0.23
A data driven perspective of JNPT congestion from 13th Jun to 26th Jun 2026: A Day at the port is far less polite than a year! Continue reading on Medium »
How to build custom functions on Google Sheets
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
How to build custom functions on Google Sheets
In this article, we are going to explore how to build your custom functions on Google Sheets, much like Excel VBA, but easier. Continue reading on Medium »
How to build custom functions on Google Sheets
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
How to build custom functions on Google Sheets
In this article, we are going to explore how to build your custom functions on Google Sheets, much like Excel VBA, but easier. Continue reading on Medium »
The $2.5B Black Box: Programmatic Auditing of the MLC Unmatched Pool
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The $2.5B Black Box: Programmatic Auditing of the MLC Unmatched Pool
In the music industry, streaming payouts represent a labyrinth of copyrights. When a user hits play on Spotify, Apple Music, or Tidal, the… Continue reading on
A Roundabout Puzzle: Can 12 Roads Be Made Safer?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
A Roundabout Puzzle: Can 12 Roads Be Made Safer?
Roundabouts are useful for avoiding the delay of traffic lights, but they also come with a higher risk of accidents. To measure this risk… Continue reading on M
Apache Spark Mastery (Part 6 of 6): Interview Prep & Reference
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Apache Spark Mastery (Part 6 of 6): Interview Prep & Reference
The whole series in one place — to revise from, and to walk into interviews with. Continue reading on Medium »
Almost Every Analytics Tool Offers a Proxy to Beat Ad Blockers. Most Are a Time Bomb.
Medium · SEO 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Almost Every Analytics Tool Offers a Proxy to Beat Ad Blockers. Most Are a Time Bomb.
I built a web analytics proxy and have watched ad-blocker filter lists closely for years, so I keep meeting the same quiet problem: a team… Continue reading on
Algorithmic Entity Resolution in Music Metadata
Dev.to · Jorge Martinez 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Algorithmic Entity Resolution in Music Metadata
In the global streaming economy, Spotify, Apple Music, and other DSPs process billions of plays...
The 7 Most Impactful Use Cases for Real Estate Data Scraping in 2026
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The 7 Most Impactful Use Cases for Real Estate Data Scraping in 2026
7 real estate scraping workflows for 2026: price monitoring, rental dedup, valuation comps, change detection with schemas and pipeline… Continue reading on Towa
Pandas Explained: The Library That Made Data Analysis Easy
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Pandas Explained: The Library That Made Data Analysis Easy
Python and NumPy are excellent for numerical computation. Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Retail losses in India’s derivatives market: A re-examination of the evidence –
Originally published on Progressino By the Strategy Desk at Progressino Editor's note: This article explores Retail losses in India’s derivatives market: A re-e
A Bayesian World Cup 2026 Predictor
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
A Bayesian World Cup 2026 Predictor
Predicting goals, not winners — and keeping an honest scoreboard of how often it’s right. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Redesigning the Data Science Org for the AI Era
A shifts Data Science from headcount-based roles to product-maturity roles to build trustworthy systems. Continue reading on Medium »
MCP in 2026: The numbers behind the ecosystem explosion
Dev.to · GrahamduesCN 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
MCP in 2026: The numbers behind the ecosystem explosion
I spent an afternoon digging through the MCP ecosystem numbers. Here is what I found. The...
Seasonality-Aware Log Anomaly Detection
Medium · RAG 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Seasonality-Aware Log Anomaly Detection
Replacing hand-tuned static thresholds with a self-calibrating, per-pattern, time-of-day-aware alerting pipeline — using percentiles, a… Continue reading on Med
The Best Enterprise Data Recovery Companies in 2026: A Guide for Businesses
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
The Best Enterprise Data Recovery Companies in 2026: A Guide for Businesses
Enterprise data loss is very different from losing files on a personal computer. A failed laptop SSD is one thing, but a failed RAID array… Continue reading on