Tech Skills

Data Analytics & Business Intelligence

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

16,847
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,376) Articles (3038)Blog Posts (3429)Tutorials (373)Research Papers (39)News (497)
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
How will you handle missing data in a dataset?
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
Apache Spark: The Complete Deep Dive
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 »
I Built the Wrong Scraper First. The Data Looked Clean and Was Still Useless.
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
Your Scraper Returns 200 OK and Still Lies: 7 Marketplace Checks I Use
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
Demystifying Profitability: How Gross, Operating, and Net Margins Differ
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
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...