Tech Skills

Data Analytics & Business Intelligence

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

16,731
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,266) Articles (2964)Blog Posts (3409)Tutorials (359)Research Papers (39)News (495)
Python for Data Science — Boxplots and Outlier Detection
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Boxplots and Outlier Detection
In the previous article, we used scatter plots to explore relationships between variables. Continue reading on Medium »
Python for Data Science — Scatter Plots and Relationships Between Variables
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Scatter Plots and Relationships Between Variables
In the previous article, we learned about three fundamental chart types: Continue reading on Medium »
Python for Data Science — Scatter Plots and Relationships Between Variables
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Scatter Plots and Relationships Between Variables
In the previous article, we learned about three fundamental chart types: Continue reading on Medium »
Python for Data Science — Scatter Plots and Relationships Between Variables
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Python for Data Science — Scatter Plots and Relationships Between Variables
In the previous article, we learned about three fundamental chart types: Continue reading on Medium »
Scraping Websites With Python: The Ultimate Beginner’s Introduction
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Scraping Websites With Python: The Ultimate Beginner’s Introduction
You want data from a website. There’s no download button, no API, no CSV export, just a wall of HTML. This is exactly the problem that… Continue reading on Medi
Stop Nesting: How to Optimize Your Data Mapping Performance
Dev.to · Jehadur Rahman (Emran) 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stop Nesting: How to Optimize Your Data Mapping Performance
Why You Should Stop Using Nested Loops for Data Mapping Nested loops are a common pitfall in software...
Are You Looking for a Career Switch into Analytics?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Are You Looking for a Career Switch into Analytics?
In today’s data-driven world, businesses rely on data to make smarter decisions, improve customer experiences, and drive growth. As a… Continue reading on Mediu
Why Your Brain Hates Pie Charts (And What to Do About It)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Your Brain Hates Pie Charts (And What to Do About It)
The psychology of visual data, the problem with angles, and why the minimalist waffle chart is the elegant solution you’ve been looking… Continue reading on Med
Reddit r/datascience 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Weekly Entering & Transitioning - Thread 22 Jun, 2026 - 29 Jun, 2026
Welcome to this week's entering & transitioning thread! This thread is for any questions about getting started, studying, or transitioning into the data sci
CSV explained — the quirks that quietly corrupt your data (and how to avoid them)
Dev.to · William Andrews 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
CSV explained — the quirks that quietly corrupt your data (and how to avoid them)
CSV looks like the simplest file format there is. It isn't. A practical guide to delimiters, quoting, encoding, the Excel traps that destroy data, and how to pa
ARIMA & SARIMA: Model Statistik Klasik untuk Deret Waktu
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
ARIMA & SARIMA: Model Statistik Klasik untuk Deret Waktu
Membongkar tiga huruf ARIMA, lalu menambahkan “indra musim” lewat SARIMA, lengkap dengan perhitungan nyata untuk menentukan p, d, q. Continue reading on Medium
What 295,732 IPL balls reveal: chase to win, and the death overs are a different game
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What 295,732 IPL balls reveal: chase to win, and the death overs are a different game
I cleaned every IPL delivery from 2008 to 2026 into one tidy ball-by-ball table — 295,732 rows — and...
Mendelian Randomization in Clinical Epidemiology: Overcoming Confounding via Genetic Instruments
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Mendelian Randomization in Clinical Epidemiology: Overcoming Confounding via Genetic Instruments
In observational epidemiology, establishing a causal relationship between a risk factor (exposure) and a clinical outcome is notoriously… Continue reading on Me
How to Build a Credit Scoring Grid From a Logistic Regression Model?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Build a Credit Scoring Grid From a Logistic Regression Model?
Turning model coefficients into a 0–1000 score, with risk classes and stability checks Continue reading on Medium »
My Drone Amputated My Fingerprint, and I Refused to Leave the Data Unanalyzed
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
My Drone Amputated My Fingerprint, and I Refused to Leave the Data Unanalyzed
TL;DR: My FPV drone injured me. Instead of guessing what happened, I pulled the Blackbox flight data, cracked it open with Python, and let… Continue reading on
My Drone Amputated My Fingerprint, and I Refused to Leave the Data Unanalyzed
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
My Drone Amputated My Fingerprint, and I Refused to Leave the Data Unanalyzed
TL;DR: My FPV drone injured me. Instead of guessing what happened, I pulled the Blackbox flight data, cracked it open with Python, and let… Continue reading on
Why Statistics is the Real Backbone of Data Science
Dev.to · Menje 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Statistics is the Real Backbone of Data Science
The explosive rise of data science has made one thing clear: everyone wants to build the next...
Getting Started with Exploratory Data Analysis (EDA) in Python: A Beginner’s Practical Guide
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Getting Started with Exploratory Data Analysis (EDA) in Python: A Beginner’s Practical Guide
When I first started working with data, I was eager to jump straight into machine learning models and predictive analytics. Like many… Continue reading on Mediu
Getting Started with Exploratory Data Analysis (EDA) in Python: A Beginner’s Practical Guide
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Getting Started with Exploratory Data Analysis (EDA) in Python: A Beginner’s Practical Guide
When I first started working with data, I was eager to jump straight into machine learning models and predictive analytics. Like many… Continue reading on Mediu
Power BI Data Modeling Unleashed: Master Schemas, Relationships, and Joins for High-Performance Reporting
Dev.to · It's pronounced W3SHY 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Power BI Data Modeling Unleashed: Master Schemas, Relationships, and Joins for High-Performance Reporting
Whether you're brand new to Power BI or just getting started with data analytics, this guide walks...
My 3rd excel project
Dev.to · Mohammad Meezan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
My 3rd excel project
I picked up a random dataset of amazon book sales of 10 years from kaggle and started exploring and...
How Data Science Projects Fail (and What Developers Can Do Differently)
Dev.to · Eva Clari 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Data Science Projects Fail (and What Developers Can Do Differently)
Organizations spend millions of dollars building data science and machine learning capabilities. They...
Day 29 of 100 Days of ClickHouse® - Understanding Distributed Tables
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 29 of 100 Days of ClickHouse® - Understanding Distributed Tables
Introduction As datasets grow, a single ClickHouse® server may eventually become...
Monaco’s RCI registry: what you actually get from the data
Dev.to · OpenRegistry 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Monaco’s RCI registry: what you actually get from the data
Monaco lists roughly 14,000 active entities in the Registre du Commerce et de l’Industrie (RCI). The...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
3. Bölüm – İnsan Radarı
İnsanı tanımayan, hiçbir sistemi yönetemez. Continue reading on Medium »
Turning messy Airbnb / Vrbo / Booking.com payout CSVs into per-property profit
Dev.to · Lawrence Locke 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Turning messy Airbnb / Vrbo / Booking.com payout CSVs into per-property profit
Hosts rarely have a single clean ledger. Revenue comes from one export, platform fees from another,...
Why I built a CSV-first rental profit tracker — no Plaid, no bank login
Dev.to · Lawrence Locke 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why I built a CSV-first rental profit tracker — no Plaid, no bank login
Most short-term-rental finance tools start the same way: connect your bank through Plaid, link your...
From Privacy Compliance to Data Security — How GBase Helps Prevent Sensitive Data Exposure
Dev.to · Scale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Privacy Compliance to Data Security — How GBase Helps Prevent Sensitive Data Exposure
Organizations today face increasing pressure to protect sensitive information while still making data...
Modelling, Joins, Relationships and different Schemas
Dev.to · Pepsy-11y 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Modelling, Joins, Relationships and different Schemas
Data Modelling is the invisible architecture that structures your data so it is fast accurate and...
How I Built an Excel Dashboard With AI as My Planning Partner
Medium · ChatGPT 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How I Built an Excel Dashboard With AI as My Planning Partner
AI did not magically create a perfect dashboard, but it helped me build a clearer one because it forced me to define the story first. Continue reading on The Fi
Why Your Data Pipeline Works Perfectly… Until Real Users Arrive
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Your Data Pipeline Works Perfectly… Until Real Users Arrive
The day your clean architecture met reality Continue reading on Medium »
Why Your Data Pipeline Works Perfectly… Until Real Users Arrive
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Your Data Pipeline Works Perfectly… Until Real Users Arrive
The day your clean architecture met reality Continue reading on Medium »
7 Resume Bullet Transformations That Turn “Task Doer” into “Impact Owner”
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
7 Resume Bullet Transformations That Turn “Task Doer” into “Impact Owner”
A LinkedIn connection sent me his resume. He had 3 years of experience. Good company. Decent projects. Solid Python skills. Continue reading on Medium »
Why regex couldn't parse my invoices (and what did)
Dev.to · zhongqiyue 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why regex couldn't parse my invoices (and what did)
I spent three weekends building a regex pipeline for invoice data extraction. By the end of it, I had...
Reddit r/artificial 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Utah Data Center Brute Forced Through to Approval Despite Widespread Popular Opposition
A data center was forced through government approval in Utah despite the citizens widely opposing its impact on scarce water resources and numerous other object
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why You Keep Falling for Dumb Data Tricks (And How Simple Math Fixes It)
A math book made me rethink every “obvious” conclusion I’ve ever drawn — and honestly, it kind of wrecked me in a good way. Continue reading on Mr. Plan ₿ Publi
TournamentIQ — Intelligence System on FIFA World Cup 2026
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
TournamentIQ — Intelligence System on FIFA World Cup 2026
TournamentIQ is a live intelligence system that tracks team strength using Elo Ratings. Continue reading on Medium »
1.4.6 Aggregate Cost: Choosing HashAgg vs GroupAgg
Dev.to · JoongHyuk Shin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
1.4.6 Aggregate Cost: Choosing HashAgg vs GroupAgg
A query like SELECT region, COUNT(*) FROM sales GROUP BY region folds many rows together, collapsing...
1.4.4 Join Strategies: Nested Loop, Hash, Merge
Dev.to · JoongHyuk Shin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
1.4.4 Join Strategies: Nested Loop, Hash, Merge
The costs in 1.4.2 and 1.4.3 were about how to read a single table. A join combines two tables, and...
From Legacy Data Platforms to Modern Data Stacks: Why Metadata Matters More Than Technology
Dev.to · Amit Kumar Singh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Legacy Data Platforms to Modern Data Stacks: Why Metadata Matters More Than Technology
Introduction Organizations spend millions of dollars modernizing data platforms. They migrate from...
Data Science vs Artificial Intelligence: Understanding the Differences, Similarities, and…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Science vs Artificial Intelligence: Understanding the Differences, Similarities, and…
Learn how Data Science and Artificial Intelligence differ in skills, responsibilities, technologies, and career opportunities Continue reading on Medium »
They Weren’t Unhappy. They Were Underpaid.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
They Weren’t Unhappy. They Were Underpaid.
How analyzing 1,470 HR records uncovered a $13.9M retention problem and three assumptions that turned out to be completely wrong. Continue reading on Medium »
Understanding the Iris Dataset Through Exploratory Data Analysis
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Understanding the Iris Dataset Through Exploratory Data Analysis
Exploratory Data Analysis on the Iris Dataset Continue reading on Medium »
Citation Analysis at Scale: Track Research Trends with Semantic Scholar Data
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Citation Analysis at Scale: Track Research Trends with Semantic Scholar Data
The research landscape moves faster than any single researcher can keep up with. You might spend...
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Introduction to Pandas Series and DataFrames with Common Methods
If you work in the field of data analytics, you are probably familiar with Pandas. Pandas is a fast, flexible, and easy-to-use Python… Continue reading on Mediu
Vertical & Horizontal Bar Chart Plotting In Python with Matplotlib
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Vertical & Horizontal Bar Chart Plotting In Python with Matplotlib
This is a simple tutorial to plot the frequencies of your data labels using python. Continue reading on Medium »
Fitness Tracker Accuracy Testing Methodology: A Comprehensive Guide
Dev.to · Sam Chen 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Fitness Tracker Accuracy Testing Methodology: A Comprehensive Guide
Introduction Fitness trackers have become ubiquitous in our daily lives, promising to...
Building a Transparent Digital SAT Score Estimator Without Pretending It Is Exact
Dev.to · 陈科林 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building a Transparent Digital SAT Score Estimator Without Pretending It Is Exact
Score calculators look simple from the outside: enter a number of correct answers, apply a conversion...