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

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
How Data Science Is Expanding Professional Opportunities in Patna’s Evolving Job Market
Patna’s professional landscape is gradually changing as businesses, institutions, and entrepreneurs adopt digital tools to improve… Continue reading on Medium »
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Event Time vs Processing Time in Flink -Why it matters more than you think
The three clocks Flink knows about, and why picking the wrong one gives you numbers that are confidently wrong Continue reading on Towards Data Engineering »

Dev.to · kevincarroll
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
How to Convert PDF and Excel Invoices to CSV for Faster Data Processing
Manually converting invoice data from PDF or Excel files into CSV format is one of the most...

Dev.to · Lucas
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
I scored 8,000 Seoul cafes for laptop-workability from review keywords
How I turned messy Naver review keywords into a "workability score" for 8,000+ Seoul cafes, aggregated it by district, and published the whole thing as a free d

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Apache Spark Mastery (Part 2 of 6): Hands-On with Databricks & DataFrames
A beginner-to-interview-ready series on Apache Spark with PySpark and Databricks. Continue reading on Medium »

Dev.to · Jenpo Zhan
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
A Historical FX Reference Report for CSV, API, and Spreadsheet Workflows
FXpeek's annual reference report for dated exchange-rate lookup, CSV exports, widgets, and lightweight JSON API workflows.

Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Reviewing P-value
Yes, I am going back to the basics, reviewing the concept of P-value, after soullessly reading and accepting that “P-value < 0.05 as… Continue reading on Medium

Dev.to · beefed.ai
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Dashboards and KPIs for Mechanical Completion Reporting
Design effective completions dashboards: choose KPIs, model data for Power BI/Tableau, visualize progress, and automate distribution to stakeholders.

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
How I Build Client-Ready Investment Charts in Under 5 Minutes with Python
Your clients don’t care about your backtest. They care about whether they can understand the chart you put in front of them. Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Data is the New Oil. But Can You Refine It?
I still remember the first time I came across words like ANOVA, MANOVA, MANCOVA, Factor Analysis, Clustering, Logistic Regression,etc. Continue reading on Mediu
Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Data Science vs Retail Realities: Demystifying Regression Evaluation Metrics
When building machine learning models to predict continuous values — like housing prices, stock trends, or supermarket clearance discounts… Continue reading on
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Data Science vs Retail Realities: Demystifying Regression Evaluation Metrics
When building machine learning models to predict continuous values — like housing prices, stock trends, or supermarket clearance discounts… Continue reading on

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Beyond the Dashboard: How Tracking Actually Improves Operations
After a decade in operations management, I have seen countless leaders fall into the exact same trap. They build beautiful dashboards… Continue reading on Mediu

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Why Does Visibility Change Behavior? The Science Behind Metrics That Move People
Understanding the psychology that turns dashboards into action Continue reading on Medium »

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Building a Flight Data Pipeline Without Trusting AI
A few months ago I was cleaning up my GitHub and found this repo — https://github.com/dat-a-ish/data-gov. It was built at that weird… Continue reading on Medium

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
My Zero-to-Hero Roadmap: How to Transition into Data Science with a Non-CS Background
Every time I look at a job description for a Data Scientist role, the first requirement almost always scares people away: “Degree in… Continue reading on Medium

Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
1. The “Creative” Angle: The Art of Data Science: A Deep Dive into Feature Construction
Stop expecting your algorithms to do all the work. Learn how to construct the custom features that actually boost predictive power. Continue reading on Medium »

Medium · JavaScript
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
CanvasXpress: An Extended Grammar of Graphics Over Tidy Data
Most JavaScript charting libraries give you chart types. Continue reading on Bootcamp »

Medium · LLM
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Ingesting Hacker News, dev.to, Lobsters, Stack Exchange, and Product Hunt without getting banned
Six APIs, six personalities. A field guide to scraping public communities politely — including the source that closed its door and what I… Continue reading on M

Dev.to · Amailuk Joseph
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Can You Be a Data Scientist Without Statistics? Yes. Should You?
Can Data Science Do Without Statistics? 1. Introduction: The Debate Nobody Wants...

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Sequential A/B Testing with Sequential Probability Ratio Test
This post will cover Sequential A/B testing and address some of the problems that sequential A/B testing creates compared to traditional… Continue reading on Me

Medium · Machine Learning
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
The Geography of Climate-Mortgage Risk: Why Zip Codes Matter More Than Credit Scores
For decades, mortgage credit risk has been told as a story about the borrower. Credit score, debt-to-income ratio, loan-to-value, payment… Continue reading on M

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
What Matters Next Week in Equities
Markets don’t move in straight lines — they move in regimes. Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
The Sentient Trading Society Rejects Cycle-Based Technical Analysis
In this article, I explain why we at the Sentient Trading Society reject unfalsifiable cycle theories. Continue reading on InsiderFinance Wire »
Dev.to · Xinglin Ming
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Data Cleaning Automation: The Complete Python Guide
Automate your data cleaning pipeline with Python. Handle duplicates, missing values, dates, and outliers.

