Tech Skills

Data Analytics & Business Intelligence

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

16,808
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,340) Articles (3014)Blog Posts (3422)Tutorials (369)Research Papers (39)News (496)
Day 30 of 100 Days of ClickHouse® - Using ClickHouse® Arrays for Complex Data Structures
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 30 of 100 Days of ClickHouse® - Using ClickHouse® Arrays for Complex Data Structures
Introduction Modern analytical workloads often involve working with multi-valued and...
Snowflake vs Databricks, BigQuery vs Redshift? The 2026 Guide to Right-Sizing Your Data Platform
Dev.to · Aditya Somani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Snowflake vs Databricks, BigQuery vs Redshift? The 2026 Guide to Right-Sizing Your Data Platform
TL;DR Big data platforms like Snowflake and BigQuery impose high pricing floors, like...
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
When Address Data Breaks Bad: How We Matched and Fixed 100,000 Messy Records Without Losing Our…
A practical walkthrough of three matching approaches, a 30-character field limit nightmare, and the street-first strategy that actually… Continue reading on Med
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Encoding Categorical Data for Outlier Detection
Why one-hot encoding isn’t always the best approach, and alternative encodings The post Encoding Categorical Data for Outlier Detection appeared first on Toward
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
When Logic Ends, Humans Begin
SQL queries are supposed to be logical, predictable, and clean. Humans are none of those things. Continue reading on Medium »
How Uber Built Its Big Data System — From a Few TBs to 350 Petabytes with Sub-Hour Latency
Dev.to · Lê Đình Phú 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Uber Built Its Big Data System — From a Few TBs to 350 Petabytes with Sub-Hour Latency
A deep-dive into Uber's three architectural generations — from a Vertica warehouse to a Hadoop data lake, to Apache Hudi — and the engineering decisions behind
InfoQ AI/ML 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Presentation: Challenging Google Analytics: Building a Scalable, Cost-Effective User Tracking Service
Alina Krasavina explains how Delivery Hero successfully deprecated Google Analytics and migrated to an internal user tracking platform. She discusses how a simp
Stop Funding History: Building a Demand Prediction App to Optimize Trade Spend
Dev.to · Malawige Inusha Thathsara Gunasekara 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stop Funding History: Building a Demand Prediction App to Optimize Trade Spend
Let’s be honest: in the FMCG (Fast-Moving Consumer Goods) space, trade marketing budgets are almost...
What Nobody Tells Beginners About Learning Web Scraping
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What Nobody Tells Beginners About Learning Web Scraping
It’s not about the code. It’s about the quiet war with your own frustration. Continue reading on Medium »
By the Numbers: The Fascinating Data Behind 100 Million Nebility Customers
Dev.to · ersajay 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
By the Numbers: The Fascinating Data Behind 100 Million Nebility Customers
Behind every great brand is a story. But behind every great global brand is data — millions of data...
Why Statistics is the Invisible Backbone of Data Science
Dev.to · Venus-Kennedy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Statistics is the Invisible Backbone of Data Science
INTRODUCTION In the hype-fueled world of tech, data science is often painted as a futuristic...
Reddit r/Entrepreneur 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Got laid off 33 days ago. Here's everything I've built since.
Mined Google reviews of trades businesses. ended up finding found specific markets/ cities with genuine labor shortages Scraped conference booth buyers and noti
​The AI Wave: Why The Real Question Is Value
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
​The AI Wave: Why The Real Question Is Value
Most operators already have more data than their teams can realistically process.
Van HTML-tabel naar SQL INSERT Statements in Eén Klik
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Van HTML-tabel naar SQL INSERT Statements in Eén Klik
Je hebt data op een website gevonden. Je hebt het in je database nodig. De workflow is meestal:...
From Dashboards To Decisions: Why Enterprises Need An Answer Layer
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
From Dashboards To Decisions: Why Enterprises Need An Answer Layer
Every week you delay is a week your competitors may be moving from observation to action while you're still debating what the chart means.
17 million Polymarket price snapshots, collected on one Mac for $0/month
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
17 million Polymarket price snapshots, collected on one Mac for $0/month
Most prediction-market datasets you find online are a one-time dump someone scraped, posted, and...
Web Scraping with APIs: A Complete Tutorial with Real Examples
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Web Scraping with APIs: A Complete Tutorial with Real Examples
A Hands-On Python Guide to Extracting Clean Data Efficiently Continue reading on Data Engineer Things »
The Month-End Close is Broken: How Modern Accountants Are Automating Financial Document Extraction
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Month-End Close is Broken: How Modern Accountants Are Automating Financial Document Extraction
Why Are Highly Trained CPAs Still Doing Manual Data Entry? Continue reading on Medium »
What Topics Are Covered in Statistics for Data Science?-IABAC
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
What Topics Are Covered in Statistics for Data Science?-IABAC
Statistics is one of the most important parts of Data science. Many learners start with excitement. They think about charts, predictions… Continue reading on Me
How Understanding Probability Distributions Made Me Better at Data Analysis
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Understanding Probability Distributions Made Me Better at Data Analysis
The Hidden Skill Behind Every Good Data Decision Continue reading on Artificial Intelligence in Plain English »
Connect Excel to a Database with Tens of Millions of Rows?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Connect Excel to a Database with Tens of Millions of Rows?
How do you connect Excel to a databases with tens of millions of rows.. and GBs of data? Continue reading on Medium »
Can a Customer Loyalty Model Predict Which Students Will Drop Out?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Can a Customer Loyalty Model Predict Which Students Will Drop Out?
What happened when we borrowed a 1987 marketing model to find at-risk university students before they failed. Continue reading on Medium »
Du Tableau HTML aux Instructions SQL INSERT en Un Clic
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Du Tableau HTML aux Instructions SQL INSERT en Un Clic
Vous avez trouvé des données sur un site web. Vous en avez besoin dans votre base de données. Le...
Data Modeling, Joins, Relationships and Schemas
Dev.to · Lameck Odhiambo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Modeling, Joins, Relationships and Schemas
Before data reaches its final used destination it needs to be organized in a structured way to enable...
Host Nation Advantage: Do USA, Canada, and Mexico Get a Statistical Boost?
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Host Nation Advantage: Do USA, Canada, and Mexico Get a Statistical Boost?
Here's a stat that'll surprise you: since 1930, host nations win the World Cup 26% of the time—nearly...
Distributions and Their Impact on Data Science
Dev.to · Samuel Mwai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Distributions and Their Impact on Data Science
Introduction Data science is built on the ability to extract meaningful insights from...
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 2w 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...