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

Dev.to · Tsvetan Gerginov
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I've built a open source PDF-To-Excel-Converter
Github Repository Hi community, I've built a open source PDF to Excel Converter and let me tell you...

Dev.to · Muhamed Maxhuni
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Learning Progress Pt.32
Daily learning part thirty-two. I started today at 17:00. I started with SQL and completed 10...

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Creating a Power BI Dashboard for Nigerian Retail Sales Analysis
Using Power BI to uncover sales trends, regional performance, and profitability inisight from a Nigerian Retail Dataset. Continue reading on Medium »

Towards AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What Really Makes Cars Pollute? A Data Science Deep Dive into CO₂ Emissions
Author(s): Sai Bhargav Rallapalli Originally published on Towards AI. How I built a 98.8% accurate prediction model — and discovered that the “cleanest” fuel is

Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
There’s a particular kind of frustration that comes from working with data in 2026. You have a CSV. Maybe it’s sales records, maybe it’s… Continue reading on Me

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
There’s a particular kind of frustration that comes from working with data in 2026. You have a CSV. Maybe it’s sales records, maybe it’s… Continue reading on Me

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
There’s a particular kind of frustration that comes from working with data in 2026. You have a CSV. Maybe it’s sales records, maybe it’s… Continue reading on Me

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
20% of Customers Generate 43% of Revenue. Here’s What the Data Says
I ran an RFM analysis on 17,000 e-commerce transactions from a Turkish online retailer. The results were eye-opening. Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Modelo de Stackelberg: Quando Quem Move Primeiro Vence
Série: Modelos Matemáticos para Data-Driven Decision Making — Step 07 / 12 Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Databricks Connect: Run Spark Code from Your Local IDE on a Remote Cluster
If you’ve ever worked with Spark, you know the usual workflow: write code, upload it to a notebook, run it on the cluster, debug through… Continue reading on Me

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Introducing PRISM: A New NBA Impact Metric
Blending regularized adjusted plus-minus with possession-level box production. Continue reading on Medium »

Dev.to · LogicNodes
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
One wallet made 58.9% of Base's 167,725 gasless USDC payments in the last 19 hours
All numbers below are chain-derived via eth_getLogs against public RPCs. Nothing is self-reported,...

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Optimizing Specific Power Consumption (kWh/T) in an Open Circuit Cement Ball Mill Using Data &…
Grinding consumes 30–40% of cement plant electricity. Learn how to cut kWh/T by 8–15% using Python data analytics. Free code + GitHub repo… Continue reading on

Dev.to · Prithvi S
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Apache Iceberg: A Modern Data Architecture for Scalable Analytics
Explore Apache Iceberg metadata hierarchy, schema evolution, hidden partitioning, and concurrency model.

Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Death of the “Quick SQL” Ticket: Why Genie + Teams is a Data Engineer’s Best Friend
How combining Databricks AI/BI Genie with Microsoft Teams transforms data teams from reactive report pullers into scalable semantic… Continue reading on Medium

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
My Data Science Internship Journey at Oasis Infobyte (OIBSIP)
Learning Through Experience Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Apache SeaTunnel Monthly Engineering Digest (May 2026): 87 PRs, Stronger Connectors, Smarter…
Hello SeaTunnel community! Continue reading on Medium »

Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
3w 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
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

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

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

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

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

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 »

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