Tech Skills

Data Analytics & Business Intelligence

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

17,205
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,730) Articles (3273)Blog Posts (3519)Tutorials (398)Research Papers (41)News (499)
Building Vietnam’s Football Data Platform
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Building Vietnam’s Football Data Platform
Keolive was founded with a simple objective: Continue reading on Medium »
PEARSON vs SPEARMAN: Two Ways to Ask “Are You Related?”
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
PEARSON vs SPEARMAN: Two Ways to Ask “Are You Related?”
Why the correlation coefficient you pick can quietly change the story your data tells Continue reading on Medium »
PEARSON vs SPEARMAN: Two Ways to Ask “Are You Related?”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
PEARSON vs SPEARMAN: Two Ways to Ask “Are You Related?”
Why the correlation coefficient you pick can quietly change the story your data tells Continue reading on Medium »
PEARSON vs SPEARMAN: Two Ways to Ask “Are You Related?”
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
PEARSON vs SPEARMAN: Two Ways to Ask “Are You Related?”
Why the correlation coefficient you pick can quietly change the story your data tells Continue reading on Medium »
The Abstract Said 84%. The Tables Said Something Else.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Abstract Said 84%. The Tables Said Something Else.
What I found reading a quantum machine learning paper closely, and why it matters for the field. Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Silent Data Quality Crisis Hiding in Your Pipeline
Your data pipeline passed last night. Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Day 7 of My Data Science Journey: Exploring Pandas Basics
Day 7 was about learning Pandas, the most popular Python library for handling tabular data Continue reading on Medium »
Database Industry Trends and Technical Observations
Dev.to · Michael 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Database Industry Trends and Technical Observations
Database Industry Trends and Technical Observations Overview In a recent GBASE...
The Sharpe Ratio: The Metric That Runs the Investment Industry
Medium · Startup 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Sharpe Ratio: The Metric That Runs the Investment Industry
Most investors have heard of the Sharpe ratio. Fewer realize how much weight it actually carries behind the scenes, from how pension funds… Continue reading on
Google's TabFM Is the First Tabular AI Launch I'd Actually Put Next to SQL
Dev.to · komo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Google's TabFM Is the First Tabular AI Launch I'd Actually Put Next to SQL
Most AI launches try to make language models look useful for everything. Google's TabFM goes after...
Our Model Called 13 of 16 Round of 32 Winners. Here’s Who It Likes in the Round of 16
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Our Model Called 13 of 16 Round of 32 Winners. Here’s Who It Likes in the Round of 16
Before a ball was kicked in the knockout stage, our ELO + form + pedigree model put a number on all 16 Round of 32 matchups. It got 13… Continue reading on Data
A/B Testing: Understanding and Calculating Lift Rate in the AI Era.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
A/B Testing: Understanding and Calculating Lift Rate in the AI Era.
When running A/B tests, one of the most important concepts you’ll come across in two-tailed hypothesis testing is lift rate. Continue reading on Medium »
Reddit r/programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
What ORMs have taught me: just learn SQL
submitted by /u/Either_Collection349 [link] [comments]
Day 60: ClickHouse® Query Profiling – Finding Performance Bottlenecks
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Day 60: ClickHouse® Query Profiling – Finding Performance Bottlenecks
When a query becomes slow, the first instinct is often to add more CPU or increase memory. In...
Let's Talk Relationships and Joins
Dev.to · gikonyo-v 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Let's Talk Relationships and Joins
Here's something nobody tells you when you start Power BI: the visuals are the easy part. You can...
A 15-Year Breakout That Never Looked Back
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
A 15-Year Breakout That Never Looked Back
Testing Donchian Channels on AAPL Continue reading on Medium »
Fact or Dimension? The All-in-One Guide to Reading a Data Model (and Nailing the Interview)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Fact or Dimension? The All-in-One Guide to Reading a Data Model (and Nailing the Interview)
A practical decision framework for identifying fact tables and dimension tables — plus exactly how to explain your reasoning when someone… Continue reading on M
Fact or Dimension? The All-in-One Guide to Reading a Data Model (and Nailing the Interview)
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Fact or Dimension? The All-in-One Guide to Reading a Data Model (and Nailing the Interview)
A practical decision framework for identifying fact tables and dimension tables — plus exactly how to explain your reasoning when someone… Continue reading on M
Building a Streaming Medallion: One Micro-Batch at a Time
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Building a Streaming Medallion: One Micro-Batch at a Time
Most Medallion tutorials quietly assume a batch world — a nightly job reads yesterday’s files and rebuilds a table. That model breaks the… Continue reading on M
Journal Figure Replication | Plotting a Nature-style Chord Diagram with Python
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Journal Figure Replication | Plotting a Nature-style Chord Diagram with Python
3D Ribbon Charta Continue reading on Top Python Libraries »
Journal Figure Replication | Plotting a Nature-style Chord Diagram with Python
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Journal Figure Replication | Plotting a Nature-style Chord Diagram with Python
3D Ribbon Charta Continue reading on Top Python Libraries »
Journal Figure Replication | Plotting a Nature-style Chord Diagram with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Journal Figure Replication | Plotting a Nature-style Chord Diagram with Python
3D Ribbon Charta Continue reading on Top Python Libraries »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Rethinking Stream Processing: Bringing It Inside PostgreSQL
Real-time data pipelines have become increasingly complex. A typical architecture involves an OLTP database, Change Data Capture (CDC), a… Continue reading on M
AI Didn’t Shrink the Analyst Job. It Deleted the Boring Half.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
AI Didn’t Shrink the Analyst Job. It Deleted the Boring Half.
A field guide to what’s actually changing for analysts in 2026 — and what still can’t be automated. Continue reading on Medium »
Introducing BondStats Assistant
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Introducing BondStats Assistant
A new way to explore finance on BondStats. Continue reading on Medium »
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
SQL Joins Explained with Real Examples (INNER, LEFT, RIGHT & FULL JOIN)
SQL Joins Explained with Real Examples Continue reading on Medium »
Seeing Is Believing: How to Visualize a Linear Regression Model in R
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Seeing Is Believing: How to Visualize a Linear Regression Model in R
If you’ve ever pasted the output of summary(lm(...)) into a Slack message or a slide deck, you know the problem: coefficients, standard… Continue reading on Med
Mastering SQL Subqueries: From Basics to Advanced Applications
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Mastering SQL Subqueries: From Basics to Advanced Applications
SQL (Structured Query Language) subqueries are a powerful way to retrieve and manipulate data from one query and use it within another… Continue reading on Medi
Transform Your Career with Data Science + GenAI
Institute of Data Science & Analytics (IDSA)…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Transform Your Career with Data Science + GenAI Institute of Data Science & Analytics (IDSA)…
 Course Highlights Comprehensive Curriculum: Covers Data Science, ML, AI, Python, SQL, Power BI, and GenAI tools. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
What AI Is Actually Doing to Entry-Level Data Jobs in 2026
The biggest disruption isn’t that AI is replacing junior analysts — it’s quietly changing what “entry level” even means. Continue reading on Medium »
Democracy’s Missing Voters
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Democracy’s Missing Voters
Abstention is often treated as apathy. The data tells a more serious story: democratic power is also shaped by the people who disappear… Continue reading on Med
InfoQ AI/ML 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
AWS Introduces Amazon S3 Annotations
AWS recently announced Amazon S3 Annotations, a feature that lets teams attach rich, searchable context such as summaries, classifications, compliance data, or
The ONLY Guide you NEED to connect SQL Databases to POWERBI
Dev.to · Lameck Odhiambo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
The ONLY Guide you NEED to connect SQL Databases to POWERBI
Introduction Integrating SQL databases with Power BI is one of the most effective and...
# Generating Sample Elon Musk Tweet Data Using Python for Practicing Fabric’s Medallion…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
# Generating Sample Elon Musk Tweet Data Using Python for Practicing Fabric’s Medallion…
**Subtitle:** A hands-on guide to simulating real-world Data Engineering scenarios — from Python data generation to Power BI Direct Lake… Continue reading on Me
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Looking at a spreadsheet containing hundreds of districts and dozens of demographic indicators rarely reveals meaningful patterns. Continue reading on Medium »
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Looking at a spreadsheet containing hundreds of districts and dozens of demographic indicators rarely reveals meaningful patterns. Continue reading on Medium »
Understanding axis=0 vs axis=1 in Pandas: A Visual Guide for Beginners
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Understanding axis=0 vs axis=1 in Pandas: A Visual Guide for Beginners
Everytime I used to see axis = 0 or axis = 1, I had to revise whole concept of rows and column. Continue reading on Medium »
Query one Apache Iceberg table from Trino, Spark, and DuckDB
Dev.to · Databasin AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Query one Apache Iceberg table from Trino, Spark, and DuckDB
Query one Apache Iceberg table from Trino, Spark, and DuckDB with the same snapshot model and honest trade-offs.
Unpacking the S&P 500 and Nasdaq: A Deep Dive into Index Performance
Dev.to · 네이쳐스테이 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Unpacking the S&P 500 and Nasdaq: A Deep Dive into Index Performance
Introduction The S&P 500 and Nasdaq are two of the most widely followed indices in the...
9 Must-Know SQL Queries for Data Analysts and Data Scientists
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
9 Must-Know SQL Queries for Data Analysts and Data Scientists
SQL (Structured Query Language) is a fundamental tool for data professionals like data analysts and data scientists. While basic SQL… Continue reading on Medium
​Behind the Screen: 2 Ways Data Science Silently Runs Your Day
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
​Behind the Screen: 2 Ways Data Science Silently Runs Your Day
​Every day, we interact with incredibly complex machine learning systems without even realizing it. From the moment we wake up to the… Continue reading on Mediu
AI in Data Integration
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
AI in Data Integration
Discover how AI data integration automates data mapping, improves quality, and speeds up real-time insights Continue reading on Medium »
Why I Left China as a Data Analyst
Dev.to · Jin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Why I Left China as a Data Analyst
Discover the challenges faced by a data analyst in China, from tech decoupling to AI barriers, and learn why the decision to leave was essential for career grow
10 SQL Techniques for Detecting Performance Bottlenecks Using Enterprise Logs
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
10 SQL Techniques for Detecting Performance Bottlenecks Using Enterprise Logs
Log analysis techniques that uncover hidden bottlenecks and optimize database performance at scale Continue reading on Medium »
Data Science Just Models
Dev.to · vanshika1807 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Data Science Just Models
From Confusion to Clarity: Understanding Data Science Techniques ...
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Scheduling strategies that optimize refresh efficiency for time-based aggregations and analytical workloads Continue reading on Medium »
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Scheduling strategies that optimize refresh efficiency for time-based aggregations and analytical workloads Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
The Math of Civilizational Asset-Stripping: A Regression Model of Oligarchic Myopia
When you look at the current geopolitical and economic landscape, it is easy to assume that the ruling class has simply lost its mind. Continue reading on Mediu