Tech Skills

Data Analytics & Business Intelligence

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

16,858
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,387) Articles (3045)Blog Posts (3431)Tutorials (375)Research Papers (39)News (497)
Towards Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
7 Crucial Barriers Between Data Teams and Self-Healing Data Architecture
What data teams need to build with AI to make self-healing data architecture a practical reality The post 7 Crucial Barriers Between Data Teams and Self-Healing
Reddit r/MachineLearning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
TSAuditor: A time-series auditing framework [P]
This happened a few months ago when I was working on an analysis project that dealt with time-series data. The dataset was large (10 years of data). I was using
Product Mix Emerged as the Primary Driver of Profitability
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Product Mix Emerged as the Primary Driver of Profitability
The bicycle retail industry operates within a highly competitive environment where profitability is influenced not only by sales volume… Continue reading on Med
I Built an Interactive 3D Universe Map Connecting the Yin-Yang Diagram to 11 Scientific Fields
Dev.to · wenyumoney 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I Built an Interactive 3D Universe Map Connecting the Yin-Yang Diagram to 11 Scientific Fields
I built an unusual educational website: a bilingual (EN/ZH) platform that maps the ancient Taiji...
How Data Professionals Use AI — and What Really Matters
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How Data Professionals Use AI — and What Really Matters
I’ve been a data engineer for over 20 years. I started when “big data” meant a few terabytes and tuning queries by hand was half the job… Continue reading on Me
DiffusionGemma, Column-Level Data Lineage Engine, LLMs: The Hard Parts | Issue 93
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
DiffusionGemma, Column-Level Data Lineage Engine, LLMs: The Hard Parts | Issue 93
A weekly curated update on data science and engineering topics and resources. Continue reading on Medium »
Python vs R for data analysis — from a statistician’s perspective
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Python vs R for data analysis — from a statistician’s perspective
I trained as a statistician before I became a data scientist. That order matters more than people think when choosing between these two… Continue reading on Med
Python vs R for data analysis — from a statistician’s perspective
Medium · Python 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Python vs R for data analysis — from a statistician’s perspective
I trained as a statistician before I became a data scientist. That order matters more than people think when choosing between these two… Continue reading on Med
How Data Science Interviews Are Changing in the GenAI Era
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How Data Science Interviews Are Changing in the GenAI Era
The skills companies value today are very different from what they looked for just a few years ago. Continue reading on The Startup »
I stopped writing throwaway scripts for messy CSVs and just use SQL now
Dev.to · Herbert Tzekian 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
I stopped writing throwaway scripts for messy CSVs and just use SQL now
Someone sends you a CSV. Then a folder of CSVs. Then a CSV that's actually tab-separated but named...
Beyond the 80% Grind: Automated ETL and the Instant Synthetic Data Revolution
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Beyond the 80% Grind: Automated ETL and the Instant Synthetic Data Revolution
Is Your Modern Data Stack Still Running on Manual Labor? Continue reading on Medium »
Day 27 of 100 Days of ClickHouse® - Optimizing ClickHouse® Queries for Faster Execution
Dev.to · Kanishga Subramani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Day 27 of 100 Days of ClickHouse® - Optimizing ClickHouse® Queries for Faster Execution
Introduction As datasets grow larger and analytical workloads become more demanding, query...
From SQL Beginner to Intermediate: My SQL Learning Journey (Part 2)
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
From SQL Beginner to Intermediate: My SQL Learning Journey (Part 2)
When I decided to transition towards Data Engineering, I knew SQL would be the foundation of everything. Continue reading on Medium »
Master Data Analytics with AI at IDSA Janakpuri
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Master Data Analytics with AI at IDSA Janakpuri
Step into the future of analytics with the Data Analytics with AI Course at the Institute of Data Science and Analytics, Janakpuri… Continue reading on Medium »
AI Is Changing ETL Pipelines. But Not in the Way Most People Think!
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
AI Is Changing ETL Pipelines. But Not in the Way Most People Think!
What every Data Engineer needs to understand before AI becomes a standard part of every Data platform! Continue reading on Medium »
Your Hard Drive should not be the Graveyard of your Research Projects
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Your Hard Drive should not be the Graveyard of your Research Projects
Or why we built unpublished.pub Continue reading on Medium »
Data Analyst Salary in Kerala 2026: Skills That Increase Your Pay
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Analyst Salary in Kerala 2026: Skills That Increase Your Pay
Data is becoming one of the most valuable assets for businesses. From startups in Kochi to multinational companies in Thiruvananthapuram… Continue reading on Me
SalesIQ: Building a Full-Stack Sales Analytics Dashboard with AI — A Team’s Journey
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
SalesIQ: Building a Full-Stack Sales Analytics Dashboard with AI — A Team’s Journey
When our team sat down to plan our internship project, we knew we didn’t want to build “just another CRUD app.” We wanted something that… Continue reading on Me
How Data Moves: A Guide to Pipeline and Warehouse Patterns
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How Data Moves: A Guide to Pipeline and Warehouse Patterns
From transactional systems to trusted analytical data products Continue reading on Level Up Coding »
Why Statistics is Important in Data Science
Dev.to · jayson kibet 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why Statistics is Important in Data Science
Introduction Ask ten people what data science is and you'll hear things like...
The Readers Are Leaving Wikipedia. The Money Isn’t.
Medium · LLM 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Readers Are Leaving Wikipedia. The Money Isn’t.
Traffic to the world’s reference library has fallen by about a quarter in three years. The cause is stranger than the headlines suggest… Continue reading on Reg
Kesalahan yang Sering Dilakukan Pemula saat Belajar SQL dan Power BI
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Kesalahan yang Sering Dilakukan Pemula saat Belajar SQL dan Power BI
Di era data saat ini, SQL dan Power BI menjadi dua keterampilan yang paling banyak dicari dalam bidang analisis data. SQL digunakan untuk… Continue reading on M
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Brutal Truth About Becoming a Data Scientist in 2026 (And Why Python is Your Golden Ticket)
Let’s be real for a second. Aajkal har doosra insaan AI, machine learning, aur data science ki baat kar raha hai. It is easy to get… Continue reading on Medium
Chatting with your Data: Conversational Analytics in BigQuery
Dev.to · Aryan Irani 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Chatting with your Data: Conversational Analytics in BigQuery
For the last decade, the workflow for Business Intelligence hasn't changed much: A business...
How To Always Land Data Science Interviews
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
How To Always Land Data Science Interviews
Why you are not getting any callbacks Continue reading on Data Science Collective »
Snowflake’s one-page SEC demo treats structured filings as text
Medium · RAG 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Snowflake’s one-page SEC demo treats structured filings as text
Reading the Cortex one-pager, and why this is the textbook example of treating structured data as text. Continue reading on Data Science Collective »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Why I Chose Data Science Even Though I Started With Zero Experience
A year ago, if someone had asked me what Data Science was, I probably would have given a vague answer involving artificial intelligence… Continue reading on Med
The Hidden Cost of Data Bias: Why Your Analysis Might Be More Wrong Than You Think
Medium · Machine Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Hidden Cost of Data Bias: Why Your Analysis Might Be More Wrong Than You Think
We live in the age of data. Every day, companies make millions of decisions backed by analysis, algorithms, and insights derived from vast… Continue reading on
The Hidden Order of the Landscape: Adding Uncertainty to MapServer Interpolation
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
The Hidden Order of the Landscape: Adding Uncertainty to MapServer Interpolation
What working on interpolation in MapServer taught me about maps, uncertainty, and the mathematics of the unseen. Continue reading on Medium »
Understanding Data Structures by Building a Contact Book in Python
Medium · Programming 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Understanding Data Structures by Building a Contact Book in Python
Data structures sound scary. They are not. Let this simple project show you exactly what they are and why they matter. Continue reading on Medium »
Dev.to AI 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Data Analytics vs Data Science vs Business Intelligence
Data Analytics vs Data Science vs Business Intelligence: Understanding the Differences and Choosing the Right Career Path Data is everywhere. Every online purch
What I Wish I Knew Before Becoming a Data Scientist
Medium · Deep Learning 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
What I Wish I Knew Before Becoming a Data Scientist
When I first entered Data Science, I thought the profession was primarily about models. Continue reading on Medium »
Customer-Facing Analytics: What Your SaaS App Is Missing (And How to Add It)
Dev.to · Vivek Kumar 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Customer-Facing Analytics: What Your SaaS App Is Missing (And How to Add It)
Most SaaS apps collect tons of data but give customers almost nothing back. Here's what customer-facing analytics looks like in practice, and how to build it ri
Two Identical Claims. One Got Paid. The Difference Was a Single Form
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Two Identical Claims. One Got Paid. The Difference Was a Single Form
Two claims leave the billing system looking identical. Same patient, same procedure, same payer. One gets paid. The other gets denied, and… Continue reading on
Who Owns African Data?
Medium · Startup 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
Who Owns African Data?
A Plain-English Guide to Data Sovereignty on the Continent. Continue reading on Medium »
Medium · Data Science 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 2w ago
What a Dataset Cannot Tell You
I still remember the first time I opened a large survey dataset. Continue reading on Medium »
How Data Science Is Expanding Professional Opportunities in Patna’s Evolving Job Market
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 »
Event Time vs Processing Time in Flink -Why it matters more than you think
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 »
How to Convert PDF and Excel Invoices to CSV for Faster Data Processing
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...
I scored 8,000 Seoul cafes for laptop-workability from review keywords
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
Apache Spark Mastery (Part 2 of 6): Hands-On with Databricks & DataFrames
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 »
A Historical FX Reference Report for CSV, API, and Spreadsheet Workflows
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.
Reviewing P-value
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
Dashboards and KPIs for Mechanical Completion Reporting
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.
How I Build Client-Ready Investment Charts in Under 5 Minutes with Python
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 »
Data is the New Oil. But Can You Refine It?
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
Data Science vs Retail Realities: Demystifying Regression Evaluation Metrics
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
Data Science vs Retail Realities: Demystifying Regression Evaluation Metrics
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