Tech Skills

Data Analytics & Business Intelligence

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

16,827
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,357) Articles (3025)Blog Posts (3427)Tutorials (370)Research Papers (39)News (496)
Segmentasi Pelanggan dan Prediksi Nilai Belanja pada Online Retail II Menggunakan K-Means dan…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Segmentasi Pelanggan dan Prediksi Nilai Belanja pada Online Retail II Menggunakan K-Means dan…
Pendahuluan Bisnis online retail hidup dari transaksi. Namun transaksi mentah belum otomatis memberi arah bisnis. Di dalam satu juta lebih… Continue reading on
My first SQL interaction
Dev.to · Mohammad Meezan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
My first SQL interaction
Today was my first day of learning SQL and my interaction with it was very unique its not like excel...
Web Scraping: What It Is, Why It Matters, and How to Use It Responsibly
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Web Scraping: What It Is, Why It Matters, and How to Use It Responsibly
A practical guide to web scraping: how it works, why businesses use it, where it becomes difficult, and how to approach it responsibly. Continue reading on Medi
Best Data Science Institute in South Delhi
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Best Data Science Institute in South Delhi
Start your Data Science career with an Advanced Data Science Course in South Delhi. Learn from industry experts, work on live projects… Continue reading on Medi
KPIs That Matter: Choosing Metrics That Drive Business Decisions
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
KPIs That Matter: Choosing Metrics That Drive Business Decisions
One of the biggest mistakes new data analysts make is assuming that every metric is equally important. Continue reading on Medium »
Build a Box Plot Calculator in Pure JavaScript — No Libraries Needed
Dev.to · TianYi Zhang 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Build a Box Plot Calculator in Pure JavaScript — No Libraries Needed
Build a Box Plot Calculator in Pure JavaScript — No Libraries Needed A box plot (or...
The 4th Down Revolution: Why NFL Teams Win 67% More Games When They Trust the Math [Jun 30]
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
The 4th Down Revolution: Why NFL Teams Win 67% More Games When They Trust the Math [Jun 30]
Most NFL head coaches would rather punt on 4th-and-2 from the opponent's 40-yard line than face a...
Understanding Parquet: The File Format Built for Analytics
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Understanding Parquet: The File Format Built for Analytics
A beginner-friendly explanation of columnar storage, compression, schemas, and why Parquet is widely used in modern data platforms. Continue reading on Stackade
TechCrunch AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Anthropic’s Claude Science bets on workflow, not a new model, to win over scientists
Anthropic's Claude Science is a workbench that gives scientists one environment to do computational research, saving them from the need to bounce between databa
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Veri analizi projelerinde çoğu zaman “ne oldu?” sorusuna cevap ararız. Continue reading on Medium »
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Veri analizi projelerinde çoğu zaman “ne oldu?” sorusuna cevap ararız. Continue reading on Medium »
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Müşteri Değerini Anlamak: RFM, CLTV ve Tahmine Dayalı CRM Analitiği
Veri analizi projelerinde çoğu zaman “ne oldu?” sorusuna cevap ararız. Continue reading on Medium »
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Surviving the Data Science Behavioral Interview
In the age of AI, standing out here means a lot more than ever. Here are three tips to walk into your next interview with confidence. The post Surviving the Dat
Mobile App Analytics in React Native — What to Track in 2026
Dev.to · Jules Sarah 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Mobile App Analytics in React Native — What to Track in 2026
The 12 metrics that actually matter, the React Native instrumentation realities, and the 4 failure modes that make your dashboards lie.
Reddit r/artificial 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Before I needed it, no one told me that "legacy tape management" was an entire industry.
We inherited roughly 6,000 LTO tapes from a business we bought last year. There was no documentation, no drives that could read half of them, multiple generatio
Looking for the Best Data Science Institute in South Delhi
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Looking for the Best Data Science Institute in South Delhi
Data Science is one of the fastest-growing career fields because today every business, from startups to large enterprises, generates a… Continue reading on Medi
Verinin Müşteriyle Buluştuğu Nokta: CRM Analitiği ve Müşteri Yaşam Boyu Değeri (Bölüm 1)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Verinin Müşteriyle Buluştuğu Nokta: CRM Analitiği ve Müşteri Yaşam Boyu Değeri (Bölüm 1)
Günümüz iş dünyasında en çok duyduğumuz cümlelerden biri şudur: “Yeni bir müşteri edinmek, var olan müşteriyi elde tutmaktan çok daha… Continue reading on Mediu
Construindo um Índice Estatístico para Prever o Campeão da Copa 2026
Dev.to · Lincoln Romais 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Construindo um Índice Estatístico para Prever o Campeão da Copa 2026
Como combinei dados reais da fase de grupos com histórico e ranking FIFA para ranquear os favoritos —...
Can Databricks LTAP Actually Run OLTP and OLAP at the Same Time?
Dev.to · Itay Waisman 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Can Databricks LTAP Actually Run OLTP and OLAP at the Same Time?
Databricks announced LTAP, Lake Transactional/Analytical Processing, at Data + AI Summit this week....
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Top 5 DBMS Concepts (2026) | Perfectnotes
Every single application you use — from Instagram to your online banking portal — runs on data. Continue reading on Medium »
n8n's Guardrails node masks your PII. It doesn't give it back. Here's why that matters.
Dev.to · Asil Ozyildirim 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
n8n's Guardrails node masks your PII. It doesn't give it back. Here's why that matters.
n8n shipped a native Guardrails node back in November. PII detection, jailbreak protection, content...
Python ve Rust’ın Gücüyle Gerçek Zamanlı Veri İşleme: Bytewax Nedir?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Python ve Rust’ın Gücüyle Gerçek Zamanlı Veri İşleme: Bytewax Nedir?
Veri mühendisliği tarafında gerçek zamanlı veri (streaming) işleme süreçleriyle uğraşırken genellikle Apache Spark Structured Streaming… Continue reading on Med
csvtidy: merge and clean CSV files from the terminal, with reusable recipes
Dev.to · Ab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
csvtidy: merge and clean CSV files from the terminal, with reusable recipes
Every month it's the same CSV exports. Same system, same columns, same handful of cleanup steps...
How We Helped an Auto Parts Plant Cut MES Query Times by Up to 116x
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
How We Helped an Auto Parts Plant Cut MES Query Times by Up to 116x
On a single automotive parts production line, PLCs write a new data point every few hundred milliseconds, with SCADA, test equipment, and… Continue reading on M
Every Dataset Has a Personality Disorder
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Every Dataset Has a Personality Disorder
Every dataset has a personality, and most of them have a disorder. Continue reading on Data Science Collective »
How we model the Golden Boot race across 30+ leagues
Dev.to · Furiosa Studio 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
How we model the Golden Boot race across 30+ leagues
"Top scorer of a league" sounds like one line of SQL: SELECT player, COUNT(*) FROM goals GROUP BY...
Day 49: Building Dashboards with ClickHouse® and Apache Superset
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Day 49: Building Dashboards with ClickHouse® and Apache Superset
Introduction A fast analytical database alone isn't enough to deliver insights....
Automating the RevOps Data Layer: How to Make CRM Actually Reflect Reality
Dev.to · SpurIQ Engineering 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Automating the RevOps Data Layer: How to Make CRM Actually Reflect Reality
45% of contacts never get logged. 17% of rep time goes to data entry. Here's the architecture that...
The Nervous System of the Telco: Unlocking the Real-Time Power of the Network Element Interfaces…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
The Nervous System of the Telco: Unlocking the Real-Time Power of the Network Element Interfaces…
Imagine a human body trying to survive when: Continue reading on Medium »
Enhanced RFM Analysis for Customer Segmentation using K-Prototypes
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Enhanced RFM Analysis for Customer Segmentation using K-Prototypes
In the previous article, we performed basic RFM Analysis using K-Means. However, customer behaviour is not limited to spending activity… Continue reading on Med
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
One Survey Asked Rich People Ten Times More Often Than Poor People.
You ran a survey, but it was lopsided: for every poor person you reached, you reached ten rich people. Continue reading on Medium »
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
A Practical Framework for Transforming Raw Data into Analysis-Ready Datasets Continue reading on Medium »
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
A Practical Framework for Transforming Raw Data into Analysis-Ready Datasets Continue reading on Medium »
Analysis on Customer Churn
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Analysis on Customer Churn
1. Business Problem Worth Solving Continue reading on Medium »
Bridging the Lab-Software Gap
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Bridging the Lab-Software Gap
What scientists need that engineers don’t understand Continue reading on Medium »
I Built an Open Healthcare Data Dictionary with 100k+ ISO-11179 Terms — Here's What I Learned
Dev.to · Season Mudbhary 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
I Built an Open Healthcare Data Dictionary with 100k+ ISO-11179 Terms — Here's What I Learned
If you've ever worked on a healthcare data team, you've lived this problem: one system calls it...
You’ve Been A Data Analyst Your Whole Life — You Just Didn’t Know It
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
You’ve Been A Data Analyst Your Whole Life — You Just Didn’t Know It
A beginner’s guide to one of the most in-demand skills of the decade — told through the decisions you already make every day. Continue reading on Medium »
When a KPI reads 163 billion instead of 819
Dev.to · Nasrul Hazim Bin Mohamad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
When a KPI reads 163 billion instead of 819
TL;DR A metrics engine had two query paths — a SQL push-down for big datasets, an...
Vanity Metrics vs. Actionable Metrics: A Framework for Knowing the Difference
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Vanity Metrics vs. Actionable Metrics: A Framework for Knowing the Difference
Why pageviews, followers, and time-on-page are seductive but misleading without context. A behavioral science framework for distinguishing… Continue reading on
Building an End-to-End Lakehouse on Databricks: Instacart Analytics from Pipeline to Insight
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building an End-to-End Lakehouse on Databricks: Instacart Analytics from Pipeline to Insight
In my previous article, I wrote about what two Databricks learning tracks reinforced about the modern data lifecycle — and why the… Continue reading on Medium »
Simon Willison's Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
HTML table extractor
Tool: HTML table extractor Yet another in my growing collection of paste-conversion tools. This one accepts pasted rich text from browsers (with embedded HTML t
Beyond the Credit Score: What 1.3 Million Loans Reveal About Who Actually Repays
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Beyond the Credit Score: What 1.3 Million Loans Reveal About Who Actually Repays
Three projects on real lending data, and what they say about a fairer, sharper way to decide who gets a loan. Continue reading on Medium »
Beyond the Credit Score: What 1.3 Million Loans Reveal About Who Actually Repays
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Beyond the Credit Score: What 1.3 Million Loans Reveal About Who Actually Repays
Three projects on real lending data, and what they say about a fairer, sharper way to decide who gets a loan. Continue reading on Medium »
Where Does the Crowd Excel? Polymarket Accuracy by Category
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Where Does the Crowd Excel? Polymarket Accuracy by Category
Not all predictions are created equal. Weather, politics, sports, and crypto operate under fundamentally different uncertainty regimes —… Continue reading on Me
How Microsoft Excel Quietly Breaks Your JSON Imports (And How to Fix It)
Dev.to · Atqiya Abida Anjum 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Microsoft Excel Quietly Breaks Your JSON Imports (And How to Fix It)
If you have ever built an application or pipeline that accepts CSV uploads, you have probably run...
Customer, Product, and Profitability Performance Analysis in Supply Chain Operations: A Case Study…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Customer, Product, and Profitability Performance Analysis in Supply Chain Operations: A Case Study…
Suhani Khanna Data Science Intern, Unified Mentor Department of Data Science and Analytics June 2026 Continue reading on Medium »
Customer, Product, and Profitability Performance Analysis in Supply Chain Operations: A Case Study…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Customer, Product, and Profitability Performance Analysis in Supply Chain Operations: A Case Study…
Suhani Khanna Data Science Intern, Unified Mentor Department of Data Science and Analytics June 2026 Continue reading on Medium »
I Didn’t Notice the Compounding Until the Last Day”
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Didn’t Notice the Compounding Until the Last Day”
Continuing from my last day, today I am writing about my further experiments added today and submitted on the leaderboard. To analyse, you… Continue reading on