Tech Skills

Data Analytics & Business Intelligence

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

14,267
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 (4,805) Articles (2188)Blog Posts (2248)Tutorials (312)Research Papers (30)News (27)
Unlock the Future with Data Science + Gen AI!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Unlock the Future with Data Science + Gen AI!
Looking to master the most in‑demand skills of today? Join Lonestar Academy Janakpuri’s Data Science with Generative AI course and gain… Continue reading on Med
What Will It Cost America To Meet Data Center Electricity Demand?
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
What Will It Cost America To Meet Data Center Electricity Demand?
Meeting data center electricity demand with fossil fuels will add $30 billion to annual electricity costs. Clean energy will cost $5 billion less.
The AI Revolution That Won’t Fire Your Data Analysts
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
The AI Revolution That Won’t Fire Your Data Analysts
Photo by path digital on Unsplash Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Data Quality & dbt : Automatiser la gouvernance avec Python (Partie 2/5)
 Série : Data Quality Engineering à l’échelle . Partie 1 : Le Framework (De la théorie au code dbt) — lien ici . Partie 2 : L’Ingénierie… Continue reading on M
Airflow vs. Dagster (2026): Which Data Orchestrator Should Your Team Choose?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Airflow vs. Dagster (2026): Which Data Orchestrator Should Your Team Choose?
The ultimate Airflow vs. Dagster Comparison Continue reading on Medium »
Graph Databases: The Backbone of Connected Data and Intelligent AI
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Graph Databases: The Backbone of Connected Data and Intelligent AI
Every second, the world generates relationships — a customer buys a product, a device talks to another device, a transaction touches three… Continue reading on
Alteryx to Python Migration: I Built an Open-Source Package to Replace Alteryx
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Alteryx to Python Migration: I Built an Open-Source Package to Replace Alteryx
How PyTeryx lets you migrate from Alteryx Designer to Pandas without losing your mind Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Why One Regression Model Isn’t Enough: Understanding Geographically Weighted Regression (GWR)…
“One of The biggest mistake in spatial data analysis is assuming that every place behaves the same.” Continue reading on Medium »
Top 10 Databricks Use Cases Across Industries
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Top 10 Databricks Use Cases Across Industries
Most teams that adopt Databricks don’t do it for a feature. The databricks use cases that actually matter are the ones that fix a real… Continue reading on Medi
DARI DATA MENJADI PENERIMAAN NEGARA: Integrasi Big Data Nasional sebagai Strategi Perluasan Basis…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 2d 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 2d 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 2d 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 2d 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 »
The Mental Health Crisis Nobody Saw Coming From Climate Change
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d 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 2d 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 3d 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 3d 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 3d 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
Only 14% of tech job postings actually tell you the salary. I measured it.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d 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 3d 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 3d 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 »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d 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 3d 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 3d 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 3d 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 3d 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 3d 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 3d 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 3d 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 3d 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 »
Building Medicaid Data Platforms That Scale Across States
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d 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 3d 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
Who is Montu Das? Building Clean Data Pipelines and Global SEO Authority
Medium · SEO 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d 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 »
Post 23: The History of Data — It’s Older Than You Think
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d 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 3d 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 3d 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
Coefficient of Correlation and Coefficient of Determination
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d 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 3d 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 »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d 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 3d 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 3d 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 »
Meet appendToExcel: The Command-Line Tool You Didn't Know You Needed
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Meet appendToExcel: The Command-Line Tool You Didn't Know You Needed
appendToExcel is a command-line utility that writes CSV-formatted data into an Excel workbook (.xlsx). It can append data to the next… Continue reading on Mediu
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Data Science Course in Kerala — Build a Future-Ready Career with Zoople Technologies
In today’s digital era, data has become one of the most valuable assets for businesses across every industry. Continue reading on Medium »
I Ordered My Usual Food Again. But Was I Really Happy With That Choice?
Medium · UX Design 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
I Ordered My Usual Food Again. But Was I Really Happy With That Choice?
A completed order tells the business what I bought. It doesn’t always explain why I bought it. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Data Science Course in Kochi — Build a Successful Career with Zoople Technologies
The demand for data-driven professionals is growing rapidly across every industry. Organizations today rely on data to make informed… Continue reading on Medium
10 Excel Functions Every Data Analyst Should Know
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
10 Excel Functions Every Data Analyst Should Know
Excel remains one of the most important tools in data analytics. Even with advanced tools like Power BI and SQL, Excel continues to play a… Continue reading on
From Hunch to Backtest
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
From Hunch to Backtest
Understanding a trick isn’t the same as having it. This is the story of how we turned an intuition into a written strategy, ran it against… Continue reading on