Tech Skills

Data Analytics & Business Intelligence

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

16,813
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,345) Articles (3018)Blog Posts (3422)Tutorials (370)Research Papers (39)News (496)
Beyond the Grid: Engineering Surgical BI Dashboards with Next.js and Canvas APIs
Dev.to · Datta Sable 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Beyond the Grid: Engineering Surgical BI Dashboards with Next.js and Canvas APIs
The Crisis of "Slow Data" In the high-stakes worlds of Fintech and Global Sales, a...
How to Transition from a Traditional Data Warehouse to a Modern Lakehouse
Dev.to · Lucy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How to Transition from a Traditional Data Warehouse to a Modern Lakehouse
If your data warehouse feels slow, expensive, or hard to scale, you are not alone. Many teams are...
IDs First, Profiles Later: A Cheaper Way to Analyze Follower Graphs
Dev.to · Dacid Chain 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
IDs First, Profiles Later: A Cheaper Way to Analyze Follower Graphs
Most audience-analysis projects start with one deceptively simple question: Which people are shared...
Extracting Publication Data from Substack
Dev.to · Mathieu K 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Extracting Publication Data from Substack
If you have a substack account, like me, you are probably wondering how the articles are stored and...
In investigations, assumptions kill
Dev.to · Ahmed Algrgawy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
In investigations, assumptions kill
Like Jack Reacher once said: “In investigations, assumptions kill.” I think the same thing happens...
Sessions vs Page Views vs Users — What Each One Actually Counts
Dev.to · toshihiro shishido 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Sessions vs Page Views vs Users — What Each One Actually Counts
The 3 web analytics metrics everyone mixes up. Clear definitions, the base inequality (PV ≧ Sessions ≧ Users), which one to look at first, and how GA4 computes
Designing a Query Performance Insights Dashboard
Dev.to · beefed.ai 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Designing a Query Performance Insights Dashboard
Build a Query Performance Insights dashboard that surfaces EXPLAIN plans, latency, resource contention, and slow query attribution for fast triage.
PostHog Custom Surveys: Beyond the Default UI
Dev.to · gulnur 📊 Data Analytics & Business Intelligence 1mo ago
PostHog Custom Surveys: Beyond the Default UI
PostHog provides a powerful analytics and experimentation platform, including built-in surveys for...
WhyAnalyst: Why Every Data-Driven Decision Needs Better Analysis
Dev.to · muhammad naveed 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
WhyAnalyst: Why Every Data-Driven Decision Needs Better Analysis
Here is the link of app : https://whyanalyst-438909629186.asia-south1.run.app/ In today’s world, data...
Excel Training in Kerala for Advanced Spreadsheet Management and Reporting
Dev.to · Nick Joy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo 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...
Junior Data Engineers Are Getting Wiped Out. Seniors Are Thriving.
Dev.to · DataDriven 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Junior Data Engineers Are Getting Wiped Out. Seniors Are Thriving.
52K+ tech cuts in Q1 2026, junior DE roles hit hardest. AI is doing entry-level work now. Here's the brutal split , and how to land on the right side.
Von der Web-Tabelle zum Pandas DataFrame in 30 Sekunden
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo 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 1mo 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...
SQL Transactions and Write Conflicts
Dev.to · Rinon Tendrinomena 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
SQL Transactions and Write Conflicts
In databases, transactions are one of the most important concepts for ensuring data correctness,...
10 SQL changes. One took 30 seconds. It cut query time by 85%.
Dev.to · <devtips/> 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
10 SQL changes. One took 30 seconds. It cut query time by 85%.
A 2015 research paper tested every tip against real data. Most developers have never seen it. The...
Data Warehouse Design for Data Engineering Interviews: A Beginner's Guide to Fact Tables, Star Schemas, and Grain
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Warehouse Design for Data Engineering Interviews: A Beginner's Guide to Fact Tables, Star Schemas, and Grain
Data warehouse design is the discipline of laying out tables so analytical questions are fast,...
Snowflake for Data Engineering Interviews: A Beginner's Guide to the Cloud Data Warehouse
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Snowflake for Data Engineering Interviews: A Beginner's Guide to the Cloud Data Warehouse
Snowflake is the cloud-native data warehouse most modern data teams stand on — it stores petabytes,...
Amazon Redshift for Data Engineering — Columnar Storage, MPP, COPY, Distribution Keys, Spectrum
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Amazon Redshift for Data Engineering — Columnar Storage, MPP, COPY, Distribution Keys, Spectrum
Amazon Redshift is the AWS cloud data warehouse that data engineers reach for when an analytical...
# From DBA to Data Engineer: Leveraging Database Expertise for Robust Data Pipelines
Dev.to · pranith m 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo 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 1mo 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",...
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 1mo 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...
Lakebase, Meet PDB: The "Third-Generation" Database Oracle Shipped in 2013
Dev.to · Rick Houlihan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Lakebase, Meet PDB: The "Third-Generation" Database Oracle Shipped in 2013
By Rick Houlihan & Patrick Meredith Databricks named the right problem. Their answer is a...
Introducing KORE: 50x Faster Than Parquet, 10x Smaller Than JSON
Dev.to · sai arun kumar katherashala 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Introducing KORE: 50x Faster Than Parquet, 10x Smaller Than JSON
Introducing KORE: 50x Faster Than Parquet, 10x Smaller Than JSON Published: May 11,...
Inner vs Outer Joins: The Two Fundamental Join Types in SQL
Dev.to · Michael 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Inner vs Outer Joins: The Two Fundamental Join Types in SQL
SQL joins fall into two fundamental categories — inner joins and outer joins — while LEFT, RIGHT, and...
The Future of Business Intelligence: Integrating AI and Machine Learning
Dev.to · Argha Sarkar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Future of Business Intelligence: Integrating AI and Machine Learning
Business Intelligence, or BI, is a system that enables companies to understand and analyze their...
The Great Data Debate: Should You Build Your Warehouse Top-Down or Bottom-Up?
Dev.to · Lawrence Murithi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo 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...
Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE
Go beyond window function basics and unlock the real power of LEAD, LAG, RANK, DENSE_RANK, and NTILE with real-world examples for analytics, reporting, and data
Data Analyst Interview Questions 2026: What Actually Shows Up Across All Three Rounds
Dev.to · ManyOffer Career 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Analyst Interview Questions 2026: What Actually Shows Up Across All Three Rounds
Most candidates preparing for data analyst interviews in 2026 treat the whole thing like a SQL exam....
Python and Its Role in the Data Analytics Space
Dev.to · Wangila russell 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo 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...
[06] Portfolio Defense Dashboard — One Screen to Rule Your Morning
Dev.to · soy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
[06] Portfolio Defense Dashboard — One Screen to Rule Your Morning
Everything comes together in a single Streamlit dashboard. Real-time portfolio tracking, margin alerts, dividend projections, and stress tests — all in one scre
How Engineering Teams Can Build Data Pipelines That Drive Revenue
Dev.to · Tricon Infotech 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Engineering Teams Can Build Data Pipelines That Drive Revenue
Data pipelines are often treated as plumbing. Something that needs to work, something that gets fixed...
Google Analytics 4: access data via Data API (Step-by-step)
Dev.to · Sasireka Balasubramaniyam 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo 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...
Python in Data Analytics: A Practical Starting Point
Dev.to · Kahuthu Muriuki 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python in Data Analytics: A Practical Starting Point
I started learning Python not because I wanted to become a software developer, but because I kept...
Creating and Customizing Line Charts in Excel Using Python
Dev.to · Allen Yang 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Creating and Customizing Line Charts in Excel Using Python
Line charts are one of the most commonly used chart types for data visualization, particularly...
Du Tableau Web au DataFrame Pandas en 30 Secondes
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo 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...
Clean, Transform, and Load Data in Power BI: A Beginner-Friendly Guide
Dev.to · Temitope Hassan 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Clean, Transform, and Load Data in Power BI: A Beginner-Friendly Guide
Introduction Data is only as powerful as the shape it’s in. Before dashboards tell compelling stories...
The Silent Bug That Exposed All Tenant Data in Databricks Unity Catalog
Dev.to · spkibe 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Silent Bug That Exposed All Tenant Data in Databricks Unity Catalog
We were building a multi-tenant data platform on Databricks. Multiple organisations sharing the same...
How a Data Pipeline and Machine Learning Can Modernize DNA Paternity Testing in Kenya
Dev.to · Kipngeno Gregory 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How a Data Pipeline and Machine Learning Can Modernize DNA Paternity Testing in Kenya
A Pre-Research Article | Data Science, Data Pipelines & Genomic...
Data Lake Architecture for Data Engineering Interviews
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Lake Architecture for Data Engineering Interviews
Data lake architecture questions in data-engineering interviews almost always reduce to four...
Data Engineering Roadmap for Freshers (2026): A 13-Step Beginner's Guide from SQL to Your First Data Engineering Job
Dev.to · Gowtham Potureddi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Data Engineering Roadmap for Freshers (2026): A 13-Step Beginner's Guide from SQL to Your First Data Engineering Job
Data engineering is one of the fastest-growing tech careers in 2026. Companies collect huge amounts...
Building Your First Data Warehouse in Databricks — End to End 🎉
Dev.to · Vinicius Fagundes 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Building Your First Data Warehouse in Databricks — End to End 🎉
Building Your First Data Warehouse in Databricks — End to End 🎉 This is it. The article...
Reddit's Karma Score Is a Lie. Here's the Math Behind It.
Dev.to · Archit Agarwal 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Reddit's Karma Score Is a Lie. Here's the Math Behind It.
Two comments. Same subreddit. Same topic. Posted minutes apart. One has +847 karma. It sits at the...
Introduction to Python in Data Analytics
Dev.to · Martin Kamau 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Introduction to Python in Data Analytics
Python is a high-level programming language with various uses such as data analysis, web development,...
When does Iceberg beat Parquet+projection on AWS Glue, and when doesn't ?
Dev.to · Alessandra Bilardi 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
When does Iceberg beat Parquet+projection on AWS Glue, and when doesn't ?
Why this project I built this repo because I didn't have one of this kind yet and,...
The Invisible Wall: Hardening Your BI Infrastructure Against Modern Data Breaches
Dev.to · Datta Sable 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The Invisible Wall: Hardening Your BI Infrastructure Against Modern Data Breaches
The modern BI stack is a goldmine for attackers. While we focus on 'Insights,' we often overlook the...
How Python Powers Real-World Data Analytics
Dev.to · Mungai M. 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
How Python Powers Real-World Data Analytics
Python Isn't a Trend. It's the Standard. If you work with data in any capacity, whether...
Python for Data Analytics
Dev.to · Milcah Mukunza 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
Python for Data Analytics
INTRODUCTION If you've spent any time exploring data analytics, you've probably heard the name...
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 1mo 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.