Tech Skills
Data Analytics & Business Intelligence
Excel, SQL, Power BI, Tableau — turn raw data into business decisions
Skills in this topic
7 skills — Sign in to track your progress
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

Dev.to · Soren
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How Excel is Used in Real-World Data Analysis
Microsoft Excel is a spreadsheet application developed by Microsoft that allows users to store,...

Dev.to · Kanishga Subramani
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Day 3 of 100 Days of ClickHouse® - ClickHouse® vs PostgreSQL
ClickHouse® vs PostgreSQL: Understanding the Differences Between OLAP and OLTP Databases One of the...

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
The Analytics Data Product Playbook
Recently Funding Circle took place in the Data Science Festival’s Big Birthday Bash! This was a great opportunity for us to connect with… Continue reading on Fu

Dev.to · Waqas R
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How we built a 10,000-run Monte Carlo simulator for the 2026 World Cup
The 2026 World Cup is the first with 48 teams and 104 matches, which makes it a genuinely interesting...
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
I Got Tired of Writing the Same Energy Data Integrations Over and Over Again
One of the less glamorous realities of working in energy is that a surprising amount of time is spent collecting data. Not analysing it… Continue reading on Med

Dev.to · Marco Gazerro
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
If the warehouse already has the data, why are we copying it elsewhere?
When we started working on Krenalis, we spent a lot of time reviewing how customer data typically...

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
From Big Pharma to the Computational Self: Mapping the Next 50 Years of Medicine
For most of modern history, medicine has been organized around a grand fiction: the “average patient”. Continue reading on Medium »

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Why Your R-Squared is High but Your Model Still Sucks
By the end of this article, you’ll not only understand MAE, MSE, RMSE, R², Adjusted R², and Standard Error — you’ll know how they talk to… Continue reading on M

