Tech Skills

Data Analytics & Business Intelligence

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

17,205
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,730) Articles (3273)Blog Posts (3519)Tutorials (398)Research Papers (41)News (499)
Beyond the 80% Grind: Automated ETL and the Instant Synthetic Data Revolution
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Beyond the 80% Grind: Automated ETL and the Instant Synthetic Data Revolution
Is Your Modern Data Stack Still Running on Manual Labor? Continue reading on Medium »
Master Data Analytics with AI at IDSA Janakpuri
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Master Data Analytics with AI at IDSA Janakpuri
Step into the future of analytics with the Data Analytics with AI Course at the Institute of Data Science and Analytics, Janakpuri… Continue reading on Medium »
Your Hard Drive should not be the Graveyard of your Research Projects
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Your Hard Drive should not be the Graveyard of your Research Projects
Or why we built unpublished.pub Continue reading on Medium »
Data Analyst Salary in Kerala 2026: Skills That Increase Your Pay
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Analyst Salary in Kerala 2026: Skills That Increase Your Pay
Data is becoming one of the most valuable assets for businesses. From startups in Kochi to multinational companies in Thiruvananthapuram… Continue reading on Me
SalesIQ: Building a Full-Stack Sales Analytics Dashboard with AI — A Team’s Journey
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
SalesIQ: Building a Full-Stack Sales Analytics Dashboard with AI — A Team’s Journey
When our team sat down to plan our internship project, we knew we didn’t want to build “just another CRUD app.” We wanted something that… Continue reading on Me
How Data Moves: A Guide to Pipeline and Warehouse Patterns
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How Data Moves: A Guide to Pipeline and Warehouse Patterns
From transactional systems to trusted analytical data products Continue reading on Level Up Coding »
The Readers Are Leaving Wikipedia. The Money Isn’t.
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Readers Are Leaving Wikipedia. The Money Isn’t.
Traffic to the world’s reference library has fallen by about a quarter in three years. The cause is stranger than the headlines suggest… Continue reading on Reg
Kesalahan yang Sering Dilakukan Pemula saat Belajar SQL dan Power BI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Kesalahan yang Sering Dilakukan Pemula saat Belajar SQL dan Power BI
Di era data saat ini, SQL dan Power BI menjadi dua keterampilan yang paling banyak dicari dalam bidang analisis data. SQL digunakan untuk… Continue reading on M
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Brutal Truth About Becoming a Data Scientist in 2026 (And Why Python is Your Golden Ticket)
Let’s be real for a second. Aajkal har doosra insaan AI, machine learning, aur data science ki baat kar raha hai. It is easy to get… Continue reading on Medium
How To Always Land Data Science Interviews
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How To Always Land Data Science Interviews
Why you are not getting any callbacks Continue reading on Data Science Collective »
Snowflake’s one-page SEC demo treats structured filings as text
Medium · RAG 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Snowflake’s one-page SEC demo treats structured filings as text
Reading the Cortex one-pager, and why this is the textbook example of treating structured data as text. Continue reading on Data Science Collective »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why I Chose Data Science Even Though I Started With Zero Experience
A year ago, if someone had asked me what Data Science was, I probably would have given a vague answer involving artificial intelligence… Continue reading on Med
The Hidden Cost of Data Bias: Why Your Analysis Might Be More Wrong Than You Think
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Hidden Cost of Data Bias: Why Your Analysis Might Be More Wrong Than You Think
We live in the age of data. Every day, companies make millions of decisions backed by analysis, algorithms, and insights derived from vast… Continue reading on
The Hidden Order of the Landscape: Adding Uncertainty to MapServer Interpolation
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Hidden Order of the Landscape: Adding Uncertainty to MapServer Interpolation
What working on interpolation in MapServer taught me about maps, uncertainty, and the mathematics of the unseen. Continue reading on Medium »
What I Wish I Knew Before Becoming a Data Scientist
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
What I Wish I Knew Before Becoming a Data Scientist
When I first entered Data Science, I thought the profession was primarily about models. Continue reading on Medium »
Two Identical Claims. One Got Paid. The Difference Was a Single Form
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Two Identical Claims. One Got Paid. The Difference Was a Single Form
Two claims leave the billing system looking identical. Same patient, same procedure, same payer. One gets paid. The other gets denied, and… Continue reading on
Who Owns African Data?
Medium · Startup 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Who Owns African Data?
A Plain-English Guide to Data Sovereignty on the Continent. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
What a Dataset Cannot Tell You
I still remember the first time I opened a large survey dataset. Continue reading on Medium »
How Data Science Is Expanding Professional Opportunities in Patna’s Evolving Job Market
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How Data Science Is Expanding Professional Opportunities in Patna’s Evolving Job Market
Patna’s professional landscape is gradually changing as businesses, institutions, and entrepreneurs adopt digital tools to improve… Continue reading on Medium »
Event Time vs Processing Time in Flink -Why it matters more than you think
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Event Time vs Processing Time in Flink -Why it matters more than you think
The three clocks Flink knows about, and why picking the wrong one gives you numbers that are confidently wrong Continue reading on Towards Data Engineering »
Apache Spark Mastery (Part 2 of 6): Hands-On with Databricks & DataFrames
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Apache Spark Mastery (Part 2 of 6): Hands-On with Databricks & DataFrames
A beginner-to-interview-ready series on Apache Spark with PySpark and Databricks. Continue reading on Medium »
Reviewing P-value
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Reviewing P-value
Yes, I am going back to the basics, reviewing the concept of P-value, after soullessly reading and accepting that “P-value < 0.05 as… Continue reading on Medium
How I Build Client-Ready Investment Charts in Under 5 Minutes with Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How I Build Client-Ready Investment Charts in Under 5 Minutes with Python
Your clients don’t care about your backtest. They care about whether they can understand the chart you put in front of them. Continue reading on Medium »
Data is the New Oil. But Can You Refine It?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data is the New Oil. But Can You Refine It?
I still remember the first time I came across words like ANOVA, MANOVA, MANCOVA, Factor Analysis, Clustering, Logistic Regression,etc. Continue reading on Mediu
Data Science vs Retail Realities: Demystifying Regression Evaluation Metrics
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Science vs Retail Realities: Demystifying Regression Evaluation Metrics
When building machine learning models to predict continuous values — like housing prices, stock trends, or supermarket clearance discounts… Continue reading on
Data Science vs Retail Realities: Demystifying Regression Evaluation Metrics
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Science vs Retail Realities: Demystifying Regression Evaluation Metrics
When building machine learning models to predict continuous values — like housing prices, stock trends, or supermarket clearance discounts… Continue reading on
Beyond the Dashboard: How Tracking Actually Improves Operations
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Beyond the Dashboard: How Tracking Actually Improves Operations
After a decade in operations management, I have seen countless leaders fall into the exact same trap. They build beautiful dashboards… Continue reading on Mediu
Why Does Visibility Change Behavior? The Science Behind Metrics That Move People
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Does Visibility Change Behavior? The Science Behind Metrics That Move People
Understanding the psychology that turns dashboards into action Continue reading on Medium »
Building a Flight Data Pipeline Without Trusting AI
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Building a Flight Data Pipeline Without Trusting AI
A few months ago I was cleaning up my GitHub and found this repo — https://github.com/dat-a-ish/data-gov. It was built at that weird… Continue reading on Medium
My Zero-to-Hero Roadmap: How to Transition into Data Science with a Non-CS Background
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
My Zero-to-Hero Roadmap: How to Transition into Data Science with a Non-CS Background
Every time I look at a job description for a Data Scientist role, the first requirement almost always scares people away: “Degree in… Continue reading on Medium
1. The “Creative” Angle: The Art of Data Science: A Deep Dive into Feature Construction
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
1. The “Creative” Angle: The Art of Data Science: A Deep Dive into Feature Construction
Stop expecting your algorithms to do all the work. Learn how to construct the custom features that actually boost predictive power. Continue reading on Medium »
CanvasXpress: An Extended Grammar of Graphics Over Tidy Data
Medium · JavaScript 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
CanvasXpress: An Extended Grammar of Graphics Over Tidy Data
Most JavaScript charting libraries give you chart types. Continue reading on Bootcamp »
Ingesting Hacker News, dev.to, Lobsters, Stack Exchange, and Product Hunt without getting banned
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Ingesting Hacker News, dev.to, Lobsters, Stack Exchange, and Product Hunt without getting banned
Six APIs, six personalities. A field guide to scraping public communities politely — including the source that closed its door and what I… Continue reading on M
Sequential A/B Testing with Sequential Probability Ratio Test
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Sequential A/B Testing with Sequential Probability Ratio Test
This post will cover Sequential A/B testing and address some of the problems that sequential A/B testing creates compared to traditional… Continue reading on Me
The Geography of Climate-Mortgage Risk: Why Zip Codes Matter More Than Credit Scores
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Geography of Climate-Mortgage Risk: Why Zip Codes Matter More Than Credit Scores
For decades, mortgage credit risk has been told as a story about the borrower. Credit score, debt-to-income ratio, loan-to-value, payment… Continue reading on M
What Matters Next Week in Equities
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
What Matters Next Week in Equities
Markets don’t move in straight lines — they move in regimes. Continue reading on Medium »
The Sentient Trading Society Rejects Cycle-Based Technical Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Sentient Trading Society Rejects Cycle-Based Technical Analysis
In this article, I explain why we at the Sentient Trading Society reject unfalsifiable cycle theories. Continue reading on InsiderFinance Wire »
I Built an Open-Source Firebase Analytics Alternative Because I Hit 1M Events/Day Once Too Many
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I Built an Open-Source Firebase Analytics Alternative Because I Hit 1M Events/Day Once Too Many
A few years ago I was the data engineer on a mobile game soft launch when Firebase Analytics quietly started dropping events past its 1M/day cap. We didn't catc
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
How Autonomous Analytics Is Changing the Future of Data Science
Data science has evolved dramatically over the last decade. Businesses once relied on static reports and historical data analysis to guide… Continue reading on
Launch Your Career with a Data Analyst Course: The Smart Choice for Future Professionals
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Launch Your Career with a Data Analyst Course: The Smart Choice for Future Professionals
In today’s data-driven world, organizations rely on data to make informed decisions, improve business performance, and identify new… Continue reading on Medium
Practical SQL Tricks Every Data Scientist Should Know
KDnuggets 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Practical SQL Tricks Every Data Scientist Should Know
In this article, we’ll cover essential SQL patterns and workflows that make everyday data analysis cleaner, faster, and easier to scale.
Weekend Geospatial Python Bootcamp: 4 Courses to Learn GeoPandas, Rasterio & PostGIS Fast
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Weekend Geospatial Python Bootcamp: 4 Courses to Learn GeoPandas, Rasterio & PostGIS Fast
Build real-world geospatial data skills in one weekend with hands-on Python projects and practical workflows. Continue reading on Tierra Insights »
Data Analytics and AI Training | Real-Time Projects & Placement Support | Quality Thought
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Data Analytics and AI Training | Real-Time Projects & Placement Support | Quality Thought
 Upgrade Your Skills. Lead with AI. Continue reading on Medium »
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Ideas for testing data science workflows on self hosted Linux based HPC cluster.
Hi all, Mid–Senior Data Scientist here. I currently work in a team that develops and maintains several fairly large-scale data science projects on a self-hosted
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
EDA
xploratory Data Analysis (EDA) on the Iris Dataset Continue reading on Medium »
5 Kesalahan yang Sering Membuat Peserta Gagal Sertifikasi Microsoft Power BI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
5 Kesalahan yang Sering Membuat Peserta Gagal Sertifikasi Microsoft Power BI
Sertifikasi Microsoft Power BI menjadi salah satu kredensial yang banyak dicari oleh calon maupun profesional data analyst. Continue reading on Medium »
Skill Power BI yang Sering Diuji Saat Technical Interview Data Analyst
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Skill Power BI yang Sering Diuji Saat Technical Interview Data Analyst
Power BI menjadi salah satu tools yang paling sering muncul dalam proses rekrutmen data analyst. Banyak perusahaan tidak hanya menanyakan… Continue reading on M
Have Movies Lost Their Legs?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3w ago
Have Movies Lost Their Legs?
An opening-weekend analysis through the years Continue reading on The Ugly Monster »