Tech Skills

Data Analytics & Business Intelligence

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

17,208
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,733) Articles (3274)Blog Posts (3520)Tutorials (399)Research Papers (41)News (499)
Retention cohort analysis with plain SQL
Dev.to · Zenovay 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Retention cohort analysis with plain SQL
Everyone wants a retention chart and most reach for a tool. You can get the core cohort triangle from...
Running Ad-Hoc Video Analytics on Parquet Exports with DuckDB
Dev.to · ahmet gedik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Running Ad-Hoc Video Analytics on Parquet Exports with DuckDB
How we run heavy ad-hoc analytical queries over tens of millions of viral-video snapshots by exporti
I Gave My Data Pipeline a Contract. It Broke on Day Two. That Was Fine.
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Gave My Data Pipeline a Contract. It Broke on Day Two. That Was Fine.
Schema contracts are a solved problem. You write a Pydantic model, add range checks, wire up a dead-letter topic. Continue reading on Medium »
I Built a Data Lakehouse to Map Kenya’s Healthcare Inequality — Here’s What I Learned
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
I Built a Data Lakehouse to Map Kenya’s Healthcare Inequality — Here’s What I Learned
And why I deliberately over-engineered it Continue reading on Medium »
The Beta-Binomial trick for not overreacting to a tiny sample
Dev.to · Bid Canvas 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Beta-Binomial trick for not overreacting to a tiny sample
It's the third quarter. A team that shoots 40% from three on the season is sitting at 4-for-20 (20%)...
Dynamically Generating SQL Joins for Tables Based on a Common Column
Dev.to · Tzvi Gregory Kaidanov 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Dynamically Generating SQL Joins for Tables Based on a Common Column
Introduction SQL databases often contain many tables that are related through common columns, such as...
Starting a Migration: Shifting from a Legacy Data System to a Modern Data Stack
Dev.to · Matheus Dallacort 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Starting a Migration: Shifting from a Legacy Data System to a Modern Data Stack
Hello, DEV community! I’m currently working as a developer/engineer, and our data architecture...
​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 »