Tech Skills

Data Analytics & Business Intelligence

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

16,833
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,362) Articles (3027)Blog Posts (3428)Tutorials (372)Research Papers (39)News (496)
DARI DATA MENJADI PENERIMAAN NEGARA: Integrasi Big Data Nasional sebagai Strategi Perluasan Basis…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
DARI DATA MENJADI PENERIMAAN NEGARA: Integrasi Big Data Nasional sebagai Strategi Perluasan Basis…
Ketika perang dagang Amerika Serikat dan Tiongkok kembali memanas pada awal 2025, gelombang kejutnya terasa hingga ke negara-negara… Continue reading on Medium
Easily Remove Duplicate Records Using Power Query(.pbix included)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Easily Remove Duplicate Records Using Power Query(.pbix included)
When working with large datasets, duplicate records can quickly become a headache. They inflate file sizes, distort analysis, and lead to… Continue reading on M
Easily Remove Duplicate Records Using Power Query(.pbix included)
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Easily Remove Duplicate Records Using Power Query(.pbix included)
When working with large datasets, duplicate records can quickly become a headache. They inflate file sizes, distort analysis, and lead to… Continue reading on M
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
You Want to Study Rare Disasters, but They Almost Never Happen.
You need to know how often a rare catastrophe strikes, but it is so rare you would wait a lifetime to see enough of them. Continue reading on Medium »
DuckDB Isn’t Just Fast. It Changes How You Think About Data.
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
DuckDB Isn’t Just Fast. It Changes How You Think About Data.
Stop building data pipelines around databases. Start bringing the database to your data. Continue reading on Medium »
Building an End-to-End Geospatial Data Pipeline with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building an End-to-End Geospatial Data Pipeline with Python
From Raw CSV Files to an Analysis-Ready Map Dataset Continue reading on iTech Publication »
ArXiv cs.AI 📊 Data Analytics & Business Intelligence 📄 Paper ⚡ AI Lesson 1w ago
The Remittance Blueprint: Data-driven Intelligence for Sri Lanka
arXiv:2606.28190v1 Announce Type: cross Abstract: This study analyzes Sri Lankan migration and remittances over 32 years (1994-2025). Using a 384-month harmoniz
Reddit r/MachineLearning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Double-Blind submission in single-blind tracks [D]
Hi everyone. First-time reviewer for data mining venues here. For the applied tracks in ICDM and KDD, the CFP states submissions should be single-blind, showing
I timed stair carries on my commute ? the spreadsheet column mobility apps skip
Dev.to · Kingsong 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I timed stair carries on my commute ? the spreadsheet column mobility apps skip
I log commutes in a spreadsheet because mobility apps smooth over the ugly legs. Last week I added a...
Your p-value answered a question you didn't ask.
Dev.to · Vinicius Fagundes 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Your p-value answered a question you didn't ask.
You ran the A/B test. It came back p = 0.08. "Not significant." So you killed the feature and moved...
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Skill AI untuk Analisis Data yang Mulai Banyak Dicari Perusahaan
Pemanfaatan Artificial Intelligence (AI) dalam dunia kerja terus meningkat, termasuk untuk kebutuhan analisis data. Continue reading on Medium »
Quick Overview of Relationship Schemas and Joins
Dev.to · Felix Nyabwonda 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Quick Overview of Relationship Schemas and Joins
Introduction BI analysts are tasked with answering business questions for their clients....
The Mental Health Crisis Nobody Saw Coming From Climate Change
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Mental Health Crisis Nobody Saw Coming From Climate Change
Scientists say rising temperatures aren’t just changing the planet — they’re changing how millions of people think, feel, and plan their… Continue reading on Hi
The Gerrymander Archipelago
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Gerrymander Archipelago
I applied the same math US courts use to detect gerrymandering to the Aegean and Ionian. The results are alarming. The culprit has been… Continue reading on Med
Important Rules of Time Series Forecasting in Python
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Important Rules of Time Series Forecasting in Python
Forecasting is one of the most common tasks in applied data science, but it is also one of the easiest to misunderstand. In my experience… Continue reading on D
Important Rules of Time Series Forecasting in Python
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Important Rules of Time Series Forecasting in Python
Forecasting is one of the most common tasks in applied data science, but it is also one of the easiest to misunderstand. In my experience… Continue reading on D
Important Rules of Time Series Forecasting in Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Important Rules of Time Series Forecasting in Python
Forecasting is one of the most common tasks in applied data science, but it is also one of the easiest to misunderstand. In my experience… Continue reading on D
DuckDB-Iceberg v1.5.3, PostgreSQL Hash Join Tuning, & Relational Algebra to SQL
Dev.to · soy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
DuckDB-Iceberg v1.5.3, PostgreSQL Hash Join Tuning, & Relational Algebra to SQL
DuckDB-Iceberg v1.5.3, PostgreSQL Hash Join Tuning, & Relational Algebra to SQL ...
Only 14% of tech job postings actually tell you the salary. I measured it.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Only 14% of tech job postings actually tell you the salary. I measured it.
I run a thing that snapshots every open role on a few thousand companies’ own Greenhouse, Lever, and Ashby boards once a day — about… Continue reading on Medium
Only 14% of tech job postings actually tell you the salary. I measured it.
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Only 14% of tech job postings actually tell you the salary. I measured it.
I run a thing that snapshots every open role on a few thousand companies’ own Greenhouse, Lever, and Ashby boards once a day — about… Continue reading on Medium
The Geography of E-Commerce, Part II: Payment Culture, Seller Dynamics, and Olist’s Growth Story
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Geography of E-Commerce, Part II: Payment Culture, Seller Dynamics, and Olist’s Growth Story
This is the second part of a two-part analysis of the Olist Brazilian e-commerce dataset. Continue reading on Medium »
The Geography of E-Commerce: A SQL Analysis of Brazil’s Olist Marketplace
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Geography of E-Commerce: A SQL Analysis of Brazil’s Olist Marketplace
A SQL-based correlation analysis of regional delivery performance, seller density, and customer satisfaction on Brazil’s largest… Continue reading on Medium »
Data Analysis SQL: Asking the right questions and using the right tools
Dev.to · Luis Monasterios 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Analysis SQL: Asking the right questions and using the right tools
If you've ever practiced SQL interview questions, you have almost certainly crossed paths with this...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Built a Model to Forecast the World Cup. The Surprising Part Was How Little Actually Mattered.
I spent a few weeks building a system to forecast the 2026 World Cup. Going in, I had a long list of things I thought would make it… Continue reading on Medium
I Built a Dashboard in Under 12 Hours. Here Is How I Diagnosed a SaaS Platform’s Hidden Churn.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Built a Dashboard in Under 12 Hours. Here Is How I Diagnosed a SaaS Platform’s Hidden Churn.
Written By: Yogithasiri Chevva (Siri Chevva) | Published On: June 28, 2026 Continue reading on Medium »
I tried testing the pareto principle out — It's not always true!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I tried testing the pareto principle out — It's not always true!
This project started from a small annoyance, and led to really understanding the 80 20 rule. Continue reading on Medium »
Do Caos à Estrutura: Por que a Indexação no Pandas é um Game-Changer?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Do Caos à Estrutura: Por que a Indexação no Pandas é um Game-Changer?
Você já tentou encontrar uma informação específica em uma planilha gigante apenas “contando as linhas”? Se sim, você sabe o quão… Continue reading on Medium »
.loc vs .iloc: Qual a diferença?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
.loc vs .iloc: Qual a diferença?
Embora pareçam similares, usá-los de forma correta é o que separa um código robusto de um script cheio de erros silenciosos. Continue reading on Medium »
.loc vs .iloc: Qual a diferença?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
.loc vs .iloc: Qual a diferença?
Embora pareçam similares, usá-los de forma correta é o que separa um código robusto de um script cheio de erros silenciosos. Continue reading on Medium »
The Living City: Urban Pulse, Flow, and Breath
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Living City: Urban Pulse, Flow, and Breath
Exploring the hidden rhythms of urban life through geospatial data science, interactive visualization, and Python. Continue reading on Medium »
The Living City: Urban Pulse, Flow, and Breath
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Living City: Urban Pulse, Flow, and Breath
Exploring the hidden rhythms of urban life through geospatial data science, interactive visualization, and Python. Continue reading on Medium »
The Living City: Urban Pulse, Flow, and Breath
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Living City: Urban Pulse, Flow, and Breath
Exploring the hidden rhythms of urban life through geospatial data science, interactive visualization, and Python. Continue reading on Medium »
Reddit r/learnprogramming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
question about DS the stack
can you explain how the stack is connected to the backtracking algorithms(maze, file directories) and calling functions(call stack) everything inside () was giv
Building Medicaid Data Platforms That Scale Across States
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building Medicaid Data Platforms That Scale Across States
Multi-state Medicaid platforms become difficult to scale when state-specific business rules are embedded directly in application code. This article argues for c
Launch Your Data Science Career: How to Choose the Best Data Science Institute in Trivandrum
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Launch Your Data Science Career: How to Choose the Best Data Science Institute in Trivandrum
Data has become the driving force behind innovation in today’s digital world. From predicting customer behavior to improving healthcare… Continue reading on Med
Reddit r/learnprogramming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How can I build an automated system to gather date from a BMS app?
Hi, part of my job is to plot specific data from charging and discharging a battery via its BMS (battery management system) app periodically. It would make my l
Who is Montu Das? Building Clean Data Pipelines and Global SEO Authority
Medium · SEO 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Who is Montu Das? Building Clean Data Pipelines and Global SEO Authority
In today’s fast-paced digital marketplace, physical borders no longer limit your market reach. Continue reading on Medium »
Ad-Hoc Video Analytics with DuckDB on Parquet Exports from Production SQLite
Dev.to · ahmet gedik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Ad-Hoc Video Analytics with DuckDB on Parquet Exports from Production SQLite
Exporting trending-video metadata from production SQLite to hive-partitioned Parquet and running cro
Post 23: The History of Data — It’s Older Than You Think
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Post 23: The History of Data — It’s Older Than You Think
Data science feels like a modern buzzword — but humans have been collecting, analysing and learning from data for centuries. Continue reading on Medium »
What Drives the Nigerian Naira? Part 2
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What Drives the Nigerian Naira? Part 2
Python | pandas | statsmodels | scipy | yfinance | matplotlib | seaborn Jan 2024 — Jun 2026 | 30 monthly observations | 3 variables | 6… Continue reading on Med
People Analytics: Uma abordagem estatística para retenção de talentos e diminuição de Turnover…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
People Analytics: Uma abordagem estatística para retenção de talentos e diminuição de Turnover…
Tradicionalmente, as decisões relacionadas à gestão de pessoas têm sido tomadas com base na experiência dos gestores, na intuição, na… Continue reading on Mediu
Why Is Your Power BI Dashboard So Slow? 🐌
Dev.to · Bethuel Ngetich 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Is Your Power BI Dashboard So Slow? 🐌
Have you ever opened a dashboard and it took forever for it to load? Before blaming Power BI, take a...
Coefficient of Correlation and Coefficient of Determination
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Coefficient of Correlation and Coefficient of Determination
Continue reading on Medium »
How Long Does Food Last? The USDA Food Storage Guide (Made Searchable)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Long Does Food Last? The USDA Food Storage Guide (Made Searchable)
A faster, ad-free, and USDA-backed expiration calculator for every item in your kitchen. Continue reading on Medium »
How to Analyze Storefront Elements by Revenue Impact, Not Just CTR
Dev.to · Sylwester Kowal 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Analyze Storefront Elements by Revenue Impact, Not Just CTR
Most ecommerce teams can tell you where traffic comes from. Fewer teams can tell you which storefront...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Hypothesis Testing Is the Most Underrated Skill in Data Science.
A coffee shop, a new recipe, and the question every data scientist has to answer Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Understanding Relationship Schemas and Joins in Power BI
When I first started learning Power BI as part of my coursework in Data Science, Analytics, and AI, I thought the exciting part would be… Continue reading on Me
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Mapping audience engagement patterns: A quick EDA scanning public likers across 27 media posts
I recently wanted to see if I could answer a straightforward question: Can we effectively map out initial audience interaction and… Continue reading on Medium »