Tech Skills

Data Analytics & Business Intelligence

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

17,008
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,536) Articles (3146)Blog Posts (3467)Tutorials (384)Research Papers (41)News (498)
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...
Your Scraper Collected 50 Rows. There Were 4,000.
Dev.to · Alex Spinov 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Your Scraper Collected 50 Rows. There Were 4,000.
A scraper can pass every check you wrote and still be wrong about the one thing you actually care...
My Interview Experience at World Wide Technology for Data Science Intern Role
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
My Interview Experience at World Wide Technology for Data Science Intern Role
“Once men turned their thinking over to machines in the hopes that this would set them free. But they only permitted other men with… Continue reading on Medium
What a Customer Churn Project Taught Me About Thinking Like a Data Scientist
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What a Customer Churn Project Taught Me About Thinking Like a Data Scientist
Customer churn sounds like a machine learning problem. Continue reading on Medium »
The Secret ‘Springs’ in Your Legs: Why Human Movement is a Masterpiece of Engineering
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Secret ‘Springs’ in Your Legs: Why Human Movement is a Masterpiece of Engineering
Have you ever wondered why human walking feels so smooth while robots often look clunky and stiff? The answer isn’t just in our brain —… Continue reading on Med
how Excel is used in the real world
Dev.to · Abdisalan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
how Excel is used in the real world
*Introduction * Excel is one of the widely used tools in the corporate world mainly for...
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Picking an Experimentation Platform: A Retrospective
My approach to guiding the choice between Eppo and Statsig, and the lessons learned The post Picking an Experimentation Platform: A Retrospective appeared first
Excel and Real-World Data Analysis - What I Learned in Week 1
Dev.to · Sylvia Ndili 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Excel and Real-World Data Analysis - What I Learned in Week 1
To be honest, when I signed up for a Data Science and Analytics course, it hadn't crossed my mind...
How Excel is Used in Real-World Data Analysis
Dev.to · Melvin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
Microsoft excel is a spreadsheet program used to collect, analyze, store, calculate and visualize...
HOW EXCEL IS USED IN REAL WORLD DATA ANALYSIS
Dev.to · Ngugi Eliza 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
HOW EXCEL IS USED IN REAL WORLD DATA ANALYSIS
Introduction Excel is a spreadsheet application developed by Microsoft that helps users...
The Three Forces Threatening the Junior Data Scientist
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Three Forces Threatening the Junior Data Scientist
A data scientist builds statistical and machine learning models to help a business find the value hidden in its data. That might mean a… Continue reading on Med
How Excel is Used in Real-World Data Analysis
Dev.to · Ruto Kipkirui Robert 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
Introduction In today's fast-paced business environments, data is considered the...
DATA SCIENCE SERIES · PART 5
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
DATA SCIENCE SERIES · PART 5
A Day in the Life of a Data Scientist Continue reading on Medium »
How Excel is Used in Real-World Data Analysis
Dev.to · Steve Mwangi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
I have began my journey as a beginner in the data analysis field by learning excel. I have previously...
I Built a Threat Intel Dashboard for $0
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Built a Threat Intel Dashboard for $0
Most intel tooling costs money, subscriptions, API’s tiers, and it can scale up to thousands of dollars very fast. Continue reading on Medium »