Tech Skills

Data Analytics & Business Intelligence

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

16,768
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,303) Articles (2989)Blog Posts (3416)Tutorials (363)Research Papers (39)News (496)
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 »
How to Convert PDF and Excel Invoices to CSV for Faster Data Processing
Dev.to · kevincarroll 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How to Convert PDF and Excel Invoices to CSV for Faster Data Processing
Manually converting invoice data from PDF or Excel files into CSV format is one of the most...
I scored 8,000 Seoul cafes for laptop-workability from review keywords
Dev.to · Lucas 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I scored 8,000 Seoul cafes for laptop-workability from review keywords
How I turned messy Naver review keywords into a "workability score" for 8,000+ Seoul cafes, aggregated it by district, and published the whole thing as a free d
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 »
A Historical FX Reference Report for CSV, API, and Spreadsheet Workflows
Dev.to · Jenpo Zhan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
A Historical FX Reference Report for CSV, API, and Spreadsheet Workflows
FXpeek's annual reference report for dated exchange-rate lookup, CSV exports, widgets, and lightweight JSON API workflows.
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
Dashboards and KPIs for Mechanical Completion Reporting
Dev.to · beefed.ai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Dashboards and KPIs for Mechanical Completion Reporting
Design effective completions dashboards: choose KPIs, model data for Power BI/Tableau, visualize progress, and automate distribution to stakeholders.
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
Can You Be a Data Scientist Without Statistics? Yes. Should You?
Dev.to · Amailuk Joseph 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Can You Be a Data Scientist Without Statistics? Yes. Should You?
Can Data Science Do Without Statistics? 1. Introduction: The Debate Nobody Wants...
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 »
Data Cleaning Automation: The Complete Python Guide
Dev.to · Xinglin Ming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Cleaning Automation: The Complete Python Guide
Automate your data cleaning pipeline with Python. Handle duplicates, missing values, dates, and outliers.
Writing Iceberg tables with Apache Hop and DuckDB
Dev.to · Peter Fabricius 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Writing Iceberg tables with Apache Hop and DuckDB
Introduction With my Iceduck project, I’ve been diving deep into Data Lakehouse...
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
I Used AI as a Personal Data Analyst. It Changed Everything.
Dev.to · Suzy Chase 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I Used AI as a Personal Data Analyst. It Changed Everything.
The Problem After losing 50 pounds on a GLP-1, I thought the hard part was over. It wasn't. The...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w 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 2w 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 2w 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 2w 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 »
Day 26 of 100 Days of ClickHouse: Understanding Distributed Tables
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Day 26 of 100 Days of ClickHouse: Understanding Distributed Tables
As your data grows, a single ClickHouse server may eventually reach its limits. Whether it's storage,...
I Analyzed 100,000+ Rows Using Only Excel and It Completely Changed How I Think About Data
Dev.to · Analyst Kinywa 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I Analyzed 100,000+ Rows Using Only Excel and It Completely Changed How I Think About Data
“Real data analysis starts with Python or SQL.” That’s what I believed too until I spent weeks...
Data Analytics and AI Training | Real-Time Projects & Placement Support | Quality Thought
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Analytics and AI Training | Real-Time Projects & Placement Support | Quality Thought
 Upgrade Your Skills. Lead with AI. Continue reading on Medium »
I Built a Match-Day Social Listening Dashboard for the World Cup in a Weekend
Dev.to · Olamide Olaniyan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I Built a Match-Day Social Listening Dashboard for the World Cup in a Weekend
I wanted a single screen that told me what the internet was feeling during a World Cup match — which...
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w 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
The inevitable weakness of metrics
MIT Technology Review 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The inevitable weakness of metrics
There are plenty of useful things a metric can reveal. There are even more it can obscure or corrupt. It took me well over a decade of tracking my own life in e
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
EDA
xploratory Data Analysis (EDA) on the Iris Dataset Continue reading on Medium »
Why Statistics is the Secret Weapon Behind Data Science- Healthcare analytics
Dev.to · NelimaL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Statistics is the Secret Weapon Behind Data Science- Healthcare analytics
"Without statistics, data is just a collection of numbers. With statistics, data becomes...
5 Kesalahan yang Sering Membuat Peserta Gagal Sertifikasi Microsoft Power BI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w 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 2w 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
I analyzed 500+ bank statements. Here's what I found.
Dev.to · FLOW by Vestelon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I analyzed 500+ bank statements. Here's what I found.
I Analyzed 500+ Bank Statements. Here's What I Found. Over the past few months, while...
Have Movies Lost Their Legs?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Have Movies Lost Their Legs?
An opening-weekend analysis through the years Continue reading on The Ugly Monster »
Building Production Data Pipelines for Enterprise AI: What Actually Has to Work
Dev.to · Open Craft 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Building Production Data Pipelines for Enterprise AI: What Actually Has to Work
Most enterprise AI projects don't fail because the model is wrong. They fail because the data feeding the model is unreliable, stale, or structurally
The Overloaded Equals Sign
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Overloaded Equals Sign
Every equals sign is a quiet decision about what to ignore — and that decision builds the integers, the real numbers, and the surface of a… Continue reading on
How to Embed a SQL Dashboard into Your SaaS App (Without Building Everything from Scratch)
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How to Embed a SQL Dashboard into Your SaaS App (Without Building Everything from Scratch)
A practical guide to adding embedded SQL dashboards to your SaaS product — covering architecture, authentication, multi-tenancy, and when to build vs. buy.
Best Data Science Institute in Delhi with 100% Placement Assistance
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Best Data Science Institute in Delhi with 100% Placement Assistance
Wondering if a Data Science Course in Delhi is worth it for career growth in 2026? With businesses increasingly adopting Artificial… Continue reading on Medium