Tech Skills

Data Analytics & Business Intelligence

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

17,006
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,534) Articles (3144)Blog Posts (3467)Tutorials (384)Research Papers (41)News (498)
​The Hidden Intake Gap: Why ABA Referral Conversion Fails Before The First Visit
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
​The Hidden Intake Gap: Why ABA Referral Conversion Fails Before The First Visit
Most ABA practices track new patient volume, but few track what percentage of received referrals actually convert to a completed first visit.
How Excel is Used in Real-World Data Analysis
Dev.to · Joy Andati 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
Nobody grows up dreaming of pivot tables. But as the meme above knows too well, the spreadsheet was...
How I Engineered a 10M-Row Autonomous AI-BI Agent Using DuckDB
Dev.to · Datta Sable 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How I Engineered a 10M-Row Autonomous AI-BI Agent Using DuckDB
This article was originally published on dattasable.com. In the modern data landscape, the gap...
Extract data from Databases into DuckLake
Dev.to · Fritz Larco 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Extract data from Databases into DuckLake
Introduction In the evolving landscape of data engineering, DuckLake is emerging as a...
Why Data Warehousing Is the Foundation of Algorithmic Trading
Dev.to · Narruxsystems 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why Data Warehousing Is the Foundation of Algorithmic Trading
Most conversations about algorithmic trading focus on the algorithm — the model, the signal, the...
Grafana Dashboards: Information Density vs Readability
Dev.to · Guatu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Grafana Dashboards: Information Density vs Readability
Stop cramming every metric into one screen. A practical look at balancing information density and performance in Grafana dashboards.
Master Data Analytics with Gen AI at IDSA Janakpuri!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Master Data Analytics with Gen AI at IDSA Janakpuri!
Unlock the power of AI‑driven insights with our Data Analytics with Gen AI course in Janakpuri, West Delhi. Perfect for students and… Continue reading on Medium
Transform Your Career with Data Analytics & Gen AI at Lone Star Academy, Janakpuri!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Transform Your Career with Data Analytics & Gen AI at Lone Star Academy, Janakpuri!
Looking to master data‑driven decision making? Our Data Analytics with Gen AI course in Janakpuri, West Delhi is designed for students and… Continue reading on
Which Skills Are Needed for Fresher Data Science Jobs-IABAC
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Which Skills Are Needed for Fresher Data Science Jobs-IABAC
A few years ago, many people thought Data science jobs were only for experienced programmers, mathematics experts, or people working… Continue reading on Medium
Stop Trusting Automated Schema Inference in Azure Data Factory
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Stop Trusting Automated Schema Inference in Azure Data Factory
If your data pipeline monitoring dashboard is a beautiful sea of green checkmarks, you probably think everything is running smoothly. I… Continue reading on Med
Data Visualization Best Practices & Mastering Big Data with Angular
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Visualization Best Practices & Mastering Big Data with Angular
How to build performant, insightful, and scalable data-driven applications Continue reading on Medium »
What Nigeria’s First 32 Days of COVID-19 Data Tell Us About Public Health Information Behaviour…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
What Nigeria’s First 32 Days of COVID-19 Data Tell Us About Public Health Information Behaviour…
National Case Growth Was Not Linear…. Continue reading on Medium »
Create Box-and-Whisker Charts in PowerPoint with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Create Box-and-Whisker Charts in PowerPoint with Python
In data analysis and statistical reporting, box and whisker charts (also known as box plots) are essential visualization tools. They… Continue reading on Medium
Construire un Système d'Inférence de Types pour des Données Web Désordonnées
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Construire un Système d'Inférence de Types pour des Données Web Désordonnées
Les tableaux web sont des chaînes de caractères. Tout est une chaîne. Mais quand on exporte en JSON...
Data Processing in Python
Dev.to · Nicholus Mush 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Processing in Python
title: Data Processing in Python — Tools & Patterns published: false tags: [python,...
SQL vs NoSQL Performance Optimization Considerations
Dev.to · Safdar Wahid 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
SQL vs NoSQL Performance Optimization Considerations
TLDR; SQL excels at complex queries and transactions – joins, aggregations, ACID...
Why Excel Is Still King in Data Analysis
Dev.to · PHILIP KAPLONG 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why Excel Is Still King in Data Analysis
Excel is a computer program built by Microsoft that lets you organize information in a grid of rows...
100 Days of ClickHouse® – Day 6: Importing CSV Files into ClickHouse®
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
100 Days of ClickHouse® – Day 6: Importing CSV Files into ClickHouse®
CSV files are one of the most common formats for storing and exchanging data. Whether you’re working...
Measuring What You Never Notice (II): The Gap That Wrecks a Truck
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Measuring What You Never Notice (II): The Gap That Wrecks a Truck
Every time I watch footage of a truck being scalped by a bridge, I find myself wondering what led to that moment. Sometimes it’s… Continue reading on Medium »
Architecture Over Alerts: How We Cut BigQuery Costs by 57%($12M) for a Fortune 500
Dev.to · Pratik Dhanave 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Architecture Over Alerts: How We Cut BigQuery Costs by 57%($12M) for a Fortune 500
I helped redesign a large BigQuery-based enterprise data warehouse and cut spend by 57%. The biggest...
How Excel is Used in Real-World Data Analysis
Dev.to · It's pronounced W3SHY 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
Microsoft Excel is an extremely popular tool used by many companies and other types of organisations...
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Weekly Entering & Transitioning - Thread 08 Jun, 2026 - 15 Jun, 2026
Welcome to this week's entering & transitioning thread! This thread is for any questions about getting started, studying, or transitioning into the data sci
I Built a Columnar File Format in Pure Python — a tiny, readable Parquet
Dev.to · Haji Rufai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Built a Columnar File Format in Pure Python — a tiny, readable Parquet
I rebuilt the core ideas behind Parquet — encodings, compression, row groups, projection & predicate pushdown — in ~3,000 lines of pure Python. 91% smaller than
Visualizing SQL Queries in R: How to Use ggsql
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Visualizing SQL Queries in R: How to Use ggsql
View SQL syntax as a graph with the convenience of ggplot2 elements, Here’s how to do it with the ggsql package. Continue reading on Medium »
In re the Matter of Patron Needs — How Judges’ Rulings and Case Filings Provide a Roadmap for Law…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
In re the Matter of Patron Needs — How Judges’ Rulings and Case Filings Provide a Roadmap for Law…
Introduction: Law — Fact v. Fiction Continue reading on Medium »
Why We Started Saving Raw Responses in Production
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Why We Started Saving Raw Responses in Production
For a long time, we treated raw responses as temporary data. Continue reading on Medium »
Reddit r/devops 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Best non-marketing resources to understand Snowflake, MongoDB, Datadog?
Hi all, I work around data in Italy and I'm trying to better understand how Snowflake, MongoDB, and Datadog's products are evolving with Al. Are there any podca
02. Your Brain Is The System Vulnerability
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
02. Your Brain Is The System Vulnerability
Article 2 of 7 in The Data Operating Lifecycle. Continue reading on Medium »
How Data Visualization Helps Decision-Making
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Data Visualization Helps Decision-Making
Turning Raw Data into Actionable Insights Continue reading on Medium »
There's No Good Programmatic Source for African Macro Data — So I Built One
Dev.to · SM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
There's No Good Programmatic Source for African Macro Data — So I Built One
If you've ever tried to get structured, current, programmatically accessible macroeconomic data for...
Building a Gender Balance Microsimulation from Scratch
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building a Gender Balance Microsimulation from Scratch
How a back-of-envelope attrition formula evolves into a Monte Carlo workforce projection framework Continue reading on Medium »
How Excel is Used in Real-World Data Analysis
Dev.to · Patrick Omondi Masese 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Excel is Used in Real-World Data Analysis
My Week 1 Reflection in Data Science & Analytics Before starting my Data Science and Analytics...
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...