Tech Skills

Data Analytics & Business Intelligence

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

16,809
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,341) Articles (3015)Blog Posts (3422)Tutorials (369)Research Papers (39)News (496)
“Proper Principles Provide Practical Practice & Proficiency”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
“Proper Principles Provide Practical Practice & Proficiency”
5-P’s Without Needing To Harm Anyone Continue reading on Medium »
10 SQL Techniques for Reducing Unnecessary Full Table Scans and Query Execution Time
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
10 SQL Techniques for Reducing Unnecessary Full Table Scans and Query Execution Time
Optimizer-focused strategies that eliminate costly scans, improve index usage, and dramatically reduce query latency at scale Continue reading on Medium »
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
What is the biggest challenge you face in data science projects?
Is it data quality, stakeholder expectations, model deployment, business understanding, or something else? submitted by /u/Effective_Ocelot_445 [link] <a href="
Project Silica and the 10,000-Year Question: How We're Preserving Humanity's Data
Dev.to · Autonix Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Project Silica and the 10,000-Year Question: How We're Preserving Humanity's Data
Here is an uncomfortable fact about the digital age: it may leave behind less durable evidence of...
Claude Code Hooks: When CLAUDE.md Stops Being Enough
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Claude Code Hooks: When CLAUDE.md Stops Being Enough
It doesn’t take long for a .claude/CLAUDE.md to grow unwieldy. Continue reading on Data Science Collective »
Import JSON from an API in Google Sheets
Dev.to · bulldo.gs 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Import JSON from an API in Google Sheets
How to fetch JSON from any REST API in Google Sheets using Apps Script — parse the response, map objects to rows, and write a rectangular 2D array wit
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Exploring the Cosmos: A Guide to NASA's Eyes on Exoplanets Tutorial
Exploring the Cosmos: A Guide to NASA's Eyes on Exoplanets Tutorial As we continue to push the boundaries of space exploration, the search for exoplanets has be
External Validity Threats: Why Your A/B Test Results Might Not Generalize
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
External Validity Threats: Why Your A/B Test Results Might Not Generalize
Discover the external validity threats that can invalidate your A/B test results, from seasonality and sample pollution to the flicker… Continue reading on Medi
Goal Analytics, Fully Built: Data Pipeline, Six Models, and a Real Backtest
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Goal Analytics, Fully Built: Data Pipeline, Six Models, and a Real Backtest
Module 1 is done. Here’s everything that’s actually in the system now, how it’s validated, and what’s next. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
The Golden Ball Deserves a Formula: A Data-Driven Take on Football’s Most Debated Award
By Sunday Ikpe and Femi Akinmade Continue reading on Medium »
Spark Joy: How I Cut 100M Record Processing from 4.5 Minutes to 76 Seconds
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Spark Joy: How I Cut 100M Record Processing from 4.5 Minutes to 76 Seconds
My first professional love was data. Anything to do with data. I found it so interesting that everything in any system ever boiled down to… Continue reading on
Creating a Power BI Dashboard for Nigerian Retail Sales Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Creating a Power BI Dashboard for Nigerian Retail Sales Analysis
This project is based on a Nigerian Retail Sales dataset that contains a large amount of raw data, which on its own does not tell a clear… Continue reading on M
So, You Need a Data Management and Sharing Plan..
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
So, You Need a Data Management and Sharing Plan..
The NIH continues to tweek the requirements for the Data Management and Sharing Plan, here’s what it looks like in 2026 Continue reading on MetaScientific »
I've built a open source PDF-To-Excel-Converter
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...
Learning Progress Pt.32
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...
Creating a Power BI Dashboard for Nigerian Retail Sales Analysis
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 »
What Really Makes Cars Pollute? A Data Science Deep Dive into CO₂ Emissions
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
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
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
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
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
Building data-lens: What I Learned Shipping a Self-Hosted Data Explorer from Scratch
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
20% of Customers Generate 43% of Revenue. Here’s What the Data Says
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 »
Modelo de Stackelberg: Quando Quem Move Primeiro Vence
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 »
Databricks Connect: Run Spark Code from Your Local IDE on a Remote Cluster
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
Introducing PRISM: A New NBA Impact Metric
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 »
One wallet made 58.9% of Base's 167,725 gasless USDC payments in the last 19 hours
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,...
Optimizing Specific Power Consumption (kWh/T) in an Open Circuit Cement Ball Mill Using Data &…
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
Apache Iceberg: A Modern Data Architecture for Scalable Analytics
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.
The Death of the “Quick SQL” Ticket: Why Genie + Teams is a Data Engineer’s Best Friend
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
My Data Science Internship Journey at Oasis Infobyte (OIBSIP)
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 »
Apache SeaTunnel Monthly Engineering Digest (May 2026): 87 PRs, Stronger Connectors, Smarter…
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 »
Apache SeaTunnel Monthly Engineering Digest (May 2026): 87 PRs, Stronger Connectors, Smarter…
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 »
Building My First Power BI Dashboard for E-Commerce Sales Analysis
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 »
Why a Coin Toss Contains More Information Than a Sunrise
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 »
GBase 8a OLAP Window Functions in Practice: Ranking, Running Totals, MoM, and Ratio Analysis
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...
Day 14 of #100DaysOfClickHouse: Understanding Nodes, Shards, and Replicas
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...
Query Optimization and Indexing Strategies for Data Warehouses
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
US Unemployment Is 4.3%.
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
There Is No Modern Playbook for This.
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
Apache Pulsar vs Kafka for Data Engineering: Geo-Replication, Tiered Storage & Functions
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...
Kafka Connect Deep Dive: Source, Sink, SMTs, Schema Registry & Idempotent Writes
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
Data Engineering Pipeline: Understanding ETL vs ELT
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...
Federated Data Architectures: Accountability Without Authority
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
Federated Data Architectures: Why PMs Fail
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
Graph Clustering for Entity Resolution: Why Union-Find Breaks at Web Scale
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
Why Building Custom Monitoring Dashboards for ClickHouse® Becomes Challenging at Scale
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...
A free, keyless API for dynasty fantasy football values — built from 672k real trades
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