Dev.to · Peter Fabricius
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Writing Iceberg tables with Apache Hop and DuckDB
Introduction With my Iceduck project, I’ve been diving deep into Data Lakehouse...

Hackernoon
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
I Built an Open-Source Firebase Analytics Alternative Because I Hit 1M Events/Day Once Too Many
A few years ago I was the data engineer on a mobile game soft launch when Firebase Analytics quietly started dropping events past its 1M/day cap. We didn't catc

Dev.to · Suzy Chase
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
I Used AI as a Personal Data Analyst. It Changed Everything.
The Problem After losing 50 pounds on a GLP-1, I thought the hard part was over. It wasn't. The...
Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
How Autonomous Analytics Is Changing the Future of Data Science
Data science has evolved dramatically over the last decade. Businesses once relied on static reports and historical data analysis to guide… Continue reading on

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Launch Your Career with a Data Analyst Course: The Smart Choice for Future Professionals
In today’s data-driven world, organizations rely on data to make informed decisions, improve business performance, and identify new… Continue reading on Medium

KDnuggets
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Practical SQL Tricks Every Data Scientist Should Know
In this article, we’ll cover essential SQL patterns and workflows that make everyday data analysis cleaner, faster, and easier to scale.

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Weekend Geospatial Python Bootcamp: 4 Courses to Learn GeoPandas, Rasterio & PostGIS Fast
Build real-world geospatial data skills in one weekend with hands-on Python projects and practical workflows. Continue reading on Tierra Insights »

Dev.to · Kanishga Subramani
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Day 26 of 100 Days of ClickHouse: Understanding Distributed Tables
As your data grows, a single ClickHouse server may eventually reach its limits. Whether it's storage,...

Dev.to · Analyst Kinywa
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
I Analyzed 100,000+ Rows Using Only Excel and It Completely Changed How I Think About Data
“Real data analysis starts with Python or SQL.” That’s what I believed too until I spent weeks...

Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Data Analytics and AI Training | Real-Time Projects & Placement Support | Quality Thought
Upgrade Your Skills. Lead with AI. Continue reading on Medium »

Dev.to · Olamide Olaniyan
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
I Built a Match-Day Social Listening Dashboard for the World Cup in a Weekend
I wanted a single screen that told me what the internet was feeling during a World Cup match — which...
Reddit r/datascience
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Ideas for testing data science workflows on self hosted Linux based HPC cluster.
Hi all, Mid–Senior Data Scientist here. I currently work in a team that develops and maintains several fairly large-scale data science projects on a self-hosted

MIT Technology Review
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
The inevitable weakness of metrics
There are plenty of useful things a metric can reveal. There are even more it can obscure or corrupt. It took me well over a decade of tracking my own life in e
Medium · Python
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
EDA
xploratory Data Analysis (EDA) on the Iris Dataset Continue reading on Medium »

Dev.to · NelimaL
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Why Statistics is the Secret Weapon Behind Data Science- Healthcare analytics
"Without statistics, data is just a collection of numbers. With statistics, data becomes...

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
5 Kesalahan yang Sering Membuat Peserta Gagal Sertifikasi Microsoft Power BI
Sertifikasi Microsoft Power BI menjadi salah satu kredensial yang banyak dicari oleh calon maupun profesional data analyst. Continue reading on Medium »

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Skill Power BI yang Sering Diuji Saat Technical Interview Data Analyst
Power BI menjadi salah satu tools yang paling sering muncul dalam proses rekrutmen data analyst. Banyak perusahaan tidak hanya menanyakan… Continue reading on M

Dev.to · FLOW by Vestelon
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
I analyzed 500+ bank statements. Here's what I found.
I Analyzed 500+ Bank Statements. Here's What I Found. Over the past few months, while...

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Have Movies Lost Their Legs?
An opening-weekend analysis through the years Continue reading on The Ugly Monster »

Dev.to · Open Craft
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Building Production Data Pipelines for Enterprise AI: What Actually Has to Work
Most enterprise AI projects don't fail because the model is wrong. They fail because the data feeding the model is unreliable, stale, or structurally

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
The Overloaded Equals Sign
Every equals sign is a quiet decision about what to ignore — and that decision builds the integers, the real numbers, and the surface of a… Continue reading on

Dev.to · Vivek Kumar
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
How to Embed a SQL Dashboard into Your SaaS App (Without Building Everything from Scratch)
A practical guide to adding embedded SQL dashboards to your SaaS product — covering architecture, authentication, multi-tenancy, and when to build vs. buy.

Medium · Data Science
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2w ago
Best Data Science Institute in Delhi with 100% Placement Assistance
Wondering if a Data Science Course in Delhi is worth it for career growth in 2026? With businesses increasingly adopting Artificial… Continue reading on Medium
DeepCamp AI