Tech Skills

Data Analytics & Business Intelligence

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

9,911
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 716 reads from curated sources

One Case for Archetype Based Optimization: A Statistical Analysis of Slap Hitters Chasing Exit Velo
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
One Case for Archetype Based Optimization: A Statistical Analysis of Slap Hitters Chasing Exit Velo
The MLB is chasing velocity on both sides of the ball, but is this velocity important for everyone or do specific groups benefit more? Continue reading on Mediu
Excel Training in Kerala for Advanced Spreadsheet Management and Reporting
Dev.to · Nick Joy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Excel Training in Kerala for Advanced Spreadsheet Management and Reporting
Many fresh graduates in Kerala think Excel is just a basic office tool. But during interviews at...
Why Data Governance Fails When Only IT Is In The Room
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Why Data Governance Fails When Only IT Is In The Room
Data governance is how an organization builds the foundation for everything it wants AI to do. That foundation must belong to the business.
Von der Web-Tabelle zum Pandas DataFrame in 30 Sekunden
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Von der Web-Tabelle zum Pandas DataFrame in 30 Sekunden
Du hast den perfekten Datensatz gefunden. Er sitzt direkt da auf einer Webseite, sauber formatiert in...
How Business Intelligence Solutions in Dubai Are Transforming Decision-Making
Dev.to · InstaLogic 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
How Business Intelligence Solutions in Dubai Are Transforming Decision-Making
Business environments in Dubai are evolving at a rapid pace, driven by digital transformation, cloud...
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Why Should You Use a Concrete Vault?
The landscape of decentralized finance (DeFi) is evolving at a breakneck pace. For the individual participant, staying ahead often feels… Continue reading on Me
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
Why Should You Use a Concrete Vault?
​1️⃣ The Friction of the Current DeFi Experience ​For most participants, the current state of DeFi feels less like "passive income" and… Continue reading on Med
# From DBA to Data Engineer: Leveraging Database Expertise for Robust Data Pipelines
Dev.to · pranith m 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
# From DBA to Data Engineer: Leveraging Database Expertise for Robust Data Pipelines
The transition from a Database Administrator (DBA) to a Data Engineer is not a leap into the unknown;...
I Built a Database That Saves You From Googling 'PLA Temperature' Ever Again
Dev.to · keeper 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
I Built a Database That Saves You From Googling 'PLA Temperature' Ever Again
Every time I switch filament brands, the same ritual: Google "Bambu Lab PLA Basic temperature",...
We Analyzed 59,000 Mortgage Applications in Washington D.C.
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
We Analyzed 59,000 Mortgage Applications in Washington D.C.
A data science capstone that started with a simple question and ended up in uncomfortable territory. Continue reading on Medium »
We Analyzed 59,000 Mortgage Applications in Washington D.C.
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2d ago
We Analyzed 59,000 Mortgage Applications in Washington D.C.
A data science capstone that started with a simple question and ended up in uncomfortable territory. Continue reading on Medium »
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Day 0: My Roadmap for Transitioning from Finance to Data Science
Recently, I resigned from my job. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Day 0: My Roadmap for Transitioning from Finance to Data Science
Recently, I resigned from my job. Continue reading on Medium »
Python: The Engine Powering Modern Data Analytics A Beginner's Guide to Understanding Python's Role in Data Analytics
Dev.to · Martin Ndungu 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Python: The Engine Powering Modern Data Analytics A Beginner's Guide to Understanding Python's Role in Data Analytics
Python: The Engine Powering Modern Data Analytics A Beginner's Guide to Understanding Python's Role...
Understanding MySQL Commands with Flowcharts: A Beginner’s Guide
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Understanding MySQL Commands with Flowcharts: A Beginner’s Guide
Introduction: What is SQL and Why Does It Matter? Continue reading on Medium »
The Great Data Debate: Should You Build Your Warehouse Top-Down or Bottom-Up?
Dev.to · Lawrence Murithi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
The Great Data Debate: Should You Build Your Warehouse Top-Down or Bottom-Up?
Introduction Imagine you have a massive, disorganized garage. You need to clean it up so...
I Took a Break from Kaggle to Help a Local Shop. Here’s What I Built.
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
I Took a Break from Kaggle to Help a Local Shop. Here’s What I Built.
I absolutely love data analysis. There is something incredibly satisfying about taking a messy spreadsheet and turning it into a clear and… Continue reading on
Top Dagster Alternatives in 2026 | Data Orchestration Primer
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Top Dagster Alternatives in 2026 | Data Orchestration Primer
Learn about the up-and-coming platforms that beat Dagster at its own game Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Power BI FP&A Evolution 2026: Building Real-Time Financial and Operational Intelligence Platforms
Introduction In today’s fast-moving business environment, finance leaders are expected to make decisions faster than ever before. Traditional monthly reporting
Python and Its Role in the Data Analytics Space
Dev.to · Wangila russell 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Python and Its Role in the Data Analytics Space
Introduction Python is one of the most widely used programming languages in the world today. Over the...
5 PostgreSQL Query Patterns I Reuse For Business Analysis
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
5 PostgreSQL Query Patterns I Reuse For Business Analysis
Business analysis SQL usually does not start from a blank page. Continue reading on Medium »
How I Built a Chess Analytics Pipeline — and What Actually Made It Possible
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
How I Built a Chess Analytics Pipeline — and What Actually Made It Possible
Chess engines have solved the game, theoretically. But at the 2000-rated blitz level on Lichess — the level where most serious amateur… Continue reading on Medi
Python for Data Science & AI · Blog 08 of 20 — Data Cleaning With Pandas
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Python for Data Science & AI · Blog 08 of 20 — Data Cleaning With Pandas
80% of a data scientist’s time is spent cleaning data. Here’s how to do it fast, correctly, and without losing sleep. Continue reading on Medium »
Python for Data Science & AI · Blog 08 of 20 — Data Cleaning With Pandas
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Python for Data Science & AI · Blog 08 of 20 — Data Cleaning With Pandas
80% of a data scientist’s time is spent cleaning data. Here’s how to do it fast, correctly, and without losing sleep. Continue reading on Medium »
Python for Data Science & AI · Blog 08 of 20 — Data Cleaning With Pandas
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Python for Data Science & AI · Blog 08 of 20 — Data Cleaning With Pandas
80% of a data scientist’s time is spent cleaning data. Here’s how to do it fast, correctly, and without losing sleep. Continue reading on Medium »
Python for Data Science & AI · Blog 08 of 20 — Data Cleaning With Pandas
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Python for Data Science & AI · Blog 08 of 20 — Data Cleaning With Pandas
80% of a data scientist’s time is spent cleaning data. Here’s how to do it fast, correctly, and without losing sleep. Continue reading on Medium »
Google Analytics 4: access data via Data API (Step-by-step)
Dev.to · Sasireka Balasubramaniyam 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Google Analytics 4: access data via Data API (Step-by-step)
If you want to build a custom report or dashboard for your Google Analytics data in your app or...
Du Tableau Web au DataFrame Pandas en 30 Secondes
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Du Tableau Web au DataFrame Pandas en 30 Secondes
Vous avez trouvé le dataset parfait sur un site web. Maintenant vous en avez besoin dans...
Praktikum Struktur Data : Tree
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Praktikum Struktur Data : Tree
Halo selamat datang kembali dengan saya Imam Ghozali dari prodi Teknologi Informasi Universitas Tidar, kali ini saya akan menyampaikan… Continue reading on Medi
Praktikum Struktur Data : Tree
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Praktikum Struktur Data : Tree
Halo selamat datang kembali dengan saya Imam Ghozali dari prodi Teknologi Informasi Universitas Tidar, kali ini saya akan menyampaikan… Continue reading on Medi
banner
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
banner
The hidden cost of poor logging and monitoring Continue reading on Medium »
Building a Live Stock Portfolio Tracker in Python with yfinance and Rich
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Building a Live Stock Portfolio Tracker in Python with yfinance and Rich
A beginner Python project: fetch live NSE/US stock prices, calculate P&L, and display a colour-coded terminal dashboard, no API key… Continue reading on Medium
Curious How the ETL Process Actually Works in Real Companies?-IABAC
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Curious How the ETL Process Actually Works in Real Companies?-IABAC
Every company you know that works with apps, websites, or online services is quietly handling huge amounts of information every second… Continue reading on Medi
Geotab Study Ranks FIFA World Cup 2026 Cities Ability To Handle Crush
Forbes Innovation 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Geotab Study Ranks FIFA World Cup 2026 Cities Ability To Handle Crush
A study by telematics company Geotab Inc. rates the 16 FIFA World Cup 2026 host cities on their ability to handle the expected crush of people and vehicles.
Finally Sharing My favorite Intraday Trading Strategy
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Finally Sharing My favorite Intraday Trading Strategy
Camarilla Pivot Strategy: A Complete Guide to Trading the Golden Pivot Zone Continue reading on Medium »
What Is Anomaly Detection in Sales Data? A Practical Guide
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
What Is Anomaly Detection in Sales Data? A Practical Guide
When I review monthly sales reports, there’s always something that catches my eye: those numbers that don’t fit. An unexpected spike here… Continue reading on M
Finding the Hidden Signals in Sales Data
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 3d ago
Finding the Hidden Signals in Sales Data
A few months ago, I was reviewing our weekly pipeline dashboard when something felt off. Continue reading on Medium »
Bölüm 4: Aggregate Functions ve GROUP BY
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Bölüm 4: Aggregate Functions ve GROUP BY
SQL öğrenme serimin dördüncü bölümünde aggregate fonksiyonları ve GROUP BY ile veri gruplama konularını ele alacağım. Bu bölüm, SQL’in… Continue reading on Medi
What Really Determines a Developer’s Salary? Insights from 50,000 Developers
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
What Really Determines a Developer’s Salary? Insights from 50,000 Developers
What determines how much a developer earns? Is it a degree, years of experience, or the size of the company they work for? Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Introduction to Python in Data Analytics
In my quest to understand data and interpret, I found out that python is one of the important languages that is useful for analysis. So… Continue reading on Med
Are We Actually Getting Better? I Let 35 Years of Data Answer That
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Are We Actually Getting Better? I Let 35 Years of Data Answer That
Tools: Google Colab, Python, wbdata, pandas, NumPy, matplotlib, seaborn, World Bank Open Data API Continue reading on Medium »
Are We Actually Getting Better? I Let 35 Years of Data Answer That
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Are We Actually Getting Better? I Let 35 Years of Data Answer That
Tools: Google Colab, Python, wbdata, pandas, NumPy, matplotlib, seaborn, World Bank Open Data API Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
10 Years in Data Science: Why I Stopped Caring About datascience, career, python,Models and Started Mastering Feature Engineering
After a decade in Data Science, I realized that the most sophisticated models are useless without high-quality features. Feature engineering is the surgical par
The Paradox Is back
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Paradox Is back
In 1987, Robert Solow looked at two decades of corporate IT investment and wrote one of the most quoted lines in economics. “You can see… Continue reading on Me
Volatility Risk Premium in 30 Lines of Python (And the 5 Mistakes That Wreck It)
Dev.to · tomasz dobrowolski 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Volatility Risk Premium in 30 Lines of Python (And the 5 Mistakes That Wreck It)
The VRP formula, a worked SPY example, a 30-line Python implementation, and the five pitfalls that quietly produce a number that looks right but isn't.
Medium · AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Multimodal Analytics Is Arriving Faster Than Most Teams Realize
Multimodal analytics is arriving faster than most teams realize. Continue reading on Medium »
The Invisible Jury: Why Data Labeling Needs Audit Trails
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
The Invisible Jury: Why Data Labeling Needs Audit Trails
Moving beyond simple quality scores to a system of record that actually settles disputes. Continue reading on Medium »
Your Pipeline Is 26.4h Behind: Catching Climate Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 4d ago
Your Pipeline Is 26.4h Behind: Catching Climate Sentiment Leads with Pulsebit
Your Pipeline Is 26.4h Behind: Catching Climate Sentiment Leads with Pulsebit We recently stumbled...