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
2d ago
10 SQL Techniques for Optimizing Refresh Schedules for YTD, R12M, and Rolling Window Aggregations
Scheduling strategies that optimize refresh efficiency for time-based aggregations and analytical workloads Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2d ago
The Math of Civilizational Asset-Stripping: A Regression Model of Oligarchic Myopia
When you look at the current geopolitical and economic landscape, it is easy to assume that the ruling class has simply lost its mind. Continue reading on Mediu
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2d ago
Part 4: Advanced Data Engineering: Skew, Streams, and the Delta Lake Revolution
The advanced techniques that separate hobbyists from production experts. Continue reading on Medium »
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Predicting Global Air Quality with 99.93%
A data science deep-dive into 23,463 cities, one Random Forest model, and the pollutant that explains almost everything Continue reading on Medium »
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
From Churn Model to AI Assistant: How I Built an End-to-End Data Science Product
By Deepti Dhanapala | Data Scientist | MPS Data Science, University at Buffalo Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
From Churn Model to AI Assistant: How I Built an End-to-End Data Science Product
By Deepti Dhanapala | Data Scientist | MPS Data Science, University at Buffalo Continue reading on Medium »
Dev.to · Mary Nyandia
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
My Journey Into Data Analysis: From Basics to SQL
Over the past few weeks, I’ve been diving into the fundamentals of data analysis. It’s been an eye...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Is This Market Lying to Me? Part 1: The Problem and the Pipeline
This is the first in a six-part series on building a real-time surveillance pipeline for prediction markets. Part 1 lays out the problem… Continue reading on De
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
My OIBSIP Journey: How Oasis Infobyte Helped Me Grow as a Data Analyst
When I signed up for the Oasis Infobyte Summer Internship Program (OIBSIP) in the Data Analytics domain, I wasn’t entirely sure what to… Continue reading on Med
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
From Strava Data to Race Insights: Building a Tool to Understand Training and Race Performance
Build an app that pulls Strava data to visualize how your training impacts your race performance. Continue reading on Medium »
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Population & Sample in Data Science!
Why tasting one spoon of soup tells you about the whole bowl, & how getting this wrong once humiliated a magazine in front of an entire… Continue reading on Med
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Population & Sample in Data Science!
Why tasting one spoon of soup tells you about the whole bowl, & how getting this wrong once humiliated a magazine in front of an entire… Continue reading on Med
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Population & Sample in Data Science!
Why tasting one spoon of soup tells you about the whole bowl, & how getting this wrong once humiliated a magazine in front of an entire… Continue reading on Med
Medium · Deep Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Population & Sample in Data Science!
Why tasting one spoon of soup tells you about the whole bowl, & how getting this wrong once humiliated a magazine in front of an entire… Continue reading on Med
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Understanding Customer Loyalty Through 100,000 Starbucks Orders: An RFM Analysis
An RFM Analysis of Customers through Starbucks Order Patterns Continue reading on Medium »
Dev.to · Ken-Mutisya
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Get a Stock Earnings Calendar as Clean JSON (Earnings, Dividends, IPOs, Splits)
If you have ever tried to build anything around earnings season, a trading dashboard, a backtest, a...
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
4 Ways to Stop AI From Silently Ruining Your Data
A green pipeline doesn’t mean your data is correct. Continue reading on ILLUMINATION »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
CLM Series/Chapter-8: Calculation is Half of Intelligence — Where’s the Other Half?
CLM Series — Chapter 8 / 50 Continue reading on Medium »
Dev.to · PrismResume
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Structuring a Senior Data Scientist Resume After a Chinese SOE Tenure
Learn how to restructure your senior data scientist resume from a Chinese state-owned enterprise for Western tech roles. Includes a before/after bullet rewrite,
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Why Gojek’s Biggest Complaint Isn’t About Drivers
I analyzed 225,000 app reviews with machine learning. The results surprised me. Continue reading on Medium »
Dev.to · Athreya aka Maneshwar
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Data structures your CS degree kind of glossed over
Hello, I'm Maneshwar. I'm building git-lrc, a Micro AI code reviewer that runs on every commit. It is...
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Raincloud Plots with PtitPrince: See What Your Data Is Really Doing
Three views of your data distribution in one function call Continue reading on Data Science Collective »
Dev.to AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Confused Between Data Science, Data Analytics, Cloud Computing, DevOps, Data Engineering, and Generative AI? Here's How to Choose the Right Career
Choosing the right technology can be overwhelming. Every day, you come across videos, blogs, and social media posts claiming that one technology is better than
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Data Science with AI — Join IDSA Janakpuri Today
Unlock your career potential with the Institute of Data Science and Analytics (IDSA), Janakpuri’s Data Science with AI Course — Delhi’s… Continue reading on Med
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Data Science with AI — Enroll Now at Lonestar Academy Janakpuri
Step into the future of technology with Lonestar Academy Janakpuri’s Data Science with AI Course. Trusted by 15,000+ learners, we are… Continue reading on Mediu
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Stop Writing Python Classes Until You Learn The 4 Things You Can Do To Every Piece Of Data An…
The data lives inside your objects. Most beginners only ever learn to put it in, and never touch it again. Continue reading on CodeToDeploy »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Why I Stopped Trying to Predict Electricity Price Spikes (And Built Something Better Instead)
A weekend project on nodal electricity markets, and the modeling mistake I almost made Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Why I Stopped Trying to Predict Electricity Price Spikes (And Built Something Better Instead)
A weekend project on nodal electricity markets, and the modeling mistake I almost made Continue reading on Medium »
Dev.to AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3d ago
Arbeitszeiterfassung 2026: Unternehmen auf die neue Pflicht vorbereiten
```html Stellen Sie sich vor, Sie sind ein Unternehmer und müssen sich plötzlich mit einer neuen, komplexen Regelung auseinandersetzen. Das ist die Situation, i
Reddit r/artificial
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
ORBIS
The world is not lacking information. It is drowning in fragments. Markets move. Governments shift. Conflicts evolve. Supply chains fracture. Policy changes rip
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
The Invisible Architecture of Truth: Why the World’s Most Boring System is Our Last Defense Against…
Universal Bibliographic Control isn’t just library science. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
The Invisible Architecture of Truth: Why the World’s Most Boring System is Our Last Defense Against…
Universal Bibliographic Control isn’t just library science. Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
SQL Window Functions: SQL’s Biggest Aha! Moment
SQL Window Functions Explained: ROW_NUMBER, RANK, DENSE_RANK, and NTILE Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
What If Fraud Doesn’t Live in Transactions? What If It Lives Between Them?
For decades, financial crime detection has followed a remarkably simple philosophy. Every transaction is evaluated on its own. The system… Continue reading on M
Dev.to · Juhi Singhal
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
5 SQL Interview Questions That Trip Up Beginners
5 SQL Interview Questions That Trip Up Beginners If you're prepping for a tech interview,...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Datenstrukturist — Warum wir einen neuen Beruf für das Informationszeitalter brauchen
Mit der fortschreitenden Digitalisierung entstehen nicht nur neue Technologien, sondern auch neue Formen menschlicher Arbeit. Continue reading on Medium »
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
How Data Science is Transforming Everyday Life: From Netflix to Healthcare
Discover how the same technology that recommends your next movie also helps doctors detect diseases, banks prevent fraud, and businesses… Continue reading on Me
Dev.to · AION ANALYTICS
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Why pandas_market_calendars Fails for Indian Markets (and what to use instead)
Indian algo traders and quant developers hit the same wall: they reach for pandas_market_calendars,...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Sales Performance Analysis
How I Analyzed 1,000 Retail Sales Transactions in Microsoft Excel to Uncover Business Insights Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Data Analytics: How Everyday Industries Actually Use Analytics
Have you ever sat on your couch late at night, staring at your streaming app, wondering how it managed to suggest the exact true-crime… Continue reading on Medi
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
7 Python Libraries That Feel Like Having a Senior Dev on Your Team
They won’t write your code for you — but they’ll save you from writing the wrong code. Continue reading on Stackademic »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Stop using CTEs just to filter window functions.
If you’ve ever written a Query like this just to get the top record per category: Continue reading on Medium »
Dev.to · juhwandad
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
How to Get Clean SEC EDGAR Filing Data (Without Getting Rate-Limited)
If you've ever tried to pull U.S. company filings straight from SEC EDGAR, you know the pain. The...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Tutorial Membuat Dashboard HRD di Power BI untuk Analisis Karyawan
Divisi Human Resources (HR) tidak lagi hanya berfokus pada administrasi karyawan. Saat ini, HR juga dituntut mampu mengolah data untuk… Continue reading on Medi
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
5 Fungsi Power BI dalam Supply Chain dan Operasional Perusahaan
Perusahaan menghasilkan data dalam jumlah besar setiap hari, mulai dari data persediaan barang, pengiriman, produksi, hingga penjualan… Continue reading on Medi
Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
For years, dashboards have been the cornerstone of business intelligence. Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
For years, dashboards have been the cornerstone of business intelligence. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4d ago
Beyond Dashboards: How Data Science and Predictive Analytics Are Transforming Business Decision…
For years, dashboards have been the cornerstone of business intelligence. Continue reading on Medium »
DeepCamp AI