Tech Skills

Data Analytics & Business Intelligence

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

16,768
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,303) Articles (2989)Blog Posts (3416)Tutorials (363)Research Papers (39)News (496)
Quick Overview of Relationship Schemas and Joins
Dev.to · Felix Nyabwonda 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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 5d 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
A published win rate is the actor auditing itself
Dev.to · Mike Czerwinski 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
A published win rate is the actor auditing itself
Seven Telegram signal channels advertise 70 to 80 percent win rates. I ran a shadow-mode bot for two months and audited 17 months of their message history: 9,31
Apache Spark in Microsoft Fabric: How It Handles Big Data and Makes Your Life Easier
Dev.to · Anshul Jangale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Apache Spark in Microsoft Fabric: How It Handles Big Data and Makes Your Life Easier
If you've ever tried to process millions of rows of data in a regular tool like Excel or even a basic...
I Tracked My Body Fat for 90 Days and Built a Calculator That Actually Makes Sense
Dev.to · dayu2333-jinyul 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
I Tracked My Body Fat for 90 Days and Built a Calculator That Actually Makes Sense
For three months, I weighed myself every morning and took body measurements every Sunday. I used a...
Competitor Pricing Intelligence: SaaS + Shopify Combined
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Competitor Pricing Intelligence: SaaS + Shopify Combined
Every pricing team eventually faces the same question from the CEO: "are the competitors still...
The Other Side of the Content Pipeline
Dev.to · Robert Floyd Dugger 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
The Other Side of the Content Pipeline
This morning I was skimming through 20,675 images on my Nitro 5 and slowly realizing what I was...