Tech Skills

Data Analytics & Business Intelligence

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

16,745
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,280) Articles (2974)Blog Posts (3413)Tutorials (359)Research Papers (39)News (495)
Day 43 – ClickHouse® Join Types and Performance Implications
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d 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 6d 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 6d 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 6d 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
DataLineage vs OpenLineage, Marquez, DataHub: Which Data Lineage Tool Should You Use?
Dev.to · Ahmed Moussa 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
DataLineage vs OpenLineage, Marquez, DataHub: Which Data Lineage Tool Should You Use?
--- title: "Data Lineage Tools in 2024: An Honest Field Guide (DataLineage vs. The...
10 Data Ingestion Optimization Techniques for Faster and Scalable Processing
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d 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 6d 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 6d 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 6d 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 6d 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 6d 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
Decoding the Sky: A Network Analysis of the U.S. Air Traffic Control System
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Decoding the Sky: A Network Analysis of the U.S. Air Traffic Control System
Have you ever wondered how air traffic flows so smoothly across a massive country like the United States? Behind the thousands of flights… Continue reading on M
Decoding the Sky: A Network Analysis of the U.S. Air Traffic Control System
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Decoding the Sky: A Network Analysis of the U.S. Air Traffic Control System
Have you ever wondered how air traffic flows so smoothly across a massive country like the United States? Behind the thousands of flights… Continue reading on M
What Averages Don’t Tell You About JNPT Congestion: 0.23
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d 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 »
10 Forecasting Techniques Essential for Optimizing Inventory in Fast Fashion and E-Commerce
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
10 Forecasting Techniques Essential for Optimizing Inventory in Fast Fashion and E-Commerce
Demand forecasting methods that improve inventory decisions across fast-moving retail environments Continue reading on Medium »
10 Forecasting Techniques Essential for Optimizing Inventory in Fast Fashion and E-Commerce
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
10 Forecasting Techniques Essential for Optimizing Inventory in Fast Fashion and E-Commerce
Demand forecasting methods that improve inventory decisions across fast-moving retail environments Continue reading on Medium »
How to build custom functions on Google Sheets
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d 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 6d 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 6d 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 6d 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 6d 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 6d 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 6d 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 6d 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 6d 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 6d 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
Stop Writing Messy Pandas Code: A Deep Dive Into .Pipe()
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Stop Writing Messy Pandas Code: A Deep Dive Into .Pipe()
Level up your ETL (Extract, Transform, Load) skill Continue reading on Level Up Coding »
A Bayesian World Cup 2026 Predictor
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d 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 6d 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 6d 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...
Stats_with_FirstPrinciples 01: How Randomness and Uncertainty give bith to Probability?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Stats_with_FirstPrinciples 01: How Randomness and Uncertainty give bith to Probability?
“Statistics doesn’t begin with probability. It begins with uncertainty.” Continue reading on Medium »
Apache Spark Mastery (Part 5 of 6): Going to Production
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Apache Spark Mastery (Part 5 of 6): Going to Production
Where a notebook experiment becomes a pipeline you can trust. Continue reading on Medium »
Seasonality-Aware Log Anomaly Detection
Medium · RAG 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d 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
ARCO-Mars: A Unified Archive of Mars Atmospheric Data
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
ARCO-Mars: A Unified Archive of Mars Atmospheric Data
For the past few months, my feed mentions new developments in the space of AI, particularly focused on Earth system modeling and Planetary… Continue reading on
The Best Enterprise Data Recovery Companies in 2026: A Guide for Businesses
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d 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
Data Science Journey
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Data Science Journey
After almost a decade working across academia and industry in data science, I’ve learned a few lessons worth sharing. Continue reading on Medium »
Python for Data Science — Mini Project: Visual Storytelling with Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Python for Data Science — Mini Project: Visual Storytelling with Data
Throughout this section, we’ve learned how to create and interpret different types of visualizations: Continue reading on Medium »
Python for Data Science — Mini Project: Visual Storytelling with Data
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Python for Data Science — Mini Project: Visual Storytelling with Data
Throughout this section, we’ve learned how to create and interpret different types of visualizations: Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
My Oasis Infobyte Data Analytics Internship Experience
During my internship as a Data Analytics Intern at Oasis Infobyte (OIBSIP), I gained valuable hands-on experience by working on real-world… Continue reading on
FIRST_VALUE and LAST_VALUE in SQL — One Works Like Magic, the Other Lies to Your Face
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
FIRST_VALUE and LAST_VALUE in SQL — One Works Like Magic, the Other Lies to Your Face
Let me tell you something that took me an embarrassingly long time to figure out. Continue reading on Medium »
My Data Science & AI/ML Internship Preparation Notes — Part 5
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
My Data Science & AI/ML Internship Preparation Notes — Part 5
Data Visualization with Matplotlib and Seaborn Continue reading on Medium »
My Data Science & AI/ML Internship Preparation Notes — Part 5
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
My Data Science & AI/ML Internship Preparation Notes — Part 5
Data Visualization with Matplotlib and Seaborn Continue reading on Medium »
Polars: Tried for the speed, stayed for the API
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Polars: Tried for the speed, stayed for the API
Beyond the 100x speed hype: Why the real power of Polars lies in how it changes the way you write data pipelines. Continue reading on Data And Beyond »
Polars: Tried for the speed, stayed for the API
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Polars: Tried for the speed, stayed for the API
Beyond the 100x speed hype: Why the real power of Polars lies in how it changes the way you write data pipelines. Continue reading on Data And Beyond »
Your analytics dashboard is blind to most AI traffic. Here's how I fixed mine.
Dev.to · Kenichi Uchiumi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Your analytics dashboard is blind to most AI traffic. Here's how I fixed mine.
A few weeks ago I went digging through raw server logs on a WordPress site I run, out of simple...
SQL window functions: what separates a mid-level from a senior developer
Dev.to · Lucas Braun 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
SQL window functions: what separates a mid-level from a senior developer
Most developers know SELECT, JOIN, and GROUP BY. Window functions are where the gap between mid and...
Microsoft Fabric Certification Roadmap 2026: A Practical Guide to DP-600, DP-700 & DP-800
Dev.to · Datta Sable 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Microsoft Fabric Certification Roadmap 2026: A Practical Guide to DP-600, DP-700 & DP-800
If you're planning to work with Microsoft Fabric in 2026, one of the first questions you'll face...
7 Developer Skills That Became More Valuable Than Coding
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
7 Developer Skills That Became More Valuable Than Coding
What clients and companies actually notice Continue reading on Python in Plain English »