Tech Skills

Data Analytics & Business Intelligence

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

17,219
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,743) Articles (3283)Blog Posts (3520)Tutorials (399)Research Papers (42)News (499)
Apache SeaTunnel Monthly Engineering Digest (May 2026): 87 PRs, Stronger Connectors, Smarter…
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Apache SeaTunnel Monthly Engineering Digest (May 2026): 87 PRs, Stronger Connectors, Smarter…
Hello SeaTunnel community! Continue reading on Medium »
Building My First Power BI Dashboard for E-Commerce Sales Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Building My First Power BI Dashboard for E-Commerce Sales Analysis
Uncovering payment behaviour, regional trends, and product performance from Nigerian retail sales data Continue reading on Medium »
Why a Coin Toss Contains More Information Than a Sunrise
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Why a Coin Toss Contains More Information Than a Sunrise
Understanding entropy through surprise, probability, and uncertainty. Continue reading on Medium »
GBase 8a OLAP Window Functions in Practice: Ranking, Running Totals, MoM, and Ratio Analysis
Dev.to · Michael 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
GBase 8a OLAP Window Functions in Practice: Ranking, Running Totals, MoM, and Ratio Analysis
GBase 8a fully supports OLAP window functions, making it a powerful gbase database for analytical...
Day 14 of #100DaysOfClickHouse: Understanding Nodes, Shards, and Replicas
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Day 14 of #100DaysOfClickHouse: Understanding Nodes, Shards, and Replicas
When people first start learning ClickHouse®, they usually focus on SQL queries, table engines, and...
Query Optimization and Indexing Strategies for Data Warehouses
Dev.to · beefed.ai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Query Optimization and Indexing Strategies for Data Warehouses
Lower compute spend by optimizing queries: clustering keys, materialized views, predicate pushdown and scan reduction for Snowflake, BigQuery, Redshif
US Unemployment Is 4.3%.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
US Unemployment Is 4.3%.
US unemployment is 4.3%. The curve even looks like it is calming down. The data underneath says otherwise. 2 million Americans have now… Continue reading on Med
There Is No Modern Playbook for This.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
There Is No Modern Playbook for This.
There is no modern playbook for this. US core inflation — the gauge the Fed targets at 2% — is at 3.3% and re-accelerating. Outside Covid… Continue reading on M
Apache Pulsar vs Kafka for Data Engineering: Geo-Replication, Tiered Storage & Functions
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Apache Pulsar vs Kafka for Data Engineering: Geo-Replication, Tiered Storage & Functions
apache pulsar vs kafka is the messaging question that every senior data engineer has answered twice...
Kafka Connect Deep Dive: Source, Sink, SMTs, Schema Registry & Idempotent Writes
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Kafka Connect Deep Dive: Source, Sink, SMTs, Schema Registry & Idempotent Writes
kafka connect looks like "just another Kafka client" to a junior engineer — senior engineers know it...
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
I've interviewed with 100+ companies during my career. Here are some high-level notes on DS/ML job hunting
This is my job search framework, the approach I follow every time I look for a new job. I want to cover mindset, preparation, finding jobs and applying, plus th
Data Engineering Pipeline: Understanding ETL vs ELT
Dev.to · Wangila russell 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Data Engineering Pipeline: Understanding ETL vs ELT
Introduction This week, I started learning Data Engineering concepts, and one of the most important...
Federated Data Architectures: Accountability Without Authority
Dev.to · David Ohnstad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Federated Data Architectures: Accountability Without Authority
David Ohnstad explains why federated data architectures create accountability gaps for PMs. Learn how schema enforcement and governance prevent revenue att
Federated Data Architectures: Why PMs Fail
Dev.to · David Ohnstad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Federated Data Architectures: Why PMs Fail
David Ohnstad reveals why data product managers struggle in federated architectures. Learn how organizational design undermines governance and trust in dec
Graph Clustering for Entity Resolution: Why Union-Find Breaks at Web Scale
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Graph Clustering for Entity Resolution: Why Union-Find Breaks at Web Scale
Union-Find is fast, but it breaks for real-world entity resolution because it cannot handle safeguards, reversals, or ambiguous matches. A weighted graph approa
Why Building Custom Monitoring Dashboards for ClickHouse® Becomes Challenging at Scale
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Why Building Custom Monitoring Dashboards for ClickHouse® Becomes Challenging at Scale
Monitoring is one of the most critical aspects of operating any production database environment. As...
A free, keyless API for dynasty fantasy football values — built from 672k real trades
Dev.to · Elliot Pollaro 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
A free, keyless API for dynasty fantasy football values — built from 672k real trades
Most dynasty fantasy football value sources are either crowdsourced votes or locked behind paywalls....
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Why AI Web Scraping Is Becoming Essential for Modern Businesses
In a world where information changes by the minute, businesses need more than just access to data — they need access to the right data at… Continue reading on M
How will you handle missing data in a dataset?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
How will you handle missing data in a dataset?
Missing data is a common problem in Data Science and can affect the accuracy and reliability of analysis and machine learning models… Continue reading on Medium
Apache Spark: The Complete Deep Dive
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Apache Spark: The Complete Deep Dive
Architecture · Internals · Join Strategies · Catalyst & Tungsten · AQE · Memory Management · Performance Tuning · Spark 4.0 Continue reading on Medium »
I Built the Wrong Scraper First. The Data Looked Clean and Was Still Useless.
Dev.to · KazKN 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
I Built the Wrong Scraper First. The Data Looked Clean and Was Still Useless.
A build-in-public failure story about why marketplace scrapers need state, sold signals, seller context, condition, and price history instead of only clean prod
Your Scraper Returns 200 OK and Still Lies: 7 Marketplace Checks I Use
Dev.to · KazKN 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Your Scraper Returns 200 OK and Still Lies: 7 Marketplace Checks I Use
A practical checklist for making marketplace scrapers safer: sold state, disappearance, seller country, condition, precision filters, price history, and review
Demystifying Profitability: How Gross, Operating, and Net Margins Differ
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Demystifying Profitability: How Gross, Operating, and Net Margins Differ
As a financial analyst with a decade of experience, I see founders confuse revenue with profit every single day. Revenue is vanity, profit… Continue reading on
Features as Code:
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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 4w 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,