Tech Skills

Data Analytics & Business Intelligence

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

16,866
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,395) Articles (3050)Blog Posts (3432)Tutorials (377)Research Papers (39)News (497)
Case Study Based Data Analytics e-Book
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Case Study Based Data Analytics e-Book
In today’s data-driven world, learning data analytics is not just about theory — it’s about understanding how data solves real problems… Continue reading on Med
Case Study Based Data Analytics e-Book
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Case Study Based Data Analytics e-Book
The Case Study Based Data Analytics e-Book is a practical learning resource designed to help students and beginners understand data… Continue reading on Medium
Reddit r/learnprogramming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Automating data extraction from a website
Hi everyone, I recently started working at a company where I have a monthly recurring task that involves extracting data from a website and pasting it into Exce
What is Data Science?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
What is Data Science?
Data Science is an interdisciplinary field that involves collecting, processing, analyzing, and interpreting data to extract meaningful… Continue reading on Med
Difference between Data Science and Data Analytics?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Difference between Data Science and Data Analytics?
Data Science and Data Analytics are related fields, but they have different goals and approaches. Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
A Technical Guide to AI-Powered CSV Duplicate Removal
In the world of data, pristine datasets are a myth. From customer lists to inventory records, nearly every CSV file you encounter is likely to harbor a silent,
I archived 17.9M Polymarket price snapshots. Three things the data shows that the order book hides.
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
I archived 17.9M Polymarket price snapshots. Three things the data shows that the order book hides.
A walk through what ~17,900 prediction markets look like in bulk — favorite-longshot bias, late convergence, and why volume != movement — using a dataset of 17.
Why regex wasn't enough for data extraction (and what I used instead)
Dev.to · zhongqiyue 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Why regex wasn't enough for data extraction (and what I used instead)
I spent three weeks trying to extract invoice data from a pile of PDFs sent by different vendors....
Data Science Careers Are Growing Rapidly Across Indore Today
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Data Science Careers Are Growing Rapidly Across Indore Today
Indore has emerged as one of India’s most dynamic cities for technology, education, and business development. Continue reading on Medium »
Python for Data Science — Detecting Skewness, Spread, and Strange Distributions
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Python for Data Science — Detecting Skewness, Spread, and Strange Distributions
I hope you enjoyed my last blog on Bivariate Analysis in Analysis thinking. Continue reading on Medium »
Python for Data Science — Detecting Skewness, Spread, and Strange Distributions
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Python for Data Science — Detecting Skewness, Spread, and Strange Distributions
I hope you enjoyed my last blog on Bivariate Analysis in Analysis thinking. Continue reading on Medium »
What Makes a Certification in Data Science Online So Popular Right Now?-IABAC
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
What Makes a Certification in Data Science Online So Popular Right Now?-IABAC
A few years ago, many people believed that Data science was only for programmers, researchers, or people with advanced mathematics… Continue reading on Medium »
Israel’s Strategic Autonomy Problem: A Stochastic Systems Analysis of Independence, Alliance, and…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Israel’s Strategic Autonomy Problem: A Stochastic Systems Analysis of Independence, Alliance, and…
Using Monte Carlo simulations, regime-switching models, economic data, defense-industrial metrics, and alliance dynamics to explore… Continue reading on The Pyu
Databricks is raising again at up to $175 billion, four months after closing at $134 billion
The Next Web AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Databricks is raising again at up to $175 billion, four months after closing at $134 billion
Databricks is in talks to raise a new funding round at a valuation of between $165 billion and $175 billion, The Information reported on Monday. The round could
Stop Saying “Baad Mein” — Your Data Analytics Career Can’t Wait
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Stop Saying “Baad Mein” — Your Data Analytics Career Can’t Wait
Stop Saying “Baad Mein” — Your Data Analytics Career Can’t Wait Continue reading on Medium »
How to Build Data Pipelines That Resist Partition Drift
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
How to Build Data Pipelines That Resist Partition Drift
Partition drift is a hidden performance drain where the physical layout of data on disk gradually uncouples from user query patterns, breaking file pruning and
Turn Data into Impact with DICS Innovatives!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Turn Data into Impact with DICS Innovatives!
Ready to build a successful career in the booming field of Data Science? Continue reading on Medium »
How Excel is Used in Real-World Data Analysis
Dev.to · Elishiba Muigo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
How Excel is Used in Real-World Data Analysis
To anyone who has basic computer knowledge will tell you they know Excel, many will just say it's a...
Calculating classification metrics in Power BI
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Calculating classification metrics in Power BI
From notebooks to dashboards: Evaluating ML models in Power BI Continue reading on Data Science + AI at Microsoft »
GrowbixAI Analytics – Smarter Decisions with AI 📊
Dev.to · Team Growbix Ai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
GrowbixAI Analytics – Smarter Decisions with AI 📊
Track your business performance, monitor conversions, and optimize your sales funnel with powerful...
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Maine Data Annotation Se Paise Kaise Kamaye? My Honest Review & Step-by-Step Guide
Data Annotation par kaam karne ka mera real experience, onboarding tips aur earning ka pura sach. Continue reading on Medium »
The 7 Most Impactful Use Cases for Real Estate Data Scraping 2026
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
The 7 Most Impactful Use Cases for Real Estate Data Scraping 2026
How Web Scraping Powers Market Analysis, Price Monitoring, Lead Generation, and Smarter Property Valuation in Today’s Data-Driven Real… Continue reading on Towa
How to Create Charts from CSV Files Without Excel
Dev.to · hw lu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
How to Create Charts from CSV Files Without Excel
CSV files are everywhere: analytics exports, sales reports, product usage logs, survey results,...
5 Practical Python Scripts for Time Series Analysis Every Data Practitioner Should Know
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
5 Practical Python Scripts for Time Series Analysis Every Data Practitioner Should Know
Time series data appears everywhere in real systems, from finance to IoT sensors to user behavior tracking. Despite the variety of domains… Continue reading on
5 Practical Python Scripts for Time Series Analysis Every Data Practitioner Should Know
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
5 Practical Python Scripts for Time Series Analysis Every Data Practitioner Should Know
Time series data appears everywhere in real systems, from finance to IoT sensors to user behavior tracking. Despite the variety of domains… Continue reading on
5 Practical Python Scripts for Time Series Analysis Every Data Practitioner Should Know
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
5 Practical Python Scripts for Time Series Analysis Every Data Practitioner Should Know
Time series data appears everywhere in real systems, from finance to IoT sensors to user behavior tracking. Despite the variety of domains… Continue reading on
From Data Quality Checks to Analytics-Ready Parquet with Python
Dev.to · Bob Oner 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
From Data Quality Checks to Analytics-Ready Parquet with Python
In the first article, I walked through a small Python data quality ETL starter that reads messy CSV,...
ArXiv cs.AI 📊 Data Analytics & Business Intelligence 📄 Paper ⚡ AI Lesson 4w ago
Can Data Work be Reparative?
arXiv:2606.09408v1 Announce Type: cross Abstract: We present an ethnographic study of an alternative approach to data work, developed by a civic-tech initiative
ArXiv cs.AI 📊 Data Analytics & Business Intelligence 📄 Paper ⚡ AI Lesson 4w ago
ArtiFact: A Large-Scale Multi-Modal Cultural Heritage Dataset
arXiv:2606.09648v1 Announce Type: cross Abstract: Multi-modal data management has emerged as a central research topic in the database community, spanning data i
Agricultural Yield Prediction and Performance Classification using a Local Data Lakehouse and…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Agricultural Yield Prediction and Performance Classification using a Local Data Lakehouse and…
Modern agriculture deals with a large volume of geospatial, weather, and historical production data. However, building reliable predictive… Continue reading on
Pandas vs SQL, when to use each
Dev.to · I Want To Learn Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Pandas vs SQL, when to use each
Pandas and SQL overlap a lot, so which should an analyst reach for? A practical comparison of where each one wins, with the same operations side by side.
5.5 Million Bike Rides Told Me Everything About Why Casual Users Don’t Convert
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
5.5 Million Bike Rides Told Me Everything About Why Casual Users Don’t Convert
The conversion problem is usually framed wrong. Cyclistic, a fictional Chicago bike-share company modelled on the real Divvy system, has a… Continue reading on
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Everhayes Academy (Everhayes Omnis Academy): Bridging Technology and Market Intelligence
The financial industry has always relied on information. From economic reports and corporate disclosures to market data and global news, the ability to process
Why the Modern Data Stack Trapped Data Engineers in Tools
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Why the Modern Data Stack Trapped Data Engineers in Tools
The Modern Data Stack solved old problems but created tool overload. Here’s why AI-native data engineering may be the next shift.
Nobody Told Me Excel Would Ambush Me at the Worst Possible Moments
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Nobody Told Me Excel Would Ambush Me at the Worst Possible Moments
On being excellent at your job and occasionally cornered by a spreadsheet. Continue reading on Medium »
Your ETL Pipeline Wasn't Built for AI — Here's How to Fix It in 2026
Dev.to · Gabriel Henrique 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
Your ETL Pipeline Wasn't Built for AI — Here's How to Fix It in 2026
Your ETL Pipeline Wasn't Built for AI — Here's How to Fix It in 2026 You've got a...
The Notebook That Science Built Its Future On Is Broken. Here’s the Proof — and the Fix.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4w ago
The Notebook That Science Built Its Future On Is Broken. Here’s the Proof — and the Fix.
Jupyter gave data scientists a superpower. It also gave them a hidden trap. Continue reading on AI Advances »
Data Cleaning Fundamentals: Detecting and Removing Duplicate Records
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Cleaning Fundamentals: Detecting and Removing Duplicate Records
A Practical Guide to Identifying, Understanding, and Eliminating Duplicate Data Continue reading on Medium »
Data Cleaning Fundamentals: Detecting and Removing Duplicate Records
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Cleaning Fundamentals: Detecting and Removing Duplicate Records
A Practical Guide to Identifying, Understanding, and Eliminating Duplicate Data Continue reading on Medium »
2025 Guide to the Best Web3 Growth Analytics for Crypto Teams
Dev.to · analytic kit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
2025 Guide to the Best Web3 Growth Analytics for Crypto Teams
Cookie-based analytics misses every on-chain interaction outside your front end — and for Web3 teams,...
The Day Data Learned to Think: Understanding the Partnership Between Data Science and Machine…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Day Data Learned to Think: Understanding the Partnership Between Data Science and Machine…
Imagine you walk into a library. This library is really big. Every second millions of books are added to its shelves. Some books have… Continue reading on Mediu
Track Medium Follower Growth and Social Graph Snapshots
Dev.to · Sebastian Casvean 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Track Medium Follower Growth and Social Graph Snapshots
Track Medium Follower Growth and Social Graph Snapshots Follower count is vanity. Useful...
Data Analysts Are the Architects of Insight: Drawing Parallels Between Engineering Design and Data…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Analysts Are the Architects of Insight: Drawing Parallels Between Engineering Design and Data…
Having worked in both the built environment sector and the data analytics field, I’ve come to realize something profound: the role of a… Continue reading on Med
From Dashboards to Autonomous Action: Why You Need to Attend Google Cloud Labs
Dev.to · Joey Lynne Hernandez 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
From Dashboards to Autonomous Action: Why You Need to Attend Google Cloud Labs
The era of passive data analytics is over. Today, the most forward-thinking data teams aren't just...
head and tail: The First and Last Things You Need to Know About Your Data
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
head and tail: The First and Last Things You Need to Know About Your Data
Head prints the first N lines of input, tail prints the last N — but the real value is in the details: negative line counts, the +N start-from syntax, magic byt
Building on Brazilian public data: a developer's field guide (CNPJ, CEP, Congress, BACEN)
Dev.to · rodrigo da silva 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building on Brazilian public data: a developer's field guide (CNPJ, CEP, Congress, BACEN)
After working with Brazilian government data for a while, I've found the landscape confusing to...
Retention cohort analysis with plain SQL
Dev.to · Zenovay 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Retention cohort analysis with plain SQL
Everyone wants a retention chart and most reach for a tool. You can get the core cohort triangle from...
Running Ad-Hoc Video Analytics on Parquet Exports with DuckDB
Dev.to · ahmet gedik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Running Ad-Hoc Video Analytics on Parquet Exports with DuckDB
How we run heavy ad-hoc analytical queries over tens of millions of viral-video snapshots by exporti