Tech Skills

Data Analytics & Business Intelligence

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

16,855
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,384) Articles (3044)Blog Posts (3429)Tutorials (375)Research Papers (39)News (497)
Features as Code:
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Features as Code:
Improving Testing, Maintainability, and Consistency with Reusable Feature Definitions Continue reading on Medium »
I Built a Python Lead Generation Machine That Found 10,000 Potential Customers While I Slept
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
I Built a Python Lead Generation Machine That Found 10,000 Potential Customers While I Slept
How I used web scraping, AI, automation, and data enrichment to build a business prospecting system that worked 24/7 — and eventually… Continue reading on Pytho
Before the Charts: How to Perform Exploratory Data Analysis with Python and Excel
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Before the Charts: How to Perform Exploratory Data Analysis with Python and Excel
When people think about data analysis, they often imagine beautiful dashboards, colorful charts, and sophisticated business metrics… Continue reading on Medium
Sample Size Calculation for A/B Tests: Getting It Right Before You Start
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Sample Size Calculation for A/B Tests: Getting It Right Before You Start
Master A/B test sample size calculation including the relationship between baseline conversion rate, minimum detectable effect, and… Continue reading on Medium
Descriptive Statistics:
Medium · NLP 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Descriptive Statistics:
Descriptive Statistics is a way to describe and summarize data. It helps us understand large amounts of data easily. Instead of looking at… Continue reading on
Apache Data Lakehouse Weekly: June 4 to June 11, 2026
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Apache Data Lakehouse Weekly: June 4 to June 11, 2026
The lakehouse community spent this week arguing about versions, and the arguments mattered. Parquet...
M L V A D A T A S C I E N C E
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
M L V A D A T A S C I E N C E
• D A R S 4 Data Visualization Matplotlib · Seaborn Continue reading on Medium »
AI for data analysis: real use cases
Dev.to · eternalsix 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
AI for data analysis: real use cases
AI for Data Analysis: What Actually Works (And What's Just Demo Magic) Last month I...
Cleaning messy CSVs without pandas: 3 tiny no-install scripts
Dev.to · wave zhou 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Cleaning messy CSVs without pandas: 3 tiny no-install scripts
Messy CSV exports are a tax on every data task: stray whitespace, duplicate rows, inconsistent...
Reliance Retail FMCG Sales & Inventory Dashboard
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Reliance Retail FMCG Sales & Inventory Dashboard
 Building an End-to-End FMCG Sales & Inventory Dashboard: A business Analytics Journey Continue reading on Medium »
Building a Real-Time World Cup Prediction Dashboard: Polymarket API + Python + Live Odds
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Building a Real-Time World Cup Prediction Dashboard: Polymarket API + Python + Live Odds
The Polymarket World Cup Winner market has processed $1.96 billion in trading volume, which makes it the largest prediction market event… Continue reading on Th
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
BI Is Dead, Long Live BI
The true bottleneck was never the analysis. The post BI Is Dead, Long Live BI appeared first on Towards Data Science .
Demo: Full Data Synchronization from MySQL CDC to PostgreSQL with Apache SeaTunnel
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Demo: Full Data Synchronization from MySQL CDC to PostgreSQL with Apache SeaTunnel
This article provides a detailed walkthrough on using Apache SeaTunnel 2.3.9 to perform full data synchronization from MySQL CDC to… Continue reading on Medium
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Antes dos Gráficos: Como Fazer uma Análise Exploratória de Dados com Python e Excel
Quando pensamos em análise de dados, muitas pessoas imaginam dashboards bonitos, gráficos coloridos e indicadores sofisticados. Porém… Continue reading on Mediu
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Antes dos Gráficos: Como Fazer uma Análise Exploratória de Dados com Python e Excel
Quando pensamos em análise de dados, muitas pessoas imaginam dashboards bonitos, gráficos coloridos e indicadores sofisticados. Porém… Continue reading on Mediu
Building Video Heatmap Analytics with HyperLogLog in Postgres
Dev.to · ahmet gedik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Building Video Heatmap Analytics with HyperLogLog in Postgres
How we built per-second video watch heatmaps using HyperLogLog sketches in Postgres, with mergeable
Cost per sample? Try cost per attempt
The Register 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Cost per sample? Try cost per attempt
PARTNER CONTENT Your genomics pipeline is probably failing 30% of the time and you're paying for all of it
Spot trends faster, sort smarter: Unlocking Sparklines and Custom Sort in Amazon Quick
AWS Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Spot trends faster, sort smarter: Unlocking Sparklines and Custom Sort in Amazon Quick
Today, we’re excited to announce two new capabilities that make Quick Sight dashboards even more expressive and business-aligned: sparklines and custom sort for
Simon Willison's Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
datasette 1.0a33
Release: datasette 1.0a33 This alpha is a significant step on the road to a stable 1.0, finally extending the ?_extra= pattern I introduced in Datasette 1.0a3 t
When Linearity Lies: A Data Scientist’s Guide to Troubleshooting Regression Models
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
When Linearity Lies: A Data Scientist’s Guide to Troubleshooting Regression Models
“If you torture the data enough, it will confess to anything.” — Ronald Coase Continue reading on Medium »
4 of my 15 trading patterns actually have edge. Here’s how I found out.
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
4 of my 15 trading patterns actually have edge. Here’s how I found out.
I learn, Backtest, improve and implement. Continue reading on Investor’s Handbook »
Feature Stores from Scratch: A Minimal Working Implementation
KDnuggets 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Feature Stores from Scratch: A Minimal Working Implementation
Build the five components every feature store needs, then see where AI changes the design.
Python for Data Science — Correlation: Useful, Dangerous, and Misused
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Python for Data Science — Correlation: Useful, Dangerous, and Misused
In the previous article, we discussed Bivariate Analysis, and Detecting Skewness, Spread, and Strange Distributions where the goal was to… Continue reading on M
From Government Dashboard to Power BI: Tracking Uganda’s Ebola Outbreak with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
From Government Dashboard to Power BI: Tracking Uganda’s Ebola Outbreak with Python
On the back of learning that America is denying entry to anyone who has been in either the Democratic Republic of Congo or Uganda within… Continue reading on Me
The Verge 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Amazon’s data centers used 2.5 billion gallons of water last year
Just after Seattle enacted a one-year data center moratorium that some of Amazon's own employees pushed for, Amazon shared how much water its data centers use,
How We Die Reveals How We Live: What Data Says About American Life
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How We Die Reveals How We Live: What Data Says About American Life
To understand life in America, we must understand how and when we die. In 2026, it’s not a pretty picture. U.S. health and care is worse than other nations and
Kurtosis In Statistics: Difference with skewness
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Kurtosis In Statistics: Difference with skewness
In this blog we will be diving deep to concept of kurtosis along with difference with skewness . Continue reading on Medium »
Journal Figure Replication | Plotting a Composite Correlation Network Heatmap with Python
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Journal Figure Replication | Plotting a Composite Correlation Network Heatmap with Python
Composite Correlation Network Heatmap Continue reading on Top Python Libraries »
Construindo um Sistema de Inferência de Tipos para Dados Web Bagunçados
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Construindo um Sistema de Inferência de Tipos para Dados Web Bagunçados
Tabelas web são strings. Tudo é string. Mas quando você exporta para JSON ou SQL, você...
Can Data Centers Become Climate Solutions Instead of Energy Problems?
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Can Data Centers Become Climate Solutions Instead of Energy Problems?
What if the infrastructure powering our digital lives could help solve some of the environmental challenges it currently creates? Continue reading on Medium »
How we built one of Africa’s first data-driven football scouting platforms at Afriskaut
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How we built one of Africa’s first data-driven football scouting platforms at Afriskaut
African football has never lacked talent. What it has often lacked is infrastructure: structured data, scalable scouting systems, and… Continue reading on Mediu
StarVault: Reclaiming Data Ownership in the Age of AI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
StarVault: Reclaiming Data Ownership in the Age of AI
The Problem We Can No Longer Ignore Continue reading on Medium »
MIT Technology Review 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Inside soccer’s data renaissance
Imagine tuning in to the opening kickoff of a World Cup match and seeing a player intentionally send the ball all the way down the pitch and right out of bounds
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Why Data Engineering Is Becoming One of the Highest-Value Careers in the Modern Job Market
Most students choose a course by asking one question: Continue reading on Medium »
Visualizing Rocket Telemetry with Python: From Raw Data to Flight Insights
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Visualizing Rocket Telemetry with Python: From Raw Data to Flight Insights
How simple plotting libraries help young engineers analyze velocity, altitude, and sensor data during atmospheric flight. Continue reading on Medium »
Demo: Full Data Synchronization from MySQL CDC to PostgreSQL with Apache SeaTunnel
Dev.to · Apache SeaTunnel 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Demo: Full Data Synchronization from MySQL CDC to PostgreSQL with Apache SeaTunnel
This article provides a detailed walkthrough on using Apache SeaTunnel 2.3.9 to perform full data...
From Clean Data to BI-Ready Reporting Tables with Python, PostgreSQL, and Metabase
Dev.to · Bob Oner 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
From Clean Data to BI-Ready Reporting Tables with Python, PostgreSQL, and Metabase
In the previous article, I extended a small Python data quality ETL starter from validation and...
How to Query Parquet Files in Object Storage with BigQuery External Tables
Dev.to · Mirlan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How to Query Parquet Files in Object Storage with BigQuery External Tables
If you're storing analytics events, logs, or any append-only data as Parquet files in object storage,...
Pressure Decay Leak Rate Calculation with Temperature Compensation — Implementation Guide
Dev.to · Robin | Mechanical Engineer 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Pressure Decay Leak Rate Calculation with Temperature Compensation — Implementation Guide
Pressure decay is the standard method for leak testing sealed pneumatic assemblies. Getting accurate...
Day 11 of #100DaysOfClickHouse: Exporting Data from ClickHouse® - Formats, Methods, and Best Practices
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Day 11 of #100DaysOfClickHouse: Exporting Data from ClickHouse® - Formats, Methods, and Best Practices
Exporting Data from ClickHouse®: Formats, Methods, and Best Practices Data export is a...
I Just Wanted dbt State Without Another Account
Dev.to · Pradip Sodha 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
I Just Wanted dbt State Without Another Account
Background DBT open whole new world of how data-transformation happen, DBT brings software...
PII masking in Polars: MaskOps 2.0, and two metrics that lied to me
Dev.to · Felipe Carvajal Brown 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
PII masking in Polars: MaskOps 2.0, and two metrics that lied to me
A Rust Polars plugin for high-speed PII masking - RUT, CPF, cards, IBAN. Honest benchmarks vs pure-Python regex, air-gapped, GDPR-ready. MaskOps 2.0.
Unlocking Hyper-Local Retrofit Patterns: Using BigQuery ML to Decipher Shrewsbury’s Property…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Unlocking Hyper-Local Retrofit Patterns: Using BigQuery ML to Decipher Shrewsbury’s Property…
Introduction & Motivation Continue reading on Google Cloud - Community »
The Best Crypto Data APIs for Developers in 2026
Dev.to · Neal O'Grady 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
The Best Crypto Data APIs for Developers in 2026
If you have ever tried to build a crypto app from scratch, you already know where the time goes. It...
One-Tailed vs Two-Tailed Tests: Does It Actually Matter?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
One-Tailed vs Two-Tailed Tests: Does It Actually Matter?
Understand the difference between one-tailed and two-tailed hypothesis tests in A/B testing, when each is appropriate, and the simple… Continue reading on Mediu
How to backtest a Polymarket strategy with free 15-minute historical data
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How to backtest a Polymarket strategy with free 15-minute historical data
A reproducible recipe: load 18M+ Polymarket price snapshots, label resolved markets, and backtest a favorite-longshot strategy in ~40 lines of pandas. With the
Building My First Sales Dashboard
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Building My First Sales Dashboard
As part of my data analytics learning journey, I created the DACV0526 Cohort Sales Dashboard using Excel/Power BI. The goal was to… Continue reading on Medium »
What is Killing Crypto in 2026?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
What is Killing Crypto in 2026?
Tools: Google Colab, Python, yfinance, pandas, NumPy, statsmodels, sklearn, matplotlib, seaborn Continue reading on Medium »