Tech Skills

Data Analytics & Business Intelligence

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

16,717
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,255) Articles (2957)Blog Posts (3407)Tutorials (357)Research Papers (39)News (495)
IGITAL ASYMMETRY AND THE ECONOMICS OF SMALL ACTIONS WITH MASSIVE IMPACT: LESSONS FOR SRI LANKA
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
IGITAL ASYMMETRY AND THE ECONOMICS OF SMALL ACTIONS WITH MASSIVE IMPACT: LESSONS FOR SRI LANKA
Perspectives from Arjuna Samarakoon and Albert-László Barabási Continue reading on Medium »
Company Registry Data Tools for Business Intelligence
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Company Registry Data Tools for Business Intelligence
Company registry data is the backbone of every credible KYC, KYB, and M &A workflow — yet it...
Addressing the global namespace
Dev.to · Joichiro Mitaka 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Addressing the global namespace
There is a moment in every data hoarder's life — and in every small media shop's IT history — when...
Day 35 – ClickHouse® and S3 Integration: Querying Data Lakes
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 35 – ClickHouse® and S3 Integration: Querying Data Lakes
Introduction Modern organizations generate massive amounts of data that need to be stored...
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Learning Concepts to Building Real Projects: My Data Science Internship Journey
Most students begin their data science journey through online courses, YouTube tutorials, and classroom assignments. I followed the same… Continue reading on Me
Debugging Data Unload Failures in GBase — How to Handle Invalid Data and Export Breakdowns
Dev.to · Scale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Debugging Data Unload Failures in GBase — How to Handle Invalid Data and Export Breakdowns
In enterprise database systems, exporting data is a critical operation for analytics, backup, and...
Building Reliable Data Pipelines in GBase — Transactions, Validation, and Export Stability
Dev.to · Scale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building Reliable Data Pipelines in GBase — Transactions, Validation, and Export Stability
In enterprise data systems, reliability is measured not only by how data is stored, but also by how...
Ensuring Data Integrity in GBase — From Transactions to Reliable Data Export Pipelines
Dev.to · Scale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Ensuring Data Integrity in GBase — From Transactions to Reliable Data Export Pipelines
In modern enterprise systems, data integrity is not only about storing correct values—it is about...
10 SQL Indexed View Techniques for Faster Reporting and Aggregation Workloads
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
10 SQL Indexed View Techniques for Faster Reporting and Aggregation Workloads
Indexed view strategies that accelerate aggregations and reduce query overhead in reporting workloads Continue reading on Medium »
The Hotel Pricing Trap: Why Raising Your ADR Might Actually Destroy Your Profits
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Hotel Pricing Trap: Why Raising Your ADR Might Actually Destroy Your Profits
How to mathematically calculate the impact of price elasticity and mixed expenses on your hotel’s net operating income. Continue reading on Medium »
Your outlook towards Excel is making you miserable
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Your outlook towards Excel is making you miserable
For data folks who are stuck with MS Office. Continue reading on DataAutodidact »
The Complete Data Science Process: A Step-by-Step Guide for Beginners and Professionals-IABAC
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Complete Data Science Process: A Step-by-Step Guide for Beginners and Professionals-IABAC
Data has become one of the most valuable assets for organizations across industries. Companies rely on data-driven insights to improve… Continue reading on Medi
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Pandas, the Most Valuable Python Library for Data Analysts
If you ask ten data analysts which Python library they use most often, many will likely say Pandas. Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Pandas, the Most Valuable Python Library for Data Analysts
If you ask ten data analysts which Python library they use most often, many will likely say Pandas. Continue reading on Medium »
Building a Sports Data Pipeline: Lessons from Scotland primed for game of their lives against fallible Brazil
Dev.to · Muhammad Bin Nazeer 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building a Sports Data Pipeline: Lessons from Scotland primed for game of their lives against fallible Brazil
Building a Sports Data Pipeline: Lessons from Scotland primed for game of their lives...
Training in Dad Mode: How I Built a Strava-to-Notion Dashboard with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Training in Dad Mode: How I Built a Strava-to-Notion Dashboard with Python
A small personal automation project for turning fitness data into a useful training system Continue reading on Medium »
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Your Apache Iceberg Tables Are Slowing Down (And How to Fix It)
Continue reading on Medium »
Tinkering with Databricks: Claude Desktop, MCP, and a Clinical Intelligence Server
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Tinkering with Databricks: Claude Desktop, MCP, and a Clinical Intelligence Server
When Claude Desktop becomes the interface, MCP becomes the bridge, and Databricks stays the governed data backbone, the shape of a… Continue reading on Medium »
What 86 Days of Clean Prediction-Market History Actually Shows
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What 86 Days of Clean Prediction-Market History Actually Shows
I archived 17.2M Polymarket price snapshots on one Mac. Here's what the resolved data says about whether the crowd is actually calibrated — and how to check it
STATISTICS MATTERS IN DATA SCIENCE
Dev.to · Diana Wachenje 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
STATISTICS MATTERS IN DATA SCIENCE
Introduction Statistics is a branch of applied mathematics that helps one to collect,...
【UoM】 Health Data Science 25/26 — Semester 2 (All Optional)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
【UoM】 Health Data Science 25/26 — Semester 2 (All Optional)
In Semester 2, every module is optional. You’ll choose 4 out of 11 available units. The course list was shared in mid-November, and you’ll… Continue reading on
The Math Behind “The House Always Wins”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Math Behind “The House Always Wins”
Breaking down the hidden probabilities on the casino floor. Continue reading on Towards AI »
The Allocation Problem No Spreadsheet Solves on Its Own
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Allocation Problem No Spreadsheet Solves on Its Own
How data science turns resource allocation from an argument about opinions into a decision you can actually defend. Continue reading on Medium »
What a client constraint taught me about writing Databricks code in 2026
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What a client constraint taught me about writing Databricks code in 2026
Left to my own devices, I write Databricks code in a terminal. Claude Code across the repo, Databricks Asset Bundles to ship, pytest… Continue reading on Medium
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
My Data Project Was 22 Megabytes for the LLM. Now It’s 241 Kilobytes.
I didn’t change the data. I changed how I packaged it. Continue reading on Medium »
Last Summer I Wrote Code to Analyze the Titanic Dataset.
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Last Summer I Wrote Code to Analyze the Titanic Dataset.
Last summer, I was learning data science the way most people do. Pick a popular dataset. Write some pandas code. Run a few plots. Call it… Continue reading on M
Building Production-Grade Delta Lake Pipelines with Apache Spark on Databricks
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building Production-Grade Delta Lake Pipelines with Apache Spark on Databricks
A deep dive into the medallion architecture, Delta Lake internals, Z-ordering, and optimized Spark writes — the patterns that separate… Continue reading on Code
Audit Workflows, Reef Cameras, Tokenizer Research: Three CDS Capstone Projects
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Audit Workflows, Reef Cameras, Tokenizer Research: Three CDS Capstone Projects
Most graduate-level coursework ends with a final exam or paper. The CDS Capstone Project ends with research the UN features on its blog… Continue reading on Med
49/60 Days System Design Questions
Dev.to · Joud Awad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
49/60 Days System Design Questions
Your data team just opened a $4,200 BigQuery bill. For a single month. One analyst. 12 queries. The...
Survivorship Bias in Backtesting: The Ghosts of the Stock Market
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Survivorship Bias in Backtesting: The Ghosts of the Stock Market
Lehman Brothers, Bear Stearns, Sears — and why every strategy built on S&P 500 historical data is missing the companies that mattered most… Continue reading on
AWS Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
AI-powered BI with Snowflake and Amazon Quick
In this post, you will learn how to build an end-to-end integration between Snowflake semantic views and Amazon Quick. The sample data is user review data for a
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Build a Credit Scoring Grid From a Logistic Regression Model
Turning model coefficients into a 0–1000 score, with risk classes and stability checks The post How to Build a Credit Scoring Grid From a Logistic Regression Mo
How to Reduce Your Cost to Serve Without Sacrificing Customer Experience
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Reduce Your Cost to Serve Without Sacrificing Customer Experience
Imagine two customers buying the exact same product at the exact same price. On paper, they generate identical revenue. In reality, one of… Continue reading on
What We Teach Our Private Students (2026)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What We Teach Our Private Students (2026)
Public details of the STS 2:1 guidance programme, highlighting our structured, ethical framework. Continue reading on Medium »
Why Is Cost to Serve So Hard to Measure?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Is Cost to Serve So Hard to Measure?
Two customers buy the exact same product at the exact same price. One of them quietly costs you twice as much to serve. Same revenue line… Continue reading on M
I Replaced Pandas Workflows with DuckDB. Here’s What Happened.
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Replaced Pandas Workflows with DuckDB. Here’s What Happened.
The Data Tool I Treated Like a Database Turned Out to Be a Better DataFrame Continue reading on Medium »
The Ultimate Guide to Data Visualization with Pandas in 2026: Architectures, PyArrow Backends, and…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Ultimate Guide to Data Visualization with Pandas in 2026: Architectures, PyArrow Backends, and…
The release of Pandas 3.0 on January 21, 2026, marks a fundamental paradigm shift in the Python data ecosystem. For web developers and… Continue reading on Medi
From Black Box to Runbook: Why Every Data Product Needs an FAA Checklist
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Black Box to Runbook: Why Every Data Product Needs an FAA Checklist
There is a particular kind of silence that happens in data teams when a critical system breaks. Continue reading on Medium »
Giant Killings in Champions League: Data Analysis of 30 Years of Upsets
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Giant Killings in Champions League: Data Analysis of 30 Years of Upsets
The night of March 6, 2017, will forever be etched into the memory of football fans worldwide. AS...
How to Fetch Real-Time Options Chain Data in Python (Without Paying $99/mo)
Dev.to · Salomon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Fetch Real-Time Options Chain Data in Python (Without Paying $99/mo)
If you've ever tried to pull live options data into a Python script, you've probably hit the same...
R Shiny and Google Cloud Run
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
R Shiny and Google Cloud Run
Dashboards are useful when you want your audience to be able to explore data without asking them to read through static tables or code. In… Continue reading on
UFC Underdog ROI: I Tracked 500 Fights to Find Systematic Mispricings
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
UFC Underdog ROI: I Tracked 500 Fights to Find Systematic Mispricings
"The sharps are cleaning up in the UFC betting markets while casual bettors get slaughtered." That...
Apache Data Lakehouse Weekly: June 17 to June 24, 2026
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Apache Data Lakehouse Weekly: June 17 to June 24, 2026
This week the lakehouse community spent most of its energy on two questions. The first is how the...
Data Engineering Coding Challenge (Python Data Validation)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Engineering Coding Challenge (Python Data Validation)
​Sample Data Engineering Take Home Test with Solution Continue reading on Medium »
How Socioeconomic Factors Influence Chronic Disease Outcomes
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Socioeconomic Factors Influence Chronic Disease Outcomes
Chronic disease management is influenced by far more than medical treatment alone. Research has consistently shown that factors such as… Continue reading on Med
How you play is where you belong
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How you play is where you belong
A location-free model that reads a player’s role from how he behaves on the ball — and the positions he could play. Continue reading on Medium »
Day 34: Advanced ClickHouse® Aggregating Functions
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 34: Advanced ClickHouse® Aggregating Functions
Advanced ClickHouse® Aggregating Functions Introduction Aggregation is one of...
CODE #4: CHOOSING THE RIGHT PROGRAMMING LANGUAGE? (R DATA SCIENCE & VISUALIZATION)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
CODE #4: CHOOSING THE RIGHT PROGRAMMING LANGUAGE? (R DATA SCIENCE & VISUALIZATION)
Trade-offs in programming languages; LLM bias toward Python/away from Rust; historical perspective; and a use-case of R for advanced data… Continue reading on M