Tech Skills

Data Analytics & Business Intelligence

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

16,828
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,358) Articles (3026)Blog Posts (3427)Tutorials (370)Research Papers (39)News (496)
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 »
Apakah Sertifikat Excel Bisa Membantu Diterima Kerja?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Apakah Sertifikat Excel Bisa Membantu Diterima Kerja?
Di tengah persaingan dunia kerja yang semakin ketat, para pencari kerja berlomba-lomba menambah berbagai sertifikat ke dalam curriculum… Continue reading on Med
Data Science Workload: Giới hạn RAM trên Dell Pro Max 14 MC14250
Dev.to · Review Laptop 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Science Workload: Giới hạn RAM trên Dell Pro Max 14 MC14250
Trong lĩnh vực Data Science, việc quản lý tài nguyên hệ thống là một bài toán cân não. Khi bạn chạy...
Understanding Subqueries and CTEs in SQL: A Complete Guide
Dev.to · Stephen Omengo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Understanding Subqueries and CTEs in SQL: A Complete Guide
Working with relational databases often requires breaking down complex problems into manageable...
Common Pitfalls in Scaling A/B Testing Programs
VWO Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Common Pitfalls in Scaling A/B Testing Programs
Teams often kickstart A/B testing programs with a handful of tests backed by a straightforward process and a shared doc. That works well enough at low volume. E
The “Metric-and-Chart” Matrix: A Masterclass in Data Storytelling
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The “Metric-and-Chart” Matrix: A Masterclass in Data Storytelling
Why traditional dashboards fail executives, and how to programmatically build the ultimate hybrid visualization in Python. Continue reading on Medium »
The “Metric-and-Chart” Matrix: A Masterclass in Data Storytelling
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The “Metric-and-Chart” Matrix: A Masterclass in Data Storytelling
Why traditional dashboards fail executives, and how to programmatically build the ultimate hybrid visualization in Python. Continue reading on Medium »
What Is the Data Analytics Salary In India in 2026?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What Is the Data Analytics Salary In India in 2026?
In the era of data, one of the most gratifying career fields, and forward looking fields is that of Data analytics. Data is essential for… Continue reading on M
Architectural Blueprint: Building a Low-Latency Analytics Pipeline for High-Capacity Physical Venues
Dev.to · stampiq 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Architectural Blueprint: Building a Low-Latency Analytics Pipeline for High-Capacity Physical Venues
When building data pipelines for enterprise-scale physical spaces—such as a 20,000-attendee corporate...
The Boardroom Advantage: How Data-Driven Leaders Outperform Their Competitors
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Boardroom Advantage: How Data-Driven Leaders Outperform Their Competitors
Data has become one of the most valuable assets in modern business. However, collecting data is only the beginning. The real advantage… Continue reading on Medi
Building an Analytics Layer on Top of Your Existing Database
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building an Analytics Layer on Top of Your Existing Database
Your production database wasn't built for reporting. Here's how to add a proper analytics layer with read replicas, materialized views, and smart SQL patterns —
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Kesulitan Menemukan Insight dari Data? AI Tools Ini Bisa Membantu!
Menurut laporan Forrester, sekitar 60–73% data enterprise tidak pernah digunakan untuk analisis lanjutan atau pengambilan keputusan. Continue reading on Medium