Tech Skills

Data Analytics & Business Intelligence

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

16,787
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,321) Articles (3000)Blog Posts (3420)Tutorials (366)Research Papers (39)News (496)
A CSV Cross-Check Before Receiving Shopify Purchase Orders
Dev.to · 王磊 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
A CSV Cross-Check Before Receiving Shopify Purchase Orders
When Shopify purchase orders rely on linked transfers, the records can drift even when each screen...
Polars: A Practical Introduction to Fast DataFrames in Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Polars: A Practical Introduction to Fast DataFrames in Python
I have been analyzing data in Python for more than 10 years. In the beginning, I wrote a lot of custom Python functions for data… Continue reading on Medium »
Biology in Finance
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Biology in Finance
I studied Biology for six years. Today, I work in credit and risk modeling — and have done so for roughly the same amount of time. Continue reading on Medium »
The Quiet Skill That Separates $50K Analysts from $150K Analysts
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Quiet Skill That Separates $50K Analysts from $150K Analysts
It’s not SQL. It’s not Python. It’s not dashboards. Here’s what it actually is — and why almost nobody teaches it. Continue reading on AI & Analytics Diaries »
The Quiet Skill That Separates $50K Analysts from $150K Analysts
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Quiet Skill That Separates $50K Analysts from $150K Analysts
It’s not SQL. It’s not Python. It’s not dashboards. Here’s what it actually is — and why almost nobody teaches it. Continue reading on AI & Analytics Diaries »
Music, Mood, and Mental Health: What Listening Habits Reveal About Wellbeing
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Music, Mood, and Mental Health: What Listening Habits Reveal About Wellbeing
Music is part of everyday life for many people. Some use it to focus while studying, some play it while working, and others listen to… Continue reading on Mediu
Nobody Prepared Me for My First On-Call Rotation. Here’s What I Wished They Had.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Nobody Prepared Me for My First On-Call Rotation. Here’s What I Wished They Had.
The survival kit for the first six months of production ownership that nobody gives you. Continue reading on Stackademic »
What is Ontology — the secret sauce to supercharge the data retrieval?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What is Ontology — the secret sauce to supercharge the data retrieval?
Demystifying Ontology, & comparing it with normal data retrieval. This is also a comparative study of Graph vs. Non-Graph based retrieval. Continue reading on M
Simon Willison's Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
datasette 1.0a35
Release: datasette 1.0a35 I'll write more about this one tomorrow, but it's a big release. Three highlights from the release notes: New "Create table" interface
Stock API Python: Build a Dashboard Fast
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stock API Python: Build a Dashboard Fast
Use a stock API Python workflow to fetch fundamentals, shape JSON into pandas, and build a financial dashboard with real SEC data. Continue reading on Medium »
Python for Data Science — Introduction to Seaborn
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Introduction to Seaborn
In the previous article, we learned how to create cleaner and more professional visualizations using: Continue reading on Medium »
Python for Data Science — Introduction to Seaborn
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Introduction to Seaborn
In the previous article, we learned how to create cleaner and more professional visualizations using: Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Modelling, Joins, Relationships and Schemas in Power Bi.
Often not, most beginners assume that having clean data, visually appealing charts, and well-thought-out dashboards is the most important part of data analysis,
Python for Data Science — Subplots, Figure Size, and Clean Visual Layouts
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Subplots, Figure Size, and Clean Visual Layouts
So far, we’ve learned how to create several important visualizations: Continue reading on Medium »
Python for Data Science — Subplots, Figure Size, and Clean Visual Layouts
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Subplots, Figure Size, and Clean Visual Layouts
So far, we’ve learned how to create several important visualizations: Continue reading on Medium »
Python for Data Science — Subplots, Figure Size, and Clean Visual Layouts
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Subplots, Figure Size, and Clean Visual Layouts
So far, we’ve learned how to create several important visualizations: Continue reading on Medium »
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Pipelines: Dynamic Multi-Level Parallelism: A YAML-Driven Tool/Framework
By Shiva Shankar Reddy Kondakindi Sr Principal Engineer, TLCP — Data & AI Creator, Architect, and Primary Contributor of Hubble Continue reading on Medium »
Everyone Is Learning AI. The Smartest People Are Learning Something Else
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Everyone Is Learning AI. The Smartest People Are Learning Something Else
The one skill that quietly separates the people who grow from the people who get stuck — and why most people skip it entirely. Continue reading on Data Science
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 32 of 32 Days of SQL Concepts — Data Lake and Data Lakehouse
Data lakes and data lakehouses represent two distinct yet related approaches to centralized data management that have emerged as… Continue reading on Medium »
I Built a Web App to See Which Bird Party Controls Your County
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Built a Web App to See Which Bird Party Controls Your County
A few weeks ago, I found myself determining whether different regions of the Netherlands were controlled by the Gull Party, the Corvid… Continue reading on Medi
How to Prepare for a Data Analyst Interview
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Prepare for a Data Analyst Interview
The practical roadmap I would follow to walk into interviews with confidence Continue reading on Medium »
Python for Data Science: Everything You Need Before NumPy and Pandas
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science: Everything You Need Before NumPy and Pandas
Python is the language that powers modern Data Science. Continue reading on Medium »
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Spent an Hour on a Data Preprocessing Task Before Asking Gemini
How Gemini solved my Pandas problem in seconds, and why data science fundamentals still matter to spot suboptimal solutions The post I Spent an Hour on a Data P
Master Data Analytics with Generative AI at Lonestar Academy, Janakpuri!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Master Data Analytics with Generative AI at Lonestar Academy, Janakpuri!
 Unlock your future with AI‑powered data analytics! Our Data Analytics with Gen AI course is designed for students, professionals, and… Continue reading on Med
