Tech Skills

Data Analytics & Business Intelligence

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

17,218
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,742) Articles (3283)Blog Posts (3520)Tutorials (399)Research Papers (41)News (499)
Randomization Works in Experiments, Even Without Balance
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Randomization Works in Experiments, Even Without Balance
Randomization usually balances confounders in experiments, but what happens when it doesn’t? Continue reading on Medium »
Zaman Serileri: Veri Biliminde Geleceği Tahmin Etmenin En Basit Yolu
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Zaman Serileri: Veri Biliminde Geleceği Tahmin Etmenin En Basit Yolu
Merhaba, Veri Bilimi meraklıları! Zaman serileri (Time Series) konusu genellikle göz korkutucu görünür ve alfabe çorbasına dönen… Continue reading on Medium »
Zaman Serileri: Veri Biliminde Geleceği Tahmin Etmenin En Basit Yolu
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Zaman Serileri: Veri Biliminde Geleceği Tahmin Etmenin En Basit Yolu
Merhaba, Veri Bilimi meraklıları! Zaman serileri (Time Series) konusu genellikle göz korkutucu görünür ve alfabe çorbasına dönen… Continue reading on Medium »
How I Built a Real-Time Irish Economic Signal Tracker Using Kafka, FinBERT and Metabase
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How I Built a Real-Time Irish Economic Signal Tracker Using Kafka, FinBERT and Metabase
What started as a curiosity about financial data ended up teaching me more about data engineering in two days than months of tutorials. Continue reading on Medi
How I Built a Real-Time Irish Economic Signal Tracker Using Kafka, FinBERT and Metabase
Medium · NLP 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How I Built a Real-Time Irish Economic Signal Tracker Using Kafka, FinBERT and Metabase
What started as a curiosity about financial data ended up teaching me more about data engineering in two days than months of tutorials. Continue reading on Medi
How Excel is applied in real world data analysis.
Dev.to · Mistry Khateyi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is applied in real world data analysis.
My initial entry into data analysis was my belief that it would require me to learn a complex...
How Excel is used in Real-World Data Analysis.
Dev.to · kelvin gikonyo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is used in Real-World Data Analysis.
My first week at LuxDevHQ has been an enlightening one as I got to be introduced to the world of Data...
The Invisible Layer of Trading: Liquidity, Order Flow, and Market Pressure
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Invisible Layer of Trading: Liquidity, Order Flow, and Market Pressure
The Hidden Forces That Move Markets Long Before Indicators React Continue reading on InsiderFinance Wire »
The Invisible Layer of Trading: Liquidity, Order Flow, and Market Pressure
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Invisible Layer of Trading: Liquidity, Order Flow, and Market Pressure
The Hidden Forces That Move Markets Long Before Indicators React Continue reading on InsiderFinance Wire »
Pixhawk BIN Log Analysis: The Data-Driven Framework Every Drone Operator, Forensic Investigator…
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Pixhawk BIN Log Analysis: The Data-Driven Framework Every Drone Operator, Forensic Investigator…
How to unlock actionable intelligence from ArduPilot DataFlash logs — from raw .BIN files to full accident reconstruction and AI-ready… Continue reading on Medi
Pixhawk BIN Log Analysis: The Data-Driven Framework Every Drone Operator, Forensic Investigator…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Pixhawk BIN Log Analysis: The Data-Driven Framework Every Drone Operator, Forensic Investigator…
How to unlock actionable intelligence from ArduPilot DataFlash logs — from raw .BIN files to full accident reconstruction and AI-ready… Continue reading on Medi
Mastering Uncertainty in Carbon Abatement: A Deep Dive into Variations in MACC Visualizations given…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Mastering Uncertainty in Carbon Abatement: A Deep Dive into Variations in MACC Visualizations given…
Welcome to a comprehensive guide on understanding and visualizing Marginal Abatement Cost Curves (MACC) with a focus on incorporating… Continue reading on Mediu
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 »
Dashboards Should Improve the Operating Picture
Dev.to · WebmasterID 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Dashboards Should Improve the Operating Picture
Dashboards Should Improve the Operating Picture is a practical operating principle, not a...
How Excel Is Used in Real-World Data Analysis: My First Week Learning Excel
Dev.to · Leah Kivuti 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel Is Used in Real-World Data Analysis: My First Week Learning Excel
When I started learning Excel as part of my Data Science & Analytics course, I assumed it was...
From Network Cables to Data Pipelines: My 8-Month Journey from IT Support to Data Analytics
Dev.to · Paul Onyango 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
From Network Cables to Data Pipelines: My 8-Month Journey from IT Support to Data Analytics
May 25, 2026. This is not just another date on my calendar. This marks the beginning of one of the...
Someone Is Keeping Score of Your Society's Pain
Dev.to · Adrian Alexandru Stinga 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Someone Is Keeping Score of Your Society's Pain
The Grievance Catalog: Why Your Population's Pain Is Already on File Adrian Alexandru Stinga | Lead...
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Does anyone work in the financial crime space?
I’m interested in working in the financial crime space, but I’ve noticed it’s a niche area, so I’m not familiar with anyone who works in this field. I previousl
How excel is used in Real-World Data Analysis.
Dev.to · sheldon oscar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How excel is used in Real-World Data Analysis.
Introduction to excel Excel is a spreadsheet application made by microsoft part of...
Week 1 of My Data Analytics Journey: Discovering the Power of Excel in Real-World Data Analysis
Dev.to · Paul Onyango 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Week 1 of My Data Analytics Journey: Discovering the Power of Excel in Real-World Data Analysis
How Excel is Used in Real-World Data Analysis As I begin my journey into Data Science and Analytics,...
HOW EXCEL IS USED IN REAL DATA ANALYSIS
Dev.to · Kevin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
HOW EXCEL IS USED IN REAL DATA ANALYSIS
Microsoft Excel and Its Importance in Data Analysis Microsoft Excel is a spreadsheet application...
How Excel is Used in Real-World Data Analysis
Dev.to · Trevor Karuma 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
Microsoft Excel When I decide that I would pursue data science as a career path, I knew...
Hello DEV! 👋 | Physics Grad Journeying into Python & Data Science
Dev.to · Okpanachi Ogwu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Hello DEV! 👋 | Physics Grad Journeying into Python & Data Science
Hello everyone! 👋 I'm excited to finally join the DEV community. I hold a First Class Honors degree...
How Excel is Used in Real-World Data Analysis
Dev.to · Brian Kiprop 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
Before this week, I thought Excel was just a fancy calculator with boxes. But after three days of my...
Microsoft Excel
Dev.to · BRIAN KIPKORIR 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Microsoft Excel
How Excel is Used in Real-World Data Analysis Microsoft Excel is one of the most popular spreadsheet...
How Excel is Used in Real-World Data Analysis
Dev.to · Maureen Kipkosgei 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
Microsoft Excel is a spreadsheet tool that is used to organize, format, analyze and store data in...
How I Used Python to Analyse 40,000 Human Gut Cells and Uncover What Makes Crohn's Disease Different from Colitis
Dev.to · Farhan Rehman Sherief 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How I Used Python to Analyse 40,000 Human Gut Cells and Uncover What Makes Crohn's Disease Different from Colitis
A step-by-step walkthrough of my multi-sample single-cell RNA sequencing project — written for anyone...
Why 95 Reviews Beats 20 Reviews — Even When Both Score 95%
Dev.to · Raj Kundalia 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why 95 Reviews Beats 20 Reviews — Even When Both Score 95%
Understanding Wilson Score, confidence intervals, and the mysterious 1.96. Originally published on...
A practical SQL query tuning playbook: execution plans, joins, indexes, and the traps
Dev.to · Victor Minbeom Joo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
A practical SQL query tuning playbook: execution plans, joins, indexes, and the traps
How I approach SQL tuning end to end — reading execution plans, the cost model, query rewrites, index strategy, the three join algorithms, the implicit-cast tra
What is Data Science? The Complete Infrastructure Hub (2026 Guide)
Dev.to · Laiba Razzaq 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What is Data Science? The Complete Infrastructure Hub (2026 Guide)
A complete architectural and infrastructure breakdown of what data science actually looks like in production.
Day 5 of 100 Days of ClickHouse®: Writing Your First Query
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Day 5 of 100 Days of ClickHouse®: Writing Your First Query
Every database journey begins with a simple query. If you’re new to ClickHouse®, one of the fastest...
DuckDB vs Polars vs Pandas: I Benchmarked All 3 on 50M Rows. The Winner Surprised Me.
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
DuckDB vs Polars vs Pandas: I Benchmarked All 3 on 50M Rows. The Winner Surprised Me.
Part 5 of the “Stop Doing This” series. Same machine, same Parquet file, same query. One tool finished before I could refill my coffee. Continue reading on Medi
The Complete Data Analyst Interview Preparation Guide for 2026
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Complete Data Analyst Interview Preparation Guide for 2026
Data Analysts play a critical role in helping organizations make data-driven decisions. Modern Data Analyst interviews focus not only on… Continue reading on Me
I built a free open source dashboard that shows exactly how far every country is from its Paris…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I built a free open source dashboard that shows exactly how far every country is from its Paris…
Climate change conversations are full of pledges. NDCs, net-zero targets, 2030 goals. What you almost never see is a clear answer to the… Continue reading on Me
Building Open Source Racing Analytics
Reddit r/webdev 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building Open Source Racing Analytics
Spent the last few months of my free time working on this, essentially a version of
Here’s a full philosophical essay for Medium, without metaphors, grounded in historical context and…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Here’s a full philosophical essay for Medium, without metaphors, grounded in historical context and…
Entropy, Reflexivity, and the Architecture of a Market-Aware Brain. Continue reading on Medium »
The New Era of Data Analytics: Intelligence, Governance & Empowerment
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The New Era of Data Analytics: Intelligence, Governance & Empowerment
Data analytics has undergone a significant transformation over the past decade. Continue reading on Medium »
Python for Data Science — Bivariate Analysis with Real Examples
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Science — Bivariate Analysis with Real Examples
In the previous article, we discussed Univariate Analysis, where the focus was on understanding one variable at a time. Continue reading on Medium »
Python for Data Science — Bivariate Analysis with Real Examples
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Science — Bivariate Analysis with Real Examples
In the previous article, we discussed Univariate Analysis, where the focus was on understanding one variable at a time. Continue reading on Medium »
Python for Data Science — Univariate Analysis Explained Clearly
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Science — Univariate Analysis Explained Clearly
In the previous article, we discussed how good analysis begins with asking good questions. Continue reading on Medium »
Python for Data Science — Univariate Analysis Explained Clearly
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Science — Univariate Analysis Explained Clearly
In the previous article, we discussed how good analysis begins with asking good questions. Continue reading on Medium »
Creating a funnel chart using Plotly
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Creating a funnel chart using Plotly
Hello everyone! In this article, we will talk about how to create a funnel chart using the Plotly library in Python. Continue reading on Medium »
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Databricks for data science?
My company has an enterprise databricks account and they want my team to start using it. I currently query our main Postgres database on an on-prem workstation
Mastering Sankey Diagrams in Python: A Cross-Domain Guide to End-to-End Data Science Storytelling
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Mastering Sankey Diagrams in Python: A Cross-Domain Guide to End-to-End Data Science Storytelling
How Companies Lose Money in Hidden Flows: 100 Business Use Cases for AI, Analytics, and SaaS across 10 Industry Sectors 烙 Continue reading on Medium »
How Excel Is Used in Real-World Data Analysis
Dev.to · janejoy mathiu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel Is Used in Real-World Data Analysis
Microsoft Excel is one of the most powerful and widely used tools for real-world data analysis. It is...
How Excel is Used in Real-World Data Analysis
Dev.to · Isaac Atuti 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
Introduction When entering the world of data science, it is easy to get swept up in...
How Excel is used in Real-World Data Analysis
Dev.to · Erick Orwa 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is used in Real-World Data Analysis
Introduction to Excel Excel is a Microsoft program used to organize, validate, clean, and...
How Excel is used in real-world Data Analytics
Dev.to · Beizy Amanda 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is used in real-world Data Analytics
Introduction Excel isn't just for budgets and to-do lists. In the real world, it is still...