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
Dev.to · datapeek
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3h ago
Job Hunting? Free Data Tools for Salary, Certification, and Visa Research
Job hunting needs salary data, certification ROI, employer-city take-home pay, and (if you're moving...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4h ago
Python for Data Science — Sampling and Why Your Conclusions Can Be Wrong
In the previous article, we discussed probability distributions and how they help us understand the behavior of data. Continue reading on Medium »
Dev.to · SleepTrace
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
6h ago
Sleep-stage detection is mostly inference. Be honest about it.
Sleep-stage classification is where a lot of consumer sleep tech quietly cheats. A quick tour of the...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8h ago
Data Science Institute in Tilak Nagar — AI, ML & Python Training
In today’s digital world, businesses generate huge amounts of data every day. They need skilled professionals who can analyze this data… Continue reading on Med
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8h ago
From Satellite Images to Smarter Air Quality Predictions: The Story Behind AIRSENSE
How we combined satellite imagery, meteorological data, and ground observations to estimate air quality across Mumbai Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
8h ago
From Satellite Images to Smarter Air Quality Predictions: The Story Behind AIRSENSE
How we combined satellite imagery, meteorological data, and ground observations to estimate air quality across Mumbai Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
16h ago
How to Write SQL Queries That Detect Unstable Join Filtering and Inconsistent Results
Query validation patterns that expose unstable joins and prevent inconsistent analytical outcomes Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
16h ago
How to Write SQL Queries That Detect Unstable Join Filtering and Inconsistent Results
Query validation patterns that expose unstable joins and prevent inconsistent analytical outcomes Continue reading on Medium »
Dev.to · L. Cordero
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
16h ago
Fable 5 Hype: Fangirling with Datasets to Build a Lakers Dashboard
This is the story of a for-fun project, Luka Fit Index that started with me typing "ai for fun?...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
21h ago
Imagine waking up one day only to discover your account has been suspended.
THE DOWNSIDE OF CENTRALISED STORAGE PLATFORMS Continue reading on Medium »
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
23h ago
Exploratory Data Analysis: Asking Good Questions of Your Data
Before you build any model or draw any conclusion, you need to actually understand what you are looking at. This is how professionals do… Continue reading on Me
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
23h ago
Exploratory Data Analysis: Asking Good Questions of Your Data
Before you build any model or draw any conclusion, you need to actually understand what you are looking at. This is how professionals do… Continue reading on Me
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
23h ago
Exploratory Data Analysis: Asking Good Questions of Your Data
Before you build any model or draw any conclusion, you need to actually understand what you are looking at. This is how professionals do… Continue reading on Me
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Automating Source-to-Target Mapping
I built lineage-mcp (Agent-STTM), an MCP server + CLI that reads real SQL scripts and XML ETL exports (SSIS, Informatica PowerCenter, or a… Continue reading on
Medium · Startup
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
The Sharpe Ratio: The Metric That Runs the Investment Industry
Most investors have heard of the Sharpe ratio. Fewer realize how much weight it actually carries behind the scenes, from how pension funds… Continue reading on
Dev.to · gikonyo-v
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Let's Talk Relationships and Joins
Here's something nobody tells you when you start Power BI: the visuals are the easy part. You can...
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
A 15-Year Breakout That Never Looked Back
Testing Donchian Channels on AAPL Continue reading on Medium »
Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
SQL Joins Explained with Real Examples (INNER, LEFT, RIGHT & FULL JOIN)
SQL Joins Explained with Real Examples Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Seeing Is Believing: How to Visualize a Linear Regression Model in R
If you’ve ever pasted the output of summary(lm(...)) into a Slack message or a slide deck, you know the problem: coefficients, standard… Continue reading on Med
InfoQ AI/ML
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
AWS Introduces Amazon S3 Annotations
AWS recently announced Amazon S3 Annotations, a feature that lets teams attach rich, searchable context such as summaries, classifications, compliance data, or
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
# Generating Sample Elon Musk Tweet Data Using Python for Practicing Fabric’s Medallion…
**Subtitle:** A hands-on guide to simulating real-world Data Engineering scenarios — from Python data generation to Power BI Direct Lake… Continue reading on Me
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Looking at a spreadsheet containing hundreds of districts and dozens of demographic indicators rarely reveals meaningful patterns. Continue reading on Medium »
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
What Building a Geospatial Analytics Dashboard Taught Me About Visualizing Data at Scale
Looking at a spreadsheet containing hundreds of districts and dozens of demographic indicators rarely reveals meaningful patterns. Continue reading on Medium »
Dev.to · 네이쳐스테이
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
Unpacking the S&P 500 and Nasdaq: A Deep Dive into Index Performance
Introduction The S&P 500 and Nasdaq are two of the most widely followed indices in the...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d ago
9 Must-Know SQL Queries for Data Analysts and Data Scientists
SQL (Structured Query Language) is a fundamental tool for data professionals like data analysts and data scientists. While basic SQL… Continue reading on Medium
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1d 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
1d 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
1d 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
1d 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
1d 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
1d 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
1d 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
1d 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
1d 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
1d 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
1d 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
2d 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
2d 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
2d 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
2d 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
2d 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
2d 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
2d 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
2d 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
2d 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
2d 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
2d 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
2d 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 »
DeepCamp AI