Tech Skills

Data Analytics & Business Intelligence

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

9,251
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

Showing 254 reads from curated sources

Beyond the Gold: What the 2026 Winter Olympics Data Actually Tells Us
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Beyond the Gold: What the 2026 Winter Olympics Data Actually Tells Us
The closing ceremony of the Milano Cortina 2026 Winter Olympics has left us with the familiar sight of Norway atop the leaderboard. But if… Continue reading on
Three Systematic Bots Trading BTC on Polymarket: A Three-Day Snapshot
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Three Systematic Bots Trading BTC on Polymarket: A Three-Day Snapshot
For the last several months I have been building and running a small fleet of systematic bots that trade BTC Up/Down markets on Polymarket… Continue reading on
Why Bhubaneswar Is Emerging as a Promising Hub for Data Science Talent in Eastern India
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Why Bhubaneswar Is Emerging as a Promising Hub for Data Science Talent in Eastern India
Bhubaneswar, long recognized for its cultural heritage and administrative significance, is now undergoing a remarkable digital… Continue reading on Medium »
From MQTT to SQL: A Practical Guide to Sensor Data Ingestion
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
From MQTT to SQL: A Practical Guide to Sensor Data Ingestion
Per-message SQL inserts fail at scale because MQTT streams clash with transactional databases. This guide shows how time-window batching, TimescaleDB hypertable
Can’t Copy Text from a PDF? Here Are 5 Practical Ways to Fix It
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Can’t Copy Text from a PDF? Here Are 5 Practical Ways to Fix It
Have you ever run into this frustrating situation: after finally finding an important PDF report or academic paper, you realize it’s… Continue reading on Medium
Decision Intelligence (DI) Over Business Intelligence (BI)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Decision Intelligence (DI) Over Business Intelligence (BI)
The numbers are clear, the patterns are visible, and still, the hardest part is deciding what to do with all of it. Continue reading on Medium »
Where Data, Operations, and Product Thinking Meet
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Where Data, Operations, and Product Thinking Meet
Most organisations don’t struggle with data or delivery. They struggle with connecting the two. Continue reading on Medium »
4 Python Libraries That Made My Projects Look Way More Advanced Than They Are
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
4 Python Libraries That Made My Projects Look Way More Advanced Than They Are
And Why I Still Use Them Even After 4+ Years of Python Continue reading on Level Up Coding »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Azure Data Engineering Training in Hyderabad
The data landscape has changed dramatically over the past decade. Organizations are no longer asking whether they should adopt cloud-based data platforms—they a
Unpacking the Yelp Dataset: A Guide to Data Loading and Cleaning
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Unpacking the Yelp Dataset: A Guide to Data Loading and Cleaning
Welcome to this guide on getting started with the Yelp business dataset! Continue reading on Medium »
Unpacking the Yelp Dataset: A Guide to Data Loading and Cleaning
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 5d ago
Unpacking the Yelp Dataset: A Guide to Data Loading and Cleaning
Welcome to this guide on getting started with the Yelp business dataset! Continue reading on Medium »
ArXiv cs.AI 📊 Data Analytics & Business Intelligence 📄 Paper ⚡ AI Lesson 5d ago
Latent patterns of urban mixing in mobility analysis across five global cities
arXiv:2604.12202v1 Announce Type: new Abstract: This study leverages large-scale travel surveys for over 200,000 residents across Boston, Chicago, Hong Kong, Lo
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
From Prism to Python: Scaling data analysis
Early in my drug discovery life, I used graphpad prism extensively to plot and analyze data. It worked great for one curve at a time, but… Continue reading on M
I trained an AI to read 200,000 app reviews so I didn’t have to. It found out users are not okay
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
I trained an AI to read 200,000 app reviews so I didn’t have to. It found out users are not okay
Here’s something no one talks about: the signal is already there. Continue reading on Medium »
When to Stop a Test Early Without Lying to Yourself
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
When to Stop a Test Early Without Lying to Yourself
Stopping tests early requires disciplined decision rules to avoid bias, misinterpretation, and costly self-deception under uncertainty Continue reading on Mediu
From Notebook to pip install: A Packaging Guide for Data Scientists
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
From Notebook to pip install: A Packaging Guide for Data Scientists
Most DS projects die in notebooks. Not because the work is bad. Because the output is untransferable. Here is how to fix that. Continue reading on Write A Catal
From Notebook to pip install: A Packaging Guide for Data Scientists
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
From Notebook to pip install: A Packaging Guide for Data Scientists
Most DS projects die in notebooks. Not because the work is bad. Because the output is untransferable. Here is how to fix that. Continue reading on Write A Catal
Why Your Fast Query Suddenly Got Slow: Storage & Retrieval Made Simple
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Why Your Fast Query Suddenly Got Slow: Storage & Retrieval Made Simple
Your app feels fast. Then one day a tiny feature lands, traffic rises, and one endpoint goes from 90ms to 1.4s. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
The Dual-Track Student: Balancing a Master’s Degree with Competitive Exam Prep
We’ve all heard that pursuing a Master’s degree is a full-time commitment. But what happens when your career ambitions require you to run… Continue reading on M
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
How To Produce Ultra-Compact Vector Graphic Plots With Orthogonal Distance Fitting
Generate high-quality, minimal SVG plots by fitting Bézier curves with an ODF algorithm. The post How To Produce Ultra-Compact Vector Graphic Plots With Orthogo
When Environmental Data Becomes Financial Infrastructure
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
When Environmental Data Becomes Financial Infrastructure
What the ISSB’s Nature Disclosure Shift Really Means Continue reading on Medium »
Bypassing the "Pandas RAM Tax": Building a Zero-Copy CSV Extractor in C
Dev.to · NARESH-CN2 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Bypassing the "Pandas RAM Tax": Building a Zero-Copy CSV Extractor in C
The Convenience Penalty Python is a masterpiece of productivity, but for high-volume data ingestion,...
The Question Behind the Question: What Stakeholders Actually Want When They Ask for Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
The Question Behind the Question: What Stakeholders Actually Want When They Ask for Data
The most important analyst skill isn’t SQL. It’s learning to hear what people aren’t saying. Continue reading on Stackademic »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Best Data Analytics Course Hyderabad — Learn How Data Drives Real Business Decisions
Master the fundamentals of data with a practical data analytics course Hyderabad. Learn how to collect, analyze, and visualize data using… Continue reading on M
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Analisi del periodo – breve guida
L’analisi del periodo serve a capire come sono collegate tra loro le proposizioni in una frase complessa. In pratica, si studia il rapporto tra le varie frasi c
How Predictive Analytics Helps Companies Make Better Decisions
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
How Predictive Analytics Helps Companies Make Better Decisions
In today’s fast-paced digital landscape, businesses are constantly seeking ways to stay ahead of the competition. One of the most powerful… Continue reading on
Experiment Evaluation in Practice: A Simple A/B Testing Example
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Experiment Evaluation in Practice: A Simple A/B Testing Example
A data-driven analysis of reminders and incentives Continue reading on Medium »
Understanding the Importance of a Global Research and Outsourcing Firm for Business Growth
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Understanding the Importance of a Global Research and Outsourcing Firm for Business Growth
Organizations are increasingly using data-driven insights to keep up with the current business environment, which is rapidly changing. A… Continue reading on Me
Memory Efficiency at Scale: Python Generators & Iterators
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Memory Efficiency at Scale: Python Generators & Iterators
Stop crashing your servers! Learn how to use Python's yield keyword to process millions of rows with nearly zero RAM usage. Continue reading on Python in Plain
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
O que é Estatística? Um guia para iniciantes
Estatística é uma palavra que muita gente já ouviu, mas poucas realmente entendem o impacto que ela tem no nosso dia a dia. Continue reading on Medium »
Cara Jago Sertifikasi BNSP Data Science: Bedah Transparansi Model dengan Explainable AI (XAI)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Cara Jago Sertifikasi BNSP Data Science: Bedah Transparansi Model dengan Explainable AI (XAI)
oleh Aditiya Widodo Putra, Data Scientist & Mathematics Expert Continue reading on Medium »
Cara Jago Sertifikasi BNSP Data Science: Bedah Transparansi Model dengan Explainable AI (XAI)
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Cara Jago Sertifikasi BNSP Data Science: Bedah Transparansi Model dengan Explainable AI (XAI)
oleh Aditiya Widodo Putra, Data Scientist & Mathematics Expert Continue reading on Medium »
- …
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
- …
Every morning, I used to check IPO news like most beginners do — scrolling through headlines, reading summaries, and trying to keep up. Continue reading on Medi
Modernizando a Gestão de Resíduos: O uso do Power BI no novo Boletim Interativo do Sistema MTR
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Modernizando a Gestão de Resíduos: O uso do Power BI no novo Boletim Interativo do Sistema MTR
A Transformação do Boletim Anual do Sistema MTR-RJ em uma Ferramenta de Business Intelligence. Continue reading on Medium »
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Range Over Depth: A Reflection on the Role of the Data Generalist
What has changed in the past five years in the role and importance of generalists in data teams The post Range Over Depth: A Reflection on the Role of the Data
Medium · Startup 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Calculate MRR, Churn, and LTV in PostgreSQL
Every SaaS founder eventually hits the same wall. Payments are flowing, subscriptions are growing, and your billing provider’s dashboard… Continue reading on Me
Unlocking Insights of Vehicle CO2 Emissions Using Python
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Unlocking Insights of Vehicle CO2 Emissions Using Python
In today’s data-driven world, understanding environmental impact through data analysis is a powerful skill. In this project, I explored a… Continue reading on M
Unlocking Insights of Vehicle CO2 Emissions Using Python
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Unlocking Insights of Vehicle CO2 Emissions Using Python
In today’s data-driven world, understanding environmental impact through data analysis is a powerful skill. In this project, I explored a… Continue reading on M
The Data Center Conversation We Can’t Ignore
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Data Center Conversation We Can’t Ignore
Introduction: The Invisible Backbone of the Digital World Continue reading on Medium »
Retirement Funds as Systems: Where Member Value Gets Diluted
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Retirement Funds as Systems: Where Member Value Gets Diluted
Why insight, governance, and operational execution do not always align in practice Continue reading on Medium »
You May Have Perfect Backups and Still Lose Everything
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
You May Have Perfect Backups and Still Lose Everything
Backup Best Practices for Data You Cannot Afford to Lose Continue reading on Medium »
This is How Yearly Comparative Column Charts should be in Power BI(.pbix included)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
This is How Yearly Comparative Column Charts should be in Power BI(.pbix included)
When it comes to visualizing yearly performance, column charts in Power BI are one of the most effective tools. They allow analysts… Continue reading on Power B
This is How Yearly Comparative Column Charts should be in Power BI(.pbix included)
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
This is How Yearly Comparative Column Charts should be in Power BI(.pbix included)
When it comes to visualizing yearly performance, column charts in Power BI are one of the most effective tools. They allow analysts… Continue reading on Power B
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
A Satisfação do Cliente Não é um Mistério. É uma Equação.
Como um modelo interpretável de IA revelou os fatores que controlam o NPS — e superou XGBoost, CatBoost e Random Forest no processo. Continue reading on Medium
Snowflake and Streamlit: A Single Connection Pattern for Seamless Local and Cloud Execution
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Snowflake and Streamlit: A Single Connection Pattern for Seamless Local and Cloud Execution
One of the most practical challenges when building data applications is ensuring that the same codebase runs consistently across… Continue reading on Medium »
The One-Hour Future: A Theory They Don’t Want You to Notice
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The One-Hour Future: A Theory They Don’t Want You to Notice
This is a strange discovery Continue reading on Medium »
Building Is Cheap. Knowing What to Build Isn’t
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building Is Cheap. Knowing What to Build Isn’t
Reflections on building tools at the boundary of math, software, and understanding Continue reading on Medium »
Beyond the Dashboard: Why Domain Intelligence is the New Front Line in Fraud Detection
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Beyond the Dashboard: Why Domain Intelligence is the New Front Line in Fraud Detection
I’ve spent the better part of my 30s staring at data. In my ten years in the analytics trenches, I’ve seen the same story play out a… Continue reading on Medium