Most CSV libraries go one way or skip types. csv-pipe does both, typed, and parses several times faster than papaparse. Live playground in the post.
Dev.to · Myroslav Martsin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Most CSV libraries go one way or skip types. csv-pipe does both, typed, and parses several times faster than papaparse. Live playground in the post.
csv-pipe: read and write CSV in TypeScript, several times faster than papaparse ...
Why Lead Taxonomy Must Come Before Machine Learning: A Step-by-Step Analytics Guide
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Lead Taxonomy Must Come Before Machine Learning: A Step-by-Step Analytics Guide
This article is the second article in a series of articles documenting my journey in implementing data analytics in an organization. Continue reading on Medium
The Irony of Being a Data Scientist Who Does Not Share Their Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Irony of Being a Data Scientist Who Does Not Share Their Data
When the people who understand data the most are also the most suspicious of it Continue reading on Medium »
Healthcare Has More Data Than Ever—Why Are Patients Still Searching For Answers?
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Healthcare Has More Data Than Ever—Why Are Patients Still Searching For Answers?
Helping people make informed decisions may ultimately create more value than providing additional information.
I Subtracted the Market From Every S&P 500 Stock. Here’s What Was Left
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
I Subtracted the Market From Every S&P 500 Stock. Here’s What Was Left
A Python scanner that flags beta-adjusted abnormal moves using SPY, volume spikes, and news catalysts Continue reading on DataDrivenInvestor »
Rebuilding the Time Machine: Designing a Dual-Purpose Data Versioning System for Modern Backends…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Rebuilding the Time Machine: Designing a Dual-Purpose Data Versioning System for Modern Backends…
In traditional software engineering, databases are treated as state machines. When a user updates their profile, a transaction executes an… Continue reading on
The Numbers Said Rite Aid Would Fail Years Before Bankruptcy
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Numbers Said Rite Aid Would Fail Years Before Bankruptcy
Four quantitative models uncovered warning signs long before Chapter 11. Continue reading on DataDrivenInvestor »
Why Has Data Access Become A Serious Governance Blind Spot?
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Has Data Access Become A Serious Governance Blind Spot?
The more information we all collect and retain, the bigger the challenges get, particularly when so much business data is unstructured.
The Future Of Data Management Is Already Here
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Future Of Data Management Is Already Here
Value is not an afterthought here: It is literally what is being measured, in euros, with rigor and accountability.
SyntheholDB for Pharma & Clinical Research Teams: Stop Letting Data Access Kill Your Pipeline
Dev.to · Jitendra Devabhaktuni 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
SyntheholDB for Pharma & Clinical Research Teams: Stop Letting Data Access Kill Your Pipeline
Published on dev.to · Target audience: Pharma engineers, CROs, clinical data architects,...
Wearable Data and the Nervous System
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Wearable Data and the Nervous System
You’re Tracking Everything. Understanding Nothing. Continue reading on Medium »
Building an Early Warning Signal for Balance Volatility in Business Banking
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building an Early Warning Signal for Balance Volatility in Business Banking
In banking, significant customer deterioration rarely happens overnight. Continue reading on Medium »
Techpoint Africa 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Public data is a national asset, not a revenue shortcut
A trusted data economy will not be built by selling what citizens submitted in good faith. It will be built by proving that Kenya can turn data into public valu
Why Haven’t You Started Learning Data Analytics or AI Yet?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Haven’t You Started Learning Data Analytics or AI Yet?
Why Haven’t You Started Learning Data Analytics or AI Yet? Continue reading on Medium »
Industry-Focused Learning Programs for Data Science Aspirants
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Industry-Focused Learning Programs for Data Science Aspirants
There is a reason as to why some data science students graduate with job offers and some graduate with confusions — and it has nothing to… Continue reading on M
Industry-Focused Learning Programs for Data Science Aspirants
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Industry-Focused Learning Programs for Data Science Aspirants
There is a reason as to why some data science students graduate with job offers and some graduate with confusions — and it has nothing to… Continue reading on M
The FIFA World Cup Effect: Does Hosting the Tournament Change Soccer Participation?
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The FIFA World Cup Effect: Does Hosting the Tournament Change Soccer Participation?
The 2026 FIFA World Cup could drive significant growth in youth soccer across the United States. Previous host countries, including the U.S. (1994), Germany (20
Day 31: Ingesting Data from Kafka into ClickHouse®
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 31: Ingesting Data from Kafka into ClickHouse®
Introduction Real-time data ingestion is a fundamental requirement for modern analytics...
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Role of AI-Powered Analytics in Improving Operational Efficiency
Organizations today generate vast amounts of operational data from business applications, customer interactions, supply chains, and internal processes. While da
Datacenters dip a toe back into waterborne computing despite obvious challenges
The Register 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Datacenters dip a toe back into waterborne computing despite obvious challenges
Floating or sub-surface bit barns are all the rage, but unlikely to compete with multi-gigawatt sites
Why Data Quality Matters More Than Artificial Intelligence Models
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Data Quality Matters More Than Artificial Intelligence Models
Artificial Intelligence has transformed the way organizations analyze information, automate processes, and make strategic decisions. While… Continue reading on
How to Build 1-Minute OHLC Bars from Non-Uniform Market Snapshot Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Build 1-Minute OHLC Bars from Non-Uniform Market Snapshot Data
In financial markets, every price tells a story — but raw snapshot data, arriving every few seconds in irregular bursts, tells it in a… Continue reading on Medi
From Software Engineer to Data Scientist: What They Don’t Tell You
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Software Engineer to Data Scientist: What They Don’t Tell You
I spent five years writing clean, deterministic code before switching to data science. I assumed the transition would be relatively… Continue reading on Medium
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How I Built a Customer Churn Predictor That Actually Explains Why Customers Leave
Most churn models tell you who might leave. Mine tells you why — and that changes everything. Continue reading on Medium »