Tech Skills

Data Analytics & Business Intelligence

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

16,858
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,387) Articles (3045)Blog Posts (3431)Tutorials (375)Research Papers (39)News (497)
How much edge is left in the final 48h of a Polymarket? I measured price convergence on 18.6M snapshots
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How much edge is left in the final 48h of a Polymarket? I measured price convergence on 18.6M snapshots
A question I kept circling when I started treating prediction markets as a trading venue: by the time...
Small Changes, Big Impact: Lessons from Optimizing a Data Platform
Dev.to · Lautaro Celli 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Small Changes, Big Impact: Lessons from Optimizing a Data Platform
Intro Last year, I joined a team responsible for a mature data platform with several tools...
The Numbers Know Before Draft Night
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Numbers Know Before Draft Night
Every draft season, front offices argue over the same sliver of prospects at the top. Scouts debate measurables. Agents spin narratives… Continue reading on Med
Apache Spark WTF???  The Spark 4 Freak Show
Medium · DevOps 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Apache Spark WTF??? The Spark 4 Freak Show
Welcome to the Spark 4 Freak Show — the only carnival where defaults bite, configs whisper from the walls, and the architecture finally… Continue reading on Tow
Free Microsoft Certifications for Data Professionals (Limited-Time Opportunity via Fabric Data Days 2026)
Dev.to · Datta Sable 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Free Microsoft Certifications for Data Professionals (Limited-Time Opportunity via Fabric Data Days 2026)
Microsoft has introduced a limited-time opportunity for Data Professionals, Analysts, BI Developers,...
Why Data People Are Moving Beyond Excel
Dev.to · EricMWaimiri 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Data People Are Moving Beyond Excel
You've probably used Microsoft Excel at some point — maybe to track a budget, keep a list, or add up...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Zero Code REST Integration for Modern HealthCare Vitals via Databricks Lakebase Data API
The friction between modern operational edge applications and core analytical data systems is a massive architectural bottleneck in… Continue reading on Medium
From DNA to Data: Where Biology meets Computation
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
From DNA to Data: Where Biology meets Computation
I thought the Human Genome Project was all about Biology. DNA, Genes, Chromosomes — the usual suspects. Continue reading on Medium »
Why Understanding the Problem Still Matters More Than Choosing the Model
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Understanding the Problem Still Matters More Than Choosing the Model
How a simple forecasting pipeline reduced electricity demand prediction errors by more than 50% using public data, interpretable models… Continue reading on Med
Why Understanding the Problem Still Matters More Than Choosing the Model
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Understanding the Problem Still Matters More Than Choosing the Model
How a simple forecasting pipeline reduced electricity demand prediction errors by more than 50% using public data, interpretable models… Continue reading on Med
Why Data Mining Matters (And How It Actually Works)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Data Mining Matters (And How It Actually Works)
Recently, while diving into the Data Mining module for my IT degree, my perspective completely shifted on the massive amounts of data we… Continue reading on Me
GridDB TimeSeries and Java Timestamps: The UTC/DST Traps That Return Empty Results
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
GridDB TimeSeries and Java Timestamps: The UTC/DST Traps That Return Empty Results
How a single timezone assumption can make your entire time-range query silently fail — and how to fix it for good. Continue reading on Medium »
Stop Saying Half of 2026 US Datacenter Capacity Is Canceled
Semi Analysis 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Stop Saying Half of 2026 US Datacenter Capacity Is Canceled
Don't Believe The Vibecoded Estimates, Go Through Every Individual Filing Instead
Tips/Tricks for sports data infrastructure
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Tips/Tricks for sports data infrastructure
Sports data is one of the most deceptively complex domains in analytics. On the surface, it looks simple — games, players, teams… Continue reading on Medium »
Redfin vs Zillow Data: Which is Better for Real Estate Market Research?
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Redfin vs Zillow Data: Which is Better for Real Estate Market Research?
Compare Redfin and Zillow data sources for real estate analysis. Learn field differences, accuracy, and best use cases for each platform.
I Stopped Looping Through Pandas DataFrames. Everything Got Faster
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I Stopped Looping Through Pandas DataFrames. Everything Got Faster
Most pandas performance problems aren’t caused by Python — they’re caused by writing pandas like regular Python. Continue reading on Medium »
I Stopped Looping Through Pandas DataFrames. Everything Got Faster
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I Stopped Looping Through Pandas DataFrames. Everything Got Faster
Most pandas performance problems aren’t caused by Python — they’re caused by writing pandas like regular Python. Continue reading on Medium »
Power BI Copilot Now Accepts 10,000-Character Prompts. That’s Not the Upgrade That Matters.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Power BI Copilot Now Accepts 10,000-Character Prompts. That’s Not the Upgrade That Matters.
In February 2026, Microsoft raised Copilot’s input limit from 500 characters to 10K across every surface. Twenty times more room to type… Continue reading on To
How We Automated SQL Alert Creation for 1000+ Databricks Tables
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How We Automated SQL Alert Creation for 1000+ Databricks Tables
3–5 sets (or more) of SQL alert queries are needed to write for each Databricks table we are managing, and we have 1000+ tables in our… Continue reading on Medi
How We Automated SQL Alert Creation for 1000+ Databricks Tables
Medium · DevOps 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How We Automated SQL Alert Creation for 1000+ Databricks Tables
3–5 sets (or more) of SQL alert queries are needed to write for each Databricks table we are managing, and we have 1000+ tables in our… Continue reading on Medi
Advanced Join Techniques: LATERAL Joins, Semi Joins, Anti Joins
KDnuggets 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Advanced Join Techniques: LATERAL Joins, Semi Joins, Anti Joins
LATERAL joins let a subquery in the FROM clause reference columns from earlier in the same FROM clause. Semi joins return rows where a match exists in another t
I analyzed 1,085 soccer matches to understand late-game scoring patterns
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I analyzed 1,085 soccer matches to understand late-game scoring patterns
The Question What happens to soccer scorelines after the 87th minute? I wanted real data,...
The Lemonade Stand That Explains Data Analytics, Data Science, ML Engineering, AI Engineering, and…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Lemonade Stand That Explains Data Analytics, Data Science, ML Engineering, AI Engineering, and…
A simple story about a kid, a lemonade stand, and the five “helpers” who turned it into a tiny empire explained so clearly even a kid… Continue reading on Stack
Apache Iceberg Optimization: A Guide
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Apache Iceberg Optimization: A Guide
The core optimization layers of healthy tables: compaction, snapshots, metadata, partitioning, delete files, and intelligent automation… Continue reading on ITN
When A/B Testing Fails: Choosing the Right Causal Inference Method
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
When A/B Testing Fails: Choosing the Right Causal Inference Method
A/B testing is often called the gold standard of causal inference. Continue reading on Medium »
Understanding Statistical Distributions Through One Simple Story
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Understanding Statistical Distributions Through One Simple Story
Disclaimer: This poster and article were created with the assistance of AI to explore a more visual and intuitive way of learning… Continue reading on Medium »
Mindful Learning: Balancing Focus and Mental Health
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Mindful Learning: Balancing Focus and Mental Health
In the digital age, students are constantly juggling assignments, online classes, and endless notifications. While technology has made… Continue reading on Medi
A Modernized Power Grid: Why A New Approach To Utilities Planning Is Key
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
A Modernized Power Grid: Why A New Approach To Utilities Planning Is Key
This shift from deterministic to probabilistic planning is a shift in mindset first and foremost.
How to Open and Run Jupyter Notebooks on Android: The 4 Best Methods (2026)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How to Open and Run Jupyter Notebooks on Android: The 4 Best Methods (2026)
A practical guide to editing and running .ipynb notebooks on your Android phone or tablet — from zero-setup apps to a full Termux server. Continue reading on Me
Complete Guide to Data Preprocessing for Data Science & Machine Learning
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Complete Guide to Data Preprocessing for Data Science & Machine Learning
Data preprocessing is one of the most critical stages in the data science and machine learning pipeline. Continue reading on Medium »
How We Modeled Conflicting Historical Knowledge Without Breaking Our Database
Dev.to · Arvind Jolly 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How We Modeled Conflicting Historical Knowledge Without Breaking Our Database
How building an AI-powered geomancy platform forced us to rethink data modeling Most...
Why Simplicity Is Harder Than Complexity in Data Work
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Simplicity Is Harder Than Complexity in Data Work
Anyone can make something complicated. Making it simple takes more. Continue reading on Medium »
Case Study: AI‑Powered Patient Journey & Claims Analytics for Australian Hospitals
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Case Study: AI‑Powered Patient Journey & Claims Analytics for Australian Hospitals
Why Patient Journey Analytics Matters in Australian Hospitals Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Modern Looker Deployments Still Face Data Fragmentation Challenges in 2026
Organizations continue to invest heavily in modern Business Intelligence (BI) platforms to create a single source of truth and enable… Continue reading on Mediu
From Intuition to Algorithm: How We “Tamed” Production Time Estimates at Mecasys s.r.o.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
From Intuition to Algorithm: How We “Tamed” Production Time Estimates at Mecasys s.r.o.
Most manufacturing companies today face the same challenge as we do: how to accurately estimate the production time of a component when we… Continue reading on
The Career Shift Toward Data Science: What Professionals Need to Know
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Career Shift Toward Data Science: What Professionals Need to Know
The professionals standing out today are not the ones working the longest hours, but the ones who ask the right questions and find answers… Continue reading on
Cross-Border Statistical Report Excel Batch Export Feature Development: Multi-Currency, Multi-Business Data Formatting Export Solution
Dev.to · Taocarts 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Cross-Border Statistical Report Excel Batch Export Feature Development: Multi-Currency, Multi-Business Data Formatting Export Solution
When financial and operations personnel use the backend of cross-border purchasing agents or...
Why Are Working Professionals in Mysore Learning New Data Skills?-IABAC
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Are Working Professionals in Mysore Learning New Data Skills?-IABAC
A few years ago, many working professionals believed that learning new technical skills was something only fresh graduates needed to do… Continue reading on Med
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Engineering: The Invisible Superpower Behind Every Data-Driven Company
Data Engineering: The Invisible Superpower Behind Every Data-Driven Company Continue reading on Medium »
What Analyzing Travel Data Taught Me Before I Even Finished the Project
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
What Analyzing Travel Data Taught Me Before I Even Finished the Project
I didn’t plan to write about this project until it was done. Continue reading on Medium »
Beyond Real-Time: Why Event Processing Needs a Full Analytics Rethink
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Beyond Real-Time: Why Event Processing Needs a Full Analytics Rethink
Complex Event Processing (CEP) is great at detecting patterns in real time, but detection alone doesn't create business value. Organizations also need context,
The Z-Test: Statistics Underrated Workhorse (And Why Its Not Just a Worse T-Test)
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Z-Test: Statistics Underrated Workhorse (And Why Its Not Just a Worse T-Test)
You’ve probably heard of the t-test. It’s the darling of intro stats courses, the go-to for ‘I have two groups and I want to compare them.’… Continue reading on
The Z-Test: Statistics Underrated Workhorse (And Why Its Not Just a Worse T-Test)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Z-Test: Statistics Underrated Workhorse (And Why Its Not Just a Worse T-Test)
You’ve probably heard of the t-test. It’s the darling of intro stats courses, the go-to for ‘I have two groups and I want to compare them.’… Continue reading on
The Z-Test: Statistics Underrated Workhorse (And Why Its Not Just a Worse T-Test)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Z-Test: Statistics Underrated Workhorse (And Why Its Not Just a Worse T-Test)
You’ve probably heard of the t-test. It’s the darling of intro stats courses, the go-to for ‘I have two groups and I want to compare them.’… Continue reading on
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Beyond One-Click Approval: Building Multi-Step Data Product Governance on Snowflake
Modern data platforms are getting serious about governed data sharing . Snowflake's Internal Marketplace lets you publish data products once and let teams acros
How to Use AI for Data Analysis without Coding?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How to Use AI for Data Analysis without Coding?
Data analysis used to mean hours in SQL or struggling with Python. That’s not the case anymore. I’ve been testing AI tools for data… Continue reading on Medium
Embedding Live Charts in Your App Without a Full BI Tool
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Embedding Live Charts in Your App Without a Full BI Tool
You don't need Tableau or a $50k BI platform to show your users live charts. Here's how to wire SQL queries directly to charts in your app, fast.
From Raw CSV to Executive Decisions: Building a Complete Retail Analytics Pipeline
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
From Raw CSV to Executive Decisions: Building a Complete Retail Analytics Pipeline
A practical walkthrough of turning 10,000 retail transactions into actionable business strategy using Python, PostgreSQL, machine learning… Continue reading on