Tech Skills
Data Analytics & Business Intelligence
Excel, SQL, Power BI, Tableau — turn raw data into business decisions
Skills in this topic
7 skills — Sign in to track your progress
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
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Analysed 56,000 Rows of Terrorism Data — Here’s What I Found (and Built)
A beginner data scientist’s journey from a messy CSV to a live interactive dashboard Continue reading on Medium »
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Analysed 56,000 Rows of Terrorism Data — Here’s What I Found (and Built)
A beginner data scientist’s journey from a messy CSV to a live interactive dashboard Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Analysed 56,000 Rows of Terrorism Data — Here’s What I Found (and Built)
A beginner data scientist’s journey from a messy CSV to a live interactive dashboard Continue reading on Medium »
Medium · Deep Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Iceoutmap People over papers| Live Map
People Over Papers collect data on ICE sightings submitted by the public with the intention to inform the public and raise awareness. The… Continue reading on M
Medium · UX Design
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Iceoutmap People over papers| Live Map
People Over Papers collect data on ICE sightings submitted by the public with the intention to inform the public and raise awareness. The… Continue reading on M
Dev.to · Kanishga Subramani
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Day 17 of #100DaysOfClickHouse: Mastering Data Filtering for Faster ClickHouse Queries
When working with ClickHouse®, writing a query is usually straightforward. Writing an efficient...
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Learning Web Scraping Changed How I See the Internet
It started as a way to make money on Fiverr. It ended up rewiring my brain. Continue reading on Medium »
Dev.to · Gidado Mukhtar Balangoggo
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Microsoft Fabric Just Changed The Data Game
📊 Every day, billions of pieces of data are generated around the world. But raw data alone doesn't...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Hidden Cost of pandas.apply() (And the Habit That Replaces It)
Part 2 of the “Python Performance Secrets” series. .apply() feels vectorized. It isn't. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What a Brazil World Cup Documentary Taught Me About Statistics, Culture and Why Data Often…
Last night I was watching USA ’94: Brazil’s Return to Glory on Netflix. But somewhere between nostalgia and football, a different question… Continue reading on
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Show Proportions of Your Data with Pie Chart in Matplotlib with Python
This is a simple and short tutorial on generating pie charts with Python. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Excel Learning Journey — Day 07
Understanding Logical Functions in Excel Continue reading on Medium »
Dev.to · Manveer Chawla
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What is the best real-time analytics database in 2026? An engineering buyer's guide
Traditional databases just can't keep up with high concurrency and low latency at the same time. The...
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Apache Spark 101
Apache Spark (Hereafter referred to as ‘Spark’) is a data processing framework designed to process large-scale data using distributed… Continue reading on Mediu
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Making of a Data & Payments Polymath
Over the years, I’ve often been asked how I would describe my role. Continue reading on Medium »
Medium · NLP
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
How Spotify Solved Choice Overload in 2015 (And Why Analysts Are Still Using the Framework in 2026)
How Spotify Kept You Hooked: Inside the Data Science of Discover Weekly Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What If Nonprofits Had Credit Scores?
Inside the IRS Form 990 data that almost nobody reads — and the tool I built to score charity efficiency. Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
What If Nonprofits Had Credit Scores?
Inside the IRS Form 990 data that almost nobody reads — and the tool I built to score charity efficiency. Continue reading on Medium »
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
5 Data Schema Design Mistakes That Quietly Create Future Bottlenecks
And how to fix them before your database becomes the reason everything feels slow Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Reality of IPOs: What I Learned Parsing 2,655 SEC Filings
The filing was 847 pages long. I found the revenue number on page 312, buried inside a footnote that referenced a table three sections… Continue reading on Medi
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
The Reality of IPOs: What I Learned Parsing 2,655 SEC Filings
The filing was 847 pages long. I found the revenue number on page 312, buried inside a footnote that referenced a table three sections… Continue reading on Medi
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
I Built an AI to Measure Football Miracles. The Greatest One Is Moroccan.
A century and a half of results, an Elo model, and 40,000 simulated tournaments — to answer a question every fan has shouted at a screen… Continue reading on Me
Dev.to · Andrew
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Vertica vs VoltDB (Volt Active Data): Key Differences, Use Cases & How to Choose in 2026
If you're building a modern data stack that requires either high-throughput transaction processing or...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Data Analytics (AI/ML) ROI 101: Why Investments in Data Analytics (AI/ML) Vanish into the ‘Black…
Overview of the Data Analytics (AI/ML) ROI 101 series of articles Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Self-Hosting Airflow at Home: Automating Stock Price Data Collection
I ran Airflow at home to pull live stock data. Here’s how I did it and what I learned. Continue reading on Analytics Vidhya »
Simon Willison's Blog
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Mapping SQLite result columns back to their source `table.column`
Research: Mapping SQLite result columns back to their source `table.column` It would be neat if arbitrary SQL queries in Datasette could be rendered with additi
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
PGx Testing: The Genetic Blind Spot in Modern Prescribing
Why pharmacogenomic testing may become one of the most underused tools in pain management, behavioral health, and primary care Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Reflections on Anthropic’s Self-Service Data Analytics Playbook
The bottleneck in self-service analytics is not the AI. Continue reading on Medium »
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
You Don’t Need a Modern Data Stack You Just Need a Good Server
For the last decade, if you asked a startup how to count their daily active users, the answer was a $15,000-a-month Rube Goldberg machine. Continue reading on T
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
You Don’t Need a Modern Data Stack You Just Need a Good Server
For the last decade, if you asked a startup how to count their daily active users, the answer was a $15,000-a-month Rube Goldberg machine. Continue reading on T
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
7 Funções de Excel que Descobri no Início da Minha Jornada em Análise de Dados
Recentemente comecei minha transição para a área de Análise de Dados e tenho dedicado parte do meu tempo a estudar ferramentas e conceitos… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
10 SQL Interview Problems That Tripped Me Up
The exact patterns that decide most data engineering SQL screens, with explanations that build real intuition. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
SQL Window Functions Explained: The Most Powerful SQL Feature Every Data Analyst Should Master
Real-World Window Function Examples Every Analyst Should Know Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Why the World Cup Favorite Almost Never Wins
The best team on paper has lost more World Cups than it’s won. Continue reading on AI & Analytics Diaries »
Medium · Startup
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Encore Launches Diamond Currency Intelligence Application : A New Era of Risk-Aware Trading for…
Risk analytics meets the diamond trade — built for importers, exporters, and traders across India Continue reading on Medium »
Dev.to · Vimal Nakrani
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Why did my DataFrame lose rows? Debugging silent pandas pipeline failures
Pandas and polars pipelines fail silently — a merge adds nulls, a filter drops rows, a cast changes dtypes, and nothing crashes. Here's how to find which step d
Dev.to · Fidelis Tuwei
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
How Excel Is Used in Real-World Data Analysis
Before I thought Excel was just something accountants use to make tables look neat. I was wrong —...
Dev.to · Tanmay
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Building My First End-to-End ETL Pipeline with Airflow, BigQuery, and Docker
Recently, I completed my first full Data Engineering project: building an end-to-end ETL pipeline...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Rethinking Leadership: Why Modern Governance Needs Ethical Statecraft and Data
Moving past rhetoric to build a data-driven, value-centric ecosystem for future policymakers. Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Pinterest Data Engineer Interview Question — Data Engineer
Find Top Categories and Highly Active Users by Country Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Data Cleaning & Preprocessing
A coffee shop conversation about why data scientists spend 80% of their time cleaning data — and why that’s actually the most important… Continue reading on Med
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Data Cleaning & Preprocessing
A coffee shop conversation about why data scientists spend 80% of their time cleaning data — and why that’s actually the most important… Continue reading on Med
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Data Cleaning & Preprocessing
A coffee shop conversation about why data scientists spend 80% of their time cleaning data — and why that’s actually the most important… Continue reading on Med
Dev.to · Omar Eldeeb
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
How to Build a LinkedIn Profile Scraper: The Honest Technical Guide
A practical, honest guide to building a LinkedIn profile scraper: why there's no public API, how public pages embed JSON-LD, and the legal reality.
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
My OIBSIP Internship Journey with Oasis Infobyte
Over the past few weeks, I had the opportunity to complete the Data Science / Machine Learning internship under the OIBSIP program by… Continue reading on Mediu
Dev.to · Pulsebit News Sentiment API
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Your Pipeline Is 28.0h Behind: Catching Climate Sentiment Leads with Pulsebit
Your Pipeline Is 28.0h Behind: Catching Climate Sentiment Leads with Pulsebit We just...
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Predictive BI Won’t Eliminate the Data Worker. It Will Make Their Context More Valuable.
Every few years, the data world gets a new promise that sounds like liberation. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3w ago
Predictive BI Won’t Eliminate the Data Worker. It Will Make Their Context More Valuable.
Every few years, the data world gets a new promise that sounds like liberation. Continue reading on Medium »
DeepCamp AI