Tech Skills

Data Analytics & Business Intelligence

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

17,219
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,743) Articles (3283)Blog Posts (3520)Tutorials (399)Research Papers (42)News (499)
10 SQL Techniques for Managing Index Fragmentation Automatically
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
10 SQL Techniques for Managing Index Fragmentation Automatically
Automated maintenance strategies to control fragmentation, sustain query performance, and minimize operational overhead Continue reading on Medium »
10 SQL Techniques for Managing Index Fragmentation Automatically
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
10 SQL Techniques for Managing Index Fragmentation Automatically
Automated maintenance strategies to control fragmentation, sustain query performance, and minimize operational overhead Continue reading on Medium »
I built a free SQL practice game where you work at a fictional Singapore bank
Dev.to · Martin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I built a free SQL practice game where you work at a fictional Singapore bank
I've been frustrated with SQL learning resources for a while. Most are either: Dry reference...
The Fastest Way to Scrape Vinted: Paste URLs, Export Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Fastest Way to Scrape Vinted: Paste URLs, Export Data
Vinted Turbo Scraper is built for one job: turn one or multiple Vinted search URLs into CSV, Excel, Sheets, JSON, or API data as quickly… Continue reading on Me
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Los datos no son el nuevo petróleo. Son el nuevo Cuello de Botella.
La verdadera restricción en la era de la IA no es cuántos datos tienes, sino si realmente sirven para algo. Durante la última década, la… Continue reading on Me
The Data Trap: Why Quantifying Sports ‘Motivation’ Outperforms Injury Lists
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Data Trap: Why Quantifying Sports ‘Motivation’ Outperforms Injury Lists
The sports data analytics market is skyrocketing. Millions of bettors and investors power up their Excel sheets and algorithmic models… Continue reading on Medi
Using the Herfindahl-Hirschman Index to Measure Categorical Data Quality
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Using the Herfindahl-Hirschman Index to Measure Categorical Data Quality
A practical technique borrowed from economics to detect label monopolies, coarse taxonomies, and silent ingestion defects in your datasets. Continue reading on
Using the Herfindahl-Hirschman Index to Measure Categorical Data Quality
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Using the Herfindahl-Hirschman Index to Measure Categorical Data Quality
A practical technique borrowed from economics to detect label monopolies, coarse taxonomies, and silent ingestion defects in your datasets. Continue reading on
Navigating Financial Uncertainty: A Strategic Introduction to Risk Modeling with Python
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Navigating Financial Uncertainty: A Strategic Introduction to Risk Modeling with Python
The modern business landscape is characterized by unprecedented volatility. From sudden macroeconomic shifts and geopolitical tensions to… Continue reading on M
Análise de Dados: Como o Pix Superou o Cartão de Débito e Transformou os Pagamentos no Brasil…
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Análise de Dados: Como o Pix Superou o Cartão de Débito e Transformou os Pagamentos no Brasil…
A análise dos dados entre 2020 e 2025 evidencia uma mudança estrutural no mercado de pagamentos, marcada pela rápida adoção do Pix e pela… Continue reading on M
Beyond default: A practitioner’s guide to production-ready Plotly visualizations
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Beyond default: A practitioner’s guide to production-ready Plotly visualizations
Stop settling for basic charts. Here is how to build interactive, stakeholder-ready graphics that elevate your data science portfolio. Continue reading on Mediu
Beyond default: A practitioner’s guide to production-ready Plotly visualizations
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Beyond default: A practitioner’s guide to production-ready Plotly visualizations
Stop settling for basic charts. Here is how to build interactive, stakeholder-ready graphics that elevate your data science portfolio. Continue reading on Mediu
Fraud Detection in Kenya: How Data Science Can Protect Mobile Money and Digital Payments
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Fraud Detection in Kenya: How Data Science Can Protect Mobile Money and Digital Payments
Kenya is one of Africa’s most advanced digital economies. With millions of daily transactions flowing through mobile money platforms… Continue reading on Medium
The IEC 61724–1:2021 Weather Correction Most Solar O&M Platforms Ignore
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The IEC 61724–1:2021 Weather Correction Most Solar O&M Platforms Ignore
Why Your Performance Ratio Is Just a Weather Report (And How to Fix It) Continue reading on Medium »
Learn SQL Once, Use It for 30 Years: Why the Skill Doesn't Expire
Dev.to · Conor Dobbs 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Learn SQL Once, Use It for 30 Years: Why the Skill Doesn't Expire
SQL rests on Codd's 1970 relational model, is declarative so it gets faster without rewrites, and was standardized in 1986. Why that makes it a rare skill that
Beyond Default Aggregations: Understanding LOD Expressions in Tableau
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Beyond Default Aggregations: Understanding LOD Expressions in Tableau
Not every data question works with what Tableau shows by default. Sometimes the calculation we need is at a different level than what the… Continue reading on M
Medium · DevOps 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
A Data Pipeline Can Pass While Producing Stale Results
A green job status is not the same as fresh output. In data-heavy systems, old records can hide a broken step. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
More Than Just Cables: What I Learnt about Networking This Week
Before this week, whenever I thought about the internet, I mostly focused on the applications I use every day. Whether it was sending… Continue reading on Mediu
Ölçeklenebilir Uçtan Uca Veri Platformu Kurulumu: Docker Üzerinde Airflow, Spark, MinIO ve…
Medium · DevOps 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Ölçeklenebilir Uçtan Uca Veri Platformu Kurulumu: Docker Üzerinde Airflow, Spark, MinIO ve…
Modern bir veri platformu geliştirmek; orkestrasyon, dağıtık işleme, depolama ve veri ambarı katmanlarının birbiriyle pürüzsüz bir şekilde… Continue reading on
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Subir Walmart Dataset a Supabase y construir un Data Warehouse + Data Mart
(IBARRA JARA RAFAEL SALVADOR) Continue reading on Medium »
HOW EXCEL IS USED IN REAL-WORLD DATA ANALYSIS
Dev.to · Jedidah Ondiso 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
HOW EXCEL IS USED IN REAL-WORLD DATA ANALYSIS
Excel is a powerful spreadsheet program developed by Microsoft. It is used to organize, calculate,...
Charting Twitch Chat Velocity: Hype Curve Analysis for Esports VODs
Dev.to · Devil Scrapes 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Charting Twitch Chat Velocity: Hype Curve Analysis for Esports VODs
Quick answer: To measure Twitch chat hype or velocity, pull the full VOD chat using the...
Who’s Actually Going to Pull That Number For You? A Review on AgenticBI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Who’s Actually Going to Pull That Number For You? A Review on AgenticBI
In most small companies, the answer is “the one person who can write the query, once they clear their backlog.” Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your Scraper Died at Row 12,000. The Rerun Pattern.
My scraper died at row 12,000 of 50,000, three hours in. The crash itself was cheap. A process gets OOM-killed, a quota trips, a machine… Continue reading on Me
Analytics Events Need Context to Stay Useful
Dev.to · WebmasterID 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Analytics Events Need Context to Stay Useful
Analytics Events Need Context to Stay Useful is a practical operating principle, not a slogan. The...
What Does a Product Data Scientist Actually Do?
Dev.to · Argha Sarkar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What Does a Product Data Scientist Actually Do?
Nowadays, everyone is talking about data science, but not many people know what a Product Data...
Data Product Reviews: Why They Fail Before Starting
Dev.to · David Ohnstad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Product Reviews: Why They Fail Before Starting
David Ohnstad explains why mid-year data product reviews collapse when teams can't answer critical questions. Learn how to fix broken review processes.
Algo (24 /40)Data is the New Oil: Compression, Latent Factors & Scale (2006–2009)
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Algo (24 /40)Data is the New Oil: Compression, Latent Factors & Scale (2006–2009)
By the late 2000s, the internet had matured. We were no longer dealing with kilobytes of text but terabytes of images, user clicks, and… Continue reading on Med
How Character Sets, Collations, and String Comparisons Cause Subtle Data Drift in GBase 8a
Dev.to · Michael 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Character Sets, Collations, and String Comparisons Cause Subtle Data Drift in GBase 8a
Many "the results look wrong" problems in a gbase database don't come from incorrect imports or bad...
Spark, dbt and Airflow — A Practical Walkthrough
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Spark, dbt and Airflow — A Practical Walkthrough
Building a medallion architecture pipeline from scratch Continue reading on Medium »
Python for Data Science — Asking Better Questions from Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Science — Asking Better Questions from Data
In the previous article, we discussed what Exploratory Data Analysis (EDA) actually means. Continue reading on Medium »
Python for Data Science — Asking Better Questions from Data
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Science — Asking Better Questions from Data
In the previous article, we discussed what Exploratory Data Analysis (EDA) actually means. Continue reading on Medium »
Python for Data Science — What Exploratory Data Analysis (EDA) Actually Means
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Science — What Exploratory Data Analysis (EDA) Actually Means
Data science is not just about writing code, cleaning datasets, or training machine learning models. Continue reading on Medium »
What I Learned Scraping 2,800 UK Data Job Postings (And Why the API Lied to Me)
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What I Learned Scraping 2,800 UK Data Job Postings (And Why the API Lied to Me)
An NLP analysis of the UK data role market, a methodology surprise, and what £14,000 of “AI premium” actually means. Continue reading on Medium »
What I Learned Scraping 2,800 UK Data Job Postings (And Why the API Lied to Me)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What I Learned Scraping 2,800 UK Data Job Postings (And Why the API Lied to Me)
An NLP analysis of the UK data role market, a methodology surprise, and what £14,000 of “AI premium” actually means. Continue reading on Medium »
What I Learned Scraping 2,800 UK Data Job Postings (And Why the API Lied to Me)
Medium · NLP 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What I Learned Scraping 2,800 UK Data Job Postings (And Why the API Lied to Me)
An NLP analysis of the UK data role market, a methodology surprise, and what £14,000 of “AI premium” actually means. Continue reading on Medium »
Best Data Science And Analytics Certifications For Career Growth In 2026
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Best Data Science And Analytics Certifications For Career Growth In 2026
The demand for data science and analytics professionals has never been more structured or more urgent. Organizations across every sector… Continue reading on Me
Journal Figure Replication | Plotting a Horizontal Percent Stacked Bar Chart with Python
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Journal Figure Replication | Plotting a Horizontal Percent Stacked Bar Chart with Python
Horizontal Percent Stacked Bar Chart Continue reading on Top Python Libraries »
Journal Figure Replication | Plotting a Horizontal Percent Stacked Bar Chart with Python
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Journal Figure Replication | Plotting a Horizontal Percent Stacked Bar Chart with Python
Horizontal Percent Stacked Bar Chart Continue reading on Top Python Libraries »
Journal Figure Replication | Plotting a Horizontal Percent Stacked Bar Chart with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Journal Figure Replication | Plotting a Horizontal Percent Stacked Bar Chart with Python
Horizontal Percent Stacked Bar Chart Continue reading on Top Python Libraries »
Time Series Forecasting Fundamentals — Part 1
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Time Series Forecasting Fundamentals — Part 1
Before building any forecasting model, you need to understand what kind of structure you are dealing with. Continue reading on Medium »
Data Science Skills That Companies Are Looking For in 2026
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Science Skills That Companies Are Looking For in 2026
The demand for data professionals continues to grow as organizations increasingly rely on information to drive business decisions… Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
<think>
Check this out: the user wants me to rewrite this article as a completely new piece from the perspective of a data scientist. I need to: NOT copy any sentences
3.5+ years in the making: Live Analytics without AI
Dev.to · Patrick Wunderlin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
3.5+ years in the making: Live Analytics without AI
Just wanted to share my journey after 3.5 years of building a live web analytics tool from scratch,...
Getting Personal: The Orchestration Behind Great Experiences
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Getting Personal: The Orchestration Behind Great Experiences
Great personalization starts with context. At scale, that context comes from your data, but only if it’s structured, connected and usable across your systems.
I Replaced 3 Paid Tools With Python — Here’s What Happened
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Replaced 3 Paid Tools With Python — Here’s What Happened
Less spending, more control Continue reading on Stackademic »
Normalizing DATEX II Across 30 European National Access Points
Dev.to · Roman Kotenko 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Normalizing DATEX II Across 30 European National Access Points
EU Directive 2010/40/EU mandates that every Member State operates a National Access Point (NAP) that...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Looker KPI Governance 2026: Building Trusted Metrics and Enterprise-Grade Data Quality for…
As organizations accelerate their investments in Artificial Intelligence, predictive analytics, and self-service reporting, one challenge… Continue reading on M