Tech Skills
Data Analytics & Business Intelligence
Excel, SQL, Power BI, Tableau — turn raw data into business decisions
Skills in this topic
7 skills — Sign in to track your progress
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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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,...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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

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 ...

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,...

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...

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...

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...

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

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...

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 —

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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:...
DeepCamp AI