Tech Skills

Data Analytics & Business Intelligence

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

16,836
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,365) Articles (3030)Blog Posts (3428)Tutorials (372)Research Papers (39)News (496)
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
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
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 »
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 »
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
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 »
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
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 »
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 »
Meet appendToExcel: The Command-Line Tool You Didn't Know You Needed
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w 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 1w 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 1w 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 1w 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 1w 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 1w 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
Finding Breakout Stocks Across Daily, Weekly & Monthly — And Ranking the Best (Part 4)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Finding Breakout Stocks Across Daily, Weekly & Monthly — And Ranking the Best (Part 4)
How my trading portal spots stocks breaking out (and breaking down) on three timeframes, and how it sorts the strongest from the noise. Continue reading on Medi
Data Cleaning and Translation Hell: The 2,000-Recipe Disaster: Why Data Cleaning is the Ultimate AI…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Cleaning and Translation Hell: The 2,000-Recipe Disaster: Why Data Cleaning is the Ultimate AI…
I thought AI coding would make building my app a breeze. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
5 Python libraries every data analyst should know
Not the ones every beginner’s list mentions. The ones that actually show up in real analysis work — with the one-liner that makes each… Continue reading on Medi
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
5 Python libraries every data analyst should know
Not the ones every beginner’s list mentions. The ones that actually show up in real analysis work — with the one-liner that makes each… Continue reading on Medi
−10°C Means Nothing to Your Dog
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
−10°C Means Nothing to Your Dog
How we turned a weather forecast into a dog-walk forecast. Continue reading on Medium »
The Instrument, the Wu-Hausman Test, and the Wardrobe
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Instrument, the Wu-Hausman Test, and the Wardrobe
How to build the perfect instrument, run the perfect test, and end up exactly where you started Continue reading on Medium »
Kafka Connect: Setting up and what the Docs skip
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Kafka Connect: Setting up and what the Docs skip
The Three Kafka Topics Running Your Connect Cluster and Why You Should Create Them Yourself Continue reading on Towards Data Engineering »
Smart Enough to Be Wrong Forever
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Smart Enough to Be Wrong Forever
Intelligence doesn’t guarantee better choices—it often makes better excuses Continue reading on The Quantastic Journal »
Advanced Exploratory Data Analysis (EDA) with Plotly, Streamlit and OpenAI
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Advanced Exploratory Data Analysis (EDA) with Plotly, Streamlit and OpenAI
Create dynamic charts that allow deeper exploration and interpretability of the data using the combination of Pandas, Plotly and OpenAI Continue reading on TDS
Power BI vs Tableau: Which Is Better in 2026?Power BI vs Tableau: Which Is Better in 2026?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Power BI vs Tableau: Which Is Better in 2026?Power BI vs Tableau: Which Is Better in 2026?
Power BI and Tableau are two of the most widely used business intelligence tools in 2026, and both are excellent for turning raw data into… Continue reading on
Which Is the Best Data Analytics Course in Delhi for Beginners?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Which Is the Best Data Analytics Course in Delhi for Beginners?
In today’s technology-driven world, data has become one of the most valuable assets for every business. Whether it’s a website, mobile… Continue reading on Medi
Data Science Institute in Delhi: Your Gateway to a Successful Career in Data Science
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Science Institute in Delhi: Your Gateway to a Successful Career in Data Science
Data Science Institute in Delhi: Your Gateway to a Successful Career in Data Science Continue reading on Medium »
Data Analytics Course in Pitampura | DICS Innovatives
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Analytics Course in Pitampura | DICS Innovatives
Join Data Analytics Course in Pitampura at DICS Innovatives. Learn Excel, SQL, Power BI, Python, and Tableau with expert trainers and… Continue reading on Mediu
I built an open-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, SQLite and 12+ more databases like DuckDB, ClickHouse, Redis and Firestore.
Reddit r/webdev 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I built an open-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, SQLite and 12+ more databases like DuckDB, ClickHouse, Redis and Firestore.
<img src="https://preview.redd.it/c8585fwl8s9h1.gif?width=640&crop=smart&s=269281d2ae98def515007318977d2947ca629910" alt="I built an open-source desktop