Data Analytics & Business Intelligence · Chapter 1 · ~15 min · Beginner
What is Data Analytics? Finding Answers in Numbers
Learn what data analysts actually do: turning raw tables of numbers into confident business decisions, understanding structured vs unstructured data, and mastering the essential metrics: Mean, Median, and Mode.
- Learn the 4 core questions of business data analytics
- Understand the difference between structured and unstructured data
- Calculate Mean, Median, Mode, and Range with confidence
- Avoid the dangerous Outlier Trap that misleads executives
1The 4 Questions Every Data Analyst Answers
Companies collect millions of data points every single day: credit card swipes, app clicks, product ratings, and warehouse shipments. But data by itself is just noise.
A Data Analyst is a detective: they clean the numbers, find patterns, and answer 4 fundamental business questions:
What Happened?
"Sales in Europe dropped by 14% last month."
Why Did It Happen?
"The checkout page had a bug on Safari browsers."
What Will Happen?
"Fixing the bug will restore $40,000 in monthly sales."
What Should We Do?
"Deploy the mobile fix and add automated Safari tests."
A retail company notices website sales plummeted on Sunday. The analyst discovers that the payment gateway was down for 6 hours. Which type of analytics is this?
2Structured vs. Unstructured Data
Before you can analyze data, you need to understand the format it arrives in:
1. Structured Data (Tables)
Data organized into neat, typed rows and columns (Excel spreadsheets, CSV files, SQL database tables). Easy to search, sort, and aggregate with math.
2. Unstructured Data (Free-Form)
Data with no predefined schema: customer call audio recordings, product reviews, emails, and surveillance videos. Requires AI or text extraction to analyze.
Which of the following is an example of Structured Data?
3The Big Three Metrics: Mean, Median, and Mode
When summarizing a column with thousands of numbers, executives don't want to read 10,000 rows; they want a single summary number:
1. Mean (The Mathematical Average)
Add all numbers together and divide by the count. Formula: Sum / Count.
2. Median (The Middle Value)
Sort the numbers from smallest to largest and pick the exact middle number. Exactly 50% of values are below the median, and 50% are above!
3. Mode (The Most Frequent)
The value that appears most often (e.g. the most popular shoe size sold: Size 9).
What is the Median of this dataset: [10, 15, 20, 25, 90]?
4The Classic Outlier Trap (Why the Average Can Lie)
An outlier is an unusually extreme data point that is drastically higher or lower than the rest of your dataset.
Because the Mean adds every number together, even one single extreme outlier will drag the average skyward!
For example, in a small town of 100 working families making $50,000 each, if a billionaire moves in, the "Average Town Income" jumps to $10,000,000. But the families are still earning $50,000! Reporting the Mean alone would be completely dishonest.
5Hands-On: Test the Outlier Effect Live
Toggle the button below to add an extreme CEO salary to a team of 5 workers and see in real time how the Mean and Median respond:
Live Outlier Simulator: Mean vs. Median
Normal Team (5 Engineers)
Click the button to see how one extreme number distorts the average.
Sample Salaries in Dataset:
$55,000
Accurate summary of typical pay when there are no extreme outliers.
$55,000
Half the employees make less than this number, and half make more.
6Chapter Knowledge Challenge
Test your analytical intuition on real business scenarios before moving to Chapter 2:
A department has 5 employees earning $70k, $75k, $80k, $85k, and $90k. A new executive joins earning $750k. Which metric best describes what a typical worker makes?
Which of the following is classified as Unstructured Data?
7Recap
- Data analysts turn raw numbers into action through Descriptive, Diagnostic, Predictive, and Prescriptive analytics.
- Structured data lives in neat tables and databases; unstructured data includes audio, text, and images.
- The Mean is the sum divided by count; the Median is the middle number; the Mode is the most common.
- Outliers distort the Mean heavily, while the Median remains stable and representative of typical users.
Ready for Chapter 2? Mark this chapter as complete to proceed: