Tech Skills

Data Analytics & Business Intelligence

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

16,860
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,388) Articles (3045)Blog Posts (3432)Tutorials (375)Research Papers (39)News (497)
Day 21 : Time-Series Data in ClickHouse®
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Day 21 : Time-Series Data in ClickHouse®
Time-series data is one of the most common types of data generated by modern applications. Every log...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
SQL Skills Every Data Analyst Should Learn in 2026
SQL (Structured Query Language) is one of the most important skills for Data Analysts. Almost every organization stores data in databases… Continue reading on M
SQL Queries Every SaaS Founder Should Know
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
SQL Queries Every SaaS Founder Should Know
Six essential SQL queries that give SaaS founders direct visibility into signups, active users, conversion, churn, MRR, and retention — no BI tool required.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Data Engineering in 2026: Building the Foundation for Smarter Decisions
Every digital interaction generates data. From website clicks and mobile app usage to online purchases and customer feedback… Continue reading on Medium »
Learn Data Science, AI & Machine Learning in Delhi
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Learn Data Science, AI & Machine Learning in Delhi
Wondering whether a Data Science Course in Delhi is worth it in 2026? This comprehensive guide explores the growing demand for Data… Continue reading on Medium
Day 20 of 100 Days of ClickHouse® - Introduction to Materialized Views
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Day 20 of 100 Days of ClickHouse® - Introduction to Materialized Views
One of the most common performance bottlenecks in analytics is running the same expensive...
Data Analytics Lifecycle Explained with Real Examples
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Data Analytics Lifecycle Explained with Real Examples
Data Analytics Lifecycle Explained: How Organizations Turn Raw Data Into Business Decisions Continue reading on Medium »
Users Don't Churn Overnight—Behavior Changes First
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Users Don't Churn Overnight—Behavior Changes First
For years, product teams have treated churn as an event. Continue reading on Medium »
Einblicke in den MxMH-Datensatz
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Einblicke in den MxMH-Datensatz
I hope this can help us beginners to have one more outlook on how to analyst a dataset Continue reading on Medium »
Turn Data Into Opportunity: Why Choosing a Data Science Course in Trivandrum Can Shape Your Future
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Turn Data Into Opportunity: Why Choosing a Data Science Course in Trivandrum Can Shape Your Future
The world is changing faster than ever, and one of the biggest forces driving this transformation is data. Every online search, digital… Continue reading on Med
Hire Smarter, Not Harder
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Hire Smarter, Not Harder
How XGBoost helped us predict offer acceptance — and what we learned building a tool HR actually uses Continue reading on Medium »
Model Forcasting Moving Average: Seni Merata-ratakan Masa Lalu untuk Melihat Masa Depan
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Model Forcasting Moving Average: Seni Merata-ratakan Masa Lalu untuk Melihat Masa Depan
Bagaimana kalau, alih-alih bertaruh pada satu titik, kita merata-ratakan beberapa titik terakhir? Itulah ide di balik Moving Average… Continue reading on Medium
Opportunity, Not Genius: What 120 Years of Nobel Prize Data Actually Tells Us
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Opportunity, Not Genius: What 120 Years of Nobel Prize Data Actually Tells Us
Since Alfred Nobel signed his famous will in 1895, the prizes bearing his name have become the most recognized markers of intellectual… Continue reading on Medi
Construction Site Supervisors Spend Too Much Time Rebuilding the Day
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Construction Site Supervisors Spend Too Much Time Rebuilding the Day
Construction projects generate hundreds of small events every day. Continue reading on Medium »
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
r/Jokes Subreddit Analysis
I was reading a joke on r/jokes that I have seen many times and in the comments you always see “good old #67” or some such. Which got me thinking, we gotta be a
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How to Fix Out-of-Order Data When Subscribing to Multiple Forex Pairs
When building real-time forex quote systems or quantitative trading programs, developers often subscribe to multiple currency pairs via a… Continue reading on M
How I Analyzed a Retail Sales Performance.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How I Analyzed a Retail Sales Performance.
My analysis on a Retail sales performance with SQL and Excel. Continue reading on Medium »
Reddit r/learnprogramming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Physical Note-taking
Does anyone have any advice, recommended resources, or structure for physical note-taking when learning multiple programming languages? For context, I’m MSc Dat
How to Improve Sensitivity in A/B Experiments
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How to Improve Sensitivity in A/B Experiments
Step-wise Guide to Covariate Adjustment Continue reading on Data Science Collective »
Animal Sex-Difference: Granger Causality Sharpens The Questions
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Animal Sex-Difference: Granger Causality Sharpens The Questions
In animal behavior in lab, we often ask a very simple question: Continue reading on Medium »
Why a Skellam Distribution Beats a Score Grid
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Why a Skellam Distribution Beats a Score Grid
The statistical backbone of a World Cup forecaster — and the calibration bug that hid inside a 5×5 matrix Continue reading on Medium »
Can NFL Running Backs Get Overworked?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Can NFL Running Backs Get Overworked?
Christian McCaffery’s 2019 season saw him explode for 1387 yards on 287 carries. Combined with passing game, he was catapulted to the top… Continue reading on M
# Why Breaking Things Apart Eventually Brings Them Together: Modulazition in ETL
Dev.to · Ibrahim0695 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
# Why Breaking Things Apart Eventually Brings Them Together: Modulazition in ETL
What does this big word really mean? The first week of data engineering at luxdev was...
Simon Willison's Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
datasette 1.0a34
Release: datasette 1.0a34 Quoting the release notes: The big feature in this alpha is tools to insert, edit and delete rows within the Datasette interface. Thes
Data Center Problem Might Be Solved?
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Data Center Problem Might Be Solved?
CPLE Lab Model Finds Roughly $27.2 Million That May Stay in the Company’s Pocket Continue reading on Medium »
Data Center Problem Might Be Solved?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Data Center Problem Might Be Solved?
CPLE Lab Model Finds Roughly $27.2 Million That May Stay in the Company’s Pocket Continue reading on Medium »
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Data Center Problem Might Be Solved?
CPLE Lab Model Finds Roughly $27.2 Million That May Stay in the Company’s Pocket Continue reading on Medium »
Your Sales Rep Made $14,000 Last Quarter. Can You Prove the Math?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Your Sales Rep Made $14,000 Last Quarter. Can You Prove the Math?
Nine reps disputed their payout. The reconciliation engine traced every single dispute to the same root cause: duplicate deal entries… Continue reading on Mediu
Building Analytics Infrastructure From Zero in a Resource-Constrained Organization
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Building Analytics Infrastructure From Zero in a Resource-Constrained Organization
“The most dangerous four words in analytics are: we track that somewhere.” Continue reading on Medium »
I Analysed 493 Nigerian Tweets About Temu vs Jumia. Here’s What the Data Actually Says.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
I Analysed 493 Nigerian Tweets About Temu vs Jumia. Here’s What the Data Actually Says.
A social listening analysis of how Temu went from a punchline to a genuine debate in Nigeria’s e-commerce conversation. Continue reading on Medium »
Dealer Gamma as a Volatility Dial: A Practical Overlay for Position Sizing
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Dealer Gamma as a Volatility Dial: A Practical Overlay for Position Sizing
How to compute dealer gamma exposure (GEX) yourself and use its one robust property — it predicts the size of the day, not its direction —… Continue reading on
My Journey Learning Excel for Data Analysis
Dev.to · PHILIP KAPLONG 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
My Journey Learning Excel for Data Analysis
When I first opened Excel, I saw rows and columns.......nothing more.Over the past two weeks ,I have...
Glove Store Web Analysis with SQL
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Glove Store Web Analysis with SQL
Background The project is for an e-commerce store. This project will use SQL tools to extract, update, and manipulate data to answer… Continue reading on Medium
Your data analyst is the smartest person in the room. So Why Is No One Listening to Them?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Your data analyst is the smartest person in the room. So Why Is No One Listening to Them?
The silence after every presentation is costing your business more than bad data ever could. Continue reading on Medium »
Discovering PII Inside InterSystems IRIS
Dev.to · InterSystems Developer 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Discovering PII Inside InterSystems IRIS
Data privacy regulations such as GDPR, LGPD, and HIPAA demand that organizations know exactly where...
The Chi-Square Test: How Statistics Decides If Two Things Are Really Connected
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
The Chi-Square Test: How Statistics Decides If Two Things Are Really Connected
You’ve probably made assumptions like this before: “I think the people who vote for Party A are mostly men” or “I bet that candy bag has… Continue reading on Me
The Chi-Square Test: How Statistics Decides If Two Things Are Really Connected
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
The Chi-Square Test: How Statistics Decides If Two Things Are Really Connected
You’ve probably made assumptions like this before: “I think the people who vote for Party A are mostly men” or “I bet that candy bag has… Continue reading on Me
Power BI vs. Tableau in 2026: What Indian Companies Are Actually Hiring For
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Power BI vs. Tableau in 2026: What Indian Companies Are Actually Hiring For
A junior analyst messaged me last month, genuinely stressed. Continue reading on Medium »
What Analyst Consensus Really Looks Like Beyond the Average
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
What Analyst Consensus Really Looks Like Beyond the Average
Two companies can have the same average estimate but completely different levels of agreement behind it Continue reading on AI Advances »
Databricks CEO Says He’s Cracked A 40-Year-Old Database Problem With LTAP
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Databricks CEO Says He’s Cracked A 40-Year-Old Database Problem With LTAP
At Data + AI Summit, Databricks CEO Ali Ghodsi unveiled LTAP, a new architecture that collapses the 40-year unification problem of OLTP and OLAP databases.
[Tutorial] Building an AI-Powered BI Tool on Upsun 🤖
Dev.to · Flora Brandão 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
[Tutorial] Building an AI-Powered BI Tool on Upsun 🤖
Querying ecommerce data often requires writing manual SQL queries or building complex dashboards....
I cleaned India's Census 2011 data so you never have to
Dev.to · Ansuman Jaiswal 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
I cleaned India's Census 2011 data so you never have to
Every Indian data scientist hits the same wall. You need district-level population data. You go to...
NHS Palantir claims face scrutiny after data suggests uneven results
The Register 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
NHS Palantir claims face scrutiny after data suggests uneven results
Campaign group says FOI figures show some trusts carried out fewer procedures than before
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
The Ghost in the Warehouse: Why You Keep Buying Things You Already Own
"Close Enough": The True Cost Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How to Evaluate Power BI Governance and Data Quality Consulting Partners in 2026
As organizations accelerate their digital transformation initiatives, Power BI has evolved from a dashboarding tool into a strategic… Continue reading on Medium
IIT Kanpur Launches Dedicated Department of Statistics and Data Science to Meet Rising AI Workforce…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
IIT Kanpur Launches Dedicated Department of Statistics and Data Science to Meet Rising AI Workforce…
As artificial intelligence, machine learning, and advanced analytics continue reshaping industries worldwide, higher education… Continue reading on Medium »
Veri Bilimi Yolculuğumda Python ile İlk Adımlar
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Veri Bilimi Yolculuğumda Python ile İlk Adımlar
Veri Bilimi İçin Python Programlamaya Başlarken Continue reading on Medium »
Veri Bilimi Yolculuğumda Python ile İlk Adımlar
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Veri Bilimi Yolculuğumda Python ile İlk Adımlar
Veri Bilimi İçin Python Programlamaya Başlarken Continue reading on Medium »