Tech Skills

Data Analytics & Business Intelligence

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

14,277
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,815) Articles (2191)Blog Posts (2254)Tutorials (312)Research Papers (31)News (27)
Your Data Engineering Learning Path: 2026 Edition
Dev.to · Krunal Kanojiya 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Your Data Engineering Learning Path: 2026 Edition
Data engineering in 2026 is not what it was three years ago. The job has expanded. Modern data...
Goldman Sachs IB Associates Score 39.7 Out of 100. The Data Explains Why.
Dev.to · Alex Bell 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Goldman Sachs IB Associates Score 39.7 Out of 100. The Data Explains Why.
Goldman Sachs Investment Banking is supposed to be the hardest finance interview. The data says...
Company Registry Data Tools for Business Intelligence
Dev.to · NexGenData 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Company Registry Data Tools for Business Intelligence
Company registry data is the backbone of every credible KYC, KYB, and M &A workflow — yet it...
Addressing the global namespace
Dev.to · Joichiro Mitaka 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Addressing the global namespace
There is a moment in every data hoarder's life — and in every small media shop's IT history — when...
Day 35 – ClickHouse® and S3 Integration: Querying Data Lakes
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Day 35 – ClickHouse® and S3 Integration: Querying Data Lakes
Introduction Modern organizations generate massive amounts of data that need to be stored...
Debugging Data Unload Failures in GBase — How to Handle Invalid Data and Export Breakdowns
Dev.to · Scale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Debugging Data Unload Failures in GBase — How to Handle Invalid Data and Export Breakdowns
In enterprise database systems, exporting data is a critical operation for analytics, backup, and...
Building Reliable Data Pipelines in GBase — Transactions, Validation, and Export Stability
Dev.to · Scale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Building Reliable Data Pipelines in GBase — Transactions, Validation, and Export Stability
In enterprise data systems, reliability is measured not only by how data is stored, but also by how...
Ensuring Data Integrity in GBase — From Transactions to Reliable Data Export Pipelines
Dev.to · Scale 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Ensuring Data Integrity in GBase — From Transactions to Reliable Data Export Pipelines
In modern enterprise systems, data integrity is not only about storing correct values—it is about...
Building a Sports Data Pipeline: Lessons from Scotland primed for game of their lives against fallible Brazil
Dev.to · Muhammad Bin Nazeer 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
Building a Sports Data Pipeline: Lessons from Scotland primed for game of their lives against fallible Brazil
Building a Sports Data Pipeline: Lessons from Scotland primed for game of their lives...
What 86 Days of Clean Prediction-Market History Actually Shows
Dev.to · manja316 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 6d ago
What 86 Days of Clean Prediction-Market History Actually Shows
I archived 17.2M Polymarket price snapshots on one Mac. Here's what the resolved data says about whether the crowd is actually calibrated — and how to check it
STATISTICS MATTERS IN DATA SCIENCE
Dev.to · Diana Wachenje 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
STATISTICS MATTERS IN DATA SCIENCE
Introduction Statistics is a branch of applied mathematics that helps one to collect,...
49/60 Days System Design Questions
Dev.to · Joud Awad 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
49/60 Days System Design Questions
Your data team just opened a $4,200 BigQuery bill. For a single month. One analyst. 12 queries. The...
Giant Killings in Champions League: Data Analysis of 30 Years of Upsets
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Giant Killings in Champions League: Data Analysis of 30 Years of Upsets
The night of March 6, 2017, will forever be etched into the memory of football fans worldwide. AS...
How to Fetch Real-Time Options Chain Data in Python (Without Paying $99/mo)
Dev.to · Salomon 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How to Fetch Real-Time Options Chain Data in Python (Without Paying $99/mo)
If you've ever tried to pull live options data into a Python script, you've probably hit the same...
UFC Underdog ROI: I Tracked 500 Fights to Find Systematic Mispricings
Dev.to · Edge Lab 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
UFC Underdog ROI: I Tracked 500 Fights to Find Systematic Mispricings
"The sharps are cleaning up in the UFC betting markets while casual bettors get slaughtered." That...
Apache Data Lakehouse Weekly: June 17 to June 24, 2026
Dev.to · Alex Merced 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Apache Data Lakehouse Weekly: June 17 to June 24, 2026
This week the lakehouse community spent most of its energy on two questions. The first is how the...
Day 34: Advanced ClickHouse® Aggregating Functions
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 34: Advanced ClickHouse® Aggregating Functions
Advanced ClickHouse® Aggregating Functions Introduction Aggregation is one of...
Your Pipeline Is 29.2h Behind: Catching World Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Your Pipeline Is 29.2h Behind: Catching World Sentiment Leads with Pulsebit
Your Pipeline Is 29.2h Behind: Catching World Sentiment Leads with Pulsebit We recently...
Azure Data Engineering Interviews Score 11 Points Below Standard Roles: What 15,000 Live Sessions Show
Dev.to · Alex Bell 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Azure Data Engineering Interviews Score 11 Points Below Standard Roles: What 15,000 Live Sessions Show
Data Engineering Interview Scores Reveal a Gap Candidates Are Not Preparing For Candidates...
The Bosman Effect, in one open dataset: how World Cup squads went global (1990 to 2026)
Dev.to · Maria-Luise Volkmar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Bosman Effect, in one open dataset: how World Cup squads went global (1990 to 2026)
In 1990, roughly one in four players at the FIFA World Cup was based at a club outside the country...
Building a Financial Reconciliation Platform, Not a Matching Engine
Dev.to · Salil Chincholikar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building a Financial Reconciliation Platform, Not a Matching Engine
Most reconciliation projects start with a simple assumption. Find two records with matching...
Understanding Apache Airflow Architecture: How the Engine Runs Your Workflows
Dev.to · grace wambua 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Understanding Apache Airflow Architecture: How the Engine Runs Your Workflows
Introduction To run data pipelines reliably in real-world production, you must understand...
Merges and Mutations in ClickHouse®
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Merges and Mutations in ClickHouse®
Introduction One of the reasons ClickHouse® delivers exceptional analytical performance is...
Understanding Data Distributions and Their Importance in Data Science
Dev.to · Tom Chege 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Understanding Data Distributions and Their Importance in Data Science
Introduction One of the most important concepts in statistics and data science is the...
The Fastest Way to Add Reporting to Your Internal Tool
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Fastest Way to Add Reporting to Your Internal Tool
Stop building reports from scratch. Here's the fastest path from raw SQL data to a working internal dashboard your team will actually use.
A CSV Cross-Check Before Receiving Shopify Purchase Orders
Dev.to · 王磊 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
A CSV Cross-Check Before Receiving Shopify Purchase Orders
When Shopify purchase orders rely on linked transfers, the records can drift even when each screen...
Simon Willison's Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
datasette 1.0a35
Release: datasette 1.0a35 I'll write more about this one tomorrow, but it's a big release. Three highlights from the release notes: New "Create table" interface
Most CSV libraries go one way or skip types. csv-pipe does both, typed, and parses several times faster than papaparse. Live playground in the post.
Dev.to · Myroslav Martsin 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Most CSV libraries go one way or skip types. csv-pipe does both, typed, and parses several times faster than papaparse. Live playground in the post.
csv-pipe: read and write CSV in TypeScript, several times faster than papaparse ...
SyntheholDB for Pharma & Clinical Research Teams: Stop Letting Data Access Kill Your Pipeline
Dev.to · Jitendra Devabhaktuni 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
SyntheholDB for Pharma & Clinical Research Teams: Stop Letting Data Access Kill Your Pipeline
Published on dev.to · Target audience: Pharma engineers, CROs, clinical data architects,...
Day 31: Ingesting Data from Kafka into ClickHouse®
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 31: Ingesting Data from Kafka into ClickHouse®
Introduction Real-time data ingestion is a fundamental requirement for modern analytics...
Data Science Workload: Giới hạn RAM trên Dell Pro Max 14 MC14250
Dev.to · Review Laptop 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Science Workload: Giới hạn RAM trên Dell Pro Max 14 MC14250
Trong lĩnh vực Data Science, việc quản lý tài nguyên hệ thống là một bài toán cân não. Khi bạn chạy...
Understanding Subqueries and CTEs in SQL: A Complete Guide
Dev.to · Stephen Omengo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Understanding Subqueries and CTEs in SQL: A Complete Guide
Working with relational databases often requires breaking down complex problems into manageable...
Common Pitfalls in Scaling A/B Testing Programs
VWO Blog 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Common Pitfalls in Scaling A/B Testing Programs
Teams often kickstart A/B testing programs with a handful of tests backed by a straightforward process and a shared doc. That works well enough at low volume. E
Architectural Blueprint: Building a Low-Latency Analytics Pipeline for High-Capacity Physical Venues
Dev.to · stampiq 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Architectural Blueprint: Building a Low-Latency Analytics Pipeline for High-Capacity Physical Venues
When building data pipelines for enterprise-scale physical spaces—such as a 20,000-attendee corporate...
Building an Analytics Layer on Top of Your Existing Database
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Building an Analytics Layer on Top of Your Existing Database
Your production database wasn't built for reporting. Here's how to add a proper analytics layer with read replicas, materialized views, and smart SQL patterns —
Data Modeling, Joins, Relationships and Schemas
Dev.to · Young Odhiambo 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Data Modeling, Joins, Relationships and Schemas
Data Modeling Data modeling is the process of creating a structured and visual...
The Apple Books data model
Dev.to · Kevin Alemán 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
The Apple Books data model
Apple Books stores everything about your reading on disk, in plain SQLite. Your books, your...
TYPES OF JOINS
Dev.to · Jedidah Ondiso 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
TYPES OF JOINS
In Power BI, joins are primarily used in Power Query (during the "Merge Queries" step) to combine...
Buscando o primeiro emprego na área de TI.
Dev.to · VICTAL 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Buscando o primeiro emprego na área de TI.
Estou procurando minha primeira oportunidade na área de TI, eu sou Analista de Dados Júnior, minha...
Cohort Retention Analysis in Excel - Without SQL
Dev.to · Waqas R 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Cohort Retention Analysis in Excel - Without SQL
If you want to know whether customers actually stick around, a cohort retention table is the clearest...
🚀 Top Data Analytics Project Ideas for Beginners and Professionals
Dev.to · Sapana Pal 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
🚀 Top Data Analytics Project Ideas for Beginners and Professionals
If you're learning Data Analytics and looking to build a strong portfolio, working on real-world...
Day 30 of 100 Days of ClickHouse® - Using ClickHouse® Arrays for Complex Data Structures
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Day 30 of 100 Days of ClickHouse® - Using ClickHouse® Arrays for Complex Data Structures
Introduction Modern analytical workloads often involve working with multi-valued and...
Snowflake vs Databricks, BigQuery vs Redshift? The 2026 Guide to Right-Sizing Your Data Platform
Dev.to · Aditya Somani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Snowflake vs Databricks, BigQuery vs Redshift? The 2026 Guide to Right-Sizing Your Data Platform
TL;DR Big data platforms like Snowflake and BigQuery impose high pricing floors, like...
How Uber Built Its Big Data System — From a Few TBs to 350 Petabytes with Sub-Hour Latency
Dev.to · Lê Đình Phú 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
How Uber Built Its Big Data System — From a Few TBs to 350 Petabytes with Sub-Hour Latency
A deep-dive into Uber's three architectural generations — from a Vertica warehouse to a Hadoop data lake, to Apache Hudi — and the engineering decisions behind
Stop Funding History: Building a Demand Prediction App to Optimize Trade Spend
Dev.to · Malawige Inusha Thathsara Gunasekara 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Stop Funding History: Building a Demand Prediction App to Optimize Trade Spend
Let’s be honest: in the FMCG (Fast-Moving Consumer Goods) space, trade marketing budgets are almost...
By the Numbers: The Fascinating Data Behind 100 Million Nebility Customers
Dev.to · ersajay 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
By the Numbers: The Fascinating Data Behind 100 Million Nebility Customers
Behind every great brand is a story. But behind every great global brand is data — millions of data...
Why Statistics is the Invisible Backbone of Data Science
Dev.to · Venus-Kennedy 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Why Statistics is the Invisible Backbone of Data Science
INTRODUCTION In the hype-fueled world of tech, data science is often painted as a futuristic...
Van HTML-tabel naar SQL INSERT Statements in Eén Klik
Dev.to · circobit 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1w ago
Van HTML-tabel naar SQL INSERT Statements in Eén Klik
Je hebt data op een website gevonden. Je hebt het in je database nodig. De workflow is meestal:...