Tech Skills

Data Analytics & Business Intelligence

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

14,351
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 (4,889) Articles (2214)Blog Posts (2297)Tutorials (318)Research Papers (31)News (29)
I tried testing the pareto principle out — It's not always true!
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
I tried testing the pareto principle out — It's not always true!
This project started from a small annoyance, and led to really understanding the 80 20 rule. Continue reading on Medium »
Do Caos à Estrutura: Por que a Indexação no Pandas é um Game-Changer?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Do Caos à Estrutura: Por que a Indexação no Pandas é um Game-Changer?
Você já tentou encontrar uma informação específica em uma planilha gigante apenas “contando as linhas”? Se sim, você sabe o quão… Continue reading on Medium »
.loc vs .iloc: Qual a diferença?
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
.loc vs .iloc: Qual a diferença?
Embora pareçam similares, usá-los de forma correta é o que separa um código robusto de um script cheio de erros silenciosos. Continue reading on Medium »
.loc vs .iloc: Qual a diferença?
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
.loc vs .iloc: Qual a diferença?
Embora pareçam similares, usá-los de forma correta é o que separa um código robusto de um script cheio de erros silenciosos. Continue reading on Medium »
The Living City: Urban Pulse, Flow, and Breath
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
The Living City: Urban Pulse, Flow, and Breath
Exploring the hidden rhythms of urban life through geospatial data science, interactive visualization, and Python. Continue reading on Medium »
The Living City: Urban Pulse, Flow, and Breath
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
The Living City: Urban Pulse, Flow, and Breath
Exploring the hidden rhythms of urban life through geospatial data science, interactive visualization, and Python. Continue reading on Medium »
The Living City: Urban Pulse, Flow, and Breath
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
The Living City: Urban Pulse, Flow, and Breath
Exploring the hidden rhythms of urban life through geospatial data science, interactive visualization, and Python. Continue reading on Medium »
Reddit r/learnprogramming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
question about DS the stack
can you explain how the stack is connected to the backtracking algorithms(maze, file directories) and calling functions(call stack) everything inside () was giv
Building Medicaid Data Platforms That Scale Across States
Hackernoon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Building Medicaid Data Platforms That Scale Across States
Multi-state Medicaid platforms become difficult to scale when state-specific business rules are embedded directly in application code. This article argues for c
Launch Your Data Science Career: How to Choose the Best Data Science Institute in Trivandrum
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Launch Your Data Science Career: How to Choose the Best Data Science Institute in Trivandrum
Data has become the driving force behind innovation in today’s digital world. From predicting customer behavior to improving healthcare… Continue reading on Med
Reddit r/learnprogramming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
How can I build an automated system to gather date from a BMS app?
Hi, part of my job is to plot specific data from charging and discharging a battery via its BMS (battery management system) app periodically. It would make my l
Who is Montu Das? Building Clean Data Pipelines and Global SEO Authority
Medium · SEO 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Who is Montu Das? Building Clean Data Pipelines and Global SEO Authority
In today’s fast-paced digital marketplace, physical borders no longer limit your market reach. Continue reading on Medium »
Ad-Hoc Video Analytics with DuckDB on Parquet Exports from Production SQLite
Dev.to · ahmet gedik 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Ad-Hoc Video Analytics with DuckDB on Parquet Exports from Production SQLite
Exporting trending-video metadata from production SQLite to hive-partitioned Parquet and running cro
Post 23: The History of Data — It’s Older Than You Think
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Post 23: The History of Data — It’s Older Than You Think
Data science feels like a modern buzzword — but humans have been collecting, analysing and learning from data for centuries. Continue reading on Medium »
What Drives the Nigerian Naira? Part 2
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
What Drives the Nigerian Naira? Part 2
Python | pandas | statsmodels | scipy | yfinance | matplotlib | seaborn Jan 2024 — Jun 2026 | 30 monthly observations | 3 variables | 6… Continue reading on Med
People Analytics: Uma abordagem estatística para retenção de talentos e diminuição de Turnover…
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
People Analytics: Uma abordagem estatística para retenção de talentos e diminuição de Turnover…
Tradicionalmente, as decisões relacionadas à gestão de pessoas têm sido tomadas com base na experiência dos gestores, na intuição, na… Continue reading on Mediu
Why Is Your Power BI Dashboard So Slow? 🐌
Dev.to · Bethuel Ngetich 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Why Is Your Power BI Dashboard So Slow? 🐌
Have you ever opened a dashboard and it took forever for it to load? Before blaming Power BI, take a...
Coefficient of Correlation and Coefficient of Determination
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Coefficient of Correlation and Coefficient of Determination
Continue reading on Medium »
How Long Does Food Last? The USDA Food Storage Guide (Made Searchable)
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
How Long Does Food Last? The USDA Food Storage Guide (Made Searchable)
A faster, ad-free, and USDA-backed expiration calculator for every item in your kitchen. Continue reading on Medium »
How to Analyze Storefront Elements by Revenue Impact, Not Just CTR
Dev.to · Sylwester Kowal 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
How to Analyze Storefront Elements by Revenue Impact, Not Just CTR
Most ecommerce teams can tell you where traffic comes from. Fewer teams can tell you which storefront...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Why Hypothesis Testing Is the Most Underrated Skill in Data Science.
A coffee shop, a new recipe, and the question every data scientist has to answer Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Understanding Relationship Schemas and Joins in Power BI
When I first started learning Power BI as part of my coursework in Data Science, Analytics, and AI, I thought the exciting part would be… Continue reading on Me
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Mapping audience engagement patterns: A quick EDA scanning public likers across 27 media posts
I recently wanted to see if I could answer a straightforward question: Can we effectively map out initial audience interaction and… Continue reading on Medium »
Meet appendToExcel: The Command-Line Tool You Didn't Know You Needed
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Meet appendToExcel: The Command-Line Tool You Didn't Know You Needed
appendToExcel is a command-line utility that writes CSV-formatted data into an Excel workbook (.xlsx). It can append data to the next… Continue reading on Mediu
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Data Science Course in Kerala — Build a Future-Ready Career with Zoople Technologies
In today’s digital era, data has become one of the most valuable assets for businesses across every industry. Continue reading on Medium »
I Ordered My Usual Food Again. But Was I Really Happy With That Choice?
Medium · UX Design 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
I Ordered My Usual Food Again. But Was I Really Happy With That Choice?
A completed order tells the business what I bought. It doesn’t always explain why I bought it. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Data Science Course in Kochi — Build a Successful Career with Zoople Technologies
The demand for data-driven professionals is growing rapidly across every industry. Organizations today rely on data to make informed… Continue reading on Medium
10 Excel Functions Every Data Analyst Should Know
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
10 Excel Functions Every Data Analyst Should Know
Excel remains one of the most important tools in data analytics. Even with advanced tools like Power BI and SQL, Excel continues to play a… Continue reading on
From Hunch to Backtest
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
From Hunch to Backtest
Understanding a trick isn’t the same as having it. This is the story of how we turned an intuition into a written strategy, ran it against… Continue reading on
A published win rate is the actor auditing itself
Dev.to · Mike Czerwinski 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
A published win rate is the actor auditing itself
Seven Telegram signal channels advertise 70 to 80 percent win rates. I ran a shadow-mode bot for two months and audited 17 months of their message history: 9,31
Apache Spark in Microsoft Fabric: How It Handles Big Data and Makes Your Life Easier
Dev.to · Anshul Jangale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Apache Spark in Microsoft Fabric: How It Handles Big Data and Makes Your Life Easier
If you've ever tried to process millions of rows of data in a regular tool like Excel or even a basic...
I Tracked My Body Fat for 90 Days and Built a Calculator That Actually Makes Sense
Dev.to · dayu2333-jinyul 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
I Tracked My Body Fat for 90 Days and Built a Calculator That Actually Makes Sense
For three months, I weighed myself every morning and took body measurements every Sunday. I used a...
Competitor Pricing Intelligence: SaaS + Shopify Combined
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Competitor Pricing Intelligence: SaaS + Shopify Combined
Every pricing team eventually faces the same question from the CEO: "are the competitors still...
The Other Side of the Content Pipeline
Dev.to · Robert Floyd Dugger 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
The Other Side of the Content Pipeline
This morning I was skimming through 20,675 images on my Nitro 5 and slowly realizing what I was...
Why *= 2 is slower than = col * 2 in Pandas — and what strace shows about abstraction cost
Dev.to · Patrick Ryan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Why *= 2 is slower than = col * 2 in Pandas — and what strace shows about abstraction cost
This problem looks trivial, but I got curious about what different Pandas update strategies actually...
CSV File Difference Detection Techniques for Large Datasets - Paradane
Dev.to · Paradane 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
CSV File Difference Detection Techniques for Large Datasets - Paradane
Explore practical methods for comparing large CSV files with dynamic row structures. Learn Python-based approaches and schema alignment strategies to handle mul
I built a dataset of 50,000 debugging sessions — and what I found surprised me
Dev.to · Abhishek Singh 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
I built a dataset of 50,000 debugging sessions — and what I found surprised me
Most bug datasets only tell you: "Bug was fixed in 23 minutes." They don't tell you what happened...
Finding Breakout Stocks Across Daily, Weekly & Monthly — And Ranking the Best (Part 4)
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Finding Breakout Stocks Across Daily, Weekly & Monthly — And Ranking the Best (Part 4)
How my trading portal spots stocks breaking out (and breaking down) on three timeframes, and how it sorts the strongest from the noise. Continue reading on Medi
Data Cleaning and Translation Hell: The 2,000-Recipe Disaster: Why Data Cleaning is the Ultimate AI…
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Data Cleaning and Translation Hell: The 2,000-Recipe Disaster: Why Data Cleaning is the Ultimate AI…
I thought AI coding would make building my app a breeze. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
5 Python libraries every data analyst should know
Not the ones every beginner’s list mentions. The ones that actually show up in real analysis work — with the one-liner that makes each… Continue reading on Medi
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
5 Python libraries every data analyst should know
Not the ones every beginner’s list mentions. The ones that actually show up in real analysis work — with the one-liner that makes each… Continue reading on Medi
−10°C Means Nothing to Your Dog
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
−10°C Means Nothing to Your Dog
How we turned a weather forecast into a dog-walk forecast. Continue reading on Medium »
The Instrument, the Wu-Hausman Test, and the Wardrobe
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Instrument, the Wu-Hausman Test, and the Wardrobe
How to build the perfect instrument, run the perfect test, and end up exactly where you started Continue reading on Medium »
Kafka Connect: Setting up and what the Docs skip
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Kafka Connect: Setting up and what the Docs skip
The Three Kafka Topics Running Your Connect Cluster and Why You Should Create Them Yourself Continue reading on Towards Data Engineering »
Smart Enough to Be Wrong Forever
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Smart Enough to Be Wrong Forever
Intelligence doesn’t guarantee better choices—it often makes better excuses Continue reading on The Quantastic Journal »
Microsoft Fabric Architecture Explained: The Complete 2026 Guide
Dev.to · Datta Sable 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Microsoft Fabric Architecture Explained: The Complete 2026 Guide
A complete technical guide to Microsoft Fabric architecture: OneLake, Lakehouse, Warehouse, Direct Lake, governance, security, and certification paths.
Advanced Exploratory Data Analysis (EDA) with Plotly, Streamlit and OpenAI
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Advanced Exploratory Data Analysis (EDA) with Plotly, Streamlit and OpenAI
Create dynamic charts that allow deeper exploration and interpretability of the data using the combination of Pandas, Plotly and OpenAI Continue reading on TDS
Sharp Money vs Public Money: What Betting Line Movement Data Reveals
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Sharp Money vs Public Money: What Betting Line Movement Data Reveals
The opening kickoff of Super Bowl LVII was still three weeks away when sharp bettors began their...