Tech Skills
Data Analytics & Business Intelligence
Excel, SQL, Power BI, Tableau — turn raw data into business decisions
Skills in this topic
7 skills — Sign in to track your progress
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

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 »

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 »

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 »

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...

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...

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

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

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

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...

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

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...

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

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

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

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...

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

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

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 »

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

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

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

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 »

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

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

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

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

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...

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 »

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...

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...

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 »
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 .

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

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
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
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

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 »

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 »

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.

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

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,
DeepCamp AI