Advanced Data Analytics

Beyond the Spreadsheet.

A professional deep-dive into the distinct workflows, technical stacks, and decision cycles of BA, DA, BI, and DI.

The Landscape: Timeline of Intelligence

In a professional ecosystem, the timeline distinguishes the role. Intelligence (BI/DI) focuses on the past and present (the descriptive), while Analytics (DA/BA) leans toward the future (the predictive and prescriptive).

Intelligence (BI/DI)

"What happened and is the data reliable?"

Analytics (DA/BA)

"What will happen and what should we do?"

Feature BA DA
Goal Strategy Improvement Statistical Insight
Typical Tool Excel, Jira Python, R, SQL
The Question "Why need change?" "What trend predicts?"
Feature BI DI
Goal Performance Monitor Data Health
Typical Tool Power BI, Tableau Collibra, Alation
The Question "How much sold?" "Source of data?"

The Four Pillars Deep-Dive

Detailed workflows for modern decision science professionals.

BA

Business Analysis

The Bridge

Identifying business needs and determining solutions. BA is less about "math" and more about "method."

Focus: Requirements & Strategy
Key Skill: Gap Analysis (As-Is vs To-Be)
DA

Data Analysis

The Microscope

Cleaning, transforming, and modeling data to discover patterns, correlations, and future predictions.

Focus: Statistical Insight & EDA
Key Concept: Correlation vs. Causation
BI

Business Intelligence

The Mirror

The infrastructure for collecting and reporting performance metrics (KPIs) through dashboards.

Focus: Reporting & Dashboards
Key Tech: ETL & Data Warehousing
DI

Data Intelligence

The Foundation

Analyzing "data about data" (metadata). Focuses on data governance, trust, and lineage.

Focus: Data Health & Compliance
Key Question: "Is this data trustworthy?"

Interactive Case Study: The "Subscription Churn" Crisis

A streaming platform sees a 15% increase in cancellations in Europe. Click the roles to match them to the correct action.

Step A

System monitors daily active users and flags the 15% drop on a real-time dashboard.

Step B

An analyst runs a T-Test and finds "Sci-Fi" fans are 3x more likely to cancel after a specific show removal.

Step C

Specialist ensures "Churn" is calculated the same in Paris as it is in Berlin to avoid "dirty data" errors.

Step D

Person negotiates a new Sci-Fi licensing contract and adjusts the marketing budget to retain users.