Dev.to · Ntech Global Solutions
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How Data Science Is Transforming Banking and Finance in 2026
The banking and finance industry has undergone a remarkable digital transformation over the last...
![[Biostatistics Series #5] Interpreting Coefficients Is Easy… Until You Add Interaction Terms](https://cdn-images-1.medium.com/max/1536/1*bB65HuimfK66vGATK9Hccw.png)
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
[Biostatistics Series #5] Interpreting Coefficients Is Easy… Until You Add Interaction Terms
One of the exam questions I was always excited to encounter was coefficient interpretation. Continue reading on Medium »

Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How many spreadsheets does your firm use every day?
Client trackers. Compliance schedules. Document lists. Workflow reports. Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Feature Selection 101: A Data Scientist’s Guide to Noise Reduction, Model Interpretability, and…
“More data is almost always better, but more features can be a curse. Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How Data Science Is Transforming Banking and Finance in 2026
The banking and finance industry has undergone a remarkable digital transformation over the last decade. With the rise of artificial… Continue reading on Medium

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Can Certifications Help You Land Fresher Data Science Jobs-IABAC
No experience. No connections. No clear starting point. That feeling is more common than you think. Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Best Data Science Course in Ahmedabad for Future AI Professionals
AI is reshaping industries at lightning speed. In healthcare, finance, e-commerce, and cybersecurity, companies are leaning on data-driven… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
I Generated a Fake Dataset for a Prototype. It Asked Better Questions Than Six Weeks of Research.
Sample data is not filler. It is the most underrated thinking tool in AI prototyping. Continue reading on Bootcamp »

Dev.to · Gabriel Mbuva
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How Excel is Used in Real-World Data Analysis
Introduction Excel is one of the most used tools for data analysis. It allows beginners...
Reddit r/datascience
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
What is the most common reason data science projects fail to deliver business value?
Iam curious whether the biggest challenges are related to data quality, stakeholder alignment, model adoption, business understanding, or something else entirel

Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Why measurement errors on transaction monitoring performance metrics matter
Transaction monitoring (TM) performance metrics are often treated as precise facts. In reality, they are estimates — subject to… Continue reading on Medium »

Dev.to · Mwai Victor Brian
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How Excel Is Used in Real-World Data Analysis
Introduction Excel is an application to store, organise, and analyse data in a...

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Why is Python used in Data Analytics?
Python is widely used in Data Analytics because it is simple, powerful, and supported by a huge ecosystem of tools. Here are the main… Continue reading on Mediu
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Chladni Patterns: From Symbolic Mechanism to Numerical Reality
Why the patterns look so organic, and how to actually reproduce them. Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Challenges and Lessons from Using LIDA for Dynamic Visualizations
Challenges and Lessons from Using LIDA for Dynamic Visualizations Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Data Analytics vs Data Science vs Machine Learning: Which Path Should You Choose
Three terms everyone throws around — and what they actually mean for your career. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Rahasia Mengolah Data Lebih dari 100.000 Baris di Excel dengan Cepat
Mengolah data dalam jumlah besar sering menjadi tantangan bagi banyak pengguna Microsoft Excel. Ketika jumlah data mencapai lebih dari… Continue reading on Medi

Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Kesalahan Data Cleaning yang Sering Dilakukan Pemula di Excel
Dalam proses analisis data, kualitas hasil sangat bergantung pada kualitas data yang digunakan. Data yang masih mengandung kesalahan… Continue reading on Medium

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Kesalahan Data Cleaning yang Sering Dilakukan Pemula di Excel
Dalam proses analisis data, kualitas hasil sangat bergantung pada kualitas data yang digunakan. Data yang masih mengandung kesalahan… Continue reading on Medium

Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
The Customer Asked For Export their data, I Thought It Was A Button
It starts with a small question, can we export our data?, then ya its not that easy hahahha Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Why the 90-Page Market Report is Dying (And What’s Replacing It)
If you look at how traditional consumer research happens in India, it usually follows a rigid script. A company wanting to launch a new… Continue reading on Med

Medium · AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Most of Your Data Is Empty on Purpose
The emptiness is not a defect. It is the business, written down. And teaching a machine to read it is worth more than the model that sits… Continue reading on M

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Most of Your Data Is Empty on Purpose
The emptiness is not a defect. It is the business, written down. And teaching a machine to read it is worth more than the model that sits… Continue reading on M

Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Understanding Apache Airflow, dbt, Azure Data Factory, and Microsoft Fabric Through Real-World…
The Question That Started Everything Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Understanding Apache Airflow, dbt, Azure Data Factory, and Microsoft Fabric Through Real-World…
The Question That Started Everything Continue reading on Medium »

Medium · Programming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Panduan Membuat Peta Dasar di ArcGIS, QGIS, dan Perangkat Lunak SIG Lainnya
5520125031076 | Informatika | Universitas Faletehan Continue reading on Medium »
Reddit r/datascience
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Potential grad job lined up - how best to prepare?
I’m have a potential grad position lined up starting in July. It’s starting out in more of a BI Analyst/Report Development type of role before working under a D
Dev.to AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Why Are More Enterprises Choosing Snowflake for Data Management?
Introduction Data has become one of the most valuable assets for modern organizations. From customer interactions and financial transactions to operational metr
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Implementing Customer Segmentation in Python: From Transactions to Actionable Customer Groups
Last week, we defined the data structure and modeling approach for customer segmentation using RFM features and clustering. This week, we… Continue reading on M
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Implementing Customer Segmentation in Python: From Transactions to Actionable Customer Groups
Last week, we defined the data structure and modeling approach for customer segmentation using RFM features and clustering. This week, we… Continue reading on M
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Implementing Customer Segmentation in Python: From Transactions to Actionable Customer Groups
Last week, we defined the data structure and modeling approach for customer segmentation using RFM features and clustering. This week, we… Continue reading on M
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
From Gambling Tables to Bell Curves: The History of Statistical Distributions
How gamblers, astronomers, a brewer, and a few brilliant mathematicians built the tools that power modern data analysis. Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How I Work With Stakeholders Who Don’t Speak “Data”
This post is part of my 2026 series, From Insight to Impact, where I explore what practical, real-world analytics looks like beyond theory… Continue reading on

Dev.to · Shaan Satsangi
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
I built a Databricks medallion lakehouse to roast my own YouTube history (Bronze Silver Gold Existential Dread)
There's a normal way to analyze your YouTube watch history. You export it from Google Takeout, open a...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How to migrate from PHIL to AKITA
How to Migrate From PHIL to AKITA Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
I Analyzed 49,378 Football Matches to Win My Office World Cup Pool
Then I tried to make the model smarter. Every upgrade made it worse. Continue reading on Startup Stash »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
IDCA Exclusive Inside Look | LinkedIn Data Center
IDCA takes an exclusive look inside LinkedIn data centers. Hear from IDCA and LinkedIn about how the world’s #1 professional social media… Continue reading on M

Dev.to · elliott cordo
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Redshift Check-In: Spring 2026
I have a soft spot for Amazon Redshift. One of my early clients was a pre-GA adopter, potentially...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
The Most Expensive Data Platform Is Usually the One You Already Have
When organizations evaluate data management software, the conversation often starts with price: How much does it cost per month? How much… Continue reading on M
TechCrunch AI
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Meta steals a tactic from Tesla and builds data centers in tents
Meta may have one found one way to slash its massive data center bill: tents.
DeepCamp AI