Tech Skills

Data Analytics & Business Intelligence

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

16,723
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,258) Articles (2959)Blog Posts (3408)Tutorials (357)Research Papers (39)News (495)
TYPES OF JOINS
Dev.to · Jedidah Ondiso 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
TYPES OF JOINS
In Power BI, joins are primarily used in Power Query (during the "Merge Queries" step) to combine...
Data Governance: Listen First. Lead Second
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Governance: Listen First. Lead Second
Data Governance, Unfiltered. | Part 5 of 7 Continue reading on Data Governance, Unfiltered »
Why Most Enterprise AI Projects Never Get Past the Pilot Stage
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Most Enterprise AI Projects Never Get Past the Pilot Stage
Enterprise AI keeps stalling at the pilot stage because the underlying data can't be trusted. AI doesn't create organizational problems but it exposes the ones
The Numbers Say I’m Winning.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Numbers Say I’m Winning.
My Duolingo streak is still alive. Continue reading on Medium »
Data Governance: Keep it Simple
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Governance: Keep it Simple
Data Governance, Unfiltered. | Part 4 of 7 Continue reading on Data Governance, Unfiltered »
I Went Looking for Proof That NASA Faked the Moon Landing. I Found the Opposite.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Went Looking for Proof That NASA Faked the Moon Landing. I Found the Opposite.
Few events in modern history have generated as much skepticism as the Apollo Moon landings. Continue reading on Medium »
Buscando o primeiro emprego na área de TI.
Dev.to · VICTAL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Buscando o primeiro emprego na área de TI.
Estou procurando minha primeira oportunidade na área de TI, eu sou Analista de Dados Júnior, minha...
The Ultimate Guide to Science and Math/CS YouTubers
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Ultimate Guide to Science and Math/CS YouTubers
This list is years in the making. All of these channels will help change the way you think. The lowest tier is A! Continue reading on Medium »
What Three Years of AQI Data Reveals About India’s Air Quality
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What Three Years of AQI Data Reveals About India’s Air Quality
How seasons, regions, and pollutants shaped air quality across 291 Indian cities from 2022 to 2025 Continue reading on The Quantastic Journal »
Your Neighbor’s Wildfire Risk Is Your Wildfire Risk: What Spatial Statistics Reveals That…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Your Neighbor’s Wildfire Risk Is Your Wildfire Risk: What Spatial Statistics Reveals That…
In October 2020, the East Troublesome Fire tore through Grand County, Colorado. Continue reading on Medium »
Cohort Retention Analysis in Excel - Without SQL
Dev.to · Waqas R 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Cohort Retention Analysis in Excel - Without SQL
If you want to know whether customers actually stick around, a cohort retention table is the clearest...
Building an Awesome Portfolio Management App in Streamlit from Scratch
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building an Awesome Portfolio Management App in Streamlit from Scratch
A comprehensive step-by-step guide to building a Bloomberg-style multi-asset portfolio management terminal from scratch, featuring… Continue reading on Medium »
Os bastidores dos Dados: Minha jornada de transição e os projetos
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Os bastidores dos Dados: Minha jornada de transição e os projetos
Como o programa Ativa sua Carreira e o Módulo de Dados e IA da Laboratoria potencializaram meu olhar estratégico, unindo tecnologia… Continue reading on Medium
🚀 Top Data Analytics Project Ideas for Beginners and Professionals
Dev.to · Sapana Pal 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
🚀 Top Data Analytics Project Ideas for Beginners and Professionals
If you're learning Data Analytics and looking to build a strong portfolio, working on real-world...
Day 30 of 100 Days of ClickHouse® - Using ClickHouse® Arrays for Complex Data Structures
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 30 of 100 Days of ClickHouse® - Using ClickHouse® Arrays for Complex Data Structures
Introduction Modern analytical workloads often involve working with multi-valued and...
Snowflake vs Databricks, BigQuery vs Redshift? The 2026 Guide to Right-Sizing Your Data Platform
Dev.to · Aditya Somani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Snowflake vs Databricks, BigQuery vs Redshift? The 2026 Guide to Right-Sizing Your Data Platform
TL;DR Big data platforms like Snowflake and BigQuery impose high pricing floors, like...
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
When Address Data Breaks Bad: How We Matched and Fixed 100,000 Messy Records Without Losing Our…
A practical walkthrough of three matching approaches, a 30-character field limit nightmare, and the street-first strategy that actually… Continue reading on Med
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Encoding Categorical Data for Outlier Detection
Why one-hot encoding isn’t always the best approach, and alternative encodings The post Encoding Categorical Data for Outlier Detection appeared first on Toward
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
When Logic Ends, Humans Begin
SQL queries are supposed to be logical, predictable, and clean. Humans are none of those things. Continue reading on Medium »
How Uber Built Its Big Data System — From a Few TBs to 350 Petabytes with Sub-Hour Latency
Dev.to · Lê Đình Phú 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Uber Built Its Big Data System — From a Few TBs to 350 Petabytes with Sub-Hour Latency
A deep-dive into Uber's three architectural generations — from a Vertica warehouse to a Hadoop data lake, to Apache Hudi — and the engineering decisions behind
InfoQ AI/ML 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Presentation: Challenging Google Analytics: Building a Scalable, Cost-Effective User Tracking Service
Alina Krasavina explains how Delivery Hero successfully deprecated Google Analytics and migrated to an internal user tracking platform. She discusses how a simp
Stop Funding History: Building a Demand Prediction App to Optimize Trade Spend
Dev.to · Malawige Inusha Thathsara Gunasekara 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stop Funding History: Building a Demand Prediction App to Optimize Trade Spend
Let’s be honest: in the FMCG (Fast-Moving Consumer Goods) space, trade marketing budgets are almost...
What Nobody Tells Beginners About Learning Web Scraping
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What Nobody Tells Beginners About Learning Web Scraping
It’s not about the code. It’s about the quiet war with your own frustration. Continue reading on Medium »
By the Numbers: The Fascinating Data Behind 100 Million Nebility Customers
Dev.to · ersajay 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
By the Numbers: The Fascinating Data Behind 100 Million Nebility Customers
Behind every great brand is a story. But behind every great global brand is data — millions of data...
Why Statistics is the Invisible Backbone of Data Science
Dev.to · Venus-Kennedy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Statistics is the Invisible Backbone of Data Science
INTRODUCTION In the hype-fueled world of tech, data science is often painted as a futuristic...
Reddit r/Entrepreneur 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Got laid off 33 days ago. Here's everything I've built since.
Mined Google reviews of trades businesses. ended up finding found specific markets/ cities with genuine labor shortages Scraped conference booth buyers and noti
​The AI Wave: Why The Real Question Is Value
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
​The AI Wave: Why The Real Question Is Value
Most operators already have more data than their teams can realistically process.
Van HTML-tabel naar SQL INSERT Statements in Eén Klik
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Van HTML-tabel naar SQL INSERT Statements in Eén Klik
Je hebt data op een website gevonden. Je hebt het in je database nodig. De workflow is meestal:...
From Dashboards To Decisions: Why Enterprises Need An Answer Layer
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Dashboards To Decisions: Why Enterprises Need An Answer Layer
Every week you delay is a week your competitors may be moving from observation to action while you're still debating what the chart means.
17 million Polymarket price snapshots, collected on one Mac for $0/month
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
17 million Polymarket price snapshots, collected on one Mac for $0/month
Most prediction-market datasets you find online are a one-time dump someone scraped, posted, and...
Web Scraping with APIs: A Complete Tutorial with Real Examples
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Web Scraping with APIs: A Complete Tutorial with Real Examples
A Hands-On Python Guide to Extracting Clean Data Efficiently Continue reading on Data Engineer Things »
The Month-End Close is Broken: How Modern Accountants Are Automating Financial Document Extraction
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Month-End Close is Broken: How Modern Accountants Are Automating Financial Document Extraction
Why Are Highly Trained CPAs Still Doing Manual Data Entry? Continue reading on Medium »
What Topics Are Covered in Statistics for Data Science?-IABAC
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What Topics Are Covered in Statistics for Data Science?-IABAC
Statistics is one of the most important parts of Data science. Many learners start with excitement. They think about charts, predictions… Continue reading on Me
How Understanding Probability Distributions Made Me Better at Data Analysis
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Understanding Probability Distributions Made Me Better at Data Analysis
The Hidden Skill Behind Every Good Data Decision Continue reading on Artificial Intelligence in Plain English »
Connect Excel to a Database with Tens of Millions of Rows?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Connect Excel to a Database with Tens of Millions of Rows?
How do you connect Excel to a databases with tens of millions of rows.. and GBs of data? Continue reading on Medium »
Can a Customer Loyalty Model Predict Which Students Will Drop Out?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Can a Customer Loyalty Model Predict Which Students Will Drop Out?
What happened when we borrowed a 1987 marketing model to find at-risk university students before they failed. Continue reading on Medium »
Du Tableau HTML aux Instructions SQL INSERT en Un Clic
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Du Tableau HTML aux Instructions SQL INSERT en Un Clic
Vous avez trouvé des données sur un site web. Vous en avez besoin dans votre base de données. Le...
Data Modeling, Joins, Relationships and Schemas
Dev.to · Lameck Odhiambo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Modeling, Joins, Relationships and Schemas
Before data reaches its final used destination it needs to be organized in a structured way to enable...
Host Nation Advantage: Do USA, Canada, and Mexico Get a Statistical Boost?
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Host Nation Advantage: Do USA, Canada, and Mexico Get a Statistical Boost?
Here's a stat that'll surprise you: since 1930, host nations win the World Cup 26% of the time—nearly...
Distributions and Their Impact on Data Science
Dev.to · Samuel Mwai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Distributions and Their Impact on Data Science
Introduction Data science is built on the ability to extract meaningful insights from...
Python for Data Science — Boxplots and Outlier Detection
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Boxplots and Outlier Detection
In the previous article, we used scatter plots to explore relationships between variables. Continue reading on Medium »
Python for Data Science — Scatter Plots and Relationships Between Variables
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Scatter Plots and Relationships Between Variables
In the previous article, we learned about three fundamental chart types: Continue reading on Medium »
Python for Data Science — Scatter Plots and Relationships Between Variables
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Scatter Plots and Relationships Between Variables
In the previous article, we learned about three fundamental chart types: Continue reading on Medium »
Python for Data Science — Scatter Plots and Relationships Between Variables
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Scatter Plots and Relationships Between Variables
In the previous article, we learned about three fundamental chart types: Continue reading on Medium »
Scraping Websites With Python: The Ultimate Beginner’s Introduction
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Scraping Websites With Python: The Ultimate Beginner’s Introduction
You want data from a website. There’s no download button, no API, no CSV export, just a wall of HTML. This is exactly the problem that… Continue reading on Medi
Stop Nesting: How to Optimize Your Data Mapping Performance
Dev.to · Jehadur Rahman (Emran) 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stop Nesting: How to Optimize Your Data Mapping Performance
Why You Should Stop Using Nested Loops for Data Mapping Nested loops are a common pitfall in software...
Are You Looking for a Career Switch into Analytics?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Are You Looking for a Career Switch into Analytics?
In today’s data-driven world, businesses rely on data to make smarter decisions, improve customer experiences, and drive growth. As a… Continue reading on Mediu
Why Your Brain Hates Pie Charts (And What to Do About It)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Your Brain Hates Pie Charts (And What to Do About It)
The psychology of visual data, the problem with angles, and why the minimalist waffle chart is the elegant solution you’ve been looking… Continue reading